在查詢的時候,只要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
2019-08-27
說明數據查詢沒問題,你獲取數據有問題,打斷點追蹤數據
2016-01-02
看看mysql的編碼方式 以及連接時 url后面指定?
jdbc:mysql://localhost:3306/mirco_message?characterEncoding=utf8
原因可能是傳入的中文字符解析成了一個?