2. mybatis mapper逆向生成代码结构以及作用1

</where>

</sql>

<sql id="Update_By_Example_Where_Clause" >

<where >

<foreach collection="example.oredCriteria" item="criteria" separator="or" >

<if test="criteria.valid" >

<trim prefix="(" suffix=")" prefixOverrides="and" >

<foreach collection="criteria.criteria" item="criterion" >

<choose >

<when test="criterion.noValue" >

and ${criterion.condition} #{criterion.value} and #{criterion.secondValue}

</when>

<when test="criterion.listValue" >

and ${criterion.condition}

<foreach collection="criterion.value" item="listItem" open="(" close=")" separator="," >

#{listItem}

</foreach>

</when>

</choose>

</foreach>

id, username, password, phone, email, created, updated

</sql>

<select id="selectByExample" resultMap="BaseResultMap" parameterType="com.taotao.pojo.TbUserExample" >

select

<if test="distinct" >

distinct

</if>

<include refid="Base_Column_List" />

<if test="_parameter != null" >

<if test="orderByClause != null" >

order by ${orderByClause}

</if>

</select>

<select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.Long" >

select

<include refid="Base_Column_List" />

from tb_user

where id = #{id,jdbcType=BIGINT}

</select>

<if test="_parameter != null" >

<include refid="Example_Where_Clause" />

</if>

</delete>

<insert id="insert" parameterType="com.taotao.pojo.TbUser" >

insert into tb_user (id, username, password,

phone, email, created,

updated)

values (#{id,jdbcType=BIGINT}, #{username,jdbcType=VARCHAR}, #{password,jdbcType=VARCHAR},

#{phone,jdbcType=VARCHAR}, #{email,jdbcType=VARCHAR}, #{created,jdbcType=TIMESTAMP},

id,

</if>

<if test="username != null" >

username,

</if>

<if test="password != null" >

password,

</if>

phone,