根据数据库的表,Mybatis逆向工程生成taotao-manager-dao和taotao-manager-pojo里需要的文件
由于互联网项目要求的效率比较高,所以电商项目的表设计常常有冗余字段(不同的表有相同的字段),因为单表查询比多表查询的效率快、性能好。
1.表
2.通过mybatis的逆向工程生成下面的东东:
TbContentCategoryMapper.java
package com.taotao.mapper; import com.taotao.pojo.TbContentCategory; import com.taotao.pojo.TbContentCategoryExample; import java.util.List; import org.apache.ibatis.annotations.Param; public interface TbContentCategoryMapper { int countByExample(TbContentCategoryExample example); int deleteByExample(TbContentCategoryExample example); int deleteByPrimaryKey(Long id); int insert(TbContentCategory record); int insertSelective(TbContentCategory record); List<TbContentCategory> selectByExample(TbContentCategoryExample example); TbContentCategory selectByPrimaryKey(Long id); int updateByExampleSelective(@Param("record") TbContentCategory record, @Param("example") TbContentCategoryExample example); int updateByExample(@Param("record") TbContentCategory record, @Param("example") TbContentCategoryExample example); int updateByPrimaryKeySelective(TbContentCategory record); int updateByPrimaryKey(TbContentCategory record); }
TbContentMapper.java
package com.taotao.mapper; import com.taotao.pojo.TbContent; import com.taotao.pojo.TbContentExample; import java.util.List; import org.apache.ibatis.annotations.Param; public interface TbContentMapper { int countByExample(TbContentExample example); int deleteByExample(TbContentExample example); int deleteByPrimaryKey(Long id); int insert(TbContent record); int insertSelective(TbContent record); List<TbContent> selectByExampleWithBLOBs(TbContentExample example); List<TbContent> selectByExample(TbContentExample example); TbContent selectByPrimaryKey(Long id); int updateByExampleSelective(@Param("record") TbContent record, @Param("example") TbContentExample example); int updateByExampleWithBLOBs(@Param("record") TbContent record, @Param("example") TbContentExample example); int updateByExample(@Param("record") TbContent record, @Param("example") TbContentExample example); int updateByPrimaryKeySelective(TbContent record); int updateByPrimaryKeyWithBLOBs(TbContent record); int updateByPrimaryKey(TbContent record); }
TbItemCatMapper.java
package com.taotao.mapper; import com.taotao.pojo.TbItemCat; import com.taotao.pojo.TbItemCatExample; import java.util.List; import org.apache.ibatis.annotations.Param; public interface TbItemCatMapper { int countByExample(TbItemCatExample example); int deleteByExample(TbItemCatExample example); int deleteByPrimaryKey(Long id); int insert(TbItemCat record); int insertSelective(TbItemCat record); List<TbItemCat> selectByExample(TbItemCatExample example); TbItemCat selectByPrimaryKey(Long id); int updateByExampleSelective(@Param("record") TbItemCat record, @Param("example") TbItemCatExample example); int updateByExample(@Param("record") TbItemCat record, @Param("example") TbItemCatExample example); int updateByPrimaryKeySelective(TbItemCat record); int updateByPrimaryKey(TbItemCat record); }
TbItemDescMapper.java
package com.taotao.mapper; import com.taotao.pojo.TbItemDesc; import com.taotao.pojo.TbItemDescExample; import java.util.List; import org.apache.ibatis.annotations.Param; public interface TbItemDescMapper { int countByExample(TbItemDescExample example); int deleteByExample(TbItemDescExample example); int deleteByPrimaryKey(Long itemId); int insert(TbItemDesc record); int insertSelective(TbItemDesc record); List<TbItemDesc> selectByExampleWithBLOBs(TbItemDescExample example); List<TbItemDesc> selectByExample(TbItemDescExample example); TbItemDesc selectByPrimaryKey(Long itemId); int updateByExampleSelective(@Param("record") TbItemDesc record, @Param("example") TbItemDescExample example); int updateByExampleWithBLOBs(@Param("record") TbItemDesc record, @Param("example") TbItemDescExample example); int updateByExample(@Param("record") TbItemDesc record, @Param("example") TbItemDescExample example); int updateByPrimaryKeySelective(TbItemDesc record); int updateByPrimaryKeyWithBLOBs(TbItemDesc record); int updateByPrimaryKey(TbItemDesc record); }
TbItemMapper.java
package com.taotao.mapper; import com.taotao.pojo.TbItem; import com.taotao.pojo.TbItemExample; import java.util.List; import org.apache.ibatis.annotations.Param; public interface TbItemMapper { int countByExample(TbItemExample example); int deleteByExample(TbItemExample example); int deleteByPrimaryKey(Long id); int insert(TbItem record); int insertSelective(TbItem record); List<TbItem> selectByExample(TbItemExample example); TbItem selectByPrimaryKey(Long id); int updateByExampleSelective(@Param("record") TbItem record, @Param("example") TbItemExample example); int updateByExample(@Param("record") TbItem record, @Param("example") TbItemExample example); int updateByPrimaryKeySelective(TbItem record); int updateByPrimaryKey(TbItem record); }
TbItemParamItemMapper.java
package com.taotao.mapper; import com.taotao.pojo.TbItemParamItem; import com.taotao.pojo.TbItemParamItemExample; import java.util.List; import org.apache.ibatis.annotations.Param; public interface TbItemParamItemMapper { int countByExample(TbItemParamItemExample example); int deleteByExample(TbItemParamItemExample example); int deleteByPrimaryKey(Long id); int insert(TbItemParamItem record); int insertSelective(TbItemParamItem record); List<TbItemParamItem> selectByExampleWithBLOBs(TbItemParamItemExample example); List<TbItemParamItem> selectByExample(TbItemParamItemExample example); TbItemParamItem selectByPrimaryKey(Long id); int updateByExampleSelective(@Param("record") TbItemParamItem record, @Param("example") TbItemParamItemExample example); int updateByExampleWithBLOBs(@Param("record") TbItemParamItem record, @Param("example") TbItemParamItemExample example); int updateByExample(@Param("record") TbItemParamItem record, @Param("example") TbItemParamItemExample example); int updateByPrimaryKeySelective(TbItemParamItem record); int updateByPrimaryKeyWithBLOBs(TbItemParamItem record); int updateByPrimaryKey(TbItemParamItem record); }
TbItemParamMapper.java
package com.taotao.mapper; import com.taotao.pojo.TbItemParam; import com.taotao.pojo.TbItemParamExample; import java.util.List; import org.apache.ibatis.annotations.Param; public interface TbItemParamMapper { int countByExample(TbItemParamExample example); int deleteByExample(TbItemParamExample example); int deleteByPrimaryKey(Long id); int insert(TbItemParam record); int insertSelective(TbItemParam record); List<TbItemParam> selectByExampleWithBLOBs(TbItemParamExample example); List<TbItemParam> selectByExample(TbItemParamExample example); TbItemParam selectByPrimaryKey(Long id); int updateByExampleSelective(@Param("record") TbItemParam record, @Param("example") TbItemParamExample example); int updateByExampleWithBLOBs(@Param("record") TbItemParam record, @Param("example") TbItemParamExample example); int updateByExample(@Param("record") TbItemParam record, @Param("example") TbItemParamExample example); int updateByPrimaryKeySelective(TbItemParam record); int updateByPrimaryKeyWithBLOBs(TbItemParam record); int updateByPrimaryKey(TbItemParam record); }
TbOrderItemMapper.java
package com.taotao.mapper; import com.taotao.pojo.TbOrderItem; import com.taotao.pojo.TbOrderItemExample; import java.util.List; import org.apache.ibatis.annotations.Param; public interface TbOrderItemMapper { int countByExample(TbOrderItemExample example); int deleteByExample(TbOrderItemExample example); int deleteByPrimaryKey(String id); int insert(TbOrderItem record); int insertSelective(TbOrderItem record); List<TbOrderItem> selectByExample(TbOrderItemExample example); TbOrderItem selectByPrimaryKey(String id); int updateByExampleSelective(@Param("record") TbOrderItem record, @Param("example") TbOrderItemExample example); int updateByExample(@Param("record") TbOrderItem record, @Param("example") TbOrderItemExample example); int updateByPrimaryKeySelective(TbOrderItem record); int updateByPrimaryKey(TbOrderItem record); }
TbOrderMapper.java
package com.taotao.mapper; import com.taotao.pojo.TbOrder; import com.taotao.pojo.TbOrderExample; import java.util.List; import org.apache.ibatis.annotations.Param; public interface TbOrderMapper { int countByExample(TbOrderExample example); int deleteByExample(TbOrderExample example); int deleteByPrimaryKey(String orderId); int insert(TbOrder record); int insertSelective(TbOrder record); List<TbOrder> selectByExample(TbOrderExample example); TbOrder selectByPrimaryKey(String orderId); int updateByExampleSelective(@Param("record") TbOrder record, @Param("example") TbOrderExample example); int updateByExample(@Param("record") TbOrder record, @Param("example") TbOrderExample example); int updateByPrimaryKeySelective(TbOrder record); int updateByPrimaryKey(TbOrder record); }
TbOrderShippingMapper.java
package com.taotao.mapper; import com.taotao.pojo.TbOrderShipping; import com.taotao.pojo.TbOrderShippingExample; import java.util.List; import org.apache.ibatis.annotations.Param; public interface TbOrderShippingMapper { int countByExample(TbOrderShippingExample example); int deleteByExample(TbOrderShippingExample example); int deleteByPrimaryKey(String orderId); int insert(TbOrderShipping record); int insertSelective(TbOrderShipping record); List<TbOrderShipping> selectByExample(TbOrderShippingExample example); TbOrderShipping selectByPrimaryKey(String orderId); int updateByExampleSelective(@Param("record") TbOrderShipping record, @Param("example") TbOrderShippingExample example); int updateByExample(@Param("record") TbOrderShipping record, @Param("example") TbOrderShippingExample example); int updateByPrimaryKeySelective(TbOrderShipping record); int updateByPrimaryKey(TbOrderShipping record); }
TbUserMapper.java
package com.taotao.mapper; import com.taotao.pojo.TbUser; import com.taotao.pojo.TbUserExample; import java.util.List; import org.apache.ibatis.annotations.Param; public interface TbUserMapper { int countByExample(TbUserExample example); int deleteByExample(TbUserExample example); int deleteByPrimaryKey(Long id); int insert(TbUser record); int insertSelective(TbUser record); List<TbUser> selectByExample(TbUserExample example); TbUser selectByPrimaryKey(Long id); int updateByExampleSelective(@Param("record") TbUser record, @Param("example") TbUserExample example); int updateByExample(@Param("record") TbUser record, @Param("example") TbUserExample example); int updateByPrimaryKeySelective(TbUser record); int updateByPrimaryKey(TbUser record); }
TestMapper.java
package com.taotao.mapper; /** * 测试接口,查询当前的时间 */ public interface TestMapper { public String queryNow(); }
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
TbContentCategoryMapper.xml
<?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="com.taotao.mapper.TbContentCategoryMapper" > <resultMap id="BaseResultMap" type="com.taotao.pojo.TbContentCategory" > <id column="id" property="id" jdbcType="BIGINT" /> <result column="parent_id" property="parentId" jdbcType="BIGINT" /> <result column="name" property="name" jdbcType="VARCHAR" /> <result column="status" property="status" jdbcType="INTEGER" /> <result column="sort_order" property="sortOrder" jdbcType="INTEGER" /> <result column="is_parent" property="isParent" jdbcType="BIT" /> <result column="created" property="created" jdbcType="TIMESTAMP" /> <result column="updated" property="updated" jdbcType="TIMESTAMP" /> </resultMap> <sql id="Example_Where_Clause" > <where > <foreach collection="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} </when> <when test="criterion.singleValue" > and ${criterion.condition} #{criterion.value} </when> <when test="criterion.betweenValue" > 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> </trim> </if> </foreach> </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} </when> <when test="criterion.singleValue" > and ${criterion.condition} #{criterion.value} </when> <when test="criterion.betweenValue" > 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> </trim> </if> </foreach> </where> </sql> <sql id="Base_Column_List" > id, parent_id, name, status, sort_order, is_parent, created, updated </sql> <select id="selectByExample" resultMap="BaseResultMap" parameterType="com.taotao.pojo.TbContentCategoryExample" > select <if test="distinct" > distinct </if> <include refid="Base_Column_List" /> from tb_content_category <if test="_parameter != null" > <include refid="Example_Where_Clause" /> </if> <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_content_category where id = #{id,jdbcType=BIGINT} </select> <delete id="deleteByPrimaryKey" parameterType="java.lang.Long" > delete from tb_content_category where id = #{id,jdbcType=BIGINT} </delete> <delete id="deleteByExample" parameterType="com.taotao.pojo.TbContentCategoryExample" > delete from tb_content_category <if test="_parameter != null" > <include refid="Example_Where_Clause" /> </if> </delete> <insert id="insert" parameterType="com.taotao.pojo.TbContentCategory" > insert into tb_content_category (id, parent_id, name, status, sort_order, is_parent, created, updated) values (#{id,jdbcType=BIGINT}, #{parentId,jdbcType=BIGINT}, #{name,jdbcType=VARCHAR}, #{status,jdbcType=INTEGER}, #{sortOrder,jdbcType=INTEGER}, #{isParent,jdbcType=BIT}, #{created,jdbcType=TIMESTAMP}, #{updated,jdbcType=TIMESTAMP}) </insert> <insert id="insertSelective" parameterType="com.taotao.pojo.TbContentCategory" > insert into tb_content_category <trim prefix="(" suffix=")" suffixOverrides="," > <if test="id != null" > id, </if> <if test="parentId != null" > parent_id, </if> <if test="name != null" > name, </if> <if test="status != null" > status, </if> <if test="sortOrder != null" > sort_order, </if> <if test="isParent != null" > is_parent, </if> <if test="created != null" > created, </if> <if test="updated != null" > updated, </if> </trim> <trim prefix="values (" suffix=")" suffixOverrides="," > <if test="id != null" > #{id,jdbcType=BIGINT}, </if> <if test="parentId != null" > #{parentId,jdbcType=BIGINT}, </if> <if test="name != null" > #{name,jdbcType=VARCHAR}, </if> <if test="status != null" > #{status,jdbcType=INTEGER}, </if> <if test="sortOrder != null" > #{sortOrder,jdbcType=INTEGER}, </if> <if test="isParent != null" > #{isParent,jdbcType=BIT}, </if> <if test="created != null" > #{created,jdbcType=TIMESTAMP}, </if> <if test="updated != null" > #{updated,jdbcType=TIMESTAMP}, </if> </trim> </insert> <select id="countByExample" parameterType="com.taotao.pojo.TbContentCategoryExample" resultType="java.lang.Integer" > select count(*) from tb_content_category <if test="_parameter != null" > <include refid="Example_Where_Clause" /> </if> </select> <update id="updateByExampleSelective" parameterType="map" > update tb_content_category <set > <if test="record.id != null" > id = #{record.id,jdbcType=BIGINT}, </if> <if test="record.parentId != null" > parent_id = #{record.parentId,jdbcType=BIGINT}, </if> <if test="record.name != null" > name = #{record.name,jdbcType=VARCHAR}, </if> <if test="record.status != null" > status = #{record.status,jdbcType=INTEGER}, </if> <if test="record.sortOrder != null" > sort_order = #{record.sortOrder,jdbcType=INTEGER}, </if> <if test="record.isParent != null" > is_parent = #{record.isParent,jdbcType=BIT}, </if> <if test="record.created != null" > created = #{record.created,jdbcType=TIMESTAMP}, </if> <if test="record.updated != null" > updated = #{record.updated,jdbcType=TIMESTAMP}, </if> </set> <if test="_parameter != null" > <include refid="Update_By_Example_Where_Clause" /> </if> </update> <update id="updateByExample" parameterType="map" > update tb_content_category set id = #{record.id,jdbcType=BIGINT}, parent_id = #{record.parentId,jdbcType=BIGINT}, name = #{record.name,jdbcType=VARCHAR}, status = #{record.status,jdbcType=INTEGER}, sort_order = #{record.sortOrder,jdbcType=INTEGER}, is_parent = #{record.isParent,jdbcType=BIT}, created = #{record.created,jdbcType=TIMESTAMP}, updated = #{record.updated,jdbcType=TIMESTAMP} <if test="_parameter != null" > <include refid="Update_By_Example_Where_Clause" /> </if> </update> <update id="updateByPrimaryKeySelective" parameterType="com.taotao.pojo.TbContentCategory" > update tb_content_category <set > <if test="parentId != null" > parent_id = #{parentId,jdbcType=BIGINT}, </if> <if test="name != null" > name = #{name,jdbcType=VARCHAR}, </if> <if test="status != null" > status = #{status,jdbcType=INTEGER}, </if> <if test="sortOrder != null" > sort_order = #{sortOrder,jdbcType=INTEGER}, </if> <if test="isParent != null" > is_parent = #{isParent,jdbcType=BIT}, </if> <if test="created != null" > created = #{created,jdbcType=TIMESTAMP}, </if> <if test="updated != null" > updated = #{updated,jdbcType=TIMESTAMP}, </if> </set> where id = #{id,jdbcType=BIGINT} </update> <update id="updateByPrimaryKey" parameterType="com.taotao.pojo.TbContentCategory" > update tb_content_category set parent_id = #{parentId,jdbcType=BIGINT}, name = #{name,jdbcType=VARCHAR}, status = #{status,jdbcType=INTEGER}, sort_order = #{sortOrder,jdbcType=INTEGER}, is_parent = #{isParent,jdbcType=BIT}, created = #{created,jdbcType=TIMESTAMP}, updated = #{updated,jdbcType=TIMESTAMP} where id = #{id,jdbcType=BIGINT} </update> </mapper>
TbContentMapper.xml
<?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="com.taotao.mapper.TbContentMapper" > <resultMap id="BaseResultMap" type="com.taotao.pojo.TbContent" > <id column="id" property="id" jdbcType="BIGINT" /> <result column="category_id" property="categoryId" jdbcType="BIGINT" /> <result column="title" property="title" jdbcType="VARCHAR" /> <result column="sub_title" property="subTitle" jdbcType="VARCHAR" /> <result column="title_desc" property="titleDesc" jdbcType="VARCHAR" /> <result column="url" property="url" jdbcType="VARCHAR" /> <result column="pic" property="pic" jdbcType="VARCHAR" /> <result column="pic2" property="pic2" jdbcType="VARCHAR" /> <result column="created" property="created" jdbcType="TIMESTAMP" /> <result column="updated" property="updated" jdbcType="TIMESTAMP" /> </resultMap> <resultMap id="ResultMapWithBLOBs" type="com.taotao.pojo.TbContent" extends="BaseResultMap" > <result column="content" property="content" jdbcType="LONGVARCHAR" /> </resultMap> <sql id="Example_Where_Clause" > <where > <foreach collection="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} </when> <when test="criterion.singleValue" > and ${criterion.condition} #{criterion.value} </when> <when test="criterion.betweenValue" > 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> </trim> </if> </foreach> </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} </when> <when test="criterion.singleValue" > and ${criterion.condition} #{criterion.value} </when> <when test="criterion.betweenValue" > 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> </trim> </if> </foreach> </where> </sql> <sql id="Base_Column_List" > id, category_id, title, sub_title, title_desc, url, pic, pic2, created, updated </sql> <sql id="Blob_Column_List" > content </sql> <select id="selectByExampleWithBLOBs" resultMap="ResultMapWithBLOBs" parameterType="com.taotao.pojo.TbContentExample" > select <if test="distinct" > distinct </if> <include refid="Base_Column_List" /> , <include refid="Blob_Column_List" /> from tb_content <if test="_parameter != null" > <include refid="Example_Where_Clause" /> </if> <if test="orderByClause != null" > order by ${orderByClause} </if> </select> <select id="selectByExample" resultMap="BaseResultMap" parameterType="com.taotao.pojo.TbContentExample" > select <if test="distinct" > distinct </if> <include refid="Base_Column_List" /> from tb_content <if test="_parameter != null" > <include refid="Example_Where_Clause" /> </if> <if test="orderByClause != null" > order by ${orderByClause} </if> </select> <select id="selectByPrimaryKey" resultMap="ResultMapWithBLOBs" parameterType="java.lang.Long" > select <include refid="Base_Column_List" /> , <include refid="Blob_Column_List" /> from tb_content where id = #{id,jdbcType=BIGINT} </select> <delete id="deleteByPrimaryKey" parameterType="java.lang.Long" > delete from tb_content where id = #{id,jdbcType=BIGINT} </delete> <delete id="deleteByExample" parameterType="com.taotao.pojo.TbContentExample" > delete from tb_content <if test="_parameter != null" > <include refid="Example_Where_Clause" /> </if> </delete> <insert id="insert" parameterType="com.taotao.pojo.TbContent" > insert into tb_content (id, category_id, title, sub_title, title_desc, url, pic, pic2, created, updated, content) values (#{id,jdbcType=BIGINT}, #{categoryId,jdbcType=BIGINT}, #{title,jdbcType=VARCHAR}, #{subTitle,jdbcType=VARCHAR}, #{titleDesc,jdbcType=VARCHAR}, #{url,jdbcType=VARCHAR}, #{pic,jdbcType=VARCHAR}, #{pic2,jdbcType=VARCHAR}, #{created,jdbcType=TIMESTAMP}, #{updated,jdbcType=TIMESTAMP}, #{content,jdbcType=LONGVARCHAR}) </insert> <insert id="insertSelective" parameterType="com.taotao.pojo.TbContent" > insert into tb_content <trim prefix="(" suffix=")" suffixOverrides="," > <if test="id != null" > id, </if> <if test="categoryId != null" > category_id, </if> <if test="title != null" > title, </if> <if test="subTitle != null" > sub_title, </if> <if test="titleDesc != null" > title_desc, </if> <if test="url != null" > url, </if> <if test="pic != null" > pic, </if> <if test="pic2 != null" > pic2, </if> <if test="created != null" > created, </if> <if test="updated != null" > updated, </if> <if test="content != null" > content, </if> </trim> <trim prefix="values (" suffix=")" suffixOverrides="," > <if test="id != null" > #{id,jdbcType=BIGINT}, </if> <if test="categoryId != null" > #{categoryId,jdbcType=BIGINT}, </if> <if test="title != null" > #{title,jdbcType=VARCHAR}, </if> <if test="subTitle != null" > #{subTitle,jdbcType=VARCHAR}, </if> <if test="titleDesc != null" > #{titleDesc,jdbcType=VARCHAR}, </if> <if test="url != null" > #{url,jdbcType=VARCHAR}, </if> <if test="pic != null" > #{pic,jdbcType=VARCHAR}, </if> <if test="pic2 != null" > #{pic2,jdbcType=VARCHAR}, </if> <if test="created != null" > #{created,jdbcType=TIMESTAMP}, </if> <if test="updated != null" > #{updated,jdbcType=TIMESTAMP}, </if> <if test="content != null" > #{content,jdbcType=LONGVARCHAR}, </if> </trim> </insert> <select id="countByExample" parameterType="com.taotao.pojo.TbContentExample" resultType="java.lang.Integer" > select count(*) from tb_content <if test="_parameter != null" > <include refid="Example_Where_Clause" /> </if> </select> <update id="updateByExampleSelective" parameterType="map" > update tb_content <set > <if test="record.id != null" > id = #{record.id,jdbcType=BIGINT}, </if> <if test="record.categoryId != null" > category_id = #{record.categoryId,jdbcType=BIGINT}, </if> <if test="record.title != null" > title = #{record.title,jdbcType=VARCHAR}, </if> <if test="record.subTitle != null" > sub_title = #{record.subTitle,jdbcType=VARCHAR}, </if> <if test="record.titleDesc != null" > title_desc = #{record.titleDesc,jdbcType=VARCHAR}, </if> <if test="record.url != null" > url = #{record.url,jdbcType=VARCHAR}, </if> <if test="record.pic != null" > pic = #{record.pic,jdbcType=VARCHAR}, </if> <if test="record.pic2 != null" > pic2 = #{record.pic2,jdbcType=VARCHAR}, </if> <if test="record.created != null" > created = #{record.created,jdbcType=TIMESTAMP}, </if> <if test="record.updated != null" > updated = #{record.updated,jdbcType=TIMESTAMP}, </if> <if test="record.content != null" > content = #{record.content,jdbcType=LONGVARCHAR}, </if> </set> <if test="_parameter != null" > <include refid="Update_By_Example_Where_Clause" /> </if> </update> <update id="updateByExampleWithBLOBs" parameterType="map" > update tb_content set id = #{record.id,jdbcType=BIGINT}, category_id = #{record.categoryId,jdbcType=BIGINT}, title = #{record.title,jdbcType=VARCHAR}, sub_title = #{record.subTitle,jdbcType=VARCHAR}, title_desc = #{record.titleDesc,jdbcType=VARCHAR}, url = #{record.url,jdbcType=VARCHAR}, pic = #{record.pic,jdbcType=VARCHAR}, pic2 = #{record.pic2,jdbcType=VARCHAR}, created = #{record.created,jdbcType=TIMESTAMP}, updated = #{record.updated,jdbcType=TIMESTAMP}, content = #{record.content,jdbcType=LONGVARCHAR} <if test="_parameter != null" > <include refid="Update_By_Example_Where_Clause" /> </if> </update> <update id="updateByExample" parameterType="map" > update tb_content set id = #{record.id,jdbcType=BIGINT}, category_id = #{record.categoryId,jdbcType=BIGINT}, title = #{record.title,jdbcType=VARCHAR}, sub_title = #{record.subTitle,jdbcType=VARCHAR}, title_desc = #{record.titleDesc,jdbcType=VARCHAR}, url = #{record.url,jdbcType=VARCHAR}, pic = #{record.pic,jdbcType=VARCHAR}, pic2 = #{record.pic2,jdbcType=VARCHAR}, created = #{record.created,jdbcType=TIMESTAMP}, updated = #{record.updated,jdbcType=TIMESTAMP} <if test="_parameter != null" > <include refid="Update_By_Example_Where_Clause" /> </if> </update> <update id="updateByPrimaryKeySelective" parameterType="com.taotao.pojo.TbContent" > update tb_content <set > <if test="categoryId != null" > category_id = #{categoryId,jdbcType=BIGINT}, </if> <if test="title != null" > title = #{title,jdbcType=VARCHAR}, </if> <if test="subTitle != null" > sub_title = #{subTitle,jdbcType=VARCHAR}, </if> <if test="titleDesc != null" > title_desc = #{titleDesc,jdbcType=VARCHAR}, </if> <if test="url != null" > url = #{url,jdbcType=VARCHAR}, </if> <if test="pic != null" > pic = #{pic,jdbcType=VARCHAR}, </if> <if test="pic2 != null" > pic2 = #{pic2,jdbcType=VARCHAR}, </if> <if test="created != null" > created = #{created,jdbcType=TIMESTAMP}, </if> <if test="updated != null" > updated = #{updated,jdbcType=TIMESTAMP}, </if> <if test="content != null" > content = #{content,jdbcType=LONGVARCHAR}, </if> </set> where id = #{id,jdbcType=BIGINT} </update> <update id="updateByPrimaryKeyWithBLOBs" parameterType="com.taotao.pojo.TbContent" > update tb_content set category_id = #{categoryId,jdbcType=BIGINT}, title = #{title,jdbcType=VARCHAR}, sub_title = #{subTitle,jdbcType=VARCHAR}, title_desc = #{titleDesc,jdbcType=VARCHAR}, url = #{url,jdbcType=VARCHAR}, pic = #{pic,jdbcType=VARCHAR}, pic2 = #{pic2,jdbcType=VARCHAR}, created = #{created,jdbcType=TIMESTAMP}, updated = #{updated,jdbcType=TIMESTAMP}, content = #{content,jdbcType=LONGVARCHAR} where id = #{id,jdbcType=BIGINT} </update> <update id="updateByPrimaryKey" parameterType="com.taotao.pojo.TbContent" > update tb_content set category_id = #{categoryId,jdbcType=BIGINT}, title = #{title,jdbcType=VARCHAR}, sub_title = #{subTitle,jdbcType=VARCHAR}, title_desc = #{titleDesc,jdbcType=VARCHAR}, url = #{url,jdbcType=VARCHAR}, pic = #{pic,jdbcType=VARCHAR}, pic2 = #{pic2,jdbcType=VARCHAR}, created = #{created,jdbcType=TIMESTAMP}, updated = #{updated,jdbcType=TIMESTAMP} where id = #{id,jdbcType=BIGINT} </update> </mapper>
TbItemCatMapper.xml
<?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="com.taotao.mapper.TbItemCatMapper" > <resultMap id="BaseResultMap" type="com.taotao.pojo.TbItemCat" > <id column="id" property="id" jdbcType="BIGINT" /> <result column="parent_id" property="parentId" jdbcType="BIGINT" /> <result column="name" property="name" jdbcType="VARCHAR" /> <result column="status" property="status" jdbcType="INTEGER" /> <result column="sort_order" property="sortOrder" jdbcType="INTEGER" /> <result column="is_parent" property="isParent" jdbcType="BIT" /> <result column="created" property="created" jdbcType="TIMESTAMP" /> <result column="updated" property="updated" jdbcType="TIMESTAMP" /> </resultMap> <sql id="Example_Where_Clause" > <where > <foreach collection="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} </when> <when test="criterion.singleValue" > and ${criterion.condition} #{criterion.value} </when> <when test="criterion.betweenValue" > 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> </trim> </if> </foreach> </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} </when> <when test="criterion.singleValue" > and ${criterion.condition} #{criterion.value} </when> <when test="criterion.betweenValue" > 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> </trim> </if> </foreach> </where> </sql> <sql id="Base_Column_List" > id, parent_id, name, status, sort_order, is_parent, created, updated </sql> <select id="selectByExample" resultMap="BaseResultMap" parameterType="com.taotao.pojo.TbItemCatExample" > select <if test="distinct" > distinct </if> <include refid="Base_Column_List" /> from tb_item_cat <if test="_parameter != null" > <include refid="Example_Where_Clause" /> </if> <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_item_cat where id = #{id,jdbcType=BIGINT} </select> <delete id="deleteByPrimaryKey" parameterType="java.lang.Long" > delete from tb_item_cat where id = #{id,jdbcType=BIGINT} </delete> <delete id="deleteByExample" parameterType="com.taotao.pojo.TbItemCatExample" > delete from tb_item_cat <if test="_parameter != null" > <include refid="Example_Where_Clause" /> </if> </delete> <insert id="insert" parameterType="com.taotao.pojo.TbItemCat" > insert into tb_item_cat (id, parent_id, name, status, sort_order, is_parent, created, updated) values (#{id,jdbcType=BIGINT}, #{parentId,jdbcType=BIGINT}, #{name,jdbcType=VARCHAR}, #{status,jdbcType=INTEGER}, #{sortOrder,jdbcType=INTEGER}, #{isParent,jdbcType=BIT}, #{created,jdbcType=TIMESTAMP}, #{updated,jdbcType=TIMESTAMP}) </insert> <insert id="insertSelective" parameterType="com.taotao.pojo.TbItemCat" > insert into tb_item_cat <trim prefix="(" suffix=")" suffixOverrides="," > <if test="id != null" > id, </if> <if test="parentId != null" > parent_id, </if> <if test="name != null" > name, </if> <if test="status != null" > status, </if> <if test="sortOrder != null" > sort_order, </if> <if test="isParent != null" > is_parent, </if> <if test="created != null" > created, </if> <if test="updated != null" > updated, </if> </trim> <trim prefix="values (" suffix=")" suffixOverrides="," > <if test="id != null" > #{id,jdbcType=BIGINT}, </if> <if test="parentId != null" > #{parentId,jdbcType=BIGINT}, </if> <if test="name != null" > #{name,jdbcType=VARCHAR}, </if> <if test="status != null" > #{status,jdbcType=INTEGER}, </if> <if test="sortOrder != null" > #{sortOrder,jdbcType=INTEGER}, </if> <if test="isParent != null" > #{isParent,jdbcType=BIT}, </if> <if test="created != null" > #{created,jdbcType=TIMESTAMP}, </if> <if test="updated != null" > #{updated,jdbcType=TIMESTAMP}, </if> </trim> </insert> <select id="countByExample" parameterType="com.taotao.pojo.TbItemCatExample" resultType="java.lang.Integer" > select count(*) from tb_item_cat <if test="_parameter != null" > <include refid="Example_Where_Clause" /> </if> </select> <update id="updateByExampleSelective" parameterType="map" > update tb_item_cat <set > <if test="record.id != null" > id = #{record.id,jdbcType=BIGINT}, </if> <if test="record.parentId != null" > parent_id = #{record.parentId,jdbcType=BIGINT}, </if> <if test="record.name != null" > name = #{record.name,jdbcType=VARCHAR}, </if> <if test="record.status != null" > status = #{record.status,jdbcType=INTEGER}, </if> <if test="record.sortOrder != null" > sort_order = #{record.sortOrder,jdbcType=INTEGER}, </if> <if test="record.isParent != null" > is_parent = #{record.isParent,jdbcType=BIT}, </if> <if test="record.created != null" > created = #{record.created,jdbcType=TIMESTAMP}, </if> <if test="record.updated != null" > updated = #{record.updated,jdbcType=TIMESTAMP}, </if> </set> <if test="_parameter != null" > <include refid="Update_By_Example_Where_Clause" /> </if> </update> <update id="updateByExample" parameterType="map" > update tb_item_cat set id = #{record.id,jdbcType=BIGINT}, parent_id = #{record.parentId,jdbcType=BIGINT}, name = #{record.name,jdbcType=VARCHAR}, status = #{record.status,jdbcType=INTEGER}, sort_order = #{record.sortOrder,jdbcType=INTEGER}, is_parent = #{record.isParent,jdbcType=BIT}, created = #{record.created,jdbcType=TIMESTAMP}, updated = #{record.updated,jdbcType=TIMESTAMP} <if test="_parameter != null" > <include refid="Update_By_Example_Where_Clause" /> </if> </update> <update id="updateByPrimaryKeySelective" parameterType="com.taotao.pojo.TbItemCat" > update tb_item_cat <set > <if test="parentId != null" > parent_id = #{parentId,jdbcType=BIGINT}, </if> <if test="name != null" > name = #{name,jdbcType=VARCHAR}, </if> <if test="status != null" > status = #{status,jdbcType=INTEGER}, </if> <if test="sortOrder != null" > sort_order = #{sortOrder,jdbcType=INTEGER}, </if> <if test="isParent != null" > is_parent = #{isParent,jdbcType=BIT}, </if> <if test="created != null" > created = #{created,jdbcType=TIMESTAMP}, </if> <if test="updated != null" > updated = #{updated,jdbcType=TIMESTAMP}, </if> </set> where id = #{id,jdbcType=BIGINT} </update> <update id="updateByPrimaryKey" parameterType="com.taotao.pojo.TbItemCat" > update tb_item_cat set parent_id = #{parentId,jdbcType=BIGINT}, name = #{name,jdbcType=VARCHAR}, status = #{status,jdbcType=INTEGER}, sort_order = #{sortOrder,jdbcType=INTEGER}, is_parent = #{isParent,jdbcType=BIT}, created = #{created,jdbcType=TIMESTAMP}, updated = #{updated,jdbcType=TIMESTAMP} where id = #{id,jdbcType=BIGINT} </update> </mapper>
TbItemDescMapper.xml
<?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="com.taotao.mapper.TbItemDescMapper" > <resultMap id="BaseResultMap" type="com.taotao.pojo.TbItemDesc" > <id column="item_id" property="itemId" jdbcType="BIGINT" /> <result column="created" property="created" jdbcType="TIMESTAMP" /> <result column="updated" property="updated" jdbcType="TIMESTAMP" /> </resultMap> <resultMap id="ResultMapWithBLOBs" type="com.taotao.pojo.TbItemDesc" extends="BaseResultMap" > <result column="item_desc" property="itemDesc" jdbcType="LONGVARCHAR" /> </resultMap> <sql id="Example_Where_Clause" > <where > <foreach collection="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} </when> <when test="criterion.singleValue" > and ${criterion.condition} #{criterion.value} </when> <when test="criterion.betweenValue" > 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> </trim> </if> </foreach> </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} </when> <when test="criterion.singleValue" > and ${criterion.condition} #{criterion.value} </when> <when test="criterion.betweenValue" > 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> </trim> </if> </foreach> </where> </sql> <sql id="Base_Column_List" > item_id, created, updated </sql> <sql id="Blob_Column_List" > item_desc </sql> <select id="selectByExampleWithBLOBs" resultMap="ResultMapWithBLOBs" parameterType="com.taotao.pojo.TbItemDescExample" > select <if test="distinct" > distinct </if> <include refid="Base_Column_List" /> , <include refid="Blob_Column_List" /> from tb_item_desc <if test="_parameter != null" > <include refid="Example_Where_Clause" /> </if> <if test="orderByClause != null" > order by ${orderByClause} </if> </select> <select id="selectByExample" resultMap="BaseResultMap" parameterType="com.taotao.pojo.TbItemDescExample" > select <if test="distinct" > distinct </if> <include refid="Base_Column_List" /> from tb_item_desc <if test="_parameter != null" > <include refid="Example_Where_Clause" /> </if> <if test="orderByClause != null" > order by ${orderByClause} </if> </select> <select id="selectByPrimaryKey" resultMap="ResultMapWithBLOBs" parameterType="java.lang.Long" > select <include refid="Base_Column_List" /> , <include refid="Blob_Column_List" /> from tb_item_desc where item_id = #{itemId,jdbcType=BIGINT} </select> <delete id="deleteByPrimaryKey" parameterType="java.lang.Long" > delete from tb_item_desc where item_id = #{itemId,jdbcType=BIGINT} </delete> <delete id="deleteByExample" parameterType="com.taotao.pojo.TbItemDescExample" > delete from tb_item_desc <if test="_parameter != null" > <include refid="Example_Where_Clause" /> </if> </delete> <insert id="insert" parameterType="com.taotao.pojo.TbItemDesc" > insert into tb_item_desc (item_id, created, updated, item_desc) values (#{itemId,jdbcType=BIGINT}, #{created,jdbcType=TIMESTAMP}, #{updated,jdbcType=TIMESTAMP}, #{itemDesc,jdbcType=LONGVARCHAR}) </insert> <insert id="insertSelective" parameterType="com.taotao.pojo.TbItemDesc" > insert into tb_item_desc <trim prefix="(" suffix=")" suffixOverrides="," > <if test="itemId != null" > item_id, </if> <if test="created != null" > created, </if> <if test="updated != null" > updated, </if> <if test="itemDesc != null" > item_desc, </if> </trim> <trim prefix="values (" suffix=")" suffixOverrides="," > <if test="itemId != null" > #{itemId,jdbcType=BIGINT}, </if> <if test="created != null" > #{created,jdbcType=TIMESTAMP}, </if> <if test="updated != null" > #{updated,jdbcType=TIMESTAMP}, </if> <if test="itemDesc != null" > #{itemDesc,jdbcType=LONGVARCHAR}, </if> </trim> </insert> <select id="countByExample" parameterType="com.taotao.pojo.TbItemDescExample" resultType="java.lang.Integer" > select count(*) from tb_item_desc <if test="_parameter != null" > <include refid="Example_Where_Clause" /> </if> </select> <update id="updateByExampleSelective" parameterType="map" > update tb_item_desc <set > <if test="record.itemId != null" > item_id = #{record.itemId,jdbcType=BIGINT}, </if> <if test="record.created != null" > created = #{record.created,jdbcType=TIMESTAMP}, </if> <if test="record.updated != null" > updated = #{record.updated,jdbcType=TIMESTAMP}, </if> <if test="record.itemDesc != null" > item_desc = #{record.itemDesc,jdbcType=LONGVARCHAR}, </if> </set> <if test="_parameter != null" > <include refid="Update_By_Example_Where_Clause" /> </if> </update> <update id="updateByExampleWithBLOBs" parameterType="map" > update tb_item_desc set item_id = #{record.itemId,jdbcType=BIGINT}, created = #{record.created,jdbcType=TIMESTAMP}, updated = #{record.updated,jdbcType=TIMESTAMP}, item_desc = #{record.itemDesc,jdbcType=LONGVARCHAR} <if test="_parameter != null" > <include refid="Update_By_Example_Where_Clause" /> </if> </update> <update id="updateByExample" parameterType="map" > update tb_item_desc set item_id = #{record.itemId,jdbcType=BIGINT}, created = #{record.created,jdbcType=TIMESTAMP}, updated = #{record.updated,jdbcType=TIMESTAMP} <if test="_parameter != null" > <include refid="Update_By_Example_Where_Clause" /> </if> </update> <update id="updateByPrimaryKeySelective" parameterType="com.taotao.pojo.TbItemDesc" > update tb_item_desc <set > <if test="created != null" > created = #{created,jdbcType=TIMESTAMP}, </if> <if test="updated != null" > updated = #{updated,jdbcType=TIMESTAMP}, </if> <if test="itemDesc != null" > item_desc = #{itemDesc,jdbcType=LONGVARCHAR}, </if> </set> where item_id = #{itemId,jdbcType=BIGINT} </update> <update id="updateByPrimaryKeyWithBLOBs" parameterType="com.taotao.pojo.TbItemDesc" > update tb_item_desc set created = #{created,jdbcType=TIMESTAMP}, updated = #{updated,jdbcType=TIMESTAMP}, item_desc = #{itemDesc,jdbcType=LONGVARCHAR} where item_id = #{itemId,jdbcType=BIGINT} </update> <update id="updateByPrimaryKey" parameterType="com.taotao.pojo.TbItemDesc" > update tb_item_desc set created = #{created,jdbcType=TIMESTAMP}, updated = #{updated,jdbcType=TIMESTAMP} where item_id = #{itemId,jdbcType=BIGINT} </update> </mapper>
TbItemMapper.xml
<?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="com.taotao.mapper.TbItemMapper" > <resultMap id="BaseResultMap" type="com.taotao.pojo.TbItem" > <id column="id" property="id" jdbcType="BIGINT" /> <result column="title" property="title" jdbcType="VARCHAR" /> <result column="sell_point" property="sellPoint" jdbcType="VARCHAR" /> <result column="price" property="price" jdbcType="BIGINT" /> <result column="num" property="num" jdbcType="INTEGER" /> <result column="barcode" property="barcode" jdbcType="VARCHAR" /> <result column="image" property="image" jdbcType="VARCHAR" /> <result column="cid" property="cid" jdbcType="BIGINT" /> <result column="status" property="status" jdbcType="TINYINT" /> <result column="created" property="created" jdbcType="TIMESTAMP" /> <result column="updated" property="updated" jdbcType="TIMESTAMP" /> </resultMap> <sql id="Example_Where_Clause" > <where > <foreach collection="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} </when> <when test="criterion.singleValue" > and ${criterion.condition} #{criterion.value} </when> <when test="criterion.betweenValue" > 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> </trim> </if> </foreach> </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} </when> <when test="criterion.singleValue" > and ${criterion.condition} #{criterion.value} </when> <when test="criterion.betweenValue" > 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> </trim> </if> </foreach> </where> </sql> <sql id="Base_Column_List" > id, title, sell_point, price, num, barcode, image, cid, status, created, updated </sql> <select id="selectByExample" resultMap="BaseResultMap" parameterType="com.taotao.pojo.TbItemExample" > select <if test="distinct" > distinct </if> <include refid="Base_Column_List" /> from tb_item <if test="_parameter != null" > <include refid="Example_Where_Clause" /> </if> <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_item where id = #{id,jdbcType=BIGINT} </select> <delete id="deleteByPrimaryKey" parameterType="java.lang.Long" > delete from tb_item where id = #{id,jdbcType=BIGINT} </delete> <delete id="deleteByExample" parameterType="com.taotao.pojo.TbItemExample" > delete from tb_item <if test="_parameter != null" > <include refid="Example_Where_Clause" /> </if> </delete> <insert id="insert" parameterType="com.taotao.pojo.TbItem" > insert into tb_item (id, title, sell_point, price, num, barcode, image, cid, status, created, updated) values (#{id,jdbcType=BIGINT}, #{title,jdbcType=VARCHAR}, #{sellPoint,jdbcType=VARCHAR}, #{price,jdbcType=BIGINT}, #{num,jdbcType=INTEGER}, #{barcode,jdbcType=VARCHAR}, #{image,jdbcType=VARCHAR}, #{cid,jdbcType=BIGINT}, #{status,jdbcType=TINYINT}, #{created,jdbcType=TIMESTAMP}, #{updated,jdbcType=TIMESTAMP}) </insert> <insert id="insertSelective" parameterType="com.taotao.pojo.TbItem" > insert into tb_item <trim prefix="(" suffix=")" suffixOverrides="," > <if test="id != null" > id, </if> <if test="title != null" > title, </if> <if test="sellPoint != null" > sell_point, </if> <if test="price != null" > price, </if> <if test="num != null" > num, </if> <if test="barcode != null" > barcode, </if> <if test="image != null" > image, </if> <if test="cid != null" > cid, </if> <if test="status != null" > status, </if> <if test="created != null" > created, </if> <if test="updated != null" > updated, </if> </trim> <trim prefix="values (" suffix=")" suffixOverrides="," > <if test="id != null" > #{id,jdbcType=BIGINT}, </if> <if test="title != null" > #{title,jdbcType=VARCHAR}, </if> <if test="sellPoint != null" > #{sellPoint,jdbcType=VARCHAR}, </if> <if test="price != null" > #{price,jdbcType=BIGINT}, </if> <if test="num != null" > #{num,jdbcType=INTEGER}, </if> <if test="barcode != null" > #{barcode,jdbcType=VARCHAR}, </if> <if test="image != null" > #{image,jdbcType=VARCHAR}, </if> <if test="cid != null" > #{cid,jdbcType=BIGINT}, </if> <if test="status != null" > #{status,jdbcType=TINYINT}, </if> <if test="created != null" > #{created,jdbcType=TIMESTAMP}, </if> <if test="updated != null" > #{updated,jdbcType=TIMESTAMP}, </if> </trim> </insert> <select id="countByExample" parameterType="com.taotao.pojo.TbItemExample" resultType="java.lang.Integer" > select count(*) from tb_item <if test="_parameter != null" > <include refid="Example_Where_Clause" /> </if> </select> <update id="updateByExampleSelective" parameterType="map" > update tb_item <set > <if test="record.id != null" > id = #{record.id,jdbcType=BIGINT}, </if> <if test="record.title != null" > title = #{record.title,jdbcType=VARCHAR}, </if> <if test="record.sellPoint != null" > sell_point = #{record.sellPoint,jdbcType=VARCHAR}, </if> <if test="record.price != null" > price = #{record.price,jdbcType=BIGINT}, </if> <if test="record.num != null" > num = #{record.num,jdbcType=INTEGER}, </if> <if test="record.barcode != null" > barcode = #{record.barcode,jdbcType=VARCHAR}, </if> <if test="record.image != null" > image = #{record.image,jdbcType=VARCHAR}, </if> <if test="record.cid != null" > cid = #{record.cid,jdbcType=BIGINT}, </if> <if test="record.status != null" > status = #{record.status,jdbcType=TINYINT}, </if> <if test="record.created != null" > created = #{record.created,jdbcType=TIMESTAMP}, </if> <if test="record.updated != null" > updated = #{record.updated,jdbcType=TIMESTAMP}, </if> </set> <if test="_parameter != null" > <include refid="Update_By_Example_Where_Clause" /> </if> </update> <update id="updateByExample" parameterType="map" > update tb_item set id = #{record.id,jdbcType=BIGINT}, title = #{record.title,jdbcType=VARCHAR}, sell_point = #{record.sellPoint,jdbcType=VARCHAR}, price = #{record.price,jdbcType=BIGINT}, num = #{record.num,jdbcType=INTEGER}, barcode = #{record.barcode,jdbcType=VARCHAR}, image = #{record.image,jdbcType=VARCHAR}, cid = #{record.cid,jdbcType=BIGINT}, status = #{record.status,jdbcType=TINYINT}, created = #{record.created,jdbcType=TIMESTAMP}, updated = #{record.updated,jdbcType=TIMESTAMP} <if test="_parameter != null" > <include refid="Update_By_Example_Where_Clause" /> </if> </update> <update id="updateByPrimaryKeySelective" parameterType="com.taotao.pojo.TbItem" > update tb_item <set > <if test="title != null" > title = #{title,jdbcType=VARCHAR}, </if> <if test="sellPoint != null" > sell_point = #{sellPoint,jdbcType=VARCHAR}, </if> <if test="price != null" > price = #{price,jdbcType=BIGINT}, </if> <if test="num != null" > num = #{num,jdbcType=INTEGER}, </if> <if test="barcode != null" > barcode = #{barcode,jdbcType=VARCHAR}, </if> <if test="image != null" > image = #{image,jdbcType=VARCHAR}, </if> <if test="cid != null" > cid = #{cid,jdbcType=BIGINT}, </if> <if test="status != null" > status = #{status,jdbcType=TINYINT}, </if> <if test="created != null" > created = #{created,jdbcType=TIMESTAMP}, </if> <if test="updated != null" > updated = #{updated,jdbcType=TIMESTAMP}, </if> </set> where id = #{id,jdbcType=BIGINT} </update> <update id="updateByPrimaryKey" parameterType="com.taotao.pojo.TbItem" > update tb_item set title = #{title,jdbcType=VARCHAR}, sell_point = #{sellPoint,jdbcType=VARCHAR}, price = #{price,jdbcType=BIGINT}, num = #{num,jdbcType=INTEGER}, barcode = #{barcode,jdbcType=VARCHAR}, image = #{image,jdbcType=VARCHAR}, cid = #{cid,jdbcType=BIGINT}, status = #{status,jdbcType=TINYINT}, created = #{created,jdbcType=TIMESTAMP}, updated = #{updated,jdbcType=TIMESTAMP} where id = #{id,jdbcType=BIGINT} </update> </mapper>
TbItemParamItemMapper.xml
<?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="com.taotao.mapper.TbItemParamItemMapper" > <resultMap id="BaseResultMap" type="com.taotao.pojo.TbItemParamItem" > <id column="id" property="id" jdbcType="BIGINT" /> <result column="item_id" property="itemId" jdbcType="BIGINT" /> <result column="created" property="created" jdbcType="TIMESTAMP" /> <result column="updated" property="updated" jdbcType="TIMESTAMP" /> </resultMap> <resultMap id="ResultMapWithBLOBs" type="com.taotao.pojo.TbItemParamItem" extends="BaseResultMap" > <result column="param_data" property="paramData" jdbcType="LONGVARCHAR" /> </resultMap> <sql id="Example_Where_Clause" > <where > <foreach collection="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} </when> <when test="criterion.singleValue" > and ${criterion.condition} #{criterion.value} </when> <when test="criterion.betweenValue" > 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> </trim> </if> </foreach> </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} </when> <when test="criterion.singleValue" > and ${criterion.condition} #{criterion.value} </when> <when test="criterion.betweenValue" > 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> </trim> </if> </foreach> </where> </sql> <sql id="Base_Column_List" > id, item_id, created, updated </sql> <sql id="Blob_Column_List" > param_data </sql> <select id="selectByExampleWithBLOBs" resultMap="ResultMapWithBLOBs" parameterType="com.taotao.pojo.TbItemParamItemExample" > select <if test="distinct" > distinct </if> <include refid="Base_Column_List" /> , <include refid="Blob_Column_List" /> from tb_item_param_item <if test="_parameter != null" > <include refid="Example_Where_Clause" /> </if> <if test="orderByClause != null" > order by ${orderByClause} </if> </select> <select id="selectByExample" resultMap="BaseResultMap" parameterType="com.taotao.pojo.TbItemParamItemExample" > select <if test="distinct" > distinct </if> <include refid="Base_Column_List" /> from tb_item_param_item <if test="_parameter != null" > <include refid="Example_Where_Clause" /> </if> <if test="orderByClause != null" > order by ${orderByClause} </if> </select> <select id="selectByPrimaryKey" resultMap="ResultMapWithBLOBs" parameterType="java.lang.Long" > select <include refid="Base_Column_List" /> , <include refid="Blob_Column_List" /> from tb_item_param_item where id = #{id,jdbcType=BIGINT} </select> <delete id="deleteByPrimaryKey" parameterType="java.lang.Long" > delete from tb_item_param_item where id = #{id,jdbcType=BIGINT} </delete> <delete id="deleteByExample" parameterType="com.taotao.pojo.TbItemParamItemExample" > delete from tb_item_param_item <if test="_parameter != null" > <include refid="Example_Where_Clause" /> </if> </delete> <insert id="insert" parameterType="com.taotao.pojo.TbItemParamItem" > insert into tb_item_param_item (id, item_id, created, updated, param_data) values (#{id,jdbcType=BIGINT}, #{itemId,jdbcType=BIGINT}, #{created,jdbcType=TIMESTAMP}, #{updated,jdbcType=TIMESTAMP}, #{paramData,jdbcType=LONGVARCHAR}) </insert> <insert id="insertSelective" parameterType="com.taotao.pojo.TbItemParamItem" > insert into tb_item_param_item <trim prefix="(" suffix=")" suffixOverrides="," > <if test="id != null" > id, </if> <if test="itemId != null" > item_id, </if> <if test="created != null" > created, </if> <if test="updated != null" > updated, </if> <if test="paramData != null" > param_data, </if> </trim> <trim prefix="values (" suffix=")" suffixOverrides="," > <if test="id != null" > #{id,jdbcType=BIGINT}, </if> <if test="itemId != null" > #{itemId,jdbcType=BIGINT}, </if> <if test="created != null" > #{created,jdbcType=TIMESTAMP}, </if> <if test="updated != null" > #{updated,jdbcType=TIMESTAMP}, </if> <if test="paramData != null" > #{paramData,jdbcType=LONGVARCHAR}, </if> </trim> </insert> <select id="countByExample" parameterType="com.taotao.pojo.TbItemParamItemExample" resultType="java.lang.Integer" > select count(*) from tb_item_param_item <if test="_parameter != null" > <include refid="Example_Where_Clause" /> </if> </select> <update id="updateByExampleSelective" parameterType="map" > update tb_item_param_item <set > <if test="record.id != null" > id = #{record.id,jdbcType=BIGINT}, </if> <if test="record.itemId != null" > item_id = #{record.itemId,jdbcType=BIGINT}, </if> <if test="record.created != null" > created = #{record.created,jdbcType=TIMESTAMP}, </if> <if test="record.updated != null" > updated = #{record.updated,jdbcType=TIMESTAMP}, </if> <if test="record.paramData != null" > param_data = #{record.paramData,jdbcType=LONGVARCHAR}, </if> </set> <if test="_parameter != null" > <include refid="Update_By_Example_Where_Clause" /> </if> </update> <update id="updateByExampleWithBLOBs" parameterType="map" > update tb_item_param_item set id = #{record.id,jdbcType=BIGINT}, item_id = #{record.itemId,jdbcType=BIGINT}, created = #{record.created,jdbcType=TIMESTAMP}, updated = #{record.updated,jdbcType=TIMESTAMP}, param_data = #{record.paramData,jdbcType=LONGVARCHAR} <if test="_parameter != null" > <include refid="Update_By_Example_Where_Clause" /> </if> </update> <update id="updateByExample" parameterType="map" > update tb_item_param_item set id = #{record.id,jdbcType=BIGINT}, item_id = #{record.itemId,jdbcType=BIGINT}, created = #{record.created,jdbcType=TIMESTAMP}, updated = #{record.updated,jdbcType=TIMESTAMP} <if test="_parameter != null" > <include refid="Update_By_Example_Where_Clause" /> </if> </update> <update id="updateByPrimaryKeySelective" parameterType="com.taotao.pojo.TbItemParamItem" > update tb_item_param_item <set > <if test="itemId != null" > item_id = #{itemId,jdbcType=BIGINT}, </if> <if test="created != null" > created = #{created,jdbcType=TIMESTAMP}, </if> <if test="updated != null" > updated = #{updated,jdbcType=TIMESTAMP}, </if> <if test="paramData != null" > param_data = #{paramData,jdbcType=LONGVARCHAR}, </if> </set> where id = #{id,jdbcType=BIGINT} </update> <update id="updateByPrimaryKeyWithBLOBs" parameterType="com.taotao.pojo.TbItemParamItem" > update tb_item_param_item set item_id = #{itemId,jdbcType=BIGINT}, created = #{created,jdbcType=TIMESTAMP}, updated = #{updated,jdbcType=TIMESTAMP}, param_data = #{paramData,jdbcType=LONGVARCHAR} where id = #{id,jdbcType=BIGINT} </update> <update id="updateByPrimaryKey" parameterType="com.taotao.pojo.TbItemParamItem" > update tb_item_param_item set item_id = #{itemId,jdbcType=BIGINT}, created = #{created,jdbcType=TIMESTAMP}, updated = #{updated,jdbcType=TIMESTAMP} where id = #{id,jdbcType=BIGINT} </update> </mapper>
TbItemParamMapper.xml
<?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="com.taotao.mapper.TbItemParamMapper" > <resultMap id="BaseResultMap" type="com.taotao.pojo.TbItemParam" > <id column="id" property="id" jdbcType="BIGINT" /> <result column="item_cat_id" property="itemCatId" jdbcType="BIGINT" /> <result column="created" property="created" jdbcType="TIMESTAMP" /> <result column="updated" property="updated" jdbcType="TIMESTAMP" /> </resultMap> <resultMap id="ResultMapWithBLOBs" type="com.taotao.pojo.TbItemParam" extends="BaseResultMap" > <result column="param_data" property="paramData" jdbcType="LONGVARCHAR" /> </resultMap> <sql id="Example_Where_Clause" > <where > <foreach collection="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} </when> <when test="criterion.singleValue" > and ${criterion.condition} #{criterion.value} </when> <when test="criterion.betweenValue" > 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> </trim> </if> </foreach> </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} </when> <when test="criterion.singleValue" > and ${criterion.condition} #{criterion.value} </when> <when test="criterion.betweenValue" > 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> </trim> </if> </foreach> </where> </sql> <sql id="Base_Column_List" > id, item_cat_id, created, updated </sql> <sql id="Blob_Column_List" > param_data </sql> <select id="selectByExampleWithBLOBs" resultMap="ResultMapWithBLOBs" parameterType="com.taotao.pojo.TbItemParamExample" > select <if test="distinct" > distinct </if> <include refid="Base_Column_List" /> , <include refid="Blob_Column_List" /> from tb_item_param <if test="_parameter != null" > <include refid="Example_Where_Clause" /> </if> <if test="orderByClause != null" > order by ${orderByClause} </if> </select> <select id="selectByExample" resultMap="BaseResultMap" parameterType="com.taotao.pojo.TbItemParamExample" > select <if test="distinct" > distinct </if> <include refid="Base_Column_List" /> from tb_item_param <if test="_parameter != null" > <include refid="Example_Where_Clause" /> </if> <if test="orderByClause != null" > order by ${orderByClause} </if> </select> <select id="selectByPrimaryKey" resultMap="ResultMapWithBLOBs" parameterType="java.lang.Long" > select <include refid="Base_Column_List" /> , <include refid="Blob_Column_List" /> from tb_item_param where id = #{id,jdbcType=BIGINT} </select> <delete id="deleteByPrimaryKey" parameterType="java.lang.Long" > delete from tb_item_param where id = #{id,jdbcType=BIGINT} </delete> <delete id="deleteByExample" parameterType="com.taotao.pojo.TbItemParamExample" > delete from tb_item_param <if test="_parameter != null" > <include refid="Example_Where_Clause" /> </if> </delete> <insert id="insert" parameterType="com.taotao.pojo.TbItemParam" > insert into tb_item_param (id, item_cat_id, created, updated, param_data) values (#{id,jdbcType=BIGINT}, #{itemCatId,jdbcType=BIGINT}, #{created,jdbcType=TIMESTAMP}, #{updated,jdbcType=TIMESTAMP}, #{paramData,jdbcType=LONGVARCHAR}) </insert> <insert id="insertSelective" parameterType="com.taotao.pojo.TbItemParam" > insert into tb_item_param <trim prefix="(" suffix=")" suffixOverrides="," > <if test="id != null" > id, </if> <if test="itemCatId != null" > item_cat_id, </if> <if test="created != null" > created, </if> <if test="updated != null" > updated, </if> <if test="paramData != null" > param_data, </if> </trim> <trim prefix="values (" suffix=")" suffixOverrides="," > <if test="id != null" > #{id,jdbcType=BIGINT}, </if> <if test="itemCatId != null" > #{itemCatId,jdbcType=BIGINT}, </if> <if test="created != null" > #{created,jdbcType=TIMESTAMP}, </if> <if test="updated != null" > #{updated,jdbcType=TIMESTAMP}, </if> <if test="paramData != null" > #{paramData,jdbcType=LONGVARCHAR}, </if> </trim> </insert> <select id="countByExample" parameterType="com.taotao.pojo.TbItemParamExample" resultType="java.lang.Integer" > select count(*) from tb_item_param <if test="_parameter != null" > <include refid="Example_Where_Clause" /> </if> </select> <update id="updateByExampleSelective" parameterType="map" > update tb_item_param <set > <if test="record.id != null" > id = #{record.id,jdbcType=BIGINT}, </if> <if test="record.itemCatId != null" > item_cat_id = #{record.itemCatId,jdbcType=BIGINT}, </if> <if test="record.created != null" > created = #{record.created,jdbcType=TIMESTAMP}, </if> <if test="record.updated != null" > updated = #{record.updated,jdbcType=TIMESTAMP}, </if> <if test="record.paramData != null" > param_data = #{record.paramData,jdbcType=LONGVARCHAR}, </if> </set> <if test="_parameter != null" > <include refid="Update_By_Example_Where_Clause" /> </if> </update> <update id="updateByExampleWithBLOBs" parameterType="map" > update tb_item_param set id = #{record.id,jdbcType=BIGINT}, item_cat_id = #{record.itemCatId,jdbcType=BIGINT}, created = #{record.created,jdbcType=TIMESTAMP}, updated = #{record.updated,jdbcType=TIMESTAMP}, param_data = #{record.paramData,jdbcType=LONGVARCHAR} <if test="_parameter != null" > <include refid="Update_By_Example_Where_Clause" /> </if> </update> <update id="updateByExample" parameterType="map" > update tb_item_param set id = #{record.id,jdbcType=BIGINT}, item_cat_id = #{record.itemCatId,jdbcType=BIGINT}, created = #{record.created,jdbcType=TIMESTAMP}, updated = #{record.updated,jdbcType=TIMESTAMP} <if test="_parameter != null" > <include refid="Update_By_Example_Where_Clause" /> </if> </update> <update id="updateByPrimaryKeySelective" parameterType="com.taotao.pojo.TbItemParam" > update tb_item_param <set > <if test="itemCatId != null" > item_cat_id = #{itemCatId,jdbcType=BIGINT}, </if> <if test="created != null" > created = #{created,jdbcType=TIMESTAMP}, </if> <if test="updated != null" > updated = #{updated,jdbcType=TIMESTAMP}, </if> <if test="paramData != null" > param_data = #{paramData,jdbcType=LONGVARCHAR}, </if> </set> where id = #{id,jdbcType=BIGINT} </update> <update id="updateByPrimaryKeyWithBLOBs" parameterType="com.taotao.pojo.TbItemParam" > update tb_item_param set item_cat_id = #{itemCatId,jdbcType=BIGINT}, created = #{created,jdbcType=TIMESTAMP}, updated = #{updated,jdbcType=TIMESTAMP}, param_data = #{paramData,jdbcType=LONGVARCHAR} where id = #{id,jdbcType=BIGINT} </update> <update id="updateByPrimaryKey" parameterType="com.taotao.pojo.TbItemParam" > update tb_item_param set item_cat_id = #{itemCatId,jdbcType=BIGINT}, created = #{created,jdbcType=TIMESTAMP}, updated = #{updated,jdbcType=TIMESTAMP} where id = #{id,jdbcType=BIGINT} </update> </mapper>
TbOrderItemMapper.xml
<?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="com.taotao.mapper.TbOrderItemMapper" > <resultMap id="BaseResultMap" type="com.taotao.pojo.TbOrderItem" > <id column="id" property="id" jdbcType="VARCHAR" /> <result column="item_id" property="itemId" jdbcType="VARCHAR" /> <result column="order_id" property="orderId" jdbcType="VARCHAR" /> <result column="num" property="num" jdbcType="INTEGER" /> <result column="title" property="title" jdbcType="VARCHAR" /> <result column="price" property="price" jdbcType="BIGINT" /> <result column="total_fee" property="totalFee" jdbcType="BIGINT" /> <result column="pic_path" property="picPath" jdbcType="VARCHAR" /> </resultMap> <sql id="Example_Where_Clause" > <where > <foreach collection="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} </when> <when test="criterion.singleValue" > and ${criterion.condition} #{criterion.value} </when> <when test="criterion.betweenValue" > 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> </trim> </if> </foreach> </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} </when> <when test="criterion.singleValue" > and ${criterion.condition} #{criterion.value} </when> <when test="criterion.betweenValue" > 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> </trim> </if> </foreach> </where> </sql> <sql id="Base_Column_List" > id, item_id, order_id, num, title, price, total_fee, pic_path </sql> <select id="selectByExample" resultMap="BaseResultMap" parameterType="com.taotao.pojo.TbOrderItemExample" > select <if test="distinct" > distinct </if> <include refid="Base_Column_List" /> from tb_order_item <if test="_parameter != null" > <include refid="Example_Where_Clause" /> </if> <if test="orderByClause != null" > order by ${orderByClause} </if> </select> <select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.String" > select <include refid="Base_Column_List" /> from tb_order_item where id = #{id,jdbcType=VARCHAR} </select> <delete id="deleteByPrimaryKey" parameterType="java.lang.String" > delete from tb_order_item where id = #{id,jdbcType=VARCHAR} </delete> <delete id="deleteByExample" parameterType="com.taotao.pojo.TbOrderItemExample" > delete from tb_order_item <if test="_parameter != null" > <include refid="Example_Where_Clause" /> </if> </delete> <insert id="insert" parameterType="com.taotao.pojo.TbOrderItem" > insert into tb_order_item (id, item_id, order_id, num, title, price, total_fee, pic_path) values (#{id,jdbcType=VARCHAR}, #{itemId,jdbcType=VARCHAR}, #{orderId,jdbcType=VARCHAR}, #{num,jdbcType=INTEGER}, #{title,jdbcType=VARCHAR}, #{price,jdbcType=BIGINT}, #{totalFee,jdbcType=BIGINT}, #{picPath,jdbcType=VARCHAR}) </insert> <insert id="insertSelective" parameterType="com.taotao.pojo.TbOrderItem" > insert into tb_order_item <trim prefix="(" suffix=")" suffixOverrides="," > <if test="id != null" > id, </if> <if test="itemId != null" > item_id, </if> <if test="orderId != null" > order_id, </if> <if test="num != null" > num, </if> <if test="title != null" > title, </if> <if test="price != null" > price, </if> <if test="totalFee != null" > total_fee, </if> <if test="picPath != null" > pic_path, </if> </trim> <trim prefix="values (" suffix=")" suffixOverrides="," > <if test="id != null" > #{id,jdbcType=VARCHAR}, </if> <if test="itemId != null" > #{itemId,jdbcType=VARCHAR}, </if> <if test="orderId != null" > #{orderId,jdbcType=VARCHAR}, </if> <if test="num != null" > #{num,jdbcType=INTEGER}, </if> <if test="title != null" > #{title,jdbcType=VARCHAR}, </if> <if test="price != null" > #{price,jdbcType=BIGINT}, </if> <if test="totalFee != null" > #{totalFee,jdbcType=BIGINT}, </if> <if test="picPath != null" > #{picPath,jdbcType=VARCHAR}, </if> </trim> </insert> <select id="countByExample" parameterType="com.taotao.pojo.TbOrderItemExample" resultType="java.lang.Integer" > select count(*) from tb_order_item <if test="_parameter != null" > <include refid="Example_Where_Clause" /> </if> </select> <update id="updateByExampleSelective" parameterType="map" > update tb_order_item <set > <if test="record.id != null" > id = #{record.id,jdbcType=VARCHAR}, </if> <if test="record.itemId != null" > item_id = #{record.itemId,jdbcType=VARCHAR}, </if> <if test="record.orderId != null" > order_id = #{record.orderId,jdbcType=VARCHAR}, </if> <if test="record.num != null" > num = #{record.num,jdbcType=INTEGER}, </if> <if test="record.title != null" > title = #{record.title,jdbcType=VARCHAR}, </if> <if test="record.price != null" > price = #{record.price,jdbcType=BIGINT}, </if> <if test="record.totalFee != null" > total_fee = #{record.totalFee,jdbcType=BIGINT}, </if> <if test="record.picPath != null" > pic_path = #{record.picPath,jdbcType=VARCHAR}, </if> </set> <if test="_parameter != null" > <include refid="Update_By_Example_Where_Clause" /> </if> </update> <update id="updateByExample" parameterType="map" > update tb_order_item set id = #{record.id,jdbcType=VARCHAR}, item_id = #{record.itemId,jdbcType=VARCHAR}, order_id = #{record.orderId,jdbcType=VARCHAR}, num = #{record.num,jdbcType=INTEGER}, title = #{record.title,jdbcType=VARCHAR}, price = #{record.price,jdbcType=BIGINT}, total_fee = #{record.totalFee,jdbcType=BIGINT}, pic_path = #{record.picPath,jdbcType=VARCHAR} <if test="_parameter != null" > <include refid="Update_By_Example_Where_Clause" /> </if> </update> <update id="updateByPrimaryKeySelective" parameterType="com.taotao.pojo.TbOrderItem" > update tb_order_item <set > <if test="itemId != null" > item_id = #{itemId,jdbcType=VARCHAR}, </if> <if test="orderId != null" > order_id = #{orderId,jdbcType=VARCHAR}, </if> <if test="num != null" > num = #{num,jdbcType=INTEGER}, </if> <if test="title != null" > title = #{title,jdbcType=VARCHAR}, </if> <if test="price != null" > price = #{price,jdbcType=BIGINT}, </if> <if test="totalFee != null" > total_fee = #{totalFee,jdbcType=BIGINT}, </if> <if test="picPath != null" > pic_path = #{picPath,jdbcType=VARCHAR}, </if> </set> where id = #{id,jdbcType=VARCHAR} </update> <update id="updateByPrimaryKey" parameterType="com.taotao.pojo.TbOrderItem" > update tb_order_item set item_id = #{itemId,jdbcType=VARCHAR}, order_id = #{orderId,jdbcType=VARCHAR}, num = #{num,jdbcType=INTEGER}, title = #{title,jdbcType=VARCHAR}, price = #{price,jdbcType=BIGINT}, total_fee = #{totalFee,jdbcType=BIGINT}, pic_path = #{picPath,jdbcType=VARCHAR} where id = #{id,jdbcType=VARCHAR} </update> </mapper>
TbOrderMapper.xml
<?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="com.taotao.mapper.TbOrderMapper" > <resultMap id="BaseResultMap" type="com.taotao.pojo.TbOrder" > <id column="order_id" property="orderId" jdbcType="VARCHAR" /> <result column="payment" property="payment" jdbcType="VARCHAR" /> <result column="payment_type" property="paymentType" jdbcType="INTEGER" /> <result column="post_fee" property="postFee" jdbcType="VARCHAR" /> <result column="status" property="status" jdbcType="INTEGER" /> <result column="create_time" property="createTime" jdbcType="TIMESTAMP" /> <result column="update_time" property="updateTime" jdbcType="TIMESTAMP" /> <result column="payment_time" property="paymentTime" jdbcType="TIMESTAMP" /> <result column="consign_time" property="consignTime" jdbcType="TIMESTAMP" /> <result column="end_time" property="endTime" jdbcType="TIMESTAMP" /> <result column="close_time" property="closeTime" jdbcType="TIMESTAMP" /> <result column="shipping_name" property="shippingName" jdbcType="VARCHAR" /> <result column="shipping_code" property="shippingCode" jdbcType="VARCHAR" /> <result column="user_id" property="userId" jdbcType="BIGINT" /> <result column="buyer_message" property="buyerMessage" jdbcType="VARCHAR" /> <result column="buyer_nick" property="buyerNick" jdbcType="VARCHAR" /> <result column="buyer_rate" property="buyerRate" jdbcType="INTEGER" /> </resultMap> <sql id="Example_Where_Clause" > <where > <foreach collection="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} </when> <when test="criterion.singleValue" > and ${criterion.condition} #{criterion.value} </when> <when test="criterion.betweenValue" > 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> </trim> </if> </foreach> </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} </when> <when test="criterion.singleValue" > and ${criterion.condition} #{criterion.value} </when> <when test="criterion.betweenValue" > 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> </trim> </if> </foreach> </where> </sql> <sql id="Base_Column_List" > order_id, payment, payment_type, post_fee, status, create_time, update_time, payment_time, consign_time, end_time, close_time, shipping_name, shipping_code, user_id, buyer_message, buyer_nick, buyer_rate </sql> <select id="selectByExample" resultMap="BaseResultMap" parameterType="com.taotao.pojo.TbOrderExample" > select <if test="distinct" > distinct </if> <include refid="Base_Column_List" /> from tb_order <if test="_parameter != null" > <include refid="Example_Where_Clause" /> </if> <if test="orderByClause != null" > order by ${orderByClause} </if> </select> <select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.String" > select <include refid="Base_Column_List" /> from tb_order where order_id = #{orderId,jdbcType=VARCHAR} </select> <delete id="deleteByPrimaryKey" parameterType="java.lang.String" > delete from tb_order where order_id = #{orderId,jdbcType=VARCHAR} </delete> <delete id="deleteByExample" parameterType="com.taotao.pojo.TbOrderExample" > delete from tb_order <if test="_parameter != null" > <include refid="Example_Where_Clause" /> </if> </delete> <insert id="insert" parameterType="com.taotao.pojo.TbOrder" > insert into tb_order (order_id, payment, payment_type, post_fee, status, create_time, update_time, payment_time, consign_time, end_time, close_time, shipping_name, shipping_code, user_id, buyer_message, buyer_nick, buyer_rate) values (#{orderId,jdbcType=VARCHAR}, #{payment,jdbcType=VARCHAR}, #{paymentType,jdbcType=INTEGER}, #{postFee,jdbcType=VARCHAR}, #{status,jdbcType=INTEGER}, #{createTime,jdbcType=TIMESTAMP}, #{updateTime,jdbcType=TIMESTAMP}, #{paymentTime,jdbcType=TIMESTAMP}, #{consignTime,jdbcType=TIMESTAMP}, #{endTime,jdbcType=TIMESTAMP}, #{closeTime,jdbcType=TIMESTAMP}, #{shippingName,jdbcType=VARCHAR}, #{shippingCode,jdbcType=VARCHAR}, #{userId,jdbcType=BIGINT}, #{buyerMessage,jdbcType=VARCHAR}, #{buyerNick,jdbcType=VARCHAR}, #{buyerRate,jdbcType=INTEGER}) </insert> <insert id="insertSelective" parameterType="com.taotao.pojo.TbOrder" > insert into tb_order <trim prefix="(" suffix=")" suffixOverrides="," > <if test="orderId != null" > order_id, </if> <if test="payment != null" > payment, </if> <if test="paymentType != null" > payment_type, </if> <if test="postFee != null" > post_fee, </if> <if test="status != null" > status, </if> <if test="createTime != null" > create_time, </if> <if test="updateTime != null" > update_time, </if> <if test="paymentTime != null" > payment_time, </if> <if test="consignTime != null" > consign_time, </if> <if test="endTime != null" > end_time, </if> <if test="closeTime != null" > close_time, </if> <if test="shippingName != null" > shipping_name, </if> <if test="shippingCode != null" > shipping_code, </if> <if test="userId != null" > user_id, </if> <if test="buyerMessage != null" > buyer_message, </if> <if test="buyerNick != null" > buyer_nick, </if> <if test="buyerRate != null" > buyer_rate, </if> </trim> <trim prefix="values (" suffix=")" suffixOverrides="," > <if test="orderId != null" > #{orderId,jdbcType=VARCHAR}, </if> <if test="payment != null" > #{payment,jdbcType=VARCHAR}, </if> <if test="paymentType != null" > #{paymentType,jdbcType=INTEGER}, </if> <if test="postFee != null" > #{postFee,jdbcType=VARCHAR}, </if> <if test="status != null" > #{status,jdbcType=INTEGER}, </if> <if test="createTime != null" > #{createTime,jdbcType=TIMESTAMP}, </if> <if test="updateTime != null" > #{updateTime,jdbcType=TIMESTAMP}, </if> <if test="paymentTime != null" > #{paymentTime,jdbcType=TIMESTAMP}, </if> <if test="consignTime != null" > #{consignTime,jdbcType=TIMESTAMP}, </if> <if test="endTime != null" > #{endTime,jdbcType=TIMESTAMP}, </if> <if test="closeTime != null" > #{closeTime,jdbcType=TIMESTAMP}, </if> <if test="shippingName != null" > #{shippingName,jdbcType=VARCHAR}, </if> <if test="shippingCode != null" > #{shippingCode,jdbcType=VARCHAR}, </if> <if test="userId != null" > #{userId,jdbcType=BIGINT}, </if> <if test="buyerMessage != null" > #{buyerMessage,jdbcType=VARCHAR}, </if> <if test="buyerNick != null" > #{buyerNick,jdbcType=VARCHAR}, </if> <if test="buyerRate != null" > #{buyerRate,jdbcType=INTEGER}, </if> </trim> </insert> <select id="countByExample" parameterType="com.taotao.pojo.TbOrderExample" resultType="java.lang.Integer" > select count(*) from tb_order <if test="_parameter != null" > <include refid="Example_Where_Clause" /> </if> </select> <update id="updateByExampleSelective" parameterType="map" > update tb_order <set > <if test="record.orderId != null" > order_id = #{record.orderId,jdbcType=VARCHAR}, </if> <if test="record.payment != null" > payment = #{record.payment,jdbcType=VARCHAR}, </if> <if test="record.paymentType != null" > payment_type = #{record.paymentType,jdbcType=INTEGER}, </if> <if test="record.postFee != null" > post_fee = #{record.postFee,jdbcType=VARCHAR}, </if> <if test="record.status != null" > status = #{record.status,jdbcType=INTEGER}, </if> <if test="record.createTime != null" > create_time = #{record.createTime,jdbcType=TIMESTAMP}, </if> <if test="record.updateTime != null" > update_time = #{record.updateTime,jdbcType=TIMESTAMP}, </if> <if test="record.paymentTime != null" > payment_time = #{record.paymentTime,jdbcType=TIMESTAMP}, </if> <if test="record.consignTime != null" > consign_time = #{record.consignTime,jdbcType=TIMESTAMP}, </if> <if test="record.endTime != null" > end_time = #{record.endTime,jdbcType=TIMESTAMP}, </if> <if test="record.closeTime != null" > close_time = #{record.closeTime,jdbcType=TIMESTAMP}, </if> <if test="record.shippingName != null" > shipping_name = #{record.shippingName,jdbcType=VARCHAR}, </if> <if test="record.shippingCode != null" > shipping_code = #{record.shippingCode,jdbcType=VARCHAR}, </if> <if test="record.userId != null" > user_id = #{record.userId,jdbcType=BIGINT}, </if> <if test="record.buyerMessage != null" > buyer_message = #{record.buyerMessage,jdbcType=VARCHAR}, </if> <if test="record.buyerNick != null" > buyer_nick = #{record.buyerNick,jdbcType=VARCHAR}, </if> <if test="record.buyerRate != null" > buyer_rate = #{record.buyerRate,jdbcType=INTEGER}, </if> </set> <if test="_parameter != null" > <include refid="Update_By_Example_Where_Clause" /> </if> </update> <update id="updateByExample" parameterType="map" > update tb_order set order_id = #{record.orderId,jdbcType=VARCHAR}, payment = #{record.payment,jdbcType=VARCHAR}, payment_type = #{record.paymentType,jdbcType=INTEGER}, post_fee = #{record.postFee,jdbcType=VARCHAR}, status = #{record.status,jdbcType=INTEGER}, create_time = #{record.createTime,jdbcType=TIMESTAMP}, update_time = #{record.updateTime,jdbcType=TIMESTAMP}, payment_time = #{record.paymentTime,jdbcType=TIMESTAMP}, consign_time = #{record.consignTime,jdbcType=TIMESTAMP}, end_time = #{record.endTime,jdbcType=TIMESTAMP}, close_time = #{record.closeTime,jdbcType=TIMESTAMP}, shipping_name = #{record.shippingName,jdbcType=VARCHAR}, shipping_code = #{record.shippingCode,jdbcType=VARCHAR}, user_id = #{record.userId,jdbcType=BIGINT}, buyer_message = #{record.buyerMessage,jdbcType=VARCHAR}, buyer_nick = #{record.buyerNick,jdbcType=VARCHAR}, buyer_rate = #{record.buyerRate,jdbcType=INTEGER} <if test="_parameter != null" > <include refid="Update_By_Example_Where_Clause" /> </if> </update> <update id="updateByPrimaryKeySelective" parameterType="com.taotao.pojo.TbOrder" > update tb_order <set > <if test="payment != null" > payment = #{payment,jdbcType=VARCHAR}, </if> <if test="paymentType != null" > payment_type = #{paymentType,jdbcType=INTEGER}, </if> <if test="postFee != null" > post_fee = #{postFee,jdbcType=VARCHAR}, </if> <if test="status != null" > status = #{status,jdbcType=INTEGER}, </if> <if test="createTime != null" > create_time = #{createTime,jdbcType=TIMESTAMP}, </if> <if test="updateTime != null" > update_time = #{updateTime,jdbcType=TIMESTAMP}, </if> <if test="paymentTime != null" > payment_time = #{paymentTime,jdbcType=TIMESTAMP}, </if> <if test="consignTime != null" > consign_time = #{consignTime,jdbcType=TIMESTAMP}, </if> <if test="endTime != null" > end_time = #{endTime,jdbcType=TIMESTAMP}, </if> <if test="closeTime != null" > close_time = #{closeTime,jdbcType=TIMESTAMP}, </if> <if test="shippingName != null" > shipping_name = #{shippingName,jdbcType=VARCHAR}, </if> <if test="shippingCode != null" > shipping_code = #{shippingCode,jdbcType=VARCHAR}, </if> <if test="userId != null" > user_id = #{userId,jdbcType=BIGINT}, </if> <if test="buyerMessage != null" > buyer_message = #{buyerMessage,jdbcType=VARCHAR}, </if> <if test="buyerNick != null" > buyer_nick = #{buyerNick,jdbcType=VARCHAR}, </if> <if test="buyerRate != null" > buyer_rate = #{buyerRate,jdbcType=INTEGER}, </if> </set> where order_id = #{orderId,jdbcType=VARCHAR} </update> <update id="updateByPrimaryKey" parameterType="com.taotao.pojo.TbOrder" > update tb_order set payment = #{payment,jdbcType=VARCHAR}, payment_type = #{paymentType,jdbcType=INTEGER}, post_fee = #{postFee,jdbcType=VARCHAR}, status = #{status,jdbcType=INTEGER}, create_time = #{createTime,jdbcType=TIMESTAMP}, update_time = #{updateTime,jdbcType=TIMESTAMP}, payment_time = #{paymentTime,jdbcType=TIMESTAMP}, consign_time = #{consignTime,jdbcType=TIMESTAMP}, end_time = #{endTime,jdbcType=TIMESTAMP}, close_time = #{closeTime,jdbcType=TIMESTAMP}, shipping_name = #{shippingName,jdbcType=VARCHAR}, shipping_code = #{shippingCode,jdbcType=VARCHAR}, user_id = #{userId,jdbcType=BIGINT}, buyer_message = #{buyerMessage,jdbcType=VARCHAR}, buyer_nick = #{buyerNick,jdbcType=VARCHAR}, buyer_rate = #{buyerRate,jdbcType=INTEGER} where order_id = #{orderId,jdbcType=VARCHAR} </update> </mapper>
TbOrderShippingMapper.xml
<?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="com.taotao.mapper.TbOrderShippingMapper" > <resultMap id="BaseResultMap" type="com.taotao.pojo.TbOrderShipping" > <id column="order_id" property="orderId" jdbcType="VARCHAR" /> <result column="receiver_name" property="receiverName" jdbcType="VARCHAR" /> <result column="receiver_phone" property="receiverPhone" jdbcType="VARCHAR" /> <result column="receiver_mobile" property="receiverMobile" jdbcType="VARCHAR" /> <result column="receiver_state" property="receiverState" jdbcType="VARCHAR" /> <result column="receiver_city" property="receiverCity" jdbcType="VARCHAR" /> <result column="receiver_district" property="receiverDistrict" jdbcType="VARCHAR" /> <result column="receiver_address" property="receiverAddress" jdbcType="VARCHAR" /> <result column="receiver_zip" property="receiverZip" jdbcType="VARCHAR" /> <result column="created" property="created" jdbcType="TIMESTAMP" /> <result column="updated" property="updated" jdbcType="TIMESTAMP" /> </resultMap> <sql id="Example_Where_Clause" > <where > <foreach collection="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} </when> <when test="criterion.singleValue" > and ${criterion.condition} #{criterion.value} </when> <when test="criterion.betweenValue" > 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> </trim> </if> </foreach> </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} </when> <when test="criterion.singleValue" > and ${criterion.condition} #{criterion.value} </when> <when test="criterion.betweenValue" > 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> </trim> </if> </foreach> </where> </sql> <sql id="Base_Column_List" > order_id, receiver_name, receiver_phone, receiver_mobile, receiver_state, receiver_city, receiver_district, receiver_address, receiver_zip, created, updated </sql> <select id="selectByExample" resultMap="BaseResultMap" parameterType="com.taotao.pojo.TbOrderShippingExample" > select <if test="distinct" > distinct </if> <include refid="Base_Column_List" /> from tb_order_shipping <if test="_parameter != null" > <include refid="Example_Where_Clause" /> </if> <if test="orderByClause != null" > order by ${orderByClause} </if> </select> <select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.String" > select <include refid="Base_Column_List" /> from tb_order_shipping where order_id = #{orderId,jdbcType=VARCHAR} </select> <delete id="deleteByPrimaryKey" parameterType="java.lang.String" > delete from tb_order_shipping where order_id = #{orderId,jdbcType=VARCHAR} </delete> <delete id="deleteByExample" parameterType="com.taotao.pojo.TbOrderShippingExample" > delete from tb_order_shipping <if test="_parameter != null" > <include refid="Example_Where_Clause" /> </if> </delete> <insert id="insert" parameterType="com.taotao.pojo.TbOrderShipping" > insert into tb_order_shipping (order_id, receiver_name, receiver_phone, receiver_mobile, receiver_state, receiver_city, receiver_district, receiver_address, receiver_zip, created, updated) values (#{orderId,jdbcType=VARCHAR}, #{receiverName,jdbcType=VARCHAR}, #{receiverPhone,jdbcType=VARCHAR}, #{receiverMobile,jdbcType=VARCHAR}, #{receiverState,jdbcType=VARCHAR}, #{receiverCity,jdbcType=VARCHAR}, #{receiverDistrict,jdbcType=VARCHAR}, #{receiverAddress,jdbcType=VARCHAR}, #{receiverZip,jdbcType=VARCHAR}, #{created,jdbcType=TIMESTAMP}, #{updated,jdbcType=TIMESTAMP}) </insert> <insert id="insertSelective" parameterType="com.taotao.pojo.TbOrderShipping" > insert into tb_order_shipping <trim prefix="(" suffix=")" suffixOverrides="," > <if test="orderId != null" > order_id, </if> <if test="receiverName != null" > receiver_name, </if> <if test="receiverPhone != null" > receiver_phone, </if> <if test="receiverMobile != null" > receiver_mobile, </if> <if test="receiverState != null" > receiver_state, </if> <if test="receiverCity != null" > receiver_city, </if> <if test="receiverDistrict != null" > receiver_district, </if> <if test="receiverAddress != null" > receiver_address, </if> <if test="receiverZip != null" > receiver_zip, </if> <if test="created != null" > created, </if> <if test="updated != null" > updated, </if> </trim> <trim prefix="values (" suffix=")" suffixOverrides="," > <if test="orderId != null" > #{orderId,jdbcType=VARCHAR}, </if> <if test="receiverName != null" > #{receiverName,jdbcType=VARCHAR}, </if> <if test="receiverPhone != null" > #{receiverPhone,jdbcType=VARCHAR}, </if> <if test="receiverMobile != null" > #{receiverMobile,jdbcType=VARCHAR}, </if> <if test="receiverState != null" > #{receiverState,jdbcType=VARCHAR}, </if> <if test="receiverCity != null" > #{receiverCity,jdbcType=VARCHAR}, </if> <if test="receiverDistrict != null" > #{receiverDistrict,jdbcType=VARCHAR}, </if> <if test="receiverAddress != null" > #{receiverAddress,jdbcType=VARCHAR}, </if> <if test="receiverZip != null" > #{receiverZip,jdbcType=VARCHAR}, </if> <if test="created != null" > #{created,jdbcType=TIMESTAMP}, </if> <if test="updated != null" > #{updated,jdbcType=TIMESTAMP}, </if> </trim> </insert> <select id="countByExample" parameterType="com.taotao.pojo.TbOrderShippingExample" resultType="java.lang.Integer" > select count(*) from tb_order_shipping <if test="_parameter != null" > <include refid="Example_Where_Clause" /> </if> </select> <update id="updateByExampleSelective" parameterType="map" > update tb_order_shipping <set > <if test="record.orderId != null" > order_id = #{record.orderId,jdbcType=VARCHAR}, </if> <if test="record.receiverName != null" > receiver_name = #{record.receiverName,jdbcType=VARCHAR}, </if> <if test="record.receiverPhone != null" > receiver_phone = #{record.receiverPhone,jdbcType=VARCHAR}, </if> <if test="record.receiverMobile != null" > receiver_mobile = #{record.receiverMobile,jdbcType=VARCHAR}, </if> <if test="record.receiverState != null" > receiver_state = #{record.receiverState,jdbcType=VARCHAR}, </if> <if test="record.receiverCity != null" > receiver_city = #{record.receiverCity,jdbcType=VARCHAR}, </if> <if test="record.receiverDistrict != null" > receiver_district = #{record.receiverDistrict,jdbcType=VARCHAR}, </if> <if test="record.receiverAddress != null" > receiver_address = #{record.receiverAddress,jdbcType=VARCHAR}, </if> <if test="record.receiverZip != null" > receiver_zip = #{record.receiverZip,jdbcType=VARCHAR}, </if> <if test="record.created != null" > created = #{record.created,jdbcType=TIMESTAMP}, </if> <if test="record.updated != null" > updated = #{record.updated,jdbcType=TIMESTAMP}, </if> </set> <if test="_parameter != null" > <include refid="Update_By_Example_Where_Clause" /> </if> </update> <update id="updateByExample" parameterType="map" > update tb_order_shipping set order_id = #{record.orderId,jdbcType=VARCHAR}, receiver_name = #{record.receiverName,jdbcType=VARCHAR}, receiver_phone = #{record.receiverPhone,jdbcType=VARCHAR}, receiver_mobile = #{record.receiverMobile,jdbcType=VARCHAR}, receiver_state = #{record.receiverState,jdbcType=VARCHAR}, receiver_city = #{record.receiverCity,jdbcType=VARCHAR}, receiver_district = #{record.receiverDistrict,jdbcType=VARCHAR}, receiver_address = #{record.receiverAddress,jdbcType=VARCHAR}, receiver_zip = #{record.receiverZip,jdbcType=VARCHAR}, created = #{record.created,jdbcType=TIMESTAMP}, updated = #{record.updated,jdbcType=TIMESTAMP} <if test="_parameter != null" > <include refid="Update_By_Example_Where_Clause" /> </if> </update> <update id="updateByPrimaryKeySelective" parameterType="com.taotao.pojo.TbOrderShipping" > update tb_order_shipping <set > <if test="receiverName != null" > receiver_name = #{receiverName,jdbcType=VARCHAR}, </if> <if test="receiverPhone != null" > receiver_phone = #{receiverPhone,jdbcType=VARCHAR}, </if> <if test="receiverMobile != null" > receiver_mobile = #{receiverMobile,jdbcType=VARCHAR}, </if> <if test="receiverState != null" > receiver_state = #{receiverState,jdbcType=VARCHAR}, </if> <if test="receiverCity != null" > receiver_city = #{receiverCity,jdbcType=VARCHAR}, </if> <if test="receiverDistrict != null" > receiver_district = #{receiverDistrict,jdbcType=VARCHAR}, </if> <if test="receiverAddress != null" > receiver_address = #{receiverAddress,jdbcType=VARCHAR}, </if> <if test="receiverZip != null" > receiver_zip = #{receiverZip,jdbcType=VARCHAR}, </if> <if test="created != null" > created = #{created,jdbcType=TIMESTAMP}, </if> <if test="updated != null" > updated = #{updated,jdbcType=TIMESTAMP}, </if> </set> where order_id = #{orderId,jdbcType=VARCHAR} </update> <update id="updateByPrimaryKey" parameterType="com.taotao.pojo.TbOrderShipping" > update tb_order_shipping set receiver_name = #{receiverName,jdbcType=VARCHAR}, receiver_phone = #{receiverPhone,jdbcType=VARCHAR}, receiver_mobile = #{receiverMobile,jdbcType=VARCHAR}, receiver_state = #{receiverState,jdbcType=VARCHAR}, receiver_city = #{receiverCity,jdbcType=VARCHAR}, receiver_district = #{receiverDistrict,jdbcType=VARCHAR}, receiver_address = #{receiverAddress,jdbcType=VARCHAR}, receiver_zip = #{receiverZip,jdbcType=VARCHAR}, created = #{created,jdbcType=TIMESTAMP}, updated = #{updated,jdbcType=TIMESTAMP} where order_id = #{orderId,jdbcType=VARCHAR} </update> </mapper>
TbUserMapper.xml
<?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="com.taotao.mapper.TbUserMapper" > <resultMap id="BaseResultMap" type="com.taotao.pojo.TbUser" > <id column="id" property="id" jdbcType="BIGINT" /> <result column="username" property="username" jdbcType="VARCHAR" /> <result column="password" property="password" jdbcType="VARCHAR" /> <result column="phone" property="phone" jdbcType="VARCHAR" /> <result column="email" property="email" jdbcType="VARCHAR" /> <result column="created" property="created" jdbcType="TIMESTAMP" /> <result column="updated" property="updated" jdbcType="TIMESTAMP" /> </resultMap> <sql id="Example_Where_Clause" > <where > <foreach collection="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} </when> <when test="criterion.singleValue" > and ${criterion.condition} #{criterion.value} </when> <when test="criterion.betweenValue" > 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> </trim> </if> </foreach> </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} </when> <when test="criterion.singleValue" > and ${criterion.condition} #{criterion.value} </when> <when test="criterion.betweenValue" > 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> </trim> </if> </foreach> </where> </sql> <sql id="Base_Column_List" > 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" /> from tb_user <if test="_parameter != null" > <include refid="Example_Where_Clause" /> </if> <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> <delete id="deleteByPrimaryKey" parameterType="java.lang.Long" > delete from tb_user where id = #{id,jdbcType=BIGINT} </delete> <delete id="deleteByExample" parameterType="com.taotao.pojo.TbUserExample" > delete from tb_user <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}, #{updated,jdbcType=TIMESTAMP}) </insert> <insert id="insertSelective" parameterType="com.taotao.pojo.TbUser" > insert into tb_user <trim prefix="(" suffix=")" suffixOverrides="," > <if test="id != null" > id, </if> <if test="username != null" > username, </if> <if test="password != null" > password, </if> <if test="phone != null" > phone, </if> <if test="email != null" > email, </if> <if test="created != null" > created, </if> <if test="updated != null" > updated, </if> </trim> <trim prefix="values (" suffix=")" suffixOverrides="," > <if test="id != null" > #{id,jdbcType=BIGINT}, </if> <if test="username != null" > #{username,jdbcType=VARCHAR}, </if> <if test="password != null" > #{password,jdbcType=VARCHAR}, </if> <if test="phone != null" > #{phone,jdbcType=VARCHAR}, </if> <if test="email != null" > #{email,jdbcType=VARCHAR}, </if> <if test="created != null" > #{created,jdbcType=TIMESTAMP}, </if> <if test="updated != null" > #{updated,jdbcType=TIMESTAMP}, </if> </trim> </insert> <select id="countByExample" parameterType="com.taotao.pojo.TbUserExample" resultType="java.lang.Integer" > select count(*) from tb_user <if test="_parameter != null" > <include refid="Example_Where_Clause" /> </if> </select> <update id="updateByExampleSelective" parameterType="map" > update tb_user <set > <if test="record.id != null" > id = #{record.id,jdbcType=BIGINT}, </if> <if test="record.username != null" > username = #{record.username,jdbcType=VARCHAR}, </if> <if test="record.password != null" > password = #{record.password,jdbcType=VARCHAR}, </if> <if test="record.phone != null" > phone = #{record.phone,jdbcType=VARCHAR}, </if> <if test="record.email != null" > email = #{record.email,jdbcType=VARCHAR}, </if> <if test="record.created != null" > created = #{record.created,jdbcType=TIMESTAMP}, </if> <if test="record.updated != null" > updated = #{record.updated,jdbcType=TIMESTAMP}, </if> </set> <if test="_parameter != null" > <include refid="Update_By_Example_Where_Clause" /> </if> </update> <update id="updateByExample" parameterType="map" > update tb_user set id = #{record.id,jdbcType=BIGINT}, username = #{record.username,jdbcType=VARCHAR}, password = #{record.password,jdbcType=VARCHAR}, phone = #{record.phone,jdbcType=VARCHAR}, email = #{record.email,jdbcType=VARCHAR}, created = #{record.created,jdbcType=TIMESTAMP}, updated = #{record.updated,jdbcType=TIMESTAMP} <if test="_parameter != null" > <include refid="Update_By_Example_Where_Clause" /> </if> </update> <update id="updateByPrimaryKeySelective" parameterType="com.taotao.pojo.TbUser" > update tb_user <set > <if test="username != null" > username = #{username,jdbcType=VARCHAR}, </if> <if test="password != null" > password = #{password,jdbcType=VARCHAR}, </if> <if test="phone != null" > phone = #{phone,jdbcType=VARCHAR}, </if> <if test="email != null" > email = #{email,jdbcType=VARCHAR}, </if> <if test="created != null" > created = #{created,jdbcType=TIMESTAMP}, </if> <if test="updated != null" > updated = #{updated,jdbcType=TIMESTAMP}, </if> </set> where id = #{id,jdbcType=BIGINT} </update> <update id="updateByPrimaryKey" parameterType="com.taotao.pojo.TbUser" > update tb_user set username = #{username,jdbcType=VARCHAR}, password = #{password,jdbcType=VARCHAR}, phone = #{phone,jdbcType=VARCHAR}, email = #{email,jdbcType=VARCHAR}, created = #{created,jdbcType=TIMESTAMP}, updated = #{updated,jdbcType=TIMESTAMP} where id = #{id,jdbcType=BIGINT} </update> </mapper>
TestMapper.xml
<?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="com.taotao.mapper.TestMapper"> <select id="queryNow" resultType="string"> select NOW() </select> </mapper>
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
TbContent.java
package com.taotao.pojo; import java.util.Date; public class TbContent { private Long id; private Long categoryId; private String title; private String subTitle; private String titleDesc; private String url; private String pic; private String pic2; private Date created; private Date updated; private String content; public Long getId() { return id; } public void setId(Long id) { this.id = id; } public Long getCategoryId() { return categoryId; } public void setCategoryId(Long categoryId) { this.categoryId = categoryId; } public String getTitle() { return title; } public void setTitle(String title) { this.title = title == null ? null : title.trim(); } public String getSubTitle() { return subTitle; } public void setSubTitle(String subTitle) { this.subTitle = subTitle == null ? null : subTitle.trim(); } public String getTitleDesc() { return titleDesc; } public void setTitleDesc(String titleDesc) { this.titleDesc = titleDesc == null ? null : titleDesc.trim(); } public String getUrl() { return url; } public void setUrl(String url) { this.url = url == null ? null : url.trim(); } public String getPic() { return pic; } public void setPic(String pic) { this.pic = pic == null ? null : pic.trim(); } public String getPic2() { return pic2; } public void setPic2(String pic2) { this.pic2 = pic2 == null ? null : pic2.trim(); } public Date getCreated() { return created; } public void setCreated(Date created) { this.created = created; } public Date getUpdated() { return updated; } public void setUpdated(Date updated) { this.updated = updated; } public String getContent() { return content; } public void setContent(String content) { this.content = content == null ? null : content.trim(); } }
TbContentCategory.java
package com.taotao.pojo; import java.util.Date; public class TbContentCategory { private Long id; private Long parentId; private String name; private Integer status; private Integer sortOrder; private Boolean isParent; private Date created; private Date updated; public Long getId() { return id; } public void setId(Long id) { this.id = id; } public Long getParentId() { return parentId; } public void setParentId(Long parentId) { this.parentId = parentId; } public String getName() { return name; } public void setName(String name) { this.name = name == null ? null : name.trim(); } public Integer getStatus() { return status; } public void setStatus(Integer status) { this.status = status; } public Integer getSortOrder() { return sortOrder; } public void setSortOrder(Integer sortOrder) { this.sortOrder = sortOrder; } public Boolean getIsParent() { return isParent; } public void setIsParent(Boolean isParent) { this.isParent = isParent; } public Date getCreated() { return created; } public void setCreated(Date created) { this.created = created; } public Date getUpdated() { return updated; } public void setUpdated(Date updated) { this.updated = updated; } }
TbContentCategoryExample.java
package com.taotao.pojo; import java.util.ArrayList; import java.util.Date; import java.util.List; public class TbContentCategoryExample { protected String orderByClause; protected boolean distinct; protected List<Criteria> oredCriteria; public TbContentCategoryExample() { oredCriteria = new ArrayList<Criteria>(); } public void setOrderByClause(String orderByClause) { this.orderByClause = orderByClause; } public String getOrderByClause() { return orderByClause; } public void setDistinct(boolean distinct) { this.distinct = distinct; } public boolean isDistinct() { return distinct; } public List<Criteria> getOredCriteria() { return oredCriteria; } public void or(Criteria criteria) { oredCriteria.add(criteria); } public Criteria or() { Criteria criteria = createCriteriaInternal(); oredCriteria.add(criteria); return criteria; } public Criteria createCriteria() { Criteria criteria = createCriteriaInternal(); if (oredCriteria.size() == 0) { oredCriteria.add(criteria); } return criteria; } protected Criteria createCriteriaInternal() { Criteria criteria = new Criteria(); return criteria; } public void clear() { oredCriteria.clear(); orderByClause = null; distinct = false; } protected abstract static class GeneratedCriteria { protected List<Criterion> criteria; protected GeneratedCriteria() { super(); criteria = new ArrayList<Criterion>(); } public boolean isValid() { return criteria.size() > 0; } public List<Criterion> getAllCriteria() { return criteria; } public List<Criterion> getCriteria() { return criteria; } protected void addCriterion(String condition) { if (condition == null) { throw new RuntimeException("Value for condition cannot be null"); } criteria.add(new Criterion(condition)); } protected void addCriterion(String condition, Object value, String property) { if (value == null) { throw new RuntimeException("Value for " + property + " cannot be null"); } criteria.add(new Criterion(condition, value)); } protected void addCriterion(String condition, Object value1, Object value2, String property) { if (value1 == null || value2 == null) { throw new RuntimeException("Between values for " + property + " cannot be null"); } criteria.add(new Criterion(condition, value1, value2)); } public Criteria andIdIsNull() { addCriterion("id is null"); return (Criteria) this; } public Criteria andIdIsNotNull() { addCriterion("id is not null"); return (Criteria) this; } public Criteria andIdEqualTo(Long value) { addCriterion("id =", value, "id"); return (Criteria) this; } public Criteria andIdNotEqualTo(Long value) { addCriterion("id <>", value, "id"); return (Criteria) this; } public Criteria andIdGreaterThan(Long value) { addCriterion("id >", value, "id"); return (Criteria) this; } public Criteria andIdGreaterThanOrEqualTo(Long value) { addCriterion("id >=", value, "id"); return (Criteria) this; } public Criteria andIdLessThan(Long value) { addCriterion("id <", value, "id"); return (Criteria) this; } public Criteria andIdLessThanOrEqualTo(Long value) { addCriterion("id <=", value, "id"); return (Criteria) this; } public Criteria andIdIn(List<Long> values) { addCriterion("id in", values, "id"); return (Criteria) this; } public Criteria andIdNotIn(List<Long> values) { addCriterion("id not in", values, "id"); return (Criteria) this; } public Criteria andIdBetween(Long value1, Long value2) { addCriterion("id between", value1, value2, "id"); return (Criteria) this; } public Criteria andIdNotBetween(Long value1, Long value2) { addCriterion("id not between", value1, value2, "id"); return (Criteria) this; } public Criteria andParentIdIsNull() { addCriterion("parent_id is null"); return (Criteria) this; } public Criteria andParentIdIsNotNull() { addCriterion("parent_id is not null"); return (Criteria) this; } public Criteria andParentIdEqualTo(Long value) { addCriterion("parent_id =", value, "parentId"); return (Criteria) this; } public Criteria andParentIdNotEqualTo(Long value) { addCriterion("parent_id <>", value, "parentId"); return (Criteria) this; } public Criteria andParentIdGreaterThan(Long value) { addCriterion("parent_id >", value, "parentId"); return (Criteria) this; } public Criteria andParentIdGreaterThanOrEqualTo(Long value) { addCriterion("parent_id >=", value, "parentId"); return (Criteria) this; } public Criteria andParentIdLessThan(Long value) { addCriterion("parent_id <", value, "parentId"); return (Criteria) this; } public Criteria andParentIdLessThanOrEqualTo(Long value) { addCriterion("parent_id <=", value, "parentId"); return (Criteria) this; } public Criteria andParentIdIn(List<Long> values) { addCriterion("parent_id in", values, "parentId"); return (Criteria) this; } public Criteria andParentIdNotIn(List<Long> values) { addCriterion("parent_id not in", values, "parentId"); return (Criteria) this; } public Criteria andParentIdBetween(Long value1, Long value2) { addCriterion("parent_id between", value1, value2, "parentId"); return (Criteria) this; } public Criteria andParentIdNotBetween(Long value1, Long value2) { addCriterion("parent_id not between", value1, value2, "parentId"); return (Criteria) this; } public Criteria andNameIsNull() { addCriterion("name is null"); return (Criteria) this; } public Criteria andNameIsNotNull() { addCriterion("name is not null"); return (Criteria) this; } public Criteria andNameEqualTo(String value) { addCriterion("name =", value, "name"); return (Criteria) this; } public Criteria andNameNotEqualTo(String value) { addCriterion("name <>", value, "name"); return (Criteria) this; } public Criteria andNameGreaterThan(String value) { addCriterion("name >", value, "name"); return (Criteria) this; } public Criteria andNameGreaterThanOrEqualTo(String value) { addCriterion("name >=", value, "name"); return (Criteria) this; } public Criteria andNameLessThan(String value) { addCriterion("name <", value, "name"); return (Criteria) this; } public Criteria andNameLessThanOrEqualTo(String value) { addCriterion("name <=", value, "name"); return (Criteria) this; } public Criteria andNameLike(String value) { addCriterion("name like", value, "name"); return (Criteria) this; } public Criteria andNameNotLike(String value) { addCriterion("name not like", value, "name"); return (Criteria) this; } public Criteria andNameIn(List<String> values) { addCriterion("name in", values, "name"); return (Criteria) this; } public Criteria andNameNotIn(List<String> values) { addCriterion("name not in", values, "name"); return (Criteria) this; } public Criteria andNameBetween(String value1, String value2) { addCriterion("name between", value1, value2, "name"); return (Criteria) this; } public Criteria andNameNotBetween(String value1, String value2) { addCriterion("name not between", value1, value2, "name"); return (Criteria) this; } public Criteria andStatusIsNull() { addCriterion("status is null"); return (Criteria) this; } public Criteria andStatusIsNotNull() { addCriterion("status is not null"); return (Criteria) this; } public Criteria andStatusEqualTo(Integer value) { addCriterion("status =", value, "status"); return (Criteria) this; } public Criteria andStatusNotEqualTo(Integer value) { addCriterion("status <>", value, "status"); return (Criteria) this; } public Criteria andStatusGreaterThan(Integer value) { addCriterion("status >", value, "status"); return (Criteria) this; } public Criteria andStatusGreaterThanOrEqualTo(Integer value) { addCriterion("status >=", value, "status"); return (Criteria) this; } public Criteria andStatusLessThan(Integer value) { addCriterion("status <", value, "status"); return (Criteria) this; } public Criteria andStatusLessThanOrEqualTo(Integer value) { addCriterion("status <=", value, "status"); return (Criteria) this; } public Criteria andStatusIn(List<Integer> values) { addCriterion("status in", values, "status"); return (Criteria) this; } public Criteria andStatusNotIn(List<Integer> values) { addCriterion("status not in", values, "status"); return (Criteria) this; } public Criteria andStatusBetween(Integer value1, Integer value2) { addCriterion("status between", value1, value2, "status"); return (Criteria) this; } public Criteria andStatusNotBetween(Integer value1, Integer value2) { addCriterion("status not between", value1, value2, "status"); return (Criteria) this; } public Criteria andSortOrderIsNull() { addCriterion("sort_order is null"); return (Criteria) this; } public Criteria andSortOrderIsNotNull() { addCriterion("sort_order is not null"); return (Criteria) this; } public Criteria andSortOrderEqualTo(Integer value) { addCriterion("sort_order =", value, "sortOrder"); return (Criteria) this; } public Criteria andSortOrderNotEqualTo(Integer value) { addCriterion("sort_order <>", value, "sortOrder"); return (Criteria) this; } public Criteria andSortOrderGreaterThan(Integer value) { addCriterion("sort_order >", value, "sortOrder"); return (Criteria) this; } public Criteria andSortOrderGreaterThanOrEqualTo(Integer value) { addCriterion("sort_order >=", value, "sortOrder"); return (Criteria) this; } public Criteria andSortOrderLessThan(Integer value) { addCriterion("sort_order <", value, "sortOrder"); return (Criteria) this; } public Criteria andSortOrderLessThanOrEqualTo(Integer value) { addCriterion("sort_order <=", value, "sortOrder"); return (Criteria) this; } public Criteria andSortOrderIn(List<Integer> values) { addCriterion("sort_order in", values, "sortOrder"); return (Criteria) this; } public Criteria andSortOrderNotIn(List<Integer> values) { addCriterion("sort_order not in", values, "sortOrder"); return (Criteria) this; } public Criteria andSortOrderBetween(Integer value1, Integer value2) { addCriterion("sort_order between", value1, value2, "sortOrder"); return (Criteria) this; } public Criteria andSortOrderNotBetween(Integer value1, Integer value2) { addCriterion("sort_order not between", value1, value2, "sortOrder"); return (Criteria) this; } public Criteria andIsParentIsNull() { addCriterion("is_parent is null"); return (Criteria) this; } public Criteria andIsParentIsNotNull() { addCriterion("is_parent is not null"); return (Criteria) this; } public Criteria andIsParentEqualTo(Boolean value) { addCriterion("is_parent =", value, "isParent"); return (Criteria) this; } public Criteria andIsParentNotEqualTo(Boolean value) { addCriterion("is_parent <>", value, "isParent"); return (Criteria) this; } public Criteria andIsParentGreaterThan(Boolean value) { addCriterion("is_parent >", value, "isParent"); return (Criteria) this; } public Criteria andIsParentGreaterThanOrEqualTo(Boolean value) { addCriterion("is_parent >=", value, "isParent"); return (Criteria) this; } public Criteria andIsParentLessThan(Boolean value) { addCriterion("is_parent <", value, "isParent"); return (Criteria) this; } public Criteria andIsParentLessThanOrEqualTo(Boolean value) { addCriterion("is_parent <=", value, "isParent"); return (Criteria) this; } public Criteria andIsParentIn(List<Boolean> values) { addCriterion("is_parent in", values, "isParent"); return (Criteria) this; } public Criteria andIsParentNotIn(List<Boolean> values) { addCriterion("is_parent not in", values, "isParent"); return (Criteria) this; } public Criteria andIsParentBetween(Boolean value1, Boolean value2) { addCriterion("is_parent between", value1, value2, "isParent"); return (Criteria) this; } public Criteria andIsParentNotBetween(Boolean value1, Boolean value2) { addCriterion("is_parent not between", value1, value2, "isParent"); return (Criteria) this; } public Criteria andCreatedIsNull() { addCriterion("created is null"); return (Criteria) this; } public Criteria andCreatedIsNotNull() { addCriterion("created is not null"); return (Criteria) this; } public Criteria andCreatedEqualTo(Date value) { addCriterion("created =", value, "created"); return (Criteria) this; } public Criteria andCreatedNotEqualTo(Date value) { addCriterion("created <>", value, "created"); return (Criteria) this; } public Criteria andCreatedGreaterThan(Date value) { addCriterion("created >", value, "created"); return (Criteria) this; } public Criteria andCreatedGreaterThanOrEqualTo(Date value) { addCriterion("created >=", value, "created"); return (Criteria) this; } public Criteria andCreatedLessThan(Date value) { addCriterion("created <", value, "created"); return (Criteria) this; } public Criteria andCreatedLessThanOrEqualTo(Date value) { addCriterion("created <=", value, "created"); return (Criteria) this; } public Criteria andCreatedIn(List<Date> values) { addCriterion("created in", values, "created"); return (Criteria) this; } public Criteria andCreatedNotIn(List<Date> values) { addCriterion("created not in", values, "created"); return (Criteria) this; } public Criteria andCreatedBetween(Date value1, Date value2) { addCriterion("created between", value1, value2, "created"); return (Criteria) this; } public Criteria andCreatedNotBetween(Date value1, Date value2) { addCriterion("created not between", value1, value2, "created"); return (Criteria) this; } public Criteria andUpdatedIsNull() { addCriterion("updated is null"); return (Criteria) this; } public Criteria andUpdatedIsNotNull() { addCriterion("updated is not null"); return (Criteria) this; } public Criteria andUpdatedEqualTo(Date value) { addCriterion("updated =", value, "updated"); return (Criteria) this; } public Criteria andUpdatedNotEqualTo(Date value) { addCriterion("updated <>", value, "updated"); return (Criteria) this; } public Criteria andUpdatedGreaterThan(Date value) { addCriterion("updated >", value, "updated"); return (Criteria) this; } public Criteria andUpdatedGreaterThanOrEqualTo(Date value) { addCriterion("updated >=", value, "updated"); return (Criteria) this; } public Criteria andUpdatedLessThan(Date value) { addCriterion("updated <", value, "updated"); return (Criteria) this; } public Criteria andUpdatedLessThanOrEqualTo(Date value) { addCriterion("updated <=", value, "updated"); return (Criteria) this; } public Criteria andUpdatedIn(List<Date> values) { addCriterion("updated in", values, "updated"); return (Criteria) this; } public Criteria andUpdatedNotIn(List<Date> values) { addCriterion("updated not in", values, "updated"); return (Criteria) this; } public Criteria andUpdatedBetween(Date value1, Date value2) { addCriterion("updated between", value1, value2, "updated"); return (Criteria) this; } public Criteria andUpdatedNotBetween(Date value1, Date value2) { addCriterion("updated not between", value1, value2, "updated"); return (Criteria) this; } } public static class Criteria extends GeneratedCriteria { protected Criteria() { super(); } } public static class Criterion { private String condition; private Object value; private Object secondValue; private boolean noValue; private boolean singleValue; private boolean betweenValue; private boolean listValue; private String typeHandler; public String getCondition() { return condition; } public Object getValue() { return value; } public Object getSecondValue() { return secondValue; } public boolean isNoValue() { return noValue; } public boolean isSingleValue() { return singleValue; } public boolean isBetweenValue() { return betweenValue; } public boolean isListValue() { return listValue; } public String getTypeHandler() { return typeHandler; } protected Criterion(String condition) { super(); this.condition = condition; this.typeHandler = null; this.noValue = true; } protected Criterion(String condition, Object value, String typeHandler) { super(); this.condition = condition; this.value = value; this.typeHandler = typeHandler; if (value instanceof List<?>) { this.listValue = true; } else { this.singleValue = true; } } protected Criterion(String condition, Object value) { this(condition, value, null); } protected Criterion(String condition, Object value, Object secondValue, String typeHandler) { super(); this.condition = condition; this.value = value; this.secondValue = secondValue; this.typeHandler = typeHandler; this.betweenValue = true; } protected Criterion(String condition, Object value, Object secondValue) { this(condition, value, secondValue, null); } } }
TbContentExample.java
package com.taotao.pojo; import java.util.ArrayList; import java.util.Date; import java.util.List; public class TbContentExample { protected String orderByClause; protected boolean distinct; protected List<Criteria> oredCriteria; public TbContentExample() { oredCriteria = new ArrayList<Criteria>(); } public void setOrderByClause(String orderByClause) { this.orderByClause = orderByClause; } public String getOrderByClause() { return orderByClause; } public void setDistinct(boolean distinct) { this.distinct = distinct; } public boolean isDistinct() { return distinct; } public List<Criteria> getOredCriteria() { return oredCriteria; } public void or(Criteria criteria) { oredCriteria.add(criteria); } public Criteria or() { Criteria criteria = createCriteriaInternal(); oredCriteria.add(criteria); return criteria; } public Criteria createCriteria() { Criteria criteria = createCriteriaInternal(); if (oredCriteria.size() == 0) { oredCriteria.add(criteria); } return criteria; } protected Criteria createCriteriaInternal() { Criteria criteria = new Criteria(); return criteria; } public void clear() { oredCriteria.clear(); orderByClause = null; distinct = false; } protected abstract static class GeneratedCriteria { protected List<Criterion> criteria; protected GeneratedCriteria() { super(); criteria = new ArrayList<Criterion>(); } public boolean isValid() { return criteria.size() > 0; } public List<Criterion> getAllCriteria() { return criteria; } public List<Criterion> getCriteria() { return criteria; } protected void addCriterion(String condition) { if (condition == null) { throw new RuntimeException("Value for condition cannot be null"); } criteria.add(new Criterion(condition)); } protected void addCriterion(String condition, Object value, String property) { if (value == null) { throw new RuntimeException("Value for " + property + " cannot be null"); } criteria.add(new Criterion(condition, value)); } protected void addCriterion(String condition, Object value1, Object value2, String property) { if (value1 == null || value2 == null) { throw new RuntimeException("Between values for " + property + " cannot be null"); } criteria.add(new Criterion(condition, value1, value2)); } public Criteria andIdIsNull() { addCriterion("id is null"); return (Criteria) this; } public Criteria andIdIsNotNull() { addCriterion("id is not null"); return (Criteria) this; } public Criteria andIdEqualTo(Long value) { addCriterion("id =", value, "id"); return (Criteria) this; } public Criteria andIdNotEqualTo(Long value) { addCriterion("id <>", value, "id"); return (Criteria) this; } public Criteria andIdGreaterThan(Long value) { addCriterion("id >", value, "id"); return (Criteria) this; } public Criteria andIdGreaterThanOrEqualTo(Long value) { addCriterion("id >=", value, "id"); return (Criteria) this; } public Criteria andIdLessThan(Long value) { addCriterion("id <", value, "id"); return (Criteria) this; } public Criteria andIdLessThanOrEqualTo(Long value) { addCriterion("id <=", value, "id"); return (Criteria) this; } public Criteria andIdIn(List<Long> values) { addCriterion("id in", values, "id"); return (Criteria) this; } public Criteria andIdNotIn(List<Long> values) { addCriterion("id not in", values, "id"); return (Criteria) this; } public Criteria andIdBetween(Long value1, Long value2) { addCriterion("id between", value1, value2, "id"); return (Criteria) this; } public Criteria andIdNotBetween(Long value1, Long value2) { addCriterion("id not between", value1, value2, "id"); return (Criteria) this; } public Criteria andCategoryIdIsNull() { addCriterion("category_id is null"); return (Criteria) this; } public Criteria andCategoryIdIsNotNull() { addCriterion("category_id is not null"); return (Criteria) this; } public Criteria andCategoryIdEqualTo(Long value) { addCriterion("category_id =", value, "categoryId"); return (Criteria) this; } public Criteria andCategoryIdNotEqualTo(Long value) { addCriterion("category_id <>", value, "categoryId"); return (Criteria) this; } public Criteria andCategoryIdGreaterThan(Long value) { addCriterion("category_id >", value, "categoryId"); return (Criteria) this; } public Criteria andCategoryIdGreaterThanOrEqualTo(Long value) { addCriterion("category_id >=", value, "categoryId"); return (Criteria) this; } public Criteria andCategoryIdLessThan(Long value) { addCriterion("category_id <", value, "categoryId"); return (Criteria) this; } public Criteria andCategoryIdLessThanOrEqualTo(Long value) { addCriterion("category_id <=", value, "categoryId"); return (Criteria) this; } public Criteria andCategoryIdIn(List<Long> values) { addCriterion("category_id in", values, "categoryId"); return (Criteria) this; } public Criteria andCategoryIdNotIn(List<Long> values) { addCriterion("category_id not in", values, "categoryId"); return (Criteria) this; } public Criteria andCategoryIdBetween(Long value1, Long value2) { addCriterion("category_id between", value1, value2, "categoryId"); return (Criteria) this; } public Criteria andCategoryIdNotBetween(Long value1, Long value2) { addCriterion("category_id not between", value1, value2, "categoryId"); return (Criteria) this; } public Criteria andTitleIsNull() { addCriterion("title is null"); return (Criteria) this; } public Criteria andTitleIsNotNull() { addCriterion("title is not null"); return (Criteria) this; } public Criteria andTitleEqualTo(String value) { addCriterion("title =", value, "title"); return (Criteria) this; } public Criteria andTitleNotEqualTo(String value) { addCriterion("title <>", value, "title"); return (Criteria) this; } public Criteria andTitleGreaterThan(String value) { addCriterion("title >", value, "title"); return (Criteria) this; } public Criteria andTitleGreaterThanOrEqualTo(String value) { addCriterion("title >=", value, "title"); return (Criteria) this; } public Criteria andTitleLessThan(String value) { addCriterion("title <", value, "title"); return (Criteria) this; } public Criteria andTitleLessThanOrEqualTo(String value) { addCriterion("title <=", value, "title"); return (Criteria) this; } public Criteria andTitleLike(String value) { addCriterion("title like", value, "title"); return (Criteria) this; } public Criteria andTitleNotLike(String value) { addCriterion("title not like", value, "title"); return (Criteria) this; } public Criteria andTitleIn(List<String> values) { addCriterion("title in", values, "title"); return (Criteria) this; } public Criteria andTitleNotIn(List<String> values) { addCriterion("title not in", values, "title"); return (Criteria) this; } public Criteria andTitleBetween(String value1, String value2) { addCriterion("title between", value1, value2, "title"); return (Criteria) this; } public Criteria andTitleNotBetween(String value1, String value2) { addCriterion("title not between", value1, value2, "title"); return (Criteria) this; } public Criteria andSubTitleIsNull() { addCriterion("sub_title is null"); return (Criteria) this; } public Criteria andSubTitleIsNotNull() { addCriterion("sub_title is not null"); return (Criteria) this; } public Criteria andSubTitleEqualTo(String value) { addCriterion("sub_title =", value, "subTitle"); return (Criteria) this; } public Criteria andSubTitleNotEqualTo(String value) { addCriterion("sub_title <>", value, "subTitle"); return (Criteria) this; } public Criteria andSubTitleGreaterThan(String value) { addCriterion("sub_title >", value, "subTitle"); return (Criteria) this; } public Criteria andSubTitleGreaterThanOrEqualTo(String value) { addCriterion("sub_title >=", value, "subTitle"); return (Criteria) this; } public Criteria andSubTitleLessThan(String value) { addCriterion("sub_title <", value, "subTitle"); return (Criteria) this; } public Criteria andSubTitleLessThanOrEqualTo(String value) { addCriterion("sub_title <=", value, "subTitle"); return (Criteria) this; } public Criteria andSubTitleLike(String value) { addCriterion("sub_title like", value, "subTitle"); return (Criteria) this; } public Criteria andSubTitleNotLike(String value) { addCriterion("sub_title not like", value, "subTitle"); return (Criteria) this; } public Criteria andSubTitleIn(List<String> values) { addCriterion("sub_title in", values, "subTitle"); return (Criteria) this; } public Criteria andSubTitleNotIn(List<String> values) { addCriterion("sub_title not in", values, "subTitle"); return (Criteria) this; } public Criteria andSubTitleBetween(String value1, String value2) { addCriterion("sub_title between", value1, value2, "subTitle"); return (Criteria) this; } public Criteria andSubTitleNotBetween(String value1, String value2) { addCriterion("sub_title not between", value1, value2, "subTitle"); return (Criteria) this; } public Criteria andTitleDescIsNull() { addCriterion("title_desc is null"); return (Criteria) this; } public Criteria andTitleDescIsNotNull() { addCriterion("title_desc is not null"); return (Criteria) this; } public Criteria andTitleDescEqualTo(String value) { addCriterion("title_desc =", value, "titleDesc"); return (Criteria) this; } public Criteria andTitleDescNotEqualTo(String value) { addCriterion("title_desc <>", value, "titleDesc"); return (Criteria) this; } public Criteria andTitleDescGreaterThan(String value) { addCriterion("title_desc >", value, "titleDesc"); return (Criteria) this; } public Criteria andTitleDescGreaterThanOrEqualTo(String value) { addCriterion("title_desc >=", value, "titleDesc"); return (Criteria) this; } public Criteria andTitleDescLessThan(String value) { addCriterion("title_desc <", value, "titleDesc"); return (Criteria) this; } public Criteria andTitleDescLessThanOrEqualTo(String value) { addCriterion("title_desc <=", value, "titleDesc"); return (Criteria) this; } public Criteria andTitleDescLike(String value) { addCriterion("title_desc like", value, "titleDesc"); return (Criteria) this; } public Criteria andTitleDescNotLike(String value) { addCriterion("title_desc not like", value, "titleDesc"); return (Criteria) this; } public Criteria andTitleDescIn(List<String> values) { addCriterion("title_desc in", values, "titleDesc"); return (Criteria) this; } public Criteria andTitleDescNotIn(List<String> values) { addCriterion("title_desc not in", values, "titleDesc"); return (Criteria) this; } public Criteria andTitleDescBetween(String value1, String value2) { addCriterion("title_desc between", value1, value2, "titleDesc"); return (Criteria) this; } public Criteria andTitleDescNotBetween(String value1, String value2) { addCriterion("title_desc not between", value1, value2, "titleDesc"); return (Criteria) this; } public Criteria andUrlIsNull() { addCriterion("url is null"); return (Criteria) this; } public Criteria andUrlIsNotNull() { addCriterion("url is not null"); return (Criteria) this; } public Criteria andUrlEqualTo(String value) { addCriterion("url =", value, "url"); return (Criteria) this; } public Criteria andUrlNotEqualTo(String value) { addCriterion("url <>", value, "url"); return (Criteria) this; } public Criteria andUrlGreaterThan(String value) { addCriterion("url >", value, "url"); return (Criteria) this; } public Criteria andUrlGreaterThanOrEqualTo(String value) { addCriterion("url >=", value, "url"); return (Criteria) this; } public Criteria andUrlLessThan(String value) { addCriterion("url <", value, "url"); return (Criteria) this; } public Criteria andUrlLessThanOrEqualTo(String value) { addCriterion("url <=", value, "url"); return (Criteria) this; } public Criteria andUrlLike(String value) { addCriterion("url like", value, "url"); return (Criteria) this; } public Criteria andUrlNotLike(String value) { addCriterion("url not like", value, "url"); return (Criteria) this; } public Criteria andUrlIn(List<String> values) { addCriterion("url in", values, "url"); return (Criteria) this; } public Criteria andUrlNotIn(List<String> values) { addCriterion("url not in", values, "url"); return (Criteria) this; } public Criteria andUrlBetween(String value1, String value2) { addCriterion("url between", value1, value2, "url"); return (Criteria) this; } public Criteria andUrlNotBetween(String value1, String value2) { addCriterion("url not between", value1, value2, "url"); return (Criteria) this; } public Criteria andPicIsNull() { addCriterion("pic is null"); return (Criteria) this; } public Criteria andPicIsNotNull() { addCriterion("pic is not null"); return (Criteria) this; } public Criteria andPicEqualTo(String value) { addCriterion("pic =", value, "pic"); return (Criteria) this; } public Criteria andPicNotEqualTo(String value) { addCriterion("pic <>", value, "pic"); return (Criteria) this; } public Criteria andPicGreaterThan(String value) { addCriterion("pic >", value, "pic"); return (Criteria) this; } public Criteria andPicGreaterThanOrEqualTo(String value) { addCriterion("pic >=", value, "pic"); return (Criteria) this; } public Criteria andPicLessThan(String value) { addCriterion("pic <", value, "pic"); return (Criteria) this; } public Criteria andPicLessThanOrEqualTo(String value) { addCriterion("pic <=", value, "pic"); return (Criteria) this; } public Criteria andPicLike(String value) { addCriterion("pic like", value, "pic"); return (Criteria) this; } public Criteria andPicNotLike(String value) { addCriterion("pic not like", value, "pic"); return (Criteria) this; } public Criteria andPicIn(List<String> values) { addCriterion("pic in", values, "pic"); return (Criteria) this; } public Criteria andPicNotIn(List<String> values) { addCriterion("pic not in", values, "pic"); return (Criteria) this; } public Criteria andPicBetween(String value1, String value2) { addCriterion("pic between", value1, value2, "pic"); return (Criteria) this; } public Criteria andPicNotBetween(String value1, String value2) { addCriterion("pic not between", value1, value2, "pic"); return (Criteria) this; } public Criteria andPic2IsNull() { addCriterion("pic2 is null"); return (Criteria) this; } public Criteria andPic2IsNotNull() { addCriterion("pic2 is not null"); return (Criteria) this; } public Criteria andPic2EqualTo(String value) { addCriterion("pic2 =", value, "pic2"); return (Criteria) this; } public Criteria andPic2NotEqualTo(String value) { addCriterion("pic2 <>", value, "pic2"); return (Criteria) this; } public Criteria andPic2GreaterThan(String value) { addCriterion("pic2 >", value, "pic2"); return (Criteria) this; } public Criteria andPic2GreaterThanOrEqualTo(String value) { addCriterion("pic2 >=", value, "pic2"); return (Criteria) this; } public Criteria andPic2LessThan(String value) { addCriterion("pic2 <", value, "pic2"); return (Criteria) this; } public Criteria andPic2LessThanOrEqualTo(String value) { addCriterion("pic2 <=", value, "pic2"); return (Criteria) this; } public Criteria andPic2Like(String value) { addCriterion("pic2 like", value, "pic2"); return (Criteria) this; } public Criteria andPic2NotLike(String value) { addCriterion("pic2 not like", value, "pic2"); return (Criteria) this; } public Criteria andPic2In(List<String> values) { addCriterion("pic2 in", values, "pic2"); return (Criteria) this; } public Criteria andPic2NotIn(List<String> values) { addCriterion("pic2 not in", values, "pic2"); return (Criteria) this; } public Criteria andPic2Between(String value1, String value2) { addCriterion("pic2 between", value1, value2, "pic2"); return (Criteria) this; } public Criteria andPic2NotBetween(String value1, String value2) { addCriterion("pic2 not between", value1, value2, "pic2"); return (Criteria) this; } public Criteria andCreatedIsNull() { addCriterion("created is null"); return (Criteria) this; } public Criteria andCreatedIsNotNull() { addCriterion("created is not null"); return (Criteria) this; } public Criteria andCreatedEqualTo(Date value) { addCriterion("created =", value, "created"); return (Criteria) this; } public Criteria andCreatedNotEqualTo(Date value) { addCriterion("created <>", value, "created"); return (Criteria) this; } public Criteria andCreatedGreaterThan(Date value) { addCriterion("created >", value, "created"); return (Criteria) this; } public Criteria andCreatedGreaterThanOrEqualTo(Date value) { addCriterion("created >=", value, "created"); return (Criteria) this; } public Criteria andCreatedLessThan(Date value) { addCriterion("created <", value, "created"); return (Criteria) this; } public Criteria andCreatedLessThanOrEqualTo(Date value) { addCriterion("created <=", value, "created"); return (Criteria) this; } public Criteria andCreatedIn(List<Date> values) { addCriterion("created in", values, "created"); return (Criteria) this; } public Criteria andCreatedNotIn(List<Date> values) { addCriterion("created not in", values, "created"); return (Criteria) this; } public Criteria andCreatedBetween(Date value1, Date value2) { addCriterion("created between", value1, value2, "created"); return (Criteria) this; } public Criteria andCreatedNotBetween(Date value1, Date value2) { addCriterion("created not between", value1, value2, "created"); return (Criteria) this; } public Criteria andUpdatedIsNull() { addCriterion("updated is null"); return (Criteria) this; } public Criteria andUpdatedIsNotNull() { addCriterion("updated is not null"); return (Criteria) this; } public Criteria andUpdatedEqualTo(Date value) { addCriterion("updated =", value, "updated"); return (Criteria) this; } public Criteria andUpdatedNotEqualTo(Date value) { addCriterion("updated <>", value, "updated"); return (Criteria) this; } public Criteria andUpdatedGreaterThan(Date value) { addCriterion("updated >", value, "updated"); return (Criteria) this; } public Criteria andUpdatedGreaterThanOrEqualTo(Date value) { addCriterion("updated >=", value, "updated"); return (Criteria) this; } public Criteria andUpdatedLessThan(Date value) { addCriterion("updated <", value, "updated"); return (Criteria) this; } public Criteria andUpdatedLessThanOrEqualTo(Date value) { addCriterion("updated <=", value, "updated"); return (Criteria) this; } public Criteria andUpdatedIn(List<Date> values) { addCriterion("updated in", values, "updated"); return (Criteria) this; } public Criteria andUpdatedNotIn(List<Date> values) { addCriterion("updated not in", values, "updated"); return (Criteria) this; } public Criteria andUpdatedBetween(Date value1, Date value2) { addCriterion("updated between", value1, value2, "updated"); return (Criteria) this; } public Criteria andUpdatedNotBetween(Date value1, Date value2) { addCriterion("updated not between", value1, value2, "updated"); return (Criteria) this; } } public static class Criteria extends GeneratedCriteria { protected Criteria() { super(); } } public static class Criterion { private String condition; private Object value; private Object secondValue; private boolean noValue; private boolean singleValue; private boolean betweenValue; private boolean listValue; private String typeHandler; public String getCondition() { return condition; } public Object getValue() { return value; } public Object getSecondValue() { return secondValue; } public boolean isNoValue() { return noValue; } public boolean isSingleValue() { return singleValue; } public boolean isBetweenValue() { return betweenValue; } public boolean isListValue() { return listValue; } public String getTypeHandler() { return typeHandler; } protected Criterion(String condition) { super(); this.condition = condition; this.typeHandler = null; this.noValue = true; } protected Criterion(String condition, Object value, String typeHandler) { super(); this.condition = condition; this.value = value; this.typeHandler = typeHandler; if (value instanceof List<?>) { this.listValue = true; } else { this.singleValue = true; } } protected Criterion(String condition, Object value) { this(condition, value, null); } protected Criterion(String condition, Object value, Object secondValue, String typeHandler) { super(); this.condition = condition; this.value = value; this.secondValue = secondValue; this.typeHandler = typeHandler; this.betweenValue = true; } protected Criterion(String condition, Object value, Object secondValue) { this(condition, value, secondValue, null); } } }
TbItem.java
package com.taotao.pojo; import java.io.Serializable; import java.util.Date; public class TbItem implements Serializable{ private Long id; private String title; private String sellPoint; private Long price; private Integer num; private String barcode; private String image; private Long cid; private Byte status; private Date created; private Date updated; public Long getId() { return id; } public void setId(Long id) { this.id = id; } public String getTitle() { return title; } public void setTitle(String title) { this.title = title == null ? null : title.trim(); } public String getSellPoint() { return sellPoint; } public void setSellPoint(String sellPoint) { this.sellPoint = sellPoint == null ? null : sellPoint.trim(); } public Long getPrice() { return price; } public void setPrice(Long price) { this.price = price; } public Integer getNum() { return num; } public void setNum(Integer num) { this.num = num; } public String getBarcode() { return barcode; } public void setBarcode(String barcode) { this.barcode = barcode == null ? null : barcode.trim(); } public String getImage() { return image; } public void setImage(String image) { this.image = image == null ? null : image.trim(); } public Long getCid() { return cid; } public void setCid(Long cid) { this.cid = cid; } public Byte getStatus() { return status; } public void setStatus(Byte status) { this.status = status; } public Date getCreated() { return created; } public void setCreated(Date created) { this.created = created; } public Date getUpdated() { return updated; } public void setUpdated(Date updated) { this.updated = updated; } }
TbItemCat.java
package com.taotao.pojo; import java.util.Date; public class TbItemCat { private Long id; private Long parentId; private String name; private Integer status; private Integer sortOrder; private Boolean isParent; private Date created; private Date updated; public Long getId() { return id; } public void setId(Long id) { this.id = id; } public Long getParentId() { return parentId; } public void setParentId(Long parentId) { this.parentId = parentId; } public String getName() { return name; } public void setName(String name) { this.name = name == null ? null : name.trim(); } public Integer getStatus() { return status; } public void setStatus(Integer status) { this.status = status; } public Integer getSortOrder() { return sortOrder; } public void setSortOrder(Integer sortOrder) { this.sortOrder = sortOrder; } public Boolean getIsParent() { return isParent; } public void setIsParent(Boolean isParent) { this.isParent = isParent; } public Date getCreated() { return created; } public void setCreated(Date created) { this.created = created; } public Date getUpdated() { return updated; } public void setUpdated(Date updated) { this.updated = updated; } }
TbItemCatExample.java
package com.taotao.pojo; import java.util.ArrayList; import java.util.Date; import java.util.List; public class TbItemCatExample { protected String orderByClause; protected boolean distinct; protected List<Criteria> oredCriteria; public TbItemCatExample() { oredCriteria = new ArrayList<Criteria>(); } public void setOrderByClause(String orderByClause) { this.orderByClause = orderByClause; } public String getOrderByClause() { return orderByClause; } public void setDistinct(boolean distinct) { this.distinct = distinct; } public boolean isDistinct() { return distinct; } public List<Criteria> getOredCriteria() { return oredCriteria; } public void or(Criteria criteria) { oredCriteria.add(criteria); } public Criteria or() { Criteria criteria = createCriteriaInternal(); oredCriteria.add(criteria); return criteria; } public Criteria createCriteria() { Criteria criteria = createCriteriaInternal(); if (oredCriteria.size() == 0) { oredCriteria.add(criteria); } return criteria; } protected Criteria createCriteriaInternal() { Criteria criteria = new Criteria(); return criteria; } public void clear() { oredCriteria.clear(); orderByClause = null; distinct = false; } protected abstract static class GeneratedCriteria { protected List<Criterion> criteria; protected GeneratedCriteria() { super(); criteria = new ArrayList<Criterion>(); } public boolean isValid() { return criteria.size() > 0; } public List<Criterion> getAllCriteria() { return criteria; } public List<Criterion> getCriteria() { return criteria; } protected void addCriterion(String condition) { if (condition == null) { throw new RuntimeException("Value for condition cannot be null"); } criteria.add(new Criterion(condition)); } protected void addCriterion(String condition, Object value, String property) { if (value == null) { throw new RuntimeException("Value for " + property + " cannot be null"); } criteria.add(new Criterion(condition, value)); } protected void addCriterion(String condition, Object value1, Object value2, String property) { if (value1 == null || value2 == null) { throw new RuntimeException("Between values for " + property + " cannot be null"); } criteria.add(new Criterion(condition, value1, value2)); } public Criteria andIdIsNull() { addCriterion("id is null"); return (Criteria) this; } public Criteria andIdIsNotNull() { addCriterion("id is not null"); return (Criteria) this; } public Criteria andIdEqualTo(Long value) { addCriterion("id =", value, "id"); return (Criteria) this; } public Criteria andIdNotEqualTo(Long value) { addCriterion("id <>", value, "id"); return (Criteria) this; } public Criteria andIdGreaterThan(Long value) { addCriterion("id >", value, "id"); return (Criteria) this; } public Criteria andIdGreaterThanOrEqualTo(Long value) { addCriterion("id >=", value, "id"); return (Criteria) this; } public Criteria andIdLessThan(Long value) { addCriterion("id <", value, "id"); return (Criteria) this; } public Criteria andIdLessThanOrEqualTo(Long value) { addCriterion("id <=", value, "id"); return (Criteria) this; } public Criteria andIdIn(List<Long> values) { addCriterion("id in", values, "id"); return (Criteria) this; } public Criteria andIdNotIn(List<Long> values) { addCriterion("id not in", values, "id"); return (Criteria) this; } public Criteria andIdBetween(Long value1, Long value2) { addCriterion("id between", value1, value2, "id"); return (Criteria) this; } public Criteria andIdNotBetween(Long value1, Long value2) { addCriterion("id not between", value1, value2, "id"); return (Criteria) this; } public Criteria andParentIdIsNull() { addCriterion("parent_id is null"); return (Criteria) this; } public Criteria andParentIdIsNotNull() { addCriterion("parent_id is not null"); return (Criteria) this; } public Criteria andParentIdEqualTo(Long value) { addCriterion("parent_id =", value, "parentId"); return (Criteria) this; } public Criteria andParentIdNotEqualTo(Long value) { addCriterion("parent_id <>", value, "parentId"); return (Criteria) this; } public Criteria andParentIdGreaterThan(Long value) { addCriterion("parent_id >", value, "parentId"); return (Criteria) this; } public Criteria andParentIdGreaterThanOrEqualTo(Long value) { addCriterion("parent_id >=", value, "parentId"); return (Criteria) this; } public Criteria andParentIdLessThan(Long value) { addCriterion("parent_id <", value, "parentId"); return (Criteria) this; } public Criteria andParentIdLessThanOrEqualTo(Long value) { addCriterion("parent_id <=", value, "parentId"); return (Criteria) this; } public Criteria andParentIdIn(List<Long> values) { addCriterion("parent_id in", values, "parentId"); return (Criteria) this; } public Criteria andParentIdNotIn(List<Long> values) { addCriterion("parent_id not in", values, "parentId"); return (Criteria) this; } public Criteria andParentIdBetween(Long value1, Long value2) { addCriterion("parent_id between", value1, value2, "parentId"); return (Criteria) this; } public Criteria andParentIdNotBetween(Long value1, Long value2) { addCriterion("parent_id not between", value1, value2, "parentId"); return (Criteria) this; } public Criteria andNameIsNull() { addCriterion("name is null"); return (Criteria) this; } public Criteria andNameIsNotNull() { addCriterion("name is not null"); return (Criteria) this; } public Criteria andNameEqualTo(String value) { addCriterion("name =", value, "name"); return (Criteria) this; } public Criteria andNameNotEqualTo(String value) { addCriterion("name <>", value, "name"); return (Criteria) this; } public Criteria andNameGreaterThan(String value) { addCriterion("name >", value, "name"); return (Criteria) this; } public Criteria andNameGreaterThanOrEqualTo(String value) { addCriterion("name >=", value, "name"); return (Criteria) this; } public Criteria andNameLessThan(String value) { addCriterion("name <", value, "name"); return (Criteria) this; } public Criteria andNameLessThanOrEqualTo(String value) { addCriterion("name <=", value, "name"); return (Criteria) this; } public Criteria andNameLike(String value) { addCriterion("name like", value, "name"); return (Criteria) this; } public Criteria andNameNotLike(String value) { addCriterion("name not like", value, "name"); return (Criteria) this; } public Criteria andNameIn(List<String> values) { addCriterion("name in", values, "name"); return (Criteria) this; } public Criteria andNameNotIn(List<String> values) { addCriterion("name not in", values, "name"); return (Criteria) this; } public Criteria andNameBetween(String value1, String value2) { addCriterion("name between", value1, value2, "name"); return (Criteria) this; } public Criteria andNameNotBetween(String value1, String value2) { addCriterion("name not between", value1, value2, "name"); return (Criteria) this; } public Criteria andStatusIsNull() { addCriterion("status is null"); return (Criteria) this; } public Criteria andStatusIsNotNull() { addCriterion("status is not null"); return (Criteria) this; } public Criteria andStatusEqualTo(Integer value) { addCriterion("status =", value, "status"); return (Criteria) this; } public Criteria andStatusNotEqualTo(Integer value) { addCriterion("status <>", value, "status"); return (Criteria) this; } public Criteria andStatusGreaterThan(Integer value) { addCriterion("status >", value, "status"); return (Criteria) this; } public Criteria andStatusGreaterThanOrEqualTo(Integer value) { addCriterion("status >=", value, "status"); return (Criteria) this; } public Criteria andStatusLessThan(Integer value) { addCriterion("status <", value, "status"); return (Criteria) this; } public Criteria andStatusLessThanOrEqualTo(Integer value) { addCriterion("status <=", value, "status"); return (Criteria) this; } public Criteria andStatusIn(List<Integer> values) { addCriterion("status in", values, "status"); return (Criteria) this; } public Criteria andStatusNotIn(List<Integer> values) { addCriterion("status not in", values, "status"); return (Criteria) this; } public Criteria andStatusBetween(Integer value1, Integer value2) { addCriterion("status between", value1, value2, "status"); return (Criteria) this; } public Criteria andStatusNotBetween(Integer value1, Integer value2) { addCriterion("status not between", value1, value2, "status"); return (Criteria) this; } public Criteria andSortOrderIsNull() { addCriterion("sort_order is null"); return (Criteria) this; } public Criteria andSortOrderIsNotNull() { addCriterion("sort_order is not null"); return (Criteria) this; } public Criteria andSortOrderEqualTo(Integer value) { addCriterion("sort_order =", value, "sortOrder"); return (Criteria) this; } public Criteria andSortOrderNotEqualTo(Integer value) { addCriterion("sort_order <>", value, "sortOrder"); return (Criteria) this; } public Criteria andSortOrderGreaterThan(Integer value) { addCriterion("sort_order >", value, "sortOrder"); return (Criteria) this; } public Criteria andSortOrderGreaterThanOrEqualTo(Integer value) { addCriterion("sort_order >=", value, "sortOrder"); return (Criteria) this; } public Criteria andSortOrderLessThan(Integer value) { addCriterion("sort_order <", value, "sortOrder"); return (Criteria) this; } public Criteria andSortOrderLessThanOrEqualTo(Integer value) { addCriterion("sort_order <=", value, "sortOrder"); return (Criteria) this; } public Criteria andSortOrderIn(List<Integer> values) { addCriterion("sort_order in", values, "sortOrder"); return (Criteria) this; } public Criteria andSortOrderNotIn(List<Integer> values) { addCriterion("sort_order not in", values, "sortOrder"); return (Criteria) this; } public Criteria andSortOrderBetween(Integer value1, Integer value2) { addCriterion("sort_order between", value1, value2, "sortOrder"); return (Criteria) this; } public Criteria andSortOrderNotBetween(Integer value1, Integer value2) { addCriterion("sort_order not between", value1, value2, "sortOrder"); return (Criteria) this; } public Criteria andIsParentIsNull() { addCriterion("is_parent is null"); return (Criteria) this; } public Criteria andIsParentIsNotNull() { addCriterion("is_parent is not null"); return (Criteria) this; } public Criteria andIsParentEqualTo(Boolean value) { addCriterion("is_parent =", value, "isParent"); return (Criteria) this; } public Criteria andIsParentNotEqualTo(Boolean value) { addCriterion("is_parent <>", value, "isParent"); return (Criteria) this; } public Criteria andIsParentGreaterThan(Boolean value) { addCriterion("is_parent >", value, "isParent"); return (Criteria) this; } public Criteria andIsParentGreaterThanOrEqualTo(Boolean value) { addCriterion("is_parent >=", value, "isParent"); return (Criteria) this; } public Criteria andIsParentLessThan(Boolean value) { addCriterion("is_parent <", value, "isParent"); return (Criteria) this; } public Criteria andIsParentLessThanOrEqualTo(Boolean value) { addCriterion("is_parent <=", value, "isParent"); return (Criteria) this; } public Criteria andIsParentIn(List<Boolean> values) { addCriterion("is_parent in", values, "isParent"); return (Criteria) this; } public Criteria andIsParentNotIn(List<Boolean> values) { addCriterion("is_parent not in", values, "isParent"); return (Criteria) this; } public Criteria andIsParentBetween(Boolean value1, Boolean value2) { addCriterion("is_parent between", value1, value2, "isParent"); return (Criteria) this; } public Criteria andIsParentNotBetween(Boolean value1, Boolean value2) { addCriterion("is_parent not between", value1, value2, "isParent"); return (Criteria) this; } public Criteria andCreatedIsNull() { addCriterion("created is null"); return (Criteria) this; } public Criteria andCreatedIsNotNull() { addCriterion("created is not null"); return (Criteria) this; } public Criteria andCreatedEqualTo(Date value) { addCriterion("created =", value, "created"); return (Criteria) this; } public Criteria andCreatedNotEqualTo(Date value) { addCriterion("created <>", value, "created"); return (Criteria) this; } public Criteria andCreatedGreaterThan(Date value) { addCriterion("created >", value, "created"); return (Criteria) this; } public Criteria andCreatedGreaterThanOrEqualTo(Date value) { addCriterion("created >=", value, "created"); return (Criteria) this; } public Criteria andCreatedLessThan(Date value) { addCriterion("created <", value, "created"); return (Criteria) this; } public Criteria andCreatedLessThanOrEqualTo(Date value) { addCriterion("created <=", value, "created"); return (Criteria) this; } public Criteria andCreatedIn(List<Date> values) { addCriterion("created in", values, "created"); return (Criteria) this; } public Criteria andCreatedNotIn(List<Date> values) { addCriterion("created not in", values, "created"); return (Criteria) this; } public Criteria andCreatedBetween(Date value1, Date value2) { addCriterion("created between", value1, value2, "created"); return (Criteria) this; } public Criteria andCreatedNotBetween(Date value1, Date value2) { addCriterion("created not between", value1, value2, "created"); return (Criteria) this; } public Criteria andUpdatedIsNull() { addCriterion("updated is null"); return (Criteria) this; } public Criteria andUpdatedIsNotNull() { addCriterion("updated is not null"); return (Criteria) this; } public Criteria andUpdatedEqualTo(Date value) { addCriterion("updated =", value, "updated"); return (Criteria) this; } public Criteria andUpdatedNotEqualTo(Date value) { addCriterion("updated <>", value, "updated"); return (Criteria) this; } public Criteria andUpdatedGreaterThan(Date value) { addCriterion("updated >", value, "updated"); return (Criteria) this; } public Criteria andUpdatedGreaterThanOrEqualTo(Date value) { addCriterion("updated >=", value, "updated"); return (Criteria) this; } public Criteria andUpdatedLessThan(Date value) { addCriterion("updated <", value, "updated"); return (Criteria) this; } public Criteria andUpdatedLessThanOrEqualTo(Date value) { addCriterion("updated <=", value, "updated"); return (Criteria) this; } public Criteria andUpdatedIn(List<Date> values) { addCriterion("updated in", values, "updated"); return (Criteria) this; } public Criteria andUpdatedNotIn(List<Date> values) { addCriterion("updated not in", values, "updated"); return (Criteria) this; } public Criteria andUpdatedBetween(Date value1, Date value2) { addCriterion("updated between", value1, value2, "updated"); return (Criteria) this; } public Criteria andUpdatedNotBetween(Date value1, Date value2) { addCriterion("updated not between", value1, value2, "updated"); return (Criteria) this; } } public static class Criteria extends GeneratedCriteria { protected Criteria() { super(); } } public static class Criterion { private String condition; private Object value; private Object secondValue; private boolean noValue; private boolean singleValue; private boolean betweenValue; private boolean listValue; private String typeHandler; public String getCondition() { return condition; } public Object getValue() { return value; } public Object getSecondValue() { return secondValue; } public boolean isNoValue() { return noValue; } public boolean isSingleValue() { return singleValue; } public boolean isBetweenValue() { return betweenValue; } public boolean isListValue() { return listValue; } public String getTypeHandler() { return typeHandler; } protected Criterion(String condition) { super(); this.condition = condition; this.typeHandler = null; this.noValue = true; } protected Criterion(String condition, Object value, String typeHandler) { super(); this.condition = condition; this.value = value; this.typeHandler = typeHandler; if (value instanceof List<?>) { this.listValue = true; } else { this.singleValue = true; } } protected Criterion(String condition, Object value) { this(condition, value, null); } protected Criterion(String condition, Object value, Object secondValue, String typeHandler) { super(); this.condition = condition; this.value = value; this.secondValue = secondValue; this.typeHandler = typeHandler; this.betweenValue = true; } protected Criterion(String condition, Object value, Object secondValue) { this(condition, value, secondValue, null); } } }
TbItemDesc.java
package com.taotao.pojo; import java.util.Date; public class TbItemDesc { private Long itemId; private Date created; private Date updated; private String itemDesc; public Long getItemId() { return itemId; } public void setItemId(Long itemId) { this.itemId = itemId; } public Date getCreated() { return created; } public void setCreated(Date created) { this.created = created; } public Date getUpdated() { return updated; } public void setUpdated(Date updated) { this.updated = updated; } public String getItemDesc() { return itemDesc; } public void setItemDesc(String itemDesc) { this.itemDesc = itemDesc == null ? null : itemDesc.trim(); } }
TbItemDescExample.java
package com.taotao.pojo; import java.util.ArrayList; import java.util.Date; import java.util.List; public class TbItemDescExample { protected String orderByClause; protected boolean distinct; protected List<Criteria> oredCriteria; public TbItemDescExample() { oredCriteria = new ArrayList<Criteria>(); } public void setOrderByClause(String orderByClause) { this.orderByClause = orderByClause; } public String getOrderByClause() { return orderByClause; } public void setDistinct(boolean distinct) { this.distinct = distinct; } public boolean isDistinct() { return distinct; } public List<Criteria> getOredCriteria() { return oredCriteria; } public void or(Criteria criteria) { oredCriteria.add(criteria); } public Criteria or() { Criteria criteria = createCriteriaInternal(); oredCriteria.add(criteria); return criteria; } public Criteria createCriteria() { Criteria criteria = createCriteriaInternal(); if (oredCriteria.size() == 0) { oredCriteria.add(criteria); } return criteria; } protected Criteria createCriteriaInternal() { Criteria criteria = new Criteria(); return criteria; } public void clear() { oredCriteria.clear(); orderByClause = null; distinct = false; } protected abstract static class GeneratedCriteria { protected List<Criterion> criteria; protected GeneratedCriteria() { super(); criteria = new ArrayList<Criterion>(); } public boolean isValid() { return criteria.size() > 0; } public List<Criterion> getAllCriteria() { return criteria; } public List<Criterion> getCriteria() { return criteria; } protected void addCriterion(String condition) { if (condition == null) { throw new RuntimeException("Value for condition cannot be null"); } criteria.add(new Criterion(condition)); } protected void addCriterion(String condition, Object value, String property) { if (value == null) { throw new RuntimeException("Value for " + property + " cannot be null"); } criteria.add(new Criterion(condition, value)); } protected void addCriterion(String condition, Object value1, Object value2, String property) { if (value1 == null || value2 == null) { throw new RuntimeException("Between values for " + property + " cannot be null"); } criteria.add(new Criterion(condition, value1, value2)); } public Criteria andItemIdIsNull() { addCriterion("item_id is null"); return (Criteria) this; } public Criteria andItemIdIsNotNull() { addCriterion("item_id is not null"); return (Criteria) this; } public Criteria andItemIdEqualTo(Long value) { addCriterion("item_id =", value, "itemId"); return (Criteria) this; } public Criteria andItemIdNotEqualTo(Long value) { addCriterion("item_id <>", value, "itemId"); return (Criteria) this; } public Criteria andItemIdGreaterThan(Long value) { addCriterion("item_id >", value, "itemId"); return (Criteria) this; } public Criteria andItemIdGreaterThanOrEqualTo(Long value) { addCriterion("item_id >=", value, "itemId"); return (Criteria) this; } public Criteria andItemIdLessThan(Long value) { addCriterion("item_id <", value, "itemId"); return (Criteria) this; } public Criteria andItemIdLessThanOrEqualTo(Long value) { addCriterion("item_id <=", value, "itemId"); return (Criteria) this; } public Criteria andItemIdIn(List<Long> values) { addCriterion("item_id in", values, "itemId"); return (Criteria) this; } public Criteria andItemIdNotIn(List<Long> values) { addCriterion("item_id not in", values, "itemId"); return (Criteria) this; } public Criteria andItemIdBetween(Long value1, Long value2) { addCriterion("item_id between", value1, value2, "itemId"); return (Criteria) this; } public Criteria andItemIdNotBetween(Long value1, Long value2) { addCriterion("item_id not between", value1, value2, "itemId"); return (Criteria) this; } public Criteria andCreatedIsNull() { addCriterion("created is null"); return (Criteria) this; } public Criteria andCreatedIsNotNull() { addCriterion("created is not null"); return (Criteria) this; } public Criteria andCreatedEqualTo(Date value) { addCriterion("created =", value, "created"); return (Criteria) this; } public Criteria andCreatedNotEqualTo(Date value) { addCriterion("created <>", value, "created"); return (Criteria) this; } public Criteria andCreatedGreaterThan(Date value) { addCriterion("created >", value, "created"); return (Criteria) this; } public Criteria andCreatedGreaterThanOrEqualTo(Date value) { addCriterion("created >=", value, "created"); return (Criteria) this; } public Criteria andCreatedLessThan(Date value) { addCriterion("created <", value, "created"); return (Criteria) this; } public Criteria andCreatedLessThanOrEqualTo(Date value) { addCriterion("created <=", value, "created"); return (Criteria) this; } public Criteria andCreatedIn(List<Date> values) { addCriterion("created in", values, "created"); return (Criteria) this; } public Criteria andCreatedNotIn(List<Date> values) { addCriterion("created not in", values, "created"); return (Criteria) this; } public Criteria andCreatedBetween(Date value1, Date value2) { addCriterion("created between", value1, value2, "created"); return (Criteria) this; } public Criteria andCreatedNotBetween(Date value1, Date value2) { addCriterion("created not between", value1, value2, "created"); return (Criteria) this; } public Criteria andUpdatedIsNull() { addCriterion("updated is null"); return (Criteria) this; } public Criteria andUpdatedIsNotNull() { addCriterion("updated is not null"); return (Criteria) this; } public Criteria andUpdatedEqualTo(Date value) { addCriterion("updated =", value, "updated"); return (Criteria) this; } public Criteria andUpdatedNotEqualTo(Date value) { addCriterion("updated <>", value, "updated"); return (Criteria) this; } public Criteria andUpdatedGreaterThan(Date value) { addCriterion("updated >", value, "updated"); return (Criteria) this; } public Criteria andUpdatedGreaterThanOrEqualTo(Date value) { addCriterion("updated >=", value, "updated"); return (Criteria) this; } public Criteria andUpdatedLessThan(Date value) { addCriterion("updated <", value, "updated"); return (Criteria) this; } public Criteria andUpdatedLessThanOrEqualTo(Date value) { addCriterion("updated <=", value, "updated"); return (Criteria) this; } public Criteria andUpdatedIn(List<Date> values) { addCriterion("updated in", values, "updated"); return (Criteria) this; } public Criteria andUpdatedNotIn(List<Date> values) { addCriterion("updated not in", values, "updated"); return (Criteria) this; } public Criteria andUpdatedBetween(Date value1, Date value2) { addCriterion("updated between", value1, value2, "updated"); return (Criteria) this; } public Criteria andUpdatedNotBetween(Date value1, Date value2) { addCriterion("updated not between", value1, value2, "updated"); return (Criteria) this; } } public static class Criteria extends GeneratedCriteria { protected Criteria() { super(); } } public static class Criterion { private String condition; private Object value; private Object secondValue; private boolean noValue; private boolean singleValue; private boolean betweenValue; private boolean listValue; private String typeHandler; public String getCondition() { return condition; } public Object getValue() { return value; } public Object getSecondValue() { return secondValue; } public boolean isNoValue() { return noValue; } public boolean isSingleValue() { return singleValue; } public boolean isBetweenValue() { return betweenValue; } public boolean isListValue() { return listValue; } public String getTypeHandler() { return typeHandler; } protected Criterion(String condition) { super(); this.condition = condition; this.typeHandler = null; this.noValue = true; } protected Criterion(String condition, Object value, String typeHandler) { super(); this.condition = condition; this.value = value; this.typeHandler = typeHandler; if (value instanceof List<?>) { this.listValue = true; } else { this.singleValue = true; } } protected Criterion(String condition, Object value) { this(condition, value, null); } protected Criterion(String condition, Object value, Object secondValue, String typeHandler) { super(); this.condition = condition; this.value = value; this.secondValue = secondValue; this.typeHandler = typeHandler; this.betweenValue = true; } protected Criterion(String condition, Object value, Object secondValue) { this(condition, value, secondValue, null); } } }
TbItemExample.java
package com.taotao.pojo; import java.util.ArrayList; import java.util.Date; import java.util.List; public class TbItemExample { protected String orderByClause; protected boolean distinct; protected List<Criteria> oredCriteria; public TbItemExample() { oredCriteria = new ArrayList<Criteria>(); } public void setOrderByClause(String orderByClause) { this.orderByClause = orderByClause; } public String getOrderByClause() { return orderByClause; } public void setDistinct(boolean distinct) { this.distinct = distinct; } public boolean isDistinct() { return distinct; } public List<Criteria> getOredCriteria() { return oredCriteria; } public void or(Criteria criteria) { oredCriteria.add(criteria); } public Criteria or() { Criteria criteria = createCriteriaInternal(); oredCriteria.add(criteria); return criteria; } public Criteria createCriteria() { Criteria criteria = createCriteriaInternal(); if (oredCriteria.size() == 0) { oredCriteria.add(criteria); } return criteria; } protected Criteria createCriteriaInternal() { Criteria criteria = new Criteria(); return criteria; } public void clear() { oredCriteria.clear(); orderByClause = null; distinct = false; } protected abstract static class GeneratedCriteria { protected List<Criterion> criteria; protected GeneratedCriteria() { super(); criteria = new ArrayList<Criterion>(); } public boolean isValid() { return criteria.size() > 0; } public List<Criterion> getAllCriteria() { return criteria; } public List<Criterion> getCriteria() { return criteria; } protected void addCriterion(String condition) { if (condition == null) { throw new RuntimeException("Value for condition cannot be null"); } criteria.add(new Criterion(condition)); } protected void addCriterion(String condition, Object value, String property) { if (value == null) { throw new RuntimeException("Value for " + property + " cannot be null"); } criteria.add(new Criterion(condition, value)); } protected void addCriterion(String condition, Object value1, Object value2, String property) { if (value1 == null || value2 == null) { throw new RuntimeException("Between values for " + property + " cannot be null"); } criteria.add(new Criterion(condition, value1, value2)); } public Criteria andIdIsNull() { addCriterion("id is null"); return (Criteria) this; } public Criteria andIdIsNotNull() { addCriterion("id is not null"); return (Criteria) this; } public Criteria andIdEqualTo(Long value) { addCriterion("id =", value, "id"); return (Criteria) this; } public Criteria andIdNotEqualTo(Long value) { addCriterion("id <>", value, "id"); return (Criteria) this; } public Criteria andIdGreaterThan(Long value) { addCriterion("id >", value, "id"); return (Criteria) this; } public Criteria andIdGreaterThanOrEqualTo(Long value) { addCriterion("id >=", value, "id"); return (Criteria) this; } public Criteria andIdLessThan(Long value) { addCriterion("id <", value, "id"); return (Criteria) this; } public Criteria andIdLessThanOrEqualTo(Long value) { addCriterion("id <=", value, "id"); return (Criteria) this; } public Criteria andIdIn(List<Long> values) { addCriterion("id in", values, "id"); return (Criteria) this; } public Criteria andIdNotIn(List<Long> values) { addCriterion("id not in", values, "id"); return (Criteria) this; } public Criteria andIdBetween(Long value1, Long value2) { addCriterion("id between", value1, value2, "id"); return (Criteria) this; } public Criteria andIdNotBetween(Long value1, Long value2) { addCriterion("id not between", value1, value2, "id"); return (Criteria) this; } public Criteria andTitleIsNull() { addCriterion("title is null"); return (Criteria) this; } public Criteria andTitleIsNotNull() { addCriterion("title is not null"); return (Criteria) this; } public Criteria andTitleEqualTo(String value) { addCriterion("title =", value, "title"); return (Criteria) this; } public Criteria andTitleNotEqualTo(String value) { addCriterion("title <>", value, "title"); return (Criteria) this; } public Criteria andTitleGreaterThan(String value) { addCriterion("title >", value, "title"); return (Criteria) this; } public Criteria andTitleGreaterThanOrEqualTo(String value) { addCriterion("title >=", value, "title"); return (Criteria) this; } public Criteria andTitleLessThan(String value) { addCriterion("title <", value, "title"); return (Criteria) this; } public Criteria andTitleLessThanOrEqualTo(String value) { addCriterion("title <=", value, "title"); return (Criteria) this; } public Criteria andTitleLike(String value) { addCriterion("title like", value, "title"); return (Criteria) this; } public Criteria andTitleNotLike(String value) { addCriterion("title not like", value, "title"); return (Criteria) this; } public Criteria andTitleIn(List<String> values) { addCriterion("title in", values, "title"); return (Criteria) this; } public Criteria andTitleNotIn(List<String> values) { addCriterion("title not in", values, "title"); return (Criteria) this; } public Criteria andTitleBetween(String value1, String value2) { addCriterion("title between", value1, value2, "title"); return (Criteria) this; } public Criteria andTitleNotBetween(String value1, String value2) { addCriterion("title not between", value1, value2, "title"); return (Criteria) this; } public Criteria andSellPointIsNull() { addCriterion("sell_point is null"); return (Criteria) this; } public Criteria andSellPointIsNotNull() { addCriterion("sell_point is not null"); return (Criteria) this; } public Criteria andSellPointEqualTo(String value) { addCriterion("sell_point =", value, "sellPoint"); return (Criteria) this; } public Criteria andSellPointNotEqualTo(String value) { addCriterion("sell_point <>", value, "sellPoint"); return (Criteria) this; } public Criteria andSellPointGreaterThan(String value) { addCriterion("sell_point >", value, "sellPoint"); return (Criteria) this; } public Criteria andSellPointGreaterThanOrEqualTo(String value) { addCriterion("sell_point >=", value, "sellPoint"); return (Criteria) this; } public Criteria andSellPointLessThan(String value) { addCriterion("sell_point <", value, "sellPoint"); return (Criteria) this; } public Criteria andSellPointLessThanOrEqualTo(String value) { addCriterion("sell_point <=", value, "sellPoint"); return (Criteria) this; } public Criteria andSellPointLike(String value) { addCriterion("sell_point like", value, "sellPoint"); return (Criteria) this; } public Criteria andSellPointNotLike(String value) { addCriterion("sell_point not like", value, "sellPoint"); return (Criteria) this; } public Criteria andSellPointIn(List<String> values) { addCriterion("sell_point in", values, "sellPoint"); return (Criteria) this; } public Criteria andSellPointNotIn(List<String> values) { addCriterion("sell_point not in", values, "sellPoint"); return (Criteria) this; } public Criteria andSellPointBetween(String value1, String value2) { addCriterion("sell_point between", value1, value2, "sellPoint"); return (Criteria) this; } public Criteria andSellPointNotBetween(String value1, String value2) { addCriterion("sell_point not between", value1, value2, "sellPoint"); return (Criteria) this; } public Criteria andPriceIsNull() { addCriterion("price is null"); return (Criteria) this; } public Criteria andPriceIsNotNull() { addCriterion("price is not null"); return (Criteria) this; } public Criteria andPriceEqualTo(Long value) { addCriterion("price =", value, "price"); return (Criteria) this; } public Criteria andPriceNotEqualTo(Long value) { addCriterion("price <>", value, "price"); return (Criteria) this; } public Criteria andPriceGreaterThan(Long value) { addCriterion("price >", value, "price"); return (Criteria) this; } public Criteria andPriceGreaterThanOrEqualTo(Long value) { addCriterion("price >=", value, "price"); return (Criteria) this; } public Criteria andPriceLessThan(Long value) { addCriterion("price <", value, "price"); return (Criteria) this; } public Criteria andPriceLessThanOrEqualTo(Long value) { addCriterion("price <=", value, "price"); return (Criteria) this; } public Criteria andPriceIn(List<Long> values) { addCriterion("price in", values, "price"); return (Criteria) this; } public Criteria andPriceNotIn(List<Long> values) { addCriterion("price not in", values, "price"); return (Criteria) this; } public Criteria andPriceBetween(Long value1, Long value2) { addCriterion("price between", value1, value2, "price"); return (Criteria) this; } public Criteria andPriceNotBetween(Long value1, Long value2) { addCriterion("price not between", value1, value2, "price"); return (Criteria) this; } public Criteria andNumIsNull() { addCriterion("num is null"); return (Criteria) this; } public Criteria andNumIsNotNull() { addCriterion("num is not null"); return (Criteria) this; } public Criteria andNumEqualTo(Integer value) { addCriterion("num =", value, "num"); return (Criteria) this; } public Criteria andNumNotEqualTo(Integer value) { addCriterion("num <>", value, "num"); return (Criteria) this; } public Criteria andNumGreaterThan(Integer value) { addCriterion("num >", value, "num"); return (Criteria) this; } public Criteria andNumGreaterThanOrEqualTo(Integer value) { addCriterion("num >=", value, "num"); return (Criteria) this; } public Criteria andNumLessThan(Integer value) { addCriterion("num <", value, "num"); return (Criteria) this; } public Criteria andNumLessThanOrEqualTo(Integer value) { addCriterion("num <=", value, "num"); return (Criteria) this; } public Criteria andNumIn(List<Integer> values) { addCriterion("num in", values, "num"); return (Criteria) this; } public Criteria andNumNotIn(List<Integer> values) { addCriterion("num not in", values, "num"); return (Criteria) this; } public Criteria andNumBetween(Integer value1, Integer value2) { addCriterion("num between", value1, value2, "num"); return (Criteria) this; } public Criteria andNumNotBetween(Integer value1, Integer value2) { addCriterion("num not between", value1, value2, "num"); return (Criteria) this; } public Criteria andBarcodeIsNull() { addCriterion("barcode is null"); return (Criteria) this; } public Criteria andBarcodeIsNotNull() { addCriterion("barcode is not null"); return (Criteria) this; } public Criteria andBarcodeEqualTo(String value) { addCriterion("barcode =", value, "barcode"); return (Criteria) this; } public Criteria andBarcodeNotEqualTo(String value) { addCriterion("barcode <>", value, "barcode"); return (Criteria) this; } public Criteria andBarcodeGreaterThan(String value) { addCriterion("barcode >", value, "barcode"); return (Criteria) this; } public Criteria andBarcodeGreaterThanOrEqualTo(String value) { addCriterion("barcode >=", value, "barcode"); return (Criteria) this; } public Criteria andBarcodeLessThan(String value) { addCriterion("barcode <", value, "barcode"); return (Criteria) this; } public Criteria andBarcodeLessThanOrEqualTo(String value) { addCriterion("barcode <=", value, "barcode"); return (Criteria) this; } public Criteria andBarcodeLike(String value) { addCriterion("barcode like", value, "barcode"); return (Criteria) this; } public Criteria andBarcodeNotLike(String value) { addCriterion("barcode not like", value, "barcode"); return (Criteria) this; } public Criteria andBarcodeIn(List<String> values) { addCriterion("barcode in", values, "barcode"); return (Criteria) this; } public Criteria andBarcodeNotIn(List<String> values) { addCriterion("barcode not in", values, "barcode"); return (Criteria) this; } public Criteria andBarcodeBetween(String value1, String value2) { addCriterion("barcode between", value1, value2, "barcode"); return (Criteria) this; } public Criteria andBarcodeNotBetween(String value1, String value2) { addCriterion("barcode not between", value1, value2, "barcode"); return (Criteria) this; } public Criteria andImageIsNull() { addCriterion("image is null"); return (Criteria) this; } public Criteria andImageIsNotNull() { addCriterion("image is not null"); return (Criteria) this; } public Criteria andImageEqualTo(String value) { addCriterion("image =", value, "image"); return (Criteria) this; } public Criteria andImageNotEqualTo(String value) { addCriterion("image <>", value, "image"); return (Criteria) this; } public Criteria andImageGreaterThan(String value) { addCriterion("image >", value, "image"); return (Criteria) this; } public Criteria andImageGreaterThanOrEqualTo(String value) { addCriterion("image >=", value, "image"); return (Criteria) this; } public Criteria andImageLessThan(String value) { addCriterion("image <", value, "image"); return (Criteria) this; } public Criteria andImageLessThanOrEqualTo(String value) { addCriterion("image <=", value, "image"); return (Criteria) this; } public Criteria andImageLike(String value) { addCriterion("image like", value, "image"); return (Criteria) this; } public Criteria andImageNotLike(String value) { addCriterion("image not like", value, "image"); return (Criteria) this; } public Criteria andImageIn(List<String> values) { addCriterion("image in", values, "image"); return (Criteria) this; } public Criteria andImageNotIn(List<String> values) { addCriterion("image not in", values, "image"); return (Criteria) this; } public Criteria andImageBetween(String value1, String value2) { addCriterion("image between", value1, value2, "image"); return (Criteria) this; } public Criteria andImageNotBetween(String value1, String value2) { addCriterion("image not between", value1, value2, "image"); return (Criteria) this; } public Criteria andCidIsNull() { addCriterion("cid is null"); return (Criteria) this; } public Criteria andCidIsNotNull() { addCriterion("cid is not null"); return (Criteria) this; } public Criteria andCidEqualTo(Long value) { addCriterion("cid =", value, "cid"); return (Criteria) this; } public Criteria andCidNotEqualTo(Long value) { addCriterion("cid <>", value, "cid"); return (Criteria) this; } public Criteria andCidGreaterThan(Long value) { addCriterion("cid >", value, "cid"); return (Criteria) this; } public Criteria andCidGreaterThanOrEqualTo(Long value) { addCriterion("cid >=", value, "cid"); return (Criteria) this; } public Criteria andCidLessThan(Long value) { addCriterion("cid <", value, "cid"); return (Criteria) this; } public Criteria andCidLessThanOrEqualTo(Long value) { addCriterion("cid <=", value, "cid"); return (Criteria) this; } public Criteria andCidIn(List<Long> values) { addCriterion("cid in", values, "cid"); return (Criteria) this; } public Criteria andCidNotIn(List<Long> values) { addCriterion("cid not in", values, "cid"); return (Criteria) this; } public Criteria andCidBetween(Long value1, Long value2) { addCriterion("cid between", value1, value2, "cid"); return (Criteria) this; } public Criteria andCidNotBetween(Long value1, Long value2) { addCriterion("cid not between", value1, value2, "cid"); return (Criteria) this; } public Criteria andStatusIsNull() { addCriterion("status is null"); return (Criteria) this; } public Criteria andStatusIsNotNull() { addCriterion("status is not null"); return (Criteria) this; } public Criteria andStatusEqualTo(Byte value) { addCriterion("status =", value, "status"); return (Criteria) this; } public Criteria andStatusNotEqualTo(Byte value) { addCriterion("status <>", value, "status"); return (Criteria) this; } public Criteria andStatusGreaterThan(Byte value) { addCriterion("status >", value, "status"); return (Criteria) this; } public Criteria andStatusGreaterThanOrEqualTo(Byte value) { addCriterion("status >=", value, "status"); return (Criteria) this; } public Criteria andStatusLessThan(Byte value) { addCriterion("status <", value, "status"); return (Criteria) this; } public Criteria andStatusLessThanOrEqualTo(Byte value) { addCriterion("status <=", value, "status"); return (Criteria) this; } public Criteria andStatusIn(List<Byte> values) { addCriterion("status in", values, "status"); return (Criteria) this; } public Criteria andStatusNotIn(List<Byte> values) { addCriterion("status not in", values, "status"); return (Criteria) this; } public Criteria andStatusBetween(Byte value1, Byte value2) { addCriterion("status between", value1, value2, "status"); return (Criteria) this; } public Criteria andStatusNotBetween(Byte value1, Byte value2) { addCriterion("status not between", value1, value2, "status"); return (Criteria) this; } public Criteria andCreatedIsNull() { addCriterion("created is null"); return (Criteria) this; } public Criteria andCreatedIsNotNull() { addCriterion("created is not null"); return (Criteria) this; } public Criteria andCreatedEqualTo(Date value) { addCriterion("created =", value, "created"); return (Criteria) this; } public Criteria andCreatedNotEqualTo(Date value) { addCriterion("created <>", value, "created"); return (Criteria) this; } public Criteria andCreatedGreaterThan(Date value) { addCriterion("created >", value, "created"); return (Criteria) this; } public Criteria andCreatedGreaterThanOrEqualTo(Date value) { addCriterion("created >=", value, "created"); return (Criteria) this; } public Criteria andCreatedLessThan(Date value) { addCriterion("created <", value, "created"); return (Criteria) this; } public Criteria andCreatedLessThanOrEqualTo(Date value) { addCriterion("created <=", value, "created"); return (Criteria) this; } public Criteria andCreatedIn(List<Date> values) { addCriterion("created in", values, "created"); return (Criteria) this; } public Criteria andCreatedNotIn(List<Date> values) { addCriterion("created not in", values, "created"); return (Criteria) this; } public Criteria andCreatedBetween(Date value1, Date value2) { addCriterion("created between", value1, value2, "created"); return (Criteria) this; } public Criteria andCreatedNotBetween(Date value1, Date value2) { addCriterion("created not between", value1, value2, "created"); return (Criteria) this; } public Criteria andUpdatedIsNull() { addCriterion("updated is null"); return (Criteria) this; } public Criteria andUpdatedIsNotNull() { addCriterion("updated is not null"); return (Criteria) this; } public Criteria andUpdatedEqualTo(Date value) { addCriterion("updated =", value, "updated"); return (Criteria) this; } public Criteria andUpdatedNotEqualTo(Date value) { addCriterion("updated <>", value, "updated"); return (Criteria) this; } public Criteria andUpdatedGreaterThan(Date value) { addCriterion("updated >", value, "updated"); return (Criteria) this; } public Criteria andUpdatedGreaterThanOrEqualTo(Date value) { addCriterion("updated >=", value, "updated"); return (Criteria) this; } public Criteria andUpdatedLessThan(Date value) { addCriterion("updated <", value, "updated"); return (Criteria) this; } public Criteria andUpdatedLessThanOrEqualTo(Date value) { addCriterion("updated <=", value, "updated"); return (Criteria) this; } public Criteria andUpdatedIn(List<Date> values) { addCriterion("updated in", values, "updated"); return (Criteria) this; } public Criteria andUpdatedNotIn(List<Date> values) { addCriterion("updated not in", values, "updated"); return (Criteria) this; } public Criteria andUpdatedBetween(Date value1, Date value2) { addCriterion("updated between", value1, value2, "updated"); return (Criteria) this; } public Criteria andUpdatedNotBetween(Date value1, Date value2) { addCriterion("updated not between", value1, value2, "updated"); return (Criteria) this; } } public static class Criteria extends GeneratedCriteria { protected Criteria() { super(); } } public static class Criterion { private String condition; private Object value; private Object secondValue; private boolean noValue; private boolean singleValue; private boolean betweenValue; private boolean listValue; private String typeHandler; public String getCondition() { return condition; } public Object getValue() { return value; } public Object getSecondValue() { return secondValue; } public boolean isNoValue() { return noValue; } public boolean isSingleValue() { return singleValue; } public boolean isBetweenValue() { return betweenValue; } public boolean isListValue() { return listValue; } public String getTypeHandler() { return typeHandler; } protected Criterion(String condition) { super(); this.condition = condition; this.typeHandler = null; this.noValue = true; } protected Criterion(String condition, Object value, String typeHandler) { super(); this.condition = condition; this.value = value; this.typeHandler = typeHandler; if (value instanceof List<?>) { this.listValue = true; } else { this.singleValue = true; } } protected Criterion(String condition, Object value) { this(condition, value, null); } protected Criterion(String condition, Object value, Object secondValue, String typeHandler) { super(); this.condition = condition; this.value = value; this.secondValue = secondValue; this.typeHandler = typeHandler; this.betweenValue = true; } protected Criterion(String condition, Object value, Object secondValue) { this(condition, value, secondValue, null); } } }
TbItemParam.java
package com.taotao.pojo; import java.util.Date; public class TbItemParam { private Long id; private Long itemCatId; private Date created; private Date updated; private String paramData; public Long getId() { return id; } public void setId(Long id) { this.id = id; } public Long getItemCatId() { return itemCatId; } public void setItemCatId(Long itemCatId) { this.itemCatId = itemCatId; } public Date getCreated() { return created; } public void setCreated(Date created) { this.created = created; } public Date getUpdated() { return updated; } public void setUpdated(Date updated) { this.updated = updated; } public String getParamData() { return paramData; } public void setParamData(String paramData) { this.paramData = paramData == null ? null : paramData.trim(); } }
TbItemParamExample.java
package com.taotao.pojo; import java.util.ArrayList; import java.util.Date; import java.util.List; public class TbItemParamExample { protected String orderByClause; protected boolean distinct; protected List<Criteria> oredCriteria; public TbItemParamExample() { oredCriteria = new ArrayList<Criteria>(); } public void setOrderByClause(String orderByClause) { this.orderByClause = orderByClause; } public String getOrderByClause() { return orderByClause; } public void setDistinct(boolean distinct) { this.distinct = distinct; } public boolean isDistinct() { return distinct; } public List<Criteria> getOredCriteria() { return oredCriteria; } public void or(Criteria criteria) { oredCriteria.add(criteria); } public Criteria or() { Criteria criteria = createCriteriaInternal(); oredCriteria.add(criteria); return criteria; } public Criteria createCriteria() { Criteria criteria = createCriteriaInternal(); if (oredCriteria.size() == 0) { oredCriteria.add(criteria); } return criteria; } protected Criteria createCriteriaInternal() { Criteria criteria = new Criteria(); return criteria; } public void clear() { oredCriteria.clear(); orderByClause = null; distinct = false; } protected abstract static class GeneratedCriteria { protected List<Criterion> criteria; protected GeneratedCriteria() { super(); criteria = new ArrayList<Criterion>(); } public boolean isValid() { return criteria.size() > 0; } public List<Criterion> getAllCriteria() { return criteria; } public List<Criterion> getCriteria() { return criteria; } protected void addCriterion(String condition) { if (condition == null) { throw new RuntimeException("Value for condition cannot be null"); } criteria.add(new Criterion(condition)); } protected void addCriterion(String condition, Object value, String property) { if (value == null) { throw new RuntimeException("Value for " + property + " cannot be null"); } criteria.add(new Criterion(condition, value)); } protected void addCriterion(String condition, Object value1, Object value2, String property) { if (value1 == null || value2 == null) { throw new RuntimeException("Between values for " + property + " cannot be null"); } criteria.add(new Criterion(condition, value1, value2)); } public Criteria andIdIsNull() { addCriterion("id is null"); return (Criteria) this; } public Criteria andIdIsNotNull() { addCriterion("id is not null"); return (Criteria) this; } public Criteria andIdEqualTo(Long value) { addCriterion("id =", value, "id"); return (Criteria) this; } public Criteria andIdNotEqualTo(Long value) { addCriterion("id <>", value, "id"); return (Criteria) this; } public Criteria andIdGreaterThan(Long value) { addCriterion("id >", value, "id"); return (Criteria) this; } public Criteria andIdGreaterThanOrEqualTo(Long value) { addCriterion("id >=", value, "id"); return (Criteria) this; } public Criteria andIdLessThan(Long value) { addCriterion("id <", value, "id"); return (Criteria) this; } public Criteria andIdLessThanOrEqualTo(Long value) { addCriterion("id <=", value, "id"); return (Criteria) this; } public Criteria andIdIn(List<Long> values) { addCriterion("id in", values, "id"); return (Criteria) this; } public Criteria andIdNotIn(List<Long> values) { addCriterion("id not in", values, "id"); return (Criteria) this; } public Criteria andIdBetween(Long value1, Long value2) { addCriterion("id between", value1, value2, "id"); return (Criteria) this; } public Criteria andIdNotBetween(Long value1, Long value2) { addCriterion("id not between", value1, value2, "id"); return (Criteria) this; } public Criteria andItemCatIdIsNull() { addCriterion("item_cat_id is null"); return (Criteria) this; } public Criteria andItemCatIdIsNotNull() { addCriterion("item_cat_id is not null"); return (Criteria) this; } public Criteria andItemCatIdEqualTo(Long value) { addCriterion("item_cat_id =", value, "itemCatId"); return (Criteria) this; } public Criteria andItemCatIdNotEqualTo(Long value) { addCriterion("item_cat_id <>", value, "itemCatId"); return (Criteria) this; } public Criteria andItemCatIdGreaterThan(Long value) { addCriterion("item_cat_id >", value, "itemCatId"); return (Criteria) this; } public Criteria andItemCatIdGreaterThanOrEqualTo(Long value) { addCriterion("item_cat_id >=", value, "itemCatId"); return (Criteria) this; } public Criteria andItemCatIdLessThan(Long value) { addCriterion("item_cat_id <", value, "itemCatId"); return (Criteria) this; } public Criteria andItemCatIdLessThanOrEqualTo(Long value) { addCriterion("item_cat_id <=", value, "itemCatId"); return (Criteria) this; } public Criteria andItemCatIdIn(List<Long> values) { addCriterion("item_cat_id in", values, "itemCatId"); return (Criteria) this; } public Criteria andItemCatIdNotIn(List<Long> values) { addCriterion("item_cat_id not in", values, "itemCatId"); return (Criteria) this; } public Criteria andItemCatIdBetween(Long value1, Long value2) { addCriterion("item_cat_id between", value1, value2, "itemCatId"); return (Criteria) this; } public Criteria andItemCatIdNotBetween(Long value1, Long value2) { addCriterion("item_cat_id not between", value1, value2, "itemCatId"); return (Criteria) this; } public Criteria andCreatedIsNull() { addCriterion("created is null"); return (Criteria) this; } public Criteria andCreatedIsNotNull() { addCriterion("created is not null"); return (Criteria) this; } public Criteria andCreatedEqualTo(Date value) { addCriterion("created =", value, "created"); return (Criteria) this; } public Criteria andCreatedNotEqualTo(Date value) { addCriterion("created <>", value, "created"); return (Criteria) this; } public Criteria andCreatedGreaterThan(Date value) { addCriterion("created >", value, "created"); return (Criteria) this; } public Criteria andCreatedGreaterThanOrEqualTo(Date value) { addCriterion("created >=", value, "created"); return (Criteria) this; } public Criteria andCreatedLessThan(Date value) { addCriterion("created <", value, "created"); return (Criteria) this; } public Criteria andCreatedLessThanOrEqualTo(Date value) { addCriterion("created <=", value, "created"); return (Criteria) this; } public Criteria andCreatedIn(List<Date> values) { addCriterion("created in", values, "created"); return (Criteria) this; } public Criteria andCreatedNotIn(List<Date> values) { addCriterion("created not in", values, "created"); return (Criteria) this; } public Criteria andCreatedBetween(Date value1, Date value2) { addCriterion("created between", value1, value2, "created"); return (Criteria) this; } public Criteria andCreatedNotBetween(Date value1, Date value2) { addCriterion("created not between", value1, value2, "created"); return (Criteria) this; } public Criteria andUpdatedIsNull() { addCriterion("updated is null"); return (Criteria) this; } public Criteria andUpdatedIsNotNull() { addCriterion("updated is not null"); return (Criteria) this; } public Criteria andUpdatedEqualTo(Date value) { addCriterion("updated =", value, "updated"); return (Criteria) this; } public Criteria andUpdatedNotEqualTo(Date value) { addCriterion("updated <>", value, "updated"); return (Criteria) this; } public Criteria andUpdatedGreaterThan(Date value) { addCriterion("updated >", value, "updated"); return (Criteria) this; } public Criteria andUpdatedGreaterThanOrEqualTo(Date value) { addCriterion("updated >=", value, "updated"); return (Criteria) this; } public Criteria andUpdatedLessThan(Date value) { addCriterion("updated <", value, "updated"); return (Criteria) this; } public Criteria andUpdatedLessThanOrEqualTo(Date value) { addCriterion("updated <=", value, "updated"); return (Criteria) this; } public Criteria andUpdatedIn(List<Date> values) { addCriterion("updated in", values, "updated"); return (Criteria) this; } public Criteria andUpdatedNotIn(List<Date> values) { addCriterion("updated not in", values, "updated"); return (Criteria) this; } public Criteria andUpdatedBetween(Date value1, Date value2) { addCriterion("updated between", value1, value2, "updated"); return (Criteria) this; } public Criteria andUpdatedNotBetween(Date value1, Date value2) { addCriterion("updated not between", value1, value2, "updated"); return (Criteria) this; } } public static class Criteria extends GeneratedCriteria { protected Criteria() { super(); } } public static class Criterion { private String condition; private Object value; private Object secondValue; private boolean noValue; private boolean singleValue; private boolean betweenValue; private boolean listValue; private String typeHandler; public String getCondition() { return condition; } public Object getValue() { return value; } public Object getSecondValue() { return secondValue; } public boolean isNoValue() { return noValue; } public boolean isSingleValue() { return singleValue; } public boolean isBetweenValue() { return betweenValue; } public boolean isListValue() { return listValue; } public String getTypeHandler() { return typeHandler; } protected Criterion(String condition) { super(); this.condition = condition; this.typeHandler = null; this.noValue = true; } protected Criterion(String condition, Object value, String typeHandler) { super(); this.condition = condition; this.value = value; this.typeHandler = typeHandler; if (value instanceof List<?>) { this.listValue = true; } else { this.singleValue = true; } } protected Criterion(String condition, Object value) { this(condition, value, null); } protected Criterion(String condition, Object value, Object secondValue, String typeHandler) { super(); this.condition = condition; this.value = value; this.secondValue = secondValue; this.typeHandler = typeHandler; this.betweenValue = true; } protected Criterion(String condition, Object value, Object secondValue) { this(condition, value, secondValue, null); } } }
TbItemParamItem.java
package com.taotao.pojo; import java.util.Date; public class TbItemParamItem { private Long id; private Long itemId; private Date created; private Date updated; private String paramData; public Long getId() { return id; } public void setId(Long id) { this.id = id; } public Long getItemId() { return itemId; } public void setItemId(Long itemId) { this.itemId = itemId; } public Date getCreated() { return created; } public void setCreated(Date created) { this.created = created; } public Date getUpdated() { return updated; } public void setUpdated(Date updated) { this.updated = updated; } public String getParamData() { return paramData; } public void setParamData(String paramData) { this.paramData = paramData == null ? null : paramData.trim(); } }
TbItemParamItemExample.java
package com.taotao.pojo; import java.util.ArrayList; import java.util.Date; import java.util.List; public class TbItemParamItemExample { protected String orderByClause; protected boolean distinct; protected List<Criteria> oredCriteria; public TbItemParamItemExample() { oredCriteria = new ArrayList<Criteria>(); } public void setOrderByClause(String orderByClause) { this.orderByClause = orderByClause; } public String getOrderByClause() { return orderByClause; } public void setDistinct(boolean distinct) { this.distinct = distinct; } public boolean isDistinct() { return distinct; } public List<Criteria> getOredCriteria() { return oredCriteria; } public void or(Criteria criteria) { oredCriteria.add(criteria); } public Criteria or() { Criteria criteria = createCriteriaInternal(); oredCriteria.add(criteria); return criteria; } public Criteria createCriteria() { Criteria criteria = createCriteriaInternal(); if (oredCriteria.size() == 0) { oredCriteria.add(criteria); } return criteria; } protected Criteria createCriteriaInternal() { Criteria criteria = new Criteria(); return criteria; } public void clear() { oredCriteria.clear(); orderByClause = null; distinct = false; } protected abstract static class GeneratedCriteria { protected List<Criterion> criteria; protected GeneratedCriteria() { super(); criteria = new ArrayList<Criterion>(); } public boolean isValid() { return criteria.size() > 0; } public List<Criterion> getAllCriteria() { return criteria; } public List<Criterion> getCriteria() { return criteria; } protected void addCriterion(String condition) { if (condition == null) { throw new RuntimeException("Value for condition cannot be null"); } criteria.add(new Criterion(condition)); } protected void addCriterion(String condition, Object value, String property) { if (value == null) { throw new RuntimeException("Value for " + property + " cannot be null"); } criteria.add(new Criterion(condition, value)); } protected void addCriterion(String condition, Object value1, Object value2, String property) { if (value1 == null || value2 == null) { throw new RuntimeException("Between values for " + property + " cannot be null"); } criteria.add(new Criterion(condition, value1, value2)); } public Criteria andIdIsNull() { addCriterion("id is null"); return (Criteria) this; } public Criteria andIdIsNotNull() { addCriterion("id is not null"); return (Criteria) this; } public Criteria andIdEqualTo(Long value) { addCriterion("id =", value, "id"); return (Criteria) this; } public Criteria andIdNotEqualTo(Long value) { addCriterion("id <>", value, "id"); return (Criteria) this; } public Criteria andIdGreaterThan(Long value) { addCriterion("id >", value, "id"); return (Criteria) this; } public Criteria andIdGreaterThanOrEqualTo(Long value) { addCriterion("id >=", value, "id"); return (Criteria) this; } public Criteria andIdLessThan(Long value) { addCriterion("id <", value, "id"); return (Criteria) this; } public Criteria andIdLessThanOrEqualTo(Long value) { addCriterion("id <=", value, "id"); return (Criteria) this; } public Criteria andIdIn(List<Long> values) { addCriterion("id in", values, "id"); return (Criteria) this; } public Criteria andIdNotIn(List<Long> values) { addCriterion("id not in", values, "id"); return (Criteria) this; } public Criteria andIdBetween(Long value1, Long value2) { addCriterion("id between", value1, value2, "id"); return (Criteria) this; } public Criteria andIdNotBetween(Long value1, Long value2) { addCriterion("id not between", value1, value2, "id"); return (Criteria) this; } public Criteria andItemIdIsNull() { addCriterion("item_id is null"); return (Criteria) this; } public Criteria andItemIdIsNotNull() { addCriterion("item_id is not null"); return (Criteria) this; } public Criteria andItemIdEqualTo(Long value) { addCriterion("item_id =", value, "itemId"); return (Criteria) this; } public Criteria andItemIdNotEqualTo(Long value) { addCriterion("item_id <>", value, "itemId"); return (Criteria) this; } public Criteria andItemIdGreaterThan(Long value) { addCriterion("item_id >", value, "itemId"); return (Criteria) this; } public Criteria andItemIdGreaterThanOrEqualTo(Long value) { addCriterion("item_id >=", value, "itemId"); return (Criteria) this; } public Criteria andItemIdLessThan(Long value) { addCriterion("item_id <", value, "itemId"); return (Criteria) this; } public Criteria andItemIdLessThanOrEqualTo(Long value) { addCriterion("item_id <=", value, "itemId"); return (Criteria) this; } public Criteria andItemIdIn(List<Long> values) { addCriterion("item_id in", values, "itemId"); return (Criteria) this; } public Criteria andItemIdNotIn(List<Long> values) { addCriterion("item_id not in", values, "itemId"); return (Criteria) this; } public Criteria andItemIdBetween(Long value1, Long value2) { addCriterion("item_id between", value1, value2, "itemId"); return (Criteria) this; } public Criteria andItemIdNotBetween(Long value1, Long value2) { addCriterion("item_id not between", value1, value2, "itemId"); return (Criteria) this; } public Criteria andCreatedIsNull() { addCriterion("created is null"); return (Criteria) this; } public Criteria andCreatedIsNotNull() { addCriterion("created is not null"); return (Criteria) this; } public Criteria andCreatedEqualTo(Date value) { addCriterion("created =", value, "created"); return (Criteria) this; } public Criteria andCreatedNotEqualTo(Date value) { addCriterion("created <>", value, "created"); return (Criteria) this; } public Criteria andCreatedGreaterThan(Date value) { addCriterion("created >", value, "created"); return (Criteria) this; } public Criteria andCreatedGreaterThanOrEqualTo(Date value) { addCriterion("created >=", value, "created"); return (Criteria) this; } public Criteria andCreatedLessThan(Date value) { addCriterion("created <", value, "created"); return (Criteria) this; } public Criteria andCreatedLessThanOrEqualTo(Date value) { addCriterion("created <=", value, "created"); return (Criteria) this; } public Criteria andCreatedIn(List<Date> values) { addCriterion("created in", values, "created"); return (Criteria) this; } public Criteria andCreatedNotIn(List<Date> values) { addCriterion("created not in", values, "created"); return (Criteria) this; } public Criteria andCreatedBetween(Date value1, Date value2) { addCriterion("created between", value1, value2, "created"); return (Criteria) this; } public Criteria andCreatedNotBetween(Date value1, Date value2) { addCriterion("created not between", value1, value2, "created"); return (Criteria) this; } public Criteria andUpdatedIsNull() { addCriterion("updated is null"); return (Criteria) this; } public Criteria andUpdatedIsNotNull() { addCriterion("updated is not null"); return (Criteria) this; } public Criteria andUpdatedEqualTo(Date value) { addCriterion("updated =", value, "updated"); return (Criteria) this; } public Criteria andUpdatedNotEqualTo(Date value) { addCriterion("updated <>", value, "updated"); return (Criteria) this; } public Criteria andUpdatedGreaterThan(Date value) { addCriterion("updated >", value, "updated"); return (Criteria) this; } public Criteria andUpdatedGreaterThanOrEqualTo(Date value) { addCriterion("updated >=", value, "updated"); return (Criteria) this; } public Criteria andUpdatedLessThan(Date value) { addCriterion("updated <", value, "updated"); return (Criteria) this; } public Criteria andUpdatedLessThanOrEqualTo(Date value) { addCriterion("updated <=", value, "updated"); return (Criteria) this; } public Criteria andUpdatedIn(List<Date> values) { addCriterion("updated in", values, "updated"); return (Criteria) this; } public Criteria andUpdatedNotIn(List<Date> values) { addCriterion("updated not in", values, "updated"); return (Criteria) this; } public Criteria andUpdatedBetween(Date value1, Date value2) { addCriterion("updated between", value1, value2, "updated"); return (Criteria) this; } public Criteria andUpdatedNotBetween(Date value1, Date value2) { addCriterion("updated not between", value1, value2, "updated"); return (Criteria) this; } } public static class Criteria extends GeneratedCriteria { protected Criteria() { super(); } } public static class Criterion { private String condition; private Object value; private Object secondValue; private boolean noValue; private boolean singleValue; private boolean betweenValue; private boolean listValue; private String typeHandler; public String getCondition() { return condition; } public Object getValue() { return value; } public Object getSecondValue() { return secondValue; } public boolean isNoValue() { return noValue; } public boolean isSingleValue() { return singleValue; } public boolean isBetweenValue() { return betweenValue; } public boolean isListValue() { return listValue; } public String getTypeHandler() { return typeHandler; } protected Criterion(String condition) { super(); this.condition = condition; this.typeHandler = null; this.noValue = true; } protected Criterion(String condition, Object value, String typeHandler) { super(); this.condition = condition; this.value = value; this.typeHandler = typeHandler; if (value instanceof List<?>) { this.listValue = true; } else { this.singleValue = true; } } protected Criterion(String condition, Object value) { this(condition, value, null); } protected Criterion(String condition, Object value, Object secondValue, String typeHandler) { super(); this.condition = condition; this.value = value; this.secondValue = secondValue; this.typeHandler = typeHandler; this.betweenValue = true; } protected Criterion(String condition, Object value, Object secondValue) { this(condition, value, secondValue, null); } } }
TbOrder.java
package com.taotao.pojo; import java.util.Date; public class TbOrder { private String orderId; private String payment; private Integer paymentType; private String postFee; private Integer status; private Date createTime; private Date updateTime; private Date paymentTime; private Date consignTime; private Date endTime; private Date closeTime; private String shippingName; private String shippingCode; private Long userId; private String buyerMessage; private String buyerNick; private Integer buyerRate; public String getOrderId() { return orderId; } public void setOrderId(String orderId) { this.orderId = orderId == null ? null : orderId.trim(); } public String getPayment() { return payment; } public void setPayment(String payment) { this.payment = payment == null ? null : payment.trim(); } public Integer getPaymentType() { return paymentType; } public void setPaymentType(Integer paymentType) { this.paymentType = paymentType; } public String getPostFee() { return postFee; } public void setPostFee(String postFee) { this.postFee = postFee == null ? null : postFee.trim(); } public Integer getStatus() { return status; } public void setStatus(Integer status) { this.status = status; } public Date getCreateTime() { return createTime; } public void setCreateTime(Date createTime) { this.createTime = createTime; } public Date getUpdateTime() { return updateTime; } public void setUpdateTime(Date updateTime) { this.updateTime = updateTime; } public Date getPaymentTime() { return paymentTime; } public void setPaymentTime(Date paymentTime) { this.paymentTime = paymentTime; } public Date getConsignTime() { return consignTime; } public void setConsignTime(Date consignTime) { this.consignTime = consignTime; } public Date getEndTime() { return endTime; } public void setEndTime(Date endTime) { this.endTime = endTime; } public Date getCloseTime() { return closeTime; } public void setCloseTime(Date closeTime) { this.closeTime = closeTime; } public String getShippingName() { return shippingName; } public void setShippingName(String shippingName) { this.shippingName = shippingName == null ? null : shippingName.trim(); } public String getShippingCode() { return shippingCode; } public void setShippingCode(String shippingCode) { this.shippingCode = shippingCode == null ? null : shippingCode.trim(); } public Long getUserId() { return userId; } public void setUserId(Long userId) { this.userId = userId; } public String getBuyerMessage() { return buyerMessage; } public void setBuyerMessage(String buyerMessage) { this.buyerMessage = buyerMessage == null ? null : buyerMessage.trim(); } public String getBuyerNick() { return buyerNick; } public void setBuyerNick(String buyerNick) { this.buyerNick = buyerNick == null ? null : buyerNick.trim(); } public Integer getBuyerRate() { return buyerRate; } public void setBuyerRate(Integer buyerRate) { this.buyerRate = buyerRate; } }
TbOrderExample.java
package com.taotao.pojo; import java.util.ArrayList; import java.util.Date; import java.util.List; public class TbOrderExample { protected String orderByClause; protected boolean distinct; protected List<Criteria> oredCriteria; public TbOrderExample() { oredCriteria = new ArrayList<Criteria>(); } public void setOrderByClause(String orderByClause) { this.orderByClause = orderByClause; } public String getOrderByClause() { return orderByClause; } public void setDistinct(boolean distinct) { this.distinct = distinct; } public boolean isDistinct() { return distinct; } public List<Criteria> getOredCriteria() { return oredCriteria; } public void or(Criteria criteria) { oredCriteria.add(criteria); } public Criteria or() { Criteria criteria = createCriteriaInternal(); oredCriteria.add(criteria); return criteria; } public Criteria createCriteria() { Criteria criteria = createCriteriaInternal(); if (oredCriteria.size() == 0) { oredCriteria.add(criteria); } return criteria; } protected Criteria createCriteriaInternal() { Criteria criteria = new Criteria(); return criteria; } public void clear() { oredCriteria.clear(); orderByClause = null; distinct = false; } protected abstract static class GeneratedCriteria { protected List<Criterion> criteria; protected GeneratedCriteria() { super(); criteria = new ArrayList<Criterion>(); } public boolean isValid() { return criteria.size() > 0; } public List<Criterion> getAllCriteria() { return criteria; } public List<Criterion> getCriteria() { return criteria; } protected void addCriterion(String condition) { if (condition == null) { throw new RuntimeException("Value for condition cannot be null"); } criteria.add(new Criterion(condition)); } protected void addCriterion(String condition, Object value, String property) { if (value == null) { throw new RuntimeException("Value for " + property + " cannot be null"); } criteria.add(new Criterion(condition, value)); } protected void addCriterion(String condition, Object value1, Object value2, String property) { if (value1 == null || value2 == null) { throw new RuntimeException("Between values for " + property + " cannot be null"); } criteria.add(new Criterion(condition, value1, value2)); } public Criteria andOrderIdIsNull() { addCriterion("order_id is null"); return (Criteria) this; } public Criteria andOrderIdIsNotNull() { addCriterion("order_id is not null"); return (Criteria) this; } public Criteria andOrderIdEqualTo(String value) { addCriterion("order_id =", value, "orderId"); return (Criteria) this; } public Criteria andOrderIdNotEqualTo(String value) { addCriterion("order_id <>", value, "orderId"); return (Criteria) this; } public Criteria andOrderIdGreaterThan(String value) { addCriterion("order_id >", value, "orderId"); return (Criteria) this; } public Criteria andOrderIdGreaterThanOrEqualTo(String value) { addCriterion("order_id >=", value, "orderId"); return (Criteria) this; } public Criteria andOrderIdLessThan(String value) { addCriterion("order_id <", value, "orderId"); return (Criteria) this; } public Criteria andOrderIdLessThanOrEqualTo(String value) { addCriterion("order_id <=", value, "orderId"); return (Criteria) this; } public Criteria andOrderIdLike(String value) { addCriterion("order_id like", value, "orderId"); return (Criteria) this; } public Criteria andOrderIdNotLike(String value) { addCriterion("order_id not like", value, "orderId"); return (Criteria) this; } public Criteria andOrderIdIn(List<String> values) { addCriterion("order_id in", values, "orderId"); return (Criteria) this; } public Criteria andOrderIdNotIn(List<String> values) { addCriterion("order_id not in", values, "orderId"); return (Criteria) this; } public Criteria andOrderIdBetween(String value1, String value2) { addCriterion("order_id between", value1, value2, "orderId"); return (Criteria) this; } public Criteria andOrderIdNotBetween(String value1, String value2) { addCriterion("order_id not between", value1, value2, "orderId"); return (Criteria) this; } public Criteria andPaymentIsNull() { addCriterion("payment is null"); return (Criteria) this; } public Criteria andPaymentIsNotNull() { addCriterion("payment is not null"); return (Criteria) this; } public Criteria andPaymentEqualTo(String value) { addCriterion("payment =", value, "payment"); return (Criteria) this; } public Criteria andPaymentNotEqualTo(String value) { addCriterion("payment <>", value, "payment"); return (Criteria) this; } public Criteria andPaymentGreaterThan(String value) { addCriterion("payment >", value, "payment"); return (Criteria) this; } public Criteria andPaymentGreaterThanOrEqualTo(String value) { addCriterion("payment >=", value, "payment"); return (Criteria) this; } public Criteria andPaymentLessThan(String value) { addCriterion("payment <", value, "payment"); return (Criteria) this; } public Criteria andPaymentLessThanOrEqualTo(String value) { addCriterion("payment <=", value, "payment"); return (Criteria) this; } public Criteria andPaymentLike(String value) { addCriterion("payment like", value, "payment"); return (Criteria) this; } public Criteria andPaymentNotLike(String value) { addCriterion("payment not like", value, "payment"); return (Criteria) this; } public Criteria andPaymentIn(List<String> values) { addCriterion("payment in", values, "payment"); return (Criteria) this; } public Criteria andPaymentNotIn(List<String> values) { addCriterion("payment not in", values, "payment"); return (Criteria) this; } public Criteria andPaymentBetween(String value1, String value2) { addCriterion("payment between", value1, value2, "payment"); return (Criteria) this; } public Criteria andPaymentNotBetween(String value1, String value2) { addCriterion("payment not between", value1, value2, "payment"); return (Criteria) this; } public Criteria andPaymentTypeIsNull() { addCriterion("payment_type is null"); return (Criteria) this; } public Criteria andPaymentTypeIsNotNull() { addCriterion("payment_type is not null"); return (Criteria) this; } public Criteria andPaymentTypeEqualTo(Integer value) { addCriterion("payment_type =", value, "paymentType"); return (Criteria) this; } public Criteria andPaymentTypeNotEqualTo(Integer value) { addCriterion("payment_type <>", value, "paymentType"); return (Criteria) this; } public Criteria andPaymentTypeGreaterThan(Integer value) { addCriterion("payment_type >", value, "paymentType"); return (Criteria) this; } public Criteria andPaymentTypeGreaterThanOrEqualTo(Integer value) { addCriterion("payment_type >=", value, "paymentType"); return (Criteria) this; } public Criteria andPaymentTypeLessThan(Integer value) { addCriterion("payment_type <", value, "paymentType"); return (Criteria) this; } public Criteria andPaymentTypeLessThanOrEqualTo(Integer value) { addCriterion("payment_type <=", value, "paymentType"); return (Criteria) this; } public Criteria andPaymentTypeIn(List<Integer> values) { addCriterion("payment_type in", values, "paymentType"); return (Criteria) this; } public Criteria andPaymentTypeNotIn(List<Integer> values) { addCriterion("payment_type not in", values, "paymentType"); return (Criteria) this; } public Criteria andPaymentTypeBetween(Integer value1, Integer value2) { addCriterion("payment_type between", value1, value2, "paymentType"); return (Criteria) this; } public Criteria andPaymentTypeNotBetween(Integer value1, Integer value2) { addCriterion("payment_type not between", value1, value2, "paymentType"); return (Criteria) this; } public Criteria andPostFeeIsNull() { addCriterion("post_fee is null"); return (Criteria) this; } public Criteria andPostFeeIsNotNull() { addCriterion("post_fee is not null"); return (Criteria) this; } public Criteria andPostFeeEqualTo(String value) { addCriterion("post_fee =", value, "postFee"); return (Criteria) this; } public Criteria andPostFeeNotEqualTo(String value) { addCriterion("post_fee <>", value, "postFee"); return (Criteria) this; } public Criteria andPostFeeGreaterThan(String value) { addCriterion("post_fee >", value, "postFee"); return (Criteria) this; } public Criteria andPostFeeGreaterThanOrEqualTo(String value) { addCriterion("post_fee >=", value, "postFee"); return (Criteria) this; } public Criteria andPostFeeLessThan(String value) { addCriterion("post_fee <", value, "postFee"); return (Criteria) this; } public Criteria andPostFeeLessThanOrEqualTo(String value) { addCriterion("post_fee <=", value, "postFee"); return (Criteria) this; } public Criteria andPostFeeLike(String value) { addCriterion("post_fee like", value, "postFee"); return (Criteria) this; } public Criteria andPostFeeNotLike(String value) { addCriterion("post_fee not like", value, "postFee"); return (Criteria) this; } public Criteria andPostFeeIn(List<String> values) { addCriterion("post_fee in", values, "postFee"); return (Criteria) this; } public Criteria andPostFeeNotIn(List<String> values) { addCriterion("post_fee not in", values, "postFee"); return (Criteria) this; } public Criteria andPostFeeBetween(String value1, String value2) { addCriterion("post_fee between", value1, value2, "postFee"); return (Criteria) this; } public Criteria andPostFeeNotBetween(String value1, String value2) { addCriterion("post_fee not between", value1, value2, "postFee"); return (Criteria) this; } public Criteria andStatusIsNull() { addCriterion("status is null"); return (Criteria) this; } public Criteria andStatusIsNotNull() { addCriterion("status is not null"); return (Criteria) this; } public Criteria andStatusEqualTo(Integer value) { addCriterion("status =", value, "status"); return (Criteria) this; } public Criteria andStatusNotEqualTo(Integer value) { addCriterion("status <>", value, "status"); return (Criteria) this; } public Criteria andStatusGreaterThan(Integer value) { addCriterion("status >", value, "status"); return (Criteria) this; } public Criteria andStatusGreaterThanOrEqualTo(Integer value) { addCriterion("status >=", value, "status"); return (Criteria) this; } public Criteria andStatusLessThan(Integer value) { addCriterion("status <", value, "status"); return (Criteria) this; } public Criteria andStatusLessThanOrEqualTo(Integer value) { addCriterion("status <=", value, "status"); return (Criteria) this; } public Criteria andStatusIn(List<Integer> values) { addCriterion("status in", values, "status"); return (Criteria) this; } public Criteria andStatusNotIn(List<Integer> values) { addCriterion("status not in", values, "status"); return (Criteria) this; } public Criteria andStatusBetween(Integer value1, Integer value2) { addCriterion("status between", value1, value2, "status"); return (Criteria) this; } public Criteria andStatusNotBetween(Integer value1, Integer value2) { addCriterion("status not between", value1, value2, "status"); return (Criteria) this; } public Criteria andCreateTimeIsNull() { addCriterion("create_time is null"); return (Criteria) this; } public Criteria andCreateTimeIsNotNull() { addCriterion("create_time is not null"); return (Criteria) this; } public Criteria andCreateTimeEqualTo(Date value) { addCriterion("create_time =", value, "createTime"); return (Criteria) this; } public Criteria andCreateTimeNotEqualTo(Date value) { addCriterion("create_time <>", value, "createTime"); return (Criteria) this; } public Criteria andCreateTimeGreaterThan(Date value) { addCriterion("create_time >", value, "createTime"); return (Criteria) this; } public Criteria andCreateTimeGreaterThanOrEqualTo(Date value) { addCriterion("create_time >=", value, "createTime"); return (Criteria) this; } public Criteria andCreateTimeLessThan(Date value) { addCriterion("create_time <", value, "createTime"); return (Criteria) this; } public Criteria andCreateTimeLessThanOrEqualTo(Date value) { addCriterion("create_time <=", value, "createTime"); return (Criteria) this; } public Criteria andCreateTimeIn(List<Date> values) { addCriterion("create_time in", values, "createTime"); return (Criteria) this; } public Criteria andCreateTimeNotIn(List<Date> values) { addCriterion("create_time not in", values, "createTime"); return (Criteria) this; } public Criteria andCreateTimeBetween(Date value1, Date value2) { addCriterion("create_time between", value1, value2, "createTime"); return (Criteria) this; } public Criteria andCreateTimeNotBetween(Date value1, Date value2) { addCriterion("create_time not between", value1, value2, "createTime"); return (Criteria) this; } public Criteria andUpdateTimeIsNull() { addCriterion("update_time is null"); return (Criteria) this; } public Criteria andUpdateTimeIsNotNull() { addCriterion("update_time is not null"); return (Criteria) this; } public Criteria andUpdateTimeEqualTo(Date value) { addCriterion("update_time =", value, "updateTime"); return (Criteria) this; } public Criteria andUpdateTimeNotEqualTo(Date value) { addCriterion("update_time <>", value, "updateTime"); return (Criteria) this; } public Criteria andUpdateTimeGreaterThan(Date value) { addCriterion("update_time >", value, "updateTime"); return (Criteria) this; } public Criteria andUpdateTimeGreaterThanOrEqualTo(Date value) { addCriterion("update_time >=", value, "updateTime"); return (Criteria) this; } public Criteria andUpdateTimeLessThan(Date value) { addCriterion("update_time <", value, "updateTime"); return (Criteria) this; } public Criteria andUpdateTimeLessThanOrEqualTo(Date value) { addCriterion("update_time <=", value, "updateTime"); return (Criteria) this; } public Criteria andUpdateTimeIn(List<Date> values) { addCriterion("update_time in", values, "updateTime"); return (Criteria) this; } public Criteria andUpdateTimeNotIn(List<Date> values) { addCriterion("update_time not in", values, "updateTime"); return (Criteria) this; } public Criteria andUpdateTimeBetween(Date value1, Date value2) { addCriterion("update_time between", value1, value2, "updateTime"); return (Criteria) this; } public Criteria andUpdateTimeNotBetween(Date value1, Date value2) { addCriterion("update_time not between", value1, value2, "updateTime"); return (Criteria) this; } public Criteria andPaymentTimeIsNull() { addCriterion("payment_time is null"); return (Criteria) this; } public Criteria andPaymentTimeIsNotNull() { addCriterion("payment_time is not null"); return (Criteria) this; } public Criteria andPaymentTimeEqualTo(Date value) { addCriterion("payment_time =", value, "paymentTime"); return (Criteria) this; } public Criteria andPaymentTimeNotEqualTo(Date value) { addCriterion("payment_time <>", value, "paymentTime"); return (Criteria) this; } public Criteria andPaymentTimeGreaterThan(Date value) { addCriterion("payment_time >", value, "paymentTime"); return (Criteria) this; } public Criteria andPaymentTimeGreaterThanOrEqualTo(Date value) { addCriterion("payment_time >=", value, "paymentTime"); return (Criteria) this; } public Criteria andPaymentTimeLessThan(Date value) { addCriterion("payment_time <", value, "paymentTime"); return (Criteria) this; } public Criteria andPaymentTimeLessThanOrEqualTo(Date value) { addCriterion("payment_time <=", value, "paymentTime"); return (Criteria) this; } public Criteria andPaymentTimeIn(List<Date> values) { addCriterion("payment_time in", values, "paymentTime"); return (Criteria) this; } public Criteria andPaymentTimeNotIn(List<Date> values) { addCriterion("payment_time not in", values, "paymentTime"); return (Criteria) this; } public Criteria andPaymentTimeBetween(Date value1, Date value2) { addCriterion("payment_time between", value1, value2, "paymentTime"); return (Criteria) this; } public Criteria andPaymentTimeNotBetween(Date value1, Date value2) { addCriterion("payment_time not between", value1, value2, "paymentTime"); return (Criteria) this; } public Criteria andConsignTimeIsNull() { addCriterion("consign_time is null"); return (Criteria) this; } public Criteria andConsignTimeIsNotNull() { addCriterion("consign_time is not null"); return (Criteria) this; } public Criteria andConsignTimeEqualTo(Date value) { addCriterion("consign_time =", value, "consignTime"); return (Criteria) this; } public Criteria andConsignTimeNotEqualTo(Date value) { addCriterion("consign_time <>", value, "consignTime"); return (Criteria) this; } public Criteria andConsignTimeGreaterThan(Date value) { addCriterion("consign_time >", value, "consignTime"); return (Criteria) this; } public Criteria andConsignTimeGreaterThanOrEqualTo(Date value) { addCriterion("consign_time >=", value, "consignTime"); return (Criteria) this; } public Criteria andConsignTimeLessThan(Date value) { addCriterion("consign_time <", value, "consignTime"); return (Criteria) this; } public Criteria andConsignTimeLessThanOrEqualTo(Date value) { addCriterion("consign_time <=", value, "consignTime"); return (Criteria) this; } public Criteria andConsignTimeIn(List<Date> values) { addCriterion("consign_time in", values, "consignTime"); return (Criteria) this; } public Criteria andConsignTimeNotIn(List<Date> values) { addCriterion("consign_time not in", values, "consignTime"); return (Criteria) this; } public Criteria andConsignTimeBetween(Date value1, Date value2) { addCriterion("consign_time between", value1, value2, "consignTime"); return (Criteria) this; } public Criteria andConsignTimeNotBetween(Date value1, Date value2) { addCriterion("consign_time not between", value1, value2, "consignTime"); return (Criteria) this; } public Criteria andEndTimeIsNull() { addCriterion("end_time is null"); return (Criteria) this; } public Criteria andEndTimeIsNotNull() { addCriterion("end_time is not null"); return (Criteria) this; } public Criteria andEndTimeEqualTo(Date value) { addCriterion("end_time =", value, "endTime"); return (Criteria) this; } public Criteria andEndTimeNotEqualTo(Date value) { addCriterion("end_time <>", value, "endTime"); return (Criteria) this; } public Criteria andEndTimeGreaterThan(Date value) { addCriterion("end_time >", value, "endTime"); return (Criteria) this; } public Criteria andEndTimeGreaterThanOrEqualTo(Date value) { addCriterion("end_time >=", value, "endTime"); return (Criteria) this; } public Criteria andEndTimeLessThan(Date value) { addCriterion("end_time <", value, "endTime"); return (Criteria) this; } public Criteria andEndTimeLessThanOrEqualTo(Date value) { addCriterion("end_time <=", value, "endTime"); return (Criteria) this; } public Criteria andEndTimeIn(List<Date> values) { addCriterion("end_time in", values, "endTime"); return (Criteria) this; } public Criteria andEndTimeNotIn(List<Date> values) { addCriterion("end_time not in", values, "endTime"); return (Criteria) this; } public Criteria andEndTimeBetween(Date value1, Date value2) { addCriterion("end_time between", value1, value2, "endTime"); return (Criteria) this; } public Criteria andEndTimeNotBetween(Date value1, Date value2) { addCriterion("end_time not between", value1, value2, "endTime"); return (Criteria) this; } public Criteria andCloseTimeIsNull() { addCriterion("close_time is null"); return (Criteria) this; } public Criteria andCloseTimeIsNotNull() { addCriterion("close_time is not null"); return (Criteria) this; } public Criteria andCloseTimeEqualTo(Date value) { addCriterion("close_time =", value, "closeTime"); return (Criteria) this; } public Criteria andCloseTimeNotEqualTo(Date value) { addCriterion("close_time <>", value, "closeTime"); return (Criteria) this; } public Criteria andCloseTimeGreaterThan(Date value) { addCriterion("close_time >", value, "closeTime"); return (Criteria) this; } public Criteria andCloseTimeGreaterThanOrEqualTo(Date value) { addCriterion("close_time >=", value, "closeTime"); return (Criteria) this; } public Criteria andCloseTimeLessThan(Date value) { addCriterion("close_time <", value, "closeTime"); return (Criteria) this; } public Criteria andCloseTimeLessThanOrEqualTo(Date value) { addCriterion("close_time <=", value, "closeTime"); return (Criteria) this; } public Criteria andCloseTimeIn(List<Date> values) { addCriterion("close_time in", values, "closeTime"); return (Criteria) this; } public Criteria andCloseTimeNotIn(List<Date> values) { addCriterion("close_time not in", values, "closeTime"); return (Criteria) this; } public Criteria andCloseTimeBetween(Date value1, Date value2) { addCriterion("close_time between", value1, value2, "closeTime"); return (Criteria) this; } public Criteria andCloseTimeNotBetween(Date value1, Date value2) { addCriterion("close_time not between", value1, value2, "closeTime"); return (Criteria) this; } public Criteria andShippingNameIsNull() { addCriterion("shipping_name is null"); return (Criteria) this; } public Criteria andShippingNameIsNotNull() { addCriterion("shipping_name is not null"); return (Criteria) this; } public Criteria andShippingNameEqualTo(String value) { addCriterion("shipping_name =", value, "shippingName"); return (Criteria) this; } public Criteria andShippingNameNotEqualTo(String value) { addCriterion("shipping_name <>", value, "shippingName"); return (Criteria) this; } public Criteria andShippingNameGreaterThan(String value) { addCriterion("shipping_name >", value, "shippingName"); return (Criteria) this; } public Criteria andShippingNameGreaterThanOrEqualTo(String value) { addCriterion("shipping_name >=", value, "shippingName"); return (Criteria) this; } public Criteria andShippingNameLessThan(String value) { addCriterion("shipping_name <", value, "shippingName"); return (Criteria) this; } public Criteria andShippingNameLessThanOrEqualTo(String value) { addCriterion("shipping_name <=", value, "shippingName"); return (Criteria) this; } public Criteria andShippingNameLike(String value) { addCriterion("shipping_name like", value, "shippingName"); return (Criteria) this; } public Criteria andShippingNameNotLike(String value) { addCriterion("shipping_name not like", value, "shippingName"); return (Criteria) this; } public Criteria andShippingNameIn(List<String> values) { addCriterion("shipping_name in", values, "shippingName"); return (Criteria) this; } public Criteria andShippingNameNotIn(List<String> values) { addCriterion("shipping_name not in", values, "shippingName"); return (Criteria) this; } public Criteria andShippingNameBetween(String value1, String value2) { addCriterion("shipping_name between", value1, value2, "shippingName"); return (Criteria) this; } public Criteria andShippingNameNotBetween(String value1, String value2) { addCriterion("shipping_name not between", value1, value2, "shippingName"); return (Criteria) this; } public Criteria andShippingCodeIsNull() { addCriterion("shipping_code is null"); return (Criteria) this; } public Criteria andShippingCodeIsNotNull() { addCriterion("shipping_code is not null"); return (Criteria) this; } public Criteria andShippingCodeEqualTo(String value) { addCriterion("shipping_code =", value, "shippingCode"); return (Criteria) this; } public Criteria andShippingCodeNotEqualTo(String value) { addCriterion("shipping_code <>", value, "shippingCode"); return (Criteria) this; } public Criteria andShippingCodeGreaterThan(String value) { addCriterion("shipping_code >", value, "shippingCode"); return (Criteria) this; } public Criteria andShippingCodeGreaterThanOrEqualTo(String value) { addCriterion("shipping_code >=", value, "shippingCode"); return (Criteria) this; } public Criteria andShippingCodeLessThan(String value) { addCriterion("shipping_code <", value, "shippingCode"); return (Criteria) this; } public Criteria andShippingCodeLessThanOrEqualTo(String value) { addCriterion("shipping_code <=", value, "shippingCode"); return (Criteria) this; } public Criteria andShippingCodeLike(String value) { addCriterion("shipping_code like", value, "shippingCode"); return (Criteria) this; } public Criteria andShippingCodeNotLike(String value) { addCriterion("shipping_code not like", value, "shippingCode"); return (Criteria) this; } public Criteria andShippingCodeIn(List<String> values) { addCriterion("shipping_code in", values, "shippingCode"); return (Criteria) this; } public Criteria andShippingCodeNotIn(List<String> values) { addCriterion("shipping_code not in", values, "shippingCode"); return (Criteria) this; } public Criteria andShippingCodeBetween(String value1, String value2) { addCriterion("shipping_code between", value1, value2, "shippingCode"); return (Criteria) this; } public Criteria andShippingCodeNotBetween(String value1, String value2) { addCriterion("shipping_code not between", value1, value2, "shippingCode"); return (Criteria) this; } public Criteria andUserIdIsNull() { addCriterion("user_id is null"); return (Criteria) this; } public Criteria andUserIdIsNotNull() { addCriterion("user_id is not null"); return (Criteria) this; } public Criteria andUserIdEqualTo(Long value) { addCriterion("user_id =", value, "userId"); return (Criteria) this; } public Criteria andUserIdNotEqualTo(Long value) { addCriterion("user_id <>", value, "userId"); return (Criteria) this; } public Criteria andUserIdGreaterThan(Long value) { addCriterion("user_id >", value, "userId"); return (Criteria) this; } public Criteria andUserIdGreaterThanOrEqualTo(Long value) { addCriterion("user_id >=", value, "userId"); return (Criteria) this; } public Criteria andUserIdLessThan(Long value) { addCriterion("user_id <", value, "userId"); return (Criteria) this; } public Criteria andUserIdLessThanOrEqualTo(Long value) { addCriterion("user_id <=", value, "userId"); return (Criteria) this; } public Criteria andUserIdIn(List<Long> values) { addCriterion("user_id in", values, "userId"); return (Criteria) this; } public Criteria andUserIdNotIn(List<Long> values) { addCriterion("user_id not in", values, "userId"); return (Criteria) this; } public Criteria andUserIdBetween(Long value1, Long value2) { addCriterion("user_id between", value1, value2, "userId"); return (Criteria) this; } public Criteria andUserIdNotBetween(Long value1, Long value2) { addCriterion("user_id not between", value1, value2, "userId"); return (Criteria) this; } public Criteria andBuyerMessageIsNull() { addCriterion("buyer_message is null"); return (Criteria) this; } public Criteria andBuyerMessageIsNotNull() { addCriterion("buyer_message is not null"); return (Criteria) this; } public Criteria andBuyerMessageEqualTo(String value) { addCriterion("buyer_message =", value, "buyerMessage"); return (Criteria) this; } public Criteria andBuyerMessageNotEqualTo(String value) { addCriterion("buyer_message <>", value, "buyerMessage"); return (Criteria) this; } public Criteria andBuyerMessageGreaterThan(String value) { addCriterion("buyer_message >", value, "buyerMessage"); return (Criteria) this; } public Criteria andBuyerMessageGreaterThanOrEqualTo(String value) { addCriterion("buyer_message >=", value, "buyerMessage"); return (Criteria) this; } public Criteria andBuyerMessageLessThan(String value) { addCriterion("buyer_message <", value, "buyerMessage"); return (Criteria) this; } public Criteria andBuyerMessageLessThanOrEqualTo(String value) { addCriterion("buyer_message <=", value, "buyerMessage"); return (Criteria) this; } public Criteria andBuyerMessageLike(String value) { addCriterion("buyer_message like", value, "buyerMessage"); return (Criteria) this; } public Criteria andBuyerMessageNotLike(String value) { addCriterion("buyer_message not like", value, "buyerMessage"); return (Criteria) this; } public Criteria andBuyerMessageIn(List<String> values) { addCriterion("buyer_message in", values, "buyerMessage"); return (Criteria) this; } public Criteria andBuyerMessageNotIn(List<String> values) { addCriterion("buyer_message not in", values, "buyerMessage"); return (Criteria) this; } public Criteria andBuyerMessageBetween(String value1, String value2) { addCriterion("buyer_message between", value1, value2, "buyerMessage"); return (Criteria) this; } public Criteria andBuyerMessageNotBetween(String value1, String value2) { addCriterion("buyer_message not between", value1, value2, "buyerMessage"); return (Criteria) this; } public Criteria andBuyerNickIsNull() { addCriterion("buyer_nick is null"); return (Criteria) this; } public Criteria andBuyerNickIsNotNull() { addCriterion("buyer_nick is not null"); return (Criteria) this; } public Criteria andBuyerNickEqualTo(String value) { addCriterion("buyer_nick =", value, "buyerNick"); return (Criteria) this; } public Criteria andBuyerNickNotEqualTo(String value) { addCriterion("buyer_nick <>", value, "buyerNick"); return (Criteria) this; } public Criteria andBuyerNickGreaterThan(String value) { addCriterion("buyer_nick >", value, "buyerNick"); return (Criteria) this; } public Criteria andBuyerNickGreaterThanOrEqualTo(String value) { addCriterion("buyer_nick >=", value, "buyerNick"); return (Criteria) this; } public Criteria andBuyerNickLessThan(String value) { addCriterion("buyer_nick <", value, "buyerNick"); return (Criteria) this; } public Criteria andBuyerNickLessThanOrEqualTo(String value) { addCriterion("buyer_nick <=", value, "buyerNick"); return (Criteria) this; } public Criteria andBuyerNickLike(String value) { addCriterion("buyer_nick like", value, "buyerNick"); return (Criteria) this; } public Criteria andBuyerNickNotLike(String value) { addCriterion("buyer_nick not like", value, "buyerNick"); return (Criteria) this; } public Criteria andBuyerNickIn(List<String> values) { addCriterion("buyer_nick in", values, "buyerNick"); return (Criteria) this; } public Criteria andBuyerNickNotIn(List<String> values) { addCriterion("buyer_nick not in", values, "buyerNick"); return (Criteria) this; } public Criteria andBuyerNickBetween(String value1, String value2) { addCriterion("buyer_nick between", value1, value2, "buyerNick"); return (Criteria) this; } public Criteria andBuyerNickNotBetween(String value1, String value2) { addCriterion("buyer_nick not between", value1, value2, "buyerNick"); return (Criteria) this; } public Criteria andBuyerRateIsNull() { addCriterion("buyer_rate is null"); return (Criteria) this; } public Criteria andBuyerRateIsNotNull() { addCriterion("buyer_rate is not null"); return (Criteria) this; } public Criteria andBuyerRateEqualTo(Integer value) { addCriterion("buyer_rate =", value, "buyerRate"); return (Criteria) this; } public Criteria andBuyerRateNotEqualTo(Integer value) { addCriterion("buyer_rate <>", value, "buyerRate"); return (Criteria) this; } public Criteria andBuyerRateGreaterThan(Integer value) { addCriterion("buyer_rate >", value, "buyerRate"); return (Criteria) this; } public Criteria andBuyerRateGreaterThanOrEqualTo(Integer value) { addCriterion("buyer_rate >=", value, "buyerRate"); return (Criteria) this; } public Criteria andBuyerRateLessThan(Integer value) { addCriterion("buyer_rate <", value, "buyerRate"); return (Criteria) this; } public Criteria andBuyerRateLessThanOrEqualTo(Integer value) { addCriterion("buyer_rate <=", value, "buyerRate"); return (Criteria) this; } public Criteria andBuyerRateIn(List<Integer> values) { addCriterion("buyer_rate in", values, "buyerRate"); return (Criteria) this; } public Criteria andBuyerRateNotIn(List<Integer> values) { addCriterion("buyer_rate not in", values, "buyerRate"); return (Criteria) this; } public Criteria andBuyerRateBetween(Integer value1, Integer value2) { addCriterion("buyer_rate between", value1, value2, "buyerRate"); return (Criteria) this; } public Criteria andBuyerRateNotBetween(Integer value1, Integer value2) { addCriterion("buyer_rate not between", value1, value2, "buyerRate"); return (Criteria) this; } } public static class Criteria extends GeneratedCriteria { protected Criteria() { super(); } } public static class Criterion { private String condition; private Object value; private Object secondValue; private boolean noValue; private boolean singleValue; private boolean betweenValue; private boolean listValue; private String typeHandler; public String getCondition() { return condition; } public Object getValue() { return value; } public Object getSecondValue() { return secondValue; } public boolean isNoValue() { return noValue; } public boolean isSingleValue() { return singleValue; } public boolean isBetweenValue() { return betweenValue; } public boolean isListValue() { return listValue; } public String getTypeHandler() { return typeHandler; } protected Criterion(String condition) { super(); this.condition = condition; this.typeHandler = null; this.noValue = true; } protected Criterion(String condition, Object value, String typeHandler) { super(); this.condition = condition; this.value = value; this.typeHandler = typeHandler; if (value instanceof List<?>) { this.listValue = true; } else { this.singleValue = true; } } protected Criterion(String condition, Object value) { this(condition, value, null); } protected Criterion(String condition, Object value, Object secondValue, String typeHandler) { super(); this.condition = condition; this.value = value; this.secondValue = secondValue; this.typeHandler = typeHandler; this.betweenValue = true; } protected Criterion(String condition, Object value, Object secondValue) { this(condition, value, secondValue, null); } } }
TbOrderItem.java
package com.taotao.pojo; public class TbOrderItem { private String id; private String itemId; private String orderId; private Integer num; private String title; private Long price; private Long totalFee; private String picPath; public String getId() { return id; } public void setId(String id) { this.id = id == null ? null : id.trim(); } public String getItemId() { return itemId; } public void setItemId(String itemId) { this.itemId = itemId == null ? null : itemId.trim(); } public String getOrderId() { return orderId; } public void setOrderId(String orderId) { this.orderId = orderId == null ? null : orderId.trim(); } public Integer getNum() { return num; } public void setNum(Integer num) { this.num = num; } public String getTitle() { return title; } public void setTitle(String title) { this.title = title == null ? null : title.trim(); } public Long getPrice() { return price; } public void setPrice(Long price) { this.price = price; } public Long getTotalFee() { return totalFee; } public void setTotalFee(Long totalFee) { this.totalFee = totalFee; } public String getPicPath() { return picPath; } public void setPicPath(String picPath) { this.picPath = picPath == null ? null : picPath.trim(); } }
TbOrderItemExample.java
package com.taotao.pojo; import java.util.ArrayList; import java.util.List; public class TbOrderItemExample { protected String orderByClause; protected boolean distinct; protected List<Criteria> oredCriteria; public TbOrderItemExample() { oredCriteria = new ArrayList<Criteria>(); } public void setOrderByClause(String orderByClause) { this.orderByClause = orderByClause; } public String getOrderByClause() { return orderByClause; } public void setDistinct(boolean distinct) { this.distinct = distinct; } public boolean isDistinct() { return distinct; } public List<Criteria> getOredCriteria() { return oredCriteria; } public void or(Criteria criteria) { oredCriteria.add(criteria); } public Criteria or() { Criteria criteria = createCriteriaInternal(); oredCriteria.add(criteria); return criteria; } public Criteria createCriteria() { Criteria criteria = createCriteriaInternal(); if (oredCriteria.size() == 0) { oredCriteria.add(criteria); } return criteria; } protected Criteria createCriteriaInternal() { Criteria criteria = new Criteria(); return criteria; } public void clear() { oredCriteria.clear(); orderByClause = null; distinct = false; } protected abstract static class GeneratedCriteria { protected List<Criterion> criteria; protected GeneratedCriteria() { super(); criteria = new ArrayList<Criterion>(); } public boolean isValid() { return criteria.size() > 0; } public List<Criterion> getAllCriteria() { return criteria; } public List<Criterion> getCriteria() { return criteria; } protected void addCriterion(String condition) { if (condition == null) { throw new RuntimeException("Value for condition cannot be null"); } criteria.add(new Criterion(condition)); } protected void addCriterion(String condition, Object value, String property) { if (value == null) { throw new RuntimeException("Value for " + property + " cannot be null"); } criteria.add(new Criterion(condition, value)); } protected void addCriterion(String condition, Object value1, Object value2, String property) { if (value1 == null || value2 == null) { throw new RuntimeException("Between values for " + property + " cannot be null"); } criteria.add(new Criterion(condition, value1, value2)); } public Criteria andIdIsNull() { addCriterion("id is null"); return (Criteria) this; } public Criteria andIdIsNotNull() { addCriterion("id is not null"); return (Criteria) this; } public Criteria andIdEqualTo(String value) { addCriterion("id =", value, "id"); return (Criteria) this; } public Criteria andIdNotEqualTo(String value) { addCriterion("id <>", value, "id"); return (Criteria) this; } public Criteria andIdGreaterThan(String value) { addCriterion("id >", value, "id"); return (Criteria) this; } public Criteria andIdGreaterThanOrEqualTo(String value) { addCriterion("id >=", value, "id"); return (Criteria) this; } public Criteria andIdLessThan(String value) { addCriterion("id <", value, "id"); return (Criteria) this; } public Criteria andIdLessThanOrEqualTo(String value) { addCriterion("id <=", value, "id"); return (Criteria) this; } public Criteria andIdLike(String value) { addCriterion("id like", value, "id"); return (Criteria) this; } public Criteria andIdNotLike(String value) { addCriterion("id not like", value, "id"); return (Criteria) this; } public Criteria andIdIn(List<String> values) { addCriterion("id in", values, "id"); return (Criteria) this; } public Criteria andIdNotIn(List<String> values) { addCriterion("id not in", values, "id"); return (Criteria) this; } public Criteria andIdBetween(String value1, String value2) { addCriterion("id between", value1, value2, "id"); return (Criteria) this; } public Criteria andIdNotBetween(String value1, String value2) { addCriterion("id not between", value1, value2, "id"); return (Criteria) this; } public Criteria andItemIdIsNull() { addCriterion("item_id is null"); return (Criteria) this; } public Criteria andItemIdIsNotNull() { addCriterion("item_id is not null"); return (Criteria) this; } public Criteria andItemIdEqualTo(String value) { addCriterion("item_id =", value, "itemId"); return (Criteria) this; } public Criteria andItemIdNotEqualTo(String value) { addCriterion("item_id <>", value, "itemId"); return (Criteria) this; } public Criteria andItemIdGreaterThan(String value) { addCriterion("item_id >", value, "itemId"); return (Criteria) this; } public Criteria andItemIdGreaterThanOrEqualTo(String value) { addCriterion("item_id >=", value, "itemId"); return (Criteria) this; } public Criteria andItemIdLessThan(String value) { addCriterion("item_id <", value, "itemId"); return (Criteria) this; } public Criteria andItemIdLessThanOrEqualTo(String value) { addCriterion("item_id <=", value, "itemId"); return (Criteria) this; } public Criteria andItemIdLike(String value) { addCriterion("item_id like", value, "itemId"); return (Criteria) this; } public Criteria andItemIdNotLike(String value) { addCriterion("item_id not like", value, "itemId"); return (Criteria) this; } public Criteria andItemIdIn(List<String> values) { addCriterion("item_id in", values, "itemId"); return (Criteria) this; } public Criteria andItemIdNotIn(List<String> values) { addCriterion("item_id not in", values, "itemId"); return (Criteria) this; } public Criteria andItemIdBetween(String value1, String value2) { addCriterion("item_id between", value1, value2, "itemId"); return (Criteria) this; } public Criteria andItemIdNotBetween(String value1, String value2) { addCriterion("item_id not between", value1, value2, "itemId"); return (Criteria) this; } public Criteria andOrderIdIsNull() { addCriterion("order_id is null"); return (Criteria) this; } public Criteria andOrderIdIsNotNull() { addCriterion("order_id is not null"); return (Criteria) this; } public Criteria andOrderIdEqualTo(String value) { addCriterion("order_id =", value, "orderId"); return (Criteria) this; } public Criteria andOrderIdNotEqualTo(String value) { addCriterion("order_id <>", value, "orderId"); return (Criteria) this; } public Criteria andOrderIdGreaterThan(String value) { addCriterion("order_id >", value, "orderId"); return (Criteria) this; } public Criteria andOrderIdGreaterThanOrEqualTo(String value) { addCriterion("order_id >=", value, "orderId"); return (Criteria) this; } public Criteria andOrderIdLessThan(String value) { addCriterion("order_id <", value, "orderId"); return (Criteria) this; } public Criteria andOrderIdLessThanOrEqualTo(String value) { addCriterion("order_id <=", value, "orderId"); return (Criteria) this; } public Criteria andOrderIdLike(String value) { addCriterion("order_id like", value, "orderId"); return (Criteria) this; } public Criteria andOrderIdNotLike(String value) { addCriterion("order_id not like", value, "orderId"); return (Criteria) this; } public Criteria andOrderIdIn(List<String> values) { addCriterion("order_id in", values, "orderId"); return (Criteria) this; } public Criteria andOrderIdNotIn(List<String> values) { addCriterion("order_id not in", values, "orderId"); return (Criteria) this; } public Criteria andOrderIdBetween(String value1, String value2) { addCriterion("order_id between", value1, value2, "orderId"); return (Criteria) this; } public Criteria andOrderIdNotBetween(String value1, String value2) { addCriterion("order_id not between", value1, value2, "orderId"); return (Criteria) this; } public Criteria andNumIsNull() { addCriterion("num is null"); return (Criteria) this; } public Criteria andNumIsNotNull() { addCriterion("num is not null"); return (Criteria) this; } public Criteria andNumEqualTo(Integer value) { addCriterion("num =", value, "num"); return (Criteria) this; } public Criteria andNumNotEqualTo(Integer value) { addCriterion("num <>", value, "num"); return (Criteria) this; } public Criteria andNumGreaterThan(Integer value) { addCriterion("num >", value, "num"); return (Criteria) this; } public Criteria andNumGreaterThanOrEqualTo(Integer value) { addCriterion("num >=", value, "num"); return (Criteria) this; } public Criteria andNumLessThan(Integer value) { addCriterion("num <", value, "num"); return (Criteria) this; } public Criteria andNumLessThanOrEqualTo(Integer value) { addCriterion("num <=", value, "num"); return (Criteria) this; } public Criteria andNumIn(List<Integer> values) { addCriterion("num in", values, "num"); return (Criteria) this; } public Criteria andNumNotIn(List<Integer> values) { addCriterion("num not in", values, "num"); return (Criteria) this; } public Criteria andNumBetween(Integer value1, Integer value2) { addCriterion("num between", value1, value2, "num"); return (Criteria) this; } public Criteria andNumNotBetween(Integer value1, Integer value2) { addCriterion("num not between", value1, value2, "num"); return (Criteria) this; } public Criteria andTitleIsNull() { addCriterion("title is null"); return (Criteria) this; } public Criteria andTitleIsNotNull() { addCriterion("title is not null"); return (Criteria) this; } public Criteria andTitleEqualTo(String value) { addCriterion("title =", value, "title"); return (Criteria) this; } public Criteria andTitleNotEqualTo(String value) { addCriterion("title <>", value, "title"); return (Criteria) this; } public Criteria andTitleGreaterThan(String value) { addCriterion("title >", value, "title"); return (Criteria) this; } public Criteria andTitleGreaterThanOrEqualTo(String value) { addCriterion("title >=", value, "title"); return (Criteria) this; } public Criteria andTitleLessThan(String value) { addCriterion("title <", value, "title"); return (Criteria) this; } public Criteria andTitleLessThanOrEqualTo(String value) { addCriterion("title <=", value, "title"); return (Criteria) this; } public Criteria andTitleLike(String value) { addCriterion("title like", value, "title"); return (Criteria) this; } public Criteria andTitleNotLike(String value) { addCriterion("title not like", value, "title"); return (Criteria) this; } public Criteria andTitleIn(List<String> values) { addCriterion("title in", values, "title"); return (Criteria) this; } public Criteria andTitleNotIn(List<String> values) { addCriterion("title not in", values, "title"); return (Criteria) this; } public Criteria andTitleBetween(String value1, String value2) { addCriterion("title between", value1, value2, "title"); return (Criteria) this; } public Criteria andTitleNotBetween(String value1, String value2) { addCriterion("title not between", value1, value2, "title"); return (Criteria) this; } public Criteria andPriceIsNull() { addCriterion("price is null"); return (Criteria) this; } public Criteria andPriceIsNotNull() { addCriterion("price is not null"); return (Criteria) this; } public Criteria andPriceEqualTo(Long value) { addCriterion("price =", value, "price"); return (Criteria) this; } public Criteria andPriceNotEqualTo(Long value) { addCriterion("price <>", value, "price"); return (Criteria) this; } public Criteria andPriceGreaterThan(Long value) { addCriterion("price >", value, "price"); return (Criteria) this; } public Criteria andPriceGreaterThanOrEqualTo(Long value) { addCriterion("price >=", value, "price"); return (Criteria) this; } public Criteria andPriceLessThan(Long value) { addCriterion("price <", value, "price"); return (Criteria) this; } public Criteria andPriceLessThanOrEqualTo(Long value) { addCriterion("price <=", value, "price"); return (Criteria) this; } public Criteria andPriceIn(List<Long> values) { addCriterion("price in", values, "price"); return (Criteria) this; } public Criteria andPriceNotIn(List<Long> values) { addCriterion("price not in", values, "price"); return (Criteria) this; } public Criteria andPriceBetween(Long value1, Long value2) { addCriterion("price between", value1, value2, "price"); return (Criteria) this; } public Criteria andPriceNotBetween(Long value1, Long value2) { addCriterion("price not between", value1, value2, "price"); return (Criteria) this; } public Criteria andTotalFeeIsNull() { addCriterion("total_fee is null"); return (Criteria) this; } public Criteria andTotalFeeIsNotNull() { addCriterion("total_fee is not null"); return (Criteria) this; } public Criteria andTotalFeeEqualTo(Long value) { addCriterion("total_fee =", value, "totalFee"); return (Criteria) this; } public Criteria andTotalFeeNotEqualTo(Long value) { addCriterion("total_fee <>", value, "totalFee"); return (Criteria) this; } public Criteria andTotalFeeGreaterThan(Long value) { addCriterion("total_fee >", value, "totalFee"); return (Criteria) this; } public Criteria andTotalFeeGreaterThanOrEqualTo(Long value) { addCriterion("total_fee >=", value, "totalFee"); return (Criteria) this; } public Criteria andTotalFeeLessThan(Long value) { addCriterion("total_fee <", value, "totalFee"); return (Criteria) this; } public Criteria andTotalFeeLessThanOrEqualTo(Long value) { addCriterion("total_fee <=", value, "totalFee"); return (Criteria) this; } public Criteria andTotalFeeIn(List<Long> values) { addCriterion("total_fee in", values, "totalFee"); return (Criteria) this; } public Criteria andTotalFeeNotIn(List<Long> values) { addCriterion("total_fee not in", values, "totalFee"); return (Criteria) this; } public Criteria andTotalFeeBetween(Long value1, Long value2) { addCriterion("total_fee between", value1, value2, "totalFee"); return (Criteria) this; } public Criteria andTotalFeeNotBetween(Long value1, Long value2) { addCriterion("total_fee not between", value1, value2, "totalFee"); return (Criteria) this; } public Criteria andPicPathIsNull() { addCriterion("pic_path is null"); return (Criteria) this; } public Criteria andPicPathIsNotNull() { addCriterion("pic_path is not null"); return (Criteria) this; } public Criteria andPicPathEqualTo(String value) { addCriterion("pic_path =", value, "picPath"); return (Criteria) this; } public Criteria andPicPathNotEqualTo(String value) { addCriterion("pic_path <>", value, "picPath"); return (Criteria) this; } public Criteria andPicPathGreaterThan(String value) { addCriterion("pic_path >", value, "picPath"); return (Criteria) this; } public Criteria andPicPathGreaterThanOrEqualTo(String value) { addCriterion("pic_path >=", value, "picPath"); return (Criteria) this; } public Criteria andPicPathLessThan(String value) { addCriterion("pic_path <", value, "picPath"); return (Criteria) this; } public Criteria andPicPathLessThanOrEqualTo(String value) { addCriterion("pic_path <=", value, "picPath"); return (Criteria) this; } public Criteria andPicPathLike(String value) { addCriterion("pic_path like", value, "picPath"); return (Criteria) this; } public Criteria andPicPathNotLike(String value) { addCriterion("pic_path not like", value, "picPath"); return (Criteria) this; } public Criteria andPicPathIn(List<String> values) { addCriterion("pic_path in", values, "picPath"); return (Criteria) this; } public Criteria andPicPathNotIn(List<String> values) { addCriterion("pic_path not in", values, "picPath"); return (Criteria) this; } public Criteria andPicPathBetween(String value1, String value2) { addCriterion("pic_path between", value1, value2, "picPath"); return (Criteria) this; } public Criteria andPicPathNotBetween(String value1, String value2) { addCriterion("pic_path not between", value1, value2, "picPath"); return (Criteria) this; } } public static class Criteria extends GeneratedCriteria { protected Criteria() { super(); } } public static class Criterion { private String condition; private Object value; private Object secondValue; private boolean noValue; private boolean singleValue; private boolean betweenValue; private boolean listValue; private String typeHandler; public String getCondition() { return condition; } public Object getValue() { return value; } public Object getSecondValue() { return secondValue; } public boolean isNoValue() { return noValue; } public boolean isSingleValue() { return singleValue; } public boolean isBetweenValue() { return betweenValue; } public boolean isListValue() { return listValue; } public String getTypeHandler() { return typeHandler; } protected Criterion(String condition) { super(); this.condition = condition; this.typeHandler = null; this.noValue = true; } protected Criterion(String condition, Object value, String typeHandler) { super(); this.condition = condition; this.value = value; this.typeHandler = typeHandler; if (value instanceof List<?>) { this.listValue = true; } else { this.singleValue = true; } } protected Criterion(String condition, Object value) { this(condition, value, null); } protected Criterion(String condition, Object value, Object secondValue, String typeHandler) { super(); this.condition = condition; this.value = value; this.secondValue = secondValue; this.typeHandler = typeHandler; this.betweenValue = true; } protected Criterion(String condition, Object value, Object secondValue) { this(condition, value, secondValue, null); } } }
TbOrderShipping.java
package com.taotao.pojo; import java.util.Date; public class TbOrderShipping { private String orderId; private String receiverName; private String receiverPhone; private String receiverMobile; private String receiverState; private String receiverCity; private String receiverDistrict; private String receiverAddress; private String receiverZip; private Date created; private Date updated; public String getOrderId() { return orderId; } public void setOrderId(String orderId) { this.orderId = orderId == null ? null : orderId.trim(); } public String getReceiverName() { return receiverName; } public void setReceiverName(String receiverName) { this.receiverName = receiverName == null ? null : receiverName.trim(); } public String getReceiverPhone() { return receiverPhone; } public void setReceiverPhone(String receiverPhone) { this.receiverPhone = receiverPhone == null ? null : receiverPhone.trim(); } public String getReceiverMobile() { return receiverMobile; } public void setReceiverMobile(String receiverMobile) { this.receiverMobile = receiverMobile == null ? null : receiverMobile.trim(); } public String getReceiverState() { return receiverState; } public void setReceiverState(String receiverState) { this.receiverState = receiverState == null ? null : receiverState.trim(); } public String getReceiverCity() { return receiverCity; } public void setReceiverCity(String receiverCity) { this.receiverCity = receiverCity == null ? null : receiverCity.trim(); } public String getReceiverDistrict() { return receiverDistrict; } public void setReceiverDistrict(String receiverDistrict) { this.receiverDistrict = receiverDistrict == null ? null : receiverDistrict.trim(); } public String getReceiverAddress() { return receiverAddress; } public void setReceiverAddress(String receiverAddress) { this.receiverAddress = receiverAddress == null ? null : receiverAddress.trim(); } public String getReceiverZip() { return receiverZip; } public void setReceiverZip(String receiverZip) { this.receiverZip = receiverZip == null ? null : receiverZip.trim(); } public Date getCreated() { return created; } public void setCreated(Date created) { this.created = created; } public Date getUpdated() { return updated; } public void setUpdated(Date updated) { this.updated = updated; } }
TbOrderShippingExample.java
package com.taotao.pojo; import java.util.ArrayList; import java.util.Date; import java.util.List; public class TbOrderShippingExample { protected String orderByClause; protected boolean distinct; protected List<Criteria> oredCriteria; public TbOrderShippingExample() { oredCriteria = new ArrayList<Criteria>(); } public void setOrderByClause(String orderByClause) { this.orderByClause = orderByClause; } public String getOrderByClause() { return orderByClause; } public void setDistinct(boolean distinct) { this.distinct = distinct; } public boolean isDistinct() { return distinct; } public List<Criteria> getOredCriteria() { return oredCriteria; } public void or(Criteria criteria) { oredCriteria.add(criteria); } public Criteria or() { Criteria criteria = createCriteriaInternal(); oredCriteria.add(criteria); return criteria; } public Criteria createCriteria() { Criteria criteria = createCriteriaInternal(); if (oredCriteria.size() == 0) { oredCriteria.add(criteria); } return criteria; } protected Criteria createCriteriaInternal() { Criteria criteria = new Criteria(); return criteria; } public void clear() { oredCriteria.clear(); orderByClause = null; distinct = false; } protected abstract static class GeneratedCriteria { protected List<Criterion> criteria; protected GeneratedCriteria() { super(); criteria = new ArrayList<Criterion>(); } public boolean isValid() { return criteria.size() > 0; } public List<Criterion> getAllCriteria() { return criteria; } public List<Criterion> getCriteria() { return criteria; } protected void addCriterion(String condition) { if (condition == null) { throw new RuntimeException("Value for condition cannot be null"); } criteria.add(new Criterion(condition)); } protected void addCriterion(String condition, Object value, String property) { if (value == null) { throw new RuntimeException("Value for " + property + " cannot be null"); } criteria.add(new Criterion(condition, value)); } protected void addCriterion(String condition, Object value1, Object value2, String property) { if (value1 == null || value2 == null) { throw new RuntimeException("Between values for " + property + " cannot be null"); } criteria.add(new Criterion(condition, value1, value2)); } public Criteria andOrderIdIsNull() { addCriterion("order_id is null"); return (Criteria) this; } public Criteria andOrderIdIsNotNull() { addCriterion("order_id is not null"); return (Criteria) this; } public Criteria andOrderIdEqualTo(String value) { addCriterion("order_id =", value, "orderId"); return (Criteria) this; } public Criteria andOrderIdNotEqualTo(String value) { addCriterion("order_id <>", value, "orderId"); return (Criteria) this; } public Criteria andOrderIdGreaterThan(String value) { addCriterion("order_id >", value, "orderId"); return (Criteria) this; } public Criteria andOrderIdGreaterThanOrEqualTo(String value) { addCriterion("order_id >=", value, "orderId"); return (Criteria) this; } public Criteria andOrderIdLessThan(String value) { addCriterion("order_id <", value, "orderId"); return (Criteria) this; } public Criteria andOrderIdLessThanOrEqualTo(String value) { addCriterion("order_id <=", value, "orderId"); return (Criteria) this; } public Criteria andOrderIdLike(String value) { addCriterion("order_id like", value, "orderId"); return (Criteria) this; } public Criteria andOrderIdNotLike(String value) { addCriterion("order_id not like", value, "orderId"); return (Criteria) this; } public Criteria andOrderIdIn(List<String> values) { addCriterion("order_id in", values, "orderId"); return (Criteria) this; } public Criteria andOrderIdNotIn(List<String> values) { addCriterion("order_id not in", values, "orderId"); return (Criteria) this; } public Criteria andOrderIdBetween(String value1, String value2) { addCriterion("order_id between", value1, value2, "orderId"); return (Criteria) this; } public Criteria andOrderIdNotBetween(String value1, String value2) { addCriterion("order_id not between", value1, value2, "orderId"); return (Criteria) this; } public Criteria andReceiverNameIsNull() { addCriterion("receiver_name is null"); return (Criteria) this; } public Criteria andReceiverNameIsNotNull() { addCriterion("receiver_name is not null"); return (Criteria) this; } public Criteria andReceiverNameEqualTo(String value) { addCriterion("receiver_name =", value, "receiverName"); return (Criteria) this; } public Criteria andReceiverNameNotEqualTo(String value) { addCriterion("receiver_name <>", value, "receiverName"); return (Criteria) this; } public Criteria andReceiverNameGreaterThan(String value) { addCriterion("receiver_name >", value, "receiverName"); return (Criteria) this; } public Criteria andReceiverNameGreaterThanOrEqualTo(String value) { addCriterion("receiver_name >=", value, "receiverName"); return (Criteria) this; } public Criteria andReceiverNameLessThan(String value) { addCriterion("receiver_name <", value, "receiverName"); return (Criteria) this; } public Criteria andReceiverNameLessThanOrEqualTo(String value) { addCriterion("receiver_name <=", value, "receiverName"); return (Criteria) this; } public Criteria andReceiverNameLike(String value) { addCriterion("receiver_name like", value, "receiverName"); return (Criteria) this; } public Criteria andReceiverNameNotLike(String value) { addCriterion("receiver_name not like", value, "receiverName"); return (Criteria) this; } public Criteria andReceiverNameIn(List<String> values) { addCriterion("receiver_name in", values, "receiverName"); return (Criteria) this; } public Criteria andReceiverNameNotIn(List<String> values) { addCriterion("receiver_name not in", values, "receiverName"); return (Criteria) this; } public Criteria andReceiverNameBetween(String value1, String value2) { addCriterion("receiver_name between", value1, value2, "receiverName"); return (Criteria) this; } public Criteria andReceiverNameNotBetween(String value1, String value2) { addCriterion("receiver_name not between", value1, value2, "receiverName"); return (Criteria) this; } public Criteria andReceiverPhoneIsNull() { addCriterion("receiver_phone is null"); return (Criteria) this; } public Criteria andReceiverPhoneIsNotNull() { addCriterion("receiver_phone is not null"); return (Criteria) this; } public Criteria andReceiverPhoneEqualTo(String value) { addCriterion("receiver_phone =", value, "receiverPhone"); return (Criteria) this; } public Criteria andReceiverPhoneNotEqualTo(String value) { addCriterion("receiver_phone <>", value, "receiverPhone"); return (Criteria) this; } public Criteria andReceiverPhoneGreaterThan(String value) { addCriterion("receiver_phone >", value, "receiverPhone"); return (Criteria) this; } public Criteria andReceiverPhoneGreaterThanOrEqualTo(String value) { addCriterion("receiver_phone >=", value, "receiverPhone"); return (Criteria) this; } public Criteria andReceiverPhoneLessThan(String value) { addCriterion("receiver_phone <", value, "receiverPhone"); return (Criteria) this; } public Criteria andReceiverPhoneLessThanOrEqualTo(String value) { addCriterion("receiver_phone <=", value, "receiverPhone"); return (Criteria) this; } public Criteria andReceiverPhoneLike(String value) { addCriterion("receiver_phone like", value, "receiverPhone"); return (Criteria) this; } public Criteria andReceiverPhoneNotLike(String value) { addCriterion("receiver_phone not like", value, "receiverPhone"); return (Criteria) this; } public Criteria andReceiverPhoneIn(List<String> values) { addCriterion("receiver_phone in", values, "receiverPhone"); return (Criteria) this; } public Criteria andReceiverPhoneNotIn(List<String> values) { addCriterion("receiver_phone not in", values, "receiverPhone"); return (Criteria) this; } public Criteria andReceiverPhoneBetween(String value1, String value2) { addCriterion("receiver_phone between", value1, value2, "receiverPhone"); return (Criteria) this; } public Criteria andReceiverPhoneNotBetween(String value1, String value2) { addCriterion("receiver_phone not between", value1, value2, "receiverPhone"); return (Criteria) this; } public Criteria andReceiverMobileIsNull() { addCriterion("receiver_mobile is null"); return (Criteria) this; } public Criteria andReceiverMobileIsNotNull() { addCriterion("receiver_mobile is not null"); return (Criteria) this; } public Criteria andReceiverMobileEqualTo(String value) { addCriterion("receiver_mobile =", value, "receiverMobile"); return (Criteria) this; } public Criteria andReceiverMobileNotEqualTo(String value) { addCriterion("receiver_mobile <>", value, "receiverMobile"); return (Criteria) this; } public Criteria andReceiverMobileGreaterThan(String value) { addCriterion("receiver_mobile >", value, "receiverMobile"); return (Criteria) this; } public Criteria andReceiverMobileGreaterThanOrEqualTo(String value) { addCriterion("receiver_mobile >=", value, "receiverMobile"); return (Criteria) this; } public Criteria andReceiverMobileLessThan(String value) { addCriterion("receiver_mobile <", value, "receiverMobile"); return (Criteria) this; } public Criteria andReceiverMobileLessThanOrEqualTo(String value) { addCriterion("receiver_mobile <=", value, "receiverMobile"); return (Criteria) this; } public Criteria andReceiverMobileLike(String value) { addCriterion("receiver_mobile like", value, "receiverMobile"); return (Criteria) this; } public Criteria andReceiverMobileNotLike(String value) { addCriterion("receiver_mobile not like", value, "receiverMobile"); return (Criteria) this; } public Criteria andReceiverMobileIn(List<String> values) { addCriterion("receiver_mobile in", values, "receiverMobile"); return (Criteria) this; } public Criteria andReceiverMobileNotIn(List<String> values) { addCriterion("receiver_mobile not in", values, "receiverMobile"); return (Criteria) this; } public Criteria andReceiverMobileBetween(String value1, String value2) { addCriterion("receiver_mobile between", value1, value2, "receiverMobile"); return (Criteria) this; } public Criteria andReceiverMobileNotBetween(String value1, String value2) { addCriterion("receiver_mobile not between", value1, value2, "receiverMobile"); return (Criteria) this; } public Criteria andReceiverStateIsNull() { addCriterion("receiver_state is null"); return (Criteria) this; } public Criteria andReceiverStateIsNotNull() { addCriterion("receiver_state is not null"); return (Criteria) this; } public Criteria andReceiverStateEqualTo(String value) { addCriterion("receiver_state =", value, "receiverState"); return (Criteria) this; } public Criteria andReceiverStateNotEqualTo(String value) { addCriterion("receiver_state <>", value, "receiverState"); return (Criteria) this; } public Criteria andReceiverStateGreaterThan(String value) { addCriterion("receiver_state >", value, "receiverState"); return (Criteria) this; } public Criteria andReceiverStateGreaterThanOrEqualTo(String value) { addCriterion("receiver_state >=", value, "receiverState"); return (Criteria) this; } public Criteria andReceiverStateLessThan(String value) { addCriterion("receiver_state <", value, "receiverState"); return (Criteria) this; } public Criteria andReceiverStateLessThanOrEqualTo(String value) { addCriterion("receiver_state <=", value, "receiverState"); return (Criteria) this; } public Criteria andReceiverStateLike(String value) { addCriterion("receiver_state like", value, "receiverState"); return (Criteria) this; } public Criteria andReceiverStateNotLike(String value) { addCriterion("receiver_state not like", value, "receiverState"); return (Criteria) this; } public Criteria andReceiverStateIn(List<String> values) { addCriterion("receiver_state in", values, "receiverState"); return (Criteria) this; } public Criteria andReceiverStateNotIn(List<String> values) { addCriterion("receiver_state not in", values, "receiverState"); return (Criteria) this; } public Criteria andReceiverStateBetween(String value1, String value2) { addCriterion("receiver_state between", value1, value2, "receiverState"); return (Criteria) this; } public Criteria andReceiverStateNotBetween(String value1, String value2) { addCriterion("receiver_state not between", value1, value2, "receiverState"); return (Criteria) this; } public Criteria andReceiverCityIsNull() { addCriterion("receiver_city is null"); return (Criteria) this; } public Criteria andReceiverCityIsNotNull() { addCriterion("receiver_city is not null"); return (Criteria) this; } public Criteria andReceiverCityEqualTo(String value) { addCriterion("receiver_city =", value, "receiverCity"); return (Criteria) this; } public Criteria andReceiverCityNotEqualTo(String value) { addCriterion("receiver_city <>", value, "receiverCity"); return (Criteria) this; } public Criteria andReceiverCityGreaterThan(String value) { addCriterion("receiver_city >", value, "receiverCity"); return (Criteria) this; } public Criteria andReceiverCityGreaterThanOrEqualTo(String value) { addCriterion("receiver_city >=", value, "receiverCity"); return (Criteria) this; } public Criteria andReceiverCityLessThan(String value) { addCriterion("receiver_city <", value, "receiverCity"); return (Criteria) this; } public Criteria andReceiverCityLessThanOrEqualTo(String value) { addCriterion("receiver_city <=", value, "receiverCity"); return (Criteria) this; } public Criteria andReceiverCityLike(String value) { addCriterion("receiver_city like", value, "receiverCity"); return (Criteria) this; } public Criteria andReceiverCityNotLike(String value) { addCriterion("receiver_city not like", value, "receiverCity"); return (Criteria) this; } public Criteria andReceiverCityIn(List<String> values) { addCriterion("receiver_city in", values, "receiverCity"); return (Criteria) this; } public Criteria andReceiverCityNotIn(List<String> values) { addCriterion("receiver_city not in", values, "receiverCity"); return (Criteria) this; } public Criteria andReceiverCityBetween(String value1, String value2) { addCriterion("receiver_city between", value1, value2, "receiverCity"); return (Criteria) this; } public Criteria andReceiverCityNotBetween(String value1, String value2) { addCriterion("receiver_city not between", value1, value2, "receiverCity"); return (Criteria) this; } public Criteria andReceiverDistrictIsNull() { addCriterion("receiver_district is null"); return (Criteria) this; } public Criteria andReceiverDistrictIsNotNull() { addCriterion("receiver_district is not null"); return (Criteria) this; } public Criteria andReceiverDistrictEqualTo(String value) { addCriterion("receiver_district =", value, "receiverDistrict"); return (Criteria) this; } public Criteria andReceiverDistrictNotEqualTo(String value) { addCriterion("receiver_district <>", value, "receiverDistrict"); return (Criteria) this; } public Criteria andReceiverDistrictGreaterThan(String value) { addCriterion("receiver_district >", value, "receiverDistrict"); return (Criteria) this; } public Criteria andReceiverDistrictGreaterThanOrEqualTo(String value) { addCriterion("receiver_district >=", value, "receiverDistrict"); return (Criteria) this; } public Criteria andReceiverDistrictLessThan(String value) { addCriterion("receiver_district <", value, "receiverDistrict"); return (Criteria) this; } public Criteria andReceiverDistrictLessThanOrEqualTo(String value) { addCriterion("receiver_district <=", value, "receiverDistrict"); return (Criteria) this; } public Criteria andReceiverDistrictLike(String value) { addCriterion("receiver_district like", value, "receiverDistrict"); return (Criteria) this; } public Criteria andReceiverDistrictNotLike(String value) { addCriterion("receiver_district not like", value, "receiverDistrict"); return (Criteria) this; } public Criteria andReceiverDistrictIn(List<String> values) { addCriterion("receiver_district in", values, "receiverDistrict"); return (Criteria) this; } public Criteria andReceiverDistrictNotIn(List<String> values) { addCriterion("receiver_district not in", values, "receiverDistrict"); return (Criteria) this; } public Criteria andReceiverDistrictBetween(String value1, String value2) { addCriterion("receiver_district between", value1, value2, "receiverDistrict"); return (Criteria) this; } public Criteria andReceiverDistrictNotBetween(String value1, String value2) { addCriterion("receiver_district not between", value1, value2, "receiverDistrict"); return (Criteria) this; } public Criteria andReceiverAddressIsNull() { addCriterion("receiver_address is null"); return (Criteria) this; } public Criteria andReceiverAddressIsNotNull() { addCriterion("receiver_address is not null"); return (Criteria) this; } public Criteria andReceiverAddressEqualTo(String value) { addCriterion("receiver_address =", value, "receiverAddress"); return (Criteria) this; } public Criteria andReceiverAddressNotEqualTo(String value) { addCriterion("receiver_address <>", value, "receiverAddress"); return (Criteria) this; } public Criteria andReceiverAddressGreaterThan(String value) { addCriterion("receiver_address >", value, "receiverAddress"); return (Criteria) this; } public Criteria andReceiverAddressGreaterThanOrEqualTo(String value) { addCriterion("receiver_address >=", value, "receiverAddress"); return (Criteria) this; } public Criteria andReceiverAddressLessThan(String value) { addCriterion("receiver_address <", value, "receiverAddress"); return (Criteria) this; } public Criteria andReceiverAddressLessThanOrEqualTo(String value) { addCriterion("receiver_address <=", value, "receiverAddress"); return (Criteria) this; } public Criteria andReceiverAddressLike(String value) { addCriterion("receiver_address like", value, "receiverAddress"); return (Criteria) this; } public Criteria andReceiverAddressNotLike(String value) { addCriterion("receiver_address not like", value, "receiverAddress"); return (Criteria) this; } public Criteria andReceiverAddressIn(List<String> values) { addCriterion("receiver_address in", values, "receiverAddress"); return (Criteria) this; } public Criteria andReceiverAddressNotIn(List<String> values) { addCriterion("receiver_address not in", values, "receiverAddress"); return (Criteria) this; } public Criteria andReceiverAddressBetween(String value1, String value2) { addCriterion("receiver_address between", value1, value2, "receiverAddress"); return (Criteria) this; } public Criteria andReceiverAddressNotBetween(String value1, String value2) { addCriterion("receiver_address not between", value1, value2, "receiverAddress"); return (Criteria) this; } public Criteria andReceiverZipIsNull() { addCriterion("receiver_zip is null"); return (Criteria) this; } public Criteria andReceiverZipIsNotNull() { addCriterion("receiver_zip is not null"); return (Criteria) this; } public Criteria andReceiverZipEqualTo(String value) { addCriterion("receiver_zip =", value, "receiverZip"); return (Criteria) this; } public Criteria andReceiverZipNotEqualTo(String value) { addCriterion("receiver_zip <>", value, "receiverZip"); return (Criteria) this; } public Criteria andReceiverZipGreaterThan(String value) { addCriterion("receiver_zip >", value, "receiverZip"); return (Criteria) this; } public Criteria andReceiverZipGreaterThanOrEqualTo(String value) { addCriterion("receiver_zip >=", value, "receiverZip"); return (Criteria) this; } public Criteria andReceiverZipLessThan(String value) { addCriterion("receiver_zip <", value, "receiverZip"); return (Criteria) this; } public Criteria andReceiverZipLessThanOrEqualTo(String value) { addCriterion("receiver_zip <=", value, "receiverZip"); return (Criteria) this; } public Criteria andReceiverZipLike(String value) { addCriterion("receiver_zip like", value, "receiverZip"); return (Criteria) this; } public Criteria andReceiverZipNotLike(String value) { addCriterion("receiver_zip not like", value, "receiverZip"); return (Criteria) this; } public Criteria andReceiverZipIn(List<String> values) { addCriterion("receiver_zip in", values, "receiverZip"); return (Criteria) this; } public Criteria andReceiverZipNotIn(List<String> values) { addCriterion("receiver_zip not in", values, "receiverZip"); return (Criteria) this; } public Criteria andReceiverZipBetween(String value1, String value2) { addCriterion("receiver_zip between", value1, value2, "receiverZip"); return (Criteria) this; } public Criteria andReceiverZipNotBetween(String value1, String value2) { addCriterion("receiver_zip not between", value1, value2, "receiverZip"); return (Criteria) this; } public Criteria andCreatedIsNull() { addCriterion("created is null"); return (Criteria) this; } public Criteria andCreatedIsNotNull() { addCriterion("created is not null"); return (Criteria) this; } public Criteria andCreatedEqualTo(Date value) { addCriterion("created =", value, "created"); return (Criteria) this; } public Criteria andCreatedNotEqualTo(Date value) { addCriterion("created <>", value, "created"); return (Criteria) this; } public Criteria andCreatedGreaterThan(Date value) { addCriterion("created >", value, "created"); return (Criteria) this; } public Criteria andCreatedGreaterThanOrEqualTo(Date value) { addCriterion("created >=", value, "created"); return (Criteria) this; } public Criteria andCreatedLessThan(Date value) { addCriterion("created <", value, "created"); return (Criteria) this; } public Criteria andCreatedLessThanOrEqualTo(Date value) { addCriterion("created <=", value, "created"); return (Criteria) this; } public Criteria andCreatedIn(List<Date> values) { addCriterion("created in", values, "created"); return (Criteria) this; } public Criteria andCreatedNotIn(List<Date> values) { addCriterion("created not in", values, "created"); return (Criteria) this; } public Criteria andCreatedBetween(Date value1, Date value2) { addCriterion("created between", value1, value2, "created"); return (Criteria) this; } public Criteria andCreatedNotBetween(Date value1, Date value2) { addCriterion("created not between", value1, value2, "created"); return (Criteria) this; } public Criteria andUpdatedIsNull() { addCriterion("updated is null"); return (Criteria) this; } public Criteria andUpdatedIsNotNull() { addCriterion("updated is not null"); return (Criteria) this; } public Criteria andUpdatedEqualTo(Date value) { addCriterion("updated =", value, "updated"); return (Criteria) this; } public Criteria andUpdatedNotEqualTo(Date value) { addCriterion("updated <>", value, "updated"); return (Criteria) this; } public Criteria andUpdatedGreaterThan(Date value) { addCriterion("updated >", value, "updated"); return (Criteria) this; } public Criteria andUpdatedGreaterThanOrEqualTo(Date value) { addCriterion("updated >=", value, "updated"); return (Criteria) this; } public Criteria andUpdatedLessThan(Date value) { addCriterion("updated <", value, "updated"); return (Criteria) this; } public Criteria andUpdatedLessThanOrEqualTo(Date value) { addCriterion("updated <=", value, "updated"); return (Criteria) this; } public Criteria andUpdatedIn(List<Date> values) { addCriterion("updated in", values, "updated"); return (Criteria) this; } public Criteria andUpdatedNotIn(List<Date> values) { addCriterion("updated not in", values, "updated"); return (Criteria) this; } public Criteria andUpdatedBetween(Date value1, Date value2) { addCriterion("updated between", value1, value2, "updated"); return (Criteria) this; } public Criteria andUpdatedNotBetween(Date value1, Date value2) { addCriterion("updated not between", value1, value2, "updated"); return (Criteria) this; } } public static class Criteria extends GeneratedCriteria { protected Criteria() { super(); } } public static class Criterion { private String condition; private Object value; private Object secondValue; private boolean noValue; private boolean singleValue; private boolean betweenValue; private boolean listValue; private String typeHandler; public String getCondition() { return condition; } public Object getValue() { return value; } public Object getSecondValue() { return secondValue; } public boolean isNoValue() { return noValue; } public boolean isSingleValue() { return singleValue; } public boolean isBetweenValue() { return betweenValue; } public boolean isListValue() { return listValue; } public String getTypeHandler() { return typeHandler; } protected Criterion(String condition) { super(); this.condition = condition; this.typeHandler = null; this.noValue = true; } protected Criterion(String condition, Object value, String typeHandler) { super(); this.condition = condition; this.value = value; this.typeHandler = typeHandler; if (value instanceof List<?>) { this.listValue = true; } else { this.singleValue = true; } } protected Criterion(String condition, Object value) { this(condition, value, null); } protected Criterion(String condition, Object value, Object secondValue, String typeHandler) { super(); this.condition = condition; this.value = value; this.secondValue = secondValue; this.typeHandler = typeHandler; this.betweenValue = true; } protected Criterion(String condition, Object value, Object secondValue) { this(condition, value, secondValue, null); } } }
TbUser.java
package com.taotao.pojo; import java.util.Date; public class TbUser { private Long id; private String username; private String password; private String phone; private String email; private Date created; private Date updated; public Long getId() { return id; } public void setId(Long id) { this.id = id; } public String getUsername() { return username; } public void setUsername(String username) { this.username = username == null ? null : username.trim(); } public String getPassword() { return password; } public void setPassword(String password) { this.password = password == null ? null : password.trim(); } public String getPhone() { return phone; } public void setPhone(String phone) { this.phone = phone == null ? null : phone.trim(); } public String getEmail() { return email; } public void setEmail(String email) { this.email = email == null ? null : email.trim(); } public Date getCreated() { return created; } public void setCreated(Date created) { this.created = created; } public Date getUpdated() { return updated; } public void setUpdated(Date updated) { this.updated = updated; } }
TbUserExample.java
package com.taotao.pojo; import java.util.ArrayList; import java.util.Date; import java.util.List; public class TbUserExample { protected String orderByClause; protected boolean distinct; protected List<Criteria> oredCriteria; public TbUserExample() { oredCriteria = new ArrayList<Criteria>(); } public void setOrderByClause(String orderByClause) { this.orderByClause = orderByClause; } public String getOrderByClause() { return orderByClause; } public void setDistinct(boolean distinct) { this.distinct = distinct; } public boolean isDistinct() { return distinct; } public List<Criteria> getOredCriteria() { return oredCriteria; } public void or(Criteria criteria) { oredCriteria.add(criteria); } public Criteria or() { Criteria criteria = createCriteriaInternal(); oredCriteria.add(criteria); return criteria; } public Criteria createCriteria() { Criteria criteria = createCriteriaInternal(); if (oredCriteria.size() == 0) { oredCriteria.add(criteria); } return criteria; } protected Criteria createCriteriaInternal() { Criteria criteria = new Criteria(); return criteria; } public void clear() { oredCriteria.clear(); orderByClause = null; distinct = false; } protected abstract static class GeneratedCriteria { protected List<Criterion> criteria; protected GeneratedCriteria() { super(); criteria = new ArrayList<Criterion>(); } public boolean isValid() { return criteria.size() > 0; } public List<Criterion> getAllCriteria() { return criteria; } public List<Criterion> getCriteria() { return criteria; } protected void addCriterion(String condition) { if (condition == null) { throw new RuntimeException("Value for condition cannot be null"); } criteria.add(new Criterion(condition)); } protected void addCriterion(String condition, Object value, String property) { if (value == null) { throw new RuntimeException("Value for " + property + " cannot be null"); } criteria.add(new Criterion(condition, value)); } protected void addCriterion(String condition, Object value1, Object value2, String property) { if (value1 == null || value2 == null) { throw new RuntimeException("Between values for " + property + " cannot be null"); } criteria.add(new Criterion(condition, value1, value2)); } public Criteria andIdIsNull() { addCriterion("id is null"); return (Criteria) this; } public Criteria andIdIsNotNull() { addCriterion("id is not null"); return (Criteria) this; } public Criteria andIdEqualTo(Long value) { addCriterion("id =", value, "id"); return (Criteria) this; } public Criteria andIdNotEqualTo(Long value) { addCriterion("id <>", value, "id"); return (Criteria) this; } public Criteria andIdGreaterThan(Long value) { addCriterion("id >", value, "id"); return (Criteria) this; } public Criteria andIdGreaterThanOrEqualTo(Long value) { addCriterion("id >=", value, "id"); return (Criteria) this; } public Criteria andIdLessThan(Long value) { addCriterion("id <", value, "id"); return (Criteria) this; } public Criteria andIdLessThanOrEqualTo(Long value) { addCriterion("id <=", value, "id"); return (Criteria) this; } public Criteria andIdIn(List<Long> values) { addCriterion("id in", values, "id"); return (Criteria) this; } public Criteria andIdNotIn(List<Long> values) { addCriterion("id not in", values, "id"); return (Criteria) this; } public Criteria andIdBetween(Long value1, Long value2) { addCriterion("id between", value1, value2, "id"); return (Criteria) this; } public Criteria andIdNotBetween(Long value1, Long value2) { addCriterion("id not between", value1, value2, "id"); return (Criteria) this; } public Criteria andUsernameIsNull() { addCriterion("username is null"); return (Criteria) this; } public Criteria andUsernameIsNotNull() { addCriterion("username is not null"); return (Criteria) this; } public Criteria andUsernameEqualTo(String value) { addCriterion("username =", value, "username"); return (Criteria) this; } public Criteria andUsernameNotEqualTo(String value) { addCriterion("username <>", value, "username"); return (Criteria) this; } public Criteria andUsernameGreaterThan(String value) { addCriterion("username >", value, "username"); return (Criteria) this; } public Criteria andUsernameGreaterThanOrEqualTo(String value) { addCriterion("username >=", value, "username"); return (Criteria) this; } public Criteria andUsernameLessThan(String value) { addCriterion("username <", value, "username"); return (Criteria) this; } public Criteria andUsernameLessThanOrEqualTo(String value) { addCriterion("username <=", value, "username"); return (Criteria) this; } public Criteria andUsernameLike(String value) { addCriterion("username like", value, "username"); return (Criteria) this; } public Criteria andUsernameNotLike(String value) { addCriterion("username not like", value, "username"); return (Criteria) this; } public Criteria andUsernameIn(List<String> values) { addCriterion("username in", values, "username"); return (Criteria) this; } public Criteria andUsernameNotIn(List<String> values) { addCriterion("username not in", values, "username"); return (Criteria) this; } public Criteria andUsernameBetween(String value1, String value2) { addCriterion("username between", value1, value2, "username"); return (Criteria) this; } public Criteria andUsernameNotBetween(String value1, String value2) { addCriterion("username not between", value1, value2, "username"); return (Criteria) this; } public Criteria andPasswordIsNull() { addCriterion("password is null"); return (Criteria) this; } public Criteria andPasswordIsNotNull() { addCriterion("password is not null"); return (Criteria) this; } public Criteria andPasswordEqualTo(String value) { addCriterion("password =", value, "password"); return (Criteria) this; } public Criteria andPasswordNotEqualTo(String value) { addCriterion("password <>", value, "password"); return (Criteria) this; } public Criteria andPasswordGreaterThan(String value) { addCriterion("password >", value, "password"); return (Criteria) this; } public Criteria andPasswordGreaterThanOrEqualTo(String value) { addCriterion("password >=", value, "password"); return (Criteria) this; } public Criteria andPasswordLessThan(String value) { addCriterion("password <", value, "password"); return (Criteria) this; } public Criteria andPasswordLessThanOrEqualTo(String value) { addCriterion("password <=", value, "password"); return (Criteria) this; } public Criteria andPasswordLike(String value) { addCriterion("password like", value, "password"); return (Criteria) this; } public Criteria andPasswordNotLike(String value) { addCriterion("password not like", value, "password"); return (Criteria) this; } public Criteria andPasswordIn(List<String> values) { addCriterion("password in", values, "password"); return (Criteria) this; } public Criteria andPasswordNotIn(List<String> values) { addCriterion("password not in", values, "password"); return (Criteria) this; } public Criteria andPasswordBetween(String value1, String value2) { addCriterion("password between", value1, value2, "password"); return (Criteria) this; } public Criteria andPasswordNotBetween(String value1, String value2) { addCriterion("password not between", value1, value2, "password"); return (Criteria) this; } public Criteria andPhoneIsNull() { addCriterion("phone is null"); return (Criteria) this; } public Criteria andPhoneIsNotNull() { addCriterion("phone is not null"); return (Criteria) this; } public Criteria andPhoneEqualTo(String value) { addCriterion("phone =", value, "phone"); return (Criteria) this; } public Criteria andPhoneNotEqualTo(String value) { addCriterion("phone <>", value, "phone"); return (Criteria) this; } public Criteria andPhoneGreaterThan(String value) { addCriterion("phone >", value, "phone"); return (Criteria) this; } public Criteria andPhoneGreaterThanOrEqualTo(String value) { addCriterion("phone >=", value, "phone"); return (Criteria) this; } public Criteria andPhoneLessThan(String value) { addCriterion("phone <", value, "phone"); return (Criteria) this; } public Criteria andPhoneLessThanOrEqualTo(String value) { addCriterion("phone <=", value, "phone"); return (Criteria) this; } public Criteria andPhoneLike(String value) { addCriterion("phone like", value, "phone"); return (Criteria) this; } public Criteria andPhoneNotLike(String value) { addCriterion("phone not like", value, "phone"); return (Criteria) this; } public Criteria andPhoneIn(List<String> values) { addCriterion("phone in", values, "phone"); return (Criteria) this; } public Criteria andPhoneNotIn(List<String> values) { addCriterion("phone not in", values, "phone"); return (Criteria) this; } public Criteria andPhoneBetween(String value1, String value2) { addCriterion("phone between", value1, value2, "phone"); return (Criteria) this; } public Criteria andPhoneNotBetween(String value1, String value2) { addCriterion("phone not between", value1, value2, "phone"); return (Criteria) this; } public Criteria andEmailIsNull() { addCriterion("email is null"); return (Criteria) this; } public Criteria andEmailIsNotNull() { addCriterion("email is not null"); return (Criteria) this; } public Criteria andEmailEqualTo(String value) { addCriterion("email =", value, "email"); return (Criteria) this; } public Criteria andEmailNotEqualTo(String value) { addCriterion("email <>", value, "email"); return (Criteria) this; } public Criteria andEmailGreaterThan(String value) { addCriterion("email >", value, "email"); return (Criteria) this; } public Criteria andEmailGreaterThanOrEqualTo(String value) { addCriterion("email >=", value, "email"); return (Criteria) this; } public Criteria andEmailLessThan(String value) { addCriterion("email <", value, "email"); return (Criteria) this; } public Criteria andEmailLessThanOrEqualTo(String value) { addCriterion("email <=", value, "email"); return (Criteria) this; } public Criteria andEmailLike(String value) { addCriterion("email like", value, "email"); return (Criteria) this; } public Criteria andEmailNotLike(String value) { addCriterion("email not like", value, "email"); return (Criteria) this; } public Criteria andEmailIn(List<String> values) { addCriterion("email in", values, "email"); return (Criteria) this; } public Criteria andEmailNotIn(List<String> values) { addCriterion("email not in", values, "email"); return (Criteria) this; } public Criteria andEmailBetween(String value1, String value2) { addCriterion("email between", value1, value2, "email"); return (Criteria) this; } public Criteria andEmailNotBetween(String value1, String value2) { addCriterion("email not between", value1, value2, "email"); return (Criteria) this; } public Criteria andCreatedIsNull() { addCriterion("created is null"); return (Criteria) this; } public Criteria andCreatedIsNotNull() { addCriterion("created is not null"); return (Criteria) this; } public Criteria andCreatedEqualTo(Date value) { addCriterion("created =", value, "created"); return (Criteria) this; } public Criteria andCreatedNotEqualTo(Date value) { addCriterion("created <>", value, "created"); return (Criteria) this; } public Criteria andCreatedGreaterThan(Date value) { addCriterion("created >", value, "created"); return (Criteria) this; } public Criteria andCreatedGreaterThanOrEqualTo(Date value) { addCriterion("created >=", value, "created"); return (Criteria) this; } public Criteria andCreatedLessThan(Date value) { addCriterion("created <", value, "created"); return (Criteria) this; } public Criteria andCreatedLessThanOrEqualTo(Date value) { addCriterion("created <=", value, "created"); return (Criteria) this; } public Criteria andCreatedIn(List<Date> values) { addCriterion("created in", values, "created"); return (Criteria) this; } public Criteria andCreatedNotIn(List<Date> values) { addCriterion("created not in", values, "created"); return (Criteria) this; } public Criteria andCreatedBetween(Date value1, Date value2) { addCriterion("created between", value1, value2, "created"); return (Criteria) this; } public Criteria andCreatedNotBetween(Date value1, Date value2) { addCriterion("created not between", value1, value2, "created"); return (Criteria) this; } public Criteria andUpdatedIsNull() { addCriterion("updated is null"); return (Criteria) this; } public Criteria andUpdatedIsNotNull() { addCriterion("updated is not null"); return (Criteria) this; } public Criteria andUpdatedEqualTo(Date value) { addCriterion("updated =", value, "updated"); return (Criteria) this; } public Criteria andUpdatedNotEqualTo(Date value) { addCriterion("updated <>", value, "updated"); return (Criteria) this; } public Criteria andUpdatedGreaterThan(Date value) { addCriterion("updated >", value, "updated"); return (Criteria) this; } public Criteria andUpdatedGreaterThanOrEqualTo(Date value) { addCriterion("updated >=", value, "updated"); return (Criteria) this; } public Criteria andUpdatedLessThan(Date value) { addCriterion("updated <", value, "updated"); return (Criteria) this; } public Criteria andUpdatedLessThanOrEqualTo(Date value) { addCriterion("updated <=", value, "updated"); return (Criteria) this; } public Criteria andUpdatedIn(List<Date> values) { addCriterion("updated in", values, "updated"); return (Criteria) this; } public Criteria andUpdatedNotIn(List<Date> values) { addCriterion("updated not in", values, "updated"); return (Criteria) this; } public Criteria andUpdatedBetween(Date value1, Date value2) { addCriterion("updated between", value1, value2, "updated"); return (Criteria) this; } public Criteria andUpdatedNotBetween(Date value1, Date value2) { addCriterion("updated not between", value1, value2, "updated"); return (Criteria) this; } } public static class Criteria extends GeneratedCriteria { protected Criteria() { super(); } } public static class Criterion { private String condition; private Object value; private Object secondValue; private boolean noValue; private boolean singleValue; private boolean betweenValue; private boolean listValue; private String typeHandler; public String getCondition() { return condition; } public Object getValue() { return value; } public Object getSecondValue() { return secondValue; } public boolean isNoValue() { return noValue; } public boolean isSingleValue() { return singleValue; } public boolean isBetweenValue() { return betweenValue; } public boolean isListValue() { return listValue; } public String getTypeHandler() { return typeHandler; } protected Criterion(String condition) { super(); this.condition = condition; this.typeHandler = null; this.noValue = true; } protected Criterion(String condition, Object value, String typeHandler) { super(); this.condition = condition; this.value = value; this.typeHandler = typeHandler; if (value instanceof List<?>) { this.listValue = true; } else { this.singleValue = true; } } protected Criterion(String condition, Object value) { this(condition, value, null); } protected Criterion(String condition, Object value, Object secondValue, String typeHandler) { super(); this.condition = condition; this.value = value; this.secondValue = secondValue; this.typeHandler = typeHandler; this.betweenValue = true; } protected Criterion(String condition, Object value, Object secondValue) { this(condition, value, secondValue, null); } } }