按id搜索返回为空
老师，我在自测的时候，按照id来搜索的话，返回为空，如果不填写productName和productId那么返回结果也为空，不应该是返回所有嘛，我对照了老师的代码就是这样写的，没找到原因呢？？
xml文件：
<select id="selectProductByNameAndId" resultMap="BaseResultMap" parameterType="map">
SELECT
<include refid="Base_Column_List"/>
from mmall_product
<where>
<if test="productName !=null">
and name like #{productName}
</if>
<if test="productId !=null">
and id=#{productId}
</if>
</where>
</select>
controller文件：
@RequestMapping(value = "search.do",method = RequestMethod.POST)
@ResponseBody
public ServerResponse search(HttpSession session,String productName,Integer productId,@RequestParam(value = "pageNum",defaultValue = "1") Integer pageNum,@RequestParam(value = "pageSize",defaultValue = "10") Integer pageSize){
User user = (User) session.getAttribute(Const.CURRENT_USER);
if (user ==null){
return ServerResponse.createByErrorCodeMessage(ResponseCode.ILLEGAL_ARGUMENT.getCode(),ResponseCode.ILLEGAL_ARGUMENT.getDesc());
}
if (iUserService.checkAdminRole(user).isSuccess()){
return iProductService.getSearchResult(productName,productId,pageNum,pageSize);
}
返回结果：
{
"status": 0,
"data":{
"pageNum": 1,
"pageSize": 20,
"size": 0,
"orderBy": null,
"startRow": 0,
"endRow": 0,
"total": 0,
"pages": 0,
"list":[
],
"firstPage": 0,
"prePage": 0,
"nextPage": 0,
"lastPage": 0,
"isFirstPage": true,
"isLastPage": false,
"hasPreviousPage": false,
"hasNextPage": false,
"navigatePages": 8,
"navigatepageNums":[]
}
}
正在回答 回答被采纳积分+3
3回答
-
wendy_z #2
JDBC Connection [jdbc:mysql://192.168.65.2:3306/mmall_learning?characterEncoding=utf-8, UserName=mmall@192.168.65.1, MySQL Connector Java] will not be managed by Spring [16:46:45.918][DEBUG][c.m.d.P.selectProductByNameAndId_COUNT][http-bio-8088-exec-2] ==> Preparing: SELECT count(*) FROM mmall_product WHERE name LIKE ? AND id = ? [16:46:45.918][DEBUG][c.m.d.P.selectProductByNameAndId_COUNT][http-bio-8088-exec-2] ==> Parameters: (String), 30(Integer) [16:46:45.920][DEBUG][c.m.d.P.selectProductByNameAndId_COUNT][http-bio-8088-exec-2] <== Total: 1
有任何疑惑可以回复我~ 2018-01-22 16:48:21
