Mybatis(四)--Spring集成Mybatis

最新推荐文章于 2024-07-19 17:50:16 发布

m0_74823264

最新推荐文章于 2024-07-19 17:50:16 发布

阅读量72

点赞数

分类专栏：面试学习路线阿里巴巴资料职业发展文章标签： mybatis spring java 后端

本文链接：https://blog.csdn.net/m0_74823264/article/details/134053578

版权

面试同时被 3 个专栏收录

21 篇文章 0 订阅

订阅专栏

学习路线

21 篇文章 0 订阅

订阅专栏

阿里巴巴资料职业发展

20 篇文章 1 订阅

订阅专栏

强烈推荐一个大神的人工智能的教程：http://www.captainai.net/zhanghan

一、创建zh-root项目(用来管理依赖包的版本)

1.使用idea开发工具新建maven项目,坐标如下:

  <groupId>zh.root</groupId>
  <artifactId>zh-root</artifactId>
  <version>1.0-SNAPSHOT</version>

2.添加对应依赖及版本

<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>zh.root</groupId>
  <artifactId>zh-root</artifactId>
  <version>1.0-SNAPSHOT</version>
  <packaging>pom</packaging>

  <properties>
    <!--构建项目时使用,用于maven中的文件拷贝-->
    <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    <project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
    <!-- 编译时的编码 -->
    <!--否则在dos执行mvn compile可能由于编码问题出现莫名其妙的问题,因为dos默认的编码,格式是系统的GBK-->
    <maven.compiler.encoding>UTF-8</maven.compiler.encoding>
    <!-- 编译源代码 jdk版本编译 -->
    <maven.compiler.source>1.8</maven.compiler.source>
    <!-- 编译源代码 版本 -->
    <maven.compiler.target>1.8</maven.compiler.target>
    <!-- 编译插件版本号控制 -->
    <maven-compiler-plugin.version>3.7.0</maven-compiler-plugin.version>
    <!--junit单元测试 -->
    <junit.version>4.12</junit.version>
    <!--日志-->
    <log4j.version>1.2.17</log4j.version>
    <spring.version>5.0.2.RELEASE</spring.version>
    <aspectj.version>1.8.13</aspectj.version>
    <jackson.version>2.9.2</jackson.version>
    <mybatis.version>3.4.5</mybatis.version>
    <mybatis-spring.version>1.3.1</mybatis-spring.version>
    <mysql.version>5.1.38</mysql.version>
    <druid.version>1.1.6</druid.version>
  </properties>

  <dependencyManagement>
    <dependencies>
      <!--测试-->
      <dependency>
        <groupId>junit</groupId>
        <artifactId>junit</artifactId>
        <version>${junit.version}</version>
      </dependency>
      <!--日志-->
      <dependency>
        <groupId>log4j</groupId>
        <artifactId>log4j</artifactId>
        <version>${log4j.version}</version>
      </dependency>
      <!--spring-->
      <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-core</artifactId>
        <version>${spring.version}</version>
      </dependency>
      <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-context</artifactId>
        <version>${spring.version}</version>
      </dependency>
      <!--JDBC-->
      <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-jdbc</artifactId>
        <version>${spring.version}</version>
      </dependency>
      <!--spring事务-->
      <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-tx</artifactId>
        <version>${spring.version}</version>
      </dependency>
      <!--Spring面向切面编程-->
      <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-aop</artifactId>
        <version>${spring.version}</version>
      </dependency>
      <!--spring-aop的依赖-->
      <dependency>
        <groupId>org.aspectj</groupId>
        <artifactId>aspectjweaver</artifactId>
        <version>${aspectj.version}</version>
      </dependency>
      <!--spring-web的依赖-->
      <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-web</artifactId>
        <version>${spring.version}</version>
      </dependency>
      <!--spring-mvc-->
      <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-webmvc</artifactId>
        <version>${spring.version}</version>
      </dependency>
      <!--spring-mvc-json-->
      <dependency>
        <groupId>com.fasterxml.jackson.core</groupId>
        <artifactId>jackson-databind</artifactId>
        <version>${jackson.version}</version>
      </dependency>
      <!--mybatis-->
      <dependency>
        <groupId>org.mybatis</groupId>
        <artifactId>mybatis</artifactId>
        <version>${mybatis.version}</version>
      </dependency>
      <dependency>
        <groupId>org.mybatis</groupId>
        <artifactId>mybatis-spring</artifactId>
        <version>${mybatis-spring.version}</version>
      </dependency>
      <!--mysql-->
      <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>${mysql.version}</version>
      </dependency>
      <!-- 连接池 -->
      <dependency>
        <groupId>com.alibaba</groupId>
        <artifactId>druid</artifactId>
        <version>${druid.version}</version>
      </dependency>
    </dependencies>
  </dependencyManagement>

  <build>
    <plugins>
      <plugin>
        <!-- 用来编译位于src/main/java/目录下的主源码 -->
        <groupId>org.apache.maven.plugins</groupId>  <!-- 项目或者组织的唯一标志 -->
        <artifactId>maven-compiler-plugin</artifactId> <!-- 项目的通用名称 -->
        <version>${maven-compiler-plugin.version}</version>
        <!-- 使用maven-compiler-plugin 指定JDK版本和编码 -->
        <configuration>    <!-- 通常用于私有不开源的plugin -->
          <source>${maven.compiler.source}</source>        <!-- 编译源代码 jdk版本编译 -->
          <target>${maven.compiler.target}</target>
          <encoding>${project.build.sourceEncoding}</encoding>      <!-- 用于maven中的文件拷贝 的 编码格式 -->
        </configuration>
      </plugin>
    </plugins>
  </build>
