/// <summary>
/// 表示给表格添加内容，按照默认顺序
/// </summary>
public void Insert(string tableName, params string[] contents)
{
string sqlCmd = "INSERT INTO " + tableName + " VALUES ";
string c = "(";
for (int i = 0; i < contents.Length; i++)
{
c += "'" + contents[i] + "'";
if (i != contents.Length - 1)
{
c += ",";
}
else
{
c += ")";
}
}
sqlCmd += c;
hunterConsole.WriteDetails(sqlCmd);
try
{
MySqlCommand sqlCommand = new MySqlCommand(sqlCmd, mysql_connection);
sqlCommand.ExecuteNonQuery();
}
catch (MySqlException e)
{
hunterConsole.WriteException(e);
}
}
public void createDatabase()
{
try
{
XDocument xdoc = new XDocument(new XDeclaration("1,0", "utf-8", "yes"),
new XElement(XMLDefinition.ElementName.root.ToString()));
if (xmlDatabasePath.Length <= 0)
{
mHunterConsole.WriteMessage("XML数据库文件名为空！");
}
else
{
xdoc.Save(xmlDatabasePath);
mHunterConsole.WriteMessage("建立XML数据库成功。");
openDatabase();
}
}
catch (Exception e) { mHunterConsole.WriteException(e); }
}
