【六袆 - Java】@Param注解的用法; @Param注解的使用;@Param注解的开发;@Param注解的作用
目录
操作:查询列表
主要看DAO层和XML映射
1.controller层
@PostMapping
@ApiOperation("用户列表")
@ApiImplicitParams({@ApiImplicitParam(name = "userName", value = "用户名称", required = false, paramType = "query", dataType = "String")})
public ResponseResult listUser(QueryUser user) {
return UserService.listUser(user);
}
2.Service层
public ResponseResult listUser(QueryUser user) {
PageHelper.startPage(user.getPageNum(), user.getPageSize());
String userName = ParamUtil.like(user.getUserName());
List<HashMap<String, Object>> list = UserDao.listUser(userName);
ParamUtil.addr("userAddressId", list, addressDao);
return new ResponseResult(new PageInfo<HashMap<String, Object>>(list));
}
3.Dao层
List<HashMap<String, Object>> listUser(@Param("userName") String userName);
4. xml映射
<select id="listUser" parameterType="String" resultType="HashMap">
select
<include refid="Base_Column_List1"/>
from User where 1=1 and user_delete_flag = 0
<if test="@com.ly.user.common.util.StringUtil@isEmptySql(userName)">
and user_name like #{userName}
</if>
order by
user_creat_time desc
</select>
附赠一个图,理解
本文来自博客园,作者:你好,Alf,转载请注明原文链接:https://www.cnblogs.com/Alf-/p/16192853.html