看之前有童鞋出了這問題，然后說在Dao中trim()了，我試了，沒效果。代碼如下：

Dao層：

//獲取message表中數據

public List<Message> messagelist(String command,String description){

List<Message> messagelist = null;

//調用Dao操作方法

//messagelist = this.dbaccess(command,description);

//調用Mybatis方式操作方法

SqlSession sqlSession = null;

Message message = new Message();

//檢索數據處理

if(command !=null&&!"".equals(command.trim())){

message.setCommand(command.trim());

}

if(description !=null&&!"".equals(description.trim())){

message.setDescription(description.trim());

}

try {

//獲取sqlSession

sqlSession = this.dbaccess.mybatis();

//查詢messagelist

messagelist = sqlSession.selectList("Message.messagelist",message);

} catch (IOException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

finally{

//關閉數據庫連接會話

if(sqlSession != null){

sqlSession.close();

}

}

mappersql.xml配置文件:

?<select id="messagelist" parameterType="blue.java.model.Message" resultMap="MessageResult">

? ? select id,command,description,content from message where 1=1

? ? <if test="command != null ">

? ? and command = #{command}

? ? </if>

? ? <if test="description != null">

? ? and description like '%' #{description} '%'

? ? </if>

? </select>

日志打印如下:

DEBUG [http-8080-2] - Opening JDBC Connection

DEBUG [http-8080-2] - Setting autocommit to false on JDBC Connection [com.mysql.jdbc.JDBC4Connection@1dc696e]

DEBUG [http-8080-2] - ==> ?Preparing: select id,command,description,content from message where 1=1 and command = ??

DEBUG [http-8080-2] - ==> Parameters: 查看(String)

DEBUG [http-8080-2] - <== ? ? ?Total: 0

DEBUG [http-8080-2] - Resetting autocommit to true on JDBC Connection [com.mysql.jdbc.JDBC4Connection@1dc696e]

DEBUG [http-8080-2] - Closing JDBC Connection [com.mysql.jdbc.JDBC4Connection@1dc696e]