数据库连接类

using  System;
using  System.ComponentModel;
using  System.Collections.Generic;
using  System.Diagnostics;
using  System.Text;
using  System.Data;
using  System.Data.SqlClient;

namespace  学生学籍管理系统
... {
    public partial class LinkDataBase : Component
    ...{
        private String strDataBase;
        private String strServer;
        private String strUseID;
        private String strPassword;

        public LinkDataBase(String serverName, String dataBase, String useID, String passWord)
        ...{
            InitializeComponent();
            strServer = serverName;
            strDataBase = dataBase;
            strUseID = useID;
            strPassword = passWord;

            connectionString = "Data Source=";
            connectionString += strServer;
            connectionString += ";Initial Catalog=";
            connectionString += strDataBase;
            connectionString += ";User ID=";
            connectionString += strUseID;
            connectionString += ";Password=";
            connectionString += strPassword;


            if (strUseID == "" && strPassword == "")
            ...{
                connectionString += ";Integrated Security=True";
            }

            this.ds = new DataSet();
        }

        public LinkDataBase(IContainer container)
        ...{
            container.Add(this);

            InitializeComponent();
        }
        public DataSet SelectDataBase(String tempStrSQL, String tempTableName)
        ...{
            this.strSQL = tempStrSQL;
            this.myConnection = new SqlConnection(connectionString);
            this.da = new SqlDataAdapter(this.strSQL, this.myConnection);
            if(ds.Tables.Contains(tempTableName))
                ds.Tables[tempTableName].Clear();
            this.da.Fill(ds, tempTableName);
            
            return ds;
        }

        public DataSet UpdateDataBase(DataSet changeDataSet, String tableName)
        ...{
           
            this.myConnection = new SqlConnection(connectionString);
            this.da = new SqlDataAdapter(this.strSQL, this.myConnection);
            this.sqlCmdBld = new SqlCommandBuilder(da);
            this.da.Update(changeDataSet, tableName);
            return changeDataSet;
        }

        public DataSet SelectDataBase(String tempStrSQL)
        ...{
            this.myConnection = new SqlConnection(connectionString);
            DataSet tempDataSet = new DataSet();
            this.da = new SqlDataAdapter(tempStrSQL, this.myConnection);
            this.da.Fill(tempDataSet);
            return tempDataSet;
        }

        public int UpdateDataBase(String tempStrSQL)
        ...{
            this.myConnection = new SqlConnection(connectionString);
            myConnection.Open();
            SqlCommand tempSqlCommand = new SqlCommand(tempStrSQL, this.myConnection);
            int number = tempSqlCommand.ExecuteNonQuery();
            myConnection.Close();
            return number;
        }
        public int DeleteCollege(int CollegeID)
        ...{
            this.myConnection = new SqlConnection(connectionString);
            myConnection.Open();
            SqlCommand tempSqlCommand = new SqlCommand("DeleteCollege", this.myConnection);
            tempSqlCommand.CommandType = CommandType.StoredProcedure;
            SqlParameter parameterCollegeID = new SqlParameter("@CollegeID", CollegeID);
            parameterCollegeID.Direction = ParameterDirection.Input;
            tempSqlCommand.Parameters.Add(parameterCollegeID);
            int number = tempSqlCommand.ExecuteNonQuery();
            myConnection.Close();
            return number;
        }
        public int DeleteSpecialty(int SpecialtyID)
        ...{
            this.myConnection = new SqlConnection(connectionString);
            myConnection.Open();
            SqlCommand tempSqlCommand = new SqlCommand("DeleteSpecialty", this.myConnection);
            tempSqlCommand.CommandType = CommandType.StoredProcedure;
            SqlParameter parameterCollegeID = new SqlParameter("@SpecialtyID", SpecialtyID);
            parameterCollegeID.Direction = ParameterDirection.Input;
            tempSqlCommand.Parameters.Add(parameterCollegeID);
            int number = tempSqlCommand.ExecuteNonQuery();
            myConnection.Close();
            return number;
        }

        public int DeleteClass(String ClassID)
        ...{
            this.myConnection = new SqlConnection(connectionString);
            myConnection.Open();
            SqlCommand tempSqlCommand = new SqlCommand("DeleteClass", this.myConnection);
            tempSqlCommand.CommandType = CommandType.StoredProcedure;
            SqlParameter parameterCollegeID = new SqlParameter("@ClassID", ClassID);
            parameterCollegeID.Direction = ParameterDirection.Input;
            tempSqlCommand.Parameters.Add(parameterCollegeID);
            int number = tempSqlCommand.ExecuteNonQuery();
            myConnection.Close();
            return number;
        }

        public int DeleteCourse(String CourseID)
        ...{
            this.myConnection = new SqlConnection(connectionString);
            myConnection.Open();
            SqlCommand tempSqlCommand = new SqlCommand("DeleteCourse", this.myConnection);
            tempSqlCommand.CommandType = CommandType.StoredProcedure;
            SqlParameter parameterCollegeID = new SqlParameter("@CourseID", CourseID);
            parameterCollegeID.Direction = ParameterDirection.Input;
            tempSqlCommand.Parameters.Add(parameterCollegeID);
            int number = tempSqlCommand.ExecuteNonQuery();
            myConnection.Close();
            return number;
        }

        public int DeleteStudent(String StudentID)
        ...{
            this.myConnection = new SqlConnection(connectionString);
            myConnection.Open();
            SqlCommand tempSqlCommand = new SqlCommand("DeleteStudent", this.myConnection);
            tempSqlCommand.CommandType = CommandType.StoredProcedure;
            SqlParameter parameterCollegeID = new SqlParameter("@StudentID", StudentID);
            parameterCollegeID.Direction = ParameterDirection.Input;
            tempSqlCommand.Parameters.Add(parameterCollegeID);
            int number = tempSqlCommand.ExecuteNonQuery();
            myConnection.Close();
            return number;
        }

        public int DeleteRP(int RPID)
        ...{
            this.myConnection = new SqlConnection(connectionString);
            myConnection.Open();
            SqlCommand tempSqlCommand = new SqlCommand("DeleteRP", this.myConnection);
            tempSqlCommand.CommandType = CommandType.StoredProcedure;
            SqlParameter parameterCollegeID = new SqlParameter("@RPID", RPID);
            parameterCollegeID.Direction = ParameterDirection.Input;
            tempSqlCommand.Parameters.Add(parameterCollegeID);
            int number = tempSqlCommand.ExecuteNonQuery();
            myConnection.Close();
            return number;
        }
        private String strSQL;
        private String connectionString;
        private SqlConnection myConnection;
        private SqlCommandBuilder sqlCmdBld;
        private DataSet ds;
        private SqlDataAdapter da;
    
    }
}