C#连接数据库（DBhelper）

最新推荐文章于 2025-11-02 18:11:52 发布

原创最新推荐文章于 2025-11-02 18:11:52 发布 · 979 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#c++ #java

java 专栏收录该内容

19 篇文章

订阅专栏

本文介绍了DBHelper类，用于数据库连接的初始化、打开和关闭操作，展示了如何使用 SqlConnection 对象并处理不同连接状态。

 class DBHelper
    {
        //数据库四参数
        private string strConn = "Data Source=.;Initial Catalog=MobileManager;User ID=sa;Pwd=1234";
        //Connection对象
        private SqlConnection connection;
        public SqlConnection Connection
        {
            get
            {
                if (connection==null)
                {
                    connection=new SqlConnection(strConn);
                }
                return connection;
            }
        }
        public void OpenConnection()
        {
            if (Connection.State == ConnectionState.Closed)
            {
                Connection.Open();
            }
            else if (Connection.State == ConnectionState.Broken)
            {
                Connection.Close();
                Connection.Open();
            }
            }
        public void CloseConnection()
        {
            if (Connection.State == ConnectionState.Open || Connection.State == ConnectionState.Broken)
            {
                Connection.Close();
            }           
       }