在查询的时候,只要name和description有值时就查询不到数据,把sql语句直接在mysql里查询却有是正常的!
2015-06-26 17:28:17,350 [http-bio-8080-exec-7] DEBUG [Command.queryCommandList] - ==> Preparing: select a.ID C_ID,a.NAME,a.DESCRIPTION,b.ID,b.CONTENT,b.COMMAND_ID from COMMAND a left join COMMAND_CONTENT b on a.ID=b.COMMAND_ID WHERE a.NAME=?
2015-06-26 17:28:17,351 [http-bio-8080-exec-7] DEBUG [Command.queryCommandList] - ==> Parameters: 段子(String)
2015-06-26 17:28:17,352 [http-bio-8080-exec-7] DEBUG [Command.queryCommandList] - <== Total: 0
2015-06-26 17:22:24,455 [http-bio-8080-exec-5] DEBUG [Command.queryCommandList] - ==> Preparing: select a.ID C_ID,a.NAME,a.DESCRIPTION,b.ID,b.CONTENT,b.COMMAND_ID from COMMAND a left join COMMAND_CONTENT b on a.ID=b.COMMAND_ID
2015-06-26 17:22:24,486 [http-bio-8080-exec-5] DEBUG [Command.queryCommandList] - ==> Parameters:
2015-06-26 17:22:24,632 [http-bio-8080-exec-5] DEBUG [Command.queryCommandList] - <== Total: 6