Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÓÃ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 **ÀàÐ͵ġ£¡£¡£


Ïà¹ØÎÊ´ð£º

sqlÓï¾ä¶à±í¶à×ֶβéѯ - MS-SQL Server / »ù´¡Àà

ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд 

ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ
ÀýÈç£ ......

jspÁ´½Ósql2000µÄÒÉÎÊ£¿



type Exception report


message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jas ......

eclipseÁ¬½ÓmysqlÊý¾Ý¿â - Java / Eclipse

ÏÈÉÏ´íÎó
ÎÞ·¨Áª½ÓÊý¾Ý¿â
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: ......

mysqlÁ¬½Ótomcat - Java / Web ¿ª·¢

ÎÒÒѾ­°´Õս̳ÌÉÏÅäÖÃtomcatµÄserver.xml
<Context path = "/POS" docBase = "POS" debug = "5" reloadable = "true" crossContext = "true" workDir = &quo ......

mysqlÊý¾Ý¿â - Java / JavaÏà¹Ø

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 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