XML与数据库的交互

最新推荐文章于 2024-04-02 11:57:25 发布

wszlh1981

最新推荐文章于 2024-04-02 11:57:25 发布

阅读量734

点赞数

CC 4.0 BY-SA版权

文章标签：数据库 xml import string exception jdbc

本文链接：https://blog.youkuaiyun.com/wszlh1981/article/details/2935699

【第1种】从数据库中将数据写入XML中

    import java.sql.*;
    import javax.xml.parsers.*;
    import org.w3c.dom.*;
    import org.xml.sax.*;
    import java.io.*;

    public class Students{
       public Students() {
       }
       public static void main(String args[]){
          String headerstring="<?xml version=/"1.0/"?>";
          String root="<students>";
          String rootend="<students>";
          try{
                File ff=new File("students.xml");
                ff.createNewFile();
                FileWriter fw=new FileWriter(ff);
                fw.write(headerstring);
                fw.write(root);

                Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                Connection con=DriverManager.getConnection("jdbc:odbc:Prod");
                Statement st=con.createStatement();
                ResultSet rs=st.executeQuery("select * from students");
                while(rs.next()){

                   fw.write("<student>");
                   fw.write("<stud_id>");
                   String stud_id=rs.getString("stud_id");
                   fw.write(stud_id);
                   fw.write("</stud_id>");

                   fw.write("<stud_name>");
                   String stud_name=rs.getString("stud_name");
                   fw.write(stud_name);
                   fw.write("</stud_name>");

fw.write("</students>");

                }
                  fw.write(rootend);
                  fw.close();
          }
          catch(Exception e){
             System.out.println(e);;
          }
       }
    }

【第2种】从XML中将数据写入数据库中

package employees;

    import java.sql.*;
    import javax.xml.parsers.*;
    import org.w3c.dom.*;
    import org.xml.sax.*;
    import java.io.*;

    public class Employee {
        public Employee() {
        }
        public static void main(String args[]){
            try{
                String empid;
                String empname;
                String sql;
                Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                Connection con=DriverManager.getConnection("jdbc:odbc:Prod");
                Statement st=con.createStatement();
                File ff=new File("emp1.xml");

                DocumentBuilderFactory dbf=DocumentBuilderFactory.newInstance();
                DocumentBuilder db=dbf.newDocumentBuilder();
                Document d=db.parse(ff);
                NodeList n1=d.getElementsByTagName("Employee");

                for(int i=0;i<n1.getLength();i++){
                    Element node=(Element)n1.item(i);
                    empid=node.getElementsByTagName("empid").item(0).getFirstChild().getNodeValue();
                    empname=node.getElementsByTagName("empname").item(0).getFirstChild().getNodeValue();
                    sql="insert into emp1 values('"+empid+"','"+empname+"')";
                    st.execute(sql);
                }
                st.close();
                con.close();
            }
            catch(Exception e){
                System.out.println(e);
            }
        }
     }