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;public class Area implements Serializableprivate int area_id;private String province;private String area;private String code;private String regdate;public int getArea_id() return area_id;public void setArea_id(int areaId) area_id = areaId;public String getProvince() return province;public void setProvince(String province) vince = province;public String getArea() return area;public void setArea(String area) this.area = area;public String getCode() return code;public void setCode(String code) this.code = code;public String getRegdate() return regdate;public void setRegdate(String regdate) this.regdate = regdate;package com.ibatis.sample.config;import java.io.Serializable;public class Define_industry implements Serializableprivate int industry_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;public int getIndustry_id() return industry_id;public void setIndustry_id(int industryId) industry_id = industryId;public String getTitle() return title;public void setTitle(String title) this.title = title;3.创建Ibatis映射文件Area.xml和Industry.xmlselect area_id, province,area,code from DEFINE_AREA area like %|#area#|% !- 元素的子元素 来支持主键自动生成,并把值写入相应的keyproperty对应的字段中- 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# 4.Ibatis整合spring以后，ibatis中的数据库连接配置不再存在，而是到spring的配置文件中进行配置。Ibatis的配置文件SqlMapConfig.xml如下： 4.Spring 的配置文件applicationContext.xmlclasspath:com/ibatis/sample/config/perties classpath:com/ibatis/sample/config/SqlMapConfig.xml 5.DAO接口和实现类TestDao.java和TestDaoImpl.javapackage com.logic;import java.util.ArrayList;import java.util.List;import com.ibatis.sample.config.Area;import com.ibatis.sample.config.Define_industry;public interface TestDao public Area getarea_byid(int id);public List getArealist1(String name);public void updateIndustry(Define_industry industry);public void insertIndustry(Define_industry industry);package com.logic;import java.util.ArrayList;import java.util.List;import org.springframework.orm.ibatis.support.SqlMapClientDaoSupport;import com.ibatis.sample.config.Area;import com.ibatis.sample.config.Define_industry;public class TestDaoImpl extends SqlMapClientDaoSupport implements TestDao public Area getarea_byid(int id) return (Area)getSqlMapClientTemplate().queryForObject(getArea,id);public List getArealist1(String name)return getSqlMapClientTemplate().queryForList(getArealist1,name);public void updateIndustry(Define_industry industry)getSqlMapClientTemplate().update(updateIndustry, industry);public void insertIndustry(Define_industry industry)getSqlMapClientTemplate().insert(insertIndustry, industry);6.测试类package com.logic;import java.util.List;import org.springframework.context.ApplicationContext;import org.springframework.context.support.ClassPathXmlApplicationContext;import org.springframework.context.support.FileSystemXmlApplicationContext;import com.ibatis.sample.config.Area;import com.ibatis.sample.config.Define_industry;public class Test public static void main(String args) / TODO Auto-generated method stubApplicationContext context = new FileSystemXmlApplicationContext(WebRoot/WEB-INF/applicationContext.xml);TestDao testimpl=(TestDao)context.getBean(testDao);Area area=testimpl.getarea_byid(5);System.out.println(area.getArea();System.out.println(area.getProvince();System.out.println(area.getRegdate();List list1=testimpl.getArealist1(南);for (int i = 0; i list1.size(); i+) Area area1=(Area)list1.get(i);System.out.println(area1.getArea_id()+-+area1.getArea();7、以下加入页面操作和事务处理修改spring的配置文件，加入事务代理和spring的controllerclasspath:com/ibatis/sample/config/perties PROPAGATION_REQUIRED PROPAGATION_REQUIRED PROPAGATION_REQUIRED PROPAGATION_REQUIRED PROPAGATION_REQUIRED,readOnly classpath:com/ibatis/sample/config/SqlMapConfig.xml TestController 修改web.xml，使自动加载spring的配置文件applicationContext.xml testSystemSpringorg.springframework.web.servlet.DispatcherServletcontextConfigLocation/WEB-INF/applicationContext.xml1 index.jsp TestController.javapackage com.controller;import java.util.ArrayList;import java.util.List;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import org.springframework.web.servlet.ModelAndView;import org.springframework.web.servlet.mvc.Controller;import com.ibatis.sample.config.Area;import com.ibatis.sample.config.Define_industry;import com.logic.Testlogic;public class TestController implements Controllerprivate Testlogic testlogic;public Testlogic getTestlogic() return testlogic;public void setTestlogic(Testlogic testlogic) this.testlogic = testlogic;/* (non-Javadoc) * see org.springframework.web.servlet.mvc.Controller#handleRequest(javax.servlet.http.HttpServletRequest, javax.servlet.http.HttpServletResponse) */public ModelAndView handleRequest(HttpServletRequest arg0,HttpServletResponse arg1) throws Exception / TODO Auto-generated method stubArea area=testlogic.getarea_byid(7);System.out.println(area.getArea();System.out.println(area.getProvince();System.out.println(area.getRegdate();List list1=testlogic.getArealist1(南);for (int i = 0; i list1.size(); i+) Area area1=(Area)list1.get(i);System.out.println(area1.getArea_id()+-+area1.getArea();Define_industry industry=new Define_industry(10,其它1);testlogic.updateIndustry(industry);List industrylist = new ArrayList();industrylist.add(new Define_industry(test_1);industrylist.add(new Define_industry(test_2);industrylist.add(new Define_industry(test_3);industrylist.add(new Define_industry(test_4);testlogic.insertIndustry(industrylist);return null;Testlogic.java和TestlogicImpl.javapackage com.logic;import java.util.List;import com.ibatis.sample.config.Area;import com.ibatis.sample.config.Define_industry;public interface Testlogic public Area getarea_byid(int id);public List getArealist1(String name);public void updateIndustry(Define_industry industry);public void insertArea(List vlist);package com.logic;import java.util.List;import com.ibatis.sample.config.Area;import com.ib