<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE mapper

    PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"

    "http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<mapper namespace="Message">

  <resultMap type="com.itewo.bean.Message" id="MessageResult">

    <id column="ID" jdbcType="INTEGER" property="id"/>

    <result column="COMMAND" jdbcType="VARCHAR" property="command"/>

    <result column="DESCRIPTION" jdbcType="VARCHAR" property="description"/>

    <result column="CONTENT" jdbcType="BOOLEAN" property="content"/>

  </resultMap>

  <select id="queryMessageList"  parameterType="com.itewo.bean.Message" resultMap="MessageResult">

    select ID,COMMAND,DESCRIPTION,CONTENT from message 

    <where> 

        <if test="description != null and ''!=description ">  

           and  description like CONCAT(CONCAT('%', #{description:VARCHAR}),'%') 

        </if>  

        <if test="command != null and ''!=command ">  

           and  command = #{command:VARCHAR}

        </if>

    </where>

  </select>

</mapper>

分享sql map