Unity 使用SQLlite数据库（一）

最新推荐文章于 2024-08-26 22:32:00 发布

iukam

最新推荐文章于 2024-08-26 22:32:00 发布

阅读量2k

点赞数 1

分类专栏： Unity 文章标签： unity 数据库 SqlLite mysql oracle

本文链接：https://blog.csdn.net/qq_40120946/article/details/100558714

版权

Unity 专栏收录该内容

24 篇文章 5 订阅

订阅专栏

前期准备工作可参考：https://blog.csdn.net/qq_37067895/article/details/85396269
https://blog.csdn.net/qinyuanpei/article/details/46812655

或者从下面链接中可获取DLL包工具

然后利用SQLLiteStudio，创建一个数据库

之后，把MyTestDB.dll导到unity项目中如下：

接下来，也把SQLlite三件套也导入unity项目中：

剩下的就是代码部分，

数据必要有的---增删查改，.这里先做个基类如下：

/*******************************************************************
* 作者:     # maki #
* 创建日期: #2019年9月5日17:02:49  #
* 描述:  数据库操作接口
******************************************************************/
using System.Collections.Generic;
using System.Data;

namespace DataBaseTool
{
    public interface IDataBase
    {
        /// <summary>
        /// 打开数据库
        /// </summary>
        /// <param name="sqlUrl"></param>
        void Open(string sqlUrl);
        /// <summary>
        /// 关闭数据库
        /// </summary>
        void Close();
        /// <summary>
        /// 开始使用事务，在停止使用事务前，通过ReplaceValues保存数据的SQL命令会集中起来，等待停止事务后一起执行命令
        /// </summary>
        void StartTransaction();
        /// <summary>
        /// 停止使用事务
        /// </summary>
        void StopTransaction();
        /// <summary>
        /// 检查数据表是否存在
        /// </summary>
        /// <param name="tableName">表名</param>
        /// <returns></returns>
        bool CheckTableIsExist(string tableName);
        /// <summary>
        /// 创建数据表
        /// </summary>
        /// <param name="tableName"></param>
        /// <param name="colNames"></param>
        /// <param name="colTypes"></param>
        void CreatTable(string tableName, string[] colNames, string[] colTypes);

        /// <summary>
        /// 更新或者保存数据
        /// </summary>
        /// <param name="tableName">表名</param>
        /// <param name="colNames">字段名集合</param>
        /// <param name="colValues">数据集合</param>
        /// <returns></returns>
        bool UpdateOrSave(string tableName, string[] colNames, object[] colValues);
        /// <summary>
        /// 更新或者保存数据 - 针对集合数据
        /// </summary>
        /// <param name="tableName">表名</param>
        /// <param name="listColNames">字段名集合</param>
        /// <param name="listColValues">数据集合</param>
        /// <returns></returns>
        bool UpdateOrSave(string tableName, List<string[]> listColNames, List<object[]> listColValues);
        /// <summary>
        /// 删除符合任一条件的数据
        /// </summary>
        /// <param name="tableName">表名</param>
        /// <param name="colNames">字段名集合</param>
        /// <param name="operations">比较符号集合</param>
        /// <param name="colValues">数据集合</param>
        /// <returns></returns>
        bool DeleteAnyone(string tableName, string[] colNames, string[] operations, string[] colValues);
        /// <summary>
        /// 删除符合所有条件的数据
        /// </summary>
        /// <param name="tableName">表名</param>
        /// <param name="colNames">字段名集合</param>
        /// <param name="operations">比较符号集合</param>
        /// <param name="colValues">数据集合</param>
        /// <returns></returns>
        bool DeleteEveryone(string tableName, string[] colNames, string[] operations, string[] colValues);
        /// <summary>
        /// 获取符合任一条件的数据
        /// </summary>
        /// <typeparam name="T"></typeparam>
        /// <param name="tableName">表名</param>
        /// <param name="colNames">字段名集合</param>
        /// <param name="operations">比较符号集合</param>
        /// <param name="colValues">数据集合</param>
        /// <returns></returns>
        List<T> GetAnyone<T>(string tableName, string[] colNames, string[] operations, string[] colValues);
        /// <summary>
        /// 获取符合全部条件的数据
        /// </summary>
        /// <typeparam name="T"></typeparam>
        /// <param name="tableName">表名</param>
        /// <param name="colNames">字段名集合</param>
        /// <param name="operations">比较符号集合</param>
        /// <param name="colValues">数据集合</param>
        /// <returns></returns>
        List<T> GetEveryone<T>(string tableName, string[] colNames, string[] operations, string[] colValues);
        /// <summary>
        /// 获取该表所有数据
        /// </summary>
        /// <typeparam name="T"></typeparam>
        /// <param name="tableName">表名</param>
        /// <returns></returns>
        List<T> GetAll<T>(string tableName);
        /// <summary>
        /// 获取符合任一条件的某些字段的数据
        /// </summary>
        /// <param name="tableName">表名</param>
        /// <param name="items">需要获取数据的字段名集合</param>
        /// <param name="colNames">字段名集合</param>
        /// <param name="operations">比较符号集合</param>
        /// <param name="colValues">数据集合</param>
        /// <returns></returns>
        List<List<object>> GetForAnyone(string tableName, string[] items, string[] colNames, string[] operations, string[] colValues);
        /// <summary>
        /// 获取符合全部条件的某些字段的数据
        /// </summary>
        /// <param name="tableName">表名</param>
        /// <param name="items">需要获取数据的字段名集合</param>
        /// <param name="colNames">字段名集合</param>
        /// <param name="operations">比较符号集合</param>
        /// <param name="colValues">数据集合</param>
        /// <returns></returns>
        List<List<object>> GetForEveryone(string tableName, string[] items, string[] colNames, string[] operations, string[] colValues);
        /// <summary>
        /// 获取某数据表的所有字段
        /// </summary>
        /// <param name="tableName">表名</param>
        /// <returns></returns>
        List<string> GetTableAllFields(string tableName);
        /// <summary>
        /// 获取所有数据表
        /// </summary>
        /// <returns></returns>
        List<string> GetAllTableName();
        /// <summary>
        /// 获取表的相关信息
        /// </summary>
        /// <param name="tableName">表名</param>
        /// <returns></returns>
        DataTable GetTableInfo(string tableName);
    }

}

