ibatis2到mybatis的转变Word格式文档下载.docx
- 文档编号:17825071
- 上传时间:2022-12-11
- 格式:DOCX
- 页数:11
- 大小:20.54KB
ibatis2到mybatis的转变Word格式文档下载.docx
《ibatis2到mybatis的转变Word格式文档下载.docx》由会员分享,可在线阅读,更多相关《ibatis2到mybatis的转变Word格式文档下载.docx(11页珍藏版)》请在冰豆网上搜索。
<
settingname="
x"
value="
foo"
/settings>
and
settingsuseStatementNamespaces="
true"
canberemoved,sincetheuseofnamespaceshasbecomemandatory.
typeAlias>
mustbemovedoutofthe<
sqlMap>
elementto<
typeAliases>
/typeAliases>
/configuration>
...
typeAlias.../>
transactionManager>
and<
dataSource>
transactionManagertype="
JDBC"
commitRequired="
false"
dataSourcetype="
your.package.CustomDataSourceFactory"
/>
/transactionManager>
environmentsdefault="
env"
environmentid="
propertyname="
commitRequired"
/environment>
/environments>
sqlMapresource=.../>
mappers>
mapperresource=.../>
/mappers>
Mapping
∙Therootelement<
mapper>
∙TheattributeparameterClassshouldbechangedtoparameterType
∙TheattributeresultClassshouldbechangedtoresultType
∙Theattributeclassshouldbechangedtotype
∙thecolumnIndexattributedoesnotexistanymoreforthe<
result>
tag
∙ThegroupByattributehasbeeneliminated.HereisanexampleofgroupByfroma2.xsqlMap:
resultMapid="
productRM"
class="
product"
groupBy="
id"
resultproperty="
column="
product_id"
name"
product_name"
category"
product_category"
subProducts"
resultMap="
Products.subProductsRM"
/resultMap>
New:
type="
>
idproperty="
product"
name"
product_name"
category"
product_category"
collectionproperty="
NestedresultMaps
Theseshouldnowbespecifiedusingthe<
association>
tag.
resultMap...>
client"
Client.clientRM"
associationproperty="
parameterMap>
Althoughthistagisdeprecated,itcanbeusedasiniBatis2.Howeverforversionsupto3.0.3thereisabugwhenusingtype="
map"
andnotspecifyingjavaTypeforaparameter.Thiswillresultin
Thereisnogetterforpropertynamed'
...'
in'
interfacejava.util.Map'
ThisshouldbesolvedinMyBatis3.0.4.Forversions3.0.3andearliertheworkaroundistoexplicitlyspecifyjavaType.
Inlineparameters
#value#
#{value}
jdbcTypechanges
jdbcType="
ORACLECURSOR"
CURSOR"
NUMBER"
NUMERIC"
Storedprocedures
∙the<
procedure>
tagdoesn'
texistanymore.Use<
select>
<
insert>
or<
update>
.
procedureid="
getValues"
parameterMap="
getValuesPM"
{?
=callpkgExample.getValues(p_id=>
?
)}
/procedure>
selectid="
statementType="
CALLABLE"
)}
/select>
Ifyou'
recallinganinsertprocedurethatreturnsavalue,youcanuse<
insteadof<
butmakesuretospecifyuseCache="
andflushCache="
.You'
llalsohavetoforceacommit.
∙forstoredproceduresthatreturnacursor,thereisabug(see
issue30
)whenusingnestedresultmaps(i.e.theoutputparameter'
sresultMapcontainsan<
tagwiththeresultMapattribute).Aslongastheissueisnotfixed,youhavetospecifytheresultMapoftheoutputparameteronthestatementitselfaswell,orthenestedresultMapwillnotbepopulated.
Caching
cacheModelid="
myCache"
LRU"
flushIntervalhours="
24"
size"
100"
/cacheModel>
cacheflushInterval="
86400000"
eviction="
Note:
youcanomiteviction="
sinceitisthedefault.
flushOnExecute>
tagisreplacedbytheflushCacheattributeforthestatementsandthecachewillbeusedbyallselectstatementsbydefault.
DynamicSQL
ThemostcommondynamicSQLinmyprojectisisNotNull.Hereisanexamplereplacementregex:
Pattern:
isNotNull.*?
property=\"
(.*?
)\"
/isNotNull>
Replacement:
iftest="
$1!
=null"
/if>
配置文件示例
SqlMapConfig
?
xmlversion="
1.0"
encoding="
UTF-8"
"
cacheEnabled"
lazyLoadingEnabled"
aggressiveLazyLoading"
typeAliasalias="
SyckSmsInfoBean"
type="
com.wtyt.callcenter.order.initOrder.bean.SyckSmsInfoBean"
SyckSmsCarBean"
com.wtyt.callcenter.order.initOrder.bean.SyckSmsCarBean"
GoodsSourceBean"
com.wtyt.callcenter.goods.bean.GoodsSourceBean"
WorkRecordInfoBean"
com.wtyt.callcenter.order.bean.WorkRecordInfoBean"
DriverBean"
com.wtyt.callcenter.ivrRegister.bean.DriverBean"
LogLocateAuthorisedBean"
com.wtyt.callcenter.ivrRegister.bean.LogLocateAuthorisedBean"
OrgDriverRelBean"
com.wtyt.callcenter.ivrRegister.bean.OrgDriverRelBean"
OrgnizationBean"
com.wtyt.callcenter.ivrRegister.bean.OrgnizationBean"
callcenter_cim"
POOLED"
driver"
oracle.jdbc.OracleDriver"
url"
jdbc:
oracle:
thin:
@192.168.1.248:
1521:
TSH1"
username"
cim3"
password"
oracle"
/dataSource>
mapperresource="
com/wtyt/callcenter/order/order-sql-map.xml"
com/wtyt/callcenter/ivrRegister/register-driver-sql.xml"
Mapper
-//mybatis.org//DTDMapper"
mappernamespace="
com.wtyt.callcenter.order.initOrder.InitCallcenterFromCimDao"
goodsBeanMap"
<
orgName"
ORG_NAME"
javaType="
string"
orgId"
ORG_ID"
int"
contectPeople"
CONTACT_PERSON"
javaType="
contectPhone"
TEL_NO"
contectMobileNo"
MOBILE_NO"
userId"
USER_ID"
userType"
USER_TYPE"
loginName"
LOGIN_NAME"
area"
AREA"
mainArea"
MAIN_AREA"
SyckSmsInfoMap"
agentId"
AGENT_ID"
goodsName"
GOODS_TYPE"
carModel"
SMS_CART_TYPE"
length"
SMS_CART_LENGTH"
weight"
SMS_CART_TONNAGE"
width"
SMS_CART_VOLUME"
loadGoodsAddress"
START_CITY_AREA"
dischargeGoodsAddress"
END_CITY_AREA"
smsNote"
CONTENT"
goodsBean"
SYCK_SMS_LIST_ID"
resultMap="
cartBeanList"
java.util.ArrayList"
ofType="
cartBeanMap"
phone"
DRIVER_MOBILE_NO"
freightState"
FREIGHT_STATE"
curPosition"
CUR_POSOTION"
driverName"
REALNAME"
idCard"
ID_CARD"
address"
ADDRESS"
ownerName"
OWNER_NAME"
ownerPhone"
MOBILE_NO_2"
license"
CART_BADGE_NO"
cartModel"
CART_TYPE"
cartLength"
CART_LENGTH"
cartWidth"
CART_WIDTH"
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- ibatis2 mybatis 转变