JSPÖÐÏòmysqlÖÐÊäÈ뺺×Ö£¬Êý¾Ý¿âÏÔʾ"???"
±¾ÈËÔÚJspÒ³ÃæÖУ¬ÊäÈ뺺×Ö£¬Êý¾Ý¿âÈ´´æ´¢Ð©ÂÒÂ룬½ø¶øÔÚJSPÒ³ÃæÉϲéѯÊý¾Ý¿âÉϵÄÐÅÏ¢£¬¸Õ²ÅÊäÈëµÄºº×ÖÐÅÏ¢ÔòÒÔ¡°£¿£¿£¿¡°ÏÔʾ¡£Èç¹û֮ǰÔÚÊý¾Ý¿âÖд洢ºº×Ö£¬JSPÖпÉÒÔÕý³£ÏÔʾ¡£ÇëÎÊÊÇʲôÔÒò£¿
±¾È˰Ñ×Ô¼ºµÄÅäÖû·¾³ËµÒ»Ï¡£MyEclipse 6.0£¬MySQL Server 5.1£¬Tomcat 5.5£¬jdk1.6.0_14¡£
mysqlµÄmy.iniÎļþÖÐ
default-character-set=gbk£¬
# The default character set that will be used when a new schema or table is
# created and no character set is defined
default-character-set=gbk
JSPÖÐÌí¼ÓÁË <%@page contentType="text/html;charset=GBK"%>
<%@page pageEncoding="GBK"%>
<%
request.setCharacterEncoding("GBK");
%>
ÔÚurlÖÐÒ²¼ÓÁËuseUnicode=true&characterEncoding=GBK
½á¹û»¹ÊÇÕâÑù¡£ËÄÜÂé·³°ïÎÒ½âÊͽâÊÍÔÒò£¬ÒÔ¼°ÎÊÌâ³öÔÚÄÄ¡£ÎÒÓдúÂ룬Èç¹ûÏëÒª¸øÎÒ·¢Óʼþdongqin40604@126.com
³öÏÖÂÒÂë¡£×îºÃͳһËùÓбàÂëΪutf-8!!!
ÉèÖÃmysql Êý¾Ý¿âµÄcharset
ͳһΪgbk²»ÐÐÂð£¿
Êý¾Ý¿âµÄcharsetÉèÖÃÁË£¬µ«ÊÇ»¹ÊDz»ºÃÓÃ
×îºÃÔÚ°²×°µÄʱºò ÉèÖ㬻òÕßÔÚ´´½¨±íµÄʱºò×Ö¶ÎÉèÖÃ
ËäÈ»ÎÒ²»ÊÇÔÚ°²×°Êý¾Ý¿âµÄʱºòÉèÖõġ£ÎÒʵÔÚmy.iniÖÐÐ޸ĵģ¬È»ºóÖØÆôµÄMysqlµÄ·þÎñÆ÷£¬ÓÖÖØÐ´´½¨µÄÊý¾Ý¿â£¬±í¡£±íµÄ×ֶξùÏÔʾÊÇgbkµÄ¸ñʽÁË
»»³ÉUTF-8µÄÊÔÊÔ
»Ø¸´ÄÚÈݲ»¶Ì~~
useUnicode=true&characterEncoding=utf-8
ÔøÊÔ¹ýUTF-8µÄ£¬µ±Ê±Êý¾Ý¿âÊÇÕâ¸ö¸ñʽ£¬Ò²²»ÖªµÀÊDz»ÊÇ´úÂëû¸ÄÈ«£¬¸Ä¹ýÒ»²¿·ÖÖ®ºó£¬JSPÒ³ÃæÉϺº×ÖÒ²ÏÔʾ²»³öÀ´ÁË£¬È«ÊÐÂÒÂ룬ºóÀ´ÓָĻØg
Ïà¹ØÎÊ´ð£º
<%@page language="java" contentType="text/html;charset=gb2312" import="java.sql.*"%>
<jsp:useBean id="db" class="wang.connectDB"/>
< ......
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË
¼Æ»®ÈÎÎñ...php....sql...truncate....OK
Äã¾ÍÕâ½ÓÔÚҳà ......
ÏÈÉÏ´íÎó
ÎÞ·¨Áª½ÓÊý¾Ý¿â
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: ......
×î½üÓöµ½Ò»Ð© jspÒ³ÃæµÄȡֵ¡£Ã»Óмû¹ý¡£Ò²²»ÖªµÀʲôÒâ˼¡£ÄÄλ´óÏÀ¸øÎÒ˵˵ ȡֵµÄÖÖÀàºÍ·½·¨°¡
request.getParameter£¬»òÕßÓÃbean£¬¼´ÔÚjspÒ³ÃæÖÐÉùÃ÷jsp:usebeanÖ®ºó¿ÉÒÔÖ±½Ósetproperty »òÕßgetproperty¡£Ò ......