之后，利用sqllite库写的管理类：

/*******************************************************************
* 作者:     # maki  #
* 创建日期: # 2019年9月5日17:18:52 #
* 描述:  sqllite 数据库管理类
******************************************************************/
using Mono.Data.Sqlite;
using System;
using System.Collections.Generic;
using System.Data;
using System.Reflection;
using System.Text;
using UnityEngine;

namespace DataBaseTool
{
    public class SqlLiteManager : IDataBase
    {

        /// <summary>
        /// 数据库连接
        /// </summary>
        private SqliteConnection dbConnection = null;

        /// <summary>
        /// SQL命令
        /// </summary>
        private SqliteCommand dbCommand = null;

        /// <summary>
        /// 数据读取
        /// </summary>
        private SqliteDataReader dataReader = null;

        private SqliteParameter myParameter;

        /// <summary>
        /// 事务
        /// </summary>
        private SqliteTransaction transaction;

        /// <summary>
        /// 是否开始事务
        /// </summary>
        private bool isStartUseTransaction;

        /// <summary>
        /// 打开数据库
        /// </summary>
        public void Open(string sqlUrl)
        {
            try
            {
                //构造数据库连接
                dbConnection = new SqliteConnection(sqlUrl);
                //打开数据库
                dbConnection.Open();
            }
            catch (Exception e)
            {
                Debug.Log(e.Message);
            }
        }
        /// <summary>
        /// 关闭数据库
        /// </summary>
        public void Close()
        {
            //销毁Command
            if (dbCommand != null) dbCommand.Cancel();
            //销毁Reader
            if (dataReader != null) dataReader.Close();
            //销毁Connection
            if (dbConnection != null) dbConnection.Close();

            dbCommand = null;
            dataReader = null;
            dbConnection = null;
            Debug.Log("关闭数据库");
        }

        /// <summary>
        /// 执行SQL命令
        /// </summary>
        /// <param name="queryString">SQL命令字符串</param>
        /// <returns></returns>
        public SqliteDataReader ExecuteQuery(string queryString)
        {
            dbCommand = dbConnection.CreateCommand();
            dbCommand.CommandText = queryString;
            dataReader = dbCommand.ExecuteReader();
            return dataReader;
        }
        /// <summary>
        /// 执行SQL命令
        /// </summary>
        /// <param name="queryString">SQL命令字符串</param>
        /// <param name="content">SQL命令字符串</param>
        /// <returns></returns>
        public void ExecuteQuery(string queryString, SqliteParameter[] content)
        {
            dbCommand = dbConnection.CreateCommand();
            dbCommand.CommandText = queryString;
            dbCommand.Parameters.AddRange(content);

            /**ExecuteNonQuery方法主要用来更新数据，
             * 当然也可以用来执行目标操作
             * （例如查询数据库的结构或者创建诸如表等的数据库对象）。
             * 通常用它来执行insert、update、delete语句，
             * 在不使用Dataset的情况下更改数据库中的数据。
             * select语句不适合ExecuteNonQuery()方法。
             * 文档地址：https://www.cnblogs.com/erhanhan/p/8270052.html
             * **/
            dbCommand.ExecuteNonQuery();
        }

