| | |
| | | " where allDeptName like #{queryParam}" + |
| | | "</script>") |
| | | public void changeAllDeptName(@Param("fromName") String fromName, @Param("toName") String toName,@Param("queryParam") String queryParam); |
| | | |
| | | @Update("<script>" + |
| | | " update t_emp_baseinfo\n" + |
| | | " set allDeptName = replace(allDeptName, #{fromName}, #{toName})" + |
| | | " where allDeptName like #{queryParam}" + |
| | | "</script>") |
| | | public void updateEmpAllDeptName(@Param("fromName") String fromName, @Param("toName") String toName,@Param("queryParam") String queryParam); |
| | | |
| | | @Update("<script>" + |
| | | " update t_emp_baseinfo \n" + |
| | | " set deptName = #{newDeptName} \n" + |
| | | " where deptId = #{queryParam} \n" + |
| | | "</script>") |
| | | public void updateEmpDeptName(@Param("newDeptName") String newDeptName,@Param("queryParam") String queryParam); |
| | | } |