package com.cnwu.db.toxml;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Date;
import org.dom4j.Document;
import org.dom4j.DocumentHelper;
import org.dom4j.Element;
import org.dom4j.io.OutputFormat;
public class DBWriteToXML
{
public static void main(String[] args) throws SQLException, IOException
{
// 使用dom4j从数据库中拿出数据,构建一个XML然后将其输出到控制台
Element root = DocumentHelper.createElement("orcl");
Document document = DocumentHelper.createDocument(root);
ResultSet rs = DBWriteToXML.getData();// 从数据库中获得数据,准备存放到xml
while (rs.next())
{
Integer id = rs.getInt(1);
String user = rs.getString(2);
Element element = root.addElement("person");
Element ID = element.addElement("id");
Element name = element.addElement("user");
ID.addText(String.valueOf(id));
name.addText(String.valueOf(user));
}
// ---------------------------------------------------
// 将获得的数据输出到控制台
OutputFormat format = new OutputFormat(" ", true);
format.setEncoding("gb2312"); // 设置输出时的编码,起先老是不能处理中文,就是这个原因
org.dom4j.io.XMLWriter xmlWriter = new org.dom4j.io.XMLWriter(
System.out, format);
xmlWriter.write(document);
xmlWriter.flush();
// -----------------------------------------------------
}
// ---------------------------------------------------
// 从Oracle数据库中获得数据
public static ResultSet getData()
{
try
{
ResultSet result = null;
Class.forName("oracle.jdbc.OracleDriver");
String url = "jdbc:oracle:thin:@localhost:1521:orcl";
String user = "scott";
String passwd = "tiger";
Connection conn = DriverManager.getConnection(url, user, passwd);
java.sql.Statement stm = conn.createStatement();
result = stm.executeQuery("select * from map");
return result;
}
catch (Exception e)
{
e.printStackTrace();
return null;
}
}
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Date;
import org.dom4j.Document;
import org.dom4j.DocumentHelper;
import org.dom4j.Element;
import org.dom4j.io.OutputFormat;
public class DBWriteToXML
{
public static void main(String[] args) throws SQLException, IOException
{
// 使用dom4j从数据库中拿出数据,构建一个XML然后将其输出到控制台
Element root = DocumentHelper.createElement("orcl");
Document document = DocumentHelper.createDocument(root);
ResultSet rs = DBWriteToXML.getData();// 从数据库中获得数据,准备存放到xml
while (rs.next())
{
Integer id = rs.getInt(1);
String user = rs.getString(2);
Element element = root.addElement("person");
Element ID = element.addElement("id");
Element name = element.addElement("user");
ID.addText(String.valueOf(id));
name.addText(String.valueOf(user));
}
// ---------------------------------------------------
// 将获得的数据输出到控制台
OutputFormat format = new OutputFormat(" ", true);
format.setEncoding("gb2312"); // 设置输出时的编码,起先老是不能处理中文,就是这个原因
org.dom4j.io.XMLWriter xmlWriter = new org.dom4j.io.XMLWriter(
System.out, format);
xmlWriter.write(document);
xmlWriter.flush();
// -----------------------------------------------------
}
// ---------------------------------------------------
// 从Oracle数据库中获得数据
public static ResultSet getData()
{
try
{
ResultSet result = null;
Class.forName("oracle.jdbc.OracleDriver");
String url = "jdbc:oracle:thin:@localhost:1521:orcl";
String user = "scott";
String passwd = "tiger";
Connection conn = DriverManager.getConnection(url, user, passwd);
java.sql.Statement stm = conn.createStatement();
result = stm.executeQuery("select * from map");
return result;
}
catch (Exception e)
{
e.printStackTrace();
return null;
}
}
}
//数据库表:MAP
//下面是运行结果
参考连接:http://hi.baidu.com/200770842223/item/21543d57d8b204c49f2667ea?qq-pf-to=pcqq.c2c