/// <summary>
/// 创建账号，写入数据库
/// </summary>
/// <param name="user"></param>
/// <param name="psw"></param>
private void CreateAccount(string user, string psw)
{
var sql = "insert into AccountInfo(UID, Account, Psw, LastLoginTime) values (?, ?, ?, ?);";
var uid = MathHelper.GetNewGuid();
var result = m_mySqlDatabase.Execute(sql, new object[] { uid, user, psw, DateTime.MinValue });
WxLog.Debug($"RegEntity.CreateAccount <{user} | {psw}> Result<{result}>");
}
static void Main(string[] args)
{
string errmsg = "";
string query;
int choice;
string nick, manuf, model;
int year;
string confirm;
List <string>[] results;
MySqlDatabase mysql = new MySqlDatabase("localhost", "Instruments", "root", "Flyers2013");
Console.WriteLine("Enter the name of the guitar table: ");
string tableName = Console.ReadLine();
if (mysql.OpenConnection(ref errmsg))
{
do
{
choice = showMenu();
switch (choice)
{
case 1:
Console.WriteLine("Enter NickName: ");
nick = Console.ReadLine();
Console.WriteLine("Enter manufacturer: ");
manuf = Console.ReadLine();
Console.WriteLine("Enter model: ");
model = Console.ReadLine();
Console.WriteLine("Enter year: ");
year = int.Parse(Console.ReadLine());
query = GuitarDBQuery.GetInsertQuery(tableName, nick, manuf, model, year);
if (mysql.Execute(query, ref errmsg))
{
Console.WriteLine("Guitar was added.");
}
else
{
Console.WriteLine("Error: " + errmsg);
}
break;
case 2:
Console.Write("Enter name of guitar to delete: ");
nick = Console.ReadLine();
query = GuitarDBQuery.GetDeleteQuery(tableName, nick);
if (mysql.Execute(query, ref errmsg))
{
Console.WriteLine("Guitar was deleted.");
}
else
{
Console.WriteLine("error: " + errmsg);
}
break;
case 3:
Console.Write("Are you sure you want to delete all guitars? ");
confirm = Console.ReadLine().ToUpper();
if (confirm == "Y")
{
query = GuitarDBQuery.GetClearQuery(tableName);
if (mysql.Execute(query, ref errmsg))
{
Console.WriteLine("You are guitar-less");
}
else
{
Console.WriteLine("error: " + errmsg);
}
}
break;
case 4:
results = GuitarDBQuery.ParseResults(mysql.Select("select * from " + tableName + ";", ref errmsg));
break;
}
} while (choice != 5);
}
else
{
Console.WriteLine("Couldn't open database: " + errmsg);
}
}
public bool InsertGuitar(string tableName, string nickName, string manufName, string modelName, int yearMade, ref string errmsg)
{
string query = GetInsertQuery(tableName, nickName, manufName, modelName, yearMade);
return mysql.Execute(query, ref errmsg);
}
public bool InsertGame(string tableName, string title, string platfrm, string year, string company, ref string errmsg)
{
string query = GetInsertQuery(tableName, title, platfrm, year, company);
return(mysql.Execute(query, ref errmsg));
}