很简单很简单的DBHelper类

古城微笑少年丶 2023-02-27 10:31 4阅读 0赞

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0MTM3Mzk3_size_16_color_FFFFFF_t_70_pic_center]  
记录一个简单的DBHelper类吧，用的时候在上来拿！

/// <summary>
        /// 数据库连接工具类
        /// </summary>
        public class DBHelper
        { 
            string constr = "Data Source=.;Initial Catalog=schoolDB;Integrated Security=True";
            private SqlConnection conn;
    
            //数据库连接Connection对象
            public SqlConnection getConnection() {  
                if(conn==null){ 
                    conn = new SqlConnection(constr);
                }
                return conn;
            }
    
    
            //打开连接
            public void OpenConnection() {  
                if(conn.State==ConnectionState.Closed){ 
                    conn.Open();
                }else if(conn.State==ConnectionState.Broken){ 
                    conn.Close();
                    conn.Open();
                }
            }
    
            //关闭连接
            public void CloseConnection() {  
                if(conn.State==ConnectionState.Open||conn.State==ConnectionState.Broken){ 
                    conn.Close();
                }
            }
        }

欢迎搜索公众号：雄雄的小课堂。  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0MTM3Mzk3_size_16_color_FFFFFF_t_70_pic_center 1]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0MTM3Mzk3_size_16_color_FFFFFF_t_70_pic_center]: /images/20230209/d9093dfae891499382a5aac550f989fb.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0MTM3Mzk3_size_16_color_FFFFFF_t_70_pic_center 1]: /images/20230209/b6c2ad31d1ed4647a7f7ce73171de020.png