C连接mysql实例分析和总结.docxVIP

C#连接 mysql 实例 using System;using System.Configuration;using MySql.Data.MySqlClient;/// summary using System; using System.Configuration; using MySql.Data.MySqlClient; /// summary /// TestDatebase 的摘要说明 /// /summary public class TestDatebase { public TestDatebase(){//// TODO: 在此处添加构造函数逻辑//}public static void Main(String[] args){ public TestDatebase() { // // TODO: 在此处添加构造函数逻辑 // } public static void Main(String[] args) { MySqlConnection mysql = getMySqlCon(); //查询 sql String sqlSearch = select * from student; //插入 sql String sqlInsert = String sqlInsert = insert into student values (12, 张三,25,大专);//修改 sqlString sqlUpdate = update student set name=李四where id= 3;//删除 sqlString sqlDel = delete from student where id = 12;//打印 张三,25,大专); //修改 sql String sqlUpdate = update student set name=李四 where id= 3; //删除 sql String sqlDel = delete from student where id = 12; //打印 SQL 语句 Console.WriteLine(sqlDel); //四种语句对象 //MySqlCommand mySqlCommand = getSqlCommand(sqlSearch, mysql); //MySqlCommand mySqlCommand = getSqlCommand(sqlInsert, mysql); //MySqlCommand mySqlCommand = getSqlCommand(sqlUpdate, mysql); MySqlCommand mySqlCommand = getSqlCommand(sqlDel, mysql); mysql.Open(); //getResultset(mySqlCommand); //getInsert(mySqlCommand); //getUpdate(mySqlCommand); getDel(mySqlCommand); getDel(mySqlCommand); //记得关闭mysql.Close();String readLine = Console.ReadLine();}/// summary/// 建立 mysql 数据库链接/// /summary/// returns/returnspublic static MySqlConnection getMySqlCon(){String mysqlStr = Database=test;DataSource=127.0.0.1;User //记得关闭 mysql.Close(); String readLine = Console.ReadLine(); } /// summary /// 建立 mysql 数据库链接 /// /summary /// returns/returns public static MySqlConnection getMySqlCon() { String mysqlStr = Database=test;Data Source=127.0.0.1;User Id=root;Password=root;pooling=false;CharSet=utf8;port=3306 ; // String mySqlCon = ConfigurationManager.ConnectionStrings[MySqlCon].Connect ionString; MySqlConnection mysql = new MySqlConnection(mysqlStr); return mysql; } /// summary /// sum