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

Ibatis+spring整合集成开发

前面的文档学习了ibatis的开发，这节学习ibatis和spring的整合集成开发。

1.需要的开发包包括ibatis开发包和spring常用包

2.创建POJO实体类，Area.java和Define_industry.java

package com.ibatis.sample.config;

import java.io.Serializable;

public class Area implements Serializable{

private 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) {

this.province = 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 Serializable{

private 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.xml

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN"

"http://www.ibatis.com/dtd/sql-map-2.dtd">

<![CDATA[

select province,area,code,to_char(regdate,'yyyy-mm-dd') as regdate from DEFINE_AREA where area_id=#id#

]]>

</select>

<![CDATA[

select * from DEFINE_AREA

]]>

</select>

<![CDATA[

select area_id, province,area,code from DEFINE_AREA where area like '%'||#are#||'%'

]]>

</select>

</resultMap>

select area_id, province,area,code from DEFINE_AREA

area like '%'||#area#||'%'

</isNotEmpty>

</dynamic>

</select>

</sqlMap>

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN"

"http://www.ibatis.com/dtd/sql-map-2.dtd">

<![CDATA[

select seq_define_industry.nextval from dual

]]>

</select>

select seq_define_industry.nextval from dual

</selectKey>

insert into DEFINE_INDUSTRY(industry_id,title) values(#industry_id#,#title#)

</insert>

update DEFINE_INDUSTRY set title=#title# where industry_id=#industry_id#

</update>

delete from DEFINE_INDUSTRY where industry_id=#industry_id#

</delete>

</parameterMap>

<![CDATA[{ call procedure_ecsystem_login(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) }]]>

</procedure>

</sqlMap>

4.Ibatis整合spring以后，ibatis中的数据库连接配置不再存在，而是到spring的配置文件中进行配置。Ibatis的配置文件SqlMapConfig.xml如下：

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE sqlMapConfig

PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN"

"http://ibatis.apache.org/dtd/sql-map-config-2.dtd">

<settings

cacheModelsEnabled="true"

enhancementEnabled="true"

lazyLoadingEnabled="true"

errorTracingEnabled="true"

maxRequests="32"

maxSessions="10"

maxTransactions="5"

useStatementNamespaces="false"

</sqlMapConfig>

4.Spring 的配置文件applicationContext.xml

<?xml version="1.0" encoding="UTF-8"?>

<beans

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/beans http://www.springframework.org/schema/beans/spring-beans-2.0.xsd">

<list>

<value>classpath:com/ibatis/sample/config/db.properties</value>

</list>

</property>

</bean>

</bean>

<value>classpath:com/ibatis/sample/config/SqlMapConfig.xml</value>

</property>

</bean>

<!-- 使用SqlMapClientDaoSupport提供的SqlMapClientTemplate对象来操纵数据库，

继承SqlMapClientDaoSupport，要求我们注入SqlMapClient对象 ,sqlMapClient从datasource获取数据库连接-->

</bean>

</beans>

5.DAO接口和实现类TestDao.java和TestDaoImpl.java

package 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 stub

ApplicationContext 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的controller

<?xml version="1.0" encoding="UTF-8"?>

<beans

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/beans http://www.springframework.org/schema/beans/spring-beans-2.0.xsd">

<list>

<value>classpath:com/ibatis/sample/config/db.properties</value>

</list>

</property>

</bean>

</bean>

<bean id="transactionManager"

class="org.springframework.jdbc.datasource.DataSourceTransactionManager">

</bean>

<bean id="txProxyTemplate" abstract="true"

class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean">

</property>

<props>

<prop key="insert*">PROPAGATION_REQUIRED</prop>

<prop key="save*">PROPAGATION_REQUIRED</prop>

<prop key="update*">PROPAGATION_REQUIRED</prop>

<prop key="delete*">PROPAGATION_REQUIRED</prop>

<prop key="*">PROPAGATION_REQUIRED,readOnly</prop>

</props>

</property>

</bean>

<value>classpath:com/ibatis/sample/config/SqlMapConfig.xml</value>

</property>

</bean>

<props>

<prop key="/test.do">TestController</prop>

</props>

</property>

</bean>

</bean>

<!-- 使用SqlMapClientDaoSupport提供的SqlMapClientTemplate对象来操纵数据库，

继承SqlMapClientDaoSupport，要求我们注入SqlMapClient对象 ,sqlMapClient从datasource获取数据库连接-->

</bean>

</bean>

</bean>

</beans>

修改web.xml，使自动加载spring的配置文件applicationContext.xml

<?xml version="1.0" encoding="UTF-8"?>

<web-app version="2.5"

xmlns="http://java.sun.com/xml/ns/javaee"

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xsi:schemaLocation="http://java.sun.com/xml/ns/javaee

http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd">

<servlet-name>testSystemSpring</servlet-name>

<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>

<init-param>

<param-name>contextConfigLocation</param-name>

<param-value>/WEB-INF/applicationContext.xml</param-value>

</init-param>

<load-on-startup>1</load-on-startup>

</servlet>

<welcome-file-list>

<welcome-file>index.jsp</welcome-file>

</welcome-file-list>

</web-app>

TestController.java

package 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 Controller{

private 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 stub

Area 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.java

package 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.ibatis.sample.config.Define_industry;

public class TestlogicImpl implements Testlogic {

private TestDao testDao;

public TestDao getTestDao() {

return testDao;

}

public void setTestDao(TestDao testDao) {

this.testDao = testDao;

}

public Area getarea_byid(int id){

return testDao.getarea_byid(id);

}

public List getArealist1(String name){

return testDao.getArealist1(name);

}

public void updateIndustry(Define_industry industry){

testDao.updateIndustry(industry);

}

public void insertIndustry(List vlist){

for(int i=0 ; i<vlist.size() ;i++){

if(i>2){

System.out.println("列表太长，中断事务");

throw new RuntimeException("中断事务异常,当列表长度大于3的时候故意抛出，看看事务是否回滚");

}

Define_industry industry = (Define_industry)vlist.get(i);

testDao.insertIndustry(industry);

}

启动tomcat，访问http://ip:port/test/test.do,访问项目

posted on 2014-01-09 11:38 kelly 阅读(285) 评论(0) 编辑收藏所属分类: java 框架

常用链接

留言簿(4)

随笔分类(66)

随笔档案(72)

文章档案(19)

收藏夹

搜索

最新评论

阅读排行榜

评论排行榜


只有注册用户登录后才能发表评论。




网站导航: 博客园 IT新闻 Chat2DB C++博客博问管理
相关文章: Struts2整合Spring从xml到注解 Spring注解讲解 Struts2.3+Spring3.2的整合 No configuration found for the specified action 简单Struts2实例(入门级)-转 Struts2基于注解的Action配置 Struts2教程1：第一个Struts2程序 -转 Ibatis+spring整合集成开发-【原创】 struts2底层中如何将表单值传入Action OGNL表达式struts2标签“%，#，$”