WebRoot/WEB-INF/classes/org/bs/model/SqlMap_Loan.xml

微信扫码关注公众号，代码整理好后第一时间通知你。

<?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="org.bs.model.Loan">						<!-- //命名空间 -->
	<insert id="insert" parameterType="Loan">						<!-- //id 和参数（已经声明了的） -->
		insert into t_loan(kind,amount,pawn,assess,company,risk,approval)
		 values (#{kind,jdbcType=VARCHAR},#{amount},#{pawn},#{assess},#{company},#{risk},#{approval})
	</insert>
	<!-- //OGNL表达式，另外必须声明了jdbcType才可以传递空值 -->
	<update id="update" parameterType="Person">
		update t_person set username=#{username},password=#{password},age=#{age},birthday=#{birthday},score=#{score},reg_time=#{regTime} where id=#{id}
	</update>
	<delete id="delete" parameterType="int"> <!-- 如果是基本数据类型 则取值是key随便写 -->
		delete from t_person where id=#{id}
	</delete>
	<select id="selectOne" parameterType="int" resultType="Person">
		select * from t_person where id=#{id}
	</select>
	<select id="selectList"  resultType="Person">
		select * from t_person 
	</select>
	<select id="selectListLikeUsername" parameterType="string" resultType="Person">
		select * from t_person  where username like #{username}
	</select>
	<select id="selectListLikeUsernameAndAgeBetween" parameterType="map" resultType="Person">
		select * from t_person  where username like #{username} and age between #{age1} and #{age2} 
	</select>
</mapper>