sqlbean.cs

图书管理系统！！C#+olc 大小是100多k

using System;
using System.Data;
using System.Data.OleDb;
using System.Data.Common;
using System.Windows.Forms;


namespace bookstore
{
	/// <summary>
	/// SqlBean 的摘要说明。
	/// </summary>
	public class SqlBean
	{
		OleDbConnection con=null;
		OleDbDataAdapter da=null;
		OleDbCommand coma=null;
		string strCon="Provider=msdaora;Data Source=ORA;User Id=system;Password=manager;"; 
//DataSet d=new decim
		public SqlBean()
        {
			try
			{
				con=new OleDbConnection(strCon);
			}
			catch(Exception em){
			MessageBox.Show(em.ToString());
			}
			con.Open();
			 
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}
		public OleDbDataReader selectTable(string sql){
			//con.Open();
			//openCon();
		    coma=new OleDbCommand();
			coma.Connection=con;
			coma.CommandText=sql;
			OleDbDataReader reader=null;
			try
			{
				reader=coma.ExecuteReader();
			}
			catch(Exception ex){
			MessageBox.Show(ex.ToString());
			}
			//con.Close();
			//closeCon();
			return reader;

		}
		public DataSet selectTable2(string sql,string name){
		    //openCon();
			//con.Open();
			da=new OleDbDataAdapter(sql,con);
			DataSet datas=new DataSet();
			da.Fill(datas,name);
			//con.Close();
			//closeCon();
			return datas;
			 

		}

		 
		public int Update(string sql){
			//openCon();
			//con.Open();
			int num=0;
			coma=new OleDbCommand();
			coma.Connection=con;
			coma.CommandText=sql;
			try
			{
				num=coma.ExecuteNonQuery();
			}
			catch(Exception em){
			MessageBox.Show(em.ToString());
			}
			//con.Close();
			//closeCon();
			return num;
		}
		public void closeCon(){
			if(con.State.Equals("Open")){
			con.Close();
			}
		}
		public void openCon(){
			if(con.State.Equals("close")){
			con.Open();
			}
		}
		 
		
	}
}