/// <summary>
/// 创建表格
/// </summary>
/// <returns>是否成功</returns>
public Boolean createTable(MySqlSlot[] slots)
{
lock (this)
{
try
{
StringBuilder sb = new StringBuilder();
for (int i = 0; i < slots.Length; i++)
{
MySqlSlot slot = slots[i];
sb.Append(slot.flag);
if (i < slots.Length - 1)
{
sb.Append(", ");
}
}
this.Command = new MySqlCommand("CREATE TABLE " + this.Schema + "." + this.Table + "(" + sb.ToString() + ");", Connection);
this.Connection.Open();
this.Reader = this.Command.ExecuteReader();
while (this.Reader.Read())
{
this.closeReader();
this.Connection.Close();
return(true);
}
}
catch (MySqlException ex)
{
this.closeReader();
this.Connection.Close();
ConsolePlusLib.Console.Out.println(Level.Severe, ex.ToString());
}
return(false);
}
}
/// <summary>
/// 创建表格
/// </summary>
/// <returns>是否成功</returns>
public Boolean createTable(MySqlSlot[] slots)
{
lock (this)
{
try
{
StringBuilder sb = new StringBuilder();
for (int i = 0; i < slots.Length; i++)
{
MySqlSlot slot = slots[i];
sb.Append(slot.flag);
if (i < slots.Length - 1)
{
sb.Append(", ");
}
}
this.Command = new MySqlCommand("CREATE TABLE " + this.Schema + "." + this.Table + "(" + sb.ToString() + ");", Connection);
this.Connection.Open();
this.Reader = this.Command.ExecuteReader();
while (this.Reader.Read())
{
this.closeReader();
this.Connection.Close();
return true;
}
}
catch (MySqlException ex)
{
this.closeReader();
this.Connection.Close();
ConsolePlusLib.Console.Out.println(Level.Severe, ex.ToString());
}
return false;
}
}
