Mybatis整合Spring和SpringMVC配置文件详解

超、凢脫俗 2022-04-15 00:59 302阅读 0赞

### 配置文件 ###

*  pom.xml（配置我们需要的jar包）
 *  web.xml（启动spring容器监听器并加载spring的xml文件，加载springmvc前端控制器）
 *  springmvc的配置文件（配置IOC自动注入视图对象（controller），前端页面映射配置，静态资源配置）
 *  spring的配置文件(创建对象配置IOC自动注入业务对象（非cont），数据库配置，事物管理，和mybatis的结合配置)
 *  mybatis的配置文件(settings, 数据库别名等，当然也都可以配置在spring中)

**1、pom.xml中导入如下jar包**

<?xml version="1.0" encoding="UTF-8"?>
    <project xmlns="http://maven.apache.org/POM/4.0.0"
             xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
             xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
        <modelVersion>4.0.0</modelVersion>
    
        <groupId>com.test</groupId>
        <artifactId>mybatisExcercise</artifactId>
        <version>1.0-SNAPSHOT</version>
    
        <dependencies>
            
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-context</artifactId>
                <version>4.3.12.RELEASE</version>
            </dependency>
    
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-aspects</artifactId>
                <version>4.3.12.RELEASE</version>
            </dependency>
    
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-jdbc</artifactId>
                <version>4.3.12.RELEASE</version>
            </dependency>
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-webmvc</artifactId>
                <version>4.3.12.RELEASE</version>
            </dependency>
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-orm</artifactId>
                <version>4.3.12.RELEASE</version>
            </dependency>
    
            <dependency>
                <groupId>junit</groupId>
                <artifactId>junit</artifactId>
                <version>4.12</version>
                <scope>test</scope>
            </dependency>
    
            
            <dependency>
                <groupId>c3p0</groupId>
                <artifactId>c3p0</artifactId>
                <version>0.9.1.2</version>
            </dependency>
    
            
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>5.1.44</version>
            </dependency>
            <dependency>
                <groupId>org.mybatis</groupId>
                <artifactId>mybatis</artifactId>
                <version>3.4.6</version>
            </dependency>
            <dependency>
                <groupId>org.mybatis</groupId>
                <artifactId>mybatis-spring</artifactId>
                <version>1.3.2</version>
            </dependency>
    
        </dependencies>
    </project>

其中

1.1、spring（包括：springIOC，springAOP，springMVC，spring数据库管理，spring事物管理，spring日志包）

具体spring模块可参考：[https://blog.csdn.net/ruiguang21/article/details/76697225/][https_blog.csdn.net_ruiguang21_article_details_76697225]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2ppbmhhaWppbmc_size_16_color_FFFFFF_t_70][]

1.2、mybatis:

![20181120110314757.png][]

1.3、mybatis和spring和适配包：

![20181120110329656.png][]

1.4、数据库驱动：

![20181120110340294.png][]

1.5、数据源（数据库连接池）：

![20181120110348823.png][]

额外知识：数据源和连接池的区别：[Java中DriverManager跟DataSource获取getConnection有什么不同（Java中数据源和连接池的区别）][Java_DriverManager_DataSource_getConnection_Java]

如果maven有导入不进去的，可以手动添加：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2ppbmhhaWppbmc_size_16_color_FFFFFF_t_70 1][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2ppbmhhaWppbmc_size_16_color_FFFFFF_t_70 2][]

**2、 web.xml**

作用：启动spring容器监听器并加载spring的xml文件，加载springmvc前端控制器

<?xml version="1.0" encoding="UTF-8"?>
    <web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" id="WebApp_ID" version="2.5">
      <display-name>MyBatis_06_ssm</display-name>
      
      
    	<context-param>
    		<param-name>contextConfigLocation</param-name>
    		<param-value>classpath:applicationContext.xml</param-value>
    	</context-param>
    
    	
    	<listener>
    		<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
    	</listener>
    	
    	
    	
    	<servlet>
    		<servlet-name>spring</servlet-name>
    		<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
    		<load-on-startup>1</load-on-startup>
    		
    		<init-param>
    			<param-name>contextConfigLocation</param-name>
    			<param-value>classpath:spring/springmvc.xml</param-value>
    		</init-param>
    	</servlet>
    
    	
    	<servlet-mapping>
    		<servlet-name>spring</servlet-name>
    		<url-pattern>/</url-pattern>
    	</servlet-mapping>
      
    </web-app>

**3、 springmvc的配置文件**

作用：配置IOC自动注入视图对象（controller），前端页面映射配置，静态资源配置

注意：springmvc的配置文件文件的位置：如果web.xml中配置了如下：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2ppbmhhaWppbmc_size_16_color_FFFFFF_t_70 3][]

