Select元素標(biāo)簽輸入方式
基本數(shù)據(jù)類型
字符串類型
Map 類型
Java bean 類型
案例實(shí)操
輸入?yún)?shù)分類
基本類型郑叠，字符串，java bean,map产禾，數(shù)組（刪除操作時(shí)體現(xiàn)）排作，List（添加時(shí)體現(xiàn)）等每種情況定義如下
基本數(shù)據(jù)類型
Statement 定義
<select id="queryCustomerById" parameterType="int" resultType="com.xxx.pojo.Customer">
SELECT id,user_name 'userName',user_balance 'userBalance' FROM ?yg_customer WHERE ?id=#{id}
</select>
CustomerDao方法定義
Customer queryCustomerById(int id);
字符串類型
Statement 定義
<select id="queryCustomerByName" parameterType="string" resultType="com.xxx.pojo.Customer">
SELECT id,user_name 'userName',user_balance 'userBalance' FROM ?yg_customer WHERE ?user_name=#{userName}
</select>
Dao 方法定義
Customer queryCustomerById(int id);
Map 類型
Statement 定義
<select id="queryCustomerByName" parameterType="map" resultType="com.xxx.pojo.Customer">
SELECT id,user_name 'userName',user_balance 'userBalance' FROM ?yg_customer WHERE ?user_name=#{userName}
</select>
Dao 方法定義
Customer queryCustomerByName(Map<String,Object> userName);
Java bean 類型
Statement 定義
<select id="queryCustomerByParams" parameterType="customer" resultType="customer">
SELECT id,user_name 'userName',user_balance 'userBalance' FROM ?yg_customer WHERE ?user_name=#{userName}
</select>
Dao方法定義
Customer queryCustomerByParams(Customer customer);
####
擴(kuò)展
結(jié)果類型分類
基本數(shù)據(jù)類型，字符串亚情，JavaBean妄痪，Map,List等
基本數(shù)據(jù)類型
Statement定義
<select id="queryCustomerAccount" resultType="int">
select count(1) from yg_customer
</select>
Dao 方法定義與對應(yīng)實(shí)現(xiàn)
int queryCustomerAccount();
字符串類型
Statement定義
<select id="queryCustomerNameById" resultType="string" parameterType="int">
select user_name from yg_customer WHERE id=#{id}
</select>
Dao 方法定義
String queryCustomerNameById(int id);
Java Bean
Statement定義
<select id="queryUserByUser" parameterType="user" ?resultType="user">
select id,user_name as userName,user_pwd as userPwd from user where id=#{id}
</select>
List
Statement 定義
<resultMap type="user" id="user_map">
<result column="id" property="id"/>
<result column="user_name" property="userName"/>
<result column="user_pwd" property="userPwd"/>
</resultMap>
<sql id="user_column">
id,user_name,user_pwd
</sql>
<select id="queryUserNyName2" parameterType="string" resultMap="user_map">
select?<include refid="user_column"/>
from user where user_name like concat("%",#{userName},"%")
</select>
Map 類型數(shù)據(jù)
Statement 定義
<select id="queryUserByIdReturnMap" ?parameterType="int" resultType="map">
select id,user_name as userName,user_pwd as userPwd from user where id=#{id}
</select>
