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