用JSP生成静态页面

2024-09-05 00:19:18

字体：大中小

来源：转载

供稿：网友

主要原理请参考http://blog.hunan2s.com/article.asp?id=233
经过一翻调试，成功了。。呵
附上源码。。

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(templatecontent);
fileoutputstream fileoutputstream = new fileoutputstream(fileame);//建立文件输出流
byte tag_bytes[] = templatecontent.getbytes();
fileoutputstream.write(tag_bytes);
fileoutputstream.close();
}
if(conn!=null)
    {
        conn.close();
    }
    if(stmt!=null)
    {
        stmt.close();
    }

%>
//数据库连接文件
import java.sql.*;
public class dbconn {
    public dbconn() {
        // todo auto-generated constructor stub
    }
    public static connection getconnection()
    {
        connection conn = null;
        try {
            class.forname("org.gjt.mm.mysql.driver");
            conn = drivermanager.getconnection("jdbc:mysql://" + "localhost" + "/" + "test" +
        "?useunicode=true&characterencoding=gb2312","root","111111");
        }
        catch(exception e)
        {
            e.printstacktrace();
        }
        return conn;
        }
    /*public static void main(string[] args) throws exception
    {
        connection con=getconnection();
        system.out.println(con.isclosed());
    }
*/
}

//　模板文件
template.htm
<!doctype html public "-//w3c//dtd xhtml 1.0 transitional//en" "http://www.w3.org/tr/xhtml1/dtd/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="content-type" content="text/html; charset=gb2312" />
<title>#title#</title>
</head>
<body>
<table width="380" height="107" border="0" cellpadding="0" cellspacing="1" bgcolor="#ffcc99">
<tr>
    <td height="16" bgcolor="#ffcc99"><div align="center">#title#</div></td>
</tr>
<tr>
    <td bgcolor="#ffffff">#content#</td>
</tr>
<tr>
    <td height="13" align="right" bgcolor="#ffffff">#author#</td>
</tr>
</table>
</body>
</html>