|
mybatis示例:
<select id="selectByUserIdAndProductId" resultMap="BaseResultMap" parameterType="HashMap" >
<!--
WARNING - @mbggenerated
This element is automatically generated by MyBatis Generator, do not modify.
-->
select id, p_id, bp_id, user_id, am_id_add, bo_aim, bo_title, bo_repaysrc, bo_price,
bo_finish_price, bo_expect, bo_expect_cat, bo_bidding_type, bo_safeguard_type, bo_type,
is_assurance, bo_ba_owner_rate, bo_sort, bo_rate, bo_time, bo_paytype, bo_is_index,
bo_is_state, bo_hurry, bo_capital, publish_time, bo_finish_rate, bo_is_finish, bo_finish_time,
bo_sign_am_id, bo_sign_time, bo_sign_result, bo_sign_remark, bo_audit_am_id, bo_audit_time,
bo_audit_remark, bo_is_success, bo_can_success, bo_is_republish, bo_is_case, bo_guid,
bo_extno, bo_agree_generated, bo_agree_time, bo_all_repayed, bo_last_repayed_time,
bo_audit_delay_days, bo_loan_agreement, bo_loan_template, bo_sorce_talk, bo_sorce_instrument,
bo_sorce_face, bo_sorce_cooperation, bo_pledge, bo_house, bo_overdue_day_count, bo_overdue_remark,
bo_contract, bo_repay_monitor, bo_overdue, bo_mxjb_match_time, version, creator,
updator, create_time, update_time, bo_des, bo_finance, bo_change_remark, voice_to_text
from borrows
where user_id = #{user_id}
and p_id= #{product_id}
</select> |
|