springboot项目demo

<?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.youbus.springbootdemo.dao.UserMapper" > <resultMap id="BaseResultMap" type="com.youbus.springbootdemo.pojo.User" > <constructor > <idArg column="ID" jdbcType="INTEGER" javaType="java.lang.Integer" /> <arg column="USER_NAME" jdbcType="VARCHAR" javaType="java.lang.String" /> <arg column="PASSWORD" jdbcType="VARCHAR" javaType="java.lang.String" /> <arg column="EMAIL" jdbcType="VARCHAR" javaType="java.lang.String" /> <arg column="PHONE" jdbcType="VARCHAR" javaType="java.lang.String" /> <arg column="QUESTION" jdbcType="VARCHAR" javaType="java.lang.String" /> <arg column="ANSWER" jdbcType="VARCHAR" javaType="java.lang.String" /> <arg column="ROLE" jdbcType="INTEGER" javaType="java.lang.Integer" /> <arg column="IS_DELETE" jdbcType="BIT" javaType="java.lang.Boolean" /> <arg column="CREATE_TIME" jdbcType="TIMESTAMP" javaType="java.util.Date" /> <arg column="CREATE_BY" jdbcType="INTEGER" javaType="java.lang.Integer" /> <arg column="UPDATE_TIME" jdbcType="TIMESTAMP" javaType="java.util.Date" /> <arg column="UPDATE_BY" jdbcType="INTEGER" javaType="java.lang.Integer" /> </constructor> </resultMap> <sql id="Base_Column_List" > ID, USER_NAME, PASSWORD, EMAIL, PHONE, QUESTION, ANSWER, ROLE, IS_DELETE, CREATE_TIME, CREATE_BY, UPDATE_TIME, UPDATE_BY </sql> <select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.Integer" > select <include refid="Base_Column_List" /> from hw_user where ID = #{id,jdbcType=INTEGER} </select> <delete id="deleteByPrimaryKey" parameterType="java.lang.Integer" > delete from hw_user where ID = #{id,jdbcType=INTEGER} </delete> <insert id="insert" parameterType="com.youbus.springbootdemo.pojo.User" > insert into hw_user (ID, USER_NAME, PASSWORD, EMAIL, PHONE, QUESTION, ANSWER, ROLE, IS_DELETE, CREATE_TIME, CREATE_BY, UPDATE_TIME, UPDATE_BY) values (#{id,jdbcType=INTEGER}, #{userName,jdbcType=VARCHAR}, #{password,jdbcType=VARCHAR}, #{email,jdbcType=VARCHAR}, #{phone,jdbcType=VARCHAR}, #{question,jdbcType=VARCHAR}, #{answer,jdbcType=VARCHAR}, #{role,jdbcType=INTEGER}, #{isDelete,jdbcType=BIT}, #{createTime,jdbcType=TIMESTAMP}, #{createBy,jdbcType=INTEGER}, #{updateTime,jdbcType=TIMESTAMP}, #{updateBy,jdbcType=INTEGER}) </insert> <insert id="insertSelective" parameterType="com.youbus.springbootdemo.pojo.User" > insert into hw_user <trim prefix="(" suffix=")" suffixOverrides="," > <if test="id != null" > ID, </if> <if test="userName != null" > USER_NAME, </if> <if test="password != null" > PASSWORD, </if> <if test="email != null" > EMAIL, </if> <if test="phone != null" > PHONE, </if> <if test="question != null" > QUESTION, </if> <if test="answer != null" > ANSWER, </if> <if test="role != null" > ROLE, </if> <if test="isDelete != null" > IS_DELETE, </if> <if test="createTime != null" > CREATE_TIME, </if> <if test="createBy != null" > CREATE_BY, </if> <if test="updateTime != null" > UPDATE_TIME, </if> <if test="updateBy != null" > UPDATE_BY, </if> </trim> <trim prefix="values (" suffix=")" suffixOverrides="," > <if test="id != null" > #{id,jdbcType=INTEGER}, </if> <if test="userName != null" > #{userName,jdbcType=VARCHAR}, </if> <if test="password != null" > #{password,jdbcType=VARCHAR}, </if> <if test="email != null" > #{email,jdbcType=VARCHAR}, </if> <if test="phone != null" > #{phone,jdbcType=VARCHAR}, </if> <if test="question != null" > #{question,jdbcType=VARCHAR}, </if> <if test="answer != null" > #{answer,jdbcType=VARCHAR}, </if> <if test="role != null" > #{role,jdbcType=INTEGER}, </if> <if test="isDelete != null" > #{isDelete,jdbcType=BIT}, </if> <if test="createTime != null" > #{createTime,jdbcType=TIMESTAMP}, </if> <if test="createBy != null" > #{createBy,jdbcType=INTEGER}, </if> <if test="updateTime != null" > #{updateTime,jdbcType=TIMESTAMP}, </if> <if test="updateBy != null" > #{updateBy,jdbcType=INTEGER}, </if> </trim> </insert> <update id="updateByPrimaryKeySelective" parameterType="com.youbus.springbootdemo.pojo.User" > update hw_user <set > <if test="userName != null" > USER_NAME = #{userName,jdbcType=VARCHAR}, </if> <if test="password != null" > PASSWORD = #{password,jdbcType=VARCHAR}, </if> <if test="email != null" > EMAIL = #{email,jdbcType=VARCHAR}, </if> <if test="phone != null" > PHONE = #{phone,jdbcType=VARCHAR}, </if> <if test="question != null" > QUESTION = #{question,jdbcType=VARCHAR}, </if> <if test="answer != null" > ANSWER = #{answer,jdbcType=VARCHAR}, </if> <if test="role != null" > ROLE = #{role,jdbcType=INTEGER}, </if> <if test="isDelete != null" > IS_DELETE = #{isDelete,jdbcType=BIT}, </if> <if test="createTime != null" > CREATE_TIME = #{createTime,jdbcType=TIMESTAMP}, </if> <if test="createBy != null" > CREATE_BY = #{createBy,jdbcType=INTEGER}, </if> <if test="updateTime != null" > UPDATE_TIME = #{updateTime,jdbcType=TIMESTAMP}, </if> <if test="updateBy != null" > UPDATE_BY = #{updateBy,jdbcType=INTEGER}, </if> </set> where ID = #{id,jdbcType=INTEGER} </update> <update id="updateByPrimaryKey" parameterType="com.youbus.springbootdemo.pojo.User" > update hw_user set USER_NAME = #{userName,jdbcType=VARCHAR}, PASSWORD = #{password,jdbcType=VARCHAR}, EMAIL = #{email,jdbcType=VARCHAR}, PHONE = #{phone,jdbcType=VARCHAR}, QUESTION = #{question,jdbcType=VARCHAR}, ANSWER = #{answer,jdbcType=VARCHAR}, ROLE = #{role,jdbcType=INTEGER}, IS_DELETE = #{isDelete,jdbcType=BIT}, CREATE_TIME = #{createTime,jdbcType=TIMESTAMP}, CREATE_BY = #{createBy,jdbcType=INTEGER}, UPDATE_TIME = #{updateTime,jdbcType=TIMESTAMP}, UPDATE_BY = #{updateBy,jdbcType=INTEGER} where ID = #{id,jdbcType=INTEGER} </update> </mapper>