程序博客网 > vsftpd 指定端口

cymlancy

来源：互联网 发布：vsftpd 指定端口 编辑：程序博客网 时间：2024/06/06 02:53

DB文件：

package org.travel.www73hi.feed;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class DB {
 public Connection getConnection() throws SQLException{
 
  Connection conn=null;     
  try {
   Class.forName("oracle.jdbc.driver.OracleDriver");
   
   conn=DriverManager.getConnection("jdbc:oracle:thin:@192.168.0.0.0:orcl","用户名","密码");
  } catch (ClassNotFoundException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }
  return conn; 
 }
}

//全量文件

package org.travel.www73hi.feed2;


import java.io.File;
import java.io.FileOutputStream;
import java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.text.SimpleDateFormat;
import java.util.Calendar;

import org.dom4j.Document;
import org.dom4j.DocumentHelper;
import org.dom4j.Element;
import org.dom4j.io.OutputFormat;
import org.dom4j.io.XMLWriter;
import org.quartz.JobExecutionContext;
import org.quartz.JobExecutionException;
import org.springframework.scheduling.quartz.QuartzJobBean;
  
  
public class FullIndex {
  //服务器
 protected void run() {
  String sql = "select id  from t_circuitry  where name like '品质游%【旅游担保】'"; 
   String path = File.separator+"travel_platform"+File.separator;
  //取得数据库连接
  DB db = new DB();
  Connection conn = null;
  try {
   conn = db.getConnection();
  } catch (SQLException e1) {
   // TODO Auto-generated catch block
   e1.printStackTrace();
  }
  ResultSet rs = null;
  PreparedStatement ps = null;
  try {
   //获取数据
   ps = conn.prepareStatement(sql);
   rs = ps.executeQuery();
   OutputFormat format = OutputFormat.createPrettyPrint();
   format.setEncoding("UTF-8");
   Document document = DocumentHelper.createDocument();
   document.setXMLEncoding("UTF-8");
      Element rootElement = document.addElement("root");
      Element versionElement = rootElement.addElement("version");
      versionElement.setText("1.0");
      Element modifiedElement = rootElement.addElement("modified");
      SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
      Calendar cal = Calendar.getInstance();
     // cal.add(Calendar.MINUTE, 30);
      modifiedElement.setText(df.format(cal.getTime()));
      
      Element seller_idElement = rootElement.addElement("seller_id");
      seller_idElement.setText("公司名称");
      Element cat_url_idElement = rootElement.addElement("cat_url");
      //cat_url_idElement.setText(path+"xml/SellerCats.xml");//linux系统
      cat_url_idElement.setText("http://域名/xml/SellerCats.xml");
      Element dirElement = rootElement.addElement("dir");
      //dirElement.setText(path+"xml/item/");//linux系统
      dirElement.setText("http://域名/xml/item/");
      Element item_idsElement = rootElement.addElement("item_ids");
      while(null!=rs&&rs.next()){
    Element outer_idElement = item_idsElement.addElement("outer_id");
    outer_idElement.addAttribute("action", "upload");
    outer_idElement.setText(rs.getString(1));
   }
   try {
    //生成文件
    //XMLWriter output = new XMLWriter(new FileOutputStream(new File(path+"xml/FullIndex.xml")),format);
    XMLWriter output = new XMLWriter(new FileOutputStream(new File("C:/Program Files/apache-tomcat-6.0.32/webapps/travel_platform/xml/FullIndex.xml")),format);
    output.write(document);
    output.close();
   } catch (IOException e) {
    System.out.println(e.getMessage());
   }
  } catch (Exception e) {
   e.printStackTrace();
  } finally {
   try {
    if (rs != null) {
     rs.close();
     rs = null;
    }
    if (ps != null) {
     ps.close();
     ps = null;
    }
    if (conn != null) {
     conn.close();
     conn = null;
    }
   } catch (Exception e) {
    e.printStackTrace();
   }
  }
 }

public static void main(String[] argv) throws SQLException{
  FullIndex dom4j=new FullIndex();
  dom4j.run();
  System.out.println("************finish*************");
 }

 
 
}

//增量文件

package org.travel.www73hi.feed2;


import java.io.File;
import java.io.FileOutputStream;
import java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.text.SimpleDateFormat;
import java.util.Calendar;
import java.util.TimerTask;

import org.dom4j.Document;
import org.dom4j.DocumentHelper;
import org.dom4j.Element;
import org.dom4j.io.OutputFormat;
import org.dom4j.io.XMLWriter;


public class Increate  {
 public void run() {
  String sql = " select id ,status from t_circuitry  where name like '品质游%【旅游担保】'";
   String path = File.separator+"travel_platform"+File.separator;
  //取得数据库连接
  DB db = new DB();
  Connection conn = null;
  try {
   conn = db.getConnection();
  } catch (SQLException e1) {
   // TODO Auto-generated catch block
   e1.printStackTrace();
  }
  ResultSet rs = null;
  PreparedStatement ps = null;
  try {
   //获取数据
   ps = conn.prepareStatement(sql);
   rs = ps.executeQuery();
   OutputFormat format = OutputFormat.createPrettyPrint();
   format.setEncoding("UTF-8");
   Document document = DocumentHelper.createDocument();
   document.setXMLEncoding("UTF-8");
      Element rootElement = document.addElement("root");
      Element versionElement = rootElement.addElement("version");
      versionElement.setText("1.0");
      Element modifiedElement = rootElement.addElement("modified");
      SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
      Calendar cal = Calendar.getInstance();
      cal.add(Calendar.MINUTE, 30);
      modifiedElement.setText(df.format(cal.getTime()));
      
      Element seller_idElement = rootElement.addElement("seller_id");
      seller_idElement.setText("公司名称");
      Element cat_url_idElement = rootElement.addElement("cat_url");
      //cat_url_idElement.setText(path+"xml/SellerCats.xml");//linux系统
      cat_url_idElement.setText("http://域名/xml/SellerCats.xml");
      Element dirElement = rootElement.addElement("dir");
      //dirElement.setText(path+"xml/item/");//linux系统
      dirElement.setText("http://域名/xml/item/");
      Element item_idsElement = rootElement.addElement("item_ids");
   while(null!=rs&&rs.next()){
       Element outer_idElement =item_idsElement.addElement("outer_id");
    String status = rs.getString(2);
    System.out.println(status);
    String poid = rs.getString(1);
    if(null!=status&&!("NORMAL".equals(status))){
     outer_idElement.addAttribute("action", "delete");
     outer_idElement.setText(poid);
    }
    if(null!=status&&"NORMAL".equals(status)){
     outer_idElement.addAttribute("action", "upload");
     outer_idElement.setText(poid);
    }
      }
   try {
    //生成文件
    //XMLWriter output = new XMLWriter(new FileOutputStream(new File(path+"xml/IncrementIndex.xml")),format);
    XMLWriter output = new XMLWriter(new FileOutputStream(new File("C:/Program Files/apache-tomcat-6.0.32/webapps/travel_platform/xml/IncrementIndex.xml")),format);
    output.write(document);
    output.close();
   } catch (IOException e) {
    System.out.println(e.getMessage());
   }
  } catch (Exception e) {
   e.printStackTrace();
  } finally {
   try {
    if (rs != null) {
     rs.close();
     rs = null;
    }
    if (ps != null) {
     ps.close();
     ps = null;
    }
    if (conn != null) {
     conn.close();
     conn = null;
    }
   } catch (Exception e) {
    e.printStackTrace();
   }
  }
 }

 public static void main(String[] argv) throws SQLException{
  Increate dom4j=new Increate();
  dom4j.run();
  System.out.println("************finish*************");
}

 

}

//item文件

package org.travel.www73hi.feed2;

import java.io.File;
import java.io.FileOutputStream;
import java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import org.dom4j.Document;
import org.dom4j.DocumentHelper;
import org.dom4j.Element;
import org.dom4j.io.OutputFormat;
import org.dom4j.io.XMLWriter;

public class Items {
 public void generateDocument() throws SQLException {
  String sql = "select * from t_circuitry where name like '品质游%【旅游担保】'";
  String path = File.separator + "travel_platform" + File.separator;
  // 获取数据库连接
  DB db = new DB();
  Connection conn = db.getConnection();
  ResultSet rs = null;
  ResultSet rs1 = null;
  ResultSet rs2 = null;
  PreparedStatement ps = null;
  try {
   // DirectoryOpr.delFolder("C:/Program Files/Tomcat5.5/webapps/web/xml/item");
   ps = conn.prepareStatement(sql);
   rs = ps.executeQuery();
   int i = 1;
   while (rs.next()) {
    OutputFormat format = OutputFormat.createPrettyPrint();
    format.setEncoding("UTF-8");
    Document document = DocumentHelper.createDocument();
    document.setXMLEncoding("UTF-8");
    Element itemElement = document.addElement("item");
    Element seller_idElement = itemElement.addElement("seller_id");
    seller_idElement.setText("公司名称");
    Element outer_idElement = itemElement.addElement("outer_id");
    outer_idElement.setText(rs.getString("id") == null ? "" : rs
      .getString("id"));

    Element titleElement = itemElement.addElement("title");
    titleElement.setText(rs.getString("name") == null ? "" : rs
      .getString("name"));

    Element typeElement = itemElement.addElement("available");
    typeElement.setText("10");
    Element priceElement = itemElement.addElement("price");
    String hq = "select a.outprice,b.gooutteamdate, b.circuitryid from t_quoteprice a,t_plan b,t_circuitry c where a.planid=b.id and a.seq=1 and b.circuitryid='"+rs.getString("id")+"' and  to_char(b.gooutteamdate,'yyyy-mm-dd') > =to_char(sysdate,'yyyy-mm-dd') and rownum =1";
    ps = conn.prepareStatement(hq);
    rs2 = ps.executeQuery();
    while (rs2.next()) {
     String priceParam = String.valueOf(rs2
       .getString("outprice"));
     System.out.println(priceParam);
     System.out.println(rs.getString("id"));
      if(priceParam.indexOf(".")<0){
       priceParam = priceParam +".00"; }
     
     priceElement.setText(priceParam);
    }
    // System.out.println("=================>"+priceParam);

    sql = " select * from t_attachment where relationid='"
      + rs.getString("id") + "' and type='LITTLEPIC'";
    i++;

    // 取得数据
    ps = conn.prepareStatement(sql);
    rs1 = ps.executeQuery();
    Element imageElement = itemElement.addElement("image");
    imageElement
      .setText("http://域名/picture/circuitryPictrue/JSZX1003112001042/1.jpg");
    while (rs1.next()) {
     imageElement.setText("http://www.axtrip.com"
       + rs1.getString("filepath"));
    }

    // http://域名/picture/circuitryPictrue/JSZX1003112001042/1.jpg
    Element scidsElement = itemElement.addElement("scids");
    scidsElement.setText(i + "");
    Element post_feeElement = itemElement.addElement("post_fee");
    post_feeElement.setText("1.00");
    Element hrefElement = itemElement.addElement("href");
    hrefElement
      .setText("http://域名/www73hiWeb.go?method=viewCircuitry&circuitryId="
        + rs.getString("id"));

    try {
     // 循环生成文件
     XMLWriter output = new XMLWriter(new FileOutputStream(
       new File(
         "C:/Program Files/apache-tomcat-6.0.32/webapps/travel_platform/xml/item/"
           + rs.getString("id") + ".xml")),
       format);
     
     /* XMLWriter output = new XMLWriter(new FileOutputStream(
      new File(path+"xml/item/" + rs.getString("id")+ ".xml")),
       format);*/
     
     output.write(document);
     output.close();
    } catch (IOException e) {
     System.out.println(e.getMessage());
    }
   }
  } catch (Exception e) {
   e.printStackTrace();
  } finally {
   System.out.println("一淘Items的任务调度！！！");
   try {
    if (rs2 != null) {
     rs2.close();
     rs2 = null;
    }
    if (rs1 != null) {
     rs1.close();
     rs1 = null;
    }
    if (rs != null) {
     rs.close();
     rs = null;
    }
    if (ps != null) {
     ps.close();
     ps = null;
    }
    if (conn != null) {
     conn.close();
     conn = null;
    }
   } catch (Exception e) {
    e.printStackTrace();
   }
  }
 }

 public static void main(String[] argv) throws SQLException {
  Items dom4j = new Items();
  dom4j.generateDocument();
  System.out.println("************finish*************");
 }
}

 

//sellerCate文件

package org.travel.www73hi.feed2;


import java.io.File;
import java.io.FileOutputStream;
import java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import org.dom4j.Document;
import org.dom4j.DocumentHelper;
import org.dom4j.Element;
import org.dom4j.io.OutputFormat;
import org.dom4j.io.XMLWriter;
import org.quartz.JobExecutionContext;
import org.quartz.JobExecutionException;
import org.springframework.scheduling.quartz.QuartzJobBean;


public class XmlSellerCats  {
 protected void executeInternal()  {
  String sql = " select * from t_circuitry where name like '品质游%【旅游担保】'";
   String path = File.separator+"travel_platform"+File.separator;
  //取得数据库连接
  DB db = new DB();
  Connection conn = null;
  try {
   conn = db.getConnection();
  } catch (SQLException e1) {
   // TODO Auto-generated catch block
   e1.printStackTrace();
  }
  ResultSet rs = null;
  PreparedStatement ps = null;
  try {
   //获取数据
   ps = conn.prepareStatement(sql);
   rs = ps.executeQuery();
   OutputFormat format = OutputFormat.createPrettyPrint();
   format.setEncoding("UTF-8");
   Document document = DocumentHelper.createDocument();
   Element rootElement = document.addElement("root");
   Element versionElement = rootElement.addElement("version");
   versionElement.setText("1.0");
   Element modifiedElement = rootElement.addElement("modified");
   modifiedElement.setText("2011-11-16 11:00:00");
   Element seller_idElement = rootElement.addElement("seller_id");
   seller_idElement.setText("公司名称");
   Element seller_catsElement = rootElement.addElement("seller_cats");
   Element catElement = null;
   Element scid1Element = null;
   Element name1Element = null;
   int i=1;
   while (rs.next()) {
    i++;
    catElement = seller_catsElement.addElement("cat");
    scid1Element = catElement.addElement("scid");
    scid1Element.setText(i+"");
    name1Element = catElement.addElement("name");
    name1Element.setText(rs.getString("name"));
   
   }
   try {
    //生成文件
    //XMLWriter output = new XMLWriter(new FileOutputStream(new File(path+"xml/SellerCats.xml")),format);
    XMLWriter output = new XMLWriter(new FileOutputStream(new File("C:/Program Files/apache-tomcat-6.0.32/webapps/travel_platform/xml/SellerCats.xml")),format);
    output.write(document);
    output.close();
   } catch (IOException e) {
    System.out.println(e.getMessage());
   }
  } catch (Exception e) {
   e.printStackTrace();
  } finally {
   try {
    if (rs != null) {
     rs.close();
     rs = null;
    }
    if (ps != null) {
     ps.close();
     ps = null;
    }
    if (conn != null) {
     conn.close();
     conn = null;
    }
   } catch (Exception e) {
    e.printStackTrace();
   }
  }
 }

 public static void main(String[] argv) throws SQLException {
  XmlSellerCats dom4j = new XmlSellerCats();
  dom4j.executeInternal();
 }
}

 

vsftpd 指定端口 vsftpd 指定端口
原创粉丝点击
热门IT博客
vb api程序设计vb api程序设计
天涯和知乎哪个实用天涯和知乎哪个实用
下载站的网站源码
做淘宝美工要学什么
玉城tina 知乎
淘宝话费充值一元
梅西最新数据
范特昔淘宝店铺号
php语言能做大型项目吗
java中多线程编程案例
seo云优化是什么意思
解压软件for mac版
mysql dmp导入数据库
java分割字符串函数
单例设计模式 java
java脚本语言
淘宝回收手机我怎么寄
淘宝开放平台 如何赚钱
买卖时机软件下载
松下电视怎么样知乎
热门问题 老师的惩罚 人脸识别 我在镇武司摸鱼那些年 重生之率土为王 我在大康的咸鱼生活 盘龙之生命进化 天生仙种 凡人之先天五行 春回大明朝 姑娘不必设防，我是瞎子 固伦公主 尤四姐 固体胶 固体饮料 固体酒精 固体 固体废物 固体水彩 精液固体 易燃固体 固体芳香剂 固体物理 固体培养基 暗紫色固体 黑色固体 固体香水 固体英文 固体胶图片 固体废弃物 乳固体 固体的英文 益生菌固体饮料 益生元固体饮料骗死人 汽车蜡固体好还是液体好 液体钙和固体钙哪个好 固体水彩怎么用 固体物理黄昆课后答案 车蜡固体好还是液体好 固体酒精制作方法 阴道白色固体 阴道有白色固体 固体线膨胀系数测定实验报告 固体清香剂对人体有害吗 逃避海关监管将境外固体废物 怀孕奶眼里头有白色固体分泌 固力 固力智能锁 螺栓紧固力矩表对照表 标准螺丝紧固力矩表 固力锁具 固力门锁 固力康

程序博客网，程序员的互联网技术博客家园。csdn论坛精品 msdn技术资料都在这里