Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- using UnityEngine;
- using System.Collections;
- using System;
- using System.IO;
- using System.Threading;
- using System.Diagnostics;
- public class Test : MonoBehaviour
- {
- // Query Create DataGame
- private string tbl_Boss =
- "CREATE TABLE IF NOT EXISTS tbl_Boss (id_boss INTEGER, type INTEGER, id_level INTEGER, name_boss VARCHAR, blood INTEGER, resist INTEGER, special INTEGER, move INTEGER, blood_special INTEGER, num_special INTEGER, img VARCHAR);";
- // Query Select DataGame
- private string tbl_BossSelect = "SELECT * FROM tbl_Boss;";
- // Query Insert DataGame
- private string tbl_BossInsert =
- "INSERT INTO tbl_Boss (id_boss,type,id_level,name_boss,blood,resist,special,move,blood_special,num_special,img) VALUES(?,?,?,?,?,?,?,?,?,?,?);";
- // other
- public string passDb = "PRAGMA hexkey=\"0x0102030405060708090a0b0c0d0e0f10\";";
- private SQLiteDB db = null;
- // Use this for initialization
- void Start()
- {
- createTable("DataGameTest", "Boss", tbl_Boss, tbl_BossSelect, tbl_BossInsert);
- getTable("DataGameTest", "Boss", tbl_BossSelect);
- }
- private void createTable(string nameDb, string nameTable, string queryCreate, string querySelect, string queryInsert)
- {
- string pass = passDb;
- db = new SQLiteDB();
- string filename = Application.persistentDataPath + "/" + nameDb;
- File.Delete(filename);
- db.Open(filename);
- //
- // set ENCRYPTION
- //
- SQLiteQuery qr = new SQLiteQuery(db, pass);
- qr.Step();
- qr.Release();
- //
- // create table
- //
- qr = new SQLiteQuery(db, queryCreate);
- qr.Step();
- qr.Release();
- print("Create ok --> " + nameDb + " -- " + nameTable);
- //
- // insert data
- //
- if (nameTable == "Boss") insertBoss(db);
- // close
- db.Close();
- }
- //
- // get data
- //
- private void getTable(string nameDb, string nameTable, string querySelect)
- {
- try
- {
- string pass = passDb;
- string filename = Application.persistentDataPath + "/" + nameDb;
- SQLiteDB db = new SQLiteDB();
- // and open again
- db.Open(filename);
- //
- // set ENCRYPTION AGAIN, you could try change to see ENCRYPTION works
- //
- SQLiteQuery qr = new SQLiteQuery(db, pass);
- qr.Step();
- qr.Release();
- print("Chuan bi lay du lieu ok" + nameDb + " >> " + nameTable);
- qr = new SQLiteQuery(db, querySelect);
- while (qr.Step())
- {
- print("Get data ok" + nameDb + " >> " + nameTable);
- if (nameTable == "Boss")
- {
- print("Boss >> id_boss= " + qr.GetInteger("id_boss"));
- }
- }
- qr.Release();
- db.Close();
- }
- catch (Exception e)
- {
- print(e.Message);
- }
- }
- //
- // insert data
- //
- private void insertBoss(SQLiteDB db3)
- {
- int i = 0;
- while (i <= 100)
- {
- i++;
- SQLiteQuery qr2 = new SQLiteQuery(db3, tbl_BossInsert);
- qr2.Bind(i);
- qr2.BindNull();
- qr2.BindNull();
- qr2.BindNull();
- qr2.BindNull();
- qr2.BindNull();
- qr2.BindNull();
- qr2.BindNull();
- qr2.BindNull();
- qr2.BindNull();
- qr2.BindNull();
- qr2.Step();
- qr2.Release();
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement