React Native 之react-native-sqlite-storage

瞢知青 發表於 2019-9-17 16:26:00

npm 官网指导: https://www.npmjs.com/package/react-native-sqlite-storage
1. 执行: npm install react-native-sqlite-storage
2.cd ios 执行pod install
3.执行react native link
使用：
按照上面官网说的，在ios项目根目录下新建www文件夹，里面放sqlite数据库文件
在react native项目中使用: 
1. 导入 import SQLiteManager from 'react-native-sqlite-storage'
2.打开数据库: 
<div class="cnblogs_code">
<pre>var db = SQLiteManager.openDatabase({name: "mydata.db", createFromLocation: 1}, openCB, errorCB); //参数依次是：数据库名，路径，操作成功函数，操作失败函数</pre>
</div>
<div class="cnblogs_code">
<pre>function openCB() {
console.log('open!')
}
function errorCB(err) {
console.log(err)
}</pre>
</div>
<div class="cnblogs_code">
<pre>/**
*
*/
function closeDB(){
if(db){
db.close()

}else {

}
}</pre>
</div>
 
3.创建表:
<div class="cnblogs_code">
<pre>db.transaction((tx) => {
//创建表
tx.executeSql('CREATE TABLE IF NOT EXISTS DATA(' +
 'id INTEGER PRIMARY KEYAUTOINCREMENT,' +
 'title VARCHAR,'+
 'value VARCHAR,' +
 'time VARCHAR,' +
 'year VARCHAR,' +
 'month VARCHAR,' +
 'date VARCHAR)',[],() => {Alert.alert('createTable executeSql success')},
(err) => { Alert.alert('createTableexecuteSql error=',err)})

}
)</pre>
</div>
4.查询
<div class="cnblogs_code">
<pre>db.transaction((tx) => {
 tx.executeSql(select, [], (tx, result) => {


 let arr = []
 for (let i = 0; i < result.rows.length; i++) {

 arr.push(result.rows.item(i))
 }

 this.setState({


 dataSource: arr

 })

 })
 });//select 是sql语句</pre>
</div>
 
<h1 class="_1RuRku">RN- react-native-sqlite-storage 封装增删改查方法：</h1>
https://www.jianshu.com/p/69a2e7e93caf
 
封装好的工具：https://linux.ctolib.com/NikiLee2016-react-native-sqlite-helper-pro.html
<h1 id="articleHeader0">react-native-sqlite-helper-pro</h1>

</div>
<div id="MySignature" role="contentinfo">
此文仅为鄙人学习笔记之用，朋友你来了，如有不明白或者建议又或者想给我指点一二，请私信我。liuw_flexi@163.com/QQ群:582039935.

我的gitHub: (学习代码都在gitHub)
https://github.com/nwgdegitHub/ 
来源：https://www.cnblogs.com/liuw-flexi/p/11534893.html

頁: [1]

琼殿技术论坛's Archiver

React Native 之react-native-sqlite-storage