89 - Tool - ConnHelper.cs - 数据库连接助手

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using MySql.Data.MySqlClient;
namespace GameServer.Tool
{
    class ConnHelper
    {
        public const string CONNECTIONSTRING = "datasource=127.0.0.1;port=3306;database=tetirsdb;user=root;pwd=root;";
        //连接数据库
        public static MySqlConnection Connect()
        {
            MySqlConnection conn = new MySqlConnection(CONNECTIONSTRING);
            try
            {
                conn.Open();
                return conn;
            }
            catch(Exception e)
            {
                Console.WriteLine("链接数据库的时候实现异常：" + e);
                return null;
            }
        }
        //断开数据库
        public static void CloseConnection(MySqlConnection conn)
        {
            if(conn!=null)
                conn.Close();
            else
            {
                Console.WriteLine("MySqlConnection不能为空");
            }
        }
    }
}