Spring MVC Mybatis 整合

最新推荐文章于 2022-06-09 22:21:34 发布

wangbiao007

最新推荐文章于 2022-06-09 22:21:34 发布

阅读量1.5k

点赞数

分类专栏：框架整合文章标签： mybatis spring mvc

本文链接：https://blog.csdn.net/wangbiao007/article/details/41827485

版权

框架整合专栏收录该内容

2 篇文章 0 订阅

订阅专栏

Web.xml文件

contextConfigLocation

contextConfigLocation

<?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>
	<servlet-name>springmvc</servlet-name>
	<servlet-class>
org.springframework.web.servlet.DispatcherServlet
	</servlet-class>
	<init-param>
	<param-name>contextConfigLocation</param-name>
        <param-value>classpath:applicationContext.xml</param-value>
	</init-param>
	<load-on-startup>1</load-on-startup>
</servlet>

<servlet-mapping>
	<servlet-name>springmvc</servlet-name>
	<url-pattern>*.from</url-pattern>
</servlet-mapping>

  <welcome-file-list>
    <welcome-file>index.jsp</welcome-file>
  </welcome-file-list>
</web-app>

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:context="http://www.springframework.org/schema/context"
	xmlns:jdbc="http://www.springframework.org/schema/jdbc" 
	xmlns:jee="http://www.springframework.org/schema/jee"
	xmlns:tx="http://www.springframework.org/schema/tx" 
	xmlns:jpa="http://www.springframework.org/schema/data/jpa"
	xmlns:util="http://www.springframework.org/schema/util"
	xmlns:mvc="http://www.springframework.org/schema/mvc"
	xsi:schemaLocation="
		http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.2.xsd
		http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.2.xsd
		http://www.springframework.org/schema/jdbc http://www.springframework.org/schema/jdbc/spring-jdbc-3.2.xsd
		http://www.springframework.org/schema/jee http://www.springframework.org/schema/jee/spring-jee-3.2.xsd
		http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.2.xsd
		http://www.springframework.org/schema/data/jpa http://www.springframework.org/schema/data/jpa/spring-jpa-1.3.xsd
		http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-3.2.xsd
		http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-3.2.xsd">
	<bean id="mydatasource"
		class="org.apache.commons.dbcp.BasicDataSource">
		<property name="username" value="demo">
		</property>
		<property name="password" value="demo">
		</property>
		<property name="driverClassName" 
			value="oracle.jdbc.OracleDriver">
		</property>
		<property name="url"
			value="jdbc:oracle:thin:@192.168.0.23:1521:tarena10g">
		</property>
	</bean>
	
	<!-- sqlsessionfactorybean -->
	<bean id="sqlsessionfactorybean"
	class="org.mybatis.spring.SqlSessionFactoryBean">
		<property name="dataSource" 
				ref="mydatasource">
		</property>
		<property name="mapperLocations"
		 value="classpath:org/tarena/entity/*.xml">
		</property>
	</bean>
	
	<!-- 定义MapperFactoryBean  
	<bean id="deptDao" 
		class="org.mybatis.spring.mapper.MapperFactoryBean">
		<property name="mapperInterface" 
			value="org.tarena.dao.DeptMapperDao">
		</property>
		<property name="sqlSessionFactory" 
			ref="sqlsessionfactorybean">
		</property>
	</bean>
	-->
	<!-- 使用MapperScannerConfigurer替代MapperFactoryBean -->
	<bean id="mapperScanner" 
		class="org.mybatis.spring.mapper.MapperScannerConfigurer">
		<!-- 指定MapperDao接口所在包 -->
		<property name="basePackage" 
			value="org.tarena.dao">
		</property>
		<!-- 指定带有@MyBatisDao标记的才当做Mapper处理 -->
		<property name="annotationClass"
			value="org.tarena.annotation.MyBatisDao">
		</property>
		<!-- sqlSessionfactorybean默认注入了 -->
	</bean>
	
	<!-- Spring MVC -->

        <!--扫描哪些带有注解-->
	<context:component-scan 
		base-package="org.tarena"/>
	<!--指定方法-->
	<mvc:annotation-driven/>
	
	<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
		<property name="prefix" 
			value="/WEB-INF/jsp/">
		</property>
		<property name="suffix" value=".jsp">
		</property>
	</bean>
