Mybatis更新(修改数据操作)

多个获取多项进行修改

UserMapper.java

	@Select("select empno,ename,job,mgr,hiredate,sal,comm,deptno from emp where empno=#{empno}")
    User findUserById(Integer empno);

	@Update("update emp set ename=#{ename},job=#{job},mgr=#{mgr}," +
            "hiredate=#{hiredate},sal=#{sal},comm=#{comm},deptno=#{deptno} where empno=#{empno}")
    Integer updateUser(User user);

TestCase.java

	@Test
    public void testUpdateUser(){
        UserMapper mapper = ctx.getBean("userMapper",UserMapper.class);
        User user = mapper.findUserById(3);
        user.setComm(9000);
        int n = mapper.updateUser(user);
        System.out.println(n);
    }

• 修改3号员工的comm(奖金)为9000

单个修改，无需获取多个参数

@Update("update emp set comm=#{comm} where empno = #{id}")
Integer updateEmailById(@Param("comm") String email, @Param("id") Integer id);

• 方法是多个参数时使用，@Param避免命名冲突，数据中按Param中命名进行操作。

    @Test
    public void testUpdateEmailById(){
        UserMapper mapper = ctx.getBean("userMapper",UserMapper.class);
        int n = mapper.updateEmailById("30000",2);
        System.out.println(n);
    }