@Mapper
public interface UserMapper {
@Select("select * from t_user where id = #{id}")
public User getUserById(Integer id);
@Options(useGeneratedKeys = true,keyProperty = "id") //加入自增主键
@Insert("insert into t_user(username,password,employeeNum,departmentId) values(#{username},#{password},#{employeeNum},#{departmentId})")
public int insertUser(User user);
@Delete("delete from t_user where id=#{id}")
public int deleteById(Integer id);
@Update("update t_user set username=#{username},password=#{password} where id=#{id}")
public int updateUser(User user);
@Select("select * from t_user")
public List<User> getALLUsers();
@Select("select u.*,r.rolename from t_user u left join t_role_user ru on u.id=ru.user_id left join t_role r on ru.role_id=r.id where username=#{username}")
public List<Role> findByUserName(String username);
@Select("select * from t_user where username like CONCAT('%',#{name},'%') and employeeNum like CONCAT('%',#{num},'%')")
public List<User> searchUsers(@Param("name") String name,@Param("num") String num);
@Select("select * from t_user where employeeNum like CONCAT('%',#{employeeNum},'%')")
public List<User> searchUsersNum(String employeeNum);
}
注意:多个条件进行查询时,需要加上@Param,否则查询无效
@Select("select * from t_user where username like CONCAT('%',#{name},'%') and employeeNum like CONCAT('%',#{num},'%')")
public List<User> searchUsers(@Param("name") String name,@Param("num") String num);