</beans>

EmpMap.xml文件,orr.tarena.dao.EmpMapperDao这个接口一定带有findAll这个方法

</pre><pre name="code" class="html"><pre name="code" class="html"><?xml version="1.0" encoding="UTF-8" ?>  
<!DOCTYPE mapper PUBLIC "-//ibatis.apache.org//DTD Mapper 3.0//EN"      
 "http://ibatis.apache.org/dtd/ibatis-3-mapper.dtd">
<mapper namespace="org.tarena.dao.EmpMapperDao">

	<select id="findAll" 
		resultType="org.tarena.entity.Emp">
		select * from EMP order by EMPNO
	</select>

</mapper>

</pre><pre name="code" class="html">自定义的一个注解MybatisDao.

<pre name="code" class="java">package org.tarena.annotation;

import org.springframework.stereotype.Repository;

//@MyBatisDao
@Repository
public @interface MyBatisDao {
//  String value() default "";
}

EmpMapperDao接口，这个和EmpMap.xml文件中的内容相对应

<pre name="code" class="html">package org.tarena.dao;

import java.util.List;

import org.tarena.annotation.MyBatisDao;
import org.tarena.entity.Emp;

@MyBatisDao
public interface EmpMapperDao {
	public List<Emp> findAll();
}

定义Emp这个对象

<pre name="code" class="html">package org.tarena.entity;

import java.sql.Date;

public class Emp {
	private Integer empno;
	private String ename;
	private String job;
	private Integer mgr;
	private Date hiredate;
	private Double sal;
	private Double comm;
	private Integer deptno;
	
	public Double getSal() {
		return sal;
	}
	public void setSal(Double sal) {
		this.sal = sal;
	}
	public Double getComm() {
		return comm;
	}
	public void setComm(Double comm) {
		this.comm = comm;
	}

	public Integer getEmpno() {
		return empno;
	}
	public void setEmpno(Integer empno) {
		this.empno = empno;
	}
	public String getEname() {
		return ename;
	}
	public void setEname(String ename) {
		this.ename = ename;
	}
	public String getJob() {
		return job;
	}
	public void setJob(String job) {
		this.job = job;
	}
	public Integer getMgr() {
		return mgr;
	}
	public void setMgr(Integer mgr) {
		this.mgr = mgr;
	}
	public Date getHiredate() {
		return hiredate;
	}
	public void setHiredate(Date hiredate) {
		this.hiredate = hiredate;
	}
	
	
	public Integer getDeptno() {
		return deptno;
	}
	public void setDeptno(Integer deptno) {
		this.deptno = deptno;
	}
}

测试类：

<pre name="code" class="java">package org.tarena.test;

import java.util.List;

import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import org.tarena.dao.DeptMapperDao;
import org.tarena.dao.EmpMapperDao;
import org.tarena.entity.Dept;
import org.tarena.entity.Emp;

public class TestEmpMapperDao {

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		String conf = "applicationContext.xml";
		ApplicationContext ac = 
			new ClassPathXmlApplicationContext(conf);
		EmpMapperDao dao = ac.getBean(
			"empMapperDao",EmpMapperDao.class);
		List<Emp> list = dao.findAll();
		for(Emp e : list){
			System.out.println(e.getEmpno()+" "+e.getEname());
		}
	}

}

在applicationContext.xml文件中发现有一段，这里是用了一个自定义的组件来进行扫描，意思是当org.tarena.dao下的所有含有@MyBatisDao的接口都当做Mapper处理

