Mysql jspÂÒÂëÎÊÌ⣡£¡
jspÒ³ÃæÓõÄÊÇ contentType="text/html; charset=gb2312"
mysqlÁ¬½ÓÓÃµÄ DBURL = "jdbc:mysql://localhost:3306/hrsystem?user= &password= &" +
"useUnicode=true&characterEncoding=gb2312";
mysql°²×°Ê±²ÉÓõÄÊÇgb2312±àÂ룬ÔÚ´´½¨Êý¾Ý¿â µÄʱºòÎÒÓÖ¼ÓÁËENGINE=MyISAM DEFAULT CHARSET=gb2312
serlvet ÓÃµÄ response.setCharacterEncoding("gb2312");
myeclipse±àÂë ¸Ä³ÉÁËGBK
»¹ÊÇÓÐÂÒÂë
ÎÒÊDz»ÊÇ»¹Ó¦¸Ã½« servletÖÐµÄ String em_visage = request.getParameter("em_visage");ÕâÖÖ½ÓÊÕ²ÎÊýµÄÓï¾äÔÙ¼ÓÉϱàÂëת»»£¬ÓÃÄǸöʲô String em_visage = new String((request.getParameter("em_visage").getBytes("ISO8859-1"),"GB2312"); ²»¹ýÎÒÔõô¶¼¸Ð¾õûÕâ¸ö±ØÒªÁË£¡£¡
ÊÔһϣºresponse.setContentType("text/html;charset=gbk");
response.setContentType("text/html");ÎÒÒѾµ¥¶À¼ÓÁË£¬Ö»ÊǰÑËü·Ö³ÉÁ½¾äÁ˶øÒÑ£¡
request.setCharacterEncoding("gb2312");
response.setContentType("text/html;charset=gb2312");
ÕâÁ½¸öÓï¾äÒªÔÚ»ñÈ¡±íµ¥ÖµÖ®Ç°ÉèÖá£
mysql°²×°Ê±¾Í²ÉÓÃutf-8±àÂë
contentType="text/html; charset=utf-8"
ÎÒ¶¼ÊÇÕâô×öµÄûÓÐÂÒÂëµÄÎÊÌâ!!!!!
Èç¹ûÁËget´«²ÎÊý£¨url´«µÝÊÇget´«µÝµÄ£©µÄ»°¾ÍҪת»»
String em_visage = new String((request.getParameter("em_visage").getBytes("ISO-8859-1"),"GB2
Ïà¹ØÎÊ´ð£º
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË
¼Æ»®ÈÎÎñ...php....sql...truncate....OK
Äã¾ÍÕâ½ÓÔÚҳà ......
ÎÊÌâÃèÊö£º
ÀýÈçÎÒÒªÏÔʾµÄÄÚÈÝÈçÏÂËùʾ
Ò»¼¶Ä¿Â¼1
Ò»¼¶Ä¿Â¼1×ÓÀà1
×ÓÀà1
Ò»¼¶Ä¿Â¼1×ÓÀà2
......
Ò»¸öJSPÒ³Ãæ½ÓÊÕÆäËûÒ³ÃæÌá½»¹ýÀ´µÄFORM±íµ¥£¬µ«ÊÇÒªÇóÖ»½ÓÊÕµ±Ç°Õ¾µã¼°Æä×ÓÕ¾µãÌá½»¹ýÀ´µÄFORM±íµ¥£¬ÆäËûÕ¾µãÌá½»¹ýÀ´µÄ±íµ¥²»½ÓÊÕ£¬Õâ¸öÔõôÉèÖã¿
ÓùýÂËÆ÷
filter
½«µ±Ç°Õ¾µã¼°Æä×ÓÕ¾µã·ÅÒ»¸öĿ¼
È» ......
ÏÈÉÏ´íÎó
ÎÞ·¨Áª½ÓÊý¾Ý¿â
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: ......