HP Driver for JDBC User's Manual
Appendix D 83
Simple Client Source Code
e.printStackTrace();
System.exit(0);
}
/* Main loop */
String sql = null;
ResultSet rs = null;
while (true)
{
/* Ask user for an sql statement */
System.out.println("");
sql = getString("SQL -> ");
System.out.println("");
/* If empty string, then exit */
if (sql == null || sql.length() == 0)
break;
/* Submit the sql statement */
try
{
stmt = con.createStatement();
/* If execute returns true, there is a result set */
if (stmt.execute(sql))
{
rs = stmt.getResultSet();
displayResultSet(rs);
}
/* Otherwise, there is an update count */
else
System.out.println(stmt.getUpdateCount() + " rows changed.");