@Override public void updateWorkTime(WorkTime workTime) { String sql = "update KGADE.T_ADE_WORKTIME set COMPANY_ID=?, NAME=?,BEGIN_TIME=?,END_TIME=?,FOLLOWING_DAY=? where ID=?"; jdbcTemplate.update( sql, workTime.getCompanyId(), workTime.getName(), workTime.getBeginTime(), workTime.getEndTime(), workTime.isFollowingDay(), workTime.getId()); }
@Override public void saveWorkTime(WorkTime workTime) { String sql = "insert into KGADE.T_ADE_WORKTIME(ID,COMPANY_ID,NAME,BEGIN_TIME,END_TIME,FOLLOWING_DAY,SYSTEM) " + "VALUES(?,?,?,?,?,?,?)"; jdbcTemplate.update( sql, workTime.getId(), workTime.getCompanyId(), workTime.getName(), workTime.getBeginTime(), workTime.getEndTime(), workTime.isFollowingDay(), workTime.isSystem()); }