spring mvc mybatis

petrel919 · 发表于 2016-11-25 01:13:17

开发环境：
　　System：Windows
　　WebBrowser：IE6+、Firefox3+
　　JavaEE Server：tomcat5.0.2.8、tomcat6
　　IDE：eclipse、MyEclipse 8
　　Database：MySQL
　　开发依赖库：
　　JavaEE5、Spring 3.0.5、Mybatis 3.0.4、myBatis-spring-1.0、junit4.8.2
　　Email：hoojo_@126.com
　　Blog：http://blog.csdn.net/IBM_hoojo
　　http://hoojo.cnblogs.com/
　　1、首先新建一个WebProject 命名为MyBatisForSpring，新建项目时，使用JavaEE5的lib库。然后手动添加需要的jar包，所需jar包如下：

2、添加spring的监听及springMVC的核心Servlet，web.xml内容，内容如下：

<-- 加载Spring容器配置 -->

<listener>

<listener-class>org.springframework.web.context.ContextLoaderListenerlistener-class>

listener>



<-- 设置Spring容器加载配置文件路径 -->

<context-param>

<param-name>contextConfigLocationparam-name>

<param-value>classpath*:applicationContext-*.xmlparam-value>

context-param>



<-- 配置Spring核心控制器 -->

<servlet>

<servlet-name>dispatcherservlet-name>

<servlet-class>org.springframework.web.servlet.DispatcherServletservlet-class>

<init-param>

      <param-name>contextConfigLocationparam-name>

      <param-value>/WEB-INF/dispatcher.xmlparam-value>

init-param>

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

servlet>



<servlet-mapping>

<servlet-name>dispatcherservlet-name>

<url-pattern>*.dourl-pattern>

servlet-mapping>



<-- 解决工程编码过滤器 -->

<filter>

<filter-name>characterEncodingFilterfilter-name>

<filter-class>org.springframework.web.filter.CharacterEncodingFilterfilter-class>

<init-param>

      <param-name>encodingparam-name>

      <param-value>UTF-8param-value>

init-param>

filter>



<filter-mapping>

<filter-name>characterEncodingFilterfilter-name>

<url-pattern>/*url-pattern>

filter-mapping>


　　3、在WEB-INF目录中添加dispatcher.xml，内容如下：

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

<beans xmlns="http://www.springframework.org/schema/beans"

xmlns:context="http://www.springframework.org/schema/context"

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

xsi:schemaLocation="http://www.springframework.org/schema/beans

http://www.springframework.org/schema/beans/spring-beans-3.0.xsd

http://www.springframework.org/schema/context

http://www.springframework.org/schema/context/spring-context-3.0.xsd">

<-- 注解探测器 -->

<context:component-scan base-package="com.hoo"/>



<--  annotation默认的方法映射适配器 -->

<bean id="handlerMapping" class="org.springframework.web.servlet.mvc.annotation.DefaultAnnotationHandlerMapping" />



<bean id="handlerAdapter" class="org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter" />

beans>


　　4、在src目录下添加applicationContext-common.xml，内容如下：

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

<beans xmlns="http://www.springframework.org/schema/beans"

xmlns:aop="http://www.springframework.org/schema/aop"

xmlns:tx="http://www.springframework.org/schema/tx"

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

xsi:schemaLocation="http://www.springframework.org/schema/beans

http://www.springframework.org/schema/beans/spring-beans-3.0.xsd

http://www.springframework.org/schema/aop

http://www.springframework.org/schema/aop/spring-aop-3.0.xsd

http://www.springframework.org/schema/tx

http://www.springframework.org/schema/tx/spring-tx-3.0.xsd ">



<-- 配置DataSource数据源 -->

<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">

      <property name="driverClassName" value="com.mysql.jdbc.Driver"/>

      <property name="url" value="jdbc:mysql://10.0.0.131:3306/ash2"/>

      <property name="username" value="dev"/>

      <property name="password" value="dev"/>

bean>



<-- 配置SqlSessionFactoryBean -->

<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">

      <property name="dataSource" ref="dataSource"/>

      <property name="configLocation" value="classpath:mybatis.xml"/>

      <-- mapper和resultmap配置路径 -->

      <property name="mapperLocations">

         <list>

            <-- 表示在com.hoo.resultmap包或以下所有目录中，以-resultmap.xml结尾所有文件 -->

            <value>classpath:com/hoo/resultmap/**/*-resultmap.xmlvalue>

            <value>classpath:com/hoo/entity/*-resultmap.xmlvalue>

            <value>classpath:com/hoo/mapper/**/*-mapper.xmlvalue>

         list>

      property>

