关于iBatis分模块的配置,以及一点其他的疑问,基于JPetStore讨论

最新推荐文章于 2019-06-16 13:09:08 发布

最新推荐文章于 2019-06-16 13:09:08 发布 · 126 阅读

标签

#iBATIS #配置管理 #DAO #Spring #框架

本文通过JPetStore 5.0示例介绍iBatis的SQL配置方式，重点讲解了如何通过配置文件指定SQL语句及参数映射，并探讨了iBatis如何处理SQL查询结果映射到对象的问题。

简单起见,拿JPetStore5.0来举例吧.

在配置文件sql-map-config.xml中,他是这么写的
[code]
<sqlMap resource="com/ibatis/jpetstore/persistence/sqlmapdao/sql/Account.xml"/>
<sqlMap resource="com/ibatis/jpetstore/persistence/sqlmapdao/sql/Category.xml"/>
<sqlMap resource="com/ibatis/jpetstore/persistence/sqlmapdao/sql/Product.xml"/>
<sqlMap resource="com/ibatis/jpetstore/persistence/sqlmapdao/sql/Sequence.xml"/>
<sqlMap resource="com/ibatis/jpetstore/persistence/sqlmapdao/sql/LineItem.xml"/>
<sqlMap resource="com/ibatis/jpetstore/persistence/sqlmapdao/sql/Order.xml"/>
<sqlMap resource="com/ibatis/jpetstore/persistence/sqlmapdao/sql/Item.xml"/>
[/code]

其他是transactionManager的配置就不管了.

这里的Account.xml是不是就是分模块的配置文件?我猜想应该是的吧

再问问Account.xml里面的一些东西
[code]
<select id="getAccountByUsername" resultClass="account" parameterClass="string">
SELECT
SIGNON.USERNAME,
ACCOUNT.EMAIL,
ACCOUNT.FIRSTNAME,
ACCOUNT.LASTNAME,
ACCOUNT.STATUS,
ACCOUNT.ADDR1 AS address1,
ACCOUNT.ADDR2 AS address2,
ACCOUNT.CITY,
ACCOUNT.STATE,
ACCOUNT.ZIP,
ACCOUNT.COUNTRY,
ACCOUNT.PHONE,
PROFILE.LANGPREF AS languagePreference,
PROFILE.FAVCATEGORY AS favouriteCategoryId,
PROFILE.MYLISTOPT AS listOption,
PROFILE.BANNEROPT AS bannerOption,
BANNERDATA.BANNERNAME
FROM ACCOUNT, PROFILE, SIGNON, BANNERDATA
WHERE ACCOUNT.USERID = #username#
AND SIGNON.USERNAME = ACCOUNT.USERID
AND PROFILE.USERID = ACCOUNT.USERID
AND PROFILE.FAVCATEGORY = BANNERDATA.FAVCATEGORY
</select>
[/code]

我知道iBatis并没有hibernate那样,显示的对应column和field的对应关系.
就拿上面的select语句来说, iBatis怎么知道, SIGNON.USERNAME 这个东西对应哪个字段呢?