classes/production/taotaoshop/com/mapper/SysuserMapper.xml

（开头部分） 12KB

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

<?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.dao.SysuserMapper">
  <resultMap id="BaseResultMap" type="com.entity.Sysuser">
    <id column="uid" jdbcType="INTEGER" property="uid" />
    <result column="uname" jdbcType="VARCHAR" property="uname" />
    <result column="sex" jdbcType="VARCHAR" property="sex" />
    <result column="address" jdbcType="VARCHAR" property="address" />
    <result column="pwd" jdbcType="VARCHAR" property="pwd" />
    <result column="level" jdbcType="INTEGER" property="level" />
    <result column="utype" jdbcType="VARCHAR" property="utype" />
    <result column="tel" jdbcType="VARCHAR" property="tel" />
    <result column="age" jdbcType="VARCHAR" property="age" />
    <result column="mbanswer" jdbcType="VARCHAR" property="mbanswer" />
    <result column="question" jdbcType="VARCHAR" property="question" />
    <result column="email" jdbcType="VARCHAR" property="email" />
    <result column="pubtime" jdbcType="VARCHAR" property="pubtime" />
    <result column="tname" jdbcType="VARCHAR" property="tname" />
    <result column="zfpwd" jdbcType="VARCHAR" property="zfpwd" />
    <result column="ed" jdbcType="VARCHAR" property="ed" />
    <result column="clazz" jdbcType="VARCHAR" property="clazz" />
    <result column="idcard" jdbcType="VARCHAR" property="idcard" />
    <result column="isdel" jdbcType="VARCHAR" property="isdel" />
    <result column="ctype" jdbcType="VARCHAR" property="ctype" />
    <result column="smtype" jdbcType="VARCHAR" property="smtype" />
  </resultMap>
  <sql id="Base_Column_List">
    uid, uname, sex, address, pwd, level, utype, tel, age, mbanswer, question, email, 
    pubtime, tname, zfpwd, ed, clazz, idcard, isdel, ctype,smtype
  </sql>
  <select id="selectByPrimaryKey" parameterType="java.lang.Integer" resultMap="BaseResultMap">
    select 
    <include refid="Base_Column_List" />
    from sysuser
    where uid = #{uid,jdbcType=INTEGER}
  </select>
  <delete id="deleteByPrimaryKey" parameterType="java.lang.Integer">
    delete from sysuser
    where uid = #{uid,jdbcType=INTEGER}
  </delete>
  <insert id="insert" parameterType="com.entity.Sysuser">
    insert into sysuser (uid, uname, sex, 
      address, pwd, level, 
      utype, tel, age, mbanswer, 
      question, email, pubtime, 
      tname, zfpwd, ed, 
      clazz, idcard, isdel, 
      ctype,smtype)
    values (#{uid,jdbcType=INTEGER}, #{uname,jdbcType=VARCHAR}, #{sex,jdbcType=VARCHAR}, 
      #{address,jdbcType=VARCHAR}, #{pwd,jdbcType=VARCHAR}, #{level,jdbcType=INTEGER}, 
      #{utype,jdbcType=VARCHAR}, #{tel,jdbcType=VARCHAR}, #{age,jdbcType=VARCHAR}, #{mbanswer,jdbcType=VARCHAR}, 
      #{question,jdbcType=VARCHAR}, #{email,jdbcType=VARCHAR}, #{pubtime,jdbcType=VARCHAR}, 
      #{tname,jdbcType=VARCHAR}, #{zfpwd,jdbcType=VARCHAR}, #{ed,jdbcType=VARCHAR}, 
      #{clazz,jdbcType=VARCHAR}, #{idcard,jdbcType=VARCHAR}, #{isdel,jdbcType=VARCHAR}, 
      #{ctype,jdbcType=VARCHAR},#{smtype,jdbcType=VARCHAR})
  </insert>
  <insert id="insertSelective" parameterType="com.entity.Sysuser">
    insert into sysuser
    <trim prefix="(" suffix=")" suffixOverrides=",">
      <if test="uid != null">
后面还有 338 行代码，购买后查看完整代码

24 小时内免费解锁 3 个项目，之后 1 积分/个。 规则说明

AI 解读

登录后可用，每次 10 积分，解读结果公开显示在下面。

还没有人解读过这个文件。