按照开发手册写的一个小demo的模糊查询,也不报错,就是查不到数据,数据库有数据

Blade 未结 1 1584
红领巾
红领巾 2019-12-17 17:39



2019-12-17 17:29:17.698  INFO 7244 --- [  XNIO-1 task-1] io.undertow.servlet                      : Initializing Spring DispatcherServlet 'dispatcherServlet'

2019-12-17 17:29:17.698  INFO 7244 --- [  XNIO-1 task-1] o.s.web.servlet.DispatcherServlet        : Initializing Servlet 'dispatcherServlet'

2019-12-17 17:29:17.714  INFO 7244 --- [  XNIO-1 task-1] o.s.web.servlet.DispatcherServlet        : Completed initialization in 16 ms

INFO: log base dir is: C:\Users\Administrator\logs\csp\

INFO: log name use pid is: false

2019-12-17 17:29:17.807 DEBUG 7244 --- [  XNIO-1 task-1] .c.c.v.BladeRequestMappingHandlerMapping : Mapped to public org.springblade.core.tool.api.R> org.springblade.demo.controller.DemoController.dim(java.util.Map)

2019-12-17 17:29:17.832  INFO 7244 --- [  XNIO-1 task-1] o.s.core.log.aspect.RequestLogAspect     : 


================  Request Start  ================

===> GET: /api/dim Parameters: {"shool":{"xxmc":"小学"}}

===Headers===  Accept : */*

===Headers===  Connection : keep-alive

===Headers===  User-Agent : PostmanRuntime/7.6.0

===Headers===  Postman-Token : e2196e5c-10a2-45a2-beb2-eeae4efe1786

===Headers===  Host : localhost:8107

===Headers===  cache-control : no-cache

===Headers===  accept-encoding : gzip, deflate

===Headers===  Content-Type : application/json

================  Request  End   ================


2019-12-17 17:29:17.912 DEBUG 7244 --- [  XNIO-1 task-1] o.s.demo.mapper.DemoMapper.selectList    : ==>  Preparing: SELECT id, zsxx, xxbxlxm, xxqhm, lsyg, jxny, xxzgbmm, zbwd, xxywmc, xxdz, xxmc, xxdm, xxlx, office_id, sspq, version_no, xxxzm, xqr, xxxz, zbjd, zxdh FROM blade_school_info WHERE id = ? AND (xxmc LIKE ?) 

2019-12-17 17:29:17.926 DEBUG 7244 --- [  XNIO-1 task-1] o.s.demo.mapper.DemoMapper.selectList    : ==>  Preparing: SELECT id, zsxx, xxbxlxm, xxqhm, lsyg, jxny, xxzgbmm, zbwd, xxywmc, xxdz, xxmc, xxdm, xxlx, office_id, sspq, version_no, xxxzm, xqr, xxxz, zbjd, zxdh FROM blade_school_info WHERE id = ? AND (xxmc LIKE ?) 

2019-12-17 17:29:17.935 DEBUG 7244 --- [  XNIO-1 task-1] o.s.demo.mapper.DemoMapper.selectList    : ==> Parameters: 0(Integer), %小学%(String)


==============  Sql Start  ==============

2019-12-17 17:29:17.947Execute ID  :org.springblade.demo.mapper.DemoMapper.selectList

 DEBUG 7244 --- Execute SQL :SELECT id, zsxx, xxbxlxm, xxqhm, lsyg, jxny, xxzgbmm, zbwd, xxywmc, xxdz, xxmc, xxdm, xxlx, office_id, sspq, version_no, xxxzm, xqr, xxxz, zbjd, zxdh FROM blade_school_info WHERE id = ? AND (xxmc LIKE ?)

[  XNIO-1 task-1] o.s.demo.mapper.DemoMapper.selectList    : <==      Total: 0

Execute Time:14 ms

==============  Sql  End   ==============


2019-12-17 17:29:17.969  INFO 7244 --- [  XNIO-1 task-1] o.s.core.log.aspect.RequestLogAspect     : 


================  Response Start  ===============

===Result===  {"code":200,"success":true,"data":[],"msg":"操作成功"}

<=== GET: /api/dim (135 ms)

================  Response  End   ===============

1条回答
  •  晓庄
    晓庄 (楼主)
    2019-12-18 09:02

    拿你 DEBUG 的 sql 去查下就知道了呗

    0 讨论(0)
提交回复