ASP.Net2.0 OleDB数据访问模块 (SqlHelper For OleDB)
来源:互联网 发布:random java 编辑:程序博客网 时间:2024/05/18 00:11
- using System;
- using System.Data;
- using System.Data.OleDb;
- namespace SqlHelper
- {
- public abstract class SqlHelper
- {
- public SqlHelper()
- {
- }
- /// <summary>
- /// 用于执行一段SQL语句,只有三个最简的必要参数,省去了commandtype。
- /// To excute a SQL statement, which reuturns a integer stand for effect line number.
- /// default Command type is text
- /// </summary>
- /// <param name="connString">连接字符串 (Conntection String)</param>
- /// <param name="cmdText">command的字符串 (SQL Statement)</param>
- /// <param name="cmdParms">参数列表 (Paramters)</param>
- /// <returns>返回影响行数 (effect line number)</returns>
- public static int ExecuteNonQuery(string connString, string cmdText, params OleDbParameter[] cmdParms)
- {
- OleDbCommand cmd = new OleDbCommand();
- using (OleDbConnection conn = new OleDbConnection(connString))
- {
- PrepareCommand(cmd, conn, null, CommandType.Text, cmdText, cmdParms);
- int val = cmd.ExecuteNonQuery();
- cmd.Parameters.Clear();
- return val;
- }
- }
- /// <summary>
- /// 用于执行一段SQL语句。
- /// To excute a SQL statement, which reuturns a integer stand for effect line number.
- /// </summary>
- /// <param name="connString">连接字符串 (Connection String)</param>
- /// <param name="cmdType">command的字符串 (SQL Statement)</param>
- /// <param name="cmdText">command的类型,具体见:CommandType (Command type)</param>
- /// <param name="cmdParms">参数列表 (Paramters)</param>
- /// <returns>返回影响行数 (effect line number)</returns>
- public static int ExecuteNonQuery(string connString, CommandType cmdType, string cmdText, params OleDbParameter[] cmdParms)
- {
- OleDbCommand cmd = new OleDbCommand();
- using (OleDbConnection conn = new OleDbConnection(connString))
- {
- PrepareCommand(cmd, conn, null, cmdType, cmdText, cmdParms);
- int val = cmd.ExecuteNonQuery();
- cmd.Parameters.Clear();
- return val;
- }
- }
- /// <summary>
- /// 用于执行一段SQL语句。传入的值是connection.
- /// To excute a SQL statement, which reuturns a integer stand for effect line number.
- /// a connection is passed in instead of a connection string
- /// </summary>
- /// <param name="conn">一个以初始化好的OleDbConnection (a Conncection)</param>
- /// <param name="connString">连接字符串 (Conntection String)</param>
- /// <param name="cmdText">command的字符串 (SQL Statement)</param>
- /// <param name="cmdParms">参数列表 (Paramters)</param>
- /// <returns>返回影响行数 (effect line number)</returns>
- public static int ExecuteNonQuery(OleDbConnection conn, CommandType cmdType, string cmdText, params OleDbParameter[] cmdParms)
- {
- OleDbCommand cmd = new OleDbCommand();
- PrepareCommand(cmd, conn, null, cmdType, cmdText, cmdParms);
- int val = cmd.ExecuteNonQuery();
- cmd.Parameters.Clear();
- return val;
- }
- /// <summary>
- /// 用于执行一段SQL语句。需要传入一个事物Transaction.
- /// To excute a SQL statement, which reuturns a integer stand for effect line number.
- /// a transaction is reqired
- /// </summary>
- /// <param name="trans">一个Trasaction (Trasaction)</param>
- /// <param name="cmdType">command的字符串 (SQL Statement)</param>
- /// <param name="cmdText">command的类型,具体见:CommandType (Command type)</param>
- /// <param name="cmdParms">参数列表 (Paramters)</param>
- /// <returns>返回影响行数 (effect line number)</returns>
- public static int ExecuteNonQuery(OleDbTransaction trans, CommandType cmdType, string cmdText, params OleDbParameter[] cmdParms)
- {
- OleDbCommand cmd = new OleDbCommand();
- PrepareCommand(cmd, trans.Connection, trans, cmdType, cmdText, cmdParms);
- int val = cmd.ExecuteNonQuery();
- cmd.Parameters.Clear();
- return val;
- }
- /// <summary>
- /// 用于执行一个Select语句返回一个datareader,省略了commandtype参数
- /// To excute a SQL statement, and reuturns a dataReader.
- /// default command type is text
- /// </summary>
- /// <param name="connString">连接字符串 (Conntection String)</param>
- /// <param name="cmdText">command的字符串 (SQL Statement)</param>
- /// <param name="cmdParms">参数列表 (Paramters)</param>
- /// <returns>datareader</returns>
- public static OleDbDataReader ExecuteReader(string connString, string cmdText, params OleDbParameter[] cmdParms)
- {
- OleDbCommand cmd = new OleDbCommand();
- OleDbConnection conn = new OleDbConnection(connString);
- // we use a try/catch here because if the method throws an exception we want to
- // close the connection throw code, because no datareader will exist, hence the
- // commandBehaviour.CloseConnection will not work
- try
- {
- PrepareCommand(cmd, conn, null, CommandType.Text, cmdText, cmdParms);
- OleDbDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
- // cmd.Parameters.Clear();
- return rdr;
- }
- catch
- {
- conn.Close();
- throw;
- }
- }
- /// <summary>
- /// 用于执行一个Select语句返回一个datareader
- /// To excute a SQL statement, and reuturns a dataReader.
- /// </summary>
- /// <param name="connString">连接字符串 (Connection String)</param>
- /// <param name="cmdType">command的字符串 (SQL Statement)</param>
- /// <param name="cmdText">command的类型,具体见:CommandType (Command type)</param>
- /// <param name="cmdParms">参数列表 (Paramters)</param>
- /// <returns>dataReader</returns>
- public static OleDbDataReader ExecuteReader(string connString, CommandType cmdType, string cmdText, params OleDbParameter[] cmdParms)
- {
- OleDbCommand cmd = new OleDbCommand();
- OleDbConnection conn = new OleDbConnection(connString);
- // we use a try/catch here because if the method throws an exception we want to
- // close the connection throw code, because no datareader will exist, hence the
- // commandBehaviour.CloseConnection will not work
- try
- {
- PrepareCommand(cmd, conn, null, cmdType, cmdText, cmdParms);
- OleDbDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
- // cmd.Parameters.Clear();
- return rdr;
- }
- catch
- {
- conn.Close();
- throw;
- }
- }
- /// <summary>
- /// 用于读取一个值,查询所返回的是结果集中第一行的第一列,省去了commandtype
- /// To excute a SQL statement, and returns the first column of the first line
- /// Default command type is text
- /// </summary>
- /// <param name="connString">连接字符串 (Conntection String)</param>
- /// <param name="cmdText">command的字符串 (SQL Statement)</param>
- /// <param name="cmdParms">参数列表 (Paramters)</param>
- /// <returns>the first column of the first line</returns>
- public static object ExecuteScalar(string connString, string cmdText, params OleDbParameter[] cmdParms)
- {
- OleDbCommand cmd = new OleDbCommand();
- using (OleDbConnection conn = new OleDbConnection(connString))
- {
- PrepareCommand(cmd, conn, null, CommandType.Text, cmdText, cmdParms);
- object val = cmd.ExecuteScalar();
- cmd.Parameters.Clear();
- return val;
- }
- }
- /// <summary>
- /// 用于读取一个值,查询所返回的是结果集中第一行的第一列
- /// To excute a SQL statement, and returns the first column of the first line
- /// </summary>
- /// <param name="connString">连接字符串 (Connection String)</param>
- /// <param name="cmdType">command的字符串 (SQL Statement)</param>
- /// <param name="cmdText">command的类型,具体见:CommandType (Command type)</param>
- /// <param name="cmdParms">参数列表 (Paramters)</param>
- /// <returns>the first column of the first line</returns>
- public static object ExecuteScalar(string connString, CommandType cmdType, string cmdText, params OleDbParameter[] cmdParms)
- {
- OleDbCommand cmd = new OleDbCommand();
- using (OleDbConnection conn = new OleDbConnection(connString))
- {
- PrepareCommand(cmd, conn, null, cmdType, cmdText, cmdParms);
- object val = cmd.ExecuteScalar();
- cmd.Parameters.Clear();
- return val;
- }
- }
- /// <summary>
- /// 用于读取一个值,查询所返回的是结果集中第一行的第一列
- /// To excute a SQL statement, and returns the first column of the first line
- /// a connection is passed in instead of a connection string
- /// </summary>
- /// <param name="conn">一个以初始化好的OleDbConnection (a Conncection)</param>
- /// <param name="connString">连接字符串 (Conntection String)</param>
- /// <param name="cmdText">command的字符串 (SQL Statement)</param>
- /// <param name="cmdParms">参数列表 (Paramters)</param>
- /// <returns>the first column of the first line</returns>
- public static object ExecuteScalar(OleDbConnection conn, CommandType cmdType, string cmdText, params OleDbParameter[] cmdParms)
- {
- OleDbCommand cmd = new OleDbCommand();
- PrepareCommand(cmd, conn, null, cmdType, cmdText, cmdParms);
- object val = cmd.ExecuteScalar();
- cmd.Parameters.Clear();
- return val;
- }
- /// <summary>
- /// 在执行SQL语句之前的准备工作
- /// </summary>
- /// <param name="cmd">command</param>
- /// <param name="conn">connection</param>
- /// <param name="trans">trasaction</param>
- /// <param name="cmdType">command类型</param>
- /// <param name="cmdText">command字符串</param>
- /// <param name="cmdParms">参数列表</param>
- private static void PrepareCommand(OleDbCommand cmd, OleDbConnection conn, OleDbTransaction trans, CommandType cmdType, string cmdText, OleDbParameter[] cmdParms)
- {
- if (conn.State != ConnectionState.Open)
- conn.Open();
- cmd.Connection = conn;
- cmd.CommandText = cmdText;
- if (trans != null)
- cmd.Transaction = trans;
- cmd.CommandType = cmdType;
- if (cmdParms != null)
- {
- foreach (OleDbParameter parm in cmdParms)
- cmd.Parameters.Add(parm);
- }
- }
- }
- }
- ASP.Net2.0 OleDB数据访问模块 (SqlHelper For OleDB)
- ASP.Net2.0 SQL数据访问模块(SqlHelper For MSSQL)
- OLEDB SqlHelper
- OLEDB SqlHelper
- 数据访问类OleDb
- oledb
- OLEDB
- OLEDB
- OLEDB
- OLEDB
- OLEDB
- OLEDB
- oledb
- 基于OleDb数据访问的基础类
- 数据访问基础类(基于OleDb)
- OLEDB数据库代码访问
- oledb 访问ACCESS
- ASP 中通过OLEDB访问 Oracle 的代码
- 事件冒泡- 关于onMouseOut违背逻辑关系的解决办法
- 如何用Squid Windows版架设二级代理服务器
- fusioncharts free传入xml字符串要注意的!!!
- 用SWT实现Java调用WindowsAPI
- 介绍下公司的产品-机房环境动力视频安防监控系统
- ASP.Net2.0 OleDB数据访问模块 (SqlHelper For OleDB)
- SdlChannelSink.cs
- 简单操作哈希表
- JavaScript环境中 实现GB2312 与 UTF8 之间的转码
- Symbian开发入门(一) symbian简介
- ASP.NET Cache
- The woman may let a man becomes omnipotent
- c语言-单链表的建立
- SudsCommon.cs