public Integer create(Role role) throws DataIntegrityViolationException { String CREATE = "INSERT cucgp.`role` (role_name) VALUES (?);"; Integer ret = jdbcTemplate.update(CREATE, role.getRoleName()); String LAST_INSERT_ID = "SELECT LAST_INSERT_ID()"; Integer id = jdbcTemplate.queryForObject(LAST_INSERT_ID, Integer.class); role.setRoleId(id); relation(role, true); return ret; }
public Integer write(Role role) { String UPDATE = "UPDATE cucgp.`role` SET role_name = (?) WHERE role_id = (?);"; Integer ret = jdbcTemplate.update(UPDATE, role.getRoleName(), role.getRoleId()); if (ret == 1) { relation(role, true); return ret; } else { return 0; } }