        /// <summary>
        /// 读取整张数据表
        /// </summary>
        /// <returns>The full table.</returns>
        /// <param name="tableName">数据表名称</param>
        public SqliteDataReader ReadFullTable(string tableName)
        {
            string queryString = "SELECT * FROM " + tableName;
            return ExecuteQuery(queryString);
        }

        /****************************   事务操作   ************************************/

        /// <summary>
        /// 开始使用事务，在停止使用事务前，通过ReplaceValues保存数据的SQL命令会集中起来，等待停止事务后一起执行命令
        /// </summary>
        public void StartTransaction()
        {
            isStartUseTransaction = true;
            dbCommand = dbConnection.CreateCommand();
            transaction = dbConnection.BeginTransaction();
        }
        /// <summary>
        /// 停止使用事务
        /// </summary>
        public void StopTransaction()
        {
            isStartUseTransaction = false;
            transaction.Commit();
        }

        /****************************   对表操作   ************************************/

        /// <summary>
        /// 检查数据表是否存在
        /// </summary>
        public bool CheckTableIsExist(string tableName)
        {
            dbCommand = dbConnection.CreateCommand();
            dbCommand.CommandText = "SELECT COUNT(*) FROM sqlite_master where type='table' and name='" + tableName + "';";
            if (0 == Convert.ToInt32(dbCommand.ExecuteScalar()))
            {
                return false;
            }
            else
            {
                return true;
            }
        }
        /// <summary>
        /// 创建数据表
        /// </summary>
        public void CreatTable(string tableName, string[] colNames, string[] colTypes)
        {
            string queryString = "CREATE TABLE " + tableName + "( " + colNames[0] + " " + colTypes[0];
            for (int i = 1; i < colNames.Length; i++)
            {
                queryString += ", " + colNames[i] + " " + colTypes[i];
            }
            queryString += "  ) ";
            ExecuteQuery(queryString);
        }

        /****************************   更新或者保存数据    ************************************/

        /// <summary>
        /// 更新或者保存数据
        /// </summary>
        public bool UpdateOrSave(string tableName, string[] colNames, object[] colValues)
        {
            try
            {
                string queryString = "REPLACE INTO " + tableName + "(" + colNames[0];
                for (int i = 1; i < colNames.Length; i++)
                {
                    queryString += "," + colNames[i];
                }

                queryString += ") VALUES (" + "@" + colNames[0];
                for (int j = 1; j < colNames.Length; j++)
                {
                    queryString += "," + "@" + colNames[j];
                }
                queryString += ")";

                SqliteParameter[] parameters = new SqliteParameter[colNames.Length];
                for (int k = 0; k < parameters.Length; k++)
                {
                    parameters[k] = new SqliteParameter("@" + colNames[k], colValues[k]);
                }

                if (isStartUseTransaction)
                {
                    // 累积SQL执行语句
                    dbCommand.CommandText = queryString;
                    dbCommand.Parameters.AddRange(parameters);
                    dbCommand.ExecuteNonQuery();
                }
                else
                {
                    ExecuteQuery(queryString, parameters);
                }
                return true;
            }
            catch (Exception e)
            {
                Debug.Log(e);
                return false;
            }
        }
        /// <summary>
        /// 更新或者保存数据
        /// </summary>
        public bool UpdateOrSave(string tableName, List<string[]> listColNames, List<object[]> listColValues)
        {
            try
            {
                System.Diagnostics.Stopwatch watch = new System.Diagnostics.Stopwatch();
                watch.Start();
                string[] colNames = listColNames[0];

                StringBuilder sb = new StringBuilder();
                sb.AppendFormat("REPLACE INTO {0}({1}", tableName, colNames[0]);
                for (int i = 1; i < colNames.Length; i++)
                {
                    sb.Append(",").Append(colNames[i]);
                }

                sb.Append(") VALUES (@").Append(colNames[0]);
                for (int j = 1; j < colNames.Length; j++)
                {
                    sb.Append(",@").Append(colNames[j]); ;
                }
                sb.Append(")");

                dbCommand = dbConnection.CreateCommand();
                dbCommand.CommandText = sb.ToString();

                var transaction = dbConnection.BeginTransaction();
                SqliteParameter[] parameters;
                for (int i1 = 0; i1 < listColNames.Count; i1++)
                {
                    parameters = new SqliteParameter[colNames.Length];
                    for (int k = 0; k < parameters.Length; k++)
                    {
                        parameters[k] = new SqliteParameter("@" + colNames[k], listColValues[i1][k]);
                    }

                    dbCommand.Parameters.AddRange(parameters);
                    dbCommand.ExecuteNonQuery();
                }
                transaction.Commit();

                watch.Stop();
                Debug.Log(watch.Elapsed);
                return true;
            }
            catch (Exception e)
            {
                Debug.Log(e);
                return false;
            }
        }

        /****************************  删除符合条件的数据    ************************************/

