当前位置: 代码迷 >> Java Web开发 >> jsp中如何把数据从数据库导出在页面直接生成html格式?
  详细解决方案

jsp中如何把数据从数据库导出在页面直接生成html格式?

热度:92   发布时间:2016-04-17 13:20:04.0
jsp中怎么把数据从数据库导出在页面直接生成html格式??
jsp中怎么把数据从数据库导出在页面直接生成html格式??

------解决方案--------------------
先建立一个模板页面:template.htm
<html> <head> <title> ###title### </title>
<meta http- equiv= "Content-Type " content= "text/html; charset=gb2312 ">
<LINK href= "../css.css " rel=stylesheet type=text/css> </head>
<body>
<table width= "500 " border= "0 " align= "center " cellpadding= "0 " cellspacing= "2 ">
<tr> <td align= "center "> ###title### </tr>
<tr> <td align= "center "> 作者:###author### </tr>
<tr> <td align= "center "> ###content### </td> </tr>
</table>
</body>
</html>

再写一个Java页面: buildhtml.java:

import java.util.*;
import java.io.*;
public class HtmlFile{
public static void main(String[] args){
try{
String title= "Make Html ";
String content= "小样,还搞不定你? ";
String editer= "Hulihutu ";
String filePath = " ";
filePath = "template.html ";
System.out.print(filePath);
String templateContent= " ";
FileInputStream fileinputstream = new FileInputStream(filePath);// 读取模板文件
int lenght = fileinputstream.available();
byte bytes[] = new byte[lenght];
fileinputstream.read(bytes);
fileinputstream.close();
templateContent = new String(bytes);
System.out.print(templateContent);
templateContent=templateContent.replaceAll( "###title### ",title);
templateContent=templateContent.replaceAll( "###content### ",content);
templateContent=templateContent.replaceAll( "###author### ",editer);// 替换掉模板中相应的地方
System.out.print(templateContent);

// 根据时间得文件名
Calendar calendar = Calendar.getInstance();
String fileame = String.valueOf(calendar.getTimeInMillis()) + ".html ";
fileame = "/ " + fileame;// 生成的html文件保存路径。
FileOutputStream fileoutputstream = new FileOutputStream(fileame);// 建立文件输出流
System.out.print( "文件输出路径: ");
System.out.print(fileame);
byte tag_bytes[] = templateContent.getBytes();
fileoutputstream.write(tag_bytes);
fileoutputstream.close();
}catch(Exception e){
System.out.print(e.toString());
}
}
}

------解决方案--------------------

supermanyan10 说的不错,细节我稍微补充一下

先建立一个模板页面:template.htm
<html> <head> <title> ###title### </title>
<meta http- equiv= "Content-Type " content= "text/html; charset=gb2312 ">
<LINK href= "../css.css " rel=stylesheet type=text/css> </head>
<body>
<table width= "500 " border= "0 " align= "center " cellpadding= "0 " cellspacing= "2 ">
<tr>
<td align= "center "> ###title### </td>
<td align= "center "> 作者:###author### </td>
<td align= "center "> ###content### </td>
</tr>
<tr> $$ </tr>
</table>
</body>
</html>

ResultSet rs=XXX.getResultSet();//获得ResultSet
StringBuffer stringbuffer=new StringBuffer();
String prefix= " <td align=\ "center\ "> ";
String suffix= " </td> ";
while(rs.next()){
stringbuffer.append( " <tr> ");
  相关解决方案