bean>



<-- 单独配置一个Mapper；这种模式就是得给每个mapper接口配置一个bean -->

<--

<bean id="accountMapper" class="org.mybatis.spring.mapper.MapperFactoryBean">

      <property name="mapperInterface" value="com.hoo.mapper.AccountMapper" />

      <property name="sqlSessionFactory" ref="sqlSessionFactory" />

bean>



<bean id="companyMapper" class="org.mybatis.spring.mapper.MapperFactoryBean">

      <property name="mapperInterface" value="com.hoo.mapper.CompanyMapper" />

      <property name="sqlSessionFactory" ref="sqlSessionFactory" />

bean>

   -->



<-- 通过扫描的模式，扫描目录在com/hoo/mapper目录下，所有的mapper都继承SqlMapper接口的接口，这样一个bean就可以了 -->

<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">

      <property name="basePackage" value="com.hoo.mapper"/>

      <property name="markerInterface" value="com.hoo.mapper.SqlMapper"/>

bean>

beans>


　　上面的配置最先配置的是DataSource，这里采用的是jdbc的DataSource；
　　然后是SqlSessionFactoryBean，这个配置比较关键。SqlSessionFactoryBean需要注入DataSource数据源，其次还要设置configLocation也就是mybatis的xml配置文件路径，完成一些关于mybatis的配置，如settings、mappers、plugin等；
　　如果使用mapperCannerConfigurer模式，需要设置扫描根路径也就是你的mybatis的mapper接口所在包路径；凡是markerInterface这个接口的子接口都参与到这个扫描，也就是说所有的mapper接口继承这个SqlMapper。
　　如果你不使用自己的transaction事务，就使用MapperScannerConfigurer来完成SqlSession的打开、关闭和事务的回滚操作。在此期间，出现数据库操作的如何异常都会被转换成DataAccessException，这个异常是一个抽象的类，继承RuntimeException；
　　5、 SqlMapper内容如下：

package com.hoo.mapper;



/**

* function:所有的Mapper继承这个接口

* @author hoojo

* @createDate 2011-4-12 下午04:00:31

* @file SqlMapper.java

* @package com.hoo.mapper

* @project MyBatisForSpring

* @blog http://blog.csdn.net/IBM_hoojo

* @email hoojo_@126.com

* @version 1.0

*/

public interface SqlMapper {



}


　　6、实体类和ResultMap.xml

package com.hoo.entity;



import java.io.Serializable;

import javax.persistence.Entity;



@Entity

public class Account implements Serializable {



private static final long serialVersionUID = -7970848646314840509L;



private Integer accountId;

private Integer status;

private String username;

private String password;

private String salt;

private String email;

private Integer roleId;



//getter、setter



@Override

public String toString() {

      return this.accountId + "#" + this.status + "#" + this.username +  "#" +

         this.password +  "#" + this.email +  "#" + this.salt + "#" + this.roleId;

}

}


　　account-resultmap.xml

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

DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"

"http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<mapper namespace="accountMap">

<resultMap type="com.hoo.entity.Account" id="accountResultMap">

      <id property="accountId" column="account_id"/>

      <result property="username" column="username"/>

      <result property="password" column="password"/>

      <result property="status" column="status"/>

resultMap>

mapper>


　　7、在src目录中添加applicationContext-beans.xml内容如下：

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

<beans xmlns="http://www.springframework.org/schema/beans"

xmlns:context="http://www.springframework.org/schema/context"

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

xsi:schemaLocation="http://www.springframework.org/schema/beans

http://www.springframework.org/schema/beans/spring-beans-3.0.xsd

http://www.springframework.org/schema/context

http://www.springframework.org/schema/context/spring-context-3.0.xsd">

<-- 注解探测器，在JUnit测试的时候需要-->

<context:component-scan base-package="com.hoo"/>



beans>


　　这里配置bean对象，一些不能用annotation注解的对象就可以配置在这里
　　8、在src目录中添加mybatis.xml，内容如下：

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

DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd">

<configuration>

<-- 别名 -->

<typeAliases>

      <typeAlias type="com.hoo.entity.Account" alias="account"/>

typeAliases>

configuration>


　　在这个文件放置一些全局性的配置，如handler、objectFactory、plugin、以及mappers的映射路径（由于在applicationContext-common中的SqlSessionFactoryBean有配置mapper的location，这里就不需要配置）等
　　9、 AccountMapper接口，内容如下：

package com.hoo.mapper;



import java.util.List;

import org.apache.ibatis.annotations.Select;

import com.hoo.entity.Account;



/**

* function:继承SqlMapper，MyBatis数据操作接口；此接口无需实现类

* @author hoojo

* @createDate 2010-12-21 下午05:21:20

* @file AccountMapper.java

* @package com.hoo.mapper

* @project MyBatis

* @blog http://blog.csdn.net/IBM_hoojo

* @email hoojo_@126.com

* @version 1.0

*/

public interface AccountMapper extends SqlMapper {



public List getAllAccount();



public Account getAccount();



public Account getAccountById(String id);



public Account getAccountByNames(String spring);



@Select("select * from account where username = #{name}")

public Account getAccountByName(String name);



public void addAccount(Account account);



public void editAccount(Account account);



public void removeAccount(int id);

}


　　这个接口我们不需要实现，由mybatis帮助我们实现，我们通过mapper文件配置sql语句即可完成接口的实现。然后这个接口需要继承SqlMapper接口，不然在其他地方就不能从Spring容器中拿到这个mapper接口，也就是说当我们注入这个接口的时候将会失败。
　　当然，你不继承这个接口也可以。那就是你需要给买个mapper配置一个bean。配置方法如下：

<bean id="accountMapper" class="org.mybatis.spring.mapper.MapperFactoryBean">

<property name="mapperInterface" value="com.hoo.mapper.AccountMapper" />

<property name="sqlSessionFactory" ref="sqlSessionFactory" />

bean>


　　这里的MapperFactoryBean可以帮助我们完成Session的打开、关闭等操作
　　10、在com.hoo.mapper也就是在AccountMapper接口的同一个包下，添加account-mapper.xml，内容如下：

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

DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"

"http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<-- namespace和定义的Mapper接口对应，并实现其中的方法 -->

<mapper namespace="com.hoo.mapper.AccountMapper">

<-- id和mapper接口中的方法名对应，resultType使用mybatis.xml中的别名 -->

<select id="getAccount" resultType="account">

      [CDATA[

         select * from account limit 1

      ]]>

select>



<select id="getAllAccount" resultType="list" resultMap="accountResultMap">

      [CDATA[

         select * from account

      ]]>

select>



<-- accountResultMap是account-resultmap.xml中定义的resultmap -->

<select id="getAccountById" parameterType="string" resultType="com.hoo.entity.Account" resultMap="accountResultMap">

      [CDATA[

         select * from account where account_id = #{id}

      ]]>

select>



<-- accountMap.accountResultMap是account-resultmap.xml中定义的resultmap，通过namespace.id找到 -->

<select id="getAccountByNames" parameterType="string" resultMap="accountMap.accountResultMap">

      [CDATA[

         select * from account where username = #{name}

      ]]>

select>



<sql id="user_name_pwd">

      username, password

sql>



<-- 自动生成id策略 -->

<insert id="addAccount" useGeneratedKeys="true" keyProperty="account_id" parameterType="account">

      insert into account(account_id, status, username, password)

      values(#{accountId}, #{status}, #{username}, #{password})

insert>



<-- 根据selectKey语句生成主键 -->

<insert id="addAccount4Key" parameterType="account">

      <selectKey keyProperty="account_id" order="BEFORE" resultType="int">

         select cast(random() * 10000 as Integer) a from #Tab

      selectKey>

      insert into account(account_id, status, username, password)

      values(#{accountId}, #{status}, #{username}, #{password})

insert>



<update id="editAccount" parameterType="account">

      update account set

      status = #{status},

      username = #{username},

      password = #{password}

      where account_id = #{accountId}

update>



<delete id="removeAccount" parameterType="int">

      delete from account where account_id = #{id}

delete>

mapper>


　　上面的namespace和定义接口类路径对应，所有的sql语句，如select、insert、delete、update的id和方法名称对应。关于更多MyBatis内容的讲解，这里就不赘述的。这里只完成整合！如果你不懂可以去阅读其他关于MyBatis的资料。
　　11、为了测试发布，这里使用junit和spring官方提供的spring-test.jar，完成spring框架整合的测试，代码如下：

package com.hoo.mapper;



import java.util.List;

import javax.inject.Inject;

import org.springframework.test.context.ContextConfiguration;

import org.springframework.test.context.junit38.AbstractJUnit38SpringContextTests;

import com.hoo.entity.Account;



/**

* function: AccountMapper JUnit测试类

* @author hoojo

* @createDate 2011-4-12 下午04:21:50

* @file AccountMapperTest.java

* @package com.hoo.mapper

* @project MyBatisForSpring

* @blog http://blog.csdn.net/IBM_hoojo

* @email hoojo_@126.com

* @version 1.0

*/



@ContextConfiguration("classpath:applicationContext-*.xml")

public class AccountMapperTest extends AbstractJUnit38SpringContextTests {



@Inject

//@Named("accountMapper")

private AccountMapper mapper;



public void testGetAccount() {

      System.out.println(mapper.getAccount());

}



public void testGetAccountById() {

      System.out.println(mapper.getAccountById("28"));

}



public void testGetAccountByName() {

      System.out.println(mapper.getAccountByName("user"));

}



public void testGetAccountByNames() {

      System.out.println(mapper.getAccountByNames("user"));

}



public void testAdd() {

      Account account = new Account();

      account.setEmail("temp@155.com");

      account.setPassword("abc");

      account.setRoleId(1);

      account.setSalt("ss");

      account.setStatus(0);

      account.setUsername("Jack");

      mapper.addAccount(account);

}



public void testEditAccount() {

      Account acc = mapper.getAccountByNames("Jack");

      System.out.println(acc);

      acc.setUsername("Zhangsan");

      acc.setPassword("123123");

      mapper.editAccount(acc);

      System.out.println(mapper.getAccountById(acc.getAccountId() + ""));

}



public void testRemoveAccount() {

      Account acc = mapper.getAccountByNames("Jack");

      mapper.removeAccount(acc.getAccountId());

      System.out.println(mapper.getAccountByNames("Jack"));

}



public void testAccountList() {

      List acc = mapper.getAllAccount();

      System.out.println(acc.size());

      System.out.println(acc);

}

}


　　这里的注入并没有使用@Autowired、@Resource、@Qualifier注入，而是使用@Inject、@Named注入方式，Inject注入是JSR330的标准注入方式；而不局限于某个产品，使用于多个产品的使用，推荐使用这种方式；运行后，没有发现问题，就可以继续后续的编码工作了。
　　12、定义AccountDao接口及实现代码，代码如下：

package com.hoo.dao;



import java.util.List;

import org.springframework.dao.DataAccessException;



/**

* function: Account数据库操作dao接口

* @author hoojo

* @createDate 2011-4-13 上午10:21:38

* @file AccountDao.java

* @package com.hoo.dao

* @project MyBatisForSpring

* @blog http://blog.csdn.net/IBM_hoojo

* @email hoojo_@126.com

* @version 1.0

*/

public interface AccountDao {



/**

   * function: 添加Account对象信息

   * @author hoojo

   * @createDate 2011-4-13 上午11:50:05

   * @param entity Account

   * @return boolean 是否成功

   * @throws DataAccessException

   */

public boolean addAccount(T entity) throws DataAccessException;



/**

   * function: 根据id对到Account信息

   * @author hoojo

   * @createDate 2011-4-13 上午11:50:45

   * @param id 编号id

   * @return Account

   * @throws DataAccessException

   */

public T getAccount(Integer id) throws DataAccessException;



/**

   * function: 查询所有Account信息

   * @author hoojo

   * @createDate 2011-4-13 上午11:51:45

   * @param id 编号id

   * @return Account

   * @throws DataAccessException

   */

public List getList() throws DataAccessException;

}


　　接口实现

package com.hoo.dao.impl;



import java.util.List;

import javax.inject.Inject;

import org.springframework.dao.DataAccessException;

import org.springframework.stereotype.Repository;

import com.hoo.dao.AccountDao;

import com.hoo.entity.Account;

import com.hoo.mapper.AccountMapper;



/**

* function: Account数据库操作dao

* @author hoojo

* @createDate 2011-4-13 上午10:25:02

* @file AccountDaoImpl.java

* @package com.hoo.dao.impl

* @project MyBatisForSpring

* @blog http://blog.csdn.net/IBM_hoojo

* @email hoojo_@126.com

* @version 1.0

*/

@SuppressWarnings("unchecked")

@Repository

public class AccountDaoImplextends Account> implements AccountDao {



@Inject

private AccountMapper mapper;



public boolean addAccount(T entity) throws DataAccessException {

      boolean flag = false;

      try {

         mapper.addAccount(entity);

         flag = true;

      } catch (DataAccessException e) {

         flag = false;

         throw e;

      }

      return flag;

}



public T getAccount(Integer id) throws DataAccessException {

      T entity = null;

      try {

         entity = (T) mapper.getAccountById(String.valueOf(id));

      } catch (DataAccessException e) {

         throw e;

      }

      return entity;

}



public List getList() throws DataAccessException {

      return (List) mapper.getAllAccount();

}

}


　　13、服务层AccountBiz接口及实现代码
　　接口：

package com.hoo.biz;



import java.util.List;

import org.springframework.dao.DataAccessException;



/**

* function: biz层Account接口

* @author hoojo

* @createDate 2011-4-13 上午11:33:04

* @file AccountBiz.java

* @package com.hoo.biz

* @project MyBatisForSpring

* @blog http://blog.csdn.net/IBM_hoojo

* @email hoojo_@126.com

* @version 1.0

*/

public interface AccountBiz {

/**

   * function: 添加Account对象信息

   * @author hoojo

   * @createDate 2011-4-13 上午11:50:05

   * @param entity Account

   * @return boolean 是否成功

   * @throws DataAccessException

   */

public boolean addAccount(T entity) throws DataAccessException;



/**

   * function: 根据id对到Account信息

   * @author hoojo

   * @createDate 2011-4-13 上午11:50:45

   * @param id 编号id

   * @return Account

   * @throws DataAccessException

   */

public T getAccount(Integer id) throws DataAccessException;



/**

   * function: 查询所有Account信息

   * @author hoojo

   * @createDate 2011-4-13 上午11:51:45

   * @param id 编号id

   * @return Account

   * @throws DataAccessException

   */

public List getList() throws DataAccessException;

}


　　实现代码：

package com.hoo.biz.impl;



import java.util.List;

import javax.inject.Inject;

import org.springframework.dao.DataAccessException;

import org.springframework.stereotype.Service;

import com.hoo.biz.AccountBiz;

import com.hoo.dao.AccountDao;

import com.hoo.entity.Account;

import com.hoo.exception.BizException;



/**

* function: Account Biz接口实现

* @author hoojo

* @createDate 2011-4-13 上午11:34:39

* @file AccountBizImpl.java

* @package com.hoo.biz.impl

* @project MyBatisForSpring

* @blog http://blog.csdn.net/IBM_hoojo

* @email hoojo_@126.com

* @version 1.0

*/

//@Component

@Service

public class AccountBizImplextends Account> implements AccountBiz {



@Inject

private AccountDao dao;



public boolean addAccount(T entity) throws DataAccessException {

      if (entity == null) {

         throw new BizException(Account.class.getName() + "对象参数信息为Empty！");

      }

      return dao.addAccount(entity);

}



public T getAccount(Integer id) throws DataAccessException {

      return dao.getAccount(id);

}



public List getList() throws DataAccessException {

      return dao.getList();

}

}


　　上面用到了一个自定义的异常信息，代码如下：

package com.hoo.exception;



import org.springframework.dao.DataAccessException;



/**

* function:自定义Biz层异常信息

* @author hoojo

* @createDate 2011-4-13 上午11:42:19

* @file BizException.java

* @package com.hoo.exception

* @project MyBatisForSpring

* @blog http://blog.csdn.net/IBM_hoojo

* @email hoojo_@126.com

* @version 1.0

*/

public class BizException extends DataAccessException {



/**

   * @author Hoojo

   */

private static final long serialVersionUID = 1L;



public BizException(String msg) {

      super(msg);

}



public BizException(String msg, Throwable cause) {

      super(msg, cause);

}

}


　　这里只是简单的继承，如果还有其他的异常业务或需求可以进行具体的实现
　　14、 springMVC的控制器，AccountController代码如下：

package com.hoo.controller;



import javax.inject.Inject;

import javax.servlet.http.HttpServletRequest;

import org.springframework.stereotype.Controller;

import org.springframework.ui.Model;

import org.springframework.web.bind.annotation.ExceptionHandler;

import org.springframework.web.bind.annotation.RequestMapping;

import com.hoo.biz.AccountBiz;

import com.hoo.entity.Account;



/**

* function: Account控制器

* @author hoojo

* @createDate 2011-4-13 上午10:18:02

* @file AccountController.java

* @package com.hoo.controller

* @project MyBatisForSpring

* @blog http://blog.csdn.net/IBM_hoojo

* @email hoojo_@126.com

* @version 1.0

*/

@Controller

@RequestMapping("/account")

public class AccountController {



@Inject

private AccountBiz biz;



@RequestMapping("/add")

public String add(Account acc) {

      System.out.println(acc);

      biz.addAccount(acc);

      return "redirect:/account/list.do";

}



@RequestMapping("/get")

public String get(Integer id, Model model) {

      System.out.println("##ID:" + id);

      model.addAttribute(biz.getAccount(id));

      return "/show.jsp";

}



@RequestMapping("/list")

public String list(Model model) {

      model.addAttribute("list", biz.getList());

      return "/list.jsp";

}



@ExceptionHandler(Exception.class)

public String exception(Exception e, HttpServletRequest request) {

      //e.printStackTrace();

      request.setAttribute("exception", e);

      return "/error.jsp";

}

}


　　15、基本页面代码
　　index.jsp

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>

<%

String path = request.getContextPath();

String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";

%>



"-//W3C//DTD HTML 4.01 Transitional//EN">





"<%=basePath%>">





"pragma" content="no-cache">

"cache-control" content="no-cache">

"expires" content="0">

"keywords" content="keyword1,keyword2,keyword3">

"description" content="This is my page">







      MyBatis 3.0.4  整合  Spring 3.0.5


      "account/list.do">查询所有


      "account/add.do?username=abcdef&password=123132&status=2">添加


      "account/get.do?id=25">查询







　　List.jsp

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>

<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>

<%

String path = request.getContextPath();

String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";

%>



<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>

  <head>

<base href="<%=basePath%>">



<title>all Account Result</title>



<meta http-equiv="pragma" content="no-cache">

<meta http-equiv="cache-control" content="no-cache">

<meta http-equiv="expires" content="0">

<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">

<meta http-equiv="description" content="This is my page">

  </head>



  <body>

      <c:forEach items="${list}" var="data">

         id: ${data.accountId }---name: ${data.username }---password: ${data.password }<hr/>

      </c:forEach>

  </body>

</html>


　　show.jsp

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>

<%

String path = request.getContextPath();

String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";

%>



<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>

  <head>

<base href="<%=basePath%>">



<title>show Account</title>



<meta http-equiv="pragma" content="no-cache">

<meta http-equiv="cache-control" content="no-cache">

<meta http-equiv="expires" content="0">

<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">

<meta http-equiv="description" content="This is my page">

  </head>



  <body>

      ${account }<br/>

      ${account.username }#${account.accountId }

  </body>

</html>




　　error.jsp

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>

<%

String path = request.getContextPath();

String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";

%>



<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>

  <head>

<base href="<%=basePath%>">



<title>Error Page</title>



<meta http-equiv="pragma" content="no-cache">

<meta http-equiv="cache-control" content="no-cache">

<meta http-equiv="expires" content="0">

<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">

<meta http-equiv="description" content="This is my page">

  </head>



  <body>

<H2>Exception: ${exception }</H2>

<a href="javascript:document.getElementById('show').style.display = 'block';void(0);">

      详细信息

</a>

<div id="show" style="color: red; display: none;">

      <% Exception ex = (Exception)request.getAttribute("exception"); %>



      <% ex.printStackTrace(new java.io.PrintWriter(out)); %>

</div>

  </body>

</html>


　　16、以上就基本上完成了整个Spring+SpringMVC+MyBatis的整合了。如果你想添加事务管理，得在applicationContext-common.xml中加入如下配置：



<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">

      <property name="dataSource" ref="dataSource" />

bean>


　　同时还需要加入aspectjweaver.jar这个jar包；
　　注意的是：Jdbc的TransactionManager不支持事务隔离级别，我在整个地方加入其它的TransactionManager，增加对transaction的隔离级别都尝试失败！
　　也许可以用于jpa、jdo、jta这方面的东西。不知道大家对MyBatis的事务是怎么处理的？
　　17、对Dao进行扩展封装，运用SqlSessionDaoSupport进行模板的扩展或运用：
　　BaseDao代码如下：

package com.hoo.dao.impl;



import java.util.ArrayList;

import java.util.List;

import javax.inject.Inject;

import org.apache.ibatis.session.SqlSessionFactory;

import org.mybatis.spring.support.SqlSessionDaoSupport;

import org.springframework.stereotype.Repository;

import com.hoo.dao.BaseDao;



/**

* function: 运用SqlSessionDaoSupport封装Dao常用增删改方法，可以进行扩展

* @author hoojo

* @createDate 2011-4-13 下午06:33:37

* @file BaseDaoImpl.java

* @package com.hoo.dao.impl

* @project MyBatisForSpring

* @blog http://blog.csdn.net/IBM_hoojo

* @email hoojo_@126.com

* @version 1.0

*/

@Repository

@SuppressWarnings({ "unchecked", "unused" })

public class BaseDaoImplextends Object> extends SqlSessionDaoSupport implements BaseDao {



@Inject

private SqlSessionFactory sqlSessionFactory;



public boolean add(String classMethod, T entity) throws Exception {

      boolean flag = false;

      try {

         flag = this.getSqlSession().insert(classMethod, entity) > 0 ? true : false;

      } catch (Exception e) {

         flag = false;

         throw e;

      }

      return flag;

}



public boolean edit(String classMethod, T entity) throws Exception {

      boolean flag = false;

      try {

         flag = this.getSqlSession().update(classMethod, entity) > 0 ? true : false;

      } catch (Exception e) {

         flag = false;

         throw e;

      }

      return flag;

}



public T get(String classMethod, T entity) throws Exception {

      T result = null;

      try {

         result = (T) this.getSqlSession().selectOne(classMethod, entity);

      } catch (Exception e) {

         throw e;

      }

      return result;

}



public List getAll(String classMethod) throws Exception {

      List result = new ArrayList();

      try {

         result = this.getSqlSession().selectList(classMethod);

      } catch (Exception e) {

         throw e;

      }

      return result;

}



public boolean remove(String classMethod, T entity) throws Exception {

      boolean flag = false;

      try {

         flag = this.getSqlSession().delete(classMethod, entity) > 0 ? true : false;

      } catch (Exception e) {

         flag = false;

         throw e;

      }

      return flag;

}

}


　　值得说明的是，这个类继承了SqlSessionDaoSupport，它需要我们帮助它注入SqlSessionFactory或是SqlSessionTemplate，如果两者都被注入将忽略SqlSessionFactory属性，使用SqlSessionTemplate模板。
　　继承SqlSessionDaoSupport后，可以拿到SqlSession完成数据库的操作；
　　18、对Dao进行扩展封装，运用SqlSessionTemplate进行模板的扩展或运用：
　　首先看看这个组件中运用的一个Mapper的基类接口：

package com.hoo.mapper;



import java.util.List;

import org.springframework.dao.DataAccessException;



/**

* function: BaseSqlMapper继承SqlMapper，对Mapper进行接口封装，提供常用的增删改查组件；

* 也可以对该接口进行扩展和封装

* @author hoojo

* @createDate 2011-4-14 上午11:36:41

* @file BaseSqlMapper.java

* @package com.hoo.mapper

* @project MyBatisForSpring

* @blog http://blog.csdn.net/IBM_hoojo

* @email hoojo_@126.com

* @version 1.0

*/

public interface BaseSqlMapper extends SqlMapper {



public void add(T entity) throws DataAccessException;



public void edit(T entity) throws DataAccessException;



public void remvoe(T entity) throws DataAccessException;



public T get(T entity) throws DataAccessException;



public List getList(T entity) throws DataAccessException;

}


　　该接口继承SqlMapper接口，但是该接口没有MyBatis的mapper实现。需要我们自己的业务mapper继承这个接口，完成上面的方法的实现。
　　看看继承SqlSessionTemplate的BaseMapperDao代码：

package com.hoo.dao.impl;



import java.util.List;

import javax.inject.Inject;

import org.apache.ibatis.session.SqlSessionFactory;

import org.mybatis.spring.SqlSessionTemplate;

import org.springframework.stereotype.Repository;

import com.hoo.dao.BaseMapperDao;

import com.hoo.mapper.BaseSqlMapper;



/**

* function:运用SqlSessionTemplate封装Dao常用增删改方法，可以进行扩展

* @author hoojo

* @createDate 2011-4-14 下午12:22:07

* @file BaseMapperDaoImpl.java

* @package com.hoo.dao.impl

* @project MyBatisForSpring

* @blog http://blog.csdn.net/IBM_hoojo

* @email hoojo_@126.com

* @version 1.0

*/

@SuppressWarnings("unchecked")

@Repository

public class BaseMapperDaoImpl extends SqlSessionTemplate implements BaseMapperDao {



@Inject

public BaseMapperDaoImpl(SqlSessionFactory sqlSessionFactory) {

      super(sqlSessionFactory);

}



private Classextends BaseSqlMapper> mapperClass;



public void setMapperClass(Classextends BaseSqlMapper> mapperClass) {

      this.mapperClass = mapperClass;

}



private BaseSqlMapper getMapper() {

      return this.getMapper(mapperClass);

}



public boolean add(T entity) throws Exception {

      boolean flag = false;

      try {

         this.getMapper().add(entity);

         flag = true;

      } catch (Exception e) {

         flag = false;

         throw e;

      }

      return flag;

}



public boolean edit(T entity) throws Exception {

      boolean flag = false;

      try {

         this.getMapper().edit(entity);

         flag = true;

      } catch (Exception e) {

         flag = false;

         throw e;

      }

      return flag;

}



public T get(T entity) throws Exception {

      return this.getMapper().get(entity);

}



public List getAll() throws Exception {

      return this.getMapper().getList(null);

}



public boolean remove(T entity) throws Exception {

      boolean flag = false;

      try {

         this.getMapper().remvoe(entity);

         flag = true;

      } catch (Exception e) {

         flag = false;

         throw e;

      }

      return flag;

}

}


　　上面这个类继承了SqlSessionTemplate，这个类需要提供一个构造函数。这里提供的是SqlSessionFactory的构造函数，通过该函数注入SqlSessionFactory即可完成数据库操作；
　　例外的是这个类还有一个关键属性mapperClass，这个class需要是BaseSqlMapper接口或是子接口，然后通过SqlSessionTemplate模板获得当前设置的Class的Mapper对象，完成数据库操作。
　　该类的测试代码：

@ContextConfiguration("classpath:applicationContext-*.xml")

public class BaseMapperDaoImplTest extends AbstractJUnit38SpringContextTests {



@Inject

private BaseMapperDao dao;



public void init() {

      dao.setMapperClass(CompanyMapper.class);

}



public void testGet() throws Exception {

      init();

      Company c = new Company();

      c.setCompanyId(4);

      System.out.println(dao.get(c));

}



public void testAdd() throws Exception {

      init();

      Company c = new Company();

      c.setAddress("北京中关村");

      c.setName("beijin");

      System.out.println(dao.add(c));

}

}


　　一般情况下，你可以在一个Dao中注入BaseMapperDao，紧跟着需要设置MapperClass。只有设置了MapperClass后，BaseMapperDao才能获取对应mapper，完成相关的数据库操作。当然你可以在这个Dao中将SqlSessionTemplate、SqlSession暴露出来，当BaseMapperDao的方法不够用，可以进行扩展

账号		自动登录	找回密码
密码			立即注册

大疆运维招人啦，

C++ :try 语句块和异常处理

C++的多态

Red Hat RHCE 8 (EX294) Cert Guide

Java/C++ 区别：看完这一篇，就够用！

别再用过时库了！这 13 个顶级 C++ 库才是

c++ size_t 和 int 的区别

[经验分享] spring mvc mybatis

浏览过的版块

扫码加入运维网微信交流群