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

如题所述

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();
}
}
温馨提示:内容为网友见解,仅供参考
第1个回答  2012-07-11
简单的实现:用JDBC连接数据库,然后将数据库的数据读出,用dom4j或JDOM(学习比较简单,一般没有太大性能上的需求推荐用JDOM)将数据写到目标XML
第2个回答  2012-07-25
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();
}
}
相似回答