<%@page import="java.util.HashSet"%>
<%@page import="java.util.Set"%>
<%@page import="java.util.List"%>
<%@page import="java.net.URLDecoder"%>
<%@page import="org.apache.el.lang.ExpressionBuilder"%>
<%@page import="java.io.File"%>
<%@page import="java.io.FileReader"%>
<%@page import="java.io.BufferedReader"%>
<%@page import="org.apache.jasper.tagplugins.jstl.core.Out"%>
<%@page import="org.apache.tools.ant.filters.TokenFilter.Trim"%>
<%@page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@page import="java.io.FileOutputStream"%>
<%@page import="java.io.OutputStreamWriter"%>
<%@page import="java.io.Writer"%>
<%@page import="java.util.regex.Pattern"%>
<%@page import="java.util.regex.Matcher"%>
<%@page import="java.util.ArrayList"%>
<%@page import="java.util.HashMap"%>
<%@page import="java.text.SimpleDateFormat"%>
<%@page import="java.util.Date"%>
<%@page import="java.util.regex.Pattern"%>
<%@page import="java.util.regex.Matcher"%>
<%@page import="org.apache.commons.lang.StringEscapeUtils"%>
<%@ page import="com.hanweb.jcms.service.info.Jcms_InfoBLF" %>
<%@page import="com.hanweb.common.basedao.Query"%>
<%@page import="com.hanweb.jcms.dao.WebInformationDAO"%>
<%@page import="com.hanweb.common.util.SpringUtil"%>
<%@page import="com.hanweb.common.util.NumberUtil"%>
<%@page import="com.hanweb.jcms.dao.CatalogInfoDAO"%>
<%@page import=" com.hanweb.jcms.entity.Jcms_InfoEntity"%>
<%@page import= "com.hanweb.jcms.sys.service.SysInfo"%>
<%@page import="com.hanweb.jcms.constant.Tables"%>
<%@page import="com.hanweb.common.BaseInfo"%>
<%
out.clear();
try {
writexml();
for(int ii = 0; ii < 20;ii++){
out.println("********开始导出！********
");
out.println("********导出完毕！********
");
}
} catch (Exception e) {
}
%>
<%!
private static String strAppID = "1";
private static String[] colsname = { "信息标题", "创建日期","用户帐号","关键字","作者","来源",
"摘要","录入人","审核人","链接网址","截止日期","评论","信息备注","发布时间","文号","正文","附件","统一编码"};
private static String basicPath = "J:/数据测试/源数据/";
private static int infoCount = 0; //导出信息总数s
private static int cataCount = 0; //有信息的栏目数
private static String cataInfo = ""; //有信息栏目的ID集合
private static String infoEachNum = ""; //有信息栏目的信息数
private static int totalPage = 0; //xml个数
private static int totalNum = 0; //信息总数
private static int eachPage = 1000; //每个xml的信息条数
private static int xmlIndex = 0; //xml计数
private static int beginIndex = 0; //开始写的信息index
private static int endIndex = 0; //结束信息index
private static String path = "";
public static void writexml() {
String infoSql= "select count(1) from jcms_info where i_webid = 2678 and i_cataid = 1345533";
WebInformationDAO webDao = SpringUtil.getBean(WebInformationDAO.class);
Query query = webDao.createQuery(infoSql);
int total = webDao.queryForInteger(query);
int pageno = 0;
if(total/300 == 0){
pageno = total%300;
}else{
pageno = total%300 + 1;
}
for(int p = 0; p < pageno;p++){
/*"信息标题", "创建日期","用户帐号","关键字","作者","来源",
"摘要","录入人","审核人","链接网址","截止日期","评论","信息备注","发布时间","文号","正文","附件","统一编码"*/
infoSql= "select i_id, vc_title,c_createdate,‘‘,vc_keyword,vc_author,vc_source,vc_describe,vc_editor,‘‘,vc_href,‘‘,‘‘,‘‘,"+
"c_complatedate,vc_filenumber,vc_content,vc_attach,vc_sectitle "+
"from jcms_info where i_webid = 2678 and i_cataid = 1345533 LIMIT "+p*1000+","+1000;
CatalogInfoDAO cataDao = SpringUtil.getBean(CatalogInfoDAO.class);
query = cataDao.createQuery(infoSql);
System.out.println( "**************infoSql**********" + infoSql);
String[][] strDatas = cataDao.queryForArrays(query);
System.out.println("开始导出，一共有" + strDatas.length + "条信息！");
infoCount += strDatas.length;
cataCount++;
totalNum = strDatas.length;
/* if (totalNum % eachPage == 0) {
totalPage = totalNum / eachPage;
} else {
totalPage = totalNum / eachPage + 1;
} */
SysInfo sys = new SysInfo();
Jcms_InfoBLF infoBLF = Jcms_InfoBLF.getInstance().init(sys);
Jcms_InfoEntity entity;
try {
/* for (xmlIndex = 0; xmlIndex < totalPage; xmlIndex++) { */
/* beginIndex = xmlIndex * eachPage;
endIndex = (xmlIndex + 1) * eachPage > strDatas.length ? strDatas.length
: (xmlIndex + 1) * eachPage; */
StringBuffer sb = new StringBuffer();
sb.append(""
+ "\r\n");
sb.append("");
//写文件
path =BaseInfo.getRealPath() + "/info/";
//path ="f:/数据测试/目标数据";
String filePath = path + p+"info.xml";
FileOutputStream fos = new FileOutputStream(filePath,false);
Writer writer = new OutputStreamWriter(fos, "UTF-8");
writer.write(sb.toString());
sb.delete(0, sb.length());
writer.flush();
writer.close();
/* } */
} catch (Exception e) {
e.printStackTrace();
}
System.out.println("==============一共导出" + cataCount+ "个栏目==================");
System.out.println("==============一共" + infoCount+ "条信息==================");
}
}
%>
从数据库查询数据然后拼接成xml文件
标签：cat java out real 审核 正文 false 个数 read