        /// <summary>
        /// 删除符合任一条件的数据
        /// </summary>
        public bool DeleteAnyone(string tableName, string[] colNames, string[] operations, string[] colValues)
        {
            try
            {
                //当字段名称和字段数值不对应时引发异常
                if (colNames.Length != colValues.Length || operations.Length != colNames.Length || operations.Length != colValues.Length)
                {
                    throw new SqliteException("colNames.Length!=colValues.Length || operations.Length!=colNames.Length || operations.Length!=colValues.Length");
                }

                StringBuilder sb = new StringBuilder();
                sb.AppendFormat("DELETE FROM {0} WHERE {1}{2}'{3}'", tableName, colNames[0], operations[0], colValues[0]);
                for (int i = 1; i < colValues.Length; i++)
                {
                    sb.AppendFormat("OR {0}{1}'{2}'", colNames[i], operations[i], colValues[i]);
                }

                ExecuteQuery(sb.ToString());
                return true;
            }
            catch (Exception e)
            {
                Debug.Log(e);
                return false;
            }
        }
        /// <summary>
        /// 删除符合所有条件的数据
        /// </summary>
        public bool DeleteEveryone(string tableName, string[] colNames, string[] operations, string[] colValues)
        {
            try
            {
                //当字段名称和字段数值不对应时引发异常
                if (colNames.Length != colValues.Length || operations.Length != colNames.Length || operations.Length != colValues.Length)
                {
                    throw new SqliteException("colNames.Length!=colValues.Length || operations.Length!=colNames.Length || operations.Length!=colValues.Length");
                }

                string queryString = "DELETE FROM " + tableName + " WHERE " + colNames[0] + operations[0] + "'" + colValues[0] + "'";
                for (int i = 1; i < colValues.Length; i++)
                {
                    queryString += " AND " + colNames[i] + operations[i] + "'" + colValues[i] + "'";
                }
                ExecuteQuery(queryString);
                return true;
            }
            catch (Exception e)
            {
                Debug.Log(e);
                return false;
            }
        }

        /****************************  获取该表数据    ************************************/

        /// <summary>
        /// 获取该表所有数据
        /// </summary>
        public List<T> GetAll<T>(string tableName)
        {
            string queryString = "SELECT * FROM " + tableName;
            return GetValues<T>(queryString);
        }
        /// <summary>
        /// 获取符合任一条件的数据
        /// </summary>
        public List<T> GetAnyone<T>(string tableName, string[] colNames, string[] operations, string[] colValues)
        {
            try
            {
                string queryString = "SELECT * FROM " + tableName + " WHERE " + colNames[0] + operations[0] + "'" + colValues[0] + "'";
                for (int i = 1; i < colNames.Length; i++)
                {
                    queryString += " OR " + colNames[i] + operations[i] + "'" + colValues[i] + "'";
                }
                return GetValues<T>(queryString);
            }
            catch (Exception e)
            {
                Debug.Log(e);
                return new List<T>();
            }
        }
        /// <summary>
        /// 获取符合全部条件的数据
        /// </summary
        public List<T> GetEveryone<T>(string tableName, string[] colNames, string[] operations, string[] colValues)
        {
            try
            {
                string queryString = "SELECT * FROM " + tableName + " WHERE " + colNames[0] + operations[0] + "'" + colValues[0] + "'";
                for (int i = 1; i < colNames.Length; i++)
                {
                    queryString += " AND " + colNames[i] + operations[i] + "'" + colValues[i] + "'";
                }
                return GetValues<T>(queryString);
            }
            catch (Exception e)
            {
                Debug.Log(e);
                return new List<T>();
            }
        }
        /// <summary>
        /// 获取符合任一条件的某些字段的数据
        /// </summary>
        public List<List<object>> GetForAnyone(string tableName, string[] items, string[] colNames, string[] operations, string[] colValues)
        {
            try
            {
                string queryString = "SELECT " + items[0];
                for (int i = 1; i < items.Length; i++)
                {
                    queryString += ", " + items[i];
                }
                queryString += " FROM " + tableName + " WHERE " + colNames[0] + operations[0] + "'" + colValues[0] + "'";
                for (int i = 0; i < colNames.Length; i++)
                {
                    queryString += " OR " + colNames[i] + operations[i] + "'" + colValues[i] + "'";
                }

                return GetValuesForItems(queryString, items);
            }
            catch (Exception e)
            {
                Debug.Log(e);
                return new List<List<object>>();
            }
        }
        /// <summary>
        /// 获取符合全部条件的某些字段的数据
        /// </summary>
        public List<List<object>> GetForEveryone(string tableName, string[] items, string[] colNames, string[] operations, string[] colValues)
        {
            try
            {
                string queryString = "SELECT " + items[0];
                for (int i = 1; i < items.Length; i++)
                {
                    queryString += ", " + items[i];
                }
                queryString += " FROM " + tableName + " WHERE " + colNames[0] + operations[0] + "'" + colValues[0] + "'";
                for (int i = 0; i < colNames.Length; i++)
                {
                    queryString += " AND " + colNames[i] + operations[i] + "'" + colValues[i] + ",";
                }

                return GetValuesForItems(queryString, items);
            }
            catch (Exception e)
            {
                Debug.Log(e);
                return new List<List<object>>();
            }
        }

