频道导航

SQLite Class - Easier Database Stuff

2020-06-18 Sqlite 前端之家

前端之家收集整理的这篇文章主要介绍了SQLite Class - Easier Database Stuff，前端之家小编觉得挺不错的，现在分享给大家，也给大家做个参考。

Hello,I thought I would share my basic sqlite class for those who are interesting in learning how to use unity with it or those who are looking to implement something similar.

This will help create cleaner code for those who need to use databases.
Ultimately I want to create an editor tool for database so that we can have another tool on top of Unity's awesome-ness.

"Update - 8/14 I added a Create Table Function"
"Update - 8/14 I added a Insert Functions"

The Class

Code:

  
  
   
    
     
     
       import     System. 
      Data;  
      // we import our data class 
     
  
    
       import     Mono. 
      Data. 
      sqliteClient; 
      // we import our sqlite client

 
      class dbAccess 
      {

         
      // variables for basic query access 
     

private 
      var connection : 
      String; 
     

var dbcon : IDbConnection; 
     

var dbcmd : IDbCommand; 
     

var reader : IDataReader; 
     

function OpenDB 
      (p : 
      String 
      ) 
      
         connection = 
      "URI=file:" + p; 
      // we set the connection to our database 
      

         dbcon = 
      new sqliteConnection 
      (connection 
      ); 
      

         dbcon. 
      Open 
      ( 
      } 
      

function BasicQuery 
      (q : 
      String,r : 
      boolean 
      { 
      // run a baic sqlite query 
      

           dbcmd = dbcon. 
      CreateCommand 
      ); 
      // create empty command 
      

           dbcmd. 
      CommandText = q; 
      // fill the command 
      

           reader = dbcmd. 
      ExecuteReader 
      // execute command which returns a reader 
      

           
      if 
      (r 
      // if we want to return the reader 
      

return reader; 
      // return the reader 
      

function CreateTable 
      ( 
      name : 
      Array,colType : 
      Array 
      // Create a table,name,column array,column type array 
      

var query : 
      
           query = 
      "CREATE TABLE " + 
      name + 
      "(" + col 
      [ 
      0 
      ] + 
      " " + colType 
      ]; 
      

for 
      var i= 
      1; i<col. 
      length; i++ 
      
             query += 
      "," + col 
      [i 
      
           query += 
      ")"; 
      

CommandText = query; 
      function InsertIntoSingle 
      (tableName : 
      value : 
      // single insert  
      

"INSERT INTO " + tableName + 
      "(" + colName + 
      ") " + 
      "VALUES (" + 
      value + 
      function InsertIntoSpecific 
      // Specific insert with col and values 
      

") VALUES (" + values 
      (i= 
      1; i<values. 
       + values 
      CommandText = query; 
      

function InsertInto 
      // basic Insert with just values 
      

" VALUES (" + values 
      function SingleSelectWhere 
      // Selects a single Item 
      

"SELECT " + itemToSelect + 
      " FROM " + tableName + 
      " WHERE " + wCol + wPar + wValue; 
      

var readArray = 
      new 
      while 
      (reader. 
      Read 
      
             readArray. 
      Push 
      (reader. 
      GetString 
      // Fill array with all matches 
      

return readArray; 
      // return matches 
      

function CloseDB 
      
           reader. 
      Close 
      // clean everything up 
      

          reader = 
      null; 
      

          dbcmd. 
      Dispose 
      
          dbcmd = 
      
          dbcon. 
      
          dbcon = 
       
      }

An Example of Creating a Table
You can create two arrays,one being the column headers,and another being the data types.

Code: var db : dbAccess;

function 
      Start 
      
         db = 
      new dbAccess 
      
         db. 
      OpenDB 
      ( 
      "myDB.sqdb" 
      var tableName = 
      "myTable"; 
     

var columnNames = 
      "firstName","lastName" 
      var columnValues = 
      "text",21)">"text" 
      CreateTable 
      (tableName,columnNames,columnValues 
      CloseDB 
      } 
     

An Example of Easy Insert
This example is an easy way to add a single record

Code: // IMPORTANT remember to add single ' to any strings,do not add them to numbers!

var values = 
      "'Bob'",21)">"'Sagat'" 
      InsertInto 
      } 
     

An Example of Single WHERE select
I am not done with this class,but this is an example of getting an array of items that match a WHERE clause.

Code: // table name,I want to return everyone whose first name is Bob when their last name is = to Sagat,this returs an array

var resultArray = db. 
      SingleSelectWhere 
      "lastName",21)">"=",0)">// Remember the '' on String values 
     

         
      print 
      (resultArray 
      ] 
      // of course you can loop through them all if you wish 
      

}

原文链接：https://www.f2er.com/sqlite/201937.html

上一篇：SQLite基本语法手册下一篇：LCD Backlight 的分析

猜你在找的Sqlite相关文章

SQLite学习笔记

安装在Windows上安装SQLite。访问官网下载下Precompliled Binaries for Windows的两个压...

作者：前端之家时间：2021-01-12

windows上如何安装Sqlite

一、安装下载地址：http://www.sqlite.org/download.html 将Precompiled Binaries for Wi...

作者：前端之家时间：2020-11-05

【Android数据存储】SQLite使用实例(附源码)

实例: 会员信息管理功能：1.查看数据库 2.清空数据库 3.增加会员 4.删除会员 5.更新会员 ...

作者：前端之家时间：2020-08-07

SQLite数据库管理

作者：前端之家时间：2020-08-07

SQLite3常用命令

作者：前端之家时间：2020-08-07

加密你的SQLite

关于SQLite SQLite是一个轻量的、跨平台的、开源的数据库引擎，它的在读写效率、消耗总量、...

作者：前端之家时间：2020-08-07

SQLite这么娇小可爱，不多了解点都不行啊

在我眼里，MySQL和Oracle是这样的而SQLite在是这样的所以这么萌的数据库，我真的应该多了...

作者：前端之家时间：2020-08-07

SQLite这么娇小可爱，不多了解点都不行啊

在我眼里，MySQL和Oracle是这样的而SQLite在是这样的所以这么萌的数据库，我真的应该多了...

作者：前端之家时间：2020-08-07

SQLite 这么娇小可爱，不多了解点都不行啊

（点击上方蓝字，快速关注我们) 作者：空之境界网址：http://supermao.cn/sqlitezhe-yao-...

作者：前端之家时间：2020-08-07

SQLITE3 使用总结

SQLITE3 使用总结投稿：hebedich 字体：[ 增加减小] 类型：转载时间：2014-08-19 Sql...

作者：前端之家时间：2020-08-07

编程分类

MySQL MsSQL Oracle Sqlite Postgre SQL Mariadb MongoDB NoSQL HBase JDBC