DBHelper
来源:互联网 发布:域名怎么防腾讯拦截 编辑:程序博客网 时间:2024/05/02 18:33
/// <summary>
/// 根据sql 返回受影响的行数(增删改)
/// </summary>
/// <param name="sql"></param>
/// <returns></returns>
public static int ExecuteSql(string sql)
{
int rs = 0;
using (SqlConnection conn = new SqlConnection(connString))
{
conn.Open();
try
{
SqlCommand cmd = new SqlCommand(sql, conn);
rs = cmd.ExecuteNonQuery();
return rs;
}
catch (Exception ex)
{
throw new Exception(ex.Message.ToString());
}
}
}
/// <summary>
/// 根据sql语句和参数执行sql
/// </summary>
/// <param name="sql"></param>
/// <param name="parmas"></param>
/// <returns></returns>
public static int ExecuteSql(string sql, SqlParameter[] param)
{
try
{
using (SqlConnection conn = new SqlConnection(connString))
{
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.Add(param);
return cmd.ExecuteNonQuery();
}
}
catch (Exception ex)
{
throw new Exception(ex.Message.ToString());
}
}
/// <summary>
/// 根据sql 返回datatable
/// </summary>
/// <param name="sql"></param>
/// <returns></returns>
public static DataTable QueryBySql(string sql)
{
try
{
using (SqlConnection conn = new SqlConnection(connString))
{
DataSet ds = new DataSet();
SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataAdapter adp = new SqlDataAdapter(cmd);
adp.Fill(ds);
return ds.Tables[0];
}
}
catch (Exception ex)
{
throw new Exception(ex.Message.ToString());
}
}
/// <summary>
/// 根据sql 返回datatable
/// </summary>
/// <param name="sql"></param>
/// <param name="param"></param>
/// <returns></returns>
public static DataTable QueryBySql(string sql, SqlParameter[] param)
{
try
{
using (SqlConnection conn = new SqlConnection(connString))
{
DataSet ds = new DataSet();
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.Add(param);
SqlDataAdapter adp = new SqlDataAdapter(cmd);
adp.Fill(ds);
return ds.Tables[0];
}
}
catch (Exception ex)
{
throw new Exception(ex.Message.ToString());
}
}
/// <summary>
/// 根据sql语句返回查询结果的首行首列
/// </summary>
/// <param name="sql"></param>
/// <returns></returns>
public static object ExecuteScalar(string sql)
{
using (SqlConnection conn = new SqlConnection(connString))
{
conn.Open();
try
{
SqlCommand cmd = new SqlCommand(sql, conn);
return cmd.ExecuteScalar();
}
catch (Exception ex)
{
throw new Exception(ex.Message.ToString());
}
}
}
/// <summary>
/// 根据sql语句返回查询结果的首行首列
/// </summary>
/// <param name="sql"></param>
/// <returns></returns>
public static object ExecuteScalar(string sql, SqlParameter[] param)
{
using (SqlConnection conn = new SqlConnection(connString))
{
conn.Open();
try
{
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.Add(param);
return cmd.ExecuteScalar();
}
catch (Exception ex)
{
throw new Exception(ex.Message.ToString());
}
}
}
/// <summary>
/// 返回datareader
/// </summary>
/// <param name="sql"></param>
/// <param name="param"></param>
/// <returns></returns>
public static SqlDataReader ExecuteReader(string sql)
{
try
{
using (SqlConnection conn = new SqlConnection(connString))
{
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
return cmd.ExecuteReader(CommandBehavior.CloseConnection);
}
}
catch (Exception ex)
{
throw new Exception(ex.Message.ToString());
}
}
/// <summary>
/// 返回datareader
/// </summary>
/// <param name="sql"></param>
/// <param name="param"></param>
/// <returns></returns>
public static SqlDataReader ExecuteReader(string sql, SqlParameter[] param)
{
try
{
using (SqlConnection conn = new SqlConnection(connString))
{
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.Add(param);
return cmd.ExecuteReader(CommandBehavior.CloseConnection);
}
}
catch (Exception ex)
{
throw new Exception(ex.Message.ToString());
}
}
- DBHelper
- DBHelper
- DBHelper
- dbhelper
- DBHelper
- dbhelper
- DBHelper
- DBHelper
- DBHelper
- DBHelper
- DBHelper
- DBHelper
- DBHelper
- Dbhelper
- DBHelper
- DBHelper
- DBhelper
- DBHelper
- func
- 10个步骤让你成为高效的Web开发者
- C# 右键转到定义 后出现文件名.cs [从元数据] 无法转到定义 而转到元数据 -》解决方法
- Date formatting Using CL_ABAP_DATFM
- 数组与指针的异同
- DBHelper
- 介绍一个 C/C++ 、C#、JAVA 代码美化工具
- 程序从weblogic迁移到tomcat时的注意事项
- linux 进程 和僵尸进程 生动说明
- 一个好的博客有点意思
- Java泛型
- 纯jsp开发者应注意
- 时空漩涡出现!
- ExtJs_Ext.TabPanel解释