本文实例讲述了javascript封装的sqlite操作类。分享给大家供大家参考。具体如下：
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(32) primary key,jfs int,jfx varchar(64),jxx text,ct int,uinfo text,jia int,zt int,bz varchar(16),yue int)', 'create index if not exists ct_a on cfrids(ct)', 'create table if not exists cliao(id varchar(32) primary key,uid varchar(32),nr text,ct int,ty varchar(8),ismy int)', 'create index if not exists uid_a on cliao(uid)', 'create table if not exists czliao(id varchar(32) 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 ?,10',['22',50],function(tx,rs){ var l=rs.rows.length;});
希望本文所述对大家的javascript程序设计有所帮助。