Ibatis+spring整合集成开发原创.docx
- 文档编号:24137015
- 上传时间:2023-05-24
- 格式:DOCX
- 页数:22
- 大小:39.20KB
Ibatis+spring整合集成开发原创.docx
《Ibatis+spring整合集成开发原创.docx》由会员分享,可在线阅读,更多相关《Ibatis+spring整合集成开发原创.docx(22页珍藏版)》请在冰豆网上搜索。
Ibatis+spring整合集成开发原创
Ibatis+spring整合集成开发
前面的文档学习了ibatis的开发,这节学习ibatis和spring的整合集成开发。
1.需要的开发包包括ibatis开发包和spring常用包
2.创建POJO实体类,Area.java和Define_industry.java
packagecom.ibatis.sample.config;
importjava.io.Serializable;
publicclassAreaimplementsSerializable{
privateintarea_id;
privateStringprovince;
privateStringarea;
privateStringcode;
privateStringregdate;
publicintgetArea_id(){
returnarea_id;
}
publicvoidsetArea_id(intareaId){
area_id=areaId;
}
publicStringgetProvince(){
returnprovince;
}
publicvoidsetProvince(Stringprovince){
this.province=province;
}
publicStringgetArea(){
returnarea;
}
publicvoidsetArea(Stringarea){
this.area=area;
}
publicStringgetCode(){
returncode;
}
publicvoidsetCode(Stringcode){
this.code=code;
}
publicStringgetRegdate(){
returnregdate;
}
publicvoidsetRegdate(Stringregdate){
this.regdate=regdate;
}
}
packagecom.ibatis.sample.config;
importjava.io.Serializable;
publicclassDefine_industryimplementsSerializable{
privateintindustry_id;
privateStringtitle;
publicDefine_industry(){};
publicDefine_industry(Stringtitle){
this.title=title;
}
publicDefine_industry(intindustry_id,Stringtitle){
this.industry_id=industry_id;
this.title=title;
}
publicintgetIndustry_id(){
returnindustry_id;
}
publicvoidsetIndustry_id(intindustryId){
industry_id=industryId;
}
publicStringgetTitle(){
returntitle;
}
publicvoidsetTitle(Stringtitle){
this.title=title;
}
}
3.创建Ibatis映射文件Area.xml和Industry.xml
xmlversion="1.0"encoding="UTF-8"?
>
DOCTYPEsqlMapPUBLIC"-//iBATIS.com//DTDSQLMap2.0//EN"
"
[CDATA[
selectprovince,area,code,to_char(regdate,'yyyy-mm-dd')asregdatefromDEFINE_AREAwherearea_id=#id#
]]>
[CDATA[
select*fromDEFINE_AREA
]]>
[CDATA[
selectarea_id,province,area,codefromDEFINE_AREAwherearealike'%'||#are#||'%'
]]>
selectarea_id,province,area,codefromDEFINE_AREA
arealike'%'||#area#||'%'
xmlversion="1.0"encoding="UTF-8"?
>
DOCTYPEsqlMapPUBLIC"-//iBATIS.com//DTDSQLMap2.0//EN"
"
[CDATA[
selectseq_define_industry.nextvalfromdual
]]>
--
selectseq_define_industry.nextvalfromdual
insertintoDEFINE_INDUSTRY(industry_id,title)values(#industry_id#,#title#)
updateDEFINE_INDUSTRYsettitle=#title#whereindustry_id=#industry_id#
deletefromDEFINE_INDUSTRYwhereindustry_id=#industry_id#
[CDATA[{callprocedure_ecsystem_login(?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
)}]]>
4.Ibatis整合spring以后,ibatis中的数据库连接配置不再存在,而是到spring的配置文件中进行配置。
Ibatis的配置文件SqlMapConfig.xml如下:
xmlversion="1.0"encoding="UTF-8"?
>
DOCTYPEsqlMapConfig
PUBLIC"-//ibatis.apache.org//DTDSQLMapConfig2.0//EN"
"http:
//ibatis.apache.org/dtd/sql-map-config-2.dtd">
cacheModelsEnabled="true" enhancementEnabled="true" lazyLoadingEnabled="true" errorTracingEnabled="true" maxRequests="32" maxSessions="10" maxTransactions="5" useStatementNamespaces="false" /> 4.Spring的配置文件applicationContext.xml xmlversion="1.0"encoding="UTF-8"? > xmlns="http: //www.springframework.org/schema/beans" xmlns: xsi="http: //www.w3.org/2001/XMLSchema-instance" xmlns: p="http: //www.springframework.org/schema/p" xsi: schemaLocation="http: //www.springframework.org/schema/beanshttp: //www.springframework.org/schema/beans/spring-beans-2.0.xsd"> --通用属性文件定义--> com/ibatis/sample/config/db.properties --数据源配置--> --同一时间可以从池分配的最多连接数量设置为0时表示无限制--> --超时等待时间以毫秒为单位--> --池里不会被释放的最多空闲连接数量设置为0时表示无限制--> --设置自动回收超时连接--> --自动回收超时时间(以秒数为单位)--> --Spring提供的iBatis的SqlMap配置--> com/ibatis/sample/config/SqlMapConfig.xml --使用SqlMapClientDaoSupport提供的SqlMapClientTemplate对象来操纵数据库, 继承SqlMapClientDaoSupport,要求我们注入SqlMapClient对象,sqlMapClient从datasource获取数据库连接--> 5.DAO接口和实现类TestDao.java和TestDaoImpl.java packagecom.logic; importjava.util.ArrayList; importjava.util.List; importcom.ibatis.sample.config.Area; importcom.ibatis.sample.config.Define_industry; publicinterfaceTestDao{ publicAreagetarea_byid(intid); publicListgetArealist1(Stringname); publicvoidupdateIndustry(Define_industryindustry); publicvoidinsertIndustry(Define_industryindustry); } packagecom.logic; importjava.util.ArrayList; importjava.util.List; importorg.springframework.orm.ibatis.support.SqlMapClientDaoSupport; importcom.ibatis.sample.config.Area; importcom.ibatis.sample.config.Define_industry; publicclassTestDaoImplextendsSqlMapClientDaoSupportimplementsTestDao{ publicAreagetarea_byid(intid){ return(Area)getSqlMapClientTemplate().queryForObject("getArea",id); } publicListgetArealist1(Stringname){ returngetSqlMapClientTemplate().queryForList("getArealist1",name); } publicvoidupdateIndustry(Define_industryindustry){ getSqlMapClientTemplate().update("updateIndustry",industry); } publicvoidinsertIndustry(Define_industryindustry){ getSqlMapClientTemplate().insert("insertIndustry",industry); } } 6.测试类 packagecom.logic; importjava.util.List; importorg.springframework.context.ApplicationContext; importorg.springframework.context.support.ClassPathXmlApplicationContext; importorg.springframework.context.support.FileSystemXmlApplicationContext; importcom.ibatis.sample.config.Area; importcom.ibatis.sample.config.Define_industry; publicclassTest{ publicstaticvoidmain(String[]args){ //TODOAuto-generatedmethodstub ApplicationContextcontext=newFileSystemXmlApplicationContext("WebRoot/WE
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- Ibatis spring 整合 集成 开发 原创