12,162
社区成员
发帖
与我相关
我的任务
分享
public static MySqlConnection sqlCon; //用于连接数据库
public bool ConnectServer(string server= "localhost", string database= "storesystem", string user= "root", string psw= "123456", uint port = 3306)
{
if (sqlCon == null)
{
try
{
MySqlConnectionStringBuilder myCSB = new MySqlConnectionStringBuilder();
myCSB.Port = port;
myCSB.Server = server;
myCSB.UserID = user;
myCSB.Database = database;
myCSB.Password = psw;
MySqlConnection myConnection = new MySqlConnection(myCSB.ConnectionString);
sqlCon = new MySqlConnection(myCSB.ConnectionString);
sqlCon.Open();
return true;
}
catch
{
MessageBox.Show("数据库连接错误,请检查网络连接情况或数据库配置!", "数据库连接失败");
}
}
return false;
}