uniapp使用sqlite 數(shù)據(jù)庫(kù)

傻瓜式使用方式，按步驟，即可使用。

1.開(kāi)啟sqlite
在項(xiàng)目中manifest.json該文件中配置

2.封裝數(shù)據(jù)庫(kù)的調(diào)用方法

const sqlName = "zmyalh"  //定義的數(shù)據(jù)庫(kù)名稱(chēng)
const sqlPath = "_doc/zmyalh.db" //定義數(shù)據(jù)庫(kù)的位置在_doc目錄下的zmyalh.db文件，zmyalh.db這個(gè)可以自己定義名字
//打開(kāi)數(shù)據(jù)庫(kù)，在使用數(shù)據(jù)庫(kù)前，必須打開(kāi)數(shù)據(jù)庫(kù)
function openDb(name,path) {
    return new Promise((resolve,reject)=>{
        plus.sqlite.openDatabase({
            name: name,    //這里是數(shù)據(jù)庫(kù)的名稱(chēng)
            path: path,    //_doc是相對(duì)路徑的應(yīng)用私有文檔目錄
            success: function(e){
                console.log('數(shù)據(jù)庫(kù)打開(kāi)成功')
                resolve(e)
            },
            fail: function(e){
                console.log('數(shù)據(jù)庫(kù)打開(kāi)失敗:' + JSON.stringify(e))
                reject(e)
            }
        })
    })
}
//判斷是否打開(kāi)數(shù)據(jù)庫(kù)
function isOpened(name,path) {
    return plus.sqlite.isOpenDatabase({name:name,path:path})
}

//關(guān)閉數(shù)據(jù)庫(kù)
function closeDb(name) {
    return new Promise((resolve,reject)=>{
        plus.sqlite.closeDatabase()({
            name: name,    //這里是數(shù)據(jù)庫(kù)的名稱(chēng)
            success: function(e){
                console.log('數(shù)據(jù)庫(kù)關(guān)閉成功')
                resolve(e)
            },
            fail: function(e){
                console.log('數(shù)據(jù)庫(kù)關(guān)閉失敗')
                reject(e)
            }
        })
    })
}

//查詢(xún)sql 所有的查詢(xún)都用該方法
function selectSql(name,sqlText) {
    return new Promise((resolve,reject)=>{
        plus.sqlite.selectSql({
            name: name,    //這里是數(shù)據(jù)庫(kù)的名稱(chēng)
            sql: sqlText,
            success: function(e){
                // console.log('查詢(xún)成功:' + sqlText)
                resolve(e)
            },
            fail: function(e){
                console.log('查詢(xún)失敗:' + sqlText + "-異常信息:" + JSON.stringify(e))
                reject(e)
            }
        })
    })
}
//執(zhí)行增刪改查都使用該方法
function executeSql(name,sqlText) {
    return new Promise((resolve,reject)=>{
        plus.sqlite.executeSql({
            name: name,    //這里是數(shù)據(jù)庫(kù)的名稱(chēng)
            sql: sqlText,
            success: function(e){
                console.log('操作成功')
                resolve(e)
            },
            fail: function(e){
                console.log('執(zhí)行失敗:' + sqlText + '-異常信息:' + JSON.stringify(e))
                reject(e)
            }
        })
    })
}
export  {
	sqlName,
	sqlPath,
	openDb,
	isOpened,
	closeDb,
	selectSql,
	executeSql
}

3.創(chuàng)建數(shù)據(jù)庫(kù)方式

import {sqlName,executeSql} from "./sqllite.js"
let createSql = {//用戶(hù)表
	name:"user",
	sql:"id INTEGER PRIMARY KEY AUTOINCREMENT,userId VARCHAR(255) NOT NULL,userName VARCHAR(255) NOT NULL,admin  VARCHAR(20) NOT NULL,loginIp   VARCHAR(255) NOT NULL,nickName VARCHAR(255) NOT NULL,password  VARCHAR(255) NOT NULL,dept json not null,roles json not null"
}
executeSql(sqlName,`create table if not exists ${createSql.name} (${createSql.sql})`)

4.操作數(shù)據(jù)庫(kù)正刪改查文章來(lái)源地址http://www.zghlxwxcb.cn/news/detail-673196.html

import {
	sqlName,
	openDb,
	isOpened,
	closeDb,
	selectSql,
	executeSql
} from "./sqllite.js"
const name = sqlName

export function userAll() {//查詢(xún)?nèi)?/span>
	let sql = "SELECT * FROM user"
	return selectSql(name,sql) 
}

export function userItem(names) {//按名字查詢(xún)
	let sql = `select * from user where userName = '${names}'`
	return selectSql(name,sql) 
}

export function userAdd(row) {//新增
	let sql = `INSERT INTO user (userId,userName, admin, loginIp, nickName, password, dept, roles)  VALUES ('${row.userId}','${row.userName}','${row.admin}','${row.loginIp}','${row.nickName}','${row.password}','${row.dept}','${row.roles}')`
	return executeSql(name,sql) 
}

export function userUpdata(row) {//修改一條
	let sql = `UPDATE user SET userId = '${row.userId}', userName = '${row.userName}', admin ='${row.admin}', loginIp = '${row.loginIp}',nickName = '${row.nickName}', password= '${row.password}',dept= '${row.dept}' ,roles= '${row.roles}'  WHERE id = ${row.id}`
	return executeSql(name,sql) 
}

export function userDelete(id) {//刪除一條
	let sql = `DELETE FROM user WHERE id = ${id}`
	return executeSql(name,sql) 
}

export function userDeletes() {//刪除全部
	let sql = `DELETE FROM user `
	return executeSql(name,sql) 
}

到了這里，關(guān)于uniapp使用sqlite 數(shù)據(jù)庫(kù)的文章就介紹完了。如果您還想了解更多內(nèi)容，請(qǐng)?jiān)谟疑辖撬阉鱐OY模板網(wǎng)以前的文章或繼續(xù)瀏覽下面的相關(guān)文章，希望大家以后多多支持TOY模板網(wǎng)！