Changes for page 01 Lua Functions

Summary

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

Details

Page properties

Content

...	...	@@ -1872,130 +1872,10 @@
1872	1872
1873	1873	Failed: nil
1874	1874
1875		-= **11 MySQL database operation** =
	1875	+= (% style="font-size:14px" %) (%%) =
1876	1876
1877		-== **luaMySql.init(string sourcename, string username, string password, string host, number port, string character)** ==
	1877	+= **11 Message summary algorithm** =
1878	1878
1879		-**Function:** Configure database connection parameters
1880		-
1881		-**Parameter:**
1882		-
1883		-sourcename: the name of database
1884		-
1885		-username: the username of the connection
1886		-
1887		-password: the password of the connection
1888		-
1889		-host: the host name of the connection
1890		-
1891		-port: the host port of the connection
1892		-
1893		-character: the character set of the connection
1894		-
1895		-**Return:**
1896		-
1897		-Succeed: string
1898		-
1899		-Failed: multi
1900		-
1901		-== **luaMySql.exec(string statement)** ==
1902		-
1903		-**Function:** Execute the given SQL statement without returning the result set (add, delete, change)
1904		-
1905		-**Parameter:**
1906		-
1907		-statement: the given SQL statement
1908		-
1909		-**Return:**
1910		-
1911		-Succeed: status: returns the number of rows affected by SQL statement execution.
1912		-
1913		-Failed: nil, errorString
1914		-
1915		-== **luaMySql.execWithResult(string statement)** ==
1916		-
1917		-**Function:** Execute the given SQL statement returning the result set (check)
1918		-
1919		-**Parameter:**
1920		-
1921		-statement: the given SQL statement
1922		-
1923		-**Return:**
1924		-
1925		-Succeed: table: returns the result set
1926		-
1927		-Failed: nil, errorString
1928		-
1929		-**For example:**
1930		-
1931		-{{code language="LUA"}}
1932		--- Assuming the "mysqlclient" library is properly installed and available
1933		-mysql = require("mysqlclient")
1934		-
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)
1944		-end
1945		-
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
1955		-end
1956		-
1957		-
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
1977		-end
1978		-
1979		-function MySQL.main()
1980		- print("script running ...")
1981		- DataInitRight()
1982		-
1983		- -- use exec demo
1984		- if ExecFunc() < 0 then
1985		- return
1986		- end
1987		-
1988		- -- use execWithResult demo
1989		- if ExecWithResultFunc() < 0 then
1990		- return
1991		- end
1992		-
1993		- print("script running success")
1994		-end
1995		-{{/code}}
1996		-
1997		-= **12 Message summary algorithm** =
1998		-
1999	1999	== **hmac(string hash_func, string key, string message)** ==
2000	2000
2001	2001	**Function:** HMAC calculate