在.net项目中经常碰到需要连接mysql数据库的情况,在这里贴出一个项目中用到的mysql连接工具类
1.首先引入mysql连接所需的dll文件,具体下载链接如下
https://pan.baidu.com/s/1XPtHfLFAT26HKlXA4RK8NQ
2.工具类代码如下
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using MySql.Data.MySqlClient;
using System.Data;
using System.Text;
namespace TCalendar.utils
{
public class WebDBServiceMySQL
{
public static string ConnStr = "server=127.0.0.1;port=3306;user id=u;password=u;database=u;charset=utf8";
public static DataTable GetDataTable(string SQL)
{
DataTable ADt = new DataTable();
MySqlConnection AConn = new MySqlConnection(ConnStr);
try
{
MySqlDataAdapter ADp = new MySqlDataAdapter(SQL, AConn);
ADp.Fill(ADt);
}
catch
{
;
}
finally
{
AConn.Close();
AConn.Dispose();
AConn = null;
}
return ADt;
}
public static DataRow GetDataRow(string SQL)
{
DataRow ARow = null;
DataTable ADt = GetDataTable(SQL);
try
{
if (ADt.Rows.Count > 0)
ARow = ADt.Rows[0];
}
finally
{
ADt.Dispose(); ADt = null;
}
return ARow;
}
/// <summary>
/// 执行 Insert Delete Update
/// </summary>
/// <param name="SQL">SQL语句</