resources/mapper/bus/CustomerMapper.xml

这里只显示每个文件的开头 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.sxt.bus.mapper.CustomerMapper">
	<resultMap id="BaseResultMap"
		type="com.sxt.bus.domain.Customer">
		<id column="identity" jdbcType="VARCHAR" property="identity" />
		<result column="custname" jdbcType="VARCHAR"
			property="custname" />
		<result column="sex" jdbcType="INTEGER" property="sex" />
		<result column="address" jdbcType="VARCHAR" property="address" />
		<result column="phone" jdbcType="VARCHAR" property="phone" />
		<result column="career" jdbcType="VARCHAR" property="career" />
		<result column="createtime" jdbcType="TIMESTAMP"
			property="createtime" />
	</resultMap>
	<sql id="Base_Column_List">
		identity, custname, sex, address, phone, career, createtime
	</sql>
	<select id="selectByPrimaryKey" parameterType="java.lang.String"
		resultMap="BaseResultMap">
		select
		<include refid="Base_Column_List" />
		from bus_customer
		where identity = #{identity,jdbcType=VARCHAR}
	</select>
	<delete id="deleteByPrimaryKey" parameterType="java.lang.String">
		delete from bus_customer
		where identity = #{identity,jdbcType=VARCHAR}
	</delete>
	<insert id="insert" parameterType="com.sxt.bus.domain.Customer">
		insert into bus_customer (identity, custname, sex,
		address, phone, career,
		createtime)
		values (#{identity,jdbcType=VARCHAR}, #{custname,jdbcType=VARCHAR},
		#{sex,jdbcType=INTEGER},
		#{address,jdbcType=VARCHAR}, #{phone,jdbcType=VARCHAR}, #{career,jdbcType=VARCHAR},
		#{createtime,jdbcType=TIMESTAMP})
	</insert>
	<insert id="insertSelective"
		parameterType="com.sxt.bus.domain.Customer">
		insert into bus_customer
		<trim prefix="(" suffix=")" suffixOverrides=",">
			<if test="identity != null">
				identity,
			</if>
			<if test="custname != null">
				custname,
			</if>
			<if test="sex != null">
				sex,
			</if>
			<if test="address != null">
				address,
			</if>
			<if test="phone != null">
				phone,
			</if>
			<if test="career != null">
				career,
			</if>