Ibatis+spring整合集成开发【原创】
- 格式：docx
- 大小：76.29 KB
- 文档页数：15
Ibatis+spring整合集成开发 前面的文档学习了ibatis的开发，这节学习ibatis和spring的整合集成开发。 1.需要的开发包包括ibatis开发包和spring常用包
2.创建POJO实体类，Area.java和Define_industry.java package com.ibatis.sample.config; import java.io.Serializable; publicclassAreaimplements Serializable{ privateintarea_id; private String province; private String area; private String code; private String regdate; publicint getArea_id() { returnarea_id; } publicvoid setArea_id(int areaId) { area_id = areaId; } public String getProvince() { returnprovince; } publicvoid setProvince(String province) { this.province = province; } public String getArea() { returnarea; } publicvoid setArea(String area) { this.area = area; } public String getCode() { returncode; } publicvoid setCode(String code) { this.code = code; } public String getRegdate() { returnregdate; } publicvoid setRegdate(String regdate) { this.regdate = regdate; } }
package com.ibatis.sample.config; import java.io.Serializable; publicclassDefine_industryimplements Serializable{ privateintindustry_id; private String title; public Define_industry(){}; public Define_industry(String title){ this.title = title; } public Define_industry(int industry_id,String title){ this.industry_id=industry_id; this.title=title; } publicint getIndustry_id() { returnindustry_id; } publicvoid setIndustry_id(int industryId) { industry_id = industryId; } public String getTitle() { returntitle; } publicvoid setTitle(String title) { this.title = title; } }
3.创建Ibatis映射文件Area.xml和Industry.xml "http://www.ibatis.com/dtd/sql-map-2.dtd"> select province,area,code,to_char(regdate,'yyyy-mm-dd') as regdate from DEFINE_AREA where area_id=#id# ]]> select * from DEFINE_AREA ]]> > select area_id, province,area,code from DEFINE_AREA where area like '%'||#are#||'%' ]]>
e="int"/>
ring"/>
result"> select area_id, province,area,code from DEFINE_AREA area like '%'||#area#||'%'
"http://www.ibatis.com/dtd/sql-map-2.dtd"> ndustry"/> "/>
select seq_define_industry.nextval from dual ]]>
keyProperty="industry_id"> select seq_define_industry.nextval from dual insert into DEFINE_INDUSTRY(industry_id,title) values(#industry_id#,#title#)
update DEFINE_INDUSTRY set title=#title# where industry_id=#industry_id#
delete from DEFINE_INDUSTRY where industry_id=#industry_id#
ng"mode="IN"/> ing"mode="IN"/> ng.Integer"mode="OUT"/> lang.String"mode="OUT"/>
