public string connectionString_master = ""; // 连接到master数据库的连接串
/// <summary>
/// 创建指定数据库操作对象
/// </summary>
/// <param name="DBName">数据库名称</param>
/// <param name="UserName">数据库用户名</param>
/// <param name="Password">数据库密码</param>
public DataBase(string DBName, string UserName, string Password)
{
if (DBName == null || DBName.Equals("") || UserName == null || UserName.Equals("") || Password == null || Password.Equals(""))
{
throw new Exception("DataBase()参数不可为空");
}
this.DBName = DBName;
this.UserName = UserName;
this.Password = Password;
connectionString = DataBaseTool.getConnectString(DBName, UserName, Password);
connectionString_master = DataBaseTool.getConnectString("", UserName, Password);
//if (this.DBName != null && !this.DBName.Equals("") && !this.DBName.Equals("master"))
{
if (!DataBaseTool.Exist(DBName, connectionString_master)) // 判断数据库是否存在，若不存在则创建数据库
{
isInitSuccess = DataBaseTool.Create(DBName, connectionString_master);
}
else
{
isInitSuccess = true;
}
}
}
/// <summary>
/// 删除指定的数据库
/// </summary>
public bool DeletDataBase(string DataBaseName)
{
if (DataBaseName == null || DataBaseName.Equals(""))
{
DataBaseName = DBName;
}
return(DataBaseTool.Delet(DataBaseName, connectionString_master));
}
private DataBaseTool()
{
string datapath =
string.Format("Server={0};Database={1};User ID={2};Password={3};Port={4}", "39.108.170.235", "efficiency", "root", "Sjy_1994_02", "3306");
try
{
if (con == null)
{
con = new MySqlConnection(datapath);
}
} catch (System.Exception ex) {
Debug.Log("数据库连接失败 ：" + ex);
}
try {
command = con.CreateCommand();
} catch (System.Exception ex) {
Debug.Log(" 创建指令对象失败 ：" + ex);
}
Instance = this;
}
/// <summary>
/// 所有数据库名称
/// </summary>
public List <String> DataBaseNames()
{
return(DataBaseTool.DataBaseNames(connectionString_master));
}
/// <summary>
/// 执行sql命令
/// </summary>
/// <param name="sql"></param>
/// <returns></returns>
public ExecuteResult Execute(string sql)
{
return(DataBaseTool.Execute(sql, connectionString));
}
/// <summary>
/// 判断当前数据库中，是否存在指定名称的表
/// </summary>
/// <param name="TAB">表名称</param>
public bool ExistTab(string TAB)
{
return(DataBaseTool.ExistTab(TAB, connectionString));
}
