c#对数据库进行增删改查

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using MySql.Data.MySqlClient;
using System.Data;

namespace ConsoleApplication1
{
	class MySQL
	{
		string connStr;
		MySqlConnection conn;
		string cmdText;
		MySqlCommand cmd;
		
		public MySQL(string dataBaseName)
		{
			connStr=string.Format(
				"database={0};datasource=localhost;user=root;pwd=******;port=3306;charset=utf8",dataBaseName);
			conn=new MySqlConnection(connStr);
		}	
		
		///需要输入的形参是：想要查询的表名，不固定个数的列名。
		public void Select(string tableName,params string[] columnsName)
		{
			conn.open();
			cmdText=string.Format("SELECT * FROM {0}",tableName);
			cmd=new MySqlCommand(cmdText,conn);
			MySqlDataReader dataReader=cmd.ExecuteReader();
			while(dataReader.Read())
			{
				Console.WriteLine(
					dataReader.GetString(columnsName[0])
					+" "+
					dataReader.GetString(columnsName[1]));
			}
			dataReader.close();
			conn.close();
		}

		///输入表名、ID列和Name列的名称来插入一条数据。
		public void Insert(string tableName,string id,string name)
		{
			conn.open();
			cmdText=string.Format(
				"INSERT INTO {0}(Sno,Sname) VALUES('{1}','{2}')",
				tableName,id,name);
			cmd=new MySqlCommand(cmdText,conn);
			cmd.ExecuteNonQuery();
			conn.close();
		}

		///通过ID来删除表中的一条数据
		public void Delete(string tableName,string id)
		{
			conn.open();
			cmdText=string.Format(
				"DELETE FROM {0} WHERE id='{1}'",
				tableName,id);
			cmd=new MySqlCommand(cmdText,conn);
			cmd.ExecuteNonQuery();
			conn.close();
		}

		///通过ID来修改表中的一条数据的Name值
		public void Update(string tableName,string id,string name)
		{
			conn.open();
			cmdText=string.Format(
				"UPDATE {0} SET Sname='{1}' WHERE Sno='{2}'",
				tableName,name,id);
			cmd=new MySqlCommand(cmdText,conn);
			cmd.ExecuteNonQuery();
			conn.close();
		}

		static void Main(string[] args)
		{
			MySQL mySql=new MySQL("xskc");
			mySql.Select("student","Sno","Sname");
			mySql.Insert("student","1001","张三");
			mySql.Update("student","1001","李四");
			mySql.Delete("student","1001");
			Console.ReadKey();
		}
	}
}