Ibatis+spring整合集成开发【原创】.docx

Ibatis+spring整合集成开发前面的文档学习了ibatis的开发，这节学习ibatis和spring的整合集成开发。1.需要的开发包包括ibatis开发包和spring常用包2.创建POJO实体类，Area.java和Define_industry.javapackage 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) {vince = 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?xmlversion=1.0encoding=UTF-8?!DOCTYPEsqlMapPUBLIC-//iBATIS.com//DTD SQL Map 2.0//EN/dtd/sql-map-2.dtdsqlMapnamespace=AreatypeAliasalias=areatype=com.ibatis.sample.config.Area/selectid=getAreaparameterClass=intresultClass=area![CDATA[select province,area,code,to_char(regdate,yyyy-mm-dd) as regdate from DEFINE_AREA where area_id=#id#]]/selectselectid=getArealistresultClass=area![CDATA[select * from DEFINE_AREA ]]/selectselectid=getArealist1parameterClass=StringresultClass=area![CDATA[select area_id, province,area,code from DEFINE_AREA where area like %||#are#||%]]/selectresultMapid=get_are