ÓÃMYSQLµÄAPI£¬¹ØÓÚSQLʹÓõÄÎÊÌ⣬Çë´ïÈ˰ïæ½â»ó¡£
C/C++ code: char chSQL[1024] = {0}; MYSQL mysql; strcat(chSQL, "select LOGIN_PWD from SYS_USER_TBL where LOGIN_NAME = '"); strcat(chSQL, chName); strcat(chSQL, "'"); mysql_real_query(&mysql, chSQL, strlen(chSQL)); ²»ÖªµÀÒÔÉϲéѯÓдíû£¿È»ºó²»ÖªµÀÔõôÅжÏÊÇ·ñ²éѯµ½PWD,Èç¹û²éµ½£¬PWDµÄÖµÔõô·µ»Ø£¿Çë´ïÈËÖ¸µãÒ»¶þ£¬Ð»Ð»¡£
ÊÔÊÔ²»¾ÍÖªµÀÁË ´úÂë¶¼²»»áд£¬ÔõôÊÔѽ£¿£¿Õâ¸öº¯Êý·µ»ØµÄºÃÏñÊÇÒ»¸öINTÐ͵ģ¬ÒÔǰÓÃSQLµÄʱºò¶¼ÊÇÖ±½Ó·µ»Ø½á¹ûµÄ£¬²»ÖªµÀ½ÓÏÂÀ´µÄ²½ÖèÊÇʲôÁË¡£ÒýÓà mysql_real_query(&mysql, chSQL, strlen(chSQL)); MYSQL_RES * res; MYSQL_ROW row ; res = mysql_store_result row = mysql_fetch_row( res ) ; лл£¬ÊDz»ÊÇËùÓзûºÏ²éѯµÄ½á¹û¾Í¶¼´æÔÚrowÀïÁË£¿ÎÒ¿´Õâ¸öÊÇchar **ÀàÐ͵ġ£¡£¡£
Ïà¹ØÎÊ´ð£º
ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ ÀýÈç£ ......
type Exception report message description The server encountered an internal error () that prevented it from fulfilling this request. exception org.apache.jas ......
ÏÈÉÏ´íÎó ÎÞ·¨Áª½ÓÊý¾Ý¿â java.sql.SQLException: Before start of result set at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910) at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java: ......
ÎÒÒѾ°´Õս̳ÌÉÏÅäÖÃtomcatµÄserver.xml <Context path = "/POS" docBase = "POS" debug = "5" reloadable = "true" crossContext = "true" workDir = &quo ......
CREATE DATABASE ADDRESSLIST; USE ADDRESSLIST; DROP TABLE IF EXISTS FRIEND; CREATE TABLE FRIEND (FRIEND_ID INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY , FRIEND_NAME VARCHAR(20) NOT N ......