Unity简易数据库之Sqlite

最新推荐文章于 2023-08-31 18:06:23 发布

sweetzhoux

最新推荐文章于 2023-08-31 18:06:23 发布

阅读量456

点赞数

分类专栏： Unity 文件读写文章标签： unity C# 数据库 sqlite

本文链接：https://blog.csdn.net/sweetzhoux/article/details/50766547

版权

Unity简易数据库之Sqlite

摘要由CSDN通过智能技术生成

1:Sqlite类

2:Sqlite读取案例

using UnityEngine;

using System;
using System.Collections;
using Mono.Data.Sqlite;
using System.IO;

public class DbAccess
{


    public SqliteConnection dbConnection;

    public SqliteCommand dbCommand;

    public SqliteDataReader reader;

    public DbAccess(string connectionString)
    {

        OpenDB("Data Source=" + connectionString, "");

    }
    public DbAccess(string connectionString,string password)
    {

        OpenDB("Data Source=" + connectionString, password);

    }
    public DbAccess()
    {

    }

    public void OpenDB(string connectionString, string password)
    {
        try
        {
            /***********/
            if (!File.Exists(connectionString.Substring(12, connectionString.Length - 12)))
            {
                SqliteConnection.CreateFile(connectionString.Substring(12, connectionString.Length - 12));
            }
            /***********/
            dbConnection = new SqliteConnection(connectionString);
            if (!string.IsNullOrEmpty(password))
            {
                dbConnection.SetPassword(password);
            }
            dbConnection.Open();

           // Debug.Log("Connected to db :" + connectionString);
        }
        catch (Exception e)
        {
            string temp1 = e.ToString();
            Debug.Log(temp1);
        }

    }

    public void CloseSqlConnection()
    {

        if (dbCommand != null)
        {

            dbCommand.Dispose();

        }

        dbCommand = null;

        if (reader != null)
        {

            reader.Dispose();

        }

        reader = null;

        if (dbConnection != null)
        {

            dbConnection.Close();

        }

        dbConnection = null;

       // Debug.Log("Disconnected from db.");

    }

    /// <summary>
    /// 直接用的方法 推荐！！！
    /// </summary>
    /// <param name="sqlQuery"></param>
    /// <returns></returns>
    public SqliteDataReader ExecuteQuery(string sqlQuery)
    {
       // Debug.Log("SQL: " + sqlQuery);
        dbCommand = dbConnection.CreateCommand();

        dbCommand.CommandText = sqlQuery;



        reader = dbCommand.ExecuteReader();





        return reader;

    }


    public SqliteDataReader ReadFullTable(string tableName)
    {

        string query = "SELECT * FROM " + tableName;

        return ExecuteQuery(query);

    }



    public SqliteDataReader InsertInto(string tableName, string[] values)
    {

        string query = "INSERT INTO " + tableName + " VALUES (" &