{"id":146,"date":"2015-04-11T10:16:29","date_gmt":"2015-04-11T02:16:29","guid":{"rendered":"http:\/\/qxu1606620110.my3w.com\/?p=146"},"modified":"2016-10-11T09:34:52","modified_gmt":"2016-10-11T01:34:52","slug":"sqllitehelper-sqllite%e6%95%b0%e6%8d%ae%e5%ba%93%e5%b0%81%e8%a3%85api","status":"publish","type":"post","link":"http:\/\/www.u3d8.com\/?p=146","title":{"rendered":"SqlLiteHelper\u2014SqlLite\u6570\u636e\u5e93\u5c01\u88c5API"},"content":{"rendered":"<p>SqlLiteHelper\u5185\u5bb9<\/p>\n<pre class=\"lang:c# decode:true \" title=\"SqlLiteHelper\u5185\u5bb9\" >using UnityEngine;\r\nusing System.Collections;\r\nusing Mono.Data.Sqlite;\r\nusing System.Text;\r\n\/\/\/ &lt;summary&gt;\r\n\/\/\/ \u5b57\u6bb5\u7c7b\u578b\r\n\/\/\/ &lt;\/summary&gt;\r\npublic static class SqlLiteHelper\r\n{\r\n    public static SqliteConnection dbConnection;\r\n    public static SqliteCommand dbCommand;\r\n    public static string conStr = \"Data Source=\" + Application.dataPath + \"\/Data\/data.db\" ;\r\n    \/\/\/ &lt;summary&gt;\r\n    \/\/\/ \u9ed8\u8ba4\u6784\u9020\u51fd\u6570\u6253\u5f00\u6570\u636e\u5e93 \u521b\u5efa\u6570\u636e\u5e93\u6307\u4ee4\r\n    \/\/\/ &lt;\/summary&gt;\r\n    public static void Initialize(){\r\n        dbConnection = new SqliteConnection (conStr);\r\n        dbConnection.Open();\r\n        dbCommand = dbConnection.CreateCommand();\r\n    }\r\n    public static void Create(string _TableName, string[] _ColsName, string [] _ColsType) {\r\n        try {\r\n            string query = \"create table \" + _TableName + \" (\" + _ColsName[0] + \" \" + _ColsType[0];\r\n            for (int i = 1; i &lt; _ColsName.Length; i++)\r\n            {\r\n                query += \", \" + _ColsName[i] + \" \" + _ColsType[i];\r\n            }\r\n            query += \")\";\r\n            ExecuteQuery(query);\r\n        }\r\n        catch {\r\n            Debug.Log(\"\u521b\u5efa\u5931\u8d25\" );\r\n        }\r\n    }\r\n    \/\/\/ &lt;summary&gt;\r\n    \/\/\/ \u63d2\u5165\u6570\u636e\r\n    \/\/\/ \u53c2\u6570\uff1a\u8868\u540d\u79f0\u3001\u503c\r\n    \/\/\/ \u7279\u70b9\uff1a\u4e0d\u9002\u7528\u81ea\u52a8ID\r\n    \/\/\/ &lt;\/summary&gt;\r\n    public static void Insert(string _TableName, string[] _Values) {\r\n        try {\r\n            string query = \"insert into \" + _TableName + \" values(\" + _Values[0];\r\n         \r\n            for (int i = 1; i &lt; _Values.Length; i++)\r\n            {\r\n                query += \",\" + _Values[i];\r\n            }\r\n            query += \")\";\r\n            ExecuteQuery(query);\r\n        }\r\n        catch {\r\n            Debug.Log(\"\u6dfb\u52a0\u5931\u8d25\" );\r\n        }\r\n    }\r\n    \/\/\/ &lt;summary&gt;\r\n    \/\/\/ \u4fee\u6539\u6570\u636e\r\n    \/\/\/ \u53c2\u6570\uff1a\u8868\u540d\u79f0\u3001\u51c6\u5907\u4fee\u6539\u7684\u5c5e\u6027\u5217\u3001\u51c6\u5907\u4fee\u6539\u7684\u5c5e\u6027\u5217\u7684\u503c\u3001\u6761\u4ef6\u4fe1\u606f\u5c5e\u6027\u5217\u3001\u6761\u4ef6\u4fe1\u606f\u5c5e\u6027\u5217\u7684\u503c\r\n    \/\/\/ &lt;\/summary&gt;\r\n    public static void Update(string _TableName, string[] _SetColsName, string [] _SetColsValues, string _ConditionColName, string _ConditionColValue) {\r\n        try {\r\n            string query = \"update \" + _TableName + \" set \" + _SetColsName[0] + \" = \" + _SetColsValues[0];\r\n            for (int i = 1; i &lt; _SetColsValues.Length; i++)\r\n            {\r\n                query += \",\" + _SetColsName[i] + \" = \" + _SetColsValues[i];\r\n            }\r\n            query += \" where \" + _ConditionColName + \" = \" + _ConditionColValue;\r\n            ExecuteQuery(query);\r\n        } catch\r\n        {\r\n            Debug.Log(\"\u4fee\u6539\u5931\u8d25\" );\r\n        }\r\n    }\r\n    \/\/\/ &lt;summary&gt;\r\n    \/\/\/ \u67e5\u8be2\u6570\u636e\r\n    \/\/\/ \u53c2\u6570\uff1a\u8868\u540d\u79f0\u3001\u67e5\u8be2\u5185\u5bb9\r\n    \/\/\/ &lt;\/summary&gt;\r\n    public static SqliteDataReader Select(string _TableName, string _Select) {\r\n        try {\r\n            string query = \"select \" + _Select + \" from \" + _TableName;\r\n            dbCommand.CommandText = query;\r\n            dbCommand.ExecuteNonQuery();\r\n            return dbCommand.ExecuteReader();\r\n        }\r\n        catch {\r\n            Debug.Log(\"\u67e5\u8be2\u5931\u8d25\" );\r\n            return null ;\r\n        }\r\n    }\r\n    \/\/\/ &lt;summary&gt;\r\n    \/\/\/ \u67e5\u8be2\u6570\u636e\r\n    \/\/\/ \u53c2\u6570\uff1a\u8868\u540d\u79f0\u3001\u67e5\u8be2\u5185\u5bb9\u3001\u67e5\u8be2\u6761\u4ef6\r\n    \/\/\/ &lt;\/summary&gt;\r\n    public static SqliteDataReader Select(string _TableName, string _Select, string _Condition) {\r\n        try {\r\n            string query = \"select \" + _Select + \" from \" + _TableName + \" where \" + _Condition;\r\n            dbCommand.CommandText = query;\r\n            dbCommand.ExecuteNonQuery();\r\n            return dbCommand.ExecuteReader();\r\n        }\r\n        catch {\r\n            Debug.Log(\"\u67e5\u8be2\u5931\u8d25\" );\r\n            return null ;\r\n        }\r\n    }\r\n    \/\/\/ &lt;summary&gt;\r\n    \/\/\/ \u5220\u9664\u6570\u636e\r\n    \/\/\/ \u53c2\u6570\uff1a\u8868\u540d\u79f0\u3001\u5c5e\u6027\u5217\u3001\u503c\r\n    \/\/\/ &lt;\/summary&gt;\r\n    public static void Delete(string _TableName, string _ColName, string _ColValue) {\r\n        try {\r\n            string query = \"delete from \" + _TableName + \" where \" + _ColName + \" = \" + _ColValue;\r\n            ExecuteQuery(query);\r\n        }\r\n        catch {\r\n            Debug.Log(\"\u5220\u9664\u5931\u8d25\" );\r\n        }\r\n    }\r\n    \/\/\/ &lt;summary&gt;\r\n    \/\/\/ \u5173\u95ed\u6570\u636e\u5e93\u8fde\u63a5\r\n    \/\/\/ &lt;\/summary&gt;\r\n    public static void Close() {\r\n        try {\r\n            dbConnection.Close();\r\n        }\r\n        catch {\r\n            Debug.Log(\"\u5173\u95ed\u5931\u8d25\" );\r\n        }\r\n    }\r\n    public static void ExecuteQuery(string sqlQuery) {\r\n        dbCommand.CommandText = sqlQuery;\r\n        dbCommand.ExecuteNonQuery();\r\n    }\r\n}\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>SqlLiteHelper\u5185\u5bb9 using UnityEngine; using &hellip; <a href=\"http:\/\/www.u3d8.com\/?p=146\">\u7ee7\u7eed\u9605\u8bfb <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[24],"tags":[31,34,33,32],"_links":{"self":[{"href":"http:\/\/www.u3d8.com\/index.php?rest_route=\/wp\/v2\/posts\/146"}],"collection":[{"href":"http:\/\/www.u3d8.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.u3d8.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.u3d8.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.u3d8.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=146"}],"version-history":[{"count":3,"href":"http:\/\/www.u3d8.com\/index.php?rest_route=\/wp\/v2\/posts\/146\/revisions"}],"predecessor-version":[{"id":758,"href":"http:\/\/www.u3d8.com\/index.php?rest_route=\/wp\/v2\/posts\/146\/revisions\/758"}],"wp:attachment":[{"href":"http:\/\/www.u3d8.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=146"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.u3d8.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=146"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.u3d8.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=146"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}