@Override
protected void saveUser(User u) {
/*procedure add_user(
p_id in dxdy_user.id%type,
p_username in dxdy_user.username%type,
p_status in dxdy_status.status_name%type,
p_reg_date in varchar2);
*/
super.saveUser(u);
String procedure = "{call dxdy_executable.add_user (?, ?, ?, ?)}";
CallableStatement st = null;
try {
st = connection.prepareCall(procedure);
st.setInt(1, u.ID);
st.setString(2, u.name);
st.setString(3, u.status);
st.setString(4, u.regDate);
st.execute();
// System.out.println("User ID = " + u.ID + ": OK");
} catch (SQLException e) {
e.printStackTrace();
} finally {
if (st != null) {
try {
st.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
