//引入命名空间
using System.Data;
using System.Data.SqlClient;
using System.Data.SqlClient;
namespace DBHelper
{
public class DBHelper
{
//创建数据库通道地址
static string connectionStr = "server=.;database=Test;uid=sa;pwd=123456";
//实例化数据库通道对象
static SqlConnection con = new SqlConnection(connectionStr);
/// <summary>
/// 打开数据库通道的方法
/// </summary>
public static void Open()
{
if (con.State==ConnectionState.Closed)
{
con.Open();
}
}
/// <summary>
/// 关闭数据库通道的方法
/// </summary>
public static void Close()
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
/// <summary>
/// 增删改通用执行数据库命令的方法
/// </summary>
/// <param name="sql"></param>
/// <returns></returns>
public static bool Excute(string sql)
{
try
{
//打开通道
Open();
//创建执行命令的对象
SqlCommand com = new SqlCommand(sql, con);
//执行命令返回结果
if (com.ExecuteNonQuery() > 0)
{
return true;
}
}
catch (Exception)
{
{
public class DBHelper
{
//创建数据库通道地址
static string connectionStr = "server=.;database=Test;uid=sa;pwd=123456";
//实例化数据库通道对象
static SqlConnection con = new SqlConnection(connectionStr);
/// <summary>
/// 打开数据库通道的方法
/// </summary>
public static void Open()
{
if (con.State==ConnectionState.Closed)
{
con.Open();
}
}
/// <summary>
/// 关闭数据库通道的方法
/// </summary>
public static void Close()
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
/// <summary>
/// 增删改通用执行数据库命令的方法
/// </summary>
/// <param name="sql"></param>
/// <returns></returns>
public static bool Excute(string sql)
{
try
{
//打开通道
Open();
//创建执行命令的对象
SqlCommand com = new SqlCommand(sql, con);
//执行命令返回结果
if (com.ExecuteNonQuery() > 0)
{
return true;
}
}
catch (Exception)
{
Console.WriteLine("数据库操作异常");
}
finally
{
Close();
}
finally
{
Close();
}
return false;
}
/// <summary>
/// 执行数据库命令后返回一行一列值得通用方法
/// </summary>
/// <param name="sql"></param>
/// <returns></returns>
public static object GetScaler(string sql) {
object result =null;
try
{
Open();
SqlCommand com = new SqlCommand(sql, con);
result = com.ExecuteScalar();
}
catch (Exception)
{
return false;
}
/// <summary>
/// 执行数据库命令后返回一行一列值得通用方法
/// </summary>
/// <param name="sql"></param>
/// <returns></returns>
public static object GetScaler(string sql) {
object result =null;
try
{
Open();
SqlCommand com = new SqlCommand(sql, con);
result = com.ExecuteScalar();
}
catch (Exception)
{
Console.WriteLine("数据量访问异常");
}
finally
{
Close();
}
return result;
}
/// <summary>
/// 通过SqlDataReader去获取数据库的数据
/// </summary>
/// <param name="sql"></param>
/// <returns></returns>
public static SqlDataReader GetDataReader(string sql) {
SqlDataReader dataReader = null;
try
{
Open();
SqlCommand com = new SqlCommand(sql, con);
dataReader = com.ExecuteReader();
}
catch (Exception)
{
}
finally
{
Close();
}
return result;
}
/// <summary>
/// 通过SqlDataReader去获取数据库的数据
/// </summary>
/// <param name="sql"></param>
/// <returns></returns>
public static SqlDataReader GetDataReader(string sql) {
SqlDataReader dataReader = null;
try
{
Open();
SqlCommand com = new SqlCommand(sql, con);
dataReader = com.ExecuteReader();
}
catch (Exception)
{
Console.WriteLine("数据量访问异常");
}
return dataReader;
}
/// <summary>
/// 根据SqlDataAdaper获取数据存放到DataSet数据集中
/// </summary>
/// <param name="sql">数据库命令</param>
/// <returns>DataSet数据集</returns>
public static DataSet GetDataSet(string sql) {
//实例化一个数据集
DataSet ds = new DataSet();
}
return dataReader;
}
/// <summary>
/// 根据SqlDataAdaper获取数据存放到DataSet数据集中
/// </summary>
/// <param name="sql">数据库命令</param>
/// <returns>DataSet数据集</returns>
public static DataSet GetDataSet(string sql) {
//实例化一个数据集
DataSet ds = new DataSet();
//实例化一个数据适配器
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(sql, con);
//将适配器拿到数据填充到数据集中
sqlDataAdapter.Fill(ds);
return ds;
}
}
}
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(sql, con);
//将适配器拿到数据填充到数据集中
sqlDataAdapter.Fill(ds);
return ds;
}
}
}