public static bool InitDB()
{
try
{
if (SQLEngine.Instance.Connection == null)
{
return(false);
}
//创建数据库
string sqlstr = "CREATE DATABASE IF NOT EXISTS " + DATABASE_NAME + ";"
+ "use " + DATABASE_NAME + ";";
MySqlCommand cmd = new MySqlCommand(sqlstr, SQLEngine.Instance.Connection);
cmd.ExecuteNonQuery();
//创建表
FaceInfoBase.MakeTable();
UserInfo.MakeTable();
MoneyRecord.MakeTable();
return(true);
}catch (Exception ex)
{
return(false);
}
}
public static void Test()
{
UserInfo.MakeTable();
UserInfo u1 = UserInfo.Create(1, "mynumber", "whatname", 1, "13923336666", "Utopia", "nodejs", 3.21);
Console.WriteLine("u1: " + u1);
if (!u1.Exists())
{
Console.WriteLine("Create Failed.");
}
int id = u1.uid;
UserInfo u2 = UserInfo.Get(id);
Console.WriteLine("u2: " + u2);
if (!u2.IdenticalTo(u1))
{
Console.WriteLine("Get OK, BUT data inconsistent!");
}
string usernumber = "NewNumber";
string username = "******";
int gender = 0;
string phonenumber = "110";
string address = "new Addr";
string node = "still";
double money = 2333;
u2.usernumber = usernumber;
u2.username = username;
u2.gender = gender;
u2.phonenumber = phonenumber;
u2.address = address;
u2.node = node;
u2.money = money;
u2.Update();
UserInfo u3 = UserInfo.Get(id);
Console.WriteLine("u3: " + u3);
if (!u3.IdenticalTo(u2))
{
Console.WriteLine("Save/Update Failed.");
}
u3.Remove();
u3 = UserInfo.Get(id);
if (u3 != null)
{
Console.WriteLine("Remove Failed.");
}
Console.WriteLine("Test Completed [UserInfo]!");
}