xml基础教程2版第7章的代码

《xml基础教程2版第7章的代码》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、第7章XML与数据库7.3连接数据库例子1InsertAndQuery.javaimportjava.sql.*;publicclassInsertAndQuery{publicstaticvoidmain(Stringargs[]){Connectioncon;Statementsql;ResultSetrs;try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}catch(ClassNotFoundExceptione){System.out.println(""+e);}try{con=DriverManager.

2、getConnection("jdbc:odbc:company","","");sql=con.createStatement();sql.executeUpdate("INSERTINTOpersonVALUES('a1004','张三','1995-12-12',3000)");sql.executeUpdate("INSERTINTOpersonVALUES('a1005','李四','1996-09-10',5000)");rs=sql.executeQuery("SELECT*FROMperson");while(rs.next()){Stringnumb

3、er=rs.getString(1);Stringname=rs.getString(2);Datebirth=rs.getDate(3);doublesalary=rs.getDouble(4);System.out.println(number+","+name+","+birth+","+salary);}con.close();}catch(SQLExceptione){163System.out.println(e);}}}7.4XML至数据库例子2example7_2.xml<雇员列表

4、><雇员><雇员号>A1006<姓名>王经路<出生日期>1995-11-11<薪水>6789<雇员><雇员号>A1007<姓名>赵懂知<出生日期>1995-06-28<薪水>5673XMLToDatabase.javaimportjavax.xml.xpath.*;importorg.xml.sax.*;importorg.w3c.dom.*;importjava.sql.*;publicclassXMLToDatabase{publicsta

5、ticvoidmain(Stringargs[]){Connectioncon=null;Statementsql=null;ResultSetrs=null;try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");163}catch(Exceptione){System.out.println(""+e);}try{con=DriverManager.getConnection("jdbc:odbc:company","","");sql=con.createStatement();XPathFactoryxPathFac

6、tory=XPathFactory.newInstance();XPathxPath=xPathFactory.newXPath();InputSourcesource=newInputSource("example9_2.xml");Stringpath="/雇员列表/雇员";NodeListnodeList=(NodeList)xPath.evaluate(path,source,XPathConstants.NODESET);intsize=nodeList.getLength();for(inti=0;i

7、员列表/雇员["+m+"]/*/text()";nodeList=(NodeList)xPath.evaluate(path,source,XPathConstants.NODESET);intlength=nodeList.getLength();String[]a=newString[length];for(intk=0;k