MyBatis操作-更新数据

需要用到的SQL语句

update emp set username = '',name ='',gender = '',image = '',job ='',entrydate = '',dept_id='',update_time='' where id =1;

需要用到的实体类Emp

@Data
@NoArgsConstructor
@AllArgsConstructor
public class Emp {
    private Integer id;
    private String username;
    private String password;
    private String name;
    private Short gender;
    private String image;
    private Short job;
    private LocalDate entrydate;
    private Integer deptId;
    private LocalDateTime createTime;
    private LocalDateTime updateTime;
}

映射接口EmpMapper

public interface EmpMapper {

    @Update("update emp set username = #{username},name =#{name},gender = #{gender},image = #{image},job =#{job},entrydate = #{entrydate},dept_id=#{deptId},update_time=#{updateTime} where id =#{id};")
    public void update(Emp emp);
}

测试

    @Autowired
    private EmpMapper empMapper;

    @Test
    public void testUpdate(){
        Emp emp = new Emp();
        emp.setId(18);
        emp.setUsername("Tom9");
        emp.setName("汤姆9");
        emp.setImage("2.jpg");
        emp.setGender((short)1);
        emp.setJob((short)1);
        emp.setDeptId(1);
        emp.setEntrydate(LocalDate.of(2000,5,1));
        emp.setUpdateTime(LocalDateTime.now());

        //执行更新员工对象
        empMapper.update(emp);
    }
}