</project>

二、创建mybatis-spring-zh(我使用的是quickstart)

1.使用idea开发工具新建maven项目.坐标如下:

  <groupId>zh.mybatis-spring</groupId>
  <artifactId>mybatis-spring</artifactId>
  <version>1.0-SNAPSHOT</version>

2.修改pom.xml中的打包方式为war

<packaging>war</packaging>

3.新建web.xml文件(目录:src/main/webapp/WEB-INF/web.xml),添加约束如下:

<?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_3_0.xsd"
         version="3.0">

</web-app>

4.在pom.xml中添加相关依赖

<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">
  <parent>
    <groupId>zh.root</groupId>
    <artifactId>zh-root</artifactId>
    <version>1.0-SNAPSHOT</version>
  </parent>

  <modelVersion>4.0.0</modelVersion>
  <groupId>zh.mybatis-spring</groupId>
  <artifactId>mybatis-spring</artifactId>
  <version>1.0-SNAPSHOT</version>
  <packaging>war</packaging>

  <dependencies>
    <!--测试-->
    <dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <scope>test</scope>
    </dependency>

    <!--日志-->
    <dependency>
      <groupId>log4j</groupId>
      <artifactId>log4j</artifactId>
    </dependency>

    <!--Spring核心-->
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-core</artifactId>
    </dependency>

    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-context</artifactId>
    </dependency>

    <!--Spring JDBC-->
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-jdbc</artifactId>
      <version>5.0.2.RELEASE</version>
    </dependency>

    <!--Spring事务-->
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-tx</artifactId>
    </dependency>

    <!--Spring面向切面编程-->
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-aop</artifactId>
    </dependency>

    <!--spring-aop依赖-->
    <dependency>
      <groupId>org.aspectj</groupId>
      <artifactId>aspectjweaver</artifactId>
    </dependency>

    <!--Spring-MVC依赖-->
    <!--Spring web依赖-->
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-web</artifactId>
    </dependency>
    <!--Spring-MVC-->
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-webmvc</artifactId>
    </dependency>

    <!--spring-mvc-json-->
    <dependency>
      <groupId>com.fasterxml.jackson.core</groupId>
      <artifactId>jackson-databind</artifactId>
    </dependency>

    <!--spring-mybatis-->
    <dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis</artifactId>
    </dependency>


    <dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis-spring</artifactId>
    </dependency>

    <!--mysql-->
    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
    </dependency>
    <!--数据库连接池-->
    <dependency>
      <groupId>com.alibaba</groupId>
      <artifactId>druid</artifactId>
    </dependency>
  </dependencies>
</project>

5.项目的完整路径如下,第一步先创建项目的基本结构,controller,mapper,model,service

6.创建springmvc的配置文件spring-context.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:mvc="http://www.springframework.org/schema/mvc"
       xsi:schemaLocation="http://www.springframework.org/schema/beans
        http://www.springframework.org/schema/beans/spring-beans.xsd
        http://www.springframework.org/schema/mvc
        http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd
        http://www.springframework.org/schema/context
        http://www.springframework.org/schema/context/spring-context.xsd">


    <mvc:annotation-driven/>

    <context:component-scan base-package="zh.mybatis.spring.controller"/>
    <context:component-scan base-package="zh.mybatis.spring.service"/>

    <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
        <!--<property name="viewClass" value="org.springframework.web.servlet.view.JstlView"/>-->
        <property name="prefix" value="/WEB-INF/jsp/"/>
        <property name="suffix" value=".jsp"/>
    </bean>

    <import resource="classpath:spring/dataSource.xml"/>
    <import resource="classpath:spring/spring-mybatis.xml"/>
