public class DBHelper
{
/// <summary>
/// 创建数据库连接字符串
/// </summary>
public static string constr = "server=.;database=你的数据库名称;Uid=数据库登录用户名;pwd=数据库登录密码";
/// <summary>
/// 数据库连接对象
/// </summary>
public static SqlConnection conn = null;
/// <summary>
/// 初始化数据库连接
/// </summary>
public static void InitConnection()
{
//如果连接对象不存在,则创建连接
if (conn == null)
{
conn = new SqlConnection(constr);
}
//如果连接对象关闭,则打开连接
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
//如果连接中断,则重启连接
if (conn.State == ConnectionState.Broken)
{
conn.Close();
conn.Open();
}
}
/// <summary>
/// 获得数据表集
/// </summary>
/// <param name="strSQL">SQL语句</param>
/// <returns></returns>
public static DataSet GetDataSet(string strSQL)
{
InitConnection();
//实例化对象
DataSet ds = new DataSet();
SqlDataAdapter dap = new SqlDataAdapter(Sql, Conn);
//填充数据
dap.Fill(ds);
//关闭数据库
Conn.Close();
return ds;
}
/// <summary>
/// 查询,获取DataReader
/// </summary>
/// <param name="sqlstr">SQL语句</param>
/// <returns></returns>
public static SqlDataReader GetDataReader(string sqlstr)
{
InitConnection();
SqlCommand cmd = new SqlCommand(sqlstr, conn);
return cmd.ExecuteReader(CommandBehavior.CloseConnection);
}
/// <summary>
/// 增删改
/// </summary>
/// <param name="sqlstr">SQL语句</param>
/// <returns></returns>
public static bool ExecuteNonQuery(string sqlstr)
{
InitConnection();
SqlCommand cmd = new SqlCommand(sqlstr, conn);
int result = cmd.ExecuteNonQuery();
conn.Close();
return result > 0;
}
/// <summary>
/// 执行集合函数
/// </summary>
/// <param name="sqlstr">SQL语句</param>
/// <returns></returns>
public static object ExecuteScalar(string sqlstr)
{
InitConnection();
SqlCommand cmd = new SqlCommand(sqlstr, conn);
object result = cmd.ExecuteNonQuery();
conn.Close();
return result;
}
}
C#中的DBHelper类
于 2021-02-05 12:08:46 首次发布