数据库xml互相操作！！！

Posted on 2009-05-18 13:47 三羽阅读(585) 评论(0) 编辑收藏所属分类: JAVA资料

JAVA如何将XML文档里的数据写入oracle数据库

import org.w3c.dom.Document;
import org.w3c.dom.Element;
import org.w3c.dom.NodeList;
import javax.xml.parsers.DocumentBuilderFactory;
import javax.xml.parsers.DocumentBuilder;
import javax.xml.parsers.ParserConfigurationException;
import org.xml.sax.SAXException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
import java.sql.SQLException;
import java.io.IOException;

public class test1
{
static Connection conn=null;
static String deptno,dname,loc,sql;
static String url="jdbc:oracle:oci8:@hydb";
public static void main(String[] args)
{
  try
  {
   Class.forName("oracle.jdbc.driver.OracleDriver");
   conn=DriverManager.getConnection(url,"scott","tiger");
   Statement st=conn.createStatement();

   DocumentBuilderFactory factory=DocumentBuilderFactory.newInstance();
   DocumentBuilder builder=factory.newDocumentBuilder();
   Document doc=builder.parse("dept.xml");

   NodeList node=doc.getElementsByTagName("PERSON");
   System.out.println(node.getLength());

   for(int i=0;i<node.getLength();i++)
   {
    Element element=(Element)node.item(i);

    deptno=element.getElementsByTagName("DEPTNO").item(0).getFirstChild().getNodeValue();
    dname=element.getElementsByTagName("DNAME").item(0).getFirstChild().getNodeValue();
    loc=element.getElementsByTagName("LOC").item(0).getFirstChild().getNodeValue();

    sql="insert into person values('"+deptno+"','"+dname+"','"+loc+"')";

    st.executeUpdate(sql);
   }
   st.close();
   conn.close();
   System.out.println("插入成功！！！");
  }catch(ClassNotFoundException e)
  {
   e.printStackTrace();
  }catch(SQLException e1)
  {
   e1.printStackTrace();
  }catch(ParserConfigurationException e2)
  {
   e2.printStackTrace();
  }catch(SAXException e3)
  {
   e3.printStackTrace();
  }catch(IOException e4)
  {
   e4.printStackTrace();
  }
}
}

dept.xml文件

<?xml version="1.0" encoding="UTF-8"?>

<COMP>
<PERSON>
    <DEPTNO>10</DEPTNO>
    <DNAME>ACCOUNTING</DNAME>
    <LOC>NEW YORK</LOC>
</PERSON>
<PERSON>
    <DEPTNO>20</DEPTNO>
    <DNAME>RESEARCH</DNAME>
    <LOC>DALLAS</LOC>
</PERSON>
<PERSON>
    <DEPTNO>30</DEPTNO>
    <DNAME>SALES</DNAME>
    <LOC>CHICAGO</LOC>
</PERSON>
<PERSON>
    <DEPTNO>40</DEPTNO>
    <DNAME>OPERATIONS</DNAME>
    <LOC>BOSTON</LOC>
</PERSON>
</COMP>

JAVA如何将oracle数据库里的数据写入XML文档

import org.w3c.dom.Document;
import org.w3c.dom.Element;
import org.apache.crimson.tree.XmlDocument;
import javax.xml.parsers.DocumentBuilderFactory;
import javax.xml.parsers.DocumentBuilder;
import javax.xml.parsers.ParserConfigurationException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.io.File;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.FileNotFoundException;
import java.io.IOException;
import org.xml.sax.SAXException;

public class test
{
static Connection conn=null;
static String sql;
static String url="jdbc:oracle:oci8:@hydb";
public static void main(String[] args)
{
  try
  {
   Class.forName("oracle.jdbc.driver.OracleDriver");
   conn=DriverManager.getConnection(url,"scott","tiger");
   Statement st=conn.createStatement();
   ResultSet rs=st.executeQuery("select * from dept");

   DocumentBuilderFactory factory=DocumentBuilderFactory.newInstance();
   DocumentBuilder builder=factory.newDocumentBuilder();
   Document doc=builder.newDocument();

   Element comp=doc.createElement("COMP");

   while(rs.next())
   {
    Element person=doc.createElement("PERSON");

    Element deptno=doc.createElement("DEPTNO");
    deptno.appendChild(doc.createTextNode(String.valueOf(rs.getInt(1))));
    person.appendChild(deptno);

    Element dname=doc.createElement("DNAME");
    dname.appendChild(doc.createTextNode(rs.getString(2)));
    person.appendChild(dname);

    Element loc=doc.createElement("LOC");
    loc.appendChild(doc.createTextNode(rs.getString(3)));
    person.appendChild(loc);

    comp.appendChild(person);
   }
   rs.close();
   st.close();
   conn.close();

   doc.appendChild(comp);

   ((XmlDocument)doc).write(new FileOutputStream(new File("dept.xml")));

   System.out.println("操作成功！！！");
  }catch(ClassNotFoundException e)
  {
   e.printStackTrace();
  }catch(SQLException e1)
  {
   e1.printStackTrace();
  }catch(ParserConfigurationException e2)
  {
   e2.printStackTrace();
  }catch(FileNotFoundException e3)
  {
   e3.printStackTrace();
  }catch(IOException e4)
  {
   e4.printStackTrace();
  }
}
}

dept.xml文件

<?xml version="1.0" encoding="UTF-8"?>

import org.w3c.dom.Document;
import org.w3c.dom.Element;
import org.apache.crimson.tree.XmlDocument;
import javax.xml.parsers.DocumentBuilderFactory;
import javax.xml.parsers.DocumentBuilder;
import javax.xml.parsers.ParserConfigurationException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.io.File;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.FileNotFoundException;
import java.io.IOException;
import org.xml.sax.SAXException;

public class test2
{
static Connection conn=null;
static String sql;
static String url="jdbc:microsoft:sqlserver://127.0.0.1:1433;databasename=pubs";
public static void main(String[] args)
{
  try
  {
   Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
   conn=DriverManager.getConnection(url,"sa","");
   Statement st=conn.createStatement();
   ResultSet rs=st.executeQuery("select * from jobs");

   DocumentBuilderFactory factory=DocumentBuilderFactory.newInstance();
   DocumentBuilder builder=factory.newDocumentBuilder();
   Document doc=builder.newDocument();

   Element comp=doc.createElement("COMP");

   while(rs.next())
   {
    Element person=doc.createElement("PERSON");

    Element job_id=doc.createElement("JOB_ID");
    job_id.appendChild(doc.createTextNode(String.valueOf(rs.getInt(1))));
    person.appendChild(job_id);

    Element job_desc=doc.createElement("JOB_DESC");
    job_desc.appendChild(doc.createTextNode(rs.getString(2)));
    person.appendChild(job_desc);

    Element min_lvl=doc.createElement("MIN_LVL");
    min_lvl.appendChild(doc.createTextNode(String.valueOf(rs.getInt(3))));
    person.appendChild(min_lvl);

    Element max_lvl=doc.createElement("MAX_LVL");
    max_lvl.appendChild(doc.createTextNode(String.valueOf(rs.getInt(4))));
    person.appendChild(max_lvl);

    comp.appendChild(person);
   }
   rs.close();
   st.close();
   conn.close();

   doc.appendChild(comp);

   ((XmlDocument)doc).write(new FileOutputStream(new File("jobs.xml")));

   System.out.println("操作成功！！！");
  }catch(ClassNotFoundException e)
  {
   e.printStackTrace();
  }catch(SQLException e1)
  {
   e1.printStackTrace();
  }catch(ParserConfigurationException e2)
  {
   e2.printStackTrace();
  }catch(FileNotFoundException e3)
  {
   e3.printStackTrace();
  }catch(IOException e4)
  {
   e4.printStackTrace();
  }
}
}

java解析xml字符串
import java.util.*;
import test.*;

public class MyDOMBean implements java.io.Serializable {
Vector vec = new Vector();

    public MyDOMBean() {
   }

  public Vector getMappingValueNode(String strIndex,String strArea)
{
      NodeIterator keys = null;
      Document doc = null;
      try
      {
         DocumentBuilderFactory factory =
                  DocumentBuilderFactory.newInstance();
         DocumentBuilder builder = factory.newDocumentBuilder();
         doc = builder.parse("/opt/tomcat/jakarta-tomcat-5.0.28/webapps/Visual/WEB-INF/qa.xml");
         String xpath = "/root/" + strArea + "/*";
         keys = XPathAPI.selectNodeIterator(doc, xpath);

        Node key = null;

         int i = 0;


        while ((key = keys.nextNode()) != null)
        {
            NodeIterator aKey = null;
            NodeIterator pKey = null;
            Node name = key.getFirstChild();
            name = name.getNextSibling();
            QuesAnswer qa = new QuesAnswer();
            String tempQ = null;
            tempQ = name.getFirstChild().getNodeValue().toString();
            name = name.getNextSibling();
            name = name.getNextSibling();
            String strTempA = "./answer";
            aKey = XPathAPI.selectNodeIterator(key,strTempA);
            Node tempKeyA = null;
           ArrayList listA = new ArrayList();
            String tempP = null;
            while((tempKeyA = aKey.nextNode()) != null){
            listA.add(tempKeyA.getFirstChild().getNodeValue().toString());
            }

            String[] tempA = new String[listA.size()];
            for(int l = 0;l<listA.size();l++){
            tempA[l] = (String)listA.get(l);
            }
            String strTempP = "./pic";
            pKey = XPathAPI.selectNodeIterator(key,strTempP);
            Node tempKeyP = null;
            while((tempKeyP = pKey.nextNode()) !=null){
            tempP = tempKeyP.getAttributes().getNamedItem("file").getNodeValue();
            }


            if(strIndex==null||strIndex.equals("")){
            qa.setQuestion(tempQ);
            qa.setAnswer(tempA);
            qa.setPicture(tempP);
            vec.add(qa);
      }else{
      if (tempQ.indexOf(strIndex)>= 0){
            qa.setQuestion(tempQ);
            qa.setAnswer(tempA);
            qa.setPicture(tempP);
            vec.add(qa);
            }else{
            for(int h = 0;h<tempA.length;h++){
            if(tempA[h].indexOf(strIndex)>=0){
            qa.setQuestion(tempQ);
            qa.setAnswer(tempA);
            qa.setPicture(tempP);
            vec.add(qa);
            break;
            }
            }
            }
            }

         }


      }catch(Exception ex)
      {
         System.out.println("[Error] Can not get mapping Value.");
         System.out.println(ex);
      }
return vec;

}

}
2、

package test;

public class QuesAnswer{
private String question = null;
private String[] answer = null;
private String picture = null;

public void setQuestion(String ques){
this.question = ques;
}

public void setAnswer(String[] answer){
this.answer = answer;
}

public String getQuestion(){
return this.question;
}

public String[] getAnswer(){
return this.answer;
}

public void setPicture(String picture){
this.picture = picture;
}

public String getPicture(){
return this.picture;
}
}

3、

XML

<?xml version="1.0" encoding="GB2312" ?>
<root>
<resume1>
<qa id="01">
<question>问题：我的PDA不能联结到灵视系统服务器。
</question>
<answer>回答：请检查是否已经播号联结（移动用户拨，联通用户拨#777，小灵通用户拨ISP服务号码）。
</answer>
</qa>
<qa id="02">
<question>问题：我的PC不能联结到灵视系统服务器。ssssss
</question>
<answer>回答：请确认；
1. 网线已连接且工作正常。
2. MPEG-4_Player目录下Decoder.ini文件中ip地址和端口号是否正确。
</answer>
</qa>
<qa id="03">
<question>问题:</question>
<answer>回答1:</answer>
<answer>回答2:</answer>
<answer>回答3:</answer>
<answer>回答4:</answer>
<answer>回答5:</answer>
<pic file="jiejuefangan-1.jpg"/>
</qa>
<qa id="04">
<question>问题:</question>
<answer>回答:</answer>
</qa>
</resume1>

<resume2>
<qa id="01">
<question>问题:</question>
<answer>回答:</answer>
</qa>
<qa id="02">
<question>问题:</question>
<answer>回答:</answer>
<answer>回答1:</answer>
<answer>回答2:</answer>
<answer>回答3:</answer>
<answer>回答4:</answer>
<answer>回答5:</answer>
</qa>
<qa id="03">
<question>问题:</question>
<answer>回答:</answer>
</qa>
<qa id="04">
<question>问题:</question>
<answer>回答:</answer>
</qa>
</resume2>
</root>

新用户注册刷新评论列表


只有注册用户登录后才能发表评论。




网站导航: 博客园 IT新闻 Chat2DB C++博客博问管理
相关文章: 部署程序svn及eclipse 最新版整合Apache2.2.9和Tomcat6.0.18 JAVA面试精选26题工程打war包方法用JAVA调用.net的webservice实例将图片文件写入数据库BLOB 数据库xml互相操作！！！ tomcat配置为系统服务 struts hibernate spring整合总结 Tomcat 配置集锦

Believe it,do it!

数据库xml互相操作！！！

常用链接

留言簿(2)

随笔分类(25)

随笔档案(34)

相册

搜索

最新评论

阅读排行榜

评论排行榜