100·ÖÇóÖú£¬¹ØÓÚJSPÏÂÌá½»ÖÐÎÄ×Ö·ûÈ¥MYSQLÂÒÂëÎÊÌâ¡£
jspÌá½»Ò³±àÂëÊÇUTF-8£¬MYSQL¿âÒ²ÊÇUTF-8,ΪʲôÌá½»ÁËÖÐÎÄ×Ö·ûÔÚÊý¾Ý¿âÀï±ä³ÉÂÒÂëÁËÄØ£¿
ÕâÖÖÎÊÌâÔõô½â¾ö£¿Ð»Ð»
ÁíÍ⣬JSPµ¯³ö¶Ô»°¿ò£¨±ÈÈ絯³ö¡°XXXÉóºËͨ¹ý¡±ÏÂÃæ¸úÈ·¶¨°´Å¥£©ºÍ·µ»ØÉÏÒ»Ò³ÒÔ¼°×ªµ½ÐÂURLÓ¦¸ÃÔõÃ´Ð´ÄØ£¿Ð»Ð»
jspÌá½»µ½µÃservletÖеÄdoPost»òÊÇdoGet·½·¨ÖУ¬È¡²ÎÊý֮ǰÏÈÖ´ÐÐrequest.setCharacterEncoding("UTF-8");
µÚ¶þµã¿ÉÒÔÓÃjs½â¾ö alert("*****");location.href="******"
·µ»ØÉÏÒ»Ò³ ÔÚservletÀïÃæ¿ÉÒÔresponse.sendRedirect(request.getRequestURL());
ÔÚjspÀïÃæ¿ÉÒÔÓà js: history.go(-1)
1.jspÒ³ÃæÉÏÓ¦¸ÃÊÇÀàËÆÕâÑùµÄ¸ñʽ£º
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ page import="java.sql.*" import="java.lang.*" %>
<%@page contentType="text/html; charset=UTF-8"%>
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<title>
</title>
</head>
<body>
<%
request.setCharacterEncoding("UTF-8");
%>
</body>
</html>
2.Êý¾Ý¿â±àÂë
CREATE TABLE `user` (
`id` int(11) NOT NULL auto_increme
Ïà¹ØÎÊ´ð£º
±¾ÈË×öÁËÒ»¸öÄ£Ä⹺ÎïÍøÕ¾£¬Óöµ½Ò»Ð©ÎÊÌâ¡£
µÚÒ»¸öÓû§Ñ¡ÔñÁËA¡¢B¡¢CÉÌÆ·
È»ºóµÚ¶þ¸öÓû§Ö»Ñ¡ÔñDÉÌÆ·¡£
µã»÷²é¿´µÄʱºò£¬¹ºÎï³µÁгöA¡¢B¡¢C¡¢DËÄÖÖÉÌÆ·£¬ÇëÎÊÄÄÀï³öÁËÎÊÌ⣿
Java code:
<%@ page content ......
<%@page language="java" contentType="text/html;charset=gb2312" import="java.sql.*"%>
<jsp:useBean id="db" class="wang.connectDB"/>
< ......
jsÖеķ½·¨£¬²»ÄÜÔÚjspÖе÷ÓÃÔõô½â¾ö£¿¼±£¡£¡!
²»Ã÷°×Òâ˼
ºÃºÃ¼ì²éÊDz»ÊÇ·¾¶µÄÎÊÌ⣬ºÜÓпÉÄÜ·¾¶²»¶Ôµ¼Öµ÷Óò»µ½
Ìùһϵ÷ÓõĴúÂë¿´¿´°¡~~
ÓÐûÓÐÕýÈ·ÒýÓÃjs£¿º¯ÊýÓÐûÓгõʼ»¯£¿....
jsp´úÂë±¾À´¾ ......
ÎÒÓÃjsp includeµÄpageÖ¸ÏòÉϼ¶Ä¿Â¼µÄjspÔõô»áÕÒ²»µ½ÄØ£¿ÎÒÊÇÕâÑùдµÄ
Java code:
<jsp:include flush="true" page="/supply/companyNews.jsp"></jsp:include>
webroo ......