<?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.ruoyi.system.mapper.house.ContrastMapper">
    <resultMap id="BaseResultMap" type="com.ruoyi.system.domain.house.Contrast">
        <id property="id" column="id" jdbcType="NUMERIC"/>
        <result property="wgName" column="wg_name" jdbcType="VARCHAR"/>
        <result property="name" column="name" jdbcType="VARCHAR"/>
        <result property="principal" column="principal" jdbcType="VARCHAR"/>
        <result property="principalTel" column="principal_tel" jdbcType="VARCHAR"/>
        <result property="flag" column="flag" jdbcType="VARCHAR"/>
    </resultMap>
    <select id="selectAll" resultType="com.ruoyi.system.domain.house.Contrast">
        SELECT * FROM contrast
    </select>
    <update id="updateById">
        UPDATE contrast
        SET wg_name = #{wgName,jdbcType=VARCHAR},
            name = #{name,jdbcType=VARCHAR},
            principal = #{principal,jdbcType=VARCHAR},
            principal_tel = #{principalTel,jdbcType=VARCHAR},
            flag = #{flag,jdbcType=VARCHAR}
        WHERE id = #{id,jdbcType=NUMERIC}
    </update>
</mapper>
