MySQL语法如何实现数据导入（Swift）

在Swift语言中使用MySQL数据库实现数据导入，在Swift项目中引入相应的库文件。下面web建站小编给大家简单介绍一下具体实现代码！

具体实现代码如下：

复制代码let hostname = "localhost" // MySQL主机名
let username = "root" // MySQL用户名
let password = "password" // MySQL密码
let database = "mydatabase" // MySQL数据库名称

let mysql = MySQLDatabase(hostname: hostname, username: username, password: password, database: database)
let pool = EventLoopGroupConnectionPool(source: mysql, maxConnectionsPerEventLoop: 1, on: ... /* 选择EventLoop的方法 */)
defer { pool.shutdown() }

//数据导入
func importData(fromFile fileURL: URL) throws {
  let fileData = try String(contentsOf: fileURL)
  let lines = fileData.components(separatedBy: .newlines)
  for line in lines {
    let values = line.components(separatedBy: ",")
    let firstName = values[0]
    let lastName = values[1]
    
    let query = "INSERT INTO users (firstName, lastName) VALUES (?, ?)"
    let statement = MySQLStatement(query: query)
    try statement.executeWithParams(on: pool) { (bind) in
      bind.input(firstName, as: MySQLData.VarString(nil))
      bind.input(lastName, as: MySQLData.VarString(nil))
    }
  }
}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26