创建MyBatis程序

最新推荐文章于 2024-07-29 13:25:32 发布

敏姐儿

最新推荐文章于 2024-07-29 13:25:32 发布

阅读量623

点赞数 2

分类专栏： Mybatis 文章标签：后端

本文链接：https://blog.csdn.net/weixin_46128463/article/details/121613982

版权

Mybatis 专栏收录该内容

4 篇文章 1 订阅

订阅专栏

环境搭建

CREATE TABLE `book` (
  `book_id` int(11) NOT NULL AUTO_INCREMENT,
  `book_table` varchar(100) NOT NULL,
  `book_author` varchar(40) NOT NULL,
  `submission_date` date DEFAULT NULL,
  PRIMARY KEY (`book_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

INSERT INTO `book`(`book_id`, `book_table`, `book_author`, `submission_date`) VALUES (1, '学习 PHP', '老夫子', '2020-04-12');
INSERT INTO `book`(`book_id`, `book_table`, `book_author`, `submission_date`) VALUES (2, '学习 MySQL', '老夫子', '2020-04-12');
INSERT INTO `book`(`book_id`, `book_table`, `book_author`, `submission_date`) VALUES (3, '学习 Java', '姜子牙', '2015-05-01');
INSERT INTO `book`(`book_id`, `book_table`, `book_author`, `submission_date`) VALUES (4, '学习 Python', '姜子牙', '2016-03-06');
INSERT INTO `book`(`book_id`, `book_table`, `book_author`, `submission_date`) VALUES (5, '学习 C', 'FK', '2017-04-05');

新建项目

在这里插入图片描述
删除src目录 : 为了创建一个纯净的父工程.
依次导入下面依赖:

<?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>org.example</groupId>
    <artifactId>mybatis-study</artifactId>
    <version>1.0-SNAPSHOT</version>

    <!--导入依赖-->
    <dependencies>
        <!--mysql驱动-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.47</version>
        </dependency>
        <!--mybatis-->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.5.6</version>
        </dependency>
        <!--junit-->
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.13</version>
            <scope>test</scope>
        </dependency>
    </dependencies>
    <properties>
        <maven.compiler.source>8</maven.compiler.source>
        <maven.compiler.target>8</maven.compiler.target>
    </properties>

</project>

在这里插入图片描述

编写核心配置文件

在这里插入图片描述

<?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 可以配置多个运行环境-->
    <environments default="development">
        <environment id="development">
            <!--默认连接类型 JDBC -->
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <!--驱动-->
                <property name="driver" value="com.mysql.jdbc.Driver"/>
                <!--路径  useSSL=true:安全策略 useUnicode=true:编码安全  -->
                <property name="url" value="jdbc:mysql://localhost:3306/game/?useSSL=true&amp;useUnicode=true&amp;characterEncoding=UTF-8"/>
                <!--用户名-->
                <property name="username" value="root"/>
                <!--用户密码-->
                <property name="password" value="${password}"/>
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <mapper resource="org/mybatis/example/BlogMapper.xml"/>
    </mappers>
</configuration>

编写工具类

package untis;

import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;

import java.io.IOException;
import java.io.InputStream;

/**
 * Created by JDX on 2021/11/29 17:41
 */
public class MybatisUtils {
    //SqlSessionFactory: 工厂模式 --> 工厂需要生产商品 他的产品就是-->sqlSession

    private static SqlSessionFactory sqlSessionFactory;

    static {
        try {
            /*读取配置文件*/
            String resource = "mybatis-config.xml";
            /*根据流将其获取*/
            InputStream inputStream = Resources.getResourceAsStream(resource);
            /*通过build将其加载进来*/
            sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
        } catch (IOException e) {
            e.printStackTrace();
        }
    }

    public static SqlSession getSqlSession() {
        /*既然有了 SqlSessionFactory，顾名思义，我们可以从中获得 SqlSession 的实例。SqlSession 提供了在数据库执行 SQL 命令所需的所有方法。
        你可以通过 SqlSession 实例来直接执行已映射的 SQL 语句。*/
        /*直接返回执行sql语句结果*/
        return sqlSessionFactory.openSession();


    }
}

在这里插入图片描述

编写代码测试

编写pojo类

package com.pojo;

import java.util.Date;

/**
 * Created by JDX on 2021/11/30 9:19
 * 实体类
 */
public class book {
    /**
     * id
     */
    private String bookId;
    /**
     * 书表
     */
    private String bookTable;
    /**
     * 作者
     */
    private String bookAuthor;

    @Override
    public String toString() {
        return "book{" +
                "bookId='" + bookId + '\'' +
                ", bookTable='" + bookTable + '\'' +
                ", bookAuthor='" + bookAuthor + '\'' +
                ", submission=" + submission +
                '}';
    }

    /**
     * 意见 时间
     */
    private Date submission;

    /**
     * 无参构造
     */
    public book() {
    }

    /**
     * 有参构造
     *
     * @param bookId
     * @param bookTable
     * @param bookAuthor
     * @param submission
     */
    public book(String bookId, String bookTable, String bookAuthor, Date submission) {
        this.bookId = bookId;
        this.bookTable = bookTable;
        this.bookAuthor = bookAuthor;
        this.submission = submission;
    }

    public String getBookID() {
        return bookId;
    }

    public void setBookID(String bookID) {
        this.bookId = bookId;
    }

    public String getBookTable() {
        return bookTable;
    }

    public void setBookTable(String bookTable) {
        this.bookTable = bookTable;
    }

    public String getBookAuthor() {
        return bookAuthor;
    }

    public void setBookAuthor(String bookAuthor) {
        this.bookAuthor = bookAuthor;
    }

    public Date getSubmission() {
        return submission;
    }

    public void setSubmission(Date submission) {
        this.submission = submission;
    }
}

在这里插入图片描述

建立Dao接口以及Mapper

package Dao;

import pojo.book;

import java.util.List;

/**
 * Created by JDX on 2021/11/30 9:27
 */
public interface bookDao {
    List<book> getBookList();
}

在这里插入图片描述

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<!--对应Dao层接口-->
<mapper namespace="com.Dao.bookDao">
    <!--编写查询语句
        resultType: 返回结果类型
        resultMap:  返回结果集合
    -->
    <select id="getBookList" resultType="com.pojo.book">
        select *
        from game.book
    </select>
</mapper>

在这里插入图片描述

测试

junit测试: 新建测试类

package com;

import com.Dao.bookDao;
import com.pojo.book;
import com.untis.MybatisUtils;
import org.apache.ibatis.session.SqlSession;
import org.junit.Test;

import java.util.List;

/**
 * Created by JDX on 2021/11/30 10:04
 */
public class bookDaoTest {
    @Test
    public void test() {
        /*第一步: 获得sqlSession对象*/
        SqlSession sqlSession = MybatisUtils.getSqlSession();
        /*执行sql*/
        bookDao mapper = sqlSession.getMapper(bookDao.class);
        List<book> bookList = mapper.getBookList();
        for (book b : bookList) {
            System.out.println(b);
        }
        /*关闭流*/
        sqlSession.close();
    }
}

在这里插入图片描述
记住这个报错:

原因就是没有将mapper.xml注册到 config配置文件中

接下来会报这个错误:

原因: 资源过滤
解决方法:
在pom父工程以及子工程里面添加资源过滤

    <!--在build文件中配置resources,来防止我们资源导出失败-->
    <build>
        <resources>
            <resource>
                <directory>src/main/resources</directory>
                <includes>
                    <include>**/*.properties</include>
                    <include>**/*.xml</include>
                </includes>
                <filtering>true</filtering>
            </resource>
            <resource>
                <directory>src/main/java</directory>
                <includes>
                    <include>**/*.properties</include>
                    <include>**/*.xml</include>
                </includes>
                <filtering>true</filtering>
            </resource>
        </resources>
    </build>

如下图:
在这里插入图片描述
很好接下来我们将会遇到这个报错:
com.sun.org.apache.xerces.internal.impl.io.MalformedByteSequenceException: 1字节的 UTF-8 序列的字节 1 无效
该错误是由一些配置文件引起的：如applicationContext.xml的编码问题；本次错误是 dao.xml 配置文件产生
解决办法:

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

在这里插入图片描述
解决完成上述报错之后运行项目,进行测试:
测试结果如下:

book{bookId='1', bookTable='学习 PHP', bookAuthor='老夫子', submission=Sun Apr 12 00:00:00 CST 2020}
book{bookId='2', bookTable='学习 MySQL', bookAuthor='老夫子', submission=Sun Apr 12 00:00:00 CST 2020}
book{bookId='3', bookTable='学习 Java', bookAuthor='姜子牙', submission=Fri May 01 00:00:00 CST 2015}
book{bookId='4', bookTable='学习 Python', bookAuthor='姜子牙', submission=Sun Mar 06 00:00:00 CST 2016}
book{bookId='5', bookTable='学习 C', bookAuthor='FK', submission=Wed Apr 05 00:00:00 CST 2017}

完成!!!有什么问题可以指出,一同进步!

敏姐儿

关注

2
点赞
踩
1

收藏

觉得还不错? 一键收藏
打赏
0
评论
创建MyBatis程序

环境搭建CREATE TABLE `book` ( `book_id` int(11) NOT NULL AUTO_INCREMENT, `book_table` varchar(100) NOT NULL, `book_author` varchar(40) NOT NULL, `submission_date` date DEFAULT NULL, PRIMARY KEY (`book_id`)) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CH
复制链接

扫一扫