dom4j写出xml文件简单实例:
import java.sql.*; //Connection DriverManager Statement
import java.io.*; //File FileInputStream
import org.dom4j.*;//Document Element Attribute
import org.dom4j.io.*;//SAXReader
//将Emp表导出
/*
<emps>
<emp>
<empno></empno>
<ename></ename>
</emp>
</emps>
//DOM4J创建文件
1.内存中创建一个Document对象 空的
2.添加各种内容
3.写出到文件
*/
public class Exec{
public static void main(String args[])throws Exception{
export();
}
public static void export()throws Exception{
Document doc = DocumentHelper.createDocument();
//root Element
Element root = doc.addElement("emps");
Connection con = getConnection();
Statement sta = con.createStatement();
String sql="select * from emp";
ResultSet rs = sta.executeQuery(sql);
while(rs.next()){
Element first = root.addElement("emp");
Element empno = first.addElement("empno");
empno.setText(rs.getInt("empno")+"");
Element ename = first.addElement("ename");
ename.setText(rs.getString("ename"));
}
//关闭资源
rs.close();sta.close();con.close();
//写出
XMLWriter writer = new XMLWriter(
new FileOutputStream("emp.xml"),
OutputFormat.createPrettyPrint());
writer.write(doc);
writer.close();
}
//获得连接的方法
private static Connection getConnection()throws Exception{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con = DriverManager.getConnection(
"jdbc:oracle:thin:@localhost:1521:orcl","scott","tiger");
return con;
}
}