文章分类:Java编程
在ibatis,输入的参数对象常以parameterClass来定义,输出的结果集常以resultMap来定义。(resultMap:方便JAVABEAN属性及字段的映射,调用JAVABEAN的setter进行设置值。通常我们不采用resultClass属性进行映射,因为它不具备映射数据库表字段的持久化特性。)
在ibateis中,parameterClass的类型大都是:string,int/对象/hashmap
resultclass/resultMap的类型大都是:对象/hashmap
当parameterClass为string,int时,可用#value#表示或直接用传入的值名表示。
当parameterClass/resultMap的类型是对象时,用#属性#表示。程序会调用JAVABEAN的getter方法,进行获得属性值。
当parameterClass/resultMap的类型是hashmap(Map是key-value结构的)时,那程序会直接通过key来分析取参数。
具体请见以下两部分:
ibatis各种参数数据集
原型参数
<select id="select1" parameterClass="java.lang.String" resultClass="AppLog">
select
ID as id,
TYPE as type,
DESCR as descr
from APP_LOG
where ID = #id#
</select>
sqlMapper.queryForObject("select0", id);
--参数名与传入值名称一样。--应该也可用参数#value#表示
Map类参数
<select id="select2" parameterClass="java.util.HashMap" resultClass="AppLog">
select
ID as id,
TYPE as type,
DESCR as descr
from APP_LOG
where ID = #ids#
</select>
map.put("ids", id);
AppLog log = (AppLog) sqlMapper.queryForObject("select0", map);
--通过key来获得值
对象参数
<select id="select3" parameterClass="AppLog" resultClass="AppLog">
select
ID as id,
TYPE as type,
DESCR as descr
from APP_LOG
where ID = #id#
</select>
AppLog p=new AppLog();
p.setId(id);
AppLog log = (AppLog) sqlMapper.queryForObject("select3", p);
动态字段、表
<select id="selectd" resultClass="java.util.HashMap" parameterClass="java.util.HashMap"
remapResults="true">
select $fieldList$
from $table$
where ID = #id#
</select>
Map p = new HashMap();
p.put("id", id);
p.put("table","APP_LOG");
p.put("fieldList", "ID,TYPE,DESCR");
Map map = (Map) sqlMapper.queryForObject("selectd", p);
String id1 = (String) map.get("ID");
String type = (String) map.get("TYPE");
String descr = (String) map.get("DESCR");
注重:#与$区别:
1.#是把传入的数据当作字符串,如#field#传入的是id,则sql语句生成是这样,order by "id",这当然会报错..
2.$传入的数据直接生成在sql里,如#field#传入的是id,则sql语句生成是这样,order by id, 这就对了.
$方式一般用于传入数据库对象.例如传入表名.
#方式一般用于传入插入/更新的值或查询/删除的where条件
ibatis各种返回数据集
别名映射->实体类 + resultClass
<select id=" selectAll" resultClass="AppLog">
select
ID as id,
TYPE as type,
DESCR as descr
from APP_LOG
where ID = #id#
</select>
List list = sqlMapper.queryForList("selectAll");
for (int i = 0; i < list.size(); i ) {
AppLog log = (AppLog) list.get(i);
//add your code here;
}
注重:
为什么定义了resultClass="AppLog",而queryForList出来的是list?
这里的resultClass="AppLog",是指查询出来的每条记录的格式是AppLog。
当我们queryForList时,系统会将各条记录(即各个AppLog放到list中)传回给我们。当我们queryForObject时,就只传回一个AppLog。
别名映射->Map类+resultClass --》把每条记录放于map中,字段名为key,值为value.
<select id=" selectAll" resultClass="java.util.HashMap">
select
ID as id,
TYPE as type,
DESCR as descr
from APP_LOG
where ID = #id#
</select>
List list = sqlMapper.queryForList("selectAll");
for (int i = 0; i < list.size(); i ) {
Map map = (Map) list.get(i);
String id = (String) map.get("id");
String type = (String) map.get("type");
String descr = (String) map.get("descr");
//add your code here;
}
无映射
<select id="selectAll3" resultClass="java.util.HashMap">
select * from APP_LOG
</select>
List list = sqlMapper.queryForList("selectAll3");
for (int i = 0; i < list.size(); i ) {
Map map = (Map) list.get(i);
String id = (String) map.get("ID");
String type = (String) map.get("TYPE");
String descr = (String) map.get("DESCR");
}
显式映射->实体类:resultMap
<resultMap id="AppLogResult" class="AppLog">
<result property="id" column="ID"/>
<result property="type" column="Type"/>
<result property="descr" column="DESCR"/>
</resultMap>
<select id="selectAll" resultMap="AppLogResult">
select * from APP_LOG
</select>
List list = sqlMapper.queryForList("selectAll");
for (int i = 0; i < list.size(); i ) {
AppLog log = (AppLog) list.get(i);
//add your code here;
}
显式映射->Map类:resultMap --》把每条记录放于map中,字段名为key,值为value.
<resultMap id="map-result" class="java.util.HashMap">
<result property="id" column="ID"/>
<result property="type" column="Type"/>
<result property="descr" column="DESCR"/>
</resultMap>
<select id="selectAll2" resultMap="map-result">
select * from APP_LOG
</select>
List list = sqlMapper.queryForList("selectAll2");
for (int i = 0; i < list.size(); i ) {
Map map = (Map) list.get(i);
String id = (String) map.get("id");
String type = (String) map.get("type");
String descr = (String) map.get("descr");
}
又如:
map.put("appIds", Ids);
executor.update("Device.OpenClientApp", map);
下面的property属性及循环变量,都是对应map的key名。
-----证实,ibatis对于hashmap,都是通过key来获得值的。所以,所有参数须用key来表示!!!
如下:
<update id="Device.OpenClientApp" parameterClass="java.util.HashMap">
update T_Device_App_R_Info set Opr='1' where App_ID in
<iterate conjunction="," open="(" close=")" property="appIds">
#appIds[]#
</iterate>
</update>
例子:
<statement id=”statementName” parameterClass=” examples.domain.Product”>
insert into PRODUCT values (#id#, #description#, #price#, #classify.id#)
</statement>
蓝色部分#classify.id#翻译过来实际是product.getClassify().getId(),classify是Product对象的一个子对象。
(4)关于参数的三种设置方法 及 ParameterMap用法
前提:有一个user的javabean.
一,自动参数映射:
<insert id="insertUser7" parameterClass="user">
<![CDATA[
INSERT INTO t_user ( ID, NAME, PASS )VALUES( #id#,#name#,#pass# )
]]>
</insert>
二,内联参数映射:
<insert id="insertUser8" parameterClass="user">
<![CDATA[
INSERT INTO t_user ( ID, NAME, PASS ) VALUES( #id:INT#, #name:VARCHAR#, #pass:VARCHAR# )
]]>
</insert>
备注: 似乎将属性对应的数据类型故意写错,程序也可正常执行,没报错.
三,外联参数映射:
以上二种方式都用paramClass,但此处用parameterMap.
<parameterMap id="parameterMap" class="user">
<parameter property="id" jdbcType="INTEGER" />
<parameter property="name" jdbcType="VARCHAR" />
<parameter property="pass" jdbcType="VARCHAR" />
</parameterMap>
<insert id="insertUser9" parameterMap="parameterMap">
<![CDATA[
INSERT INTO t_user ( ID, NAME, PASS )VALUES( ?,?,? )
]]>
</insert>
若此处的对象不是javabean,而是一个hashMap.用法也一样,只是id,name,pass不是javabean的属性,而是hashMap的key.
String[] ids;
...........
map.put("devId", ids[0]);
map.put("appId", ids[1]);
<!-- 自动参数映射方式 -->
<insert id="DAPermit.addAppDevMapping" parameterClass="java.util.HashMap">
insert into T_Device_App_R_Info(Device_ID,App_ID,Opr) values (#devId#,#appId#,'2');
</insert>
<!--
内联方式:
<insert id="DAPermit.addAppDevMapping" parameterClass="java.util.HashMap">
insert into T_Device_App_R_Info(Device_ID,App_ID,Opr) values (#devId:varchar#,#appId:varchar#,'2');
</insert>
外联方式:
<parameterMap id="dapermitParams" class="java.util.HashMap">
<parameter property="devId" jdbcType="VARCHAR"/>
<parameter property="appId" jdbcType="VARCHAR"/>
</parameterMap>
<insert id="DAPermit.addAppDevMapping" parameterMap="dapermitParams">
insert into T_Device_App_R_Info(Device_ID,App_ID,Opr) values (?,?,'2');
</insert>
-->
四,利用parameterMap调用存储过程:
<!-- example 11: 存储过程 -->
<resultMap id="returnResultMap" class="user">
<result property="id" column="ID" />
</resultMap>
<parameterMap id="paramUser" class="java.util.Map">
<parameter property="name" jdbcType="VARCHAR" javaType="string" mode="IN" />
<parameter property="pass" jdbcType="VARCHAR" javaType="string" mode="IN" />
<parameter property="id" jdbcType="INT" javaType="Integer" mode="INOUT" resultMap="returnResultMap" />
</parameterMap>
<procedure id="pro_insertUser11" parameterMap="paramUser" resultClass="int">
<![CDATA[
{call proc_userinsert(?,?,?)}
]]>
</procedure>
然后在UserDaoTest.java中增加如下一个方法:
public static void example11() throws Exception {
try {
Map map = new HashMap();
map.put("name", "procedure");
map.put("pass", "123456");
Integer returnValue = (Integer)sqlMapClient.insert("pro_insertUser11", map);
System.out.println(returnValue);
} catch (Exception e) {
e.printStackTrace();
}
}
如何用Map类型的对象作为传入参数?
<!--
这里,可以使用全路径类名,如:
java.util.Map
java.util.HashMap
java.util.TreeMap
或
map
-->
<insert id="insertUser" parameterClass="map">
insert into t_user values (
null,#username#,#password#
)
</insert>
Map user = new TreeMap();
user.put("username", "Map用户");
user.put("password", "Map用户密码");
sqlMapper.insert("insertUser",user);
如何将查询结果集的元素转换为Map类型的对象?
<!--
resultClass可以定义为java.util.HashMap类型,
将能自动转换
-->
<select id="selectMapUsers" resultClass="java.util.HashMap">
select * from t_user
</select>
List list = (List)sqlMapper.queryForList("selectMapUsers");
System.out.println(list);
for (Iterator iter = list.iterator(); iter.hasNext();) {
Map map = (Map) iter.next();
//可在此输出map的数据
}
在ibateis中,parameterClass的类型大都是:string,int/对象/hashmap
resultclass/resultMap的类型大都是:对象/hashmap
当parameterClass为string,int时,可用#value#表示或直接用传入的值名表示。
当parameterClass/resultMap的类型是对象时,用#属性#表示。程序会调用JAVABEAN的getter方法,进行获得属性值。
当parameterClass/resultMap的类型是hashmap(Map是key-value结构的)时,那程序会直接通过key来分析取参数。
具体请见以下两部分:
ibatis各种参数数据集
原型参数
<select id="select1" parameterClass="java.lang.String" resultClass="AppLog">
select
ID as id,
TYPE as type,
DESCR as descr
from APP_LOG
where ID = #id#
</select>
sqlMapper.queryForObject("select0", id);
--参数名与传入值名称一样。--应该也可用参数#value#表示
Map类参数
<select id="select2" parameterClass="java.util.HashMap" resultClass="AppLog">
select
ID as id,
TYPE as type,
DESCR as descr
from APP_LOG
where ID = #ids#
</select>
map.put("ids", id);
AppLog log = (AppLog) sqlMapper.queryForObject("select0", map);
--通过key来获得值
对象参数
<select id="select3" parameterClass="AppLog" resultClass="AppLog">
select
ID as id,
TYPE as type,
DESCR as descr
from APP_LOG
where ID = #id#
</select>
AppLog p=new AppLog();
p.setId(id);
AppLog log = (AppLog) sqlMapper.queryForObject("select3", p);
动态字段、表
<select id="selectd" resultClass="java.util.HashMap" parameterClass="java.util.HashMap"
remapResults="true">
select $fieldList$
from $table$
where ID = #id#
</select>
Map p = new HashMap();
p.put("id", id);
p.put("table","APP_LOG");
p.put("fieldList", "ID,TYPE,DESCR");
Map map = (Map) sqlMapper.queryForObject("selectd", p);
String id1 = (String) map.get("ID");
String type = (String) map.get("TYPE");
String descr = (String) map.get("DESCR");
注重:#与$区别:
1.#是把传入的数据当作字符串,如#field#传入的是id,则sql语句生成是这样,order by "id",这当然会报错..
2.$传入的数据直接生成在sql里,如#field#传入的是id,则sql语句生成是这样,order by id, 这就对了.
$方式一般用于传入数据库对象.例如传入表名.
#方式一般用于传入插入/更新的值或查询/删除的where条件
ibatis各种返回数据集
别名映射->实体类 + resultClass
<select id=" selectAll" resultClass="AppLog">
select
ID as id,
TYPE as type,
DESCR as descr
from APP_LOG
where ID = #id#
</select>
List list = sqlMapper.queryForList("selectAll");
for (int i = 0; i < list.size(); i ) {
AppLog log = (AppLog) list.get(i);
//add your code here;
}
注重:
为什么定义了resultClass="AppLog",而queryForList出来的是list?
这里的resultClass="AppLog",是指查询出来的每条记录的格式是AppLog。
当我们queryForList时,系统会将各条记录(即各个AppLog放到list中)传回给我们。当我们queryForObject时,就只传回一个AppLog。
别名映射->Map类+resultClass --》把每条记录放于map中,字段名为key,值为value.
<select id=" selectAll" resultClass="java.util.HashMap">
select
ID as id,
TYPE as type,
DESCR as descr
from APP_LOG
where ID = #id#
</select>
List list = sqlMapper.queryForList("selectAll");
for (int i = 0; i < list.size(); i ) {
Map map = (Map) list.get(i);
String id = (String) map.get("id");
String type = (String) map.get("type");
String descr = (String) map.get("descr");
//add your code here;
}
无映射
<select id="selectAll3" resultClass="java.util.HashMap">
select * from APP_LOG
</select>
List list = sqlMapper.queryForList("selectAll3");
for (int i = 0; i < list.size(); i ) {
Map map = (Map) list.get(i);
String id = (String) map.get("ID");
String type = (String) map.get("TYPE");
String descr = (String) map.get("DESCR");
}
显式映射->实体类:resultMap
<resultMap id="AppLogResult" class="AppLog">
<result property="id" column="ID"/>
<result property="type" column="Type"/>
<result property="descr" column="DESCR"/>
</resultMap>
<select id="selectAll" resultMap="AppLogResult">
select * from APP_LOG
</select>
List list = sqlMapper.queryForList("selectAll");
for (int i = 0; i < list.size(); i ) {
AppLog log = (AppLog) list.get(i);
//add your code here;
}
显式映射->Map类:resultMap --》把每条记录放于map中,字段名为key,值为value.
<resultMap id="map-result" class="java.util.HashMap">
<result property="id" column="ID"/>
<result property="type" column="Type"/>
<result property="descr" column="DESCR"/>
</resultMap>
<select id="selectAll2" resultMap="map-result">
select * from APP_LOG
</select>
List list = sqlMapper.queryForList("selectAll2");
for (int i = 0; i < list.size(); i ) {
Map map = (Map) list.get(i);
String id = (String) map.get("id");
String type = (String) map.get("type");
String descr = (String) map.get("descr");
}
又如:
map.put("appIds", Ids);
executor.update("Device.OpenClientApp", map);
下面的property属性及循环变量,都是对应map的key名。
-----证实,ibatis对于hashmap,都是通过key来获得值的。所以,所有参数须用key来表示!!!
如下:
<update id="Device.OpenClientApp" parameterClass="java.util.HashMap">
update T_Device_App_R_Info set Opr='1' where App_ID in
<iterate conjunction="," open="(" close=")" property="appIds">
#appIds[]#
</iterate>
</update>
例子:
<statement id=”statementName” parameterClass=” examples.domain.Product”>
insert into PRODUCT values (#id#, #description#, #price#, #classify.id#)
</statement>
蓝色部分#classify.id#翻译过来实际是product.getClassify().getId(),classify是Product对象的一个子对象。
(4)关于参数的三种设置方法 及 ParameterMap用法
前提:有一个user的javabean.
一,自动参数映射:
<insert id="insertUser7" parameterClass="user">
<![CDATA[
INSERT INTO t_user ( ID, NAME, PASS )VALUES( #id#,#name#,#pass# )
]]>
</insert>
二,内联参数映射:
<insert id="insertUser8" parameterClass="user">
<![CDATA[
INSERT INTO t_user ( ID, NAME, PASS ) VALUES( #id:INT#, #name:VARCHAR#, #pass:VARCHAR# )
]]>
</insert>
备注: 似乎将属性对应的数据类型故意写错,程序也可正常执行,没报错.
三,外联参数映射:
以上二种方式都用paramClass,但此处用parameterMap.
<parameterMap id="parameterMap" class="user">
<parameter property="id" jdbcType="INTEGER" />
<parameter property="name" jdbcType="VARCHAR" />
<parameter property="pass" jdbcType="VARCHAR" />
</parameterMap>
<insert id="insertUser9" parameterMap="parameterMap">
<![CDATA[
INSERT INTO t_user ( ID, NAME, PASS )VALUES( ?,?,? )
]]>
</insert>
若此处的对象不是javabean,而是一个hashMap.用法也一样,只是id,name,pass不是javabean的属性,而是hashMap的key.
String[] ids;
...........
map.put("devId", ids[0]);
map.put("appId", ids[1]);
<!-- 自动参数映射方式 -->
<insert id="DAPermit.addAppDevMapping" parameterClass="java.util.HashMap">
insert into T_Device_App_R_Info(Device_ID,App_ID,Opr) values (#devId#,#appId#,'2');
</insert>
<!--
内联方式:
<insert id="DAPermit.addAppDevMapping" parameterClass="java.util.HashMap">
insert into T_Device_App_R_Info(Device_ID,App_ID,Opr) values (#devId:varchar#,#appId:varchar#,'2');
</insert>
外联方式:
<parameterMap id="dapermitParams" class="java.util.HashMap">
<parameter property="devId" jdbcType="VARCHAR"/>
<parameter property="appId" jdbcType="VARCHAR"/>
</parameterMap>
<insert id="DAPermit.addAppDevMapping" parameterMap="dapermitParams">
insert into T_Device_App_R_Info(Device_ID,App_ID,Opr) values (?,?,'2');
</insert>
-->
四,利用parameterMap调用存储过程:
<!-- example 11: 存储过程 -->
<resultMap id="returnResultMap" class="user">
<result property="id" column="ID" />
</resultMap>
<parameterMap id="paramUser" class="java.util.Map">
<parameter property="name" jdbcType="VARCHAR" javaType="string" mode="IN" />
<parameter property="pass" jdbcType="VARCHAR" javaType="string" mode="IN" />
<parameter property="id" jdbcType="INT" javaType="Integer" mode="INOUT" resultMap="returnResultMap" />
</parameterMap>
<procedure id="pro_insertUser11" parameterMap="paramUser" resultClass="int">
<![CDATA[
{call proc_userinsert(?,?,?)}
]]>
</procedure>
然后在UserDaoTest.java中增加如下一个方法:
public static void example11() throws Exception {
try {
Map map = new HashMap();
map.put("name", "procedure");
map.put("pass", "123456");
Integer returnValue = (Integer)sqlMapClient.insert("pro_insertUser11", map);
System.out.println(returnValue);
} catch (Exception e) {
e.printStackTrace();
}
}
如何用Map类型的对象作为传入参数?
<!--
这里,可以使用全路径类名,如:
java.util.Map
java.util.HashMap
java.util.TreeMap
或
map
-->
<insert id="insertUser" parameterClass="map">
insert into t_user values (
null,#username#,#password#
)
</insert>
Map user = new TreeMap();
user.put("username", "Map用户");
user.put("password", "Map用户密码");
sqlMapper.insert("insertUser",user);
如何将查询结果集的元素转换为Map类型的对象?
<!--
resultClass可以定义为java.util.HashMap类型,
将能自动转换
-->
<select id="selectMapUsers" resultClass="java.util.HashMap">
select * from t_user
</select>
List list = (List)sqlMapper.queryForList("selectMapUsers");
System.out.println(list);
for (Iterator iter = list.iterator(); iter.hasNext();) {
Map map = (Map) iter.next();
//可在此输出map的数据
}