using System;
using System.Data;
using System.Data.OleDb;
using System.Configuration;
namespace QYTang.Gengerate
{
///
/// OleDb操作类
///
public abstract class OpOleDb
{
///
/// 获取数据库查询字符串
///
public static string connStr = ConfigurationManager.ConnectionStrings["QYTangConnectionString"].ToString();
///
/// 根据一条sql,获取Dataset
///
/// 数据库连接字符串
/// sql语句
/// 参数列表
/// Dataset
public static DataSet GetDataSet(string con, string cmdText, OleDbParameter[] parms)
{
DataSet ds = new DataSet();
OleDbCommand cmd = new OleDbCommand();
OleDbConnection conn = new OleDbConnection(con);
OleDbDataAdapter da = new OleDbDataAdapter();
PrepareCommand(cmd, conn, CommandType.Text, cmdText, parms);
da.SelectCommand = cmd;
da.Fill(ds);
cmd.Parameters.Clear();
if (conn.State == ConnectionState.Open)
conn.Close();
return ds;
}
///
/// 读取DataReader
///
/// 数据库连接字符串
/// sql语句
/// 参数列表
/// DataReader
public static OleDbDataReader GetDataRead(OleDbConnection conn, string cmdText, OleDbParameter[] parms)
{
OleDbCommand cmd = new OleDbCommand();
PrepareCommand(cmd, conn, CommandType.Text, cmdText, parms);
OleDbDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
cmd.Parameters.Clear();
return dr;
}
///
/// 插入、更新或删除操作
///
/// 数据库连接字符串
/// sql语句
/// 参数列表
/// 接受调整的行数
public static int Query(string con, string cmdText, OleDbParameter[] parms)
{
OleDbCommand cmd = new OleDbCommand();
OleDbConnection conn = new OleDbConnection(con);
PrepareCommand(cmd, conn, CommandType.Text, cmdText, parms);
int val = cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
if (conn.State == ConnectionState.Open)
conn.Close();
return val;
}
// 为数据查询做好准备
static void PrepareCommand(OleDbCommand cmd, OleDbConnection conn, CommandType cmdType, string cmdText, OleDbParameter[] parms)
{
if (conn.State != ConnectionState.Open)
conn.Open();
cmd.Connection = conn;
cmd.CommandText = cmdText;
cmd.CommandType = cmdType;
if (parms != null)
{
for (int i = 0; i
cmd.Parameters.Add(parms[i]);
}
}
}
}