Mybatis----根据ID修改数据——sql配置模板例子03

1.直接把POJO传入到Mybatis，根据ID找到数据，然后把POJO的数据覆盖进入数据库

简化的的POJO例子

public class Target implements Serializable {


    private static final long serialVersionUID = -4733433410890544354L;


    /**
     * 设置id，主键
     */
    private Long setup_id;

    /**
     * 代账中介id
     */
    private Long agency_id;

    public static long getSerialVersionUID() {
        return serialVersionUID;
    }

    public Long getSetup_id() {
        return setup_id;
    }

    public void setSetup_id(Long setup_id) {
        this.setup_id = setup_id;
    }

    public Long getAgency_id() {
        return agency_id;
    }

}

MyBatis的Sql配置文件

<update id="updateTarget" parameterType="com.XX.XX.XX.XX.vo.Target">

            UPDATE boss_target_setup
            <set>
                agency_id=#{agency_id},
                belong_year=#{belong_year},
                cycle_type=#{cycle_type}
            </set>
            <where>
                setup_id = #{setup_id}
            </where>
</update>