jdom创建xml文件

2019独角兽企业重金招聘Python工程师标准>>>

package com.cjq.xml;

import java.io.FileOutputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.Statement;

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


public class DBtoXml {

	public static void main(String[] args) throws Exception{
		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		Connection conn = DriverManager.getConnection("jdbc:odbc:book");
		Statement stmt = conn.createStatement();
		ResultSet rs = stmt.executeQuery("select * from customer");
		ResultSetMetaData rsmd = rs.getMetaData();
		int numcols = rsmd.getColumnCount();
		
		org.jdom2.Element root,ele,name;
		root = new Element("customer");
		while(rs.next()){
			ele = new Element("第"+rs.getRow()+"条纪录");
			for(int i=1;i<numcols;i++){
				name = new Element("a"+rsmd.getColumnLabel(i));
				name.setContent(new Element("a"+rs.getString(i)));
				ele.addContent(name);
			}
			root.addContent(ele);
		}
		Document doc = new Document(root);
		FileOutputStream f = new FileOutputStream("db.xml");
		XMLOutputter out = new XMLOutputter();
		out.output(root, f);
		rs.close();
		conn.close();
	}

}

转载于:https://my.oschina.net/u/2552902/blog/543946