mybatis与spring的集成

于 2024-06-18 19:40:59 发布
阅读量806 收藏 24
点赞数 22
文章标签： mybatis spring java
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.youkuaiyun.com/2401_85117868/article/details/139781831
版权

<version>${pagehelper.version}</version>

</dependency>

<dependency>

<groupId>org.mybatis</groupId>

<artifactId>mybatis-spring</artifactId>

<version>${mybatis.spring.version}</version>

</dependency>

<dependency>

<groupId>org.apache.commons</groupId>

<artifactId>commons-dbcp2</artifactId>

<version>${commons.dbcp2.version}</version>

</dependency>

<dependency>

<groupId>org.apache.commons</groupId>

<artifactId>commons-pool2</artifactId>

<version>${commons.pool2.version}</version>

</dependency>

<dependency>

<groupId>org.apache.logging.log4j</groupId>

<artifactId>log4j-core</artifactId>

<version>${log4j2.version}</version>

</dependency>

<dependency>

<groupId>org.apache.logging.log4j</groupId>

<artifactId>log4j-api</artifactId>

<version>${log4j2.version}</version>

</dependency>

<dependency>

<groupId>org.apache.logging.log4j</groupId>

<artifactId>log4j-web</artifactId>

<version>${log4j2.version}</version>

</dependency>

<dependency>

<groupId>junit</groupId>

<artifactId>junit</artifactId>

<version>${junit.version}</version>

<scope>test</scope>

</dependency>

<dependency>

<groupId>javax.servlet</groupId>

<artifactId>javax.servlet-api</artifactId>

<version>${servlet.version}</version>

<scope>provided</scope>

</dependency>

<dependency>

<groupId>org.projectlombok</groupId>

<artifactId>lombok</artifactId>

<version>${lombok.version}</version>

<scope>provided</scope>

</dependency>

</dependencies>

将resources部分放入build里面

<resources>

<resource>

<directory>src/main/java</directory>

<includes>

<include>**/*.xml</include>

</includes>

</resource>

<resource>

<directory>src/main/resources</directory>

<includes>

<include>jdbc.properties</include>

<include>*.xml</include>

</includes>

</resource>

</resources>

建议将jdbc改成*

在plugins里面插入逆向工程插件

<plugin>

<groupId>org.apache.maven.plugins</groupId>

<artifactId>maven-compiler-plugin</artifactId>

<version>${maven.compiler.plugin.version}</version>

<configuration>

<source>${maven.compiler.source}</source>

<target>${maven.compiler.target}</target>

<encoding>${project.build.sourceEncoding}</encoding>

</configuration>

</plugin>

<plugin>

<groupId>org.mybatis.generator</groupId>

<artifactId>mybatis-generator-maven-plugin</artifactId>

<version>1.3.2</version>

<dependencies>

<dependency>

<groupId>mysql</groupId>

<artifactId>mysql-connector-java</artifactId>

<version>${mysql.version}</version>

</dependency>

</dependencies>

<configuration>

<overwrite>true</overwrite>

</configuration>

</plugin>

完整pom

<?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">

<parent>

    <artifactId>Mybatis</artifactId>

    <groupId>com.ltf</groupId>

    <version>1.0-SNAPSHOT</version>

</parent>

<modelVersion>4.0.0</modelVersion>

<artifactId>Mybatis02</artifactId>

<packaging>war</packaging>

<name>Mybatis02 Maven Webapp</name>

<!-- FIXME change it to the project's website -->

<url>http://www.example.com</url>

<properties>

    <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>

    <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>

    <!--添加jar包依赖-->

    <!--1.spring 5.0.2.RELEASE相关-->

    <spring.version>5.0.2.RELEASE</spring.version>

    <!--2.mybatis相关-->

    <mybatis.version>3.4.5</mybatis.version>

    <!--mysql-->

    <mysql.version>5.1.44</mysql.version>

    <!--pagehelper分页jar依赖-->

    <pagehelper.version>5.1.2</pagehelper.version>

    <!--mybatis与spring集成jar依赖-->

    <mybatis.spring.version>1.3.1</mybatis.spring.version>

    <!--3.dbcp2连接池相关 druid-->

    <commons.dbcp2.version>2.1.1</commons.dbcp2.version>

    <commons.pool2.version>2.4.3</commons.pool2.version>

    <!--4.log日志相关-->

    <!-- log4j2日志配置相关依赖 -->

    <log4j2.version>2.9.1</log4j2.version>

    <log4j2.disruptor.version>3.2.0</log4j2.disruptor.version>

    <slf4j.version>1.7.13</slf4j.version>

    <!--5.其他-->

    <junit.version>4.12</junit.version>

    <servlet.version>4.0.0</servlet.version>

    <lombok.version>1.18.2</lombok.version>

</properties>

<dependencies>

    <!--1.spring相关-->

    <dependency>

        <groupId>org.springframework</groupId>

        <artifactId>spring-context</artifactId>

        <version>${spring.version}</version>

    </dependency>

    <dependency>

        <groupId>org.springframework</groupId>

        <artifactId>spring-orm</artifactId>

        <version>${spring.version}</version>

    </dependency>

    <dependency>

        <groupId>org.springframework</groupId>

        <artifactId>spring-tx</artifactId>

        <version>${spring.version}</version>

    </dependency>

    <dependency>

        <groupId>org.springframework</groupId>

        <artifactId>spring-aspects</artifactId>

        <version>${spring.version}</version>

    </dependency>

    <dependency>

        <groupId>org.springframework</groupId>

        <artifactId>spring-web</artifactId>

        <version>${spring.version}</version>

    </dependency>

    <dependency>

        <groupId>org.springframework</groupId>

        <artifactId>spring-test</artifactId>

        <version>${spring.version}</version>

    </dependency>

    <!--2.mybatis相关-->

    <dependency>

        <groupId>org.mybatis</groupId>

        <artifactId>mybatis</artifactId>

        <version>${mybatis.version}</version>

    </dependency>

    <!--mysql-->

    <dependency>

        <groupId>mysql</groupId>

        <artifactId>mysql-connector-java</artifactId>

        <version>${mysql.version}</version>

    </dependency>

    <!--pagehelper分页插件jar包依赖-->

    <dependency>

        <groupId>com.github.pagehelper</groupId>

        <artifactId>pagehelper</artifactId>

        <version>${pagehelper.version}</version>

    </dependency>

    <!--mybatis与spring集成jar包依赖-->

    <dependency>

        <groupId>org.mybatis</groupId>

        <artifactId>mybatis-spring</artifactId>

        <version>${mybatis.spring.version}</version>

    </dependency>

    <!--3.dbcp2连接池相关-->

    <dependency>

        <groupId>org.apache.commons</groupId>

        <artifactId>commons-dbcp2</artifactId>

        <version>${commons.dbcp2.version}</version>

    </dependency>

    <dependency>

        <groupId>org.apache.commons</groupId>

        <artifactId>commons-pool2</artifactId>

        <version>${commons.pool2.version}</version>

    </dependency>

    <!--4.log日志相关依赖-->

    <!--核心log4j2jar包-->

    <!-- log4j2日志相关依赖 -->

    <!-- log配置：Log4j2 + Slf4j -->

    <!-- slf4j核心包-->

    <dependency>

        <groupId>org.slf4j</groupId>

        <artifactId>slf4j-api</artifactId>

        <version>${slf4j.version}</version>

    </dependency>

    <dependency>

        <groupId>org.slf4j</groupId>

        <artifactId>jcl-over-slf4j</artifactId>

        <version>${slf4j.version}</version>

        <scope>runtime</scope>

    </dependency>

    <!--核心log4j2jar包-->

    <dependency>

        <groupId>org.apache.logging.log4j</groupId>

        <artifactId>log4j-api</artifactId>

        <version>${log4j2.version}</version>

    </dependency>

    <dependency>

        <groupId>org.apache.logging.log4j</groupId>

        <artifactId>log4j-core</artifactId>

        <version>${log4j2.version}</version>

    </dependency>

    <!--用于与slf4j保持桥接-->

    <dependency>

        <groupId>org.apache.logging.log4j</groupId>

        <artifactId>log4j-slf4j-impl</artifactId>

        <version>${log4j2.version}</version>

    </dependency>

    <!--web工程需要包含log4j-web，非web工程不需要-->

    <dependency>

        <groupId>org.apache.logging.log4j</groupId>

        <artifactId>log4j-web</artifactId>

        <version>${log4j2.version}</version>

        <scope>runtime</scope>

    </dependency>

    <!--需要使用log4j2的AsyncLogger需要包含disruptor-->

    <dependency>

        <groupId>com.lmax</groupId>

        <artifactId>disruptor</artifactId>

        <version>${log4j2.disruptor.version}</version>

    </dependency>

    <!--5.其他-->

    <dependency>

        <groupId>junit</groupId>

        <artifactId>junit</artifactId>

        <version>${junit.version}</version>

        <scope>test</scope>

    </dependency>

    <dependency>

        <groupId>javax.servlet</groupId>

        <artifactId>javax.servlet-api</artifactId>

        <version>${servlet.version}</version>

        <scope>provided</scope>

    </dependency>

    <dependency>

        <groupId>org.projectlombok</groupId>

        <artifactId>lombok</artifactId>

        <version>${lombok.version}</version>

        <scope>provided</scope>

    </dependency>

</dependencies>

<build>

    <finalName>Mybatis02</finalName>

    <resources>

        <!--解决mybatis-generator-maven-plugin运行时没有将XxxMapper.xml文件放入target文件夹的问题-->

        <resource>

            <directory>src/main/java</directory>

            <includes>

                <include>\*\*/\*.xml</include>

            </includes>

        </resource>

        <!--解决mybatis-generator-maven-plugin运行时没有将jdbc.properites文件放入target文件夹的问题-->

        <resource>

            <directory>src/main/resources</directory>

            <includes>

                <include>jdbc.properties</include>

                <include>\*.xml</include>

            </includes>

        </resource>

    </resources>

    <pluginManagement><!-- lock down plugins versions to avoid using Maven defaults (may be moved to parent pom) -->

        <plugins>

            <plugin>

                <groupId>org.apache.maven.plugins</groupId>

                <artifactId>maven-compiler-plugin</artifactId>

                <version>${maven.compiler.plugin.version}</version>

                <configuration>

                    <source>${maven.compiler.source}</source>

                    <target>${maven.compiler.target}</target>

                    <encoding>${project.build.sourceEncoding}</encoding>

                </configuration>

            </plugin>

            <plugin>

                <groupId>org.mybatis.generator</groupId>

                <artifactId>mybatis-generator-maven-plugin</artifactId>

                <version>1.3.2</version>

                <dependencies>

                    <!--使用Mybatis-generator插件不能使用太高版本的mysql驱动 -->

                    <dependency>

                        <groupId>mysql</groupId>

                        <artifactId>mysql-connector-java</artifactId>

                        <version>${mysql.version}</version>

                    </dependency>

                </dependencies>

                <configuration>

                    <overwrite>true</overwrite>

                </configuration>

            </plugin>

            <plugin>

                <groupId>org.apache.maven.plugins</groupId>

                <artifactId>maven-compiler-plugin</artifactId>

                <version>${maven.compiler.plugin.version}</version>

                <configuration>

                    <source>${maven.compiler.source}</source>

                    <target>${maven.compiler.target}</target>

                    <encoding>${project.build.sourceEncoding}</encoding>

                </configuration>

            </plugin>

            <plugin>

                <groupId>org.mybatis.generator</groupId>

                <artifactId>mybatis-generator-maven-plugin</artifactId>

                <version>1.3.2</version>

                <dependencies>

                    <!--使用Mybatis-generator插件不能使用太高版本的mysql驱动 -->

                    <dependency>

                        <groupId>mysql</groupId>

                        <artifactId>mysql-connector-java</artifactId>

                        <version>${mysql.version}</version>

                    </dependency>

                </dependencies>

                <configuration>

                    <overwrite>true</overwrite>

                </configuration>

            </plugin>

        </plugins>

    </pluginManagement>

</build>

2.利用mybatis逆向工程生成模型层代码

改为当前模块名

否则是无法自动生成实体类和mapper

建立applicationContext.xml、applicationContext-mybatis.xml文件

将applicationContext-mybatis.xml配置到applicationContext.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”

xsi:schemaLocation=“http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd”>

applicationContext-mybatis.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:tx=“http://www.springframework.org/schema/tx”

xmlns:aop=“http://www.springframework.org/schema/aop”

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 http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd”>

context:annotation-config/

<context:component-scan base-package=“com.ltf”/>

<context:property-placeholder location=“classpath:jdbc.properties”/>

<bean id=“dataSource” class=“org.apache.commons.dbcp2.BasicDataSource”

destroy-method=“close”>

helperDialect=mysql

<tx:annotation-driven transaction-manager=“transactionManager” />

aop:aspectj-autoproxy/

mapper.xml与mapper接口做映射关联

hibernate使用声明式事务：配置四项（开启动态代理，切面，定义事务的属性，事务管理器）

预先定义好规则，然后开发过程中遵循规则去开发

mybatis使用注解式事务 ：配置三项（开启动态代理，事务管理器，事务管理器扫描驱动）

没有定义规则，方法名可以自己取，当对应方法需要使用注解时，添加注解@transaction

