MyBatis学习记录二

Mapper.xml详细解析
statement标签：select\update\insert\detele
parameterType:参数数据类型
1、基本数据类型，通过id查询Account

<select id="findById" parameterType="long" resultType="com.southwind.entity.Account">
	select * from t_account where id = #{id}
</select>

2、String类型，通过name查询Account

<select id="findById" parameterType="java.lang.String" resultType="com.southwind.entity.Account">
	 select * from t_account where username= #{username}
</select>

3、包装类，通过id查询Account

<select id="findById2" parameterType="java.lang.Long" resultType="com.southwind.entity.Account">
 select * from t_account where id = #{id}
</select>

4、多个参数，通过username和age查询Account

<select id="findByNameAndAge"  resultType="com.southwind.entity.Account">
 select * from t_account where username = #{arg0} and age = #{arg1}
</select>

5、Java Bean

<select id="update" resultType="com.southwind.entity.Account">ct
	update t_account set username = #{username},pasword = #{password},age = #{age} where id = #{id}
</select>

resultType:结果类型
1、基本数据类型，统计Account的总数

<select id="count" resultType="int">
	select count(id) from t_acount;
</select>

2、包装类，统计Account的总数

<select id="count2" resultType="java.lang.Integer">
	select * from t_account;
</select>

3、String类型，通过id查询Account的name

<select id="findNameById" resultType="java.lang.String">
	select username from t_account where id = #{id}
</select>

4、Java Bean

<select id="findById" parameterType="long" resultType="com.southwind.entity.Account">
	select * from t_account where id = #{id}
</select>