SpringMVC+Spring+MyBatis整合笔记

最新推荐文章于 2025-08-14 09:32:24 发布

原创最新推荐文章于 2025-08-14 09:32:24 发布 · 1.2k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#spring #encoding #insert #class #aop #jdbc

本文介绍了一个结合SpringMVC、MyBatis及Spring的项目配置过程，包括SpringMVC配置、Spring配置、MyBatis配置等内容，并提供了DAO层实现示例。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

jars:

aopalliance.jar
aspectjrt.jar
aspectjweaver.jar
commons-dbcp-1.4.jar
commons-logging-1.1.1.jar
commons-pool-1.6.jar
mybatis-3.1.1.jar
mybatis-spring-1.1.1.jar
org.springframework.aop-3.1.0.RELEASE.jar
org.springframework.asm-3.1.0.RELEASE.jar
org.springframework.beans-3.1.0.RELEASE.jar
org.springframework.context-3.1.0.RELEASE.jar
org.springframework.core-3.1.0.RELEASE.jar
org.springframework.expression-3.1.0.RELEASE.jar
org.springframework.jdbc-3.1.0.RELEASE.jar
org.springframework.transaction-3.1.0.RELEASE.jar
org.springframework.web-3.1.0.RELEASE.jar
org.springframework.web.servlet-3.1.0.RELEASE.jar

一、SpringMVC配置

web.xml

	
	<!-- Context Configuration locations for Spring XML files -->
	<context-param>
		<param-name>contextConfigLocation</param-name>
		<param-value>classpath:applicationContext.xml</param-value>
	</context-param>

	<!-- 监听,ServletContext启动时让spring启动 -->
	<listener>
		<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
	</listener>
	
	<!-- SpringMVC 核心分发器 -->
	<servlet>
		<servlet-name>dispatcher</servlet-name>
		<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
		<init-param>
			<description>加载/WEB-INF/spring-mvc/目录下的所有XML作为Spring MVC的配置文件</description>
			<param-name>contextConfigLocation</param-name>
			<param-value>/WEB-INF/spring-mvc/*.xml</param-value>
		</init-param>
		<load-on-startup>1</load-on-startup>
	</servlet>
	<servlet-mapping>
		<servlet-name>dispatcher</servlet-name>
		<url-pattern>*.do</url-pattern>
	</servlet-mapping>
	
	<!-- SpringMVC 字符编码过滤器 -->
	<filter>
		<filter-name>encoding</filter-name>
		<filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
		<init-param>
			<param-name>encoding</param-name>
			<param-value>UTF-8</param-value>
		</init-param>
	</filter>
	<filter-mapping>
		<filter-name>encoding</filter-name>
		<url-pattern>/*</url-pattern>
	</filter-mapping>

在WEB-INF下创建spring-mvc放dispatcher-servlet.xml

dispatcher-servlet.xml

<!-- 扫描控制器 -->
	<context:component-scan base-package="com.jeremy.web.controller" />

	<!-- 视图配置 -->
	<bean id="viewResolver"
		class="org.springframework.web.servlet.view.InternalResourceViewResolver">
		<!-- <property name="viewClass">
			<value>org.springframework.web.servlet.view.JstlView</value>
		</property> -->
		<!-- 在viewResolver中设定prefix和suffix属性,分別設定除了相对路径和后缀 -->
		<property name="prefix">
			<value>/WEB-INF/jsp/</value>
		</property>
		<property name="suffix">
			<value>.jsp</value>
		</property>
	</bean>

二、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:context="http://www.springframework.org/schema/context"
	xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx"
	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
         http://www.springframework.org/schema/tx
         http://www.springframework.org/schema/tx/spring-tx-3.0.xsd
         http://www.springframework.org/schema/aop 
         http://www.springframework.org/schema/aop/spring-aop-3.0.xsd">

	<!-- 使用annotation -->
	<context:annotation-config />
	<!-- 扫描组件 -->
	<context:component-scan base-package="com.jeremy" />

	<!-- 引入数据库配置文件 -->
	<context:property-placeholder location="classpath:db.properties" />

	<!-- 配置数据源 -->
	<bean id="dataSource" destroy-method="close"
		class="org.apache.commons.dbcp.BasicDataSource">
		<property name="driverClassName" value="${db.driverClassName}" />
		<property name="url" value="${db.url}" />
		<property name="username" value="${db.username}" />
		<property name="password" value="${db.password}" />
	</bean>

	<!-- 配置SqlSessionFactory，会自动被注入到org.mybatis.spring.support.SqlSessionDaoSupport -->
	<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
		<property name="configLocation" value="classpath:SqlMapConfig.xml" />  
		<property name="dataSource" ref="dataSource" />
		<property name="mapperLocations">
			<list>
				<value>classpath:com/jeremy/domain/*Mapper.xml</value>
			</list>
		</property>
	</bean>
	
	<!-- 事务相关控制 -->
	<bean name="transactionManager"
		class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="dataSource"></property>  
	</bean>

	<tx:advice id="txAdvice" transaction-manager="transactionManager">
		<tx:attributes>
			<tx:method name="delete*" propagation="REQUIRED" read-only="false"
				rollback-for="java.lang.Exception" no-rollback-for="java.lang.RuntimeException" />
			<tx:method name="insert*" propagation="REQUIRES_NEW" read-only="false"
				rollback-for="java.lang.RuntimeException" />
			<tx:method name="save*" propagation="REQUIRES_NEW" read-only="false"
				rollback-for="java.lang.RuntimeException" />
			<tx:method name="update*" propagation="REQUIRED" read-only="false"
				rollback-for="java.lang.Exception" />
				
			<tx:method name="find*" propagation="SUPPORTS" />
			<tx:method name="get*" propagation="SUPPORTS" />
			<tx:method name="select*" propagation="SUPPORTS" />
		</tx:attributes>
	</tx:advice>

	<!--把事务控制在Service层 -->
	<aop:config>
		<aop:pointcut id="serviceMethods"
			expression="execution(public * com.jeremy.service.*.*(..))" />

		<aop:advisor pointcut-ref="serviceMethods" advice-ref="txAdvice" />
	</aop:config>
	
</beans>

db.properties

db.driverClassName=com.mysql.jdbc.Driver
db.url=jdbc:mysql:///ssmdemo
db.username=root
db.password=123456

三、MyBatis配置

SqlMapConfig.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.jeremy.domain.Department" alias="Department" />
		<typeAlias type="com.jeremy.domain.Employee" alias="Employee" />
	</typeAliases>

</configuration>

com/jeremy/domain/DepartmentMapper.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="com.jeremy.domain.Department">
	<insert id="insert" parameterType="Department">
		INSERT INTO DEPARTMENT
		(name) VALUES (#{name})
	</insert>
</mapper>

四、DAO

com.jeremy.dao.impl.DepartmentDAOImpl

package com.jeremy.dao.impl;

import org.mybatis.spring.support.SqlSessionDaoSupport;
import org.springframework.stereotype.Repository;

import com.jeremy.dao.IDepartmentDAO;
import com.jeremy.domain.Department;

@Repository
public class DepartmentDAOImpl extends SqlSessionDaoSupport implements IDepartmentDAO {

	@Override
	public void save(Department d) {
		getSqlSession().insert("com.jeremy.domain.Department.insert", d);
	}
}