JSPÉú³É¾²Ì¬Ò³Ãæ
JDK 1.5 +ECLIPSE +TOMCAT 5.0.28 + MYSQL 5.0
Êý¾Ý¿âTEST¡¡£¬±íÃûnews
×ֶΣº¡¡id int ×Ô¶¯Ôö³¤¡¡, Title varchar(20) , Content varchar(200) , Author varchar(10)
makeFile.jsp
<%
Connection conn = DBconn.getConnection();
Statement stmt = conn.createStatement();
ResultSet Rs = stmt.executeQuery("select * from news");
System.out.println("success");
%>
<%
String filePath = request.getRealPath("/")+"template.htm";
System.out.println(filePath);
String templateContent;
FileInputStream fileinputstream = new FileInputStream(filePath);
int lenght = fileinputstream.available(); //available() ·µ»Ø¿ÉÒÔ²»ÊÜ×èÈûµØ´Ó´ËÎļþÊäÈëÁ÷ÖжÁÈ¡µÄ×Ö½ÚÊý¡£
byte bytes[] = new byte[lenght];
fileinputstream.read(bytes); //read(byte[] b) ´Ó´ËÊäÈëÁ÷Öн«×î¶à b.length ¸ö×Ö½ÚµÄÊý¾Ý¶ÁÈëÒ»¸ö×Ö½ÚÊý×éÖС£
fileinputstream.close();
//templateContent = new String(bytes);
String title;
String content;
String author;
while(Rs.next())
{
templateContent = new String(bytes);//Èç¹û²»ÓÃÕâ¾ä£¬ÔòÌæ»»Ò»´ÎÖ®ºó£¬templateContentÖоÍûÓÐ#**#±êÖ¾ÁË¡£ËùÒÔÒªÖØÐÂÉú³É
title = Rs.getString("Title");
content = Rs.getString("Content");
author = Rs.getString("Author");
out.println(title+"********"+content+"****"+author);
out.print("ÒÔÏÂÊÇÄ£°åÄÚÈÝ£º<br>"+templateContent+"<br> ÒÔÏÂÊÇÖû»ÒÔºóµÄhtmlÄÚÈÝ<br><hr>");
templateContent=templateContent.replaceAll("#title#",title);
templateContent=templateContent.replaceAll("#author#",author);//Ìæ»»µôÄ£¿éÖÐÏàÓ¦µÄµØ·½
templateContent=templateContent.replaceAll("#content#",content);
// ¸ù¾Ýʱ¼äµÃÎļþÃû
Calendar calendar = Calendar.getInstance();
String fileame = String.valueOf(calendar.getTimeInMillis()) +".html";
fileame = request.getRealPath("/")+"Html/"+fileame;//Éú³ÉµÄhtmlÎļþ±£´æ·¾¶
out.print(
Ïà¹ØÎĵµ£º
JSP ÈçºÎʵÏÖÍøÒ³¶¨Ê±Ìøת:
<script language="javascript">
<!--
setTimeout("document.location.href='http://www.163.com'",3000);
//-->
</script>
ˢУº
<meta http-equiv="Refresh" content ......
JSP ʵÔÚservlet Ö®ºó·¢Õ¹ÆðÀ´µÄ¼¼Êõ¡£
ÔËÐлúÖÆ£º
1£ºjspÎļþÌá½»·þÎñÆ÷£¬·þÎñÆ÷ £¨Tomcat£©£¬³õʼ»¯ ÇëÇóºÍÏìÓ¦¶ÔÏó £¬È»ºóÅжÏjspÎļþÊÇ·ñ´æÔÚ £¬Èç¹û²»´æÔÚ 404 ´íÎ󣬴æÔÚ £¬±àÒë³ÉΪ ¡£java Îļþ ----¡·¡£class Îļþ ¡£¾ÍÊÇÒ»¸öjavaµÄÀà £¬Õâ¸öÀà £¬¼Ì³Ð×Ô httpjspbase £¬Õâ¸öhttpjsppageÀà ÓÖ ÊµÏÖÁË» ......
дһ¸öjspÎļþ,È»ºó°ÑÒª´ÓÊý¾Ý¿âÈ¡³öÊý¾ÝµÄsqlÓï¾ä´«µ½servlet ÖÐ.
java ´úÂë:
package exportExcel;
import java.io.File;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.OutputStream;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLExcep ......
ÔÚJSP/Servlet ÖÐÖ÷ÒªÓÐÒÔϼ¸¸öµØ·½¿ÉÒÔÉèÖñàÂ룬pageEncoding="UTF-8"¡¢contentType="text/html;charset=UTF -8"¡¢request.setCharacterEncoding("UTF-8")ºÍresponse.setCharacterEncoding ("UTF-8")£¬ÆäÖÐÇ°Á½¸öÖ»ÄÜÓÃÓÚJSPÖУ¬¶øºóÁ½¸ö¿ÉÒÔÓÃÓÚJSPºÍServletÖС£
1¡¢pageEncoding="UTF-8"µÄ×÷ÓÃÊÇÉèÖÃJSP±àÒë³É ......
1.¶¨Òå±êǩʵÏÖÀà
ParentTag.java
import java.io.IOException;
import java.util.HashMap;
import java.util.Iterator;
import java.util.Map;
import java.util.Set;
import javax.servlet.jsp.JspException;
import javax.servlet.jsp.JspWriter;
import javax.servlet.jsp.tagext.TagSupport;
public c ......