meishidaQS/pages/api/dataBase.js

const dbPath = '_doc/locateDB.db'
const name = 'locateDB'
//const ApiUrl = 'http://192.168.1.7:8080'
const getdata = function(api,data,successc,failc){
	//打开数据库
	if(api=='openDB'){
		plus.sqlite.openDatabase({
			name:name,
			path:dbPath,
			success: res=> {
				successc(res);
			},
			fail: function (err) {
				failc(err);
			},
		});
	}
	if(api=='DBisOpen'){//判断数据库是否打开
		if(plus.sqlite.isOpenDatabase({name:name,path:dbPath})){
			successc(true);
		}
		else{
			successc(false);
		}
	}
	//关闭数据库
	if(api=='closeDB'){
		plus.sqlite.openDatabase({
			name:name,
			success: res=> {
				successc(res);
			},
			fail: function (err) {
				failc(err);
			},
		});
	}
	
	//创建用户表（好友）
	if(api=='CTableuser'){
		plus.sqlite.executeSql({
			name:name,
			sql:'create table if not exists userfl("userid" CHAR(20),"NickName" CHAR(32),"UserName" CHAR(32),"illustrate" CHAR(120),"newmsg" int(8))',
			success: res=> {
				successc(res);
			},
			fail: function (err) {
				failc(err);
			},
		})
	}
	
	//创建消息表
	if(api=='CTablemsg'){
		plus.sqlite.executeSql({
			name:name,
			sql:'create table if not exists msglist("userid" CHAR(20),"time" CHAR(32),"msg" CHAR(32),"type" int(8))',
			success: res=> {
				successc(res);
			},
			fail: function (err) {
				failc(err);
			},
		})
	}
	
	//插入用户（好友）
	if(api=='insertUser'){
		plus.sqlite.executeSql({
			name:name,
			sql:'if not exists(select * from userfl where userid=001) begin insert into userfl(userid,NickName,UserName,illustrate,newmsg) values(userid,NickName,UserName,illustrate,newmsg)',
			success: res=> {
				successc(res);
			},
			fail: function (err) {
				failc(err);
			},
		})
	}
	//插入消息
	if(api=='insertmsg'){
		plus.sqlite.executeSql({
			name:name,
			sql:'if not exists(select * from userfl where userid=001) begin insert into userfl(userid,NickName,UserName,illustrate,newmsg) values(userid,NickName,UserName,illustrate,newmsg)',
			success: res=> {
				successc(res);
			},
			fail: function (err) {
				failc(err);
			},
		})
	}
	
	
}
module.exports = getdata;