        /****************************  获取表，名 相关数据    ************************************/

        /// <summary>
        /// 获取某数据表的所有字段名
        /// </summary>
        public List<string> GetTableAllFields(string tableName)
        {
            string queryString = "Pragma Table_Info(" + tableName + ")";

            List<string> listFields = new List<string>();
            try
            {
                ExecuteQuery(queryString);

                while (dataReader.Read())
                {
                    listFields.Add(dataReader["Name"].ToString());
                }

                return listFields;
            }
            catch (Exception e)
            {
                Debug.Log(e);
                return listFields;
            }
        }
        /// <summary>
        /// 获取所有数据表名
        /// </summary>
        public List<string> GetAllTableName()
        {
            string queryString = "select name from sqlite_master where type= 'table' order by name";

            List<string> list = new List<string>();
            try
            {
                ExecuteQuery(queryString);

                while (dataReader.Read())
                {
                    list.Add(dataReader["Name"].ToString());
                }

                return list;
            }
            catch (Exception e)
            {
                Debug.Log(e);
                return list;
            }
        }
        /// <summary>
        /// 获取表的相关信息
        /// </summary>
        public DataTable GetTableInfo(string tableName)
        {
            DataTable dt = new DataTable();
            try
            {
                ReadFullTable(tableName);
                dt = dataReader.GetSchemaTable();
                return dt;
            }
            catch (Exception e)
            {
                Debug.Log(e);
                return dt;
            }
        }

        /****************************  其他处理数据    ************************************/

        /// <summary>
        /// 通过SQL语句获取数据
        /// </summary>
        /// <typeparam name="T"></typeparam>
        /// <param name="queryString">获取数据方式</param>
        /// <returns></returns>
        private List<T> GetValues<T>(string queryString)
        {
            try
            {
                List<string> fields = GetTableAllFields(typeof(T).Name);
                ExecuteQuery(queryString);

                PropertyInfo[] pros = typeof(T).GetProperties();
                List<T> listT = new List<T>();
                while (dataReader.Read())
                {
                    T t = Activator.CreateInstance<T>();
                    foreach (PropertyInfo item in pros)
                    {
                        //如果数据表不包含该字段，不读取
                        if (!fields.Contains(item.Name))
                            continue;

                        var result = dataReader.GetValue(dataReader.GetOrdinal(item.Name));
                        if (!string.IsNullOrEmpty(result.ToString()))
                        {
                            item.SetValue(t, Convert.ChangeType(result, item.PropertyType), null);
                        }
                    }
                    listT.Add(t);
                }
                return listT;
            }
            catch (Exception e)
            {
                Debug.Log(e);
                return new List<T>();
            }
        }
        /// <summary>
        /// 获取指定的某些字段数据
        /// </summary>
        /// <param name="queryString">SQL语句</param>
        /// <param name="items">要获取的字段</param>
        /// <returns></returns>
        private List<List<object>> GetValuesForItems(string queryString, string[] items)
        {
            try
            {
                ExecuteQuery(queryString);

                List<List<object>> list = new List<List<object>>();
                for (int i = 0; i < items.Length; i++)
                {
                    List<object> listTemp = new List<object>();
                    list.Add(listTemp);
                }

                while (dataReader.Read())
                {
                    for (int i = 0; i < items.Length; i++)
                    {
                        var result = dataReader.GetValue(dataReader.GetOrdinal(items[i]));
                        list[i].Add(result);
                    }
                }
                return list;
            }
            catch (Exception e)
            {
                Debug.Log(e);
                return new List<List<object>>();
            }
        }
    }
}

最后是写个可以调用的帮助类

/*******************************************************************
* 作者:     # maki #
* 创建日期: # 2019年9月5日18:05:56 #
* 描述: 数据库  SqlBase的帮助类  单例模式
******************************************************************/
using System.Collections;
using System.Collections.Generic;
using System.Data;
using System.Reflection;
using UnityEngine;

namespace DataBaseTool
{
    public class DataBaseHelper
    {
        private DataBaseHelper() { }
        private static DataBaseHelper instance;
        //单例
        public static DataBaseHelper Instance
        {
            get
            {
                if (instance == null)
                {
                    instance = new DataBaseHelper();
                }
                return instance;
            }
        }

        private IDataBase dbBase;

