导出数据库数据生成xml

package com.web.service.news;
import java.io.File;
import java.io.FileWriter;
import java.io.PrintWriter;

import javax.swing.JOptionPane;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;

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

import com.web.db.DButls;
import com.web.form.UserActionForm;

public class Helltest2 {
     private XMLWriter writer = null;
    private Connection conn=null;
    private DButls db=null;
    private PreparedStatement psmt=null;
    private ResultSet rs=null;
     

      private void viewData()

      {

              try

              {

                      Document document = DocumentHelper.createDocument();

                      Element friendsElement = document.addElement("friends");

                      friendsElement.addComment("创建同学地址薄");

                      StringBuilder sql=new StringBuilder()
          .append("select * from manager  ")
          ;
                      Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
                      Connection con=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=dtga","sa","sa");
                      //PreparedStatement stmt =con.prepareStatement("select * from manager  ");
                      Statement stmt =con.createStatement();
                      rs=stmt.executeQuery("select * from manager");

                      List pcs = new ArrayList();
                      while(rs.next()){
                      UserActionForm user=new UserActionForm();
                      user.setId(rs.getString(1));
                      user.setUsers(rs.getString(2));
                      user.setPwd(rs.getString(3));
                      user.setAgencies_id (rs.getString(4));
                      user.setSite(rs.getString(5));
                      user.setPublished(rs.getString(6));
                      user.setSystem(rs.getString(7));
                      user.setAudit(rs.getString(8));
                      user.setPriority(rs.getString(9));
                      user.setState(rs.getString(10));
             pcs.add(user);
             }
                      if(pcs.isEmpty())

                      {

                              System.out.println("此表中无数据");

                              pcs.clear();

                      }

                      else

                      {

                              for(Iterator it=pcs.iterator();it.hasNext();)

                              {

                               UserActionForm user = (UserActionForm)it.next();

                                      System.out.println("编号->"+user.getId());

                                      System.out.println("账号->"+user.getUsers());

                                      System.out.println("密码->"+user.getPwd());

                                      System.out.println("机构ID->"+user.getAgencies_id());

                                      System.out.println("栏目权限->"+user.getSite());

                                      System.out.println("发布管理权限->"+user.getPublished());

                                      System.out.println("系统管理权限->"+user.getSystem());

                                      System.out.println("插件管理->"+user.getAudit());

                                      System.out.println("优先级->"+user.getPriority());

                                      System.out.println("审核->"+user.getState());

                                      System.out.println("----------------------");

                                     

                                      Element friendElement = friendsElement.addElement("user");

                                     

                                      Element idElement = friendElement.addElement("id");

                                      idElement.setText((user.getId()+"").toString().trim());

                                     

                                      Element usersElement = friendElement.addElement("users");

                                      usersElement.setText(user.getUsers());

                                     

                                      Element pwdElement = friendElement.addElement("pwd");

                                      pwdElement.setText((user.getPwd()).toString().trim());

                                     

                                      Element agencies_idElement = friendElement.addElement("agencies_id");

                                      agencies_idElement.setText(user.getAgencies_id());

                                     

                                      Element siteElement = friendElement.addElement("site");

                                      siteElement.setText(user.getSite());

                                     

                                      Element publishedElement = friendElement.addElement("published");

                                      publishedElement.setText(user.getPublished());

                                     

                                      Element systemElement = friendElement.addElement("system");

                                      systemElement.setText(user.getSystem());

                                     

                                      Element auditElement = friendElement.addElement("audit");

                                      auditElement.setText(user.getAudit());

                                     

                                      Element priorityElement = friendElement.addElement("priority");

                                      priorityElement.setText(user.getPriority());

                                     

                                      Element stateElement = friendElement.addElement("state");

                                      stateElement.setText(user.getState());

                              }

                              writer = new XMLWriter(new FileWriter(new File("WebRoot/UserFiles/user.xml")));

                              writer.write(document);

                              System.out.println("创建同学录成功");

                      }

              }

              catch(Exception err)

              {

                      err.printStackTrace();

              }

              finally

              {

                     DButls.close(rs);
                     DButls.close(psmt);
                     DButls.close(conn);

                      }

                      if(writer != null)

                      {

                              try

                              {

                                      writer.close();

                              }

                              catch(Exception err)

                              {

                                      err.printStackTrace();

                              }

                      }

              }

     

      public static void main(String args[])

      {

              new Helltest2().viewData();

      }
}