static int InsertInto(IntPtr L)
{
try
{
ToLua.CheckArgsCount(L, 3);
SqliteDbHelper obj = (SqliteDbHelper)ToLua.CheckObject(L, 1, typeof(SqliteDbHelper));
string arg0 = ToLua.CheckString(L, 2);
string[] arg1 = ToLua.CheckStringArray(L, 3);
Mono.Data.Sqlite.SqliteDataReader o = obj.InsertInto(arg0, arg1);
ToLua.PushObject(L, o);
return(1);
}
catch (Exception e)
{
return(LuaDLL.toluaL_exception(L, e));
}
}
public void register()
{
string firstname = GameObject.Find("FirstName/InputField/Text").GetComponent <Text>().text;
string lastname = GameObject.Find("LastName/InputField/Text").GetComponent <Text>().text;
string grade = GameObject.Find("Grade/InputField/Text").GetComponent <Text>().text;
string sid = GameObject.Find("SID/InputField/Text").GetComponent <Text>().text;
SqliteDbHelper db = new SqliteDbHelper("Data Source=./sqlite.db");
if (!db.CheckTable("user"))
{
db.CreateTable("user", new string[] { "userid", "firstname", "lastname", "grade" }, new string[] { "integer primary key", "text not null", "text not null", "int not null" });
}
db.InsertInto("user", new string[] { sid, "'" + firstname + "'", "'" + lastname + "'", grade });
db.CloseSqlConnection();
Debug.Log("OK!");
PlayerPrefs.SetString("sid", sid);
}
void OnGUI()
{
if (GUILayout.Button("create table"))
{
db.CreateTable("mytable", new string[] { "id", "name", "email" }, new string[] { "int", "varchar(20)", "varchar(50)" });
Debug.Log("create table ok");
}
if (GUILayout.Button("insert data"))
{
db.InsertInto("mytable",
new string[] { "" + (++id), "'随风去旅行" + id + "'", "'zhangj_live" + id + "@163.com'" });
Debug.Log("insert table ok");
}
if (GUILayout.Button("insert data specific"))
{
db.InsertIntoSpecific("mytable",
new string[] { "name", "id" }, new string[] { "'随风去旅行6'", "99" });
Debug.Log("insert data specific ok");
}
if (GUILayout.Button("Delete data"))
{
db.Delete("mytable",
new string[] { "name" }, new string[] { "'随风去旅行6'" });
Debug.Log("Delete data ok");
}
if (GUILayout.Button("Read Full Table"))
{
IDataReader sqReader = db.ReadFullTable("mytable");
while (sqReader.Read())
{
string id = "id=" + sqReader.GetInt32(sqReader.GetOrdinal("id"));
name = "name=" + sqReader.GetString(sqReader.GetOrdinal("name"));
emls = "email=" + sqReader.GetString(sqReader.GetOrdinal("email"));
Debug.LogError(id + "/" + name + "/" + emls);
}
Debug.Log("Read Full Table ok");
}
if (GUILayout.Button("search database"))
{
IDataReader sqReader = db.SelectWhere("mytable", new string[] { "name", "email" }, new string[] { "id" }, new string[] { "=" }, new string[] { "2" });
while (sqReader.Read())
{
name = "name=" + sqReader.GetString(sqReader.GetOrdinal("name"));
emls = "email=" + sqReader.GetString(sqReader.GetOrdinal("email"));
}
}
if (GUILayout.Button("Update data"))
{
db.UpdateInto("mytable",
new string[] { "name", "email" }, new string[] { "'吴小雄'", "'吴小雄21a'" },
"id", "5");
Debug.Log("Update data ok");
}
if (name != "")
{
GUI.Label(new Rect(100, 100, 100, 100), name);
GUI.Label(new Rect(100, 200, 100, 100), emls);
// GUILayout.Label(emls);
}
if (GUILayout.Button("close database"))
{
db.CloseSqlConnection();
Debug.Log("close table ok");
}
}
