C#数据库操作类

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

namespace DB_Application
{
    class DataManguage
    {
        private static String Server_IP;
        private static String Database_Name;
        private static String Username;
        private static String UserPasswd;
        private static String DB_CONN_STRING;

        private static SqlConnection db_conn;
 //       public SqlDataAdapter db_dataadapter;
  //      public DataTable db_datatable;
  //      public SqlDataReader db_datareader;

        public DataManguage()
        {
           
        }
        public void set_dbconn_string(String server_ip,String database_name,String username,String userpasswd){
           
            DataManguage.Server_IP = server_ip;
            DataManguage.Database_Name = database_name;
            DataManguage.Username = username;
            DataManguage.UserPasswd = userpasswd;
            DB_CONN_STRING = "SERVER=" + Server_IP + ";DATABASE=" + Database_Name + ";UID=" + Username + ";PWD=" + UserPasswd;
           
        }
        public int excu_conn_db(){
            System.Console.WriteLine(DB_CONN_STRING);
            try
            {
                db_conn = new SqlConnection(DB_CONN_STRING);
                db_conn.Open();

                return (1);
            }
            catch(Exception ex){
                MessageBox.Show("connection failed:"+ex.Message);
                return (0);
            }
        }
        public void excu_close_db(){
            db_conn.Close();           
        }


//读数据库,返回SqlDataReader
        public SqlDataReader db_read_data(String sqlstring){
           
            //第1种查询的方法
            if (db_conn.State == ConnectionState.Closed)
            {
                this.excu_conn_db();
            }
           
             SqlCommand read_cmd = new SqlCommand(sqlstring, db_conn);
             SqlDataReader db_datareader = read_cmd.ExecuteReader();
           
            //第2种查询的方法
/*             db_adapt_sql = new SqlDataAdapter(sqlstring, DB_CONN_STRING);
             db_datatab = new DataTable();
             db_adapt_sql.Fill(db_datatab);
 */

            return db_datareader;        
        }

//读数据库,返回DataTable
        public DataTable db_read_table(String sqlstring)
        {
            if (db_conn.State == ConnectionState.Closed)
            {
                this.excu_conn_db();
            }
            SqlDataAdapter sqladapter = new SqlDataAdapter(sqlstring,db_conn);
            DataSet data_set = new DataSet(); //可以填充多个表的存储过程
            sqladapter.Fill(data_set, "tablename");
            DataTable return_table = data_set.Tables["tablename"];//返回DataSet的其中一个表。可实现多个查询表结果的返回。
            return return_table;

        }
       

//执行操作       
        public int db_excu_string(String sqlstring){
            if (db_conn.State == ConnectionState.Closed)
            {
                this.excu_conn_db();
            }
            SqlCommand excu_cmd = new SqlCommand(sqlstring, db_conn);
            return excu_cmd.ExecuteNonQuery();

        }

//查找指定学号学生
        public Boolean db_user_ifexist(String sqlstring){
            if (db_conn.State == ConnectionState.Closed)
            {
                this.excu_conn_db();
            }
            SqlDataReader sdr=this.db_read_data(sqlstring);
            if(sdr.Read()){
                sdr.Close();
                return true;
            }
            else{
                sdr.Close();
                return false;
            }
           
        }

    }
}