mydata.cs

学生宿舍管理系统 学生宿舍管理系统

using System;
using System.Data;
using System.Data.OleDb;
using System.Windows.Forms;
using System.Collections.Generic;
using System.Text;

namespace 学生宿舍管理系统
{
   public  class MyData
    {
       private string strDSN;   //定义数据库连接对象
       private OleDbConnection myConn;
       public MyData()         // 构造函数实现打开数据库连接
       {
           strDSN = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=mydb.mdb";
           myConn = new OleDbConnection(strDSN);
           myConn.Open();
       }

      //利用DataReader对象检索数据
       public OleDbDataReader getDataReader(String strSQL)  
       {
           try
           {
               OleDbCommand myCmd = new OleDbCommand(strSQL, myConn);
               OleDbDataReader datareader = myCmd.ExecuteReader();
               return datareader;
           }
           catch (Exception e)
           {
               MessageBox.Show(e.Message, "数据库操作失败！", MessageBoxButtons.OK, MessageBoxIcon.Information);
               return null;
           }
       }

       //更新数据库
       public Boolean updateSql(string strSQL)
       {
           OleDbCommand myCmd = new OleDbCommand(strSQL, myConn);
           try
           {
               myCmd.ExecuteNonQuery();
               return true;
           }
           catch (Exception e)
           {

               MessageBox.Show(e.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
               return false;
           }
       }

       //创建数据集
       public DataSet getDataSet(string str,string table)
       {
           OleDbDataAdapter da = new OleDbDataAdapter(str, myConn);
           DataSet ds = new DataSet();
           da.Fill(ds, table);
           return ds;
       }

       //关闭数据库连接
       public void closeConnection()
       {
               myConn.Close();
        
       }

    }
}