官网的例子永远是最好的,切记切记!!
拼接条件
<sql id="select_asset_where">
<if test="accountType != null and accountType.size != 0" >
and
<foreach collection="accountType" item="param" separator="OR" open="(" close=")">
a.account_type = #{param}
</foreach>
</if>
</sql>
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
条件查询
<select id="selectAssetByCondition"
parameterType="com.zemcho.controller.asset.dto.AssetConditionDto" resultMap="AssetCondtitionResultMap">
SELECT reg_code, asset_name, asset_type, metering_units, use_info,
expect_end_date, regist_man, regist_date, account_type, fee_item,
finance_bill_date, user, user_account, keeper, checker,
buyer, school_addr, account_book, acquire_way, asset_use_way,
write_off_date, asset_status_1, store_place, orginal_value, net_value,
number_value
FROM tb_asset_regist_d a
<if test="assetDepInfo != null" >
, cfg_asset_dep_info b
</if>
<if test="assetTypeInfo != null" >
, cfg_asset_type_info c
</if>
<where>
<include refid="select_asset_where"></include>
</where>
</select>
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
批量插入
宁波好的整形医院http://www.iyestar.com/
宁波最好的整形医院http://www.iyestar.com/
<!-- 批量插入 -->
<!-- 批量插入生成的兑换码 -->
<insert id ="insertBulk" parameterType="java.util.List" >
<selectKey resultType ="java.lang.Integer" keyProperty= "id"
order= "AFTER">
SELECT LAST_INSERT_ID()
</selectKey >
insert into `tb_basic_treatment_d`
(<include refid="Base_Column_List" />,LOAD_TIME)
values
<foreach collection ="list" item="item" index= "index" separator =",">
(
#{item.name},
#{item.teacherNumber},
#{item.idNumber},
#{item.year},
#{item.annualWageIncomeYuan},
#{item.fiveInsuranceAGold},
#{item.loadTime}
)
</foreach >
</insert >
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
普通查询
<select id="selectByReaderNum" parameterType="string" resultMap="BaseResultMap">
select
<include refid="Base_Column_List" />
from tb_library_borrower_d
where reader_id = #{num,jdbcType=VARCHAR} limit 1
</select>
- 1
- 2
- 3
- 4
- 5
- 6