lua连接数据库之luasql ------ luasql连接mysql数据库 及 luasql源码编译

LUA_INC=D:\Lua\5.1\include
LUA_DIR=D:\Lua\5.1
LUA_LIBDIR=D:\Lua\5.1\lib
LUA_LIB=D:\Lua\5.1\lib\lua5.1.lib

T=mysql

DRIVER_INCLUDE= /I"D:\Upupw\MySQL\include"
DRIVER_LIBS= "D:\Upupw\MySQL\lib\libmySQL.lib" "D:\Upupw\MySQL\lib\mysqlclient.lib" 

OBJS= src\luasql.obj src\ls_$T.obj

.c.obj:
    cl /c /Fo$@ /O2 /I$(LUA_INC) /DWIN32 /D_CRT_SECURE_NO_DEPRECATE $(DRIVER_INCLUDE) $<

src\$T.dll: $(OBJS)
    link /dll /def:src\$T.def /out:$@ $(OBJS) $(DRIVER_LIBS) $(LUA_LIB) 

install:
    IF NOT EXIST $(LUA_LIBDIR)\luasql mkdir $(LUA_LIBDIR)\luasql
    copy src\$T.dll $(LUA_LIBDIR)\luasql

clean:
    del src\$T.dll
    del src\$T.exp
    del src\$T.lib
    del $(OBJS)

require "luasql.mysql"

--创建环境对象
env = assert(luasql.mysql())

--连接数据库
conn = assert(env:connect("ly","root","*****","192.168.1.55",3306))

--操作数据数据库
conn:execute"SET NAMES GB2312"

--执行数据库操作
--下面这种方式有问题，貌似和lua库有关
--[[
cur = conn:execute("SELECT * from people")
row = cur:fetch({},"a")
while row do
    print(string.format("%s   %s",row.name,row.email))
    row = cur:fetch(row,"a")
end
--]]
--操作数据库文法2
function rows (connection, sql_statement)
  local cursor = assert (connection:execute (sql_statement))
  return function ()
    return cursor:fetch()
  end
end

for name,email in rows(conn ,"SELECT * from people") do
    print(string.format("%s  %s",name,email))
end

conn:close()  --关闭数据库连接
env:close()   --关闭数据库环境