请高手帮忙添加注释!
using System;
using System.Data.SqlClient;
using System.Data;
using System.Configuration;namespace kms.Models
{
public class DbHelper
{
private static SqlConnection conn; private static DbHelper instance; DbHelper()
{
if (conn == null)
{
string connstr = ConfigurationManager.ConnectionStrings["SqlConnection"].ConnectionString;
conn = new SqlConnection(connstr);
if (conn.State == ConnectionState.Closed)
conn.Open();
if (conn.State == ConnectionState.Broken)
{
conn.Close();
conn.Open();
}
}
} public static DbHelper getInstance(){
if (instance == null)
{
instance = new DbHelper();
}
return instance;
} public void close()
{
if (conn.State == ConnectionState.Open || conn.State == ConnectionState.Broken)
{
conn.Close();
}
}
public int excuteQuery(string sqlstr,SqlParameter[] parmsArray)
{
SqlCommand cmd = new SqlCommand(sqlstr,conn);
if (parmsArray != null)
{
foreach (SqlParameter sp in parmsArray)
{
cmd.Parameters.Add(sp);
}
}
return cmd.ExecuteNonQuery();
}
public object excuteScalar(string sqlstr, SqlParameter[] parmsArray)
{
SqlCommand cmd = new SqlCommand(sqlstr, conn);
if (parmsArray != null)
{
foreach (SqlParameter sp in parmsArray)
{
cmd.Parameters.Add(sp);
}
}
return cmd.ExecuteScalar();
} public SqlDataReader getReader(string sqlstr, SqlParameter[] parmsArray)
{
SqlCommand cmd = new SqlCommand(sqlstr, conn);
if (parmsArray != null)
{
foreach (SqlParameter sp in parmsArray)
{
cmd.Parameters.Add(sp);
}
}
return cmd.ExecuteReader();
} ~DbHelper()
{
if (conn.State == ConnectionState.Open || conn.State == ConnectionState.Broken)
{
conn.Close();
} }
}
}
using System;
using System.Data.SqlClient;
using System.Data;
using System.Configuration;namespace kms.Models
{
public class DbHelper
{
private static SqlConnection conn; private static DbHelper instance; DbHelper()
{
if (conn == null)
{
string connstr = ConfigurationManager.ConnectionStrings["SqlConnection"].ConnectionString;
conn = new SqlConnection(connstr);
if (conn.State == ConnectionState.Closed)
conn.Open();
if (conn.State == ConnectionState.Broken)
{
conn.Close();
conn.Open();
}
}
} public static DbHelper getInstance(){
if (instance == null)
{
instance = new DbHelper();
}
return instance;
} public void close()
{
if (conn.State == ConnectionState.Open || conn.State == ConnectionState.Broken)
{
conn.Close();
}
}
public int excuteQuery(string sqlstr,SqlParameter[] parmsArray)
{
SqlCommand cmd = new SqlCommand(sqlstr,conn);
if (parmsArray != null)
{
foreach (SqlParameter sp in parmsArray)
{
cmd.Parameters.Add(sp);
}
}
return cmd.ExecuteNonQuery();
}
public object excuteScalar(string sqlstr, SqlParameter[] parmsArray)
{
SqlCommand cmd = new SqlCommand(sqlstr, conn);
if (parmsArray != null)
{
foreach (SqlParameter sp in parmsArray)
{
cmd.Parameters.Add(sp);
}
}
return cmd.ExecuteScalar();
} public SqlDataReader getReader(string sqlstr, SqlParameter[] parmsArray)
{
SqlCommand cmd = new SqlCommand(sqlstr, conn);
if (parmsArray != null)
{
foreach (SqlParameter sp in parmsArray)
{
cmd.Parameters.Add(sp);
}
}
return cmd.ExecuteReader();
} ~DbHelper()
{
if (conn.State == ConnectionState.Open || conn.State == ConnectionState.Broken)
{
conn.Close();
} }
}
}
解决方案 »
- 导出Word
- 异步上传的关闭流操作疑问(很难)
- C# 如何捕网页获弹出的对话框!!!!!!!!!!
- C# string.lengh 截得的长度和数据库长度不一致,该怎么处理。。。。。
- 高分求教:DEVEXPRESS 组件ClickOnce方式发布,客户端报错:“应用程序即将关闭”无法启动,如何解决?
- 关于跨越线程更新UI的问题,在线等!!急,高手帮帮我啊
- DataViewRowState的含义
- 请教高手
- 外网IP无法远程连接到SQL2005,好像就是IP地址的配置问题
- 如何使winform的高度大於612
- C#根据XML数据加载枚举问题
- 最近在学习C#有好多知识都不了解,请各路高手帮忙指点(FeatureModel.cs)
using System.Data.SqlClient;
using System.Data;引入命名空间
using System.Configuration;namespace kms.Models
{
public class DbHelper定义类
{
private static SqlConnection conn;定义成员 private static DbHelper instance;定义成员 DbHelper()定义构造函数
{
if (conn == null)
{
string connstr = ConfigurationManager.ConnectionStrings["SqlConnection"].ConnectionString;
conn = new SqlConnection(connstr);初始化连接
if (conn.State == ConnectionState.Closed)
conn.Open();打开连接
if (conn.State == ConnectionState.Broken)
{
conn.Close();
conn.Open();打开连接
}
}
} public static DbHelper getInstance(){单例模式
if (instance == null)
{
instance = new DbHelper();
}
return instance;
} public void close()定义方法,关闭连接
{
if (conn.State == ConnectionState.Open || conn.State == ConnectionState.Broken)
{
conn.Close();
}
}
public int excuteQuery(string sqlstr,SqlParameter[] parmsArray)定义方法,执行SQL语句
{
SqlCommand cmd = new SqlCommand(sqlstr,conn);
if (parmsArray != null)
{
foreach (SqlParameter sp in parmsArray)
{
cmd.Parameters.Add(sp);SQL添加参数
}
}
return cmd.ExecuteNonQuery();
}
public object excuteScalar(string sqlstr, SqlParameter[] parmsArray)
{
SqlCommand cmd = new SqlCommand(sqlstr, conn);
if (parmsArray != null)
{
foreach (SqlParameter sp in parmsArray)
{
cmd.Parameters.Add(sp);
}
}
return cmd.ExecuteScalar();
} public SqlDataReader getReader(string sqlstr, SqlParameter[] parmsArray)
{
SqlCommand cmd = new SqlCommand(sqlstr, conn);
if (parmsArray != null)
{
foreach (SqlParameter sp in parmsArray)
{
cmd.Parameters.Add(sp);
}
}
return cmd.ExecuteReader();
} ~DbHelper()析构函数
{
if (conn.State == ConnectionState.Open || conn.State == ConnectionState.Broken)
{
conn.Close();
} }
}
}