public class SqlHelper
{
//sql连接对象
private static SqlConnection conConnection = null;
//数据库命令对象
private static SqlCommand conCommand = null;
public SqlHelper()
{
}
//获取数据库连接字符串
private static string getConnectionString()
{
return System.Configuration.ConfigurationManager.ConnectionStrings["DispatchDB"].ConnectionString;
}
//打开数据库连接
private static void openSqlConnection()
{
try
{
// 如果数据库连接对象状态为关闭
if (conConnection.State == ConnectionState.Closed)
{
// 打开连接
conConnection.Open();
}
}
catch (Exception ex)
{
}
}
//关闭数据库连接
private static void closeSqlConnection()
{
// 如果数据库连接对象不为空
if (conConnection != null)
{
try
{
// 如果数据库连接对象当前状态不
C# DAL层数据库操作类SqlHelper
最新推荐文章于 2020-06-20 12:46:18 发布