MyBatis学习——基础配置和初次使用

最新推荐文章于 2022-07-28 19:21:14 发布

楠十三

最新推荐文章于 2022-07-28 19:21:14 发布

阅读量289

点赞数 1

分类专栏： MyBatis 文章标签：数据库 mybatis mysql java jdbc

本文链接：https://blog.csdn.net/L_ZG_/article/details/105868803

版权

MyBatis 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

基础配置

加jar包

maven工程中pom.xml设置


    <dependencies>
    	<!-- MyBatis依赖包，必须 -->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.5.4</version>
        </dependency>
        <!-- 数据库连接包，必须 -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.18</version>
        </dependency>
        <!-- 日志工具包，不必须 -->
        <dependency>
            <groupId>log4j</groupId>
            <artifactId>log4j</artifactId>
            <version>1.2.17</version>
        </dependency>
        <!-- 测试工具包，不必须 -->
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.13</version>
            <scope>test</scope>
        </dependency>
    </dependencies>

创建MyBatis系统的核心设置文件——xml文件

在src主目录下的resources资源目录中
创建SqlMapConfig.xml文件，名字自取

基础配置内容


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

<!--mybatis的主配置文件-->
<configuration>
<!--    配置环境-->
    <environments default="mysql">
<!--        配置mysql环境-->
        <environment id="mysql">
<!--            配置事务类型-->
            <transactionManager type="JDBC"></transactionManager>
<!--            配置数据源（连接池）-->
            <dataSource type="POOLED">
<!--                配置连接数据库的4个基本信息-->
                <property name="driver" value="com.mysql.cj.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql://localhost:3306/数据库名?serverTimezone=UTC"/>
                <property name="username" value="数据库账户"/>
                <property name="password" value="数据库密码"/>
            </dataSource>
        </environment>
    </environments>

<!--    指定映射配置文件的位置，映射配置文件指的是每个dao独立的配置文件-->
    <mappers>
        <mapper resource="com/wenshuya/dao/IUserDao.xml"/>
    </mappers>
</configuration>

在上文件中配置了两项内容

1.数据库的连接
<environments>
2.指定映射文件的位置
<mappers>

所谓映射文件就是存放对应sql语句的地方。若使用注释进行相关操作的话就可以取消映射配置文件。

创建映射配置文件

在主配置文件的同级文件里创建想要放置文件的路径com/wenshuya/dao/，在该路径下创建映射xml文件IUserDao.xml。

映射文件中的设置


<?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">
<mapper namespace="com.wenshuya.dao.IUserDao">
	<!-- 查询语句 -->
	<select id="findAll" resultType="com.wenshuya.domain.User">
        select * from user
    </select>
</mapper>

创建数据库中对应的类

sql数据库的user表
在这里插入图片描述
在src的com.wenshuya.domain路径下创建User类


package com.wenshuya.domain;

import java.io.Serializable;
import java.util.Date;

public class User implements Serializable {
    private Integer id;
    private String username;
    private String sex;
    private String address;
    private Date birthday;

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public String getSex() {
        return sex;
    }

    public void setSex(String sex) {
        this.sex = sex;
    }

    public String getAddress() {
        return address;
    }

    public void setAddress(String address) {
        this.address = address;
    }

    public Date getBirthday() {
        return birthday;
    }

    public void setBirthday(Date birthday) {
        this.birthday = birthday;
    }

	@Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", username='" + username + '\'' +
                ", sex='" + sex + '\'' +
                ", address='" + address + '\'' +
                ", birthday=" + birthday +
                '}';
    }
}

创建数据库的操作的接口

在src下的com.wenshuya.dao路径下创建IUserDao接口


package com.wenshuya.dao;

import com.wenshuya.domain.QueryVo;
import com.wenshuya.domain.User;

import java.util.List;

/*
* 用户的持久层接口
* */
public interface IUserDao {

    /*
    * 查询所有操作
    * @return
    * */
    List<User> findAll();

}

测试查询结果

在test文件下创建com.wenshuya.test包，在此包下创建 MybatisTest测试类


package com.wenshuya.test;

import com.wenshuya.dao.IUserDao;
import com.wenshuya.domain.User;
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 org.junit.After;
import org.junit.Before;
import org.junit.Test;

import java.io.InputStream;
import java.util.List;

public class MybatisTest {

    private InputStream in;
    private SqlSessionFactoryBuilder builder;
    private SqlSessionFactory factory;
    private SqlSession session;
    private IUserDao userDao;

