/// <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)); }