src/org/bs/model/SqlMapping_eg.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.Credit"><!-- //命名空间 -->
	<insert id="insert" parameterType="Person"><!-- //id 和参数（已经声明了的） -->
		insert into t_person(id,username,password,age,birthday,score,reg_time)
		 values (seq_person_id.nextval,#{username,jdbcType=VARCHAR},#{password},#{age},#{birthday,jdbcType=DATE},#{score},#{regTime})
	</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>