React Native 之react-native-sqlite-storage

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.打开数据库:

var db = SQLiteManager.openDatabase({name: "mydata.db", createFromLocation: 1}, openCB, errorCB); //参数依次是：数据库名，路径，操作成功函数，操作失败函数

function openCB() {
    console.log('open!')
}
function errorCB(err) {
    console.log(err)
}

/**
 * [closeDB 关闭数据库]
 */
function closeDB(){
  if(db){
    db.close()

  }else {

  }
}

3.创建表:

db.transaction((tx) => {
    //创建表
    tx.executeSql('CREATE TABLE IF NOT EXISTS DATA(' +
                'id INTEGER PRIMARY KEY  AUTOINCREMENT,' +
                'title VARCHAR,'+
                'value VARCHAR,' +
                'time VARCHAR,' +
                'year VARCHAR,' +
                'month VARCHAR,' +
                'date VARCHAR)',[],() => {Alert.alert('createTable executeSql success')},
    (err) => { Alert.alert('createTable  executeSql error=',err)})

}
)

4.查询

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语句

https://www.jianshu.com/p/69a2e7e93caf

封装好的工具：https://linux.ctolib.com/NikiLee2016-react-native-sqlite-helper-pro.html

react-native-sqlite-helper-pro