- using System;
- using System.Collections.Generic;
- using System.Text;
- using System.Data;
- using System.Data.OleDb;
- using System.Windows.Forms;
- namespace 恶猫外推小助手
- {
- public class DBManage
- {
- // 数据库连接字符串
- private static string ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Application.StartupPath + "\\\\data.mdb";
- //private static string ConnectionString = "Data Source=db;user=db;password=db;";
- //private static string ConnectionString = "Data Source=ORCL;user=ieasdba;password=ieasdba;";
- public DBManage()
- {
- //
- // TODO: 在此处添加构造函数逻辑
- //
- _conn = new OleDbConnection(ConnectionString);
- _conn.Open();
- }
- public DBManage(string ConnString)
- {
- //
- // TODO: 在此处添加构造函数逻辑
- //
- _conn = new OleDbConnection(ConnString);
- }
- public void Open()
- {
- _conn.Open();
- }
- public void Close()
- {
- _conn.Close();
- }
- private OleDbConnection _conn;
- public OleDbConnection Connection
- {
- get { return _conn; }
- }
- public static DataSet GetDataSet(string SQLSelect, OleDbConnection conn)
- {
- OleDbCommand selectCmd = new OleDbCommand(SQLSelect, conn);
- OleDbDataAdapter dsCmd = new OleDbDataAdapter();
- DataSet resutleDataSet = new DataSet();
- selectCmd.CommandType = CommandType.Text;
- dsCmd.SelectCommand = selectCmd;
- dsCmd.Fill(resutleDataSet);
- return resutleDataSet;
- }
- public static IDataReader GetDataReader(string SQLSelect, OleDbConnection conn)
- {
- //OracleCommand selectCmd = new OracleCommand( SQLSelect, conn );
- OleDbCommand selectCmd = conn.CreateCommand();
- selectCmd.CommandText = SQLSelect;
- OleDbDataReader myReader = selectCmd.ExecuteReader();
- return myReader;
- }
- public static void ExecuteSQL(string sqlText, OleDbConnection conn)
- {
- OleDbCommand cmd = conn.CreateCommand();
- cmd.CommandText = sqlText;
- cmd.ExecuteNonQuery();
- cmd = null;
- }
- public static object GetField(string sqlText, OleDbConnection conn)
- {
- OleDbCommand cmd = conn.CreateCommand();
- cmd.CommandText = sqlText;
- return cmd.ExecuteScalar();
- }
- }
- }
- //该片段来自于http://www.codesnippet.cn/detail/3107201513285.html
来源: http://www.codesnippet.cn/detail/3107201513285.html