mybatis 学习之基础知识

一.动态sql

1. 

<select id=" " resulttype="" parameType=" ">

select * from  mmall

<where>
<if test=" ">And state = #{state} </if>,
<if test=" ">And name like #{name} </if>
<if test=" ">And </if>
</where>
或者是for
where id in
<foreach item ="item" index ="index" collection="list" open="(" sparator="," close=")"> 
#{item}
</foreach>
<select>

 2.

<sql id="userColumns"> ${alias}.id,${alias}.username,${alias}.password </sql>
<select id="selectUsers" resultType="map">
  select
    <include refid="userColumns"><property name="alias" value="t1"/></include>,
    <inclu