lua访问mysql数据库

require "luasql.mysql"

--initial
env = luasql.mysql()

--connect db
db="testdb"
username="test"
password="test"
ip="127.0.0.1"
port="3306"
conn = env:connect(db,username,password,ip,port)

--set encode
conn:execute"SET NAMES UTF8"

--query
cur = conn:execute("select * from user")

--output result
row=cur:fetch({},"a")
while row do
    var=string.format("%s %s\n",row.userid,row.username)
    print(var)
    row=cur:fetch(row,"a")
end

--close
conn:close()
env:close()