Java Reference
In-Depth Information
"
LANGUAGE JAVA"+
"
DYNAMIC RESULT SETS 0"+
"
EXTERNAL
NAME
'Employ-
eeDB.fire'";
stmt.executeUpdate(sql);
sql = "CREATE TABLE EMPLOYEES(ID INTEGER, NAME
VARCHAR(30), "+
"FIRED
BOOLEAN)";
stmt.executeUpdate(sql);
sql = "INSERT INTO EMPLOYEES VALUES(1, 'John
Doe', false)";
stmt.executeUpdate(sql);
sql = "INSERT INTO EMPLOYEES VALUES(2, 'Sally
Smith', false)";
stmt.executeUpdate(sql);
dump(stmt.executeQuery("SELECT
*
FROM
EMPLOYEES"));
try
(CallableStatement
cstmt
=
con.prepareCall("{ call FIRE(?)}"))
{
cstmt.setInt(1, 2);
cstmt.execute();
}
dump(stmt.executeQuery("SELECT
*
FROM
EMPLOYEES"));
sql = "DROP TABLE EMPLOYEES";
stmt.executeUpdate(sql);
sql = "DROP PROCEDURE FIRE";
stmt.executeUpdate(sql);
}
}
catch (SQLException sqlex)
{
while (sqlex != null)
{
