SQLite在unity下使用的工具类

最新推荐文章于 2024-08-09 07:01:10 发布

hacker9403

最新推荐文章于 2024-08-09 07:01:10 发布

阅读量637

点赞数

分类专栏： unity技术文章标签： sqlite unity

本文链接：https://blog.csdn.net/hacker9403/article/details/78534375

版权

/// <summary>
/// SQLite数据库简单操作的分装（Sqlite3）
/// 注意：SQLite 是不区分大小写
/// </summary>
public class DbAccess
{
    //SQLite链接库
	private SqliteConnection dbConnection;
	
	private SqliteCommand dbCommand;
	//数据库读取
	private SqliteDataReader reader;
	
	
	public DbAccess (string connectionString)
		
	{
		
		OpenDB (connectionString);
		
	}
	public DbAccess ()
	{
		
	}
	
    /// <summary>
    /// 数据库链接
    /// </summary>
    /// <param name="connectionString"></param>

	public void OpenDB (string connectionString)
		
	{
		try
		{
			dbConnection = new SqliteConnection (connectionString);
			
			dbConnection.Open ();
			
			//Debug.Log ("Connected to db,连接数据库成功！");
		}
		catch(Exception e)
		{
			string temp1 = e.ToString();
			Debug.Log(temp1);
		}
		
	}
	
	
	/// <summary>
	/// 关闭数据库
	/// </summary>
	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>
	/// sql数据库命令
	/// </summary>
	/// <param name="sqlQuery"></param>
	/// <returns>执行结果</returns>
	public SqliteDataReader ExecuteQuery (string sqlQuery)
		
	{
		
		dbCommand = dbConnection.CreateCommand ();
		
		dbCommand.CommandText = sqlQuery;
	
		reader = dbCommand.ExecuteReader ();

		return reader;
		
	}
	
	/// <summa