则springmvc的配置文件则是配置中指定的目录和指定的文件，但如果没有配置，springmvc的配置文件默认在：WEB-INF/servlet的name+"-servlet.xml"

spring-servlet.xml

**4、spring的配置文件**

作用：创建对象配置IOC自动注入业务对象（非controller），数据库配置，事物管理，和mybatis的结合配置，以及对mapper接口的注入

位置：web.xml中配置的位置和文件名

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:mybatis-spring="http://mybatis.org/schema/mybatis-spring"
    	xmlns:tx="http://www.springframework.org/schema/tx"
    	xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
    		http://mybatis.org/schema/mybatis-spring http://mybatis.org/schema/mybatis-spring-1.2.xsd
    		http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.0.xsd
    		http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsd">
    
    	
    	<context:component-scan base-package="com.atguigu.mybatis">
    		<context:exclude-filter type="annotation"
    			expression="org.springframework.stereotype.Controller" />
    	</context:component-scan>
    
    	
    	<context:property-placeholder location="classpath:dbconfig.properties" />
    	
    	<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
    		<property name="jdbcUrl" value="${jdbc.url}"></property>
    		<property name="driverClass" value="${jdbc.driver}"></property>
    		<property name="user" value="${jdbc.username}"></property>
    		<property name="password" value="${jdbc.password}"></property>
    	</bean>
    	
    	
    	<bean id="dataSourceTransactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
    		<property name="dataSource" ref="dataSource"></property>
    	</bean>
    	
    	<tx:annotation-driven transaction-manager="dataSourceTransactionManager"/>
    	
    	<bean id="sqlSessionFactoryBean" class="org.mybatis.spring.SqlSessionFactoryBean">
    		<property name="dataSource" ref="dataSource"></property>
    		
    		<property name="configLocation" value="classpath:mybatis-config.xml"></property>
    		
    		<property name="mapperLocations" value="classpath:mybatis/mapper/*.xml"></property>
    	</bean>
    	
    	
    	<bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate">
    		<constructor-arg name="sqlSessionFactory" ref="sqlSessionFactoryBean"></constructor-arg>
    		<constructor-arg name="executorType" value="BATCH"></constructor-arg>
    	</bean>
    	
    	
    	<mybatis-spring:scan base-package="com.atguigu.mybatis.dao"/>
    	
    	
    </beans>

**5、mybatis相关配置**

其实这些配置都可以写在spring配置文件的

<bean id="sqlSessionFactoryBean" class="org.mybatis.spring.SqlSessionFactoryBean"></bean>中

原生的mybatis中操作数据库的对象是：SqlSession，而sqlSession的获取方式是：

String resource = "mybatis-config.xml";
    InputStream inputStream = Resources.getResourceAsStream(resource);
    //获取sqlSessionFactory
    SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
    //获取sqlSession
    SqlSession sqlSession = sqlSessionFactory.openSession();
    
    //得到Mapper接口的对象
    DepartmentMapper mapper = sqlSession.getMapper(DepartmentMapper.class);
    //Mapper接口的对象去调用自己的方法返回结果
    Department deptById = mapper.getDeptById(1);

所以mybatis相关的配置都写在id="sqlSessionFactoryBean"的bean中。

*附：原生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>
    	
    	<properties resource="dbconfig.properties"></properties>
    	
    	
    	
    	<settings>
    		<setting name="mapUnderscoreToCamelCase" value="true"/>
    		<setting name="jdbcTypeForNull" value="NULL"/>
    		
    		
    		<setting name="cacheEnabled" value="true"/>
    		<setting name="lazyLoadingEnabled" value="true"/>
    		<setting name="aggressiveLazyLoading" value="false"/>
    	</settings>
    	
    	
    	
    	<typeAliases>
    		
    		
    		
    		
    		<package name="com.atguigu.mybatis.bean"/>
    		
    		
    	</typeAliases>
    		
    	
    		 
    	<environments default="dev_mysql">
    		<environment id="dev_mysql">
    			<transactionManager type="JDBC"></transactionManager>
    			<dataSource type="POOLED">
    				<property name="driver" value="${jdbc.driver}" />
    				<property name="url" value="${jdbc.url}" />
    				<property name="username" value="${jdbc.username}" />
    				<property name="password" value="${jdbc.password}" />
    			</dataSource>
    		</environment>
    	
    		<environment id="dev_oracle">
    			<transactionManager type="JDBC" />
    			<dataSource type="POOLED">
    				<property name="driver" value="${orcl.driver}" />
    				<property name="url" value="${orcl.url}" />
    				<property name="username" value="${orcl.username}" />
    				<property name="password" value="${orcl.password}" />
    			</dataSource>
    		</environment>
    	</environments>
    	
    	
    	
    	<databaseIdProvider type="DB_VENDOR">
    		
    		<property name="MySQL" value="mysql"/>
    		<property name="Oracle" value="oracle"/>
    		<property name="SQL Server" value="sqlserver"/>
    	</databaseIdProvider>
    	
    	
    	
    	
    	<mappers>
    		
    		
    		
    		
    		
    		<package name="com.atguigu.mybatis.dao"/>
    	</mappers>
    </configuration>

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2ppbmhhaWppbmc_size_16_color_FFFFFF_t_70 4][]

