MyBatis的环境搭建

最新推荐文章于 2024-08-22 20:07:38 发布

fdh0311

最新推荐文章于 2024-08-22 20:07:38 发布

阅读量71

点赞数

本文链接：https://blog.csdn.net/weixin_45398105/article/details/103657473

版权

一、概念

MyBatis是一个基于Java的持久层框架。

MyBatis可以使用简单的XML或注解用于配置和原始映射，将接口和Java的POJO（Plain Old Java Objects，普通的Java对象）映射成数据库中的记录。

Mybatis提供一种“半自动化”的ORM（Object Ralation Mapping 对象关系映射）实现，需要手动写SQL，后期可以逆向工程(可以使用工具自动生成SQL)！

二、IDE安装MyBatis插件

步骤：File—>Settings—>Plugins—>搜索Mybatis plugin—>免费下载安装插件—>重启IDE。

三、在IDE中搭建MyBatis环境

1、新建工程

（1）新建一个maven空工程

（2）新建Mybatis项目Module

2、准备数据库

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `t_user`
-- ----------------------------
DROP TABLE IF EXISTS `t_user`;
CREATE TABLE `t_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(32) NOT NULL COMMENT '用户名称',
  `birthday` date DEFAULT NULL COMMENT '生日',
  `sex` char(1) DEFAULT NULL COMMENT '性别',
  `address` varchar(256) DEFAULT NULL COMMENT '地址',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_user
-- ----------------------------
INSERT INTO `t_user` VALUES ('1', '王五', '2018-09-06', '1', '四川成都');
INSERT INTO `t_user` VALUES ('2', '张三', '2014-07-10', '1', '北京市');
INSERT INTO `t_user` VALUES ('3', '李四', '2018-09-06', '1', '河南郑州');
INSERT INTO `t_user` VALUES ('4', '小明', '2018-09-05', '1', '河南郑州');
INSERT INTO `t_user` VALUES ('5', '张三2', '2018-09-13', '1', '河南郑州');
INSERT INTO `t_user` VALUES ('6', '小明2', '2018-09-12', '1', '河南郑州');
INSERT INTO `t_user` VALUES ('7', '王五2', '2018-09-05', '1', '河南郑州');

3、搭建环境

（1）导入Mybatis所需依赖

   <!--导入MyBatis开发环境的依赖-->
    <dependencies>

        <!-- myBatis -->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.4.5</version>
        </dependency>

        <!-- mysql驱动包(版本与本地mysql版本有关) -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.38</version>
        </dependency>

        <!-- Junit测试 -->
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.12</version>
        </dependency>

        <!--Log4J日志工具  打印运行日志用的！-->
        <dependency>
            <groupId>log4j</groupId>
            <artifactId>log4j</artifactId>
            <version>1.2.14</version>
        </dependency>
        
        <!--JavaBean中注解@Data生成get、set方法-->
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <version>1.18.8</version>
            <scope>provided</scope>
        </dependency>

    </dependencies>

    <!--如果是WEB项目，那么不用创建bulid标签-->
    <build>
        <!--编译的时候同时也把包下面的xml同时编译进去-->
        <resources>
            <resource>
                <directory>src/main/java</directory>
                <includes>
                    <include>**/*.xml</include>
                </includes>
            </resource>
        </resources>
    </build>

（2）核心配置文件

resource

jdbc.properties

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://127.0.0.1:3306/mybatis
jdbc.username=root
jdbc.password=root

log4j.properties

log4j.rootLogger=DEBUG, Console 
log4j.appender.Console=org.apache.log4j.ConsoleAppender  
log4j.appender.Console.layout=org.apache.log4j.PatternLayout  
log4j.appender.Console.layout.ConversionPattern=%d [%t] %-5p [%c] - %m%n  

log4j.logger.java.sql.ResultSet=INFO  
log4j.logger.org.apache=INFO  
log4j.logger.java.sql.Connection=DEBUG  
log4j.logger.java.sql.Statement=DEBUG  
log4j.logger.java.sql.PreparedStatement=DEBUG

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">
<configuration>
    <!-- 引入外部配置文件 -->
    <properties resource="jdbc.properties"/>
    <!--实体类取别名(必须放在properties之后)-->
    <typeAliases>
        <!--直接给所有的实体类取别名。默认的实体类的别名就是类名(不区分小大写)
           User实体类：User、user、USER
       -->
        <package name="com.fdh.pojo"/>
    </typeAliases>
    <!-- 环境 -->
    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"></transactionManager>
            <dataSource type="POOLED">
                <property name="driver" value="${jdbc.driver}"/>
                <property name="url" value="${jdbc.url}"/>
                <property name="username" value="${jdbc.username}"/>
                <property name="password" value="${jdbc.password}"/>
            </dataSource>
        </environment>
    </environments>

    <!--映射Mapper文件-->
    <!--引入映射文件-->
    <mappers>
        <mapper resource="com/fdh/mapper/UserMapper.xml"></mapper>
    </mappers>
</configuration>

（3）实体类

package com.fdh.pojo;

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

import java.util.Date;

@NoArgsConstructor
@AllArgsConstructor
@Data
public class User {
    private Integer id;
    private String username;
    private Date birthday;
    private String sex;
    private String address;
}

（4）mapper层

接口

package com.fdh.mapper;

import com.fdh.pojo.User;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface UserMapper {
    List<User> findUsers();
    //加注解
    List<User> selectUsersByPage(@Param("offSet") int offSet, @Param("pageSize") int pageSize, @Param("username") String username);

}

实现类.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.fdh.mapper.UserMapper">

    <!-- 返回值类型 -->
    <select id="findUsers" resultType="User">
       select id,username,birthday,sex,address from t_user
    </select>

    <!--加注解-->
    <select id="selectUsersByPage" resultType="User">
         select id,username,birthday,sex,address from t_user where username like #{username} limit #{offSet},#{pageSize}
    </select>

</mapper>

（5）工具类

package com.fdh.utils;

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;

public class MyBatisUtils {

    /**
     * 01-获取SqlSession
     * @return
     */
    public static SqlSession getSession(){
        SqlSession session=null;
        InputStream inputStream=null;
        try {
            //配置文件的路径
            String resource = "mybatis-config.xml";
            //加载配置文件，得到一个输入流
            inputStream = Resources.getResourceAsStream(resource);
            //获取MyBatis的Session工厂
            SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
            //通过session工厂获取到一个session (此session非Servlet中Session，这个Session表示MyBatis框架和数据库的会话信息)
            //获取到session就表示MyBatis连接上数据库啦！！类似于JDBC中 Connection对象
            session = sqlSessionFactory.openSession(true);//自动提交事务
            //调用session的查询集合方法
            return session;
        } catch (IOException e) {
            e.printStackTrace();
        }finally {
            try {
                inputStream.close();
            } catch (IOException e) {
                e.printStackTrace();
            }
        }
        return null;
    }

    /**
     * 02-关闭SqlSession
     * @param session
     */
    public static void closeSession(SqlSession session){
        if(session!=null){
            session.close();
        }
    }
}

（4）测试类

import com.fdh.pojo.User;
import com.fdh.mapper.UserMapper;
import com.fdh.utils.MyBatisUtils;
import org.apache.ibatis.session.SqlSession;
import org.junit.After;
import org.junit.Before;
import org.junit.Test;

import java.util.Date;
import java.util.List;

public class TestMyBatis {
    SqlSession sqlSession=null;
    UserMapper userMapper =null;

    @Before
    public void init(){
        sqlSession= MyBatisUtils.getSession();
        userMapper = sqlSession.getMapper(UserMapper.class);
    }

    @Test
    public void findUsersTest(){
        List<User> users = userMapper.findUsers();
        for (User user:users) {
            System.out.println(user);
        }
    }

    @Test
    public void selectUsersByPageTest(){
        List<User> users = userMapper.selectUsersByPage(1,2,"%小%");
        for (User user:users) {
            System.out.println(user);
        }
    }

    @After
    public void destroy(){
        MyBatisUtils.closeSession(sqlSession);
    }
}