之前写好的接口,接口文档已经给到领导了,然后来问我怎么调用的,时间已经过去有段日子了我自己也不太清楚,于是我按照我自己的接口文档当着领导的面来调用,报错了贼尴尬.然后我找原因我的sql是这样写的
mapper是这样写的
实现类
contorller
/**
* 渠道信息查询-渠道信息导出excel
* @return
*/
@RequestMapping("/getChannelInfoExcel")
@ResponseBody
public Result getFundAccInfosExcel(SearchParam sp,HttpServletResponse res,HttpServletRequest request){
Result result = Result.SUCCESS();
String contactName = request.getParameter("contactName");
String networkName = request.getParameter("networkName");
String contactPosition = request.getParameter("contactPosition");
logger.info("根据条件导出渠道信息Excel:"+"联系人姓名contactName:"+contactName+"网点名称networkName"+networkName+"联系人职务contactPosition"+contactPosition);
List<ChannelEntity> list=channelService.getChannelListAll(contactName, networkName, contactPosition);
return result;
}
然后我请求接口的时候是这样请求的:
http://127.0.0.1:8011/channel/getChannelInfoExcel?contactName=""&networkName=""&contactPosition=""
返回的数据为空waht?当时的真的是不解呀,为啥呢?为什么呢?怎么就为空了呢?不知道是不是当时中午要吃饭了饿傻了传入在传值的时候输入双引号在Sql判断的时候就会判断为有值,值就是双引号所以是没有值的
2018-08-28 13:43:41,051 INFO 根据条件导出渠道信息Excel:联系人姓名contactName:""网点名称networkName""联系人职务contactPosition""
2018-08-28 13:43:42,505 DEBUG ==> Preparing: SELECT ID, NETWORKNAME, NETWORKADDRESS, CONTACTNAME, CONTACTPOSITION, TELEPHONE, PHONENUMBER, EMAIL FROM CMF_SALES_CHANNEL WHERE 1=1 AND CONTACTNAME=? AND NETWORKNAME=? AND CONTACTPOSITION=? AND ISDEL='1' ORDER BY ID DESC
2018-08-28 13:43:42,507 DEBUG ==> Parameters: ""(String), ""(String), ""(String)
2018-08-28 13:43:42,517 DEBUG <== Total: 0
吃完饭后我在看了一眼,改了请求
http://127.0.0.1:8011/channel/getChannelInfoExcel?contactName=&networkName=&contactPosition=
这样请求就有值了,我当时怎么了
2018-08-28 13:49:35,879 INFO 根据条件导出渠道信息Excel:联系人姓名contactName:网点名称networkName联系人职务contactPosition
2018-08-28 13:49:36,810 DEBUG ==> Preparing: SELECT ID, NETWORKNAME, NETWORKADDRESS, CONTACTNAME, CONTACTPOSITION, TELEPHONE, PHONENUMBER, EMAIL FROM CMF_SALES_CHANNEL WHERE 1=1 AND ISDEL='1' ORDER BY ID DESC
2018-08-28 13:49:36,812 DEBUG ==> Parameters:
2018-08-28 13:49:36,834 DEBUG <== Total: 25