<pre name="code" class="html"><!-- 使用MapperScannerConfigurer替代MapperFactoryBean -->
	<bean id="mapperScanner" 
		class="org.mybatis.spring.mapper.MapperScannerConfigurer">
		<!-- 指定MapperDao接口所在包 -->
		<property name="basePackage" 
			value="org.tarena.dao">
		</property>
		<!-- 指定带有@MyBatisDao标记的才当做Mapper处理 -->
		<property name="annotationClass"
			value="org.tarena.annotation.MyBatisDao">
		</property>
		<!-- sqlSessionfactorybean默认注入了 -->
	</bean>

这里还可以直接指定一个接口，在这里接口DeptMapperDao是被当成Mapper处理的。

       <bean id="deptDao" 
		class="org.mybatis.spring.mapper.MapperFactoryBean">
		<property name="mapperInterface" 
			value="org.tarena.dao.DeptMapperDao">
		</property>
		<property name="sqlSessionFactory" 
			ref="sqlsessionfactorybean">
		</property>
	</bean>

接口DeptMapperDao

package org.tarena.dao;

import java.util.List;

import org.tarena.annotation.MyBatisDao;
import org.tarena.entity.Dept;


public interface DeptMapperDao {
	public List<Dept> findAll();
}

整个整合过程：

-------搭建Spring+MyBatis环境-----------
1.先导入Spring开发包和applicationContext.xml
导入springjdbc02开发包,包含了springmvc,ioc,dao,aop,dbcp
2.然后导入MyBatis开发包
mybatis-3.2.5.jar,ojdbc6.jar
3.引入Spring和MyBatis整合的开发包
mybatis-spring-1.2.2.jar
------------使用SqlSessionFactoryBean----------------
4.在applicationContext.xml定义一个dataSource连接池对象Bean
5.在applicationContext.xml定义一个SqlSessionFactoryBean对象
6.实例化Spring容器ApplicationContext对象
----------对DEPT表操作-------------
7.编写Dept实体类,属性名与字段名保持一致
8.编写DeptMap.xml文件,定义SQL操作语句
9.在SqlSessionFactoryBean定义部分追加DeptMap.xml的参数指定
-----定义Mapper映射器生成实例对象-------------
10.定义一个Mapper映射器DeptMapperDao接口
--方法名要和DeptMap.xml一致
--DeptMap.xml中的namespace要指定DeptMapperDao
11.使用MapperFactoryBean根据Mapper映射器接口生成
实现对象(过时,用下面的MapperScannerConfigurer)
11.使用MapperScannerConfigurer将指定包下的所有Mapper映射器批量生成实现对象,对象id默认用接口名首字母小写
12.测试Mapper映射器对象
-----指定带有自定义标记的接口才当做Mapper映射器--------
13.自定义一个注解标记@MyBatisDao
14.给MapperScannerConfigurer组件<bean>定义添加
annotationClass属性指定
15.在Mapper映射器接口中使用@MyBatisDao定义
16.测试Mapper映射器对象

=========再次追加EMP表操作===========
1.添加Emp实体类
2.添加EmpMap.xml,定义SQL
3.定义EmpMapperDao映射器接口
--方法名与EmpMap.xml中SQL操作的id属性一致
--将EmpMap.xml的namesapce属性写成EmpMapperDao
4.在EmpMapperDao接口前使用@MyBatisDao定义
5.测试

========添加SpringMVC环境===========
1.引入spring ioc,webmvc等开发包(已完成)
2.添加applicationContextx.xml (已完成)
3.在web.xml中定义DispatcherServlet
=========实现发请求到响应的处理=======
emplist.from-->EmpListController(使用dao)-->emp_list.jsp
4.编写EmpListController,使用@Controller和@RequestMapping注解
5.在applicationContext.xml中添加支持注解的配置
组件扫描和mvc:annotation-driven
6.在applicationContext.xml中定义viewresolver
7.在WEB-INF/jsp/添加一个emp_list.jsp
8.测试发送emplist.from请求

9.将EmpMapperDao给EmpListController注入使用
10.在emp_list.jsp页面中使用JSTL标签和EL表达式显示数据
11.测试发送emplist.from请求