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不能为空");
}
}
}
}