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**
...	...	@@ -1872,8 +1872,184 @@
1872	1872
1873	1873	Failed: nil
1874	1874
1875		-= (% style="font-size:14px" %) (%%) =
	1887	+= **11 MySQL database operation** =
1876	1876
	1889	+== **luaMySql.init(string sourcename, string username, string password, string host, number port, string character)** ==
	1890	+
	1891	+**Function:** Configure database connection parameters
	1892	+
	1893	+**Parameter:**
	1894	+
	1895	+sourcename: the name of database
	1896	+
	1897	+username: the username of the connection
	1898	+
	1899	+password: the password of the connection
	1900	+
	1901	+host: the host name of the connection
	1902	+
	1903	+port: the host port of the connection
	1904	+
	1905	+character: the character set of the connection
	1906	+
	1907	+**Return:**
	1908	+
	1909	+Succeed: string
	1910	+
	1911	+Failed: multi
	1912	+
	1913	+== **luaMySql.exec(string statement)** ==
	1914	+
	1915	+**Function:** Execute the given SQL statement without returning the result set (add, delete, change)
	1916	+
	1917	+**Parameter:**
	1918	+
	1919	+statement: the given SQL statement
	1920	+
	1921	+**Return:**
	1922	+
	1923	+Succeed: status: returns the number of rows affected by SQL statement execution.
	1924	+
	1925	+Failed: nil, errorString
	1926	+
	1927	+== **luaMySql.execWithResult(string statement)** ==
	1928	+
	1929	+**Function:** Execute the given SQL statement returning the result set (check)
	1930	+
	1931	+**Parameter:**
	1932	+
	1933	+statement: the given SQL statement
	1934	+
	1935	+**Return:**
	1936	+
	1937	+Succeed: table: returns the result set
	1938	+
	1939	+Failed: nil, errorString
	1940	+
	1941	+**For example:**
	1942	+
	1943	+{{code language="LUA"}}
	1944	+mysql = require"mysqlclient"
	1945	+
	1946	+function DataInitRight()
	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	+
	1961	+end
	1962	+
	1963	+function ExecFunc()
	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	+
	1979	+end
	1980	+
	1981	+return 0
	1982	+
	1983	+end
	1984	+
	1985	+function ExecWithResultFunc()
	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	+
	2027	+end
	2028	+
	2029	+end
	2030	+
	2031	+print("---------------")
	2032	+
	2033	+end
	2034	+
	2035	+return 0
	2036	+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
	2063	+{{/code}}
	2064	+
1877	1877	= **12 Message summary algorithm** =
1878	1878
1879	1879	== **hmac(string hash_func, string key, string message)** ==