        /// <summary>
        /// 初始化数据库
        /// </summary>
        /// <param name="dbBase">用的是哪种数据库</param>
        public void Init(IDataBase dbBase, string loginSql)
        {
            this.dbBase = dbBase;
            this.dbBase.Open(loginSql);
        }
        /// <summary>
        /// 关闭数据库
        /// </summary>
        public void CloseDB()
        {
            if (dbBase != null)dbBase.Close();
        }

        /****************************   对表操作   ************************************/

        /// <summary>
        /// 检查数据库里是否存在数据表
        /// </summary>
        /// <param name="tableName">表名</param>
        /// <returns></returns>
        public bool CheckTableIsExist(string tableName)
        {
            if (dbBase.CheckTableIsExist(tableName))
            {
                return true;
            }
            Debug.Log("该类型对应的数据表不存在" + tableName);
            return false;
        }

        /// <summary>
        /// 创建一个表
        /// </summary>
        /// <typeparam name="T"></typeparam>
        /// <param name="colNames">字段名</param>
        /// <param name="operations">运算符</param>
        /// <param name="colValues">结果</param>
        /// <returns></returns>
        public bool CreatTable<T>(T t)
        {
            string tableName = typeof(T).Name;
            if (CheckTableIsExist(tableName))
            {
                Debug.Log(tableName);
                return false;
            }

            PropertyInfo[] pros = typeof(T).GetProperties();
            //要修改的字段集合
            List<string> colNames = new List<string>();
            //对应的内容
            List<string> colTypes = new List<string>();

            for (int i = 0; i < pros.Length; i++)
            {
                //判断属性的特性，具有某些特性的特殊处理
                object[] ob = pros[i].GetCustomAttributes(typeof(PropertySign), true);
                PropertyType proType = PropertyType.None;
                if (ob.Length > 0)
                    proType = ((PropertySign)ob[0]).fieldType;

                //如果属性特性为不存在数据库里，则跳过当前循环
                if (proType == PropertyType.NotInDataBase)
                    continue;

                //如果属性特性为不存在数据库里，则跳过当前循环
                if (proType == PropertyType.PrimaryKeyInDataBase)
                    continue;

                colNames.Add(pros[i].Name);
                var result = pros[i].PropertyType.Name;Debug.Log(result);
                colTypes.Add(result);
            }
            CreatTable(tableName, colNames.ToArray(), colTypes.ToArray());
            return true;
        }

        /// <summary>
        /// 创建一个表
        /// </summary>
        /// <typeparam name="T"></typeparam>
        /// <param name="colNames">字段名</param>
        /// <param name="operations">运算符</param>
        /// <param name="colValues">结果</param>
        /// <returns></returns>
        public void CreatTable(string tableName, string[] colNames, string[] colTypes)
        {
            dbBase.CreatTable(tableName, colNames, colTypes);
        }
        /****************************   保存或者更新   ************************************/

        /// <summary>
        /// 保存或者更新数据，数据库会判断ID是否已存在，存在则更新数据，不存在则插入数据
        /// </summary>
        /// <typeparam name="T">数据类型</typeparam>
        /// <param name="t">插入的数据实体</param>
        /// <returns></returns>
        public bool SaveOrUpdate<T>(T t)
        {
            string tableName = typeof(T).Name;
            if (!CheckTableIsExist(tableName))
            {
                Debug.Log(tableName);
                return false;
            }

            PropertyInfo[] pros = typeof(T).GetProperties();
            //要修改的字段集合
            List<string> colNames = new List<string>();
            //对应的内容
            List<object> colValues = new List<object>();

            for (int i = 0; i < pros.Length; i++)
            {
                //判断属性的特性，具有某些特性的特殊处理
                object[] ob = pros[i].GetCustomAttributes(typeof(PropertySign), true);
                PropertyType proType = PropertyType.None;
                if (ob.Length > 0)
                    proType = ((PropertySign)ob[0]).fieldType;

                //如果属性特性为不存在数据库里，则跳过当前循环
                if (proType == PropertyType.NotInDataBase)
                    continue;

                //如果属性特性为不存在数据库里，则跳过当前循环
                if (proType == PropertyType.PrimaryKeyInDataBase)
                    continue;

                colNames.Add(pros[i].Name);
                var result = pros[i].GetValue(t, null);
                colValues.Add(result);
            }
            return dbBase.UpdateOrSave(tableName, colNames.ToArray(), colValues.ToArray());
        }

