能用存储过程的DBHelper类
来源:互联网 发布:爱剪辑无法连接网络 编辑:程序博客网 时间:2024/05/01 12:22
/* *创建人:陈伟 *创建时间:2010-2-9 14:34 *说明:数据库助手类 */using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Data;using System.Data.SqlClient;namespace Book.DAL{ public class DBHelper { private SqlConnection conn = null; private SqlCommand cmd = null; private SqlDataReader sdr = null; public DBHelper() { string connStr = "data Source=.;database=MYBOOKSHOP;uid=sa;pwd=123"; conn = new SqlConnection(connStr); } private SqlConnection GetConn() { if (conn.State == ConnectionState.Closed) { conn.Open(); } return conn; } /// <summary> /// 执行不带参数的增删改SQL语句或存储过程 /// </summary> /// <param name="cmdText">增删改SQL语句或存储过程</param> /// <param name="ct">命令类型</param> /// <returns></returns> public int ExecuteNonQuery(string cmdText, CommandType ct) { int res; try { cmd = new SqlCommand(cmdText, GetConn()); cmd.CommandType = ct; res = cmd.ExecuteNonQuery(); } catch (Exception ex) { throw ex; } finally { if (conn.State == ConnectionState.Open) { conn.Close(); } } return res; } /// <summary> /// 执行带参数的增删改SQL语句或存储过程 /// </summary> /// <param name="cmdText">增删改SQL语句或存储过程</param> /// <param name="ct">命令类型</param> /// <returns>int值</returns> public int ExecuteNonQuery(string cmdText, SqlParameter[] paras, CommandType ct) { int res; using (cmd = new SqlCommand(cmdText, GetConn())) { cmd.CommandType = ct; cmd.Parameters.AddRange(paras); res = cmd.ExecuteNonQuery(); } return res; } /// <summary> /// 执行查询SQL语句或存储过程 /// </summary> /// <param name="cmdText">查询SQL语句或存储过程</param> /// <param name="ct">命令类型</param> /// <returns>Table值</returns> public DataTable ExecuteQuery(string cmdText, CommandType ct) { DataTable dt = new DataTable(); cmd = new SqlCommand(cmdText, GetConn()); cmd.CommandType = ct; using (sdr = cmd.ExecuteReader(CommandBehavior.CloseConnection)) { dt.Load(sdr); } return dt; } /// <summary> /// 执行带参数的查询SQL语句或存储过程 /// </summary> /// <param name="cmdText">查询SQL语句或存储过程</param> /// <param name="paras">参数集合</param> /// <param name="ct">命令类型</param> /// <returns>Table值</returns> public DataTable ExecuteQuery(string cmdText, SqlParameter[] paras, CommandType ct) { DataTable dt = new DataTable(); cmd = new SqlCommand(cmdText, GetConn()); cmd.CommandType = ct; cmd.Parameters.AddRange(paras); using (sdr = cmd.ExecuteReader(CommandBehavior.CloseConnection)) { dt.Load(sdr); } return dt; } /// <summary> /// 执行带参数的Scalar查询 /// </summary> /// <param name="cmdText">查询SQL语句或存储过程</param> /// <param name="paras">参数集合</param> /// <param name="ct">命令类型</param> /// <returns>一个int型值</returns> public int ExecuteCheck(string cmdText, SqlParameter[] paras, CommandType ct) { int result; using (cmd = new SqlCommand(cmdText, GetConn())) { cmd.CommandType = ct; cmd.Parameters.AddRange(paras); result = Convert.ToInt32(cmd.ExecuteScalar()); } return result; } }}
用法
// 判断用户名密码是否正确 public bool CheckUser(string LoginId, string LoginPwd) { bool check = false; string cmdText = "procCheckUser"; SqlParameter[] parm = new SqlParameter[] { new SqlParameter("@LoginId",LoginId), new SqlParameter("@LoginPwd",LoginPwd) }; int one = dh.ExecuteCheck(cmdText, parm, CommandType.StoredProcedure); if (one > 0) { return true; } return check; } //根据图书类型显示该类型所有图书 public DataTable SelectAllByType(int TypeId) { string cmdText = "procSelectAllByType"; SqlParameter[] parm = new SqlParameter[]{ new SqlParameter("@TypeId",TypeId) }; dt = dh.ExecuteQuery(cmdText, parm, CommandType.StoredProcedure); return dt; }
- 能用存储过程的DBHelper类
- 能用存储过程的DBHelper类
- 能用存储过程的DBHelper
- 适用不同数据库的、可执行存储过程的DBHelper类
- 一个很好用的DBHelper类(包括使用SQL语句 存储过程 事务 做相关操作) 入门级
- DBHelper类的编写
- 简单的DBHelper类
- DBHelper类的关闭问题
- ASP.NET 的DBHelper类
- 最实用的DBHelper类
- DBHelper类的使用操作
- asp.net用储存过程名为参数的DBHelper类(增删改查)
- DBHelper类
- DBHelper类
- DBHelper类
- DBHelper类
- DBHelper类
- DbHelper 类
- 进程的虚拟地址空间
- 怎么查看本地主机名 找本地IP地址
- 安装RedHatLinux6时无法进入图形界面的问题
- DBHelper类
- ipconfig
- 能用存储过程的DBHelper类
- .net后置代码中弹出提示框
- window下搭建SVN服务器
- 胃病3
- WdWordDialog.wdDialogContentControlProperties 使用
- .NET使用了UpdatePanel后如何弹出对话框!
- vim出现的问题
- 新浪旧事-log4j资源
- NBA球员版球鞋