简写的通用数据层代码

王朝other·作者佚名  2008-05-31
窄屏简体版  字體: |||超大  

public class SqlHelper

...{

ExecuteNonQuery的两个重载#region ExecuteNonQuery的两个重载

public static int ExecuteNonQuery(string connStr, CommandType commandType, string commStr)

...{

SqlConnection conn = new SqlConnection(connStr);

SqlCommand comm = new SqlCommand(commStr, conn);

comm.CommandType = commandType;

conn.Open();

int rowNum = comm.ExecuteNonQuery();

comm.Dispose();

conn.Close();

return rowNum;

}

public static int ExecuteNonQuery(string connStr, CommandType commandType, string commStr, params SqlParameter[] commandParameters)

...{

SqlConnection conn = new SqlConnection(connStr);

SqlCommand comm = new SqlCommand(commStr, conn);

comm.CommandType = commandType;

for (int i = 0; i < commandParameters.Length; i++)

comm.Parameters.Add(commandParameters[i]);

conn.Open();

int rowNum = comm.ExecuteNonQuery();

comm.Dispose();

conn.Close();

return rowNum;

}

#endregion

ExecuteScalar的两个重载#region ExecuteScalar的两个重载

public static object ExecuteScalar(string connStr, CommandType commandType, string commStr)

...{

SqlConnection conn = new SqlConnection(connStr);

SqlCommand comm = new SqlCommand(commStr, conn);

comm.CommandType = commandType;

conn.Open();

object firstObj = comm.ExecuteScalar();

comm.Dispose();

conn.Close();

return firstObj;

}

public static object ExecuteScalar(string connStr, CommandType commandType, string commStr, params SqlParameter[] commandParameters)

...{

SqlConnection conn = new SqlConnection(connStr);

SqlCommand comm = new SqlCommand(commStr, conn);

comm.CommandType = commandType;

for (int i = 0; i < commandParameters.Length; i++)

comm.Parameters.Add(commandParameters[i]);

conn.Open();

object firstObj = comm.ExecuteScalar();

comm.Dispose();

conn.Close();

return firstObj;

}

#endregion

ExecuteReader的两个重载#region ExecuteReader的两个重载

public static SqlDataReader ExecuteReader(string connStr, CommandType commandType, string commStr)

...{

SqlConnection conn = new SqlConnection(connStr);

SqlCommand comm = new SqlCommand(commStr, conn);

comm.CommandType = commandType;

conn.Open();

SqlDataReader reader = comm.ExecuteReader(CommandBehavior.CloseConnection);

return reader;

}

public static SqlDataReader ExecuteReader(string connStr, CommandType commandType, string commStr, params SqlParameter[] commandParameters)

...{

SqlConnection conn = new SqlConnection(connStr);

SqlCommand comm = new SqlCommand(commStr, conn);

comm.CommandType = commandType;

for (int i = 0; i < commandParameters.Length; i++)

comm.Parameters.Add(commandParameters[i]);

conn.Open();

SqlDataReader reader = comm.ExecuteReader(CommandBehavior.CloseConnection);

return reader;

}

#endregion

SqlDataSetAdapter的两个重载#region SqlDataSetAdapter的两个重载

public static DataSet SqlDataSetAdapter(string connStr, CommandType commandType, string commStr, params SqlParameter[] commandParameters)

...{

SqlConnection conn = new SqlConnection(connStr);

SqlCommand comm = new SqlCommand(commStr, conn);

comm.CommandType = commandType;

for (int i = 0; i < commandParameters.Length; i++)

comm.Parameters.Add(commandParameters[i]);

SqlDataAdapter sda = new SqlDataAdapter(comm);

DataSet ds = new DataSet();

sda.Fill(ds);

return ds;

}

public static DataSet SqlDataSetAdapter(string connStr, CommandType commandType, string commStr)

...{

SqlConnection conn = new SqlConnection(connStr);

SqlCommand comm = new SqlCommand(commStr, conn);

comm.CommandType = commandType;

SqlDataAdapter sda = new SqlDataAdapter(comm);

DataSet ds = new DataSet();

sda.Fill(ds);

return ds;

}

#endregion

}

 
 
 
免责声明:本文为网络用户发布,其观点仅代表作者个人观点,与本站无关,本站仅提供信息存储服务。文中陈述内容未经本站证实,其真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
 
 
© 2005- 王朝網路 版權所有 導航