Application development with Java - DB2 Express-C: The Developer for XML, PHP, C/C++, Java, and .NET - page 206

System.err.println(" Statement " + i + ":" +
updateCounts[i]);
System.err.println(" Message: " + buex.getMessage());
System.err.println(" SQLSTATE: " + buex.getSQLState());
System.err.println(" Error code: " + buex.getErrorCode());
SQLException ex = buex.getNextException();
while (ex != null) {
System.err.println("SQL exception:");
System.err.println(" Message: " + ex.getMessage());
System.err.println(" SQLSTATE: " + ex.getSQLState());
System.err.println(" Error code: " + ex.getErrorCode());
ex = ex.getNextException();
}
}
} // createCart
public double findTotal()
{
Statement stmt;
try {
stmt = con.createStatement();
String query="select sum(price*quantity) from cart"+cid+",
product where cart"+cid+".pid=product.pid";
ResultSet rs= stmt.executeQuery(query);
rs.next();
return rs.getDouble(1);
} catch (SQLException e) {
System.out.println(e.getMessage());
System.out.println(e.getErrorCode());
e.printStackTrace();
return 0;
}
}
// updateTable updates the purchaseorder table with the new purchase
// order
public int updateTable()
{
try {
Statement stmt=con.createStatement();
String porder=null;
String dropQuery="drop table cart"+cid;
con.setAutoCommit(false);
ResultSet rs=stmt.executeQuery("select max(poid) from
purchaseorder");
rs.next();