数据源+freemarker+servlet生成xml文件

来源：互联网发布：python 列表推导式循环编辑：程序博客网时间：2024/06/05 02:20

1.在server.xml文件中建立数据源.

<Connector acceptCount="100" connectionTimeout="20000" debug="0" disableUploadTimeout="true"

enableLookups="false" maxSpareThreads="75" maxThreads="150" minSpareThreads="25" port="8081" redirectPort="8443"/>

<name>factory</name>

<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>

</parameter>

<name>maxActive</name>

</parameter>

<name>validationQuery</name>

<value>select 1+1</value>

</parameter>

<name>maxIdle</name>

</parameter>

<name>maxWait</name>

</parameter>

<name>removeAbandoned</name>

</parameter>

<name>removeAbandonedTimeout</name>

</parameter>

<name>logAbandoned</name>

<value>false</value>

</parameter>

<name>username</name>

</parameter>

<name>password</name>

<value>bbbbbb</value>

</parameter>

<name>driverClassName</name>

<value>net.sourceforge.jtds.jdbc.Driver</value>

</parameter>

<value>jdbc:jtds:sqlserver://111.111.111.111:1433/cms</value>

</parameter>

</ResourceParams>

</Context>

</Host>

</Engine>

</Service>

2.在web.xml文件中配置servlet

<description>generate xml file</description>

<servlet-name>NewsXmlServlet</servlet-name>

<servlet-class>xml.NewsXmlServlet</servlet-class>

</servlet>

<servlet-mapping>

<servlet-name>NewsXmlServlet</servlet-name>

<url-pattern>/xmlServlet</url-pattern>

</servlet-mapping>

3.newsXmlServlet.java

package xml;

import java.io.*;

import java.nio.charset.Charset;

import java.sql.Connection;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import java.util.ArrayList;

import java.util.HashMap;

import java.util.List;

import java.util.Map;

import javax.naming.Context;

import javax.naming.InitialContext;

import javax.naming.NamingException;

import javax.servlet.ServletException;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import javax.sql.DataSource;

import freemarker.template.Configuration;

import freemarker.template.Template;

import freemarker.template.TemplateException;

import java.util.Locale;

public class NewsXmlServlet extends HttpServlet{

protected void doGet(HttpServletRequest req, HttpServletResponse resp)

throws ServletException, IOException {

// TODO Auto-generated method stub

try {

Connection conn=null;

Context ctx = new InitialContext();

DataSource ds=(DataSource)ctx.lookup("java:comp/env/jdbc/news_DB");

conn=ds.getConnection();

Statement stmt=conn.createStatement();

ResultSet rs=stmt.executeQuery("select url,updatetime,tpf_edu_contentTitle,tpf_edu_contentneirong,tpf_edu_contentlaiyuan,tpf_edu_contentkeyword from tp5__edu_content where url<>'' and url is not null and dateDiff(d,updatetime,getDate())=1 order by updatetime desc");

Configuration cfg=new Configuration();

cfg.setDirectoryForTemplateLoading(new File("E:/wwwroot/CMS/web/WEB-INF/classes/xml"));

Template tem=cfg.getTemplate("news.ftl");

List list=new ArrayList();

OutputStreamWriter out=new OutputStreamWriter(System.out);

while(rs.next()){

Map item=new HashMap();

item.put("title",rs.getString(3));

item.put("link","http://test.com.cn"+rs.getString(1));

item.put("pubdate",rs.getTimestamp(2));

item.put("content",DelHtml(rs.getString(4)));

item.put("source",rs.getString(5));

item.put("keywords",DelHtml(rs.getString(6)));

list.add(item);

}

Map data=new HashMap();

data.put("items",list);

StringWriter writer=new StringWriter();

tem.process(data,writer);

String content=writer.toString();

writer.close();

createXml(content);

out.close();

//resp.setContentType("text/xml; charset=utf-8");

//resp.getWriter().write(content);

} catch (NamingException e) {

// TODO Auto-generated catch block

e.printStackTrace();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

} catch (TemplateException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

public String DelHtml(String content){

String contents=content.replaceAll("<//?/s*(/S+)(/s*[^>]*)?/s*//?>","");

contents=contents.replaceAll("“", "”");

contents=contents.replaceAll("”","”");

contents=contents.replaceAll("“", "‘");

contents=contents.replaceAll("”","’");

contents=contents.replaceAll("·","·");

contents=contents.replaceAll("—","—");

contents=contents.replaceAll("…","…");

contents=contents.replaceAll(" ","");

contents=contents.replaceAll(","," ");

return contents;

}

public void createXml(String fileContent){

try {

String filePath="E:/wwwroot/cmsHtml/education/news.xml";

File fileXml=new File(filePath);

if(!fileXml.exists()){

fileXml.createNewFile();

}

/*FileWriter fileWriter=new FileWriter(fileXml);

fileWriter.

fileWriter.write(fileContent);

fileWriter.close();*/

OutputStreamWriter writer=new OutputStreamWriter(new FileOutputStream(fileXml), Charset.forName("utf-8"));

writer.write(fileContent);

writer.close();

} catch (IOException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

public void destroy() {

// TODO Auto-generated method stub

super.destroy();

}

public void init() throws ServletException {

// TODO Auto-generated method stub

super.init();

}

4.news.ftl

<?xml version="1.0" encoding="utf-8" ?>

<webMaster>webmaster@aweb.com.cn</webMaster>

<#list items as it>

<item>

<pubDate>${it.pubdate}</pubDate>

<source>${it.source}</source>

</item>

</#list>

</document>