using System;
using MySQLDriverCS;
using System.Data;
using MySql.Data.MySqlClient;
namespace 实验室信息管理
{
class DBHelper
{
//private static string strCon = "server=localhost;uid=root;pwd=123;database=labmanger;Character Set=utf8";
//private static string strCon = new MySQLConnectionString("localhost", "labmanger", "root", "123").AsString;
private static string DB_CON_STR = "server=localhost;uid=root;pwd=123;database=labmanger;Character Set=utf8";
MySqlConnection conn = new MySqlConnection(DB_CON_STR);
public int ExecuteScalar(string strSql)
{
//MySQLConnection conn = new MySQLConnection(strCon);
try
{
conn.Open();
MySqlCommand cmd = new MySqlCommand(strSql, conn);
return Convert.ToInt32(cmd.ExecuteScalar());
}
finally
{
conn.Close();
}
}
public int ExcecuteNonQuery(string strSql)
{
//MySQLConnection conn = new MySQLConnection(strCon);
try
{
conn.Open();
MySqlCommand cmd = new MySqlCommand(strSql, conn);
return Convert.ToInt32(cmd.ExecuteNonQuery());
}
finally
{
conn.Close();
}
}
public DataSet ds(string strSql)
{
//MySQLConnection conn = new MySQLConnection(strCon);
try
{
conn.Open();
DataSet ds = new DataSet();
MySqlDataAdapter sda = new MySqlDataAdapter(strSql, conn);
sda.Fill(ds);
return ds;
}
finally
{
conn.Close();
}
}
}
}
using MySQLDriverCS;
using System.Data;
using MySql.Data.MySqlClient;
namespace 实验室信息管理
{
class DBHelper
{
//private static string strCon = "server=localhost;uid=root;pwd=123;database=labmanger;Character Set=utf8";
//private static string strCon = new MySQLConnectionString("localhost", "labmanger", "root", "123").AsString;
private static string DB_CON_STR = "server=localhost;uid=root;pwd=123;database=labmanger;Character Set=utf8";
MySqlConnection conn = new MySqlConnection(DB_CON_STR);
public int ExecuteScalar(string strSql)
{
//MySQLConnection conn = new MySQLConnection(strCon);
try
{
conn.Open();
MySqlCommand cmd = new MySqlCommand(strSql, conn);
return Convert.ToInt32(cmd.ExecuteScalar());
}
finally
{
conn.Close();
}
}
public int ExcecuteNonQuery(string strSql)
{
//MySQLConnection conn = new MySQLConnection(strCon);
try
{
conn.Open();
MySqlCommand cmd = new MySqlCommand(strSql, conn);
return Convert.ToInt32(cmd.ExecuteNonQuery());
}
finally
{
conn.Close();
}
}
public DataSet ds(string strSql)
{
//MySQLConnection conn = new MySQLConnection(strCon);
try
{
conn.Open();
DataSet ds = new DataSet();
MySqlDataAdapter sda = new MySqlDataAdapter(strSql, conn);
sda.Fill(ds);
return ds;
}
finally
{
conn.Close();
}
}
}
}