import .*;
import .*;
public class OracleJavaProc ...{
// Add a salgrade to the database.
public static void addSalGrade(int grade, int losal, int hisal) ...{
("Creating new salgrade for EMPLOYEE...");
try ...{
Connection conn =
("jdbc:default:connection:");
String sql =
"INSERT INTO salgrade " +
"(GRADE,LOSAL,HISAL) " +
"VALUES(?,?,?)";
PreparedStatement pstmt = (sql);
(1,grade);
(2,losal);
(3,hisal);
();
();
}
catch(SQLException e) ...{
("ERROR! Adding Salgrade: "
+ ());
}
}
public static int getHiSal(int grade)
...{
try ...{
Connection conn =
("jdbc:default:connection:");
String sql = "SELECT hisal FROM salgrade WHERE grade = ?";
PreparedStatement pstmt = (sql);(1, grade);
ResultSet rset = ();
int res = 0;
if (())
...{
res = (1);
}
();
return res;
}
catch (SQLException e)
...{
("ERROR! Querying Salgrade: "
+ ());
return -1;
}
}
}