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

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文件的字符为gb2312format.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 = (Element) list.get(i);String str_number = e.getChildText(number);String str_name = e.getChildText(name);String str_age = e.getChildText(age);/输出xml文件中的信息System.out.println(NUMBER: + str_number);System.out.println(NAME: + str_name);System.out.println(AGE: + str_age);4.读取和修改xml中节点数据类TestJDOM.java；package text.jdom;import org.jdom.*;import org.jdom.output.*;import org.jdom.input.*;import java.io.*;public class TestJDOM public static void main(String args) throws Exception SAXBuilder sb = new SAXBuilder();/从文件构造一个Document，因为XML文件中已经指定了编码，所以这里不必了Document doc = sb.build(new FileInputStream(exampleA.xml);/加入一条处理指令ProcessingInstruction pi = new ProcessingInstruction(xml-stylesheet, href=bookList.html.xsl type=text/xsl);doc.addContent(pi);Element root = doc.getRootElement(); /得到根元素java.util.List books = root.getChildren(); /得到根元素所有子元素的集合Element book = (Element) books.get(0); /得到第一个book元素/为第一本书添加一条属性Attribute a = new Attribute(hot, true);book.setAttribute(a);Element author = book.getChild(author); /得到指定的字元素author.setText(王五); /将作者改为王五/或 Text t = new Text(王五);book.addContent(t);Element price = book.getChild(price); /得到指定的字元素/修改价格，比较郁闷的是我们必须自己转换数据类型，而这正是JAXB的优势price.setText(Float.toString(50.0f);String indent = ;boolean newLines = true;XMLOutputter outp = new XMLOutputter();outp.output(doc, new FileOutputStream(exampleA.xml);5.xml文件oracle数据插入和读取类Oracle.java；package jdbc;import javax.swing.*;import java.sql.*;import java.io.*;import java.util.*;/xml文件oracle数据插入和读取public class Oracle void getConnection() / 数据库连接函数与SQL操作代码try Class.forName(oracle.jdbc.driver.OracleDriver); catch (Exception ex) System.out.print(加载失败！);try / 与oracle数据库建立连接String username = system;String password = 123456;String url = jdbc:oracle:thin:127.0.0.1:1521:orcl;Connection con = DriverManager.getConnection(url, username,password);if (!con.isClosed() System.out.print(连接成功！n);Statement stmt = con.createStatement();/ 插入xml文件/ String SQL2=Insert into resumes2 values/ (1,XMLType(bfilename(XMLDIR,test.xml),nls_charset_id(AL16UTF8);/ stmt.executeUpdate(SQL2);/ 读取xml文件中字段数据,其中使用XPATH语言String SQL = select employee_id,i.resume.extract(/student-info/student/number/text().getStringVal(),i.resume.extract(/student-info/student/name/text().getStringVal(),i.resume.extract(/student-info/student/age/text().getStringVal() from resumes2 i;ResultSet rs = stmt.executeQuery(SQL);while (rs.next() System.out.println(xml文件字段内容如下：);System.out.println(id: + rs.getString(1);System.out.println(number: + rs.getString(2);System.out.println(name: + rs.getString(3);System.out.println(age: + rs.getString(4);con.close(); / 关闭数据库连接 else System.out.print(连接失败！); catch (SQLException ex) System.out.print(ex.ge