增删改查

web

# userMapper.xml

//登录
<select id="login" 
        parameterType="com.pollux.pojo.loginpojo"
        resultType="com.pollux.pojo.user">
        select * from USERS where NAME = #{username} and PASSWORD = #{password}
</select>

//查询
<resultMap type="java.lang.String" id="IDResultMap">
<id column="ID" jdbcType="VARCHAR" property="id" />
<result column="ACCOUNT" jdbcType="VARCHAR" property="ACCOUNT" />
</resultMap>
<select id="selectIdByAccount"
parameterType="java.lang.String" resultMap="IDResultMap">
    select <include refid="Base_Column_List" />
    from USERS where ACCOUNT = #{account,jdbcType=VARCHAR}
</select>

//更新用户的所有信息
<update id="updateByPrimaryKey" parameterType="com.pollux.pojo.user">
    update USERS
    set ACCOUNT = #{account,jdbcType=VARCHAR},
      NAME = #{name,jdbcType=VARCHAR},
      TYPE = #{type,jdbcType=DECIMAL},
      PASSWORD = #{password,jdbcType=VARCHAR},
      SFZH = #{sfzh,jdbcType=VARCHAR},
      SEX = #{sex,jdbcType=DECIMAL},
      HEAD_ICON = #{headIcon,jdbcType=VARCHAR},
      ADDRESS = #{address,jdbcType=VARCHAR},
      BMID = #{bmid,jdbcType=VARCHAR},
      PHONE = #{phone,jdbcType=VARCHAR},
      QQ = #{qq,jdbcType=VARCHAR},
      EMAIL = #{email,jdbcType=VARCHAR},
      PRIVACY_CONFIG = #{privacyConfig,jdbcType=DECIMAL},
      STATUS = #{status,jdbcType=DECIMAL}
    where ID = #{id,jdbcType=VARCHAR}
</update>

//增加用户信息（插入）
<insert id="insert" parameterType="com.pollux.pojo.user">
    insert into USERS (
      ID, ACCOUNT, NAME, 
      TYPE, PASSWORD, SFZH, 
      SEX, HEAD_ICON, ADDRESS, 
      BMID, PHONE, QQ, EMAIL, 
      PRIVACY_CONFIG, STATUS)
    values (
      #{id,jdbcType=VARCHAR}, 
      #{account,jdbcType=VARCHAR}, 
      #{name,jdbcType=VARCHAR}, 
      #{type,jdbcType=DECIMAL}, 
      #{password,jdbcType=VARCHAR}, 
      #{sfzh,jdbcType=VARCHAR}, 
      #{sex,jdbcType=DECIMAL}, 
      #{headIcon,jdbcType=VARCHAR}, 
      #{address,jdbcType=VARCHAR}, 
      #{bmid,jdbcType=VARCHAR}, 
      #{phone,jdbcType=VARCHAR}, 
      #{qq,jdbcType=VARCHAR}, 
      #{email,jdbcType=VARCHAR}, 
      #{privacyConfig,jdbcType=DECIMAL}, 
      #{status,jdbcType=DECIMAL})
</insert>

//删除用户信息
<delete id="deleteByPrimaryKey" parameterType="java.lang.String">
    delete from USERS
    where ID = #{id,jdbcType=VARCHAR}
</delete>

//查询用户
<resultMap id="BaseResultMap" type="com.pollux.pojo.user">
<id column="ID" jdbcType="VARCHAR" property="id" />
<result column="ACCOUNT" jdbcType="VARCHAR" property="account" />
<result column="NAME" jdbcType="VARCHAR" property="name" />
<result column="TYPE" jdbcType="DECIMAL" property="type" />
<result column="PASSWORD" jdbcType="VARCHAR" property="password" />
<result column="SFZH" jdbcType="VARCHAR" property="sfzh" />
<result column="SEX" jdbcType="DECIMAL" property="sex" />
<result column="HEAD_ICON" jdbcType="VARCHAR" property="headIcon" />
<result column="ADDRESS" jdbcType="VARCHAR" property="address" />
<result column="BMID" jdbcType="VARCHAR" property="bmid" />
<result column="PHONE" jdbcType="VARCHAR" property="phone" />
<result column="QQ" jdbcType="VARCHAR" property="qq" />
<result column="EMAIL" jdbcType="VARCHAR" property="email" />
<result column="PRIVACY_CONFIG" jdbcType="DECIMAL" property="privacyConfig" />
<result column="STATUS" jdbcType="DECIMAL" property="status" />
</resultMap>
<select id="selectByPrimaryKey" parameterType="java.lang.String" resultMap="BaseResultMap">
    select 
    <include refid="Base_Column_List" />
    from USERS
    where ID = #{id,jdbcType=VARCHAR}
</select>