    @Before//用于测试方法执行之前执行
    public void init() throws Exception{
//        1.读取配置文件
        in = Resources.getResourceAsStream("SqlMapConfig.xml");
//        2.创建SqlSessionFactory工厂
        builder = new SqlSessionFactoryBuilder();
        factory = builder.build(in);
//        3.使用生产一个SqlSession对象
        session = factory.openSession();
//        4.使用SqlSession创建Dao接口的代理对象
        userDao = session.getMapper(IUserDao.class);
    }

    @After//用于在测试方法执行之后执行
    public void destroy() throws Exception{

//        6.提交事务
        session.commit();
//        7.释放资源
        session.close();
        in.close();
    }

    /*
    * 入门案例
    * */
    @Test
    public void testFindAll() throws Exception{
//        5.使用代理对象执行方法
        List<User> users = userDao.findAll();
        for (User user : users){
            System.out.println(user);
        }
    }
}

运行结果


2020-04-30 21:06:01,529 0      [           main] DEBUG ache.ibatis.logging.LogFactory  - Logging initialized using 'class org.apache.ibatis.logging.log4j.Log4jImpl' adapter.
2020-04-30 21:06:01,553 24     [           main] DEBUG source.pooled.PooledDataSource  - PooledDataSource forcefully closed/removed all connections.
2020-04-30 21:06:01,553 24     [           main] DEBUG source.pooled.PooledDataSource  - PooledDataSource forcefully closed/removed all connections.
2020-04-30 21:06:01,553 24     [           main] DEBUG source.pooled.PooledDataSource  - PooledDataSource forcefully closed/removed all connections.
2020-04-30 21:06:01,553 24     [           main] DEBUG source.pooled.PooledDataSource  - PooledDataSource forcefully closed/removed all connections.
2020-04-30 21:06:01,662 133    [           main] DEBUG ansaction.jdbc.JdbcTransaction  - Opening JDBC Connection
2020-04-30 21:06:02,825 1296   [           main] DEBUG source.pooled.PooledDataSource  - Created connection 1064154107.
2020-04-30 21:06:02,826 1297   [           main] DEBUG ansaction.jdbc.JdbcTransaction  - Setting autocommit to false on JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@3f6db3fb]
2020-04-30 21:06:02,830 1301   [           main] DEBUG .wenshuya.dao.IUserDao.findAll  - ==>  Preparing: select * from user 
2020-04-30 21:06:02,880 1351   [           main] DEBUG .wenshuya.dao.IUserDao.findAll  - ==> Parameters: 
2020-04-30 21:06:02,915 1386   [           main] DEBUG .wenshuya.dao.IUserDao.findAll  - <==      Total: 8
User{id=41, username='老王', sex='男', address='北京', birthday=Wed Feb 28 01:47:08 CST 2018}
User{id=42, username='小二王', sex='女', address='北京金燕龙', birthday=Fri Mar 02 23:09:37 CST 2018}
User{id=43, username='小二王', sex='女', address='北京金燕龙', birthday=Sun Mar 04 19:34:34 CST 2018}
User{id=45, username='传智播客', sex='男', address='北京金燕龙', birthday=Sun Mar 04 20:04:06 CST 2018}
User{id=46, username='老王', sex='男', address='北京', birthday=Thu Mar 08 01:37:26 CST 2018}
User{id=48, username='小马宝莉', sex='女', address='北京修正', birthday=Thu Mar 08 19:44:00 CST 2018}
User{id=49, username='云中君', sex='男', address='河南省郑州市', birthday=Thu Sep 19 08:00:00 CST 2019}
User{id=64, username='云中君', sex='男', address='河南省郑州市', birthday=Thu Sep 19 08:00:00 CST 2019}
2020-04-30 21:06:02,937 1408   [           main] DEBUG ansaction.jdbc.JdbcTransaction  - Resetting autocommit to true on JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@3f6db3fb]
2020-04-30 21:06:02,938 1409   [           main] DEBUG ansaction.jdbc.JdbcTransaction  - Closing JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@3f6db3fb]
2020-04-30 21:06:02,938 1409   [           main] DEBUG source.pooled.PooledDataSource  - Returned connection 1064154107 to pool.

出现此结果就说明运行成功。

下一部分：SqlSession等语句介绍
 MyBatis主页

楠十三

关注

1
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
MyBatis学习——基础配置和初次使用

基础配置加jar包maven工程中pom.xml设置 <dependencies>  <dependency> <groupId>org.mybatis</groupId> <artifactId&gt...
复制链接

扫一扫