代码:classMySqlHelper{privatestaticstringconStr=ConfigurationManager.ConnectionStrings["conListOfOrder"].ConnectionString;privatestaticMySqlConnectionconn;publicstaticMy...
代码:
class MySqlHelper
{
private static string conStr = ConfigurationManager.ConnectionStrings["conListOfOrder"].ConnectionString;
private static MySqlConnection conn;
public static MySqlConnection Conn
{
get
{
//判断连接是否为空或者连接通道已断开
if (conn == null || conn.State == ConnectionState.Broken)
{
//重置连接通道为当前设定
conn = new MySqlConnection(conStr);
}
return conn;
}
}
public static DataTable GetDataTable(string mysqlStr, params MySqlParameter[] paras)
{
MySqlCommand cmd = new MySqlCommand(mysqlStr, Conn);