C#连接mysql数据库完整实例
本文实例讲述了C#连接mysql数据库的方法。分享给大家供大家参考。具体实现方法如下:
usingSystem; usingSystem.Configuration; usingMySql.Data.MySqlClient; ///<summary> ///TestDatebase的摘要说明 ///</summary> publicclassTestDatebase { publicTestDatebase() { // //TODO:在此处添加构造函数逻辑 // } publicstaticvoidMain(String[]args) { MySqlConnectionmysql=getMySqlCon(); //查询sql StringsqlSearch="select*fromstudent"; //插入sql StringsqlInsert="insertintostudentvalues(12,'张三',25,'大专')"; //修改sql StringsqlUpdate="updatestudentsetname='李四'whereid=3"; //删除sql StringsqlDel="deletefromstudentwhereid=12"; //打印SQL语句 Console.WriteLine(sqlDel); //四种语句对象 //MySqlCommandmySqlCommand=getSqlCommand(sqlSearch,mysql); //MySqlCommandmySqlCommand=getSqlCommand(sqlInsert,mysql); //MySqlCommandmySqlCommand=getSqlCommand(sqlUpdate,mysql); MySqlCommandmySqlCommand=getSqlCommand(sqlDel,mysql); mysql.Open(); //getResultset(mySqlCommand); //getInsert(mySqlCommand); //getUpdate(mySqlCommand); getDel(mySqlCommand); //记得关闭 mysql.Close(); StringreadLine=Console.ReadLine(); } ///<summary> ///建立mysql数据库链接 ///</summary> ///<returns></returns> publicstaticMySqlConnectiongetMySqlCon() { StringmysqlStr="Database=test;DataSource=127.0.0.1;UserId=root;Password=root;pooling=false;CharSet=utf8;port=3306"; //StringmySqlCon=ConfigurationManager.ConnectionStrings["MySqlCon"].ConnectionString; MySqlConnectionmysql=newMySqlConnection(mysqlStr); returnmysql; } ///<summary> ///建立执行命令语句对象 ///</summary> ///<paramname="sql"></param> ///<paramname="mysql"></param> ///<returns></returns> publicstaticMySqlCommandgetSqlCommand(Stringsql,MySqlConnectionmysql) { MySqlCommandmySqlCommand=newMySqlCommand(sql,mysql); //MySqlCommandmySqlCommand=newMySqlCommand(sql); //mySqlCommand.Connection=mysql; returnmySqlCommand; } ///<summary> ///查询并获得结果集并遍历 ///</summary> ///<paramname="mySqlCommand"></param> publicstaticvoidgetResultset(MySqlCommandmySqlCommand) { MySqlDataReaderreader=mySqlCommand.ExecuteReader(); try { while(reader.Read()) { if(reader.HasRows) { Console.WriteLine("编号:"+reader.GetInt32(0)+"|姓名:"+reader.GetString(1)+"|年龄:"+reader.GetInt32(2)+"|学历:"+reader.GetString(3)); } } } catch(Exception) { Console.WriteLine("查询失败了!"); } finally { reader.Close(); } } ///<summary> ///添加数据 ///</summary> ///<paramname="mySqlCommand"></param> publicstaticvoidgetInsert(MySqlCommandmySqlCommand) { try { mySqlCommand.ExecuteNonQuery(); } catch(Exceptionex) { Stringmessage=ex.Message; Console.WriteLine("插入数据失败了!"+message); } } ///<summary> ///修改数据 ///</summary> ///<paramname="mySqlCommand"></param> publicstaticvoidgetUpdate(MySqlCommandmySqlCommand) { try { mySqlCommand.ExecuteNonQuery(); } catch(Exceptionex) { Stringmessage=ex.Message; Console.WriteLine("修改数据失败了!"+message); } } ///<summary> ///删除数据 ///</summary> ///<paramname="mySqlCommand"></param> publicstaticvoidgetDel(MySqlCommandmySqlCommand) { try { mySqlCommand.ExecuteNonQuery(); } catch(Exceptionex) { Stringmessage=ex.Message; Console.WriteLine("删除数据失败了!"+message); } } }
希望本文所述对大家的C#程序设计有所帮助。