using?MySql.Data.MySqlClient;
using?System;
using?System.Collections.Generic;
using?System.Data;
using?System.Diagnostics;
using?System.IO;
using?System.Linq;
using?System.Text;
using?System.Threading.Tasks;

namespace?Emergency.DBClient
{
????public?class?MySQLconnection
????{
????????///?

????????///?MySqlConnection連接對象
????????///?

????????private?MySqlConnection?connection;
????????///?

????????///?服務器地址
????????///?

????????private?string?server;
????????///?

????????///?數據庫實例名稱
????????///?

????????private?string?database;?????
????????///?

????????///?用戶名
????????///?
??
????????private?string?uid;
????????///?

????????///?密碼
????????///?

????????private?string?password;
????????///?

????????///?端口號
????????///?

????????private?string?port;

????????public?MySqlConnection?getInstance（）?{
????????????return?connection;
????????}

????????///?

????????///?初始化mysql連接
????????///?

????????///?服務器地址
????????///?se“>數據庫實例
????????///?用戶名稱
????????///?密碼
????????public?void?Initialize（string?server?string?database?string?uid?string?password）
????????{
????????????this.server?=?server;
????????????this.uid?=?uid;
????????????this.password?=?password;
????????????this.database?=?database;
????????????//string?connectionString?=?“Data?Source=“?+?server?+?“;“?+?“port=“?+?port?+?“;“?+?“Database=“?+?database?+?“;“?+?“User?Id=“?+?uid?+?“;“?+?“Password=“?+?password?+?“;“?+?“CharSet?=?utf8“;?;
????????????string?connectionString?=?“server=“?+?server?+?“;user?id=“?+?uid?+?“;password=“?+?password?+?“;database=“?+?database;
????????????connection?=?new?MySqlConnection（connectionString）;
????????}
????????///?

????????///?打開數據庫連接
????????///?

????????///?是否成功
????????public?bool?OpenConnection（）
????????{
????????????try
????????????{
????????????????connection.Open（）;
????????????????return?true;
????????????}
????????????catch?（MySqlException?ex）
????????????{
????????????????//When?handling?errors?you?can?your?application‘s?response?based?on?the?error?number.
????????????????//The?two?most?common?error?numbers?when?connecting?are?as?follows:
????????????????//0:?Cannot?connect?to?server.
????????????????//1045:?Invalid?user?name?and/or?password.
????????????????switch?（ex.Number）
????????????????{
????????????????????case?0:
????????????????????????Console.Write（“Cannot?connect?to?server.??Contact?administrator“）;
????????????????????????break;

????????????????????case?1045:
????????????????????????Console.Write（“Invalid?username/password?please?try?again“）;
????????????????????????break;
????????????????}
????????????????return?false;
????????????????
????????????}
????????}

?????