namespace GoodsManagement
{
public class DBHelper
{
//定义连接字符串
public static string connStr = "";
//定义Connection对象
public static SqlConnection conn = null;
/// <summary>
/// 获取连接对象
/// </summary>
public static void GetConnection()
{
if (conn == null)
{
conn = new SqlConnection(connStr);
}
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
}
//查询
public static DataTable GetDataTable(string sql)
{
GetConnection();
//创建DataAdapter
SqlDataAdapter sda = new SqlDataAdapter(sql,conn);
//创建DataSet
//DataSet ds = new DataSet("Goods");
DataTable dt = new DataTable();
//填充数据集
sda.Fill(dt);
return dt;
}
//增改删
public static bool ExecuteNonQuery(string sql)
{
GetConnection();
SqlCommand cmd = new SqlCommand(sql, conn);
int result = cmd.ExecuteNonQuery();
conn.Close();
return result > 0;
}
}
}