前端实现mysql查询_HTML5 webSQL动态查询前端数据库表

//HTML5 WEB SQL查询数据

$scope.queryCenterReimbursData = function(keyword,querycol){

var lencr="0";

//拼接sql

var condition="";//拼过滤条件

var conditiontemp="";//临时过滤条件变量

var querycrsql="";//最后执行sql

var queryzxcols=new Array();//queryzxcols = ["1","2"]

var selcolsql="";//拼查询字段

for(var i=0;i

selcolsql=selcolsql+" "+colattrs[i]+",";

}

selcolsql=selcolsql.substring(0,(selcolsql.length-1));//查询字段

queryzxcols=querycol.split(",");

for(var i=0;i

if(i==0){

conditiontemp= colattrs[queryzxcols[i]]+" LIKE "+'\"'+keyword+'%\"';

}else{

conditiontemp=" OR "+colattrs[queryzxcol