XML基础教程版第章的代码.docVIP

第7章 XML与数据库 7.3 连接数据库 例子1 InsertAndQuery.java import java.sql.*; public class InsertAndQuery{ public static void main(String args[]){ Connection con; Statement sql; ResultSet rs; try { Class.forName(sun.jdbc.odbc.JdbcOdbcDriver); } catch(ClassNotFoundException e){ System.out.println(+e); } try{ con=DriverManager.getConnection(jdbc:odbc:company,,); sql=con.createStatement(); sql.executeUpdate (INSERT INTO person VALUES(a1004,张三,1995-12-12,3000)); sql.executeUpdate (INSERT INTO person VALUES(a1005,李四,1996-09-10,5000)); rs=sql.executeQuery(SELECT * FROM person); while(rs.next()){ String number=rs.getString(1); String name=rs.getString(2); Date birth=rs.getDate(3); double salary=rs.getDouble(4); System.out.println(number+,+name+,+birth+,+salary); } con.close(); } catch(SQLException e){ System.out.println(e); } } } 7.4 XML至数据库 例子2 example7_2.xml ?xml version=1.0 encoding=UTF-8? 雇员列表 雇员 雇员号A1006/雇员号 姓名王经路/姓名 出生日期1995-11-11/出生日期 薪水6789/薪水 /雇员 雇员 雇员号A1007/雇员号 姓名赵懂知/姓名 出生日期1995-06-28/出生日期 薪水5673/薪水 /雇员 /雇员列表 XMLToDatabase.java import javax.xml.xpath.*; import org.xml.sax.*; import org.w3c.dom.*; import java.sql.*; public class XMLToDatabase{ public static void main(String args[]){ Connection con=null; Statement sql=null; ResultSet rs=null; try { Class.forName(sun.jdbc.odbc.JdbcOdbcDriver); } catch(Exception e){ System.out.println(+e); } try{ con=DriverManager.getConnection(jdbc:odbc:company,,); sql=con.createStatement(); XPathFactory xPathFactory=XPathFactory.newInstance(); X