spring+springmvc+mybatis 整合

迷南。 2023-10-17 18:31 69阅读 0赞

**搭建ssm框架:**

(1):MyBatis和Spring整合，通过Spring管理mapper接口。

使用mapper的扫描器自动扫描mapper接口在Spring中进行注册。

(2):通过Spring管理Service接口。

使用配置方式将Service接口配置在Spring配置文件中。

实现事务控制。

(3):由于SpringMVC是Spring的模块，无需整合这两个。

**SSM工程:**

**![Center][]**

**操作步骤:**  
1)创建工程,导入ssm框架包  
2)引入spring框架  
3)重新创建javaproject工程,mybatis-generator工具来生成对应的实体类,接口,映射文件  
4)配置mybatis-config.xml文件放在src目录下!

<?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>
    
    	
    	<settings>
    		
    		<setting name="useGeneratedKeys" value="true" />
    	</settings>
    
    	
    	<typeAliases>
    		
    		<package name="com.hlx.entity" />
    	</typeAliases>
    
    	
    	
    
    	
    	<plugins>
    		<plugin interceptor="com.github.pagehelper.PageHelper">
    			<property name="dialect" value="mysql" />
    			<property name="reasonable" value="true" />
    		</plugin>
    	</plugins>
    
    </configuration>

5)配置数据库jdbc.properties文件放在src目录下!

jdbc.driver=com.mysql.jdbc.Driver
    jdbc.url=jdbc:mysql://localhost:3306/java178?useUnicode=true&characterEncoding=utf8
    jdbc.username=root
    jdbc.password=root

6)配置applicationContext-dao.xml文件数据源、SqlSessionFactory、mapper扫描器放在src目录下!

<context:property-placeholder location="classpath:jdbc.properties" />
    
    	
    	<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"
    		destroy-method="close">
    		<property name="driverClassName" value="${jdbc.driver}" />
    		<property name="url" value="${jdbc.url}" />
    		<property name="username" value="${jdbc.username}" />
    		<property name="password" value="${jdbc.password}" />
    		<property name="maxActive" value="30" />
    		<property name="maxIdle" value="5" />
    	</bean>
    
    	
    	<bean id="sqlSessionFactoryBean" class="org.mybatis.spring.SqlSessionFactoryBean">
    		
    		<property name="dataSource" ref="dataSource" />
    		
    		<property name="configLocation" value="classpath:mybatis-config.xml" />
    	</bean>
    
    	
    	<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
    		
    		<property name="basePackage" value="com.hlx.mapper" />
    		
    		<property name="sqlSessionFactoryBeanName" value="sqlSessionFactoryBean" />
    	</bean>

7)业务层service接口,具体实现的类StudentsServiceImpl(忽略)  
8)配置applicationContext-service.xml文件

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

9)配置applicationContext-tx.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"
    	xmlns:context="http://www.springframework.org/schema/context"
    	xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx"
    	xmlns:mvc="http://www.springframework.org/schema/mvc"
    	xsi:schemaLocation="http://www.springframework.org/schema/beans 
    	http://www.springframework.org/schema/beans/spring-beans-4.1.xsd
    	http://www.springframework.org/schema/context
    	http://www.springframework.org/schema/context/spring-context-4.1.xsd
    	http://www.springframework.org/schema/aop
    	http://www.springframework.org/schema/aop/spring-aop-4.1.xsd
    	http://www.springframework.org/schema/tx
    	http://www.springframework.org/schema/tx/spring-tx-4.1.xsd
    	http://www.springframework.org/schema/mvc
    	http://www.springframework.org/schema/mvc/spring-mvc-4.1.xsd
    	">
    
    	
    	<bean id="transactionManager"
    		class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
    		
    		<property name="dataSource" ref="dataSource" />
    	</bean>
    
    	
    	<tx:advice id="txAdvice" transaction-manager="transactionManager">
    		<tx:attributes>
    			<tx:method name="*save*" propagation="REQUIRED" />
    			<tx:method name="*del*" propagation="REQUIRED" />
    			<tx:method name="*update*" propagation="REQUIRED" />
    			<tx:method name="*find*" propagation="SUPPORTS" read-only="true" />
    			<tx:method name="*all*" propagation="SUPPORTS" read-only="true" />
    		</tx:attributes>
    	</tx:advice>
    
    	
    	<aop:config>
    	 <aop:pointcut expression="execution(* com.hlx.service.*.*(..))" id="mycut"/>
    	 <aop:advisor advice-ref="txAdvice" pointcut-ref="mycut"/>
    	</aop:config>
    
    </beans>

10)控制层springmvc类 (忽略)  
11)配置springmvc.xml文件

<context:component-scan base-package="com.hlx.controller" />
    
    	
    	<mvc:annotation-driven conversion-service="conversionServiceFactory" />
    
    	
    	<bean id="conversionServiceFactory"
    		class="org.springframework.format.support.FormattingConversionServiceFactoryBean">
    		<property name="converters">
    			<set>
    				<bean class="com.hlx.util.StringToDateConvert" /> 
    			</set>
    		</property>
    	</bean>
    
    	
    	<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver" p:prefix="/" p:suffix=".jsp"/>

12)在web.xml中配置前端控制器

<context-param>
    		<description>设置Spring加载时的配置文件位置，默认位置在web-inf/lib下</description>
    		<param-name>contextConfigLocation</param-name>
    		<param-value>classpath:applicationContext-*.xml</param-value>
    	</context-param>
    
    	
    	<listener>
    		<display-name>监听spring</display-name>
    		<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
    	</listener>
    
    
    	
    	<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:springmvc.xml</param-value>
    		</init-param>
    	</servlet>
    	<servlet-mapping>
    		<servlet-name>springmvc</servlet-name>
    		<url-pattern>*.action</url-pattern>
    	</servlet-mapping>
    
    
    	
    	<filter>
    		<filter-name>China</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>China</filter-name>
    		<url-pattern>/*</url-pattern>
    	</filter-mapping>

效果:

(1)没有条件查询数据

![Center 1][]

(2)根据一个条件查询数据

![Center 2][]

(3)根据多个条件查询数据

![Center 3][]

[Center]: https://img-blog.csdn.net/20180303154141187?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvaGx4MjAwODA4MDg=/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/Center
[Center 1]: https://img-blog.csdn.net/20180303155220549?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvaGx4MjAwODA4MDg=/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/Center
[Center 2]: https://img-blog.csdn.net/20180303155231082?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvaGx4MjAwODA4MDg=/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/Center
[Center 3]: https://img-blog.csdn.net/20180303155238085?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvaGx4MjAwODA4MDg=/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/Center