使用FMDB Swift创建多个表

let databasePath = NSSearchPathForDirectoriesInDomains(.documentDirectory, .userDomainMask, true).first! + "/mydatabase.db"
let database = FMDatabase(path: databasePath)

if database.open() {
    // 数据库连接成功
} else {
    // 数据库连接失败
}

let createTableSQL = "CREATE TABLE IF NOT EXISTS table1 (id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT, age INTEGER)"
if database.executeUpdate(createTableSQL, withArgumentsIn: []) {
    // 表创建成功
} else {
    // 表创建失败
}

let insertDataSQL = "INSERT INTO table1 (name, age) VALUES (?, ?)"
if database.executeUpdate(insertDataSQL, withArgumentsIn: ["John", 25]) {
    // 数据插入成功
} else {
    // 数据插入失败
}

let queryDataSQL = "SELECT * FROM table1"
if let resultSet = database.executeQuery(queryDataSQL, withArgumentsIn: []) {
    while resultSet.next() {
        let id = resultSet.int(forColumn: "id")
        let name = resultSet.string(forColumn: "name")
        let age = resultSet.int(forColumn: "age")
        // 处理查询结果
    }
} else {
    // 查询失败
}

database.close()