1,需要用到这几个dll文件:Mono.Data.Sqlite.dll和sqlite3.dll和Mono.Data.SQLiteClient.dll
2,将这几个dll文件放在Plugins下,必须放这里。
3,在Player Setting里的 OtherSettings里有个Optimization 下边的API Compatbility Level 选择.NET 2.0。
4,添加个SQLiteHelper类。这个网上有,当然也可以自己写 - -!
5,数据库要放在 StreamingAssets这个文件夹下。
5,剩下的就是操作了
随便写点代码:
[code]csharpcode:
02 | using System.Collections; |
03 | using System.Collections.Generic; |
06 | using Mono.Data.SqliteClient; |
10 | public class DBHelp : MonoBehaviour { |
11 | static string conn= string .Empty; |
14 | public static string getConstr() |
19 | conn = "URI=file:" + Application.dataPath + "/StreamingAssets/KLandNG.db" ; |
26 | conn = "URI=file:" + Application.persistentDataPath + "/" + "daniya.db" ; |
34 | public static bool UpdateScoll() |
36 | int i = SqliteHelper.ExecuteNonQuery(getConstr(), CommandType.Text, |
37 | "update ItemInfo set name ='haha' where Type =1;" |