即：mybatis中也可以设置连接池

**mybatis-config.xml**

*因为spring中已配置了数据源、事物管理、mapper.xml的地址，所以mybatis中可以只配置setting和数据库别名的配置；**当然，这些也可以直接写在spring中；*

<?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="mapUnderscoreToCamelCase" value="true"/>
    		<setting name="jdbcTypeForNull" value="NULL"/>
    		
    		
    		<setting name="cacheEnabled" value="true"/>
    		<setting name="lazyLoadingEnabled" value="true"/>
    		<setting name="aggressiveLazyLoading" value="false"/>
    	</settings>
    	
    	<databaseIdProvider type="DB_VENDOR">
    		<property name="MySQL" value="mysql"/>
    		<property name="Oracle" value="oracle"/>
    		<property name="SQL Server" value="sqlserver"/>
    	</databaseIdProvider>
    	
    </configuration>

**6、数据库配置文件**

dbconfig.properties

jdbc.driver=com.mysql.jdbc.Driver
    jdbc.url=jdbc:mysql://localhost:3306/mybatis?allowMultiQueries=true
    jdbc.username=root
    jdbc.password=123456
    
    orcl.driver=oracle.jdbc.OracleDriver
    orcl.url=jdbc:oracle:thin:@localhost:1521:orcl
    orcl.username=scott
    orcl.password=123456

### 编写自己的代码 ###

*  创建controller，servlet，dao，mapper, bean类即可
 *  并可以使用注解@controller, @Service, @Autowired进行编码

# ======以下于你或许是个好消息====== #

**好消息就是：**欢迎访问下面的博客网站哈哈哈......

**网站名称：**[Java学习笔记网][Java]  (点击进入)

**url：**[https://www.javaxxbj.com/][Java] (点击进入)

**网站特点：**

1.  java主要网站的导航目录
2.  你可以记录自己的博客，并可以控制显示和隐藏，可利于管理啦！！！
3.  可以添加收藏各个网站的链接！！！
4.  甚至也可以文章收藏，点赞，关注，查看我的消息等功能哦！！1

**看一小点点的截图：**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2ppbmhhaWppbmc_size_16_color_FFFFFF_t_70 5][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2ppbmhhaWppbmc_size_16_color_FFFFFF_t_70 6][]

或可一试哦！

[https_blog.csdn.net_ruiguang21_article_details_76697225]: https://blog.csdn.net/ruiguang21/article/details/76697225/
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2ppbmhhaWppbmc_size_16_color_FFFFFF_t_70]: /images/20220415/70d6013977db4efe8443bdd923db30f3.png
[20181120110314757.png]: /images/20220415/27dfb8d791314d03bb8f4a30e7d6509a.png
[20181120110329656.png]: /images/20220415/5171c741822a4bc5847c93704c741106.png
[20181120110340294.png]: /images/20220415/5d0240a129894b1582c568ba29e5b0e7.png
[20181120110348823.png]: /images/20220415/d0a2f1404fab431fafb619c0f972ea06.png
[Java_DriverManager_DataSource_getConnection_Java]: https://blog.csdn.net/jinhaijing/article/details/84284847
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2ppbmhhaWppbmc_size_16_color_FFFFFF_t_70 1]: /images/20220415/45bf0a91f16440518e5019213bc64b0e.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2ppbmhhaWppbmc_size_16_color_FFFFFF_t_70 2]: /images/20220415/05f131af295b4a05893def9b06f221a3.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2ppbmhhaWppbmc_size_16_color_FFFFFF_t_70 3]: /images/20220415/5776271066d54177b0d07007186d17ba.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2ppbmhhaWppbmc_size_16_color_FFFFFF_t_70 4]: /images/20220415/6566f4c688a64f6090231df72c23c732.png
[Java]: https://www.javaxxbj.com/
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2ppbmhhaWppbmc_size_16_color_FFFFFF_t_70 5]: /images/20220415/4a96f551153741c690702d8720b8b3ee.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2ppbmhhaWppbmc_size_16_color_FFFFFF_t_70 6]: /images/20220415/4171784bfffc441691caf58944179b4e.png