多个获取多项进行修改
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)