writesysusertoxmlfilemanager.java

java oracle 示例 prefirst.rar

package cn.com.freeborders.sys;

import java.io.FileWriter;
import java.io.IOException;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;

import org.jdom.Document;
import org.jdom.Element;
import org.jdom.output.XMLOutputter;

import cn.com.freeborders.dataconn.DataProcess;

public class WriteSysuserToXmlFileManager {
	public static boolean write(){
		String sql = "select * from sysuser";
		Element sysuserElement = new Element("sysuser");
		Document myDocument = new Document(sysuserElement);
		Connection conn = DataProcess.getConnection();
		ResultSet rs = DataProcess.getResult(sql,conn);
		
		try {
			int i = 1;
			while (rs.next()) {
				Element sysuserOneElement = new Element("sysuser"+i);
				Element temp1 = new Element("id");
				temp1.addContent(rs.getString("id"));
				Element temp2 = new Element("username");
				temp2.addContent(rs.getString("username"));
				Element temp3 = new Element("password");
				temp3.addContent(rs.getString("password"));
				Element temp4 = new Element("levels");
				temp4.addContent(rs.getString("levels"));
				sysuserOneElement.addContent(temp1);
				sysuserOneElement.addContent(temp2);
				sysuserOneElement.addContent(temp3);
				sysuserOneElement.addContent(temp4);
				sysuserElement.addContent(sysuserOneElement);
				i++;
			}
			XMLOutputter outputter = new XMLOutputter();
			FileWriter writer = new FileWriter("D:\\workspace\\prefirst\\WebContent\\sysuser.xml");
			outputter.output(myDocument, writer);
			DataProcess.closeResult(rs);
			DataProcess.closeConnection(conn);
		} catch (SQLException e) {
			e.printStackTrace();
		} catch (IOException e) {
			e.printStackTrace();
		}
		return true;
	}
}