        /// <summary>
        /// 保存或者更新数据，数据库会判断ID是否已存在，存在则更新数据，不存在则插入数据
        /// </summary>
        /// <typeparam name="T">数据类型</typeparam>
        /// <param name="tList">插入的数据实体集合</param>
        /// <returns></returns>
        public bool SaveOrUpdate<T>(List<T> tList)
        {
            string tableName = typeof(T).Name;
            if (!CheckTableIsExist(tableName))
            {
                return false;
            }

            PropertyInfo[] pros = typeof(T).GetProperties();

            List<string[]> listColNames = new List<string[]>();
            List<object[]> listColValues = new List<object[]>();

            foreach (var t in tList)
            {
                //要修改的字段集合
                List<string> colNames = new List<string>();
                //对应的内容
                List<object> colValues = new List<object>();

                for (int i = 0; i < pros.Length; i++)
                {
                    //判断属性的特性，具有某些特性的特殊处理
                    object[] ob = pros[i].GetCustomAttributes(typeof(PropertySign), true);
                    PropertyType proType = PropertyType.None;
                    if (ob.Length > 0)
                        proType = ((PropertySign)ob[0]).fieldType;

                    //如果属性特性为不存在数据库里，则跳过当前循环
                    if (proType == PropertyType.NotInDataBase)
                        continue;

                    //如果属性特性为不存在数据库里，则跳过当前循环
                    if (proType == PropertyType.PrimaryKeyInDataBase)
                        continue;

                    colNames.Add(pros[i].Name);
                    var result = pros[i].GetValue(t, null);
                    colValues.Add(result);
                }

                listColNames.Add(colNames.ToArray());
                listColValues.Add(colValues.ToArray());
            }

            return dbBase.UpdateOrSave(tableName, listColNames, listColValues);
        }


        /****************************   删除  ************************************/

        /// <summary>
        /// 删除指定UUID的数据
        /// </summary>
        /// <typeparam name="T"></typeparam>
        /// <param name="uuid">唯一标识符</param>
        /// <returns></returns>
        public bool DeleteById<T>(string id)
        {
            string tableName = typeof(T).Name;
            if (!CheckTableIsExist(tableName))
            {
                return false;
            }
            return dbBase.DeleteAnyone(tableName, new string[] { "id" }, new string[] { "=" }, new string[] { id });
        }
        /// <summary>
        /// 删除符合条件的数据
        /// </summary>
        /// <typeparam name="T"></typeparam>
        /// <param name="uuid">唯一标识符</param>
        /// <returns></returns>
        public bool DeleteByCondition<T>(string colName, string operation, string colValue)
        {
            string tableName = typeof(T).Name;
            if (!CheckTableIsExist(tableName))
            {
                return false;
            }
            return dbBase.DeleteAnyone(tableName, new string[] { colName }, new string[] { operation }, new string[] { colValue });
        }


        /****************************   获取  ************************************/

        /// <summary>
        /// 获取符合一个条件的对应一条数据
        /// </summary>
        /// <typeparam name="T"></typeparam>
        /// <param name="colName">字段名</param>
        /// <param name="operation">运算符</param>
        /// <param name="colValue">结果</param>
        /// <returns></returns>
        public T GetEveryone<T>(string colName, string operation, string colValue)
        {
            string[] colNames = new string[] { colName };
            string[] operations = new string[] { operation };
            string[] colValues = new string[] { colValue };

            var list = GetEveryone<T>(colNames, operations, colValues);
            if (list.Count > 0)
                return GetEveryone<T>(colNames, operations, colValues)[0];
            else
                return default(T);
        }

        / <summary>
        / 获取符合一个条件的对应数据
        / </summary>
        / <typeparam name="T"></typeparam>
        / <param name="colName">字段名</param>
        / <param name="operation">运算符</param>
        / <param name="colValue">结果</param>
        / <returns></returns>
        //public List<T> GetEveryone<T>(string colName, string operation, string colValue)
        //{
        //    string[] colNames = new string[] { colName };
        //    string[] operations = new string[] { operation };
        //    string[] colValues = new string[] { colValue };

        //    return GetEveryone<T>(colNames, operations, colValues);
        //}

        /// <summary>
        /// 获取符合全部条件的数据
        /// </summary>
        /// <typeparam name="T"></typeparam>
        /// <param name="colNames">字段名</param>
        /// <param name="operations">运算符</param>
        /// <param name="colValues">结果</param>
        /// <returns></returns>
        public List<T> GetEveryone<T>(string[] colNames, string[] operations, string[] colValues)
        {
            string tableName = typeof(T).Name;
            if (!CheckTableIsExist(tableName))
            {
                return default(List<T>);
            }
            return dbBase.GetEveryone<T>(tableName, colNames, operations, colValues);
        }

        /// <summary>
        /// 获取符合任一条件的数据
        /// </summary>
        /// <typeparam name="T"></typeparam>
        /// <param name="colNames">字段名</param>
        /// <param name="operations">运算符</param>
        /// <param name="colValues">结果</param>
        /// <returns></returns>
        public List<T> GetAnyone<T>(string[] colNames, string[] operations, string[] colValues)
        {
            string tableName = typeof(T).Name;
            if (!CheckTableIsExist(tableName))
            {
                return default(List<T>);
            }
            return dbBase.GetAnyone<T>(tableName, colNames, operations, colValues);
        }