</beans>

7.创建db.properties文件,配置数据库连接的相关参数

jdbc_driverClassName=com.mysql.cj.jdbc.Driver
jdbc_url=jdbc:mysql://localhost:3306/mybatis?useUnicode=true&characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull
jdbc_username=root
jdbc_password=

8.创建dataSource.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"
       xsi:schemaLocation="http://www.springframework.org/schema/beans
    http://www.springframework.org/schema/beans/spring-beans.xsd">

    <!--数据库连接设置-->
    <!--<bean id="dataSource" class="com.p6spy.engine.spy.P6DataSource">-->
        <!--<constructor-arg>-->
            <!--<ref bean="dataSourceDefault"/>-->
        <!--</constructor-arg>-->
    <!--</bean>-->

    <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource" destroy-method="close">
        <property name="url" value="${jdbc_url}"/>
        <property name="username" value="${jdbc_username}"/>
        <property name="password" value="${jdbc_password}"/>
    </bean>
</beans>

9.创建mybatis配置文件mybatis-config.xml,用于mybatis的常用配置

<?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="logImpl" value="LOG4J"/>
        <setting name="cacheEnabled" value="true"/>
        <setting name="mapUnderscoreToCamelCase" value="true"/>
        <setting name="aggressiveLazyLoading" value="false"/>
    </settings>
</configuration>

10.创建mybatis和spring整合的配置文件,spring-mybatis.xml

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

<beans xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xmlns="http://www.springframework.org/schema/beans"
       xmlns:context="http://www.springframework.org/schema/context"
       xsi:schemaLocation="http://www.springframework.org/schema/beans
        http://www.springframework.org/schema/beans/spring-beans.xsd
        http://www.springframework.org/schema/context
        http://www.springframework.org/schema/context/spring-context.xsd">
    <!--加载db配置文件-->
    <context:property-placeholder location="classpath:db.properties"/>

    <!--配置sqlSessionFactory-->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="configLocation" value="classpath:spring/mybatis-config.xml"/>
        <property name="dataSource" ref="dataSource"/>
        <property name="mapperLocations">
            <array>
                <value>classpath:mapper/*.xml</value>
            </array>
        </property>
        <property name="typeAliasesPackage" value="zh.mybatis.spring.model"/>
    </bean>

    <!--扫描mapper-->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="basePackage" value="zh.mybatis.spring.mapper"/>
        <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
    </bean>
</beans>

11.完善web.xml

<?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_3_0.xsd"
         version="3.0">
    <context-param>
        <!--定义了要装入的spring配置文件-->
        <param-name>contextConfigLocation</param-name>
        <param-value>classpath:spring/spring-context.xml</param-value>
    </context-param>

    <listener>
        <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
    </listener>
    <!--前端控制器-->
    <servlet>
        <servlet-name>mybatis</servlet-name>
        <servlet-class>
            org.springframework.web.servlet.DispatcherServlet
        </servlet-class>
        <init-param>
            <param-name>contextConfigLocation</param-name>
            <param-value>classpath:spring/spring-context.xml</param-value>
        </init-param>
        <load-on-startup>1</load-on-startup>
    </servlet>
    <servlet-mapping>
        <servlet-name>mybatis</servlet-name>
        <url-pattern>/</url-pattern>
    </servlet-mapping>

</web-app>

12.写一个小例子测试一下是否成功了,以查询用户为例,分别创建UserMapper.xml,UserService,UserController,SysUser,访问该测试方法,查询出如下结果。相关程序代码已上传到码云,可以参考,https://gitee.com/ZhangHuan8/spring-mybatis.git

关于为什么要抽出一个root项目管理版本,可以参考以下博客:Maven实战（六）— dependencies与dependencyManagement的区别__Emily的博客-CSDN博客

m0_74823264

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
Mybatis(四)--Spring集成Mybatis

12.写一个小例子测试一下是否成功了,以查询用户为例,分别创建UserMapper.xml,UserService,UserController,SysUser,访问该测试方法,查询出如下结果。相关程序代码已上传到码云,可以参考,https://gitee.com/ZhangHuan8/spring-mybatis.git。5.项目的完整路径如下,第一步先创建项目的基本结构,controller,mapper,model,service。7.创建db.properties文件,配置数据库连接的相关参数。
复制链接

扫一扫