Skip to Content

Changes for page 01 Lua Functions

Last modified by Theodore Xu on 2023/10/26 10:51
From version 17.1
edited by Theodore Xu
on 2023/08/24 16:45
Change comment: There is no comment for this version
To version 13.1
edited by Hunter
on 2023/02/18 15:33
Change comment: There is no comment for this version

Summary

Details

Page properties
Author
... ... @@ -1,1 +1,1 @@
1 -XWiki.AiXia
1 +XWiki.Hunter
Content
... ... @@ -1929,69 +1929,125 @@
1929 1929  **For example:**
1930 1930  
1931 1931  {{code language="LUA"}}
1932 --- Assuming the "mysqlclient" library is properly installed and available
1933 -mysql = require("mysqlclient")
1932 +mysql = require"mysqlclient"
1934 1934  
1935 1935  function DataInitRight()
1936 - local dbName = "excel"
1937 - local user = "root"
1938 - local pwd = "XXXXX"
1939 - local host = "192.168.39.146"
1940 - local port = 3306
1941 - local character = "utf8mb3"
1942 -
1943 - mysql.init(dbName, user, pwd, host, port, character)
1935 +
1936 +local dbName = "db_lua1"
1937 +
1938 +local user = "root"
1939 +
1940 +local pwd = "123456"
1941 +
1942 +local host = "192.168.56.186"
1943 +
1944 +local port = 3306
1945 +local character = "UTF8"
1946 +
1947 +mysql.init(dbName, user, pwd, host, port, character)
1948 +
1944 1944  end
1945 1945  
1946 1946  function ExecFunc()
1947 - status, errorString = mysql.exec("delete from student where Name = 'XXX';") --Delete statement, column name = table element
1948 - if nil == status then
1949 - print("ExecFunc() error:", errorString)
1950 - return -1
1951 - else
1952 - print("the number of rows affected by the command:", status)
1953 - end
1954 - return 0
1952 +
1953 +status, errorString = mysql.exec("delete from tb_lua1 where mykey =
1954 +
1955 +10;")
1956 +
1957 +if nil == status then
1958 +
1959 +print("ExecFunc() error:", errorString)
1960 +
1961 +return -1
1962 +
1963 +else
1964 +
1965 +print("the number of rows affected by the command:", status)
1966 +
1955 1955  end
1956 1956  
1969 +return 0
1957 1957  
1971 +end
1972 +
1958 1958  function ExecWithResultFunc()
1959 - status, errorString = mysql.execWithResult("select * from student;")
1960 - if nil == status then
1961 - print("ExecWithResultFunc() error:", errorString)
1962 - return -1
1963 - else
1964 - print("ExecWithResultFunc() success : status type = ", type(status))
1965 - print("ExecWithResultFunc() success : status len = ", #status)
1966 - local num = #status
1967 - local i = 1
1968 - if num > 0 then
1969 - for i = 1, num, 1 do
1970 - local var = string.format("select result[%d] :Num = %d，Name = %s，Age = %d", i, status[i].Num, status[i].Name,status[i].Age) --Iterate through the data in the table, noting whether the elements are strings or numbers
1971 - print(var)
1972 - end
1973 - end
1974 - print("---------------")
1975 - end
1976 - return 0
1974 +
1975 +status, errorString = mysql.execWithResult("select * from tb_lua1;")
1976 +
1977 +if nil == status then
1978 +
1979 +print("ExecWithResultFunc() error:", errorString)
1980 +
1981 +return -1
1982 +
1983 +else
1984 +
1985 +print("ExecWithResultFunc()
1986 +
1987 +success
1988 +
1989 +: status
1990 +
1991 +type
1992 +
1993 +=
1994 +
1995 +",
1996 +
1997 +type(status))
1998 +
1999 +print("ExecWithResultFunc() success : status len = ", #status)
2000 +
2001 +local num = #status
2002 +
2003 +local i = 1
2004 +
2005 +if num > 0 then
2006 +
2007 +for i = 1, num, 1 do
2008 +
2009 +local var = string.format("select result[%d] :mykey = %d,
2010 +
2011 +value = %s", i, status[i].mykey, status[i].value)
2012 +
2013 +print(var)
2014 +
1977 1977  end
1978 1978  
1979 -function MySQL.main()
1980 - print("script running ...")
1981 - DataInitRight()
2017 +end
1982 1982  
1983 - -- use exec demo
1984 - if ExecFunc() < 0 then
1985 - return
1986 - end
2019 +print("---------------")
1987 1987  
1988 - -- use execWithResult demo
1989 - if ExecWithResultFunc() < 0 then
1990 - return
1991 - end
2021 +end
1992 1992  
1993 - print("script running success")
2023 +return 0
1994 1994  end
2025 +
2026 +function luaMysql_apiTest.main()
2027 +
2028 +print("script running ...")
2029 +
2030 +DataInitRight()
2031 +
2032 +--use exec demo
2033 +
2034 +if ExecFunc() < 0 then
2035 +
2036 +return
2037 +
2038 +end
2039 +
2040 +--use execWithResult demo
2041 +
2042 +if ExecWithResultFunc() < 0 then
2043 +
2044 +return
2045 +
2046 +end
2047 +
2048 +print("script running success")
2049 +
2050 +end
1995 1995  {{/code}}
1996 1996  
1997 1997  = **12 Message summary algorithm** =