C#连接连接mysql数据库完整实例 数据库完整实例 主要介绍了C#连接mysql数据库的方法,以一个完整实例形式分析了C#操作mysql数据库连接的基本技巧,非常具 有实用价值,需要的朋友可以参考下 本文实例讲述了C#连接mysql数据库的方法。分享给大家供大家参考。具体实现方法如下： using System; using System.Configuration; using MySql.Data.MySqlClient; ///

/// TestDatebase 的摘要说明 ///

public class TestDatebase { public TestDatebase() { // // TODO: 在此处添加构造函数逻辑 // } public static void Main(String[] args) { MySqlConnection mysql = getMySqlCon(); //查询sql String sqlSearch = "select * from student"; //插入sql String sqlInsert = "insert into student values (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); //记得关闭 mysql.Close(); String readLine = Console.ReadLine(); } ///

/// 建立mysql数据库链接 ///

/// 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"].ConnectionString; MySqlConnection mysql = new MySqlConnection(mysqlStr); return mysql; } ///

/// 建立执行命令语句对象 ///

/// /// /// public static MySqlCommand getSqlCommand(String sql,MySqlConnection mysql) { MySqlCommand mySqlCommand = new MySqlCommand(sql, mysql); // MySqlCommand mySqlCommand = new MySqlCommand(sql); // mySqlCommand.Connection = mysql; return mySqlCommand; } ///

/// 查询并获得结果集并遍历 ///

/// public static void getResultset(MySqlCommand mySqlCommand) { MySqlDataReader reader = 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(); } } ///

/// 添加数据 ///

/// public static void getInsert(MySqlCommand mySqlCommand) { try { mySqlCommand.ExecuteNonQuery(); } catch (Exception ex) { String message = ex.Message; Console.WriteLine("插入数据失败了！" + message); } } ///

/// 修改数据 ///

/// public static void getUpdate(MySqlCommand mySqlCommand) { try { mySqlCommand.ExecuteNonQuery(); } catch (Exception ex) { String message = ex.Message; Console.WriteLine("修改数据失败了！" + message); } } ///

/// 删除数据 ///

/// public static void getDel(MySqlCommand mySqlCommand) { try { mySqlCommand.ExecuteNonQuery(); } catch (Exception ex) { String message = ex.Message; Console.WriteLine("删除数据失败了！" + message); } } } 希望本文所述对大家的C#程序设计有所帮助。