webjs 数据库 离线读取本地数据库源码-SAAS 本地化及未来之窗行业应用跨平台架构

一、初始化js数据库

 

console.group("本地数据");

			var 未来之窗db=new CyberWin_MS("cyberwinclient_gfsoft_itemmain","cyberwin_gfsoft_db");
			if(type =="项目"){
				未来之窗db=new CyberWin_MS("cyberwinclient_item","cyberwin_gfsoft_db");
			}
			if(type =="商品"){
				未来之窗db=new CyberWin_MS("cyberwinclient_goods_list","cyberwin_gfsoft_db");
			}
		

二、js sql 便编

		  const whereClause = "age > 18 or number = "+key+" or name like "+key+" or age2 > 18  or goods_code like "+key+" or goods_barcodes like "+key+" ";

		

三、执行js sql

  var loading_cart_html_goods_score_show = 0;
			未来之窗db.where(whereClause);
			未来之窗db.find(function(ret,request){
				

四、渲染查询到的数据库显示

	//在这里面就可以进行对数据的操作了
					 
					var countrow = request.length;
					if(countrow < 1 ){
						//return "无结果";
						//alert("查找无结果"+key);
						console.log("查找无结果");
							return "无结果";
					}else{
							console.log("查找结果countrow="+countrow);
							console.log(request);
						}

					$("#cyberwin_localapp_search_goods").show();
					var localapp_search_html='';

				//recordset_mul_one_obj.goods_id
				   var recordset = request;

					for (var loca_i = 0; loca_i < countrow; loca_i ++) { 
						var recordset_mul_one_obj=recordset[loca_i];

						console.log("查找结果");
						console.log(recordset_mul_one_obj);