• Lua (1): 基础语法
• Lua (2): 其他姿势
• Lua (3): 面向对象
• Lua (4): 包
• Lua (5): 数据库
• Lua (6): 和 C 的交互

之前安装了 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()