SQLite operation class instance _javascript technique for JavaScript encapsulation

This example describes the SQLite action class for JavaScript encapsulation. Share to everyone for your reference. Specifically as follows:

function SQL (name,v,desc,size,tables) {
 this.db=null;
 This.name=name;
 This.v=v;
 This.desc=desc;
 This.size=size;
 This.tables=tables;
 This.ini ();
}
Sql.prototype.ini=function () {
 var self=this;
 Self.db=opendatabase (self.name,self.v,self.desc,self.size);
 Self.db.transaction (Function (TX) {
  Self.tables.forEach (function (s) {
   tx.executesql (s,[));
  }
); };
Sql.prototype.query=function (sql,opt,rs,err) {
 var opt=opt | | [];
 var rs =rs | | function () {};
 var Err=err | | function (tx,e) {G.alert (e.message);};
 This.db.transaction (Function (TX) {
  if (typeof (sql) = = ' object ') {
   Sql.foreach (function (s)
    { Tx.executesql (S,opt,rs,err);}
  else{
   Tx.executesql (sql,opt,rs,err);
  }
 );

Demo

var tbs=[
  ' CREATE TABLE IF not EXISTS cfrids (id varchar (PRIMARY key,jfs) int,jfx varchar (), jxx text,ct Int,uinfo Text,jia int,zt int,bz varchar (), Yue INT) ',
  ' create INDEX if not EXISTS ct_a on cfrids (CT) ',
  ' Create TABLE if NO T EXISTS Cliao (id varchar (PRIMARY key,uid varchar), nr text,ct int,ty varchar (8), Ismy INT) ',
  ' CREATE INDEX IF NO T EXISTS uid_a on Cliao (UID) ",
  ' CREATE TABLE IF not EXISTS Czliao (id varchar () PRIMARY key,nr text,ty varchar (8), CT Int,num INT) '];
  var db=new sql (' Imdata ' +z, ' 1.0 ', ' User Data ', 1048576,TBS);
  Db.query (' INSERT into Cliao (Id,uid,nr,ct,ty,ismy) VALUES (?,?,?,?,?,?) ', [' afasdf ', ' Asdfa ', ' saadf ', ' eeee ', ' rrrr ', 1] );
  Db.query (' select * from Cliao where uid=? ORDER BY ct desc limit?, ', [' 50],function ' (tx,rs) {
   var l=rs.rows.length ;
});

I hope this article will help you with your JavaScript programming.