怎么用C#与sql做一个翻译程序

Question

1、在C#录入单词自动保存到sql

2、在C#中可调用sql中的词库进行翻译

3、在C#中可修改或删除sql中的词汇

Answer 1

【以下回答由 chatGPT 生成】
回复不易，麻烦关注下博主，谢谢！！！

录入单词并自动保存到SQL数据库

using System;
using System.Data.SqlClient;

class Program
{
    static void Main()
    {
        // 连接数据库
        string connectionString = "Data Source=YourServerName;Initial Catalog=YourDatabaseName;Integrated Security=True";
        SqlConnection connection = new SqlConnection(connectionString);

        try
        {
            // 打开数据库连接
            connection.Open();

            // 接收用户输入的单词和翻译
            Console.Write("请输入单词：");
            string word = Console.ReadLine();
            Console.Write("请输入翻译：");
            string translation = Console.ReadLine();

            // 插入数据到数据库
            string insertQuery = $"INSERT INTO Words (Word, Translation) VALUES ('{word}', '{translation}')";
            SqlCommand command = new SqlCommand(insertQuery, connection);
            command.ExecuteNonQuery();

            Console.WriteLine("单词已成功录入并保存到数据库。");
        }
        catch (Exception ex)
        {
            Console.WriteLine("发生错误：" + ex.Message);
        }
        finally
        {
            // 关闭数据库连接
            connection.Close();
        }
    }
}

1.调用SQL中的词库进行翻译

using System;
using System.Data.SqlClient;

class Program
{
    static void Main()
    {
        // 连接数据库
        string connectionString = "Data Source=YourServerName;Initial Catalog=YourDatabaseName;Integrated Security=True";
        SqlConnection connection = new SqlConnection(connectionString);

        try
        {
            // 打开数据库连接
            connection.Open();

            // 接收用户输入的要翻译的单词
            Console.Write("请输入要翻译的单词：");
            string wordToTranslate = Console.ReadLine();

            // 查询数据库获取翻译
            string selectQuery = $"SELECT Translation FROM Words WHERE Word = '{wordToTranslate}'";
            SqlCommand command = new SqlCommand(selectQuery, connection);
            string translation = command.ExecuteScalar()?.ToString();

            if (!string.IsNullOrEmpty(translation))
            {
                Console.WriteLine($"翻译结果：{translation}");
            }
            else
            {
                Console.WriteLine("未找到对应的翻译。");
            }
        }
        catch (Exception ex)
        {
            Console.WriteLine("发生错误：" + ex.Message);
        }
        finally
        {
            // 关闭数据库连接
            connection.Close();
        }
    }
}

修改或删除SQL中的词汇

using System;
using System.Data.SqlClient;

class Program
{
    static void Main()
    {
        // 连接数据库
        string connectionString = "Data Source=YourServerName;Initial Catalog=YourDatabaseName;Integrated Security=True";
        SqlConnection connection = new SqlConnection(connectionString);

        try
        {
            // 打开数据库连接
            connection.Open();

            // 修改单词或翻译
            string updateQuery = "UPDATE Words SET Translation = @NewTranslation WHERE Word = @WordToUpdate";
            SqlCommand updateCommand = new SqlCommand(updateQuery, connection);
            updateCommand.Parameters.AddWithValue("@NewTranslation", "New Translation");
            updateCommand.Parameters.AddWithValue("@WordToUpdate", "Word to Update");
            int rowsAffected = updateCommand.ExecuteNonQuery();

            if (rowsAffected > 0)
            {
                Console.WriteLine("单词或翻译已成功修改。");
            }
            else
            {
                Console.WriteLine("未找到要修改的单词或翻译。");
            }

            // 删除单词
            string deleteQuery = "DELETE FROM Words WHERE Word = @WordToDelete";
            SqlCommand deleteCommand = new SqlCommand(deleteQuery, connection);
            deleteCommand.Parameters.AddWithValue("@WordToDelete", "Word to Delete");
            rowsAffected = deleteCommand.ExecuteNonQuery();

            if (rowsAffected > 0)
            {
                Console.WriteLine("单词已成功删除。");
            }
            else
            {
                Console.WriteLine("未找到要删除的单词。");
            }
        }
        catch (Exception ex)
        {
            Console.WriteLine("发生错误：" + ex.Message);
        }
        finally
        {
            // 关闭数据库连接
            connection.Close();
        }
    }
}