用JSP生成靜態頁面

2024-09-05 00:21:36

字體：大中小

來源：轉載

供稿：網友

主要原理請參考?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中就沒有#**#標志了。所以要重新生成
{
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 cellpadding="0" cellspacing="1" bgcolor="#FFCC99">
<tr>
<td bgcolor="#FFCC99"><div>#title#</div></td>
</tr>
<tr>
<td bgcolor="#FFFFFF">#content#</td>
</tr>
<tr>
<td bgcolor="#FFFFFF">#author#</td>
</tr>
</table>
</body>
</html>