数据库操作类代码,CSharp代码库,德仔网

代码语言
代码分类
【CSharp】数据库操作类
作者:Dezai.CN / 发布于2011/5/1/ 640
<div>using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;
/// <summary>
/// Author:匆匆 Blog:http://www.cnblogs.com/huangjianhuakarl/
/// 数据库操作类
/// </summary>
public class Common
{
 private static OleDbConnection conn = new OleDbConnection();
 private static OleDbCommand comm = new OleDbCommand();
public Common()
{ 
 
}
 /// <summary>
 /// 打开连接
 /// </summary>
 private static void openConnection()
 {
 if (conn.State == ConnectionState.Closed)
 {
 try
 {
 conn.ConnectionString =System.Web.Configuration.WebConfigurationManager.ConnectionStrings["connStr"].ConnectionString;
 comm.Connection = conn;
 conn.Open();
 }
 catch (Exception e)
 {
 throw new Exception(e.Message);
 }
 }
 }
 /// <summary>
 /// 关闭连接
 /// </summary>
 private static void closeConnection()
 {
 if (conn.State == ConnectionState.Open)
 {
 conn.Close();
 }
 conn.Dispose();
 comm.Dispose();
 }
 /// <summary>
 /// 执行一条sql语句
 /// </summary>
 /// <param name="sqlStr">sql语句</param>
 public static void ExecuteSql(string sqlStr)
 {
 try
 {
 openConnection();
 comm.CommandType = CommandType.Text;
 comm.CommandText = sqlStr;
 comm.ExecuteNonQuery();
 }
 catch (Exception e)
 {
 throw new Exception(e.Message);
 }
 finally
 {
 closeConnection();
 }
 }
 /// <summary>
 /// 返回一个数据集
 /// </summary>
 /// <param name="sqlStr">sql语句</param>
 /// <returns></returns>
 public static DataSet dataSet(string sqlStr)
 {
 OleDbDataAdapter da = new OleDbDataAdapter();
 DataSet ds = new DataSet();
 try
 {
 openConnection();
 comm.CommandType = CommandType.Text;
 comm.CommandText = sqlStr;
 da.SelectCommand = comm;
 da.Fill(ds);
 }
 catch(Exception e)
 {
 throw new Exception(e.Message);
 }
 finally
 {
 closeConnection();
 }
 return ds;
 }
 /// <summary>
 /// 返回一个数据视图
 /// </summary>
 /// <param name="sqlStr">sql语句</param>
 /// <returns></returns>
 public static DataView dataView(string sqlStr)
 {
 OleDbDataAdapter da = new OleDbDataAdapter();
 DataView dv = new DataView();
 DataSet ds = new DataSet();
 try
 {
 openConnection();
 comm.CommandType = CommandType.Text;
 comm.CommandText = sqlStr;
 da.SelectCommand = comm;
 da.Fill(ds);
 dv = ds.Tables[0].DefaultView;
 }
 catch (Exception e)
 {
 throw new Exception(e.Message);
 }
 finally
 {
 closeConnection();
 }
 return dv;
 }
}
</div>
试试其它关键字
　数据库操作类　
同语言下
可能有用的
Dezai.CN贡献的其它代码(4037)