DBHelper类

class  DBHelper

     {

         //public static string connstr = "server=.;database=SuperKTV;uid=sa;pwd=123456";

 

         public  static  string  connstr =  "server=.;database=Dormitory;uid=sa;pwd=123456" ;

         //数据库链接对象

         private  static  SqlConnection Conn =  null ;

 

         //初始化数据库链接

         private  static  void  InitConnection()

         {

             //如果连接对象不存在，创建连接

             if  (Conn ==  null )

                 Conn =  new  SqlConnection(connstr);

             //如果连接对象关闭，打开连接

             if  (Conn.State == ConnectionState.Closed)

                 Conn.Open();

             //如果连接中断，重启连接

             if  (Conn.State == ConnectionState.Broken)

             {

                 Conn.Close();

                 Conn.Open();

             }

         }

 

         //查询，获取DataReader

         public  static  SqlDataReader GetDataReader( string  sqlStr)

         {

             InitConnection();

             SqlCommand cmd =  new  SqlCommand(sqlStr, Conn);

             //CommandBehavior.CloseConnection 命令行为：当DataReader对象被关闭时，自动关闭占用的连接对象

             return  cmd.ExecuteReader(CommandBehavior.CloseConnection);

         }

 

         //查询，获取DataTable

         public  static  DataTable GetDataTable( string  sqlStr)

         {

             InitConnection();

             DataTable table =  new  DataTable();

             SqlDataAdapter dap =  new  SqlDataAdapter(sqlStr, Conn);

             dap.Fill(table);

             Conn.Close();

             return  table;

         }

 

         //查询，获取DataSet

         public  static  DataSet GetDataSet( string  sqlStr)

         {

             InitConnection();

             DataSet ds =  new  DataSet();

             SqlDataAdapter dap =  new  SqlDataAdapter(sqlStr, Conn);

             dap.Fill(ds);

             Conn.Close();

             return  ds;

         }

 

         //增改删

         public  static  bool  ExecuteNonQuery( string  sqlStr)

         {

             InitConnection();

             SqlCommand cmd =  new  SqlCommand(sqlStr, Conn);

             int  result = cmd.ExecuteNonQuery();

             Conn.Close();

             return  result > 0;

         }

 

         //执行集合函数

         public  static  object  ExecuteScalar( string  sqlStr)

         {

             InitConnection();

             SqlCommand cmd =  new  SqlCommand(sqlStr, Conn);

             object  result = cmd.ExecuteScalar();

             Conn.Close();

             return  result;

         }

     }