嘉兴网站推广平台给人家做网站服务器自己搭吗

当前位置： 首页 > news >正文

嘉兴网站推广平台,给人家做网站服务器自己搭吗,网络营销事件案例,网站开发规划方案一、打开uni-app中SQLite 二、封装sqlite.js module.exports {dbName: chat, // 数据库名称dbPath: _doc/chat.db, // 数据库地址,推荐以下划线为开头 _doc/xxx.db/*** Description: 创建数据库 或 有该数据库就打开* author: ZXL* createTime: 2023-10-12 09:23:10* Copyr…一、打开uni-app中SQLite 二、封装sqlite.js  module.exports {dbName: chat, // 数据库名称dbPath: _doc/chat.db, // 数据库地址,推荐以下划线为开头 _doc/xxx.db/*** Description: 创建数据库 或 有该数据库就打开* author: ZXL* createTime: 2023-10-12 09:23:10* Copyright by 蓝创科技有限公司/openSqlite() {return new Promise((resolve, reject) {// 打开数据库plus.sqlite.openDatabase({name: this.dbName,path: this.dbPath,success(e) {resolve(e); },fail(e) {reject(e); }})})},/** Description: 判断数据库是否打开 数据库打开了就返回 true,否则返回 false* author: ZXL* createTime: 2023-10-12 08:43:03* Copyright by 蓝创科技有限公司/isOpen() {var open plus.sqlite.isOpenDatabase({name: this.dbName, // 数据库名称path: this.dbPath // 数据库地址})return open;},/** Description: 创建表executeSql是执行增删改等操作的SQL语句* author: ZXL* createTime: 2023-10-12 08:43:03* Copyright by 蓝创科技有限公司/ExecuteSQL(sql) {return new Promise((resolve, reject) {plus.sqlite.executeSql({name: this.dbName,sql: sql,success(e) {resolve(e);},fail(e) {reject(e);}})})},/** Description: 查询表数据* author: ZXL* createTime: 2023-10-12 08:52:15* Copyright by 蓝创科技有限公司*/getTable(dbTable){return new Promise((resolve, reject) {plus.sqlite.selectSql({name: this.dbName,sql: SELECT * FROM \({dbTable},success(e) {resolve(e);},fail(e) {console.log(e)reject(e);}})})},/*** Description: 查询数据库所有表* author: ZXL* createTime: 2023-10-12 09:01:05* Copyright by 蓝创科技有限公司*/QueryAllTables(){return new Promise((resolve, reject) {plus.sqlite.selectSql({name: this.dbName,sql: SELECT * FROM sqlite_master WHERE typetable,success(e) {resolve(e);},fail(e) {console.log(e)reject(e);}})})},/*** Description: 查询数据库下的所有表* author: ZXL* createTime: 2023-10-12 09:20:33* Copyright by 蓝创科技有限公司*/selectTableName(){return new Promise((resolve, reject) {plus.sqlite.selectSql({name: this.dbName,sql: select * FROM chat where typetable,success(e) {resolve(e);},fail(e) {console.log(e)reject(e);}})})},/*** Description: 新增数据* author: ZXL* 向表格里添加数据 sql:INSERT INTO dbTable VALUES(x,x,x) 对应新增* 或者 sql:INSERT INTO dbTable (x,x,x) VALUES(x,x,x) 具体新增* 插入 INSERT INTO 、 dbTable 是表名、根据表头列名插入列值* createTime: 2023-10-12 10:21:32* Copyright by 蓝创科技有限公司*///使用// let arr [// {id:121,dept_id: 100,dept_name: 你好呀},// {id:332,dept_id: 200,dept_name: 你好呀},// ]// arr.map((item) {// let condition id,dept_id,dept_name// let data \){item.id},\({item.dept_id},\){item.dept_name}// DB.insertTableData(表名,数据,字段).then((res) {})// .catch((error) {// console.log(失败, error)// })// })insertTableData(dbTable, data, condition) {// 判断有没有传参if (dbTable ! undefined data ! undefined) {// 判断传的参是否有值var bol (JSON.stringify(data) {});if (!bol) {if (condition undefined) var sql INSERT INTO \({dbTable} VALUES(\){data});else var sql INSERT INTO \({dbTable} (\){condition}) VALUES(\({data});return new Promise((resolve, reject) {// 表格添加数据plus.sqlite.executeSql({name: this.dbName,sql: sql,success(e) {resolve(e);},fail(e) {reject(e);}})})} else {return new Promise((resolve, reject) { reject(错误添加) })}} else {return new Promise((resolve, reject) { reject(错误添加) })}},/*** Description: 数据库建表* author: ZXL* 数据库建表 sql:CREATE TABLE IF NOT EXISTS dbTable(id varchar(50),name TEXT) * 创建 CREATE TABLE IF NOT EXISTS 、 dbTable 是表名不能用数字开头、括号里是表格的表头* createTime: 2023-10-12 09:26:44* Copyright by 蓝创科技有限公司*/// 使用// DB.createTable(bus_mzpy,id INTEGER PRIMARY KEY AUTOINCREMENT,mzpy_name TEXT ,dept_id INTEGER ,dept_name TEXT ,mzpy_concent TEXT)createTable(dbTable, data) {return new Promise((resolve, reject) {// executeSql: 执行增删改等操作的SQL语句plus.sqlite.executeSql({name: this.dbName,sql: CREATE TABLE IF NOT EXISTS \){dbTable}(\({data}),success(e) {resolve(e);},fail(e) {reject(e);}})})},/*** Description: 数据库删表 sql:DROP TABLE dbTable* author: ZXL* createTime: 2023-10-12 09:28:46* Copyright by 蓝创科技有限公司*/dropTable(dbTable) {return new Promise((resolve, reject) {plus.sqlite.executeSql({name: this.dbName,sql: DROP TABLE \){dbTable},success(e) {resolve(e);},fail(e) {reject(e);}})})},/*** Description: 根据条件向表里插入数据、更新或覆盖* author: ZXL* 根据条件向表格里添加数据 有数据更新、无数据插入* (建表时需要设置主键) 例如 — roomid varchar(50) PRIMARY KEY* createTime: 2023-10-12 09:31:19* Copyright by 蓝创科技有限公司/insertOrReplaceData(dbTable, data, condition) {// 判断有没有传参if (dbTable ! undefined data ! undefined) {if (condition undefined) var sql INSERT OR REPLACE INTO \({dbTable} VALUES(\){data});else var sql INSERT OR REPLACE INTO \({dbTable} (\){condition}) VALUES(${data});return new Promise((resolve, reject) {// 表格添加数据plus.sqlite.executeSql({name: this.dbName,sql: sql,success(e) {resolve(e);},fail(e) {reject(e);}})})} else {return new Promise((resolve, reject) { reject(错误添加) })}},/** Description: 表里查询数据* author: ZXL* 查询获取数据库里的数据 sql:SELECT * FROM dbTable WHERE lname lvalue* 查询 SELECT * FROM 、 dbTable 是表名、 WHERE 查找条件 lname,lvalue 是查询条件的列名和列值* createTime: 2023-10-12 09:44:08* Copyright by 蓝创科技有限公司*/ selectTableData(dbTable, lname, lvalue, cc, dd) {if (dbTable ! undefined) {let sql;// 第一个是表单名称后两个参数是列表名用来检索// 两个检索条件if (lname ! undefined cc ! undefined) sqlSELECT * FROM \({dbTable} WHERE \){lname} \({lvalue} AND \){cc} \({dd};// 一个检索条件if (lname ! undefined cc undefined) sql SELECT * FROM \){dbTable} WHERE \({lname} \){lvalue};if (lname undefined) sql SELECT * FROM \({dbTable};return new Promise((resolve, reject) {// 表格查询数据 执行查询的SQL语句plus.sqlite.selectSql({name: this.dbName,sql: sql,success(e) {resolve(e);},fail(e) {reject(e);}})})} else {return new Promise((resolve, reject) { reject(错误查询) });}},/*** Description: 表里删除数据* author: ZXL* 删除表里的数据 sql:DELETE FROM dbTable WHERE lname lvalue* 删除 DELETE FROM 、 dbTable 是表名、 WHERE 查找条件 lname,lvalue 是查询条件的列名和列值* createTime: 2023-10-12 09:40:37* Copyright by 蓝创科技有限公司*/deleteTableData(dbTable, lname, lvalue, ww, ee) {if(dbTable ! undefined){let sql;if(lname undefined){sql DELETE FROM \){dbTable};}else{if (ww ! undefined) {// 两个检索条件sql DELETE FROM \({dbTable} WHERE \){lname} \({lvalue} AND \){ww} \({ee};} else {// 一个检索条件sql DELETE FROM \){dbTable} WHERE \({lname} \){lvalue};}}return new Promise((resolve, reject) {// 删除表数据plus.sqlite.executeSql({name: this.dbName,sql: sql,success(e) {resolve(e);},fail(e) {reject(e);}})})} else {return new Promise((resolve, reject) { reject(错误删除) });}},/*** Description: 表里修改数据* author: ZXL* 修改数据表里的数据 sql:UPDATE dbTable SET 列名 列值,列名 列值 WHERE lname lvalue* 修改 UPDATE 、 dbTable 是表名, data: 要修改的列名修改后列值, lname,lvalue 是查询条件的列名和列值* createTime: 2023-10-12 09:37:59* Copyright by 蓝创科技有限公司/updateTableData(dbTable, data, lname, lvalue) {let sql;if (lname undefined) sql UPDATE \({dbTable} SET \){data};else sql UPDATE \({dbTable} SET \){data} WHERE \({lname} \){lvalue};// WHERE 前面是要修改的列名、列值后面是条件的列名、列值return new Promise((resolve, reject) {// 修改表数据plus.sqlite.executeSql({name: this.dbName,sql: sql,success(e) {resolve(e);},fail(e) {reject(e);}})})},/** Description: 获取指定数据条数* author: ZXL* 获取指定数据条数 sql:SELECT * FROM dbTable ORDER BY id DESC LIMIT 15 OFFSET num* dbTable 表名, ORDER BY 代表排序默认正序, id 是排序的条件 DESC 代表倒序从最后一条数据开始拿* LIMIT 15 OFFSET \({num},这句的意思是跳过 num 条拿 15 条数据, num 为跳过多少条数据是动态值* 例 初始num设为0就从最后的数据开始拿15条下次不拿刚获取的数据所以可以让num为15这样就能一步一步的拿完所有的数据* createTime: 2023-10-12 09:33:43* Copyright by 蓝创科技有限公司*/pullSQL(dbTable, id, num) {return new Promise((resolve, reject) {plus.sqlite.selectSql({name: this.dbName,sql: SELECT * FROM \){dbTable} ORDER BY \({id} DESC LIMIT 15 OFFSET \){num},success(e) {resolve(e);},fail(e) {reject(e);}})})},/*** Description: 关闭数据库* author: ZXL* createTime: 2023-10-12 09:23:56* Copyright by 蓝创科技有限公司*/closeSqlite() {return new Promise((resolve, reject) {plus.sqlite.closeDatabase({name: this.dbName,success(e) {resolve(e);},fail(e) {reject(e);}})})}, } 三、使用  import DB from /utils/sqlite.js类似这样 DB.selectTableData(,,).then((res) {}).catch((error) {console.log(查询失败, error) })