        /// <summary>
        /// 获取一张表的所有数据
        /// </summary>
        /// <typeparam name="T"></typeparam>
        /// <returns></returns>
        public List<T> GetAll<T>()
        {
            string tableName = typeof(T).Name;
            if (!CheckTableIsExist(tableName))
            {
                return null;
            }
            return dbBase.GetAll<T>(tableName);
        }

        /// <summary>
        /// 获取指定的字段数据
        /// </summary>
        /// <param name="tableName">表名</param>
        /// <param name="item">要获取的字段数据</param>
        /// <param name="colName">字段名</param>
        /// <param name="operation">运算符</param>
        /// <param name="colValue">对应数据</param>
        /// <returns></returns>
        public List<object> GetValuesForItem<T>(string item, string colName, string operation, string colValue)
        {
            string[] items = new string[] { item };
            string[] colNames = new string[] { colName };
            string[] operations = new string[] { operation };
            string[] colValues = new string[] { colValue };

            return GetForEveryone<T>(items, colNames, operations, colValues)[0];
        }

        /// <summary>
        /// 获取符合所有条件的指定的某些字段数据
        /// </summary>
        /// <param name="tableName">表名</param>
        /// <param name="items">要获取的字段数据</param>
        /// <param name="colNames">字段名</param>
        /// <param name="operations">运算符</param>
        /// <param name="colValues">对应数据</param>
        /// <returns></returns>
        public List<List<object>> GetForEveryone<T>(string[] items, string[] colNames, string[] operations, string[] colValues)
        {
            string tableName = typeof(T).Name;
            if (!CheckTableIsExist(tableName))
            {
                return null;
            }

            return dbBase.GetForEveryone(tableName, items, colNames, operations, colValues);
        }

        /// <summary>
        /// 获取符合任一条件的指定的某些字段数据
        /// </summary>
        /// <param name="tableName">表名</param>
        /// <param name="items">要获取的字段数据</param>
        /// <param name="colNames">字段名</param>
        /// <param name="operations">运算符</param>
        /// <param name="colValues">对应数据</param>
        /// <returns></returns>
        public List<List<object>> GetForAnyone<T>(string[] items, string[] colNames, string[] operations, string[] colValues)
        {
            string tableName = typeof(T).Name;
            if (!CheckTableIsExist(tableName))
            {
                return null;
            }

            return dbBase.GetForAnyone(tableName, items, colNames, operations, colValues);
        }
        /****************************  获取表，名 相关数据    ************************************/

        /// <summary>
        /// 获取数据库所有表的名字
        /// </summary>
        /// <returns></returns>
        public List<string> GetAllTableName()
        {
            return dbBase.GetAllTableName();
        }

        /// <summary>
        /// 获取数据表的字段和字段类型
        /// </summary>
        /// <param name="tableName"></param>
        /// <returns></returns>
        public DataTable GetTableInfo(string tableName)
        {
            if (!CheckTableIsExist(tableName))
            {
                return null;
            }

            return dbBase.GetTableInfo(tableName);
        }
    }
}

这样的话，全部实现SQLlite的调用

然后，我们再写个测试类，看看效果

/*******************************************************************
* 作者:     # maki #
* 创建日期: # 2019年9月6日12:24:26 #
* 描述:  测试连接sqllite数据库
* 
* TODO：我用代码创建的表/数据在studio里面不显示，我在studio里面创建的表，在代码中添加数据，也不显示
* 
******************************************************************/
using System.Collections;
using System.Collections.Generic;
using UnityEngine;
using DataBaseTool;
using System;

public class SqlLiteTest : MonoBehaviour {
   
    private DataBaseHelper dbHelper;
    // Use this for initialization
    void Start () {
        string path = Application.streamingAssetsPath + "MyTest.db3";
        string url = "data source =" + path;
        dbHelper = DataBaseHelper.Instance;
        dbHelper.Init(new SqlLiteManager(), url);


        Student stu = new Student()
        {
            id = Guid.NewGuid().ToString(),
            name = "mmm",
            age = 22,
            grade = "七十一班",
            score = 32.5f,
        };

        ///**获取所有表名**/
        //var names = dbHelper.GetAllTableName(); Debug.Log(names.Count);
        //names.ForEach(u => Debug.Log(u));

        //   /**创建一个表**/

        //   var bo = dbHelper.CreatTable(stu);
        //   /**添加数据**/
          dbHelper.SaveOrUpdate(stu);
        //   /**获取数据**/
        var s = dbHelper.GetAll<Student>();
        Debug.Log(s.Count);


        //var m = dbHelper.GetAll<Teacher>(); Debug.Log(m.Count);
    }

    // Update is called once per frame
    void Update () {
		
	}
}
public class Student
{
    public string id { get; set; }
    public string name { get; set; }
    public int age { get; set; }
    public string grade { get; set; }
    public float score { get; set; }
}