@Override
public void put(Emp object) {
Emp emp = object;
String sql;
if (emp.getId() == null) {
emp.setId(DBSrv.getInstance().getNextId());
sql = "INSERT INTO DDT_EMP(lname,fname,mname,d_hire,d_fire,id) " + "VALUES(?,?,?,?,?,?)";
} else {
sql =
"UPDATE DDT_EMP SET "
+ " lname = ?, "
+ " fname = ?, "
+ " mname = ?, "
+ " d_hire = ?, "
+ " d_fire = ? "
+ " WHERE id = ?";
}
try {
PreparedStatement st = conn.prepareStatement(sql);
st.setString(1, emp.getLastName());
st.setString(2, emp.getFirstName());
st.setString(3, emp.getMiddleName());
st.setDate(4, DBSrv.UtilToSQL(emp.getHireDate()));
st.setDate(5, DBSrv.UtilToSQL(emp.getFireDate()));
st.setInt(6, emp.getId());
st.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
}
}
