定义的公共类:
public static SqlConnection getConnection() {
SqlConnection myCon;
try
{
string strSqlCon = @"Server=DAJI;Integrated Security=True;database=QYZLGL";
//SqlConnection类用来连接数据库
myCon = new SqlConnection(strSqlCon);
}
catch (Exception e)
{
throw e;
}
return myCon;
}
/// <summary>
/// 执行SqlCommand命令
/// </summary>
/// <param name="strSqlCommand">SQL语句</param>
public static void getCommand(string strSqlCommand) {
SqlConnection sqlcon = getConnection();
try
{
//SqlConnection类的Open()方法用来打开数据库连接
sqlcon.Open();
//声明将对数据库执行一个SQL语句或存储过程
SqlCommand sqlcom = new SqlCommand(strSqlCommand, sqlcon);
//执行SqlCommand命令
sqlcom.ExecuteNonQuery();
}
catch (Exception e)
{
throw e;
}
finally
{
//关闭数据库连接
sqlcon.Close();
//sqlcon.Dispose();
}
}
/// <summary>
/// 创建一个DataSet对象
/// </summary>
/// <param name="strSqlCommand">SQL语句</param>
/// <param name="strTable">表名</param>
/// <returns>返回DataSet对象</returns>
public static DataSet getDataSet(string strSqlCommand, string strTable) {
SqlConnection sqlcon = getConnection();
DataSet myds;
try
{
sqlcon.Open();
//用于填充DataSet和更新数据库的一组数据命令和一个数据库连接
SqlDataAdapter sqlda = new SqlDataAdapter(strSqlCommand, sqlcon);
//DataSet是数据的内存驻留表示形式,他表示一个数据集
myds = new DataSet();
//填充DataSet数据集
sqlda.Fill(myds, strTable);
}
catch (Exception e)
{
throw e;
}
finally
{
sqlcon.Close();
//sqlcon.Dispose();
}
return myds;
}
/// <summary>
/// 创建一个SqlDataReader对象
/// </summary>
/// <param name="strSqlCommand">SQL语句</param>
/// <returns>返回SqlDataReader对象</returns>
public static SqlDataReader getRead(string strSqlCommand) {
SqlConnection sqlcon = getConnection();
SqlDataReader sqlread;
try
{
sqlcon.Open();
//实例化一个SqlCommand对象
SqlCommand sqlcom = new SqlCommand(strSqlCommand, sqlcon);
//ExecuteReader创建SqlDataReader类对象,CommandBehavior .
//CloseConnection说明在关闭SqlDataReader对象的时候,关闭其关联的SqlConnection对象
sqlread = sqlcom.ExecuteReader(CommandBehavior.CloseConnection);
}
catch (Exception e)
{
throw e;
}
return sqlread;
}
public static SqlConnection getConnection() {
SqlConnection myCon;
try
{
string strSqlCon = @"Server=DAJI;Integrated Security=True;database=QYZLGL";
//SqlConnection类用来连接数据库
myCon = new SqlConnection(strSqlCon);
}
catch (Exception e)
{
throw e;
}
return myCon;
}
/// <summary>
/// 执行SqlCommand命令
/// </summary>
/// <param name="strSqlCommand">SQL语句</param>
public static void getCommand(string strSqlCommand) {
SqlConnection sqlcon = getConnection();
try
{
//SqlConnection类的Open()方法用来打开数据库连接
sqlcon.Open();
//声明将对数据库执行一个SQL语句或存储过程
SqlCommand sqlcom = new SqlCommand(strSqlCommand, sqlcon);
//执行SqlCommand命令
sqlcom.ExecuteNonQuery();
}
catch (Exception e)
{
throw e;
}
finally
{
//关闭数据库连接
sqlcon.Close();
//sqlcon.Dispose();
}
}
/// <summary>
/// 创建一个DataSet对象
/// </summary>
/// <param name="strSqlCommand">SQL语句</param>
/// <param name="strTable">表名</param>
/// <returns>返回DataSet对象</returns>
public static DataSet getDataSet(string strSqlCommand, string strTable) {
SqlConnection sqlcon = getConnection();
DataSet myds;
try
{
sqlcon.Open();
//用于填充DataSet和更新数据库的一组数据命令和一个数据库连接
SqlDataAdapter sqlda = new SqlDataAdapter(strSqlCommand, sqlcon);
//DataSet是数据的内存驻留表示形式,他表示一个数据集
myds = new DataSet();
//填充DataSet数据集
sqlda.Fill(myds, strTable);
}
catch (Exception e)
{
throw e;
}
finally
{
sqlcon.Close();
//sqlcon.Dispose();
}
return myds;
}
/// <summary>
/// 创建一个SqlDataReader对象
/// </summary>
/// <param name="strSqlCommand">SQL语句</param>
/// <returns>返回SqlDataReader对象</returns>
public static SqlDataReader getRead(string strSqlCommand) {
SqlConnection sqlcon = getConnection();
SqlDataReader sqlread;
try
{
sqlcon.Open();
//实例化一个SqlCommand对象
SqlCommand sqlcom = new SqlCommand(strSqlCommand, sqlcon);
//ExecuteReader创建SqlDataReader类对象,CommandBehavior .
//CloseConnection说明在关闭SqlDataReader对象的时候,关闭其关联的SqlConnection对象
sqlread = sqlcom.ExecuteReader(CommandBehavior.CloseConnection);
}
catch (Exception e)
{
throw e;
}
return sqlread;
}