idea 环境下 mybatis连接数据库实现增删改查

Bertha 。 2022-12-13 04:50 85阅读 0赞

# 一、什么是Mybatis #

这里借用官网的一句话介绍什么是mybatis：MyBatis 是一款优秀的持久层框架，它支持定制化 SQL、存储过程以及高级映射。MyBatis 避免了几乎所有的 JDBC 代码和手动设置参数以及获取结果集。MyBatis 可以使用简单的 XML 或注解来配置和映射原生信息，将接口和 Java 的 POJOs(Plain Old Java Objects,普通的 Java对象)映射成数据库中的记录。

#  #

# 第一步 搭建maven环境 #

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2d4Zmxo_size_16_color_FFFFFF_t_70][]

# 第二步填写包名 #

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2d4Zmxo_size_16_color_FFFFFF_t_70 1][]

# 第三步在新建的项目中找到pom.xml文件 #

添加mybatis mysql 还有junit（单元测试）的依赖

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2d4Zmxo_size_16_color_FFFFFF_t_70 2][]

添加Mybatis依赖代码（此处注意一些遇到的异常处理，看备注）

<?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.org.Ssm</groupId>
        <artifactId>ssm</artifactId>
        <version>1.0-SNAPSHOT</version>
    
        
        <properties>
            <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
        </properties>
        <dependencies>
    
            
            <dependency>
                <groupId>org.mybatis</groupId>
                <artifactId>mybatis</artifactId>
                <version>3.5.2</version>
            </dependency>
            
            
            <dependency>
                <groupId>org.apache.logging.log4j</groupId>
                <artifactId>log4j</artifactId>
                <version>2.11.2</version>
            </dependency>
            
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>8.0.18</version>
                <scope>runtime</scope>
            </dependency>
      
            <dependency>
                <groupId>junit</groupId>
                <artifactId>junit</artifactId>
                <version>4.12</version>
                <scope>test</scope>
            </dependency>
            <dependency>
                <groupId>junit</groupId>
                <artifactId>junit</artifactId>
                <version>4.12</version>
                <scope>compile</scope>
            </dependency>
        </dependencies>
        <build>
            <resources>
               
                <resource>
                    <directory>src/main/resources</directory>
                    <filtering>true</filtering>
                </resource>
                <resource>
                    <directory>src/main/java</directory>
                    <filtering>true</filtering>
                </resource>
            </resources>
            
            <plugins>
                <plugin>
                    <groupId>org.apache.maven.plugins</groupId>
                    <artifactId>maven-resources-plugin</artifactId>
                    <configuration>
                        <encoding>UTF-8</encoding>
                    </configuration>
                </plugin>
            </plugins>
        </build>
    
    </project>

# 第四步配置mybatis核心配置文件（此处注意配置文件所在的位置，和文件中配置变量的注意事项） #

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2d4Zmxo_size_16_color_FFFFFF_t_70 3][]

<?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>
        
        <environments default="mysql">
            <environment id="mysql">
                
                <transactionManager type="JDBC"></transactionManager>
                
                <dataSource type="POOLED">
                    
                    <property name="driver" value="com.mysql.cj.jdbc.Driver"/>
                    
                    
                    <property name="url" value="jdbc:mysql://localhost:3306/gxftest?serverTimezone=UTC"/>
                    <property name="username" value="root"/>
                    <property name="password" value="123456" />
                </dataSource>
    
            </environment>
    
        </environments>
       
       
        <mappers>
            <mapper resource="mapper/userMapper.xml"/>
        </mappers>
    
    </configuration>

# 第六步创建与数据库中表一致的的实体类 navicat 进行数据库的创建 #

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2d4Zmxo_size_16_color_FFFFFF_t_70 4][]

命令

CREATE DATABASE gxftest;  
USE gxftest;  
CREATE TABLE t\_user(  
uid INT PRIMARY KEY AUTO\_INCREMENT,  
username VARCHAR(100),  
password VARCHAR(100)  
);

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2d4Zmxo_size_16_color_FFFFFF_t_70 5][]

# 第七步创建数据库增删改查功能和mybatis的映射关系 #

7.1现创建mapper.xml文件

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2d4Zmxo_size_16_color_FFFFFF_t_70 6][]

7.2在mybatis核心配置文件中映射mapper文件

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2d4Zmxo_size_16_color_FFFFFF_t_70 7][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2d4Zmxo_size_16_color_FFFFFF_t_70 8][]

到此关联已建立下面就是代码进行数据库的增删改查

# 第一步打开数据库通道 #

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2d4Zmxo_size_16_color_FFFFFF_t_70 9][]

第二步封装测试基本类

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2d4Zmxo_size_16_color_FFFFFF_t_70 10][]

最后编写测试类

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2d4Zmxo_size_16_color_FFFFFF_t_70 11][]

原创代码demo已上传

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2d4Zmxo_size_16_color_FFFFFF_t_70]: /images/20221123/a81a19c34ee447a490bfc4dcb1dca51a.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2d4Zmxo_size_16_color_FFFFFF_t_70 1]: /images/20221123/35239becbd9f4e3a9a813ee826084ebe.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2d4Zmxo_size_16_color_FFFFFF_t_70 2]: /images/20221123/673b5ead18cb4ae69a9cdb2358558a5f.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2d4Zmxo_size_16_color_FFFFFF_t_70 3]: /images/20221123/7ebcbc0a26314903a164f04ca8e865a2.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2d4Zmxo_size_16_color_FFFFFF_t_70 4]: /images/20221123/cbcd84521acd4f0e9e22f13a5b6a05c4.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2d4Zmxo_size_16_color_FFFFFF_t_70 5]: /images/20221123/261e73f46ee54f2b8960902b1f830ecd.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2d4Zmxo_size_16_color_FFFFFF_t_70 6]: /images/20221123/8af8e7aa45cb4da782e0be2c8e651278.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2d4Zmxo_size_16_color_FFFFFF_t_70 7]: /images/20221123/d0ac6a80563440958cb60bb91d1b4d57.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2d4Zmxo_size_16_color_FFFFFF_t_70 8]: /images/20221123/c179b1e693aa442ba8198329698863b9.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2d4Zmxo_size_16_color_FFFFFF_t_70 9]: /images/20221123/9a49e16aab954ac69a1cf45cd39fb0d1.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2d4Zmxo_size_16_color_FFFFFF_t_70 10]: /images/20221123/e5ce2d3614ab43beafd89d27feb45874.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2d4Zmxo_size_16_color_FFFFFF_t_70 11]: /images/20221123/87e25fe75e43434891746d06ecf71db3.png