Changes for page 01 Lua Functions

Summary

• Page properties (2 modified, 0 added, 0 removed)

Details

Page properties

Author

...	...	@@ -1,1 +1,1 @@
1		-XWiki.AiXia
	1	+XWiki.Hunter

Content

...	...	@@ -1,5 +1,17 @@
1	1	= **1 Interface description** =
2	2
	3	+(% style="width:749.222px" %)
	4	+|=(% scope="row" style="width: 374px;" %)z|=(% style="width: 373px;" %)cxz
	5	+|=(% style="width: 374px;" %) |(% style="width:373px" %)
	6	+|=(% style="width: 374px;" %) |(% style="width:373px" %)
	7	+
	8	+|分类|宽|高
	9	+|网页全屏|700-850|400
	10	+|手机全屏|300|400
	11	+|其他大图片|400左右|400左右
	12	+|小图片|200左右|200左右
	13	+
	14	+
3	3	== **Data type definition** ==
4	4
5	5	|=**Type**|=**Description**
...	...	@@ -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")
	1944	+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)
	1947	+
	1948	+local dbName = "db_lua1"
	1949	+
	1950	+local user = "root"
	1951	+
	1952	+local pwd = "123456"
	1953	+
	1954	+local host = "192.168.56.186"
	1955	+
	1956	+local port = 3306
	1957	+local character = "UTF8"
	1958	+
	1959	+mysql.init(dbName, user, pwd, host, port, character)
	1960	+
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
	1964	+
	1965	+status, errorString = mysql.exec("delete from tb_lua1 where mykey =
	1966	+
	1967	+10;")
	1968	+
	1969	+if nil == status then
	1970	+
	1971	+print("ExecFunc() error:", errorString)
	1972	+
	1973	+return -1
	1974	+
	1975	+else
	1976	+
	1977	+print("the number of rows affected by the command:", status)
	1978	+
1955	1955	end
1956	1956
	1981	+return 0
1957	1957
	1983	+end
	1984	+
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
	1986	+
	1987	+status, errorString = mysql.execWithResult("select * from tb_lua1;")
	1988	+
	1989	+if nil == status then
	1990	+
	1991	+print("ExecWithResultFunc() error:", errorString)
	1992	+
	1993	+return -1
	1994	+
	1995	+else
	1996	+
	1997	+print("ExecWithResultFunc()
	1998	+
	1999	+success
	2000	+
	2001	+: status
	2002	+
	2003	+type
	2004	+
	2005	+=
	2006	+
	2007	+",
	2008	+
	2009	+type(status))
	2010	+
	2011	+print("ExecWithResultFunc() success : status len = ", #status)
	2012	+
	2013	+local num = #status
	2014	+
	2015	+local i = 1
	2016	+
	2017	+if num > 0 then
	2018	+
	2019	+for i = 1, num, 1 do
	2020	+
	2021	+local var = string.format("select result[%d] :mykey = %d,
	2022	+
	2023	+value = %s", i, status[i].mykey, status[i].value)
	2024	+
	2025	+print(var)
	2026	+
1977	1977	end
1978	1978
1979		-function MySQL.main()
1980		- print("script running ...")
1981		- DataInitRight()
	2029	+end
1982	1982
1983		- -- use exec demo
1984		- if ExecFunc() < 0 then
1985		- return
1986		- end
	2031	+print("---------------")
1987	1987
1988		- -- use execWithResult demo
1989		- if ExecWithResultFunc() < 0 then
1990		- return
1991		- end
	2033	+end
1992	1992
1993		- print("script running success")
	2035	+return 0
1994	1994	end
	2037	+
	2038	+function luaMysql_apiTest.main()
	2039	+
	2040	+print("script running ...")
	2041	+
	2042	+DataInitRight()
	2043	+
	2044	+--use exec demo
	2045	+
	2046	+if ExecFunc() < 0 then
	2047	+
	2048	+return
	2049	+
	2050	+end
	2051	+
	2052	+--use execWithResult demo
	2053	+
	2054	+if ExecWithResultFunc() < 0 then
	2055	+
	2056	+return
	2057	+
	2058	+end
	2059	+
	2060	+print("script running success")
	2061	+
	2062	+end
1995	1995	{{/code}}
1996	1996
1997	1997	= **12 Message summary algorithm** =