1.bean
/**
* 二维码
*/
public class EWM {
private String id;
private String name;
private String url;
public String getId() {
return id;
}
public void setId(String id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getUrl() {
return url;
}
public void setUrl(String url) {
this.url = url;
}
}
2.读信息
/**
* 从数据库读取二维码相关信息
*/
public class ReadInfoUtil {
public static List<EWM> getInfo() throws ClassNotFoundException, SQLException{
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/ewm?user=XXX&password=XXX&useUnicode=true&characterEncoding=UTF8";
Connection conn=DriverManager.getConnection(url);
Statement stat=conn.createStatement();
String selectsql="select * from XXX";
ResultSet rs=stat.executeQuery(selectsql);
List<EWM> list=new ArrayList<EWM>();
while(rs.next()){
EWM ewm=new EWM();
ewm.setId(rs.getString(1));
ewm.setName(rs.getString(2));
ewm.setUrl(rs.getString(3));
list.add(ewm);
}
return list;
}
}
3.生成展示页面
public class CreatePageUtil {
public static void createPage(String filename,String title,String imgname) throws IOException{
File file=new File("d:/test/demo/XXX/"+filename+".html");
FileOutputStream out=new FileOutputStream(file);
StringBuffer sb=new StringBuffer();
sb.append("<!DOCTYPE html PUBLIC '-//W3C//DTD XHTML 1.0 Transitional//EN' 'http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd'>");
sb.append("\r\n");
sb.append("<html xmlns='http://www.w3.org/1999/xhtml'>");
sb.append("\r\n");
sb.append("<head>");
sb.append("\r\n");
sb.append("<meta http-equiv='Content-Type' content='text/html; charset=utf-8' />");
sb.append("\r\n");
sb.append("<meta name='viewport' content='width=device-width, initial-scale=1.0'>");
sb.append("\r\n");
sb.append("<link rel='stylesheet' type='text/css' href='../css/bootstrap.min.css' /> ");
sb.append("\r\n");
sb.append("<script type='text/javascript' src='../js/jquery.min.js'></script>");
sb.append("\r\n");
sb.append("<title>").append(title).append("</title>");
sb.append("\r\n");
sb.append("<script>");
sb.append("\r\n");
sb.appe