之前安装了 sqlite,mysql 的客户端。这里用 mysql 做示例,跑跑看。
require "luasql.mysql"
dbParam = {
host = '127.0.0.1',
port = 3306,
user = 'root',
pass = '123456'
db = 'test'
}
my = luasql.mysql()
conn = my:connect(dbParam.db, dbParam.user, dbParam.pass, dbParam.host, dbParam.port)
conn:execute("SET NAMES UTF8")
cur = conn:execute("select * from user")
print(cur:numrows())
repeat
row = cur:fetch({}, "a")
print(row)
until(not row)
conn:close()
my:close()