测试

建立类SpringBaseTest，加上两行注解

@RunWith(SpringJUnit4ClassRunner.class)

@ContextConfiguration(locations={“classpath:applicationContext.xml”})

service

package com.ltf.service;

import com.ltf.model.Book;

public interface BookService {

int deleteByPrimaryKey(Integer bid);

int insert(Book record);

int insertSelective(Book record);

Book selectByPrimaryKey(Integer bid);

int updateByPrimaryKeySelective(Book record);

int updateByPrimaryKey(Book record);

}

BookServiceImpl

package com.ltf.service.impl;

import com.ltf.mapper.BookMapper;

import com.ltf.model.Book;

import com.ltf.service.BookService;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.stereotype.Service;

@Service

public class BookServiceImpl implements BookService {

@Autowired

private BookMapper bookMapper;

@Override

public int deleteByPrimaryKey(Integer bid) {

return bookMapper.deleteByPrimaryKey(bid);

}

@Override

public int insert(Book record) {

return bookMapper.insert(record);

}

@Override

public int insertSelective(Book record) {

return bookMapper.insertSelective(record);

}

@Override

public Book selectByPrimaryKey(Integer bid) {

return bookMapper.selectByPrimaryKey(bid);

写在最后

为了这次面试，也收集了很多的面试题！

以下是部分面试题截图

Java程序员秋招三面蚂蚁金服，我总结了所有面试题，也不过如此
e com.ltf.service.impl;

import com.ltf.mapper.BookMapper;

import com.ltf.model.Book;

import com.ltf.service.BookService;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.stereotype.Service;

@Service

public class BookServiceImpl implements BookService {

@Autowired

private BookMapper bookMapper;

@Override

public int deleteByPrimaryKey(Integer bid) {

return bookMapper.deleteByPrimaryKey(bid);

}

@Override

public int insert(Book record) {

return bookMapper.insert(record);

}

@Override

public int insertSelective(Book record) {

return bookMapper.insertSelective(record);

}

@Override

public Book selectByPrimaryKey(Integer bid) {

return bookMapper.selectByPrimaryKey(bid);

写在最后

为了这次面试，也收集了很多的面试题！

以下是部分面试题截图

[外链图片转存中…(img-hnR10PBw-1718710846232)]

评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值