Unity와 SQLite연동하기

<목차로 돌아가기>

SQLite와 Unity 연동하기

C:\Program Files\Unity\Editor\Data\Mono\lib\mono\2.0 여기에 있는

System.Data.dll 과 Mono.Data.Sqlite 를 복사

 Asset\Plugins에 붙여넣기

http://www.sqlite.org/download.html 여기에서 

sqlite3.def, sqlite3.dll를 다운받기

 Asset\Plugins에 넣기

Table 생성하기

1. using UnityEngine;
2. using System.Collections;
3. using System;
4. using System.Data;
5. using Mono.Data.Sqlite;
6. 
   
7. public class dbScript : MonoBehaviour {
8. 
   
9. void Start()
10.     {
11.         string conn = "URI=file:" + Application.dataPath + "/testDB.s3db"; //Path to database.
12.         IDbConnection dbconn;
13.         dbconn = (IDbConnection) new SqliteConnection(conn);
14.         dbconn.Open(); //Open connection to the database.
15. 
    
16.         IDbCommand dbcmd = dbconn.CreateCommand();
17.         string sqlQuery;
18.         sqlQuery = "CREATE TABLE COMPANY(";
19.         sqlQuery += "ID INT PRIMARY KEY     NOT NULL,";
20.         sqlQuery += "NAME           TEXT    NOT NULL,";
21.         sqlQuery += "AGE            INT     NOT NULL,";
22.         sqlQuery += "ADDRESS        CHAR(50),";
23.         sqlQuery += "SALARY         REAL";
24.         sqlQuery += ");";
25. 
    
26.         dbcmd.CommandText = sqlQuery;
27.         dbcmd.ExecuteNonQuery ();
28. 
    
29.         dbcmd.Dispose();
30.         dbcmd = null;
31.         dbconn.Close();
32.         dbconn = null;
33.     }
34. }

테이블에 데이터 넣기

1. using UnityEngine;
2. using System.Collections;
3. using System;
4. using System.Data;
5. using Mono.Data.Sqlite;
6. 
   
7. public class dbScript : MonoBehaviour {
8. 
   
9. void Start()
10.     {
11.         string conn = "URI=file:" + Application.dataPath + "/testDB.s3db"; //Path to database.
12.         IDbConnection dbconn;
13.         dbconn = (IDbConnection) new SqliteConnection(conn);
14.         dbconn.Open(); //Open connection to the database.
15. 
    
16.         IDbCommand dbcmd = dbconn.CreateCommand();
17.         string sqlQuery;
18.         sqlQuery = "INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY)";
19.         sqlQuery += "VALUES (1, 'Paul', 32, 'California', 20000.00 );";
20. 
    
21.         dbcmd.CommandText = sqlQuery;
22.         dbcmd.ExecuteNonQuery ();
23. 
    
24.         dbcmd.Dispose();
25.         dbcmd = null;
26.         dbconn.Close();
27.         dbconn = null;
28.     }
29. }

데이터 읽어오기

1. using UnityEngine;
2. using System.Collections;
3. using System;
4. using System.Data;
5. using Mono.Data.Sqlite;
6. 
   
7. public class dbScript : MonoBehaviour {
8. 
   
9. void Start()
10.     {
11.         string conn = "URI=file:" + Application.dataPath + "/testDB.s3db"; //Path to database.
12.         IDbConnection dbconn;
13.         dbconn = (IDbConnection)new SqliteConnection (conn);
14.         dbconn.Open (); //Open connection to the database.
15. 
    
16.         IDbCommand dbcmd = dbconn.CreateCommand ();
17.         string sqlQuery = "SELECT *" + "FROM COMPANY";
18.         dbcmd.CommandText = sqlQuery;
19.         IDataReader reader = dbcmd.ExecuteReader ();
20.         while (reader.Read ())
21.         {
22.             int ID = reader.GetInt32 (0);
23.             string NAME = reader.GetString (1);
24.             int AGE = reader.GetInt32 (2);
25.             string ADDRESS = reader.GetString (3);
26.             //ID,NAME,AGE,ADDRESS,SALARY
27.             Debug.Log ("ID= " + ID + "  NAME =" + NAME + "  AGE =" + AGE + "  ADDRESS =" + ADDRESS);
28.         }
29.         reader.Close ();
30.         reader = null;
31.         dbcmd.Dispose ();
32.         dbcmd = null;
33.         dbconn.Close ();
34.         dbconn = null;
35.     }
36. }