maven整合mybatis_spring

最新推荐文章于 2023-06-07 11:46:51 发布

Lance1ot

最新推荐文章于 2023-06-07 11:46:51 发布

阅读量557

点赞数

文章标签： maven spring mybatis 教程学习

本文链接：https://blog.csdn.net/Lance1ot/article/details/89400256

版权

maven整合mybatis_spring

因为mybatis和spring整合过程中，遇到的jar包及其版本问题，实在是麻烦，所以简单学习了maven后进行整合

前提条件

首先，需要Eclipse和相应的java环境

关于maven操作

maven下载链接

http://maven.apache.org/download.cgi
maven环境变量配置

在系统变量中:
新建MAVEN_HOME，填写maven目录
在path中加入%MAVEN_HOME%\bin;
检查maven

在控制台中输入mvn -v，如果出现版本信息，则配置成功
在Eclipse中创建maven项目
目录结构如下，其中的文件用的是以前的文件，详情看之前写的东西

配置pom.xml，在这里面可以添加需要的依赖包信息，当添加后，maven会自动下载、添加到项目中

  <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/maven-v4_0_0.xsd">
    <modelVersion>4.0.0</modelVersion>
    <groupId>com.javen.maven02</groupId>
    <artifactId>maven_mybatis_spring</artifactId>
    <packaging>war</packaging>
    <version>0.0.1-SNAPSHOT</version>
    <name>maven_mybatis_spring Maven Webapp</name>
    <url>http://maven.apache.org</url>
    <dependencies>
    
      <dependency>
        <groupId>junit</groupId>
        <artifactId>junit</artifactId>
        <version>4.9</version>
        <scope>test</scope>
      </dependency>
      
      <!-- https://mvnrepository.com/artifact/org.apache.logging.log4j/log4j-core -->
  	<dependency>
  	    <groupId>org.apache.logging.log4j</groupId>
  	    <artifactId>log4j-core</artifactId>
  	    <version>2.11.1</version>
  	</dependency>
  	
  	<!-- https://mvnrepository.com/artifact/org.mybatis/mybatis-spring -->
  	<dependency>
  	    <groupId>org.mybatis</groupId>
  	    <artifactId>mybatis-spring</artifactId>
  	    <version>1.3.2</version>
  	</dependency>
  	
  	<!-- https://mvnrepository.com/artifact/org.mybatis/mybatis -->
  	<dependency>
  	    <groupId>org.mybatis</groupId>
  	    <artifactId>mybatis</artifactId>
  	    <version>3.4.6</version>
  	</dependency>
  	
  	<!-- https://mvnrepository.com/artifact/org.springframework/spring-core -->
  	<dependency>
  	    <groupId>org.springframework</groupId>
  	    <artifactId>spring-core</artifactId>
  	    <version>5.1.5.RELEASE</version>
  	</dependency>
  	
  	<!-- https://mvnrepository.com/artifact/org.springframework/spring-context -->
  	<dependency>
  	    <groupId>org.springframework</groupId>
  	    <artifactId>spring-context</artifactId>
  	    <version>5.1.5.RELEASE</version>
  	</dependency>
  	
  	<!-- https://mvnrepository.com/artifact/org.apache.logging.log4j/log4j-core -->
  	<dependency>
  	    <groupId>org.apache.logging.log4j</groupId>
  	    <artifactId>log4j-core</artifactId>
  	    <version>2.11.1</version>
  	</dependency>
  	
  	<!-- https://mvnrepository.com/artifact/org.apache.logging.log4j/log4j-api -->
  	<dependency>
  	    <groupId>org.apache.logging.log4j</groupId>
  	    <artifactId>log4j-api</artifactId>
  	    <version>2.11.1</version>
  	</dependency>
  	
  	<!-- https://mvnrepository.com/artifact/org.springframework/spring-tx -->
  	<dependency>
  	    <groupId>org.springframework</groupId>
  	    <artifactId>spring-tx</artifactId>
  	    <version>5.1.5.RELEASE</version>
  	</dependency>
  	
  	<!-- https://mvnrepository.com/artifact/org.springframework/spring-beans -->
  	<dependency>
  	    <groupId>org.springframework</groupId>
  	    <artifactId>spring-beans</artifactId>
  	    <version>5.1.5.RELEASE</version>
  	</dependency>
  	
  	<!-- https://mvnrepository.com/artifact/commons-dbcp/commons-dbcp -->
  	<dependency>
  	    <groupId>commons-dbcp</groupId>
  	    <artifactId>commons-dbcp</artifactId>
  	    <version>1.4</version>
  	</dependency>
  	
  	<!-- https://mvnrepository.com/artifact/org.springframework/spring-jdbc -->
  	<dependency>
  	    <groupId>org.springframework</groupId>
  	    <artifactId>spring-jdbc</artifactId>
  	    <version>5.1.5.RELEASE</version>
  	</dependency>
  	
  	<!-- https://mvnrepository.com/artifact/org.apache.ibatis/ibatis-core -->
  	<dependency>
  	    <groupId>org.apache.ibatis</groupId>
  	    <artifactId>ibatis-core</artifactId>
  	    <version>3.0</version>
  	</dependency>
  	
  	
  	<!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
  	<dependency>
  	    <groupId>mysql</groupId>
  	    <artifactId>mysql-connector-java</artifactId>
  	    <version>8.0.13</version>
  	</dependency>
  	
  	<!-- https://mvnrepository.com/artifact/org.slf4j/slf4j-api -->
  	<dependency>
  	    <groupId>org.slf4j</groupId>
  	    <artifactId>slf4j-api</artifactId>
  	    <version>1.7.25</version>
  	</dependency>
  	
  	<!-- https://mvnrepository.com/artifact/org.slf4j/slf4j-log4j12 -->
  	<dependency>
  	    <groupId>org.slf4j</groupId>
  	    <artifactId>slf4j-log4j12</artifactId>
  	    <version>1.7.25</version>
  	    <scope>test</scope>
  	</dependency>
  	
  	<!-- https://mvnrepository.com/artifact/log4j/log4j -->
  	<dependency>
  	    <groupId>log4j</groupId>
  	    <artifactId>log4j</artifactId>
  	    <version>1.2.17</version>
  	</dependency>
  		
  	<!-- https://mvnrepository.com/artifact/org.apache.logging.log4j/log4j-core -->
  	<dependency>
  	    <groupId>org.apache.logging.log4j</groupId>
  	    <artifactId>log4j-core</artifactId>
  	    <version>2.11.1</version>
  	</dependency>
  	
    </dependencies>
    <build>
      <finalName>maven_mybatis_spring</finalName>
    </build>
  </project>

依赖包在这儿：

mybatis和spring的操作

关于mybatis和spring的操作就不多说了，之前有写，但是因为我依赖包选用的是比较新的，所以有些新的变化

关于log4j2

在根目录下，新建一个叫做log4j2.xml的文件，配置如下：

  <?xml version="1.0" encoding="UTF-8"?>
  <configuration status="OFF">
    <appenders>
      <Console name="Console" target="SYSTEM_OUT">
        <PatternLayout pattern="%d{HH:mm:ss.SSS} [%t] %-5level %logger{36} - %msg%n"/>
      </Console>
    </appenders>
    <loggers>
      <logger name="log4j.logger.noModule" level="fatal" additivity="false">
        <appender-ref ref="Console"/>
      </logger>
      <logger name="log4j.logger.org.mybatis.jpetstore" level="trace" additivity="false">
        <appender-ref ref="Console"/>
      </logger>
      <logger name="log4j.logger.com.opensymphony.xwork2" level="debug" additivity="false">
        <appender-ref ref="Console"/>
      </logger>
      <logger name="log4j.logger.com.ibatis" level="trace" additivity="false">
        <appender-ref ref="Console"/>
      </logger>
      <logger name="log4j.logger.com.ibatis.common.jdbc.SimpleDataSource" level="debug" additivity="false">
        <appender-ref ref="Console"/>
      </logger>
      <logger name="log4j.logger.com.ibatis.common.jdbc.ScriptRunner" level="debug" additivity="false">
        <appender-ref ref="Console"/>
      </logger>
      <logger name="log4j.logger.com.ibatis.sqlmap.engine.impl.SqlMapClientDelegate" level="debug" additivity="false">
        <appender-ref ref="Console"/>
      </logger>
      <logger name="log4j.logger.org.mybatis" level="debug" additivity="false">
        <appender-ref ref="Console"/>
      </logger>
      <logger name="log4j.logger.java.sql" level="debug" additivity="false">
        <appender-ref ref="Console"/>
      </logger>
      <logger name="log4j.logger.java.sql.Connection" level="debug" additivity="false">
        <appender-ref ref="Console"/>
      </logger>
      <logger name="log4j.logger.java.sql.Statement" level="debug" additivity="false">
        <appender-ref ref="Console"/>
      </logger>
      <logger name="log4j.logger.java.sql.PreparedStatement" level="debug" additivity="false">
        <appender-ref ref="Console"/>
      </logger>
      <logger name="log4j.logger.java.sql.ResultSet" level="debug" additivity="false">
        <appender-ref ref="Console"/>
      </logger>
      <root level="trace">
        <appender-ref ref="Console"/>
      </root>
    </loggers>
  </configuration>

在mybatis的配置文件中添加这么一句：

  <settings>
        <setting name="logImpl" value="LOG4J2" />
  </settings>

在spring配置文件中，关于其他新版本改变

driver的值改为：

  com.mysql.cj.jdbc.Driver

url的值改为：

  jdbc:mysql://127.0.0.1:3306/mybatis?characterEncoding=utf8&amp;serverTimezone=UTC

测试结果

在这里插入图片描述

Lance1ot

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
maven整合mybatis_spring

maven整合mybatis_spring前提条件关于maven操作mybatis和spring的操作测试结果因为mybatis和spring整合过程中，遇到的jar包及其版本问题，实在是麻烦，所以简单学习了maven后进行整合前提条件首先，需要Eclipse和相应的java环境关于maven操作maven下载链接http://maven.apache.org/download.c...
复制链接

扫一扫