创建数据库
var db = openDatabase (`person`,1,`person`,0) |
创建表
db.transaction(tx=>{ | |
tx.executeSql('create table if not exists student (id unique,name)') | |
}) |
向表中添加数据
db.transaction(tx=>{ | |
tx.executeSql('insert into student (id,name) values (?,?)' , [1,'张三']) | |
tx.executeSql('insert into student (id,name) values (?,?)' , [2,'李四']) | |
}) |
查询
db.transaction(tx=>{ | |
tx.executeSql('select * from student',[],(tx,res)=>{ | |
let rows = res.rows | |
let end = rows.length | |
for(let i = 0;i < end;i++){ | |
console.log(rows.item(i)) | |
} | |
}) | |
}) |
