java 读取 xmltype_java中xml文件的处理及oracle中xmltype的插入和读取.docx

java中xml文件的处理及oracle中xmltype的插入和读取

java中xml文件的处理及oracle中xmltype的插入和读取：总体结构：?1.ORACLE中创建表：// 创建的表CREATE TABLE resumes2 (employee_id NUMBER(6) PRIMARY KEY,resume XMLType)XMLType COLUMN resumeSTORE AS CLOB;CREATE DIRECTORY XMLDIR AS 'C:\';????? //设置xml目录?2.创建xml文件类WriteXML.java：package jdom;import java.io.*;import java.util.List;import org.jdom.*;import org.jdom.input.*;import org.jdom.output.*;import org.jdom.xpath.*;public class WriteXML {?public void BuildXML() throws Exception {?Element root, student, number, name, age;?root = new Element("student-info"); //生成根元素：student-info?//?生成元素：student(number,name,age)?student = new Element("student");?number = new Element("number");?name = new Element("name");?age = new Element("age");?Document doc = new Document(root); //将根元素植入文档doc中??//?给元素赋值?number.setText("001");?name.setText("lnman");?age.setText("24");??//?形成树?student.addContent(number);?student.addContent(name);?student.addContent(age);?root.addContent(student);??//?设置格式并生成xml文件?Format format = Format.getCompactFormat();?format.setEncoding("gb2312"); //设置xml文件的字符为gb2312?format.setIndent("??? "); //设置xml文件的缩进为4个空格?XMLOutputter XMLOut = new XMLOutputter(format);//元素后换行一层元素缩四格?XMLOut.output(doc, new FileOutputStream("studentinfo.xml"));?}?public static void main(String[] args) throws Exception {?//?测试main函数?WriteXML w = new WriteXML();?System.out.println("Now we build an XML document .....");?w.BuildXML();?System.out.println("finished!");?}}??3.读取xml中节点数据类ReadXML.java：package jdom;import org.jdom.output.*;import org.jdom.input.*;import org.jdom.*;import java.io.*;import java.util.*;public class ReadXML {?public static void main(String[] args) throws Exception {?// 实例化SAXBuilder对象，利用该对象可直接对XML文档进行解析?SAXBuilder builder = new SAXBuilder();?// 利用SAXBuilder对象对XML文档进行解析，并取出解析以后的document文档对象?Document read_doc = builder.build("studentinfo.xml");?Element stu = read_doc.getRootElement(); //取出文档的根元素?//?以下为对文档的各个节点循环进行操作并显示?List list = stu.getChildren("student");?for (int i = 0; i < list.size(); i++) {?Element e = (E