手写一个SqlHelper
来源:互联网 发布:新疆网络屏蔽 编辑:程序博客网 时间:2024/06/05 15:41
public static class SqlHelper
{
public static string connstr = ConfigurationManager.ConnectionStrings["connstr"].ConnectionString;
public static int ExecuteNonQuery(string cmdText)
{
using (SqlConnection conn = new SqlConnection(connstr))
{
using (SqlCommand cmd = new SqlCommand(cmdText, conn))
{
conn.Open();
return cmd.ExecuteNonQuery();
}
}
}
public static int ExecuteNonQuery(string cmdText, CommandType cmdType, SqlParameter[] cmdParms)
{
using (SqlConnection conn = new SqlConnection(connstr))
{
using (SqlCommand cmd = new SqlCommand(cmdText, conn))
{
if (cmdParms != null)
cmd.Parameters.AddRange(cmdParms);
cmd.CommandType = cmdType;
conn.Open();
return cmd.ExecuteNonQuery();
}
}
}
public static int ExecuteNonQuery(SqlCommand cmd, CommandType cmdType)
{
using (SqlConnection conn = new SqlConnection(connstr))
{
cmd.CommandType = cmdType;
cmd.Connection = conn;
conn.Open();
return cmd.ExecuteNonQuery();
}
}
public static object ExecuteScalar(string cmdText)
{
using (SqlConnection conn = new SqlConnection(connstr))
{
using (SqlCommand cmd = new SqlCommand(cmdText, conn))
{
conn.Open();
return cmd.ExecuteScalar();
}
}
}
public static object ExecuteScalar(string cmdText, CommandType cmdType, SqlParameter[] cmdParms)
{
using (SqlConnection conn = new SqlConnection(connstr))
{
using (SqlCommand cmd = new SqlCommand(cmdText, conn))
{
cmd.CommandType = cmdType;
if (cmdParms != null)
cmd.Parameters.AddRange(cmdParms);
conn.Open();
return cmd.ExecuteScalar();
}
}
}
public static object ExecuteScalar(SqlCommand cmd, CommandType cmdType)
{
using (SqlConnection conn = new SqlConnection(connstr))
{
cmd.CommandType = cmdType;
cmd.Connection = conn;
conn.Open();
return cmd.ExecuteScalar();
}
}
public static SqlDataReader ExecuteReader(string cmdText)
{
SqlConnection conn = new SqlConnection(connstr);
using (SqlCommand cmd = new SqlCommand(cmdText, conn))
{
try
{
conn.Open();
return cmd.ExecuteReader(CommandBehavior.CloseConnection);
}
catch
{//可能会出现异常,没有using,必须手动关闭
conn.Close();
conn.Dispose();
throw;
}
}
}
public static SqlDataReader ExecuteReader(string cmdText, CommandType cmdType, SqlParameter[] cmdParms)
{
SqlConnection conn = new SqlConnection(connstr);
using (SqlCommand cmd = new SqlCommand(cmdText, conn))
{
cmd.CommandType = cmdType;
if (cmdParms != null)
cmd.Parameters.AddRange(cmdParms);
try
{
conn.Open();
return cmd.ExecuteReader(CommandBehavior.CloseConnection);
}
catch
{//可能会出现异常,没有using,必须手动关闭
conn.Close();
conn.Dispose();
throw;
}
}
}
public static SqlDataReader ExecuteReader(SqlCommand cmd, CommandType cmdType)
{
SqlConnection conn = new SqlConnection(connstr);
cmd.CommandType = cmdType;
cmd.Connection = conn;
try
{
conn.Open();
return cmd.ExecuteReader(CommandBehavior.CloseConnection);
}
catch
{
conn.Close();
conn.Dispose();
throw;
}
}
public static DataTable GetDataTable(string cmdText)
{
DataTable set = new DataTable();
using (SqlConnection conn = new SqlConnection(connstr))
{
using (SqlDataAdapter adp = new SqlDataAdapter(cmdText, conn))
{
adp.Fill(set);
return set;
}
}
}
public static DataTable GetDataTable(string cmdText, CommandType cmdType, SqlParameter[] cmdParms)
{
DataTable set = new DataTable();
using (SqlConnection conn = new SqlConnection(connstr))
{
using (SqlDataAdapter adp = new SqlDataAdapter(cmdText, conn))
{
adp.SelectCommand.CommandType = cmdType;
if(cmdParms != null)
adp.SelectCommand.Parameters.AddRange(cmdParms);
adp.Fill(set);
return set;
}
}
}
public static DataTable GetDataTable(SqlCommand cmd, CommandType cmdType)
{
DataTable set = new DataTable();
using (SqlConnection conn = new SqlConnection(connstr))
{
cmd.Connection = conn;
cmd.CommandType = cmdType;
using (SqlDataAdapter adp = new SqlDataAdapter(cmd))
{
adp.Fill(set);
return set;
}
}
}
public static DataSet GetDataSet(string sqlstr)
{
DataSet set = new DataSet();
using (SqlConnection conn = new SqlConnection(connstr))
{
using (SqlDataAdapter adp = new SqlDataAdapter(sqlstr, conn))
{
adp.Fill(set);
return set;
}
}
}
public static DataSet GetDataSet(string sqlstr, string tableName)
{
DataSet set = new DataSet();
using (SqlConnection conn = new SqlConnection(connstr))
{
using (SqlDataAdapter adp = new SqlDataAdapter(sqlstr, conn))
{
adp.Fill(set, tableName);
return set;
}
}
}
public static DataSet GetDataSet(SqlCommand cmd, CommandType cmdType, string tableName)
{
DataSet set = new DataSet();
using (SqlConnection conn = new SqlConnection(connstr))
{
cmd.Connection = conn;
cmd.CommandType = cmdType;
using (SqlDataAdapter adp = new SqlDataAdapter(cmd))
{
adp.Fill(set, tableName);
}
}
return set;
}
}
- 手写一个SqlHelper
- 黑马程序员——手写SQLHelper
- 封装一个SQLHelper
- 写一个SqlHelper类
- C# 一个SqlHelper例子
- SqlHelper.FillDataset 的一个 Bug
- 一个完美的SqlHelper.cs
- 如何手写一个servlet
- 手写一个jsonp
- 自己手写一个springmvc
- 手写一个JSONP
- 手写一个JSONP
- 手写一个bind
- 手写一个手机网页
- 手写一个线程池
- SqlHelper
- SqlHelper
- SqlHelper
- tomcat+websocket实现
- PID2 / 开心的金明
- leetcode 11
- 出题&题解
- ViewPager+Fragment+RadioGroup实现页面联动\点击切换
- 手写一个SqlHelper
- spark sql版本的单词统计代码
- <crtdbg.h> 的作用
- JSESSIONID与SESSION
- 自定义圆形图
- CodeForces 653 A. Bear and Three Balls(数学 ,快排)
- Easy-题目8:242. Valid Anagram
- POJ2488【DFS】
- Eclipse Debug快捷键 和 SVN各个字母含义