全查询可以查出，条件查询不到，疑惑？？？帮忙看下哪有问题。。。

看之前有童鞋出了这问题，然后说在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]