¹ã¶«º£Ñó´óѧjsp¸´Ï°×ÊÁÏ JSPÔËÐÐÔÀí
µ±·þÎñÆ÷ÉϵÄÒ»¸ö JSP Ò³Ãæ±»µÚÒ»´ÎÇëÇóÖ´ÐÐʱ£¬·þÎñÆ÷É쵀 JSP ÒýÇæÊ×ÏȽ« JSPÒ³ÃæÎļþתÒë³ÉÒ»¸ö java Îļþ£¬ÔÙ½«Õâ¸ö java Îļþ±àÒëÉú³É×Ö½ÚÂëÎļþ£¬È»ºóͨ¹ýÖ´ÐÐ×Ö½ÚÂëÎļþÏìÓ¦¿Í»§µÄÇëÇ󣬶øµ±Õâ¸ö JSP Ò³ÃæÔٴα»ÇëÇóÖ´ÐÐʱ£¬JSP ÒýÇæ½«Ö±½ÓÖ´ÐÐÕâ¸ö×Ö½ÚÂëÎļþÀ´ÏìÓ¦¿Í»§£¬ÕâÒ²ÊÇ JSP ±È ASP ËÙ¶È¿ìµÄÒ»¸öÔÒò¡£¶ø JSP Ò³ÃæµÄÊ×´ÎÖ´ÐÐÍùÍùÓÉ·þÎñÆ÷¹ÜÀíÕßÀ´Ö´ÐС£Õâ¸ö×Ö½ÚÂëÎļþµÄÖ÷Òª¹¤×÷ÊÇ£º
1¡¢°Ñ JSP Ò³ÃæÖÐÆÕͨµÄ HTML ±ê¼Ç·ûºÅ£¨Ò³ÃæµÄ¾²Ì¬²¿·Ö£©½»¸øÓû§µÄä¯ÀÀÆ÷¸ºÔðÏÔʾ¡£
2¡¢¸ºÔð´¦ÀíJSP±ê¼Ç,²¢½«ÓйصĴ¦Àí½á¹û·¢Ë͵½Óû§µÄä¯ÀÀÆ÷.
3¡¢Ö´ÐС°<%¡±ºÍ¡°%>¡±Ö®¼äµÄ java ³ÌÐòƬ£¨JSP Ò³ÃæÖеĶ¯Ì¬²¿·Ö£©£¬²¢°ÑÖ´Ðнá¹û½»¸øÓû§µÄä¯ÀÀÆ÷ÏÔʾ¡£
4¡¢µ±¶à¸öÓû§ÇëÇóÒ»¸ö JSP Ò³ÃæÊ±£¬Tomcat·þÎñÆ÷Ϊÿ¸öÓû§Æô¶¯Ò»¸öÏ̶߳ø²»ÊÇÆô¶¯Ò»¸ö½ø³Ì£¬ÕâЩÏß³ÌÓÉ Tomcat·þÎñÆ÷À´¹ÜÀí£¬Ó봫ͳµÄ CGI Ϊÿ¸ö¿Í»§Æô¶¯Ò»¸ö½ø³ÌÏà±È½Ï£¬Ð§ÂÊÒª¸ßµÄ¶à¡£
×¢Ò⣺Èç¹û¶ÔJSPÒ³Ãæ½øÐÐÁËÐ޸ġ¢±£´æ£¬ÄÇô·þÎñÆ÷»áÉú³ÉеÄ×Ö½ÚÂë¡£ÎÒÃÇ¿ÉÒÔÔÚ·þÎñÆ÷ϵÄ\\work\\Catalina\\localhost\\_\\org\\apache\\jspĿ¼ÏÂÕÒµ½·þÎñÆ÷Éú³ÉµÄJSPÒ³Ãæ¶ÔÓ¦µÄJAVAÎļþ£¬ÒÔ¼°±àÒëJAVAÎļþµÃµ½µÄ×Ö½ÚÂëÎļþ¡£ JSPÖ¸Áî±ê¼Ç
<%@ page contentType=¡±text/html;charset=GB2312¡±%> <%@ page import= ¡°java.util.*¡±£¬¡°java.io.*¡±%>
Èç¹ûÐèÒªÔÚJSPÒ³ÃæµÄij´¦ÕûÌå²åÈëÒ»¸öÎļþ£¬¿ÉÒÔʹÓÃincludeÖ¸Áî±ê¼Ç£¬Æä±ê¼ÇÓ﷨Ϊ£º<%@ include file=¡±ÎļþµÄURL¡±%>
¸ÃÖ¸Áî±ê¼ÇµÄ×÷ÓÃÊÇÔÚJSPÒ³Ãæ³öÏÖ¸ÃÖ¸ÁîµÄλÖô¦£¬¾²Ì¬²åÈëÒ»¸öÎļþ¡£
include ¶¯×÷±êÇ©¸ñʽΪ£º
<%@ taglib tagdir=¡±/WEB-INF/tags¡± prefix=¡±show¡±%> <%@ tag pageEncoding=¡±utf-8¡±%>
<%@ attribute name=¡±result¡± required=¡±true¡± type=¡±java.lang.Double¡±%>
<%@ variable name-given=¡±time¡± variable-class=¡±java.util.Date¡± scope=¡±AT_END¡±%>
JSPÄÚÖöÔÏó
pageContext.setAttribute(¡°page¡±,¡±hello¡±); getParameter(String s)·½·¨»ñÈ¡±íµ¥Ìá½»¹ýÀ´µÄÐÅÏ¢¡£ request.setCharacterEncoding(¡°utf-8¡±)£» response.setContentType(¡°utf-8¡±)£»
request¶ÔÏó»ñÈ¡ÇëÇóËùÌá½»µÄ¸÷ÀàÐÅÏ¢¡£
getMethod()£º»ñÈ¡Óû§Ìá½»ÐÅÏ¢µÄ·½Ê½¡£ÀýÈçpost»òget. getSchema£¨£©£º»ñµÃµ±Ç°Ò³ÃæÊ¹ÓõÄÐÒ飺ÀýÈçhttp.
getRemoteHost()£º»ñÈ¡Óû§»úµÄÃû³Æ£¨Èç¹û»ñÈ¡²»µ½£¬¾Í»ñÈ¡IPµØÖ·£©¡£ getParameterNames()£º»ñÈ¡Óû§Ìá½»µÄÐÅÏ¢Ì岿·ÖÖÐname²ÎÊýÖµµÄÒ»¸öö¾Ù¡£ ±ê¼Ç ¸´Ñ¡¿òcheckbox
Òþ²Øhidden
response¶ÔÏóµÄsendRedirect(URL url)·½·¨ÊµÏÖÓû§µÄÖØ¶¨Ïò¡£
response¶ÔÏóµ÷ÓÃencodeURL()»òencodeRedirectURL()·½·¨ÊµÏÖURLÖØÐ´¡£ ʹÓÃJavaÊý¾Ý¿âÇý¶¯³ÌÐò 1.¼ÓÔØJavaÊý¾Ý¿âÇý¶¯³ÌÐò
try{Class.forName(¡°com.microsoft.sqlserver.jdb- c.SQLServerDriver¡±)£» }catch(Exccption e){ System.out.println(e)£» }
2.½¨Á¢Á¬½Ó
try{ String uri=¡°jdbc:sqlserver://192.168.100.1:1433;Database-Name=Warehouser¡±£» String user=¡±¡±;
String password=¡±sa¡±;
con=DriverManager.getConnection(uri,user,passw- ord);
}catch(Exccption e){ System.out.println(e)£» }
Ëæ»ú²éѯ
Statement stmt=con.createStatement(int type,int concurrency)£» ResultSet re=stmt.executeQuery(SQLÓï¾ä)£» typeµÄȡֵ¾ö¶¨¹ö¶¯·½Ê½£¬È¡Öµ¿ÉÒÔÊÇ£º ResultSet.TYPE_FORWORD_ONLY; ResultSet.TYPE_SCROLL_INSENSITIVE; ResultSet.TYPE_SCROLL_SENSITIVE;
concurrencyȡֵ¾ö¶¨ÊÇ·ñ¿ÉÒÔÓýá¹û¼¯¸üÐÂÊý¾Ý¿â£¬È¡Öµ¿ÉÒÔÊÇ£º ResultSet.CONCUR_READ_ONLY; ResultSet.CONCUR_UPDATABLE; »ñÈ¡ºÍÐÞ¸ÄbeanµÄÊôÐÔ
ͨ¹ýHTTP±íµ¥µÄ²ÎÊýµÄÖµÀ´ÉèÖÃbeanµÄÏàÓ¦ÊôÐÔµÄÖµ