Sql数据库在Unity中的使用

SqlManager的单例类

  这里在写了一个SqlManager类的单例来实现Sql方法在Unity中的使用,Sql语句基本的增删查改语言在我的另外一篇博客里面有记录( Sql安装及Sql增删查改)https://blog.csdn.net/weixin_43492764/article/details/88393806
  代码如下:

using System.Collections;
using System.Collections.Generic;
using UnityEngine;
using Mono.Data.Sqlite;
using System;
public class SqlManager
{
    #region 单例模式
    //SqlManager的一个单例
    private static SqlManager instance;
    public static SqlManager GetInstance()
    {
        if (instance == null)
        {
            instance = new SqlManager();
        }
        return instance;
    }
    private SqlManager()
    {
    }
    #endregion

    #region sqlite数据库的一些基础操作方法的封装
    /// <summary>
    /// Sqlite数据库的一些基础操作的封装
    /// </summary>
    private SqliteConnection connect;//数据连接对象
    private SqliteCommand command;//sql指令对象
    private SqliteDataReader reader;//数据读取对象


    /// <summary>
    /// 打开Sqlite数据库连接的方法
    /// </summary>
    ///<param name="dataBaseName">数据库名称</param>
	public void OpenDataBase(string dataBaseName)
    {
        if (!dataBaseName.Contains(".sqlite"))
        {
            dataBaseName += ".sqlite";
        }
        //数据库路径拼接   string类型
        string dataPath = "Data Source =" + Application.streamingAssetsPath +"/"+ dataBaseName;
        //对数据库连接对象进行赋值
        connect = new SqliteConnection(dataPath);
        //对sql指令对象进行赋值
        command = connect.CreateCommand();
        //打开数据路连接
        connect.Open();

    }
    /// <summary>
    /// 关闭数据路
    /// </summary>
    public void CloseDataBase()
    {
        try
        {
            connect.Close();
            if (reader != null)
            {
                reader.Close();
            }
        }
        catch (SqliteException ex)
        {
            Debug.LogError(ex.ToString());
        }
    }
    /// <summary>
    /// 执行非查询的工作(增删改三个不需要返回值的工作)
    /// </summary>
    ///<param name="sql">sql指令</param>
    public void RunNoneQuery(string sql)
    {
        try
        {
            command.CommandText = sql;
            command.ExecuteNonQuery();
        }
        catch (SqliteException ex)
        {
            Debug.Log(ex.ToString());            
        }
    }
    /// <summary>
    /// 查询单个数据
    /// </summary>
    /// <param name="sql">sql指令</param>
    /// <returns></returns>
    public object SelectSingleData(string sql)
    {
        try
        {
            command.CommandText = sql;
            object obj = command.ExecuteScalar();
            return obj;
        }
        catch (SqliteException ex)
        {
            Debug.Log(ex.ToString());
            return null;
        }
    }
    /// <summary>
    /// 查询多个数据
    /// </summary>
    /// <param name="sql">sql指令</param>
    /// <returns></returns>
    public List<ArrayList> SelectMutidata(string sql)
    {
        try
        {
            List<ArrayList> result = new List<ArrayList>();
            command.CommandText = sql;
            reader = command.ExecuteReader();
            while (reader.Read())
            {
                ArrayList temp = new ArrayList();                                                                                                                                                                                                                                                      
                for (int i = 0; i < reader.FieldCount; i++)
                {
                    temp.Add(reader.GetValue(i));
                }
                result.Add(temp);
            }
            reader.Close();
            return result;
        }
        catch (SqliteException ex)
        {
            Debug.Log(ex.ToString());
            return null;
        }
    }
    #endregion

    #region 当前项目的一些常用方法的封装

    #endregion
}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141