Question

大家谁会用JAVA写，功能是：能够往Oracle中读写数据，并且能够转换成XML格式的，最好有完整的程序哈

Answer 1

public class TestDom4j {
public static void main(String[] args) throws Exception {
input();
}
public static void input() throws Exception {
SAXReader reader = new SAXReader();
Document doc = reader.read(new InputStreamReader(new FileInputStream(
"d:/students.xml")));
Element root = doc.getRootElement();
System.out.println(root.getName());
List<Element> list = root.elements();
for (int i = 0; i < list.size(); i++) {
Element e = list.get(i);
Element nameElement = (Element) e.elements("name").get(0);
Element ageElement = (Element) e.elements("age").get(0);
System.out.println(nameElement.getText() + "," + ageElement.getText());
}
// root.elements("student");
}
public static void output() throws Exception {
Document doc = DocumentHelper.createDocument();
Element root = doc.addElement("students");
for (int i = 0; i < 100; i++) {
Element s1 = root.addElement("student");
s1.addAttribute("id", "" + i);
Element name1 = s1.addElement("name");
Element age1 = s1.addElement("age");
name1.setText("name" + i);
age1.setText("25");
}
OutputFormat opf = OutputFormat.createPrettyPrint();
XMLWriter xmlWriter = new XMLWriter(new OutputStreamWriter(
new FileOutputStream("d:/students.xml")), opf);
xmlWriter.write(doc);
xmlWriter.close();
}
}

Answer 2

简单的实现：用JDBC连接数据库，然后将数据库的数据读出，用dom4j或JDOM(学习比较简单，一般没有太大性能上的需求推荐用JDOM)将数据写到目标XML

Answer 3

public class TestDom4j {
public static void main(String[] args) throws Exception {
input();
}
public static void input() throws Exception {
SAXReader reader = new SAXReader();
Document doc = reader.read(new InputStreamReader(new FileInputStream(
"d:/students.xml")));
Element root = doc.getRootElement();
System.out.println(root.getName());
List<Element> list = root.elements();
for (int i = 0; i < list.size(); i++) {
Element e = list.get(i);
Element nameElement = (Element) e.elements("name").get(0);
Element ageElement = (Element) e.elements("age").get(0);
System.out.println(nameElement.getText() + "," + ageElement.getText());
}
// root.elements("student");
}
public static void output() throws Exception {
Document doc = DocumentHelper.createDocument();
Element root = doc.addElement("students");
for (int i = 0; i < 100; i++) {
Element s1 = root.addElement("student");
s1.addAttribute("id", "" + i);
Element name1 = s1.addElement("name");
Element age1 = s1.addElement("age");
name1.setText("name" + i);
age1.setText("25");
}
OutputFormat opf = OutputFormat.createPrettyPrint();
XMLWriter xmlWriter = new XMLWriter(new OutputStreamWriter(
new FileOutputStream("d:/students.xml")), opf);
xmlWriter.write(doc);
xmlWriter.close();
}
}