C#与mysql数据库（一）

        近期开个专题记录一下C#和mysql的简单用法，暂时不采用存储过程，只是研究一下语句的使用；本篇先带来连接数据库和关闭数据库的方法。下面是DBHelper类的构造函数；

public void Initialize()
        {
            server = Temp_Variable.server;
            database = Temp_Variable.db_name;
            uid = Temp_Variable.uid;
            password = Temp_Variable.password;
            string connectionString;
            connectionString = "SERVER=" + server + ";" + "DATABASE=" + database + ";" + "UID=" + uid + ";" + "PASSWORD=" + password + ";";
            connection = new MySqlConnection(connectionString);
        }

以下是数据库连接对象connection的使用，开启和关闭数据库功能方法的实现；

        /// <summary>
        /// 开启数据库
        /// </summary>
        /// <returns></returns>
        public  int OpenConnection()
        {
            try
            {
                connection.Open();
                return Error.NoError;
            }
            catch (MySqlException ex)
            {
                switch (ex.Number)
                {
                    case 0:
                        return Error.CannotConnectDB;//无法连接数据库
                    case 1045:
                        return Error.UidPwdWrong;//用户名密码错误
                }
                return Error.UnknownError;//未知错误
            }
            catch (Exception ex1)
            {
                return Error.UnknownError;
            }
        }

        /// <summary>
        /// 关闭数据库
        /// </summary>
        /// <returns></returns>
        public int CloseConnection()
        {
            try
            {
                connection.Close();
                return Error.NoError;
            }
            catch (MySqlException ex)
            {
                return Error.DBClosingError;
            }
        }