根据相应的纪录，生成xml文件

import java.io.FileOutputStream;
import java.io.PrintWriter;

import java.io.*;
import org.jdom.Document;
import org.jdom.Element;
import org.jdom.output.XMLOutputter;
import org.jdom.output.Format;
import java.sql.*;
import java.util.*;
/**
 * 
 * Author:lucky
 */
public class createFtixml{

//连接数据库
 String dbDriver="net.sourceforge.jtds.jdbc.Driver";
 String dbUrl="jdbc:jtds:sqlserver://127.0.0.1:1433;DatabaseName=DB";
 String userName="sa";
 String passWord="sa";
 public createFtixml() {
 }
 protected void create()
    {
  String dir_path = "f:/ftixml/";// 用于读取要遍历的FLV目录
   try{
 Class.forName(dbDriver);
 Connection connect=DriverManager.getConnection(dbUrl,userName,passWord);
 Statement stmt=connect.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 ResultSet rs=stmt.executeQuery("SELECT * FROM CORPORATIONwhere ischeckout in('1','2','3')");
   
   while(rs.next()){

//获取数据库中的数据
     int id=rs.getInt("ID");   
  String dwmc=(rs.getString("DWMC")=="null")?null:rs.getString("DWMC");
  String uuid=(rs.getString("UUID")=="null")?null:rs.getString("UUID");
  String dz=(rs.getString("DZ")=="null")?null:rs.getString("DZ");
  String ischeckout=(rs.getString("ischeckout")=="null")?"0":rs.getString("ischeckout");
  String cz=(rs.getString("FAX")=="null")?null:rs.getString("FAX");
  String email=(rs.getString("EMAIL")=="null")?null:rs.getString("EMAIL");
  String lxr=(rs.getString("FZR")=="null")?null:rs.getString("FZR");
  String dh=(rs.getString("TEL")=="null")?null:rs.getString("TEL");
  String www=(rs.getString("WWW")=="null")?null:rs.getString("WWW");
  String hydm=(rs.getString("HYDM")=="null")?null:rs.getString("HYDM");
  String xzqh=(rs.getString("XZQH")=="null")?null:rs.getString("XZQH");
  String qyjj=(rs.getString("QYJJ")=="null")?null:rs.getString("QYJJ");

//进行行政区划，行业代码的代码分离
  String hydm1="",hydm2="";
  String xzqh1="",xzqh2="";
  try{
           System.out.println(dwmc);
           ischeckout=String.valueOf((Integer.parseInt(ischeckout)+5));
              hydm1=hydm.substring(0,1);
              hydm2=hydm;
              xzqh1=xzqh.substring(0,2);
             
              if(xzqh1.equals("11")||xzqh1.equals("12")||xzqh1.equals("31")||xzqh1.equals("50")){
                 xzqh2=xzqh;
              }else{
               if(xzqh.length()>4){
                 xzqh2=xzqh.substring(0,4);
               }else{
                 xzqh2=xzqh;
               }
             
              }
         // Element element0=new Element("root");
          Element elementItem=new Element("root");
          Document document=new Document(elementItem);
//          增加各个节点
          Element elementid=new Element("ID").setText(String.valueOf(id));
          elementItem.addContent(elementid);
          Element elementischeckout=new Element("ISCHECKOUT").setText(ischeckout);
          elementItem.addContent(elementischeckout);
          Element elementuuid=new Element("UUID").setText(uuid);
          elementItem.addContent(elementuuid);   
          Element elementdwmc=new Element("DWMC").setText(dwmc);
          elementItem.addContent(elementdwmc);
          Element elementDZ=new Element("DZ").setText(dz);
          elementItem.addContent(elementDZ);
          Element elementdh=new Element("TEL").setText(dh);
          elementItem.addContent(elementdh);          
          Element elementcz=new Element("FAX").setText(cz);
          elementItem.addContent(elementcz); 
          Element elementWWW=new Element("WWW").setText(www);
          elementItem.addContent(elementWWW);          
          Element elementemail=new Element("EMAIL").setText(email);
          elementItem.addContent(elementemail);          
          Element elementJYFW=new Element("JYFW").setText(qyjj);
          elementItem.addContent(elementJYFW);
          
          Element elementxzqh1=new Element("XZQH1").setText(xzqh1);
          elementItem.addContent(elementxzqh1);
          Element elementxzqh2=new Element("XZQH2").setText(xzqh2);
          elementItem.addContent(elementxzqh2);
             Element elementhydm1=new Element("HYDM1").setText(hydm1);
          elementItem.addContent(elementhydm1);
          Element elementhydm2=new Element("HYDM2").setText(hydm2);
          elementItem.addContent(elementhydm2);
          
         
          try {
                    String filename= dir_path+id+".xml";
                    Format format = Format.getPrettyFormat();
              format.setEncoding("GBK");
           XMLOutputter xmloutputter=new XMLOutputter();
           xmloutputter.setFormat(format);
           FileOutputStream fileOutputStream=new FileOutputStream(filename);
           xmloutputter.output(document,fileOutputStream);
           fileOutputStream.close();
          } catch (Exception e) {
           e.printStackTrace();
          }
            
             }
            catch(Exception ex){
             System.out.println(ex.toString());
            }
   
       System.out.println("=====================================");
   } //WHILE END
 
}
 catch(Exception ex){
    System.out.println(ex.toString());
 }

}

 public static void main(String[] args) {
  // TODO: 在这添加你的代码
  createFtixml test=new createFtixml();
  test.create();
 }
}