Java Reference
In-Depth Information
Doe')";
stmt.executeUpdate(sql);
sql = "INSERT INTO EMPLOYEES VALUES(2, 'Sally
Smith')";
stmt.executeUpdate(sql);
ResultSet rs = stmt.executeQuery("SELECT * FROM
EMPLOYEES");
while (rs.next())
System.out.println(rs.getInt("ID")+"
"+rs.getString("NAME"));
sql = "DROP TABLE EMPLOYEES";
stmt.executeUpdate(sql);
}
}
catch (SQLException sqlex)
{
while (sqlex != null)
{
System.err.println("SQL
error
:
"+sqlex.getMessage());
System.err.println("SQL
state
:
"+sqlex.getSQLState());
System.err.println("Error
code:
"+sqlex.getErrorCode());
System.err.println("Cause:
"+sqlex.getCause());
sqlex = sqlex.getNextException();
}
}
}
static boolean isExist(Connection con, String tableName)
throws SQLException
{
DatabaseMetaData dbmd = con.getMetaData();
ResultSet rs = dbmd.getTables(null, "APP", tableName,
null);
