adoclass.cs

教师管理系统,登陆上去后可以在系统中对教师资料等等做管理

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.Sql;
using System.Data.SqlClient;
using System.Windows.Forms;
namespace jsgl.baseClass1
{
    public class adoClass
    {
        protected string connString;
        protected SqlConnection conn;

        public SqlConnection Conn
        {
            get { return conn; }
            set { conn = value; }
        }

        protected SqlCommand comm;
        public SqlCommand Comm
        {
            get { return comm; }
            set { comm = value; }
        }
        protected DataSet ds;

        public DataSet Ds
        {
            get { return ds; }
            set { ds = value; }
        }

        public adoClass()
        {
            connString = "server=(local);database=rsgl;trusted_connection=true;";
        }
        public adoClass(string serverName,string databaseName)
        {
            connString = "server="+serverName+";database="+databaseName+";trusted_connection=true;";
        }
        public SqlConnection GetConn()
        {
            try
            {
                conn = new SqlConnection(connString);
                return conn;
            }
            catch(Exception e)
            {
                MessageBox.Show(e.Message);
                return null;
            }
        }
        public SqlDataAdapter GetAda(string sqlString)
        {
            try
            {
                SqlConnection con = this.GetConn();
                SqlDataAdapter ada = new SqlDataAdapter(sqlString, con);
                return ada;
            }
            catch (Exception e)
            {
                MessageBox.Show(e.Message);
                return null;
            }
        }
        public DataSet GetDataset(string sqlstring, string tableName)
        {
            try
            {
                SqlConnection con = this.GetConn();
                con.Open();
                SqlDataAdapter ada = new SqlDataAdapter(sqlstring, con);
                ds = new DataSet();
                ada.Fill(ds, tableName);
                con.Close();
                return ds;
            }
            catch (Exception e)
            {
                MessageBox.Show(e.Message);
                return null;
            }
            finally
            {
                if (conn != null)
                    conn.Close();
            }
           
        }
        public void ExecuteCommand(string sqlString)
        {
            try 
            {
                SqlConnection con = this.GetConn();
                con.Open();
                SqlCommand comm = new SqlCommand();
                comm.Connection = con;
                comm.CommandText = sqlString;
                comm.ExecuteNonQuery();
                con.Close(); 
            }
            catch (Exception e)
            {
                MessageBox.Show(e.Message);
                
            }
            finally
            {
                if (conn != null)
                    conn.Close();
            }
            
        }
        public SqlDataReader GetReader(string sqlString)
        {
            try 
            {
                 SqlConnection con = this.GetConn();
                con.Open();
                comm = new SqlCommand(sqlString, con);
                SqlDataReader dr = comm.ExecuteReader();
                con.Close();

                return dr;
            }
            catch (Exception e)
            {
                MessageBox.Show(e.Message);
                return null;
            }
            finally
            {
                if (conn != null)
                    conn.Close();
            }
            
        }
    }
}