New file |
| | |
| | | <?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.dy.pipIrrGlobal.daoSe.SeManagementCardMapper"> |
| | | <resultMap id="BaseResultMap" type="com.dy.pipIrrGlobal.pojoSe.SeManagementCard"> |
| | | <!--@mbg.generated--> |
| | | <!--@Table se_management_card--> |
| | | <id column="id" jdbcType="BIGINT" property="id" /> |
| | | <result column="protocol" jdbcType="VARCHAR" property="protocol" /> |
| | | <result column="card_addr" jdbcType="VARCHAR" property="cardAddr" /> |
| | | <result column="security_code" jdbcType="VARCHAR" property="securityCode" /> |
| | | <result column="card_type" jdbcType="TINYINT" property="cardType" /> |
| | | <result column="create_time" jdbcType="TIMESTAMP" property="createTime" /> |
| | | <result column="order_no" jdbcType="VARCHAR" property="orderNo" /> |
| | | <result column="district_code" jdbcType="VARCHAR" property="districtCode" /> |
| | | <result column="project_no" jdbcType="INTEGER" property="projectNo" /> |
| | | <result column="ip" jdbcType="VARCHAR" property="ip" /> |
| | | <result column="domain" jdbcType="VARCHAR" property="domain" /> |
| | | <result column="open_clost_time" jdbcType="INTEGER" property="openClostTime" /> |
| | | <result column="remarks" jdbcType="VARCHAR" property="remarks" /> |
| | | </resultMap> |
| | | <sql id="Base_Column_List"> |
| | | <!--@mbg.generated--> |
| | | id, protocol, card_addr, security_code, card_type, create_time, order_no, district_code, |
| | | project_no, ip, `domain`, open_clost_time, remarks |
| | | </sql> |
| | | <select id="selectByPrimaryKey" parameterType="java.lang.Long" resultMap="BaseResultMap"> |
| | | <!--@mbg.generated--> |
| | | select |
| | | <include refid="Base_Column_List" /> |
| | | from se_management_card |
| | | where id = #{id,jdbcType=BIGINT} |
| | | </select> |
| | | <delete id="deleteByPrimaryKey" parameterType="java.lang.Long"> |
| | | <!--@mbg.generated--> |
| | | delete from se_management_card |
| | | where id = #{id,jdbcType=BIGINT} |
| | | </delete> |
| | | <insert id="insert" parameterType="com.dy.pipIrrGlobal.pojoSe.SeManagementCard"> |
| | | <!--@mbg.generated--> |
| | | insert into se_management_card (id, protocol, card_addr, |
| | | security_code, card_type, create_time, |
| | | order_no, district_code, project_no, |
| | | ip, `domain`, open_clost_time, |
| | | remarks) |
| | | values (#{id,jdbcType=BIGINT}, #{protocol,jdbcType=VARCHAR}, #{cardAddr,jdbcType=VARCHAR}, |
| | | #{securityCode,jdbcType=VARCHAR}, #{cardType,jdbcType=TINYINT}, #{createTime,jdbcType=TIMESTAMP}, |
| | | #{orderNo,jdbcType=VARCHAR}, #{districtCode,jdbcType=VARCHAR}, #{projectNo,jdbcType=INTEGER}, |
| | | #{ip,jdbcType=VARCHAR}, #{domain,jdbcType=VARCHAR}, #{openClostTime,jdbcType=INTEGER}, |
| | | #{remarks,jdbcType=VARCHAR}) |
| | | </insert> |
| | | <insert id="insertSelective" parameterType="com.dy.pipIrrGlobal.pojoSe.SeManagementCard"> |
| | | <!--@mbg.generated--> |
| | | insert into se_management_card |
| | | <trim prefix="(" suffix=")" suffixOverrides=","> |
| | | <if test="id != null"> |
| | | id, |
| | | </if> |
| | | <if test="protocol != null"> |
| | | protocol, |
| | | </if> |
| | | <if test="cardAddr != null"> |
| | | card_addr, |
| | | </if> |
| | | <if test="securityCode != null"> |
| | | security_code, |
| | | </if> |
| | | <if test="cardType != null"> |
| | | card_type, |
| | | </if> |
| | | <if test="createTime != null"> |
| | | create_time, |
| | | </if> |
| | | <if test="orderNo != null"> |
| | | order_no, |
| | | </if> |
| | | <if test="districtCode != null"> |
| | | district_code, |
| | | </if> |
| | | <if test="projectNo != null"> |
| | | project_no, |
| | | </if> |
| | | <if test="ip != null"> |
| | | ip, |
| | | </if> |
| | | <if test="domain != null"> |
| | | `domain`, |
| | | </if> |
| | | <if test="openClostTime != null"> |
| | | open_clost_time, |
| | | </if> |
| | | <if test="remarks != null"> |
| | | remarks, |
| | | </if> |
| | | </trim> |
| | | <trim prefix="values (" suffix=")" suffixOverrides=","> |
| | | <if test="id != null"> |
| | | #{id,jdbcType=BIGINT}, |
| | | </if> |
| | | <if test="protocol != null"> |
| | | #{protocol,jdbcType=VARCHAR}, |
| | | </if> |
| | | <if test="cardAddr != null"> |
| | | #{cardAddr,jdbcType=VARCHAR}, |
| | | </if> |
| | | <if test="securityCode != null"> |
| | | #{securityCode,jdbcType=VARCHAR}, |
| | | </if> |
| | | <if test="cardType != null"> |
| | | #{cardType,jdbcType=TINYINT}, |
| | | </if> |
| | | <if test="createTime != null"> |
| | | #{createTime,jdbcType=TIMESTAMP}, |
| | | </if> |
| | | <if test="orderNo != null"> |
| | | #{orderNo,jdbcType=VARCHAR}, |
| | | </if> |
| | | <if test="districtCode != null"> |
| | | #{districtCode,jdbcType=VARCHAR}, |
| | | </if> |
| | | <if test="projectNo != null"> |
| | | #{projectNo,jdbcType=INTEGER}, |
| | | </if> |
| | | <if test="ip != null"> |
| | | #{ip,jdbcType=VARCHAR}, |
| | | </if> |
| | | <if test="domain != null"> |
| | | #{domain,jdbcType=VARCHAR}, |
| | | </if> |
| | | <if test="openClostTime != null"> |
| | | #{openClostTime,jdbcType=INTEGER}, |
| | | </if> |
| | | <if test="remarks != null"> |
| | | #{remarks,jdbcType=VARCHAR}, |
| | | </if> |
| | | </trim> |
| | | </insert> |
| | | <update id="updateByPrimaryKeySelective" parameterType="com.dy.pipIrrGlobal.pojoSe.SeManagementCard"> |
| | | <!--@mbg.generated--> |
| | | update se_management_card |
| | | <set> |
| | | <if test="protocol != null"> |
| | | protocol = #{protocol,jdbcType=VARCHAR}, |
| | | </if> |
| | | <if test="cardAddr != null"> |
| | | card_addr = #{cardAddr,jdbcType=VARCHAR}, |
| | | </if> |
| | | <if test="securityCode != null"> |
| | | security_code = #{securityCode,jdbcType=VARCHAR}, |
| | | </if> |
| | | <if test="cardType != null"> |
| | | card_type = #{cardType,jdbcType=TINYINT}, |
| | | </if> |
| | | <if test="createTime != null"> |
| | | create_time = #{createTime,jdbcType=TIMESTAMP}, |
| | | </if> |
| | | <if test="orderNo != null"> |
| | | order_no = #{orderNo,jdbcType=VARCHAR}, |
| | | </if> |
| | | <if test="districtCode != null"> |
| | | district_code = #{districtCode,jdbcType=VARCHAR}, |
| | | </if> |
| | | <if test="projectNo != null"> |
| | | project_no = #{projectNo,jdbcType=INTEGER}, |
| | | </if> |
| | | <if test="ip != null"> |
| | | ip = #{ip,jdbcType=VARCHAR}, |
| | | </if> |
| | | <if test="domain != null"> |
| | | `domain` = #{domain,jdbcType=VARCHAR}, |
| | | </if> |
| | | <if test="openClostTime != null"> |
| | | open_clost_time = #{openClostTime,jdbcType=INTEGER}, |
| | | </if> |
| | | <if test="remarks != null"> |
| | | remarks = #{remarks,jdbcType=VARCHAR}, |
| | | </if> |
| | | </set> |
| | | where id = #{id,jdbcType=BIGINT} |
| | | </update> |
| | | <update id="updateByPrimaryKey" parameterType="com.dy.pipIrrGlobal.pojoSe.SeManagementCard"> |
| | | <!--@mbg.generated--> |
| | | update se_management_card |
| | | set protocol = #{protocol,jdbcType=VARCHAR}, |
| | | card_addr = #{cardAddr,jdbcType=VARCHAR}, |
| | | security_code = #{securityCode,jdbcType=VARCHAR}, |
| | | card_type = #{cardType,jdbcType=TINYINT}, |
| | | create_time = #{createTime,jdbcType=TIMESTAMP}, |
| | | order_no = #{orderNo,jdbcType=VARCHAR}, |
| | | district_code = #{districtCode,jdbcType=VARCHAR}, |
| | | project_no = #{projectNo,jdbcType=INTEGER}, |
| | | ip = #{ip,jdbcType=VARCHAR}, |
| | | `domain` = #{domain,jdbcType=VARCHAR}, |
| | | open_clost_time = #{openClostTime,jdbcType=INTEGER}, |
| | | remarks = #{remarks,jdbcType=VARCHAR} |
| | | where id = #{id,jdbcType=BIGINT} |
| | | </update> |
| | | </mapper> |