Java Reference
In-Depth Information
stmt.executeUpdate(SQLCmd[i]);
}
xmlDoc =
((JavaDatabaseBible.ch19.JDBCforXML.XMLStatement)stmt).getXmlDocument();
}
catch (Exception e){
System.out.println(e);
}
return xmlDoc;
}
public Document queryTable(String SQLQuery){
ResultSet rs = null;
try{
Connection con = DriverManager.getConnection(UrlString);
Statement stmt = con.createStatement();
rs = stmt.executeQuery(SQLQuery);
while(rs.next()){
getRowData(rs);
}
while(rs.previous()){
getRowData(rs);
}
rs.first();
getRowData(rs);
rs.last();
getRowData(rs);
rs.absolute(2);
getRowData(rs);
rs.relative(-1);
getRowData(rs);
}
catch (Exception e){
System.out.println(e);
}
return ((JavaDatabaseBible.ch19.JDBCforXML.XMLResultSet)rs).xmlDoc;
}
private void getRowData(ResultSet rs){
try {
