110,499
社区成员
发帖
与我相关
我的任务
分享
class DBClass
{
private static MySQLConnection mySqlConn = null;
private static MySQLCommand mySqlCmd = null;
private static DataTable TBL_sy_group_point = null;
private static DataTable TBL_sy_point = null;
private static DataTable TBL_sy_point_term = null;
private static DataTable TBL_sy_term = null;
/// <summary>
/// 初始化数据库接数对象
/// </summary>
public static void Init_DataBase()
{
string mySqlConnString = "Data Source="+ global::monitor.Properties.Settings.Default.mySqlDBSource +";Password="+ global::monitor.Properties.Settings.Default.mySqlDBPWD +";User ID="+ global::monitor.Properties.Settings.Default.mySqlDBUID +";Location=" + global::monitor.Properties.Settings.Default.mySqlDBLocation;
if (mySqlConn == null)
{
mySqlConn = new MySQLConnection(mySqlConnString);
}
if (mySqlCmd == null)
{
mySqlCmd = new MySQLCommand();
mySqlCmd.Connection = mySqlConn;
mySqlCmd.CommandType = CommandType.Text;
}
if (mySqlConn.State == ConnectionState.Closed)
{
mySqlConn.Open();
mySqlCmd.CommandText = "set names GB2312";
//mySqlCmd.CommandText = "set names UTF8";
mySqlCmd.ExecuteNonQuery();
}
}
/// <summary>
/// 根据指定的SQL,返回此SQL的数据表
/// </summary>
/// <param name="sqlstring"></param>
/// <returns></returns>
public static DataTable GetDataTable(string sqlstring)
{
Init_DataBase();
mySqlCmd.CommandText = sqlstring;
MySQLDataAdapter mysqladp = new MySQLDataAdapter(mySqlCmd);
DataTable dbtab = new DataTable();
mysqladp.Fill(dbtab);
return dbtab;
}
public static MySQLDataReader GetData(string sqlstring)
{
Init_DataBase();
mySqlCmd.CommandText = sqlstring;
return (MySQLDataReader)mySqlCmd.ExecuteReader();
}
/// <summary>
/// 执行一个SQL,返回此SQL所影响的行数
/// </summary>
/// <param name="sql"></param>
/// <returns></returns>
public static int ExecuteSQL(string sql)
{
Init_DataBase();
mySqlCmd.CommandText = sql;
return mySqlCmd.ExecuteNonQuery();
}
/// <summary>
/// 执行一个SQL,返回此SQL所影响的行数(使用ExecuteScalar返回查询结果集的第一行第一列值)
/// </summary>
/// <param name="sql"></param>
/// <returns></returns>
public static object ExecuteScalarSQL(string sql)
{
Init_DataBase();
mySqlCmd.CommandText = sql;
return mySqlCmd.ExecuteScalar();
}
/// <summary>
/// 执行指定的MySQLCommand
/// </summary>
/// <param name="cmd"></param>
/// <returns></returns>
public static int UpdateMySQLCommand(MySQLCommand cmd)
{
Init_DataBase();
cmd.Connection = mySqlConn;
return cmd.ExecuteNonQuery();
}
}
}