主题
LimeSqlite
- lime-sqlite 参考 plus.sqlite API 实现的sqlite UTS API,兼容uniappx(安卓, ios)
- 可以打开plus.sqlite参考
文档
安装
代码演示
打开数据库
js
import { openDatabase, DatabaseOptions } from '@/uni_modules/lime-sqlite'
openDatabase({
// 支持路径,例如 '/static/db/test.db',
// 鸿蒙不支持路径。
// web支持路径,是通过下载的方式,但数据并不存在路径文件里。
name: 'text',
success(res) {
console.log('openDatabase', res)
},
fail(err) {
console.log('openDatabase', err)
}
} as DatabaseOptions)
判断数据库是否打开
js
import { isOpenDatabase, DatabaseOptions } from '@/uni_modules/lime-sqlite'
isOpenDatabase({
name: 'text',
success(res) {
console.log('isOpenDatabase', res)
},
fail(err) {
console.log('isOpenDatabase', err)
}
} as DatabaseOptions)
关闭数据库
js
import { closeDatabase, DatabaseOptions } from '@/uni_modules/lime-sqlite'
closeDatabase({
name: 'text',
success(res) {
console.log('closeDatabase', res)
},
fail(err) {
console.log('closeDatabase', err)
}
} as DatabaseOptions)
执行事务
js
import { transaction, SqlTransactionOptions } from '@/uni_modules/lime-sqlite'
transaction({
name: 'text',
operation: 'begin',
success(res) {
console.log('transaction', res)
},
fail(err) {
console.log('transaction', err)
}
} as SqlTransactionOptions)
执行增删改等操作的SQL语句
js
import { executeSql, SqlOperationOptions } from '@/uni_modules/lime-sqlite'
executeSql({
name: 'text',
sql: [
"CREATE TABLE IF NOT EXISTS test (id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT NOT NULL, age INTEGER)",
"INSERT INTO test (name, age) VALUES ('Alice', 30)",
"INSERT INTO test (name, age) VALUES ('Bob', 25)",
"INSERT INTO test (name, age) VALUES ('Charlie', 35)"
],
success(res) {
console.log('executeSql', res)
},
fail(err) {
console.log('executeSql', err)
}
} as SqlOperationOptions)
执行查询的SQL语句
js
import { selectSql, SqlOperationOptions } from '@/uni_modules/lime-sqlite'
selectSql({
name: 'text',
sql: ['select * from test'],
success(res) {
console.log('selectSql', res)
},
fail(err) {
console.log('selectSql', err)
}
} as SqlOperationOptions)
获取数据路径
js
import { getDatabasePath } from '@/uni_modules/lime-sqlite'
const url = getDatabasePath('text');
// web 返回的blob
打赏
如果你觉得本插件,解决了你的问题,赠人玫瑰,手留余香。