JDBC对比MyBatis

JDBC与MyBatis操作数据库

JDBC操作数据库

JDBC操作数据库详细说明

一、导入jar包

1.1 下载jar包（jdbc）

mysql官网，下载驱动

1.2 下载jar包（druid）

仓库，下载驱动

1.3 安装驱动

新建项目→新建lib文件夹→解压jar包到lib文件夹


两个jar包导入后

二、操作数据库

2.1 建表

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `tb_user`
-- ----------------------------
DROP TABLE IF EXISTS `tb_user`;
CREATE TABLE `tb_user` (
  `id` int NOT NULL AUTO_INCREMENT,
  `username` varchar(20) DEFAULT NULL,
  `password` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of tb_user
-- ----------------------------
INSERT INTO `tb_user` VALUES ('2', '小小红', '234');
INSERT INTO `tb_user` VALUES ('3', 'www', '123');
INSERT INTO `tb_user` VALUES ('4', 'OOO', '123');
INSERT INTO `tb_user` VALUES ('5', 'XM', '123');
INSERT INTO `tb_user` VALUES ('6', '小红', '234');

2.2 实体类

package com.xxxIt.pojo;

public class User {

    private Integer id;
    private String username;
    private String password;

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

    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 getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }
}

2.3 druid.properties

# druid.properties文件的配置
driverClassName=com.mysql.cj.jdbc.Driver
url=jdbc:mysql://127.0.0.1:3306/db1
username=root
password=root
# 初始化连接数量
initialSize=5
# 最大连接数
maxActive=10
# 最大超时时间
maxWait=3000

JdbcDruidDemo

package xxxIt;

import com.alibaba.druid.pool.DruidDataSourceFactory;
import main.java.xxxIt.pojo.User;

import javax.sql.DataSource;
import java.io.FileInputStream;
import java.sql.*;
import java.util.Properties;

// 使用预编译的方式
public class JdbcDemo {
    public static void main(String[] args) throws Exception {

        // 导入druid配置文件（druid帮我们做了jdbc导入）
        Properties Pp = new Properties();
        Pp.load(new FileInputStream("src/main/Resource/druid.properties"));

        // 新建数据库连接池
        DataSource dataSource = DruidDataSourceFactory.createDataSource(Pp);

        // 获取数据库连接
        Connection conn = dataSource.getConnection();

        // 定义sql语句，采用预编译的方式
        String sql = "select * from tb_user where id = ?";

        // 获取PrepareStatem对象
        PreparedStatement ps = conn.prepareStatement(sql);

        // 传入参数(模仿参数)(sql语句中第几个问好，传入的参数)
        ps.setInt(1,2);

        // 执行sql
        ResultSet resultSet = ps.executeQuery();

        // 输出结果
        User user = new User();
        while (resultSet.next()){
            int id = resultSet.getInt(1);
            String username = resultSet.getString(2);
            String password = resultSet.getString(3);
            user.setId(id);
            user.setUsername(username);
            user.setPassword(password);
        }
        System.out.println(user);

        // 释放资源
        resultSet.close();
        ps.close();
        conn.close();
    }
}

MyBatis操作数据库

在上面的操作加上mybatis jar包，dao层，数据库连接池池, 测试类
mybatis jar包

数据库连接池类

package com.xxxIt;

import com.alibaba.druid.pool.DruidDataSource;
import org.apache.ibatis.datasource.pooled.PooledDataSourceFactory;

public class DruidDataSourceFactory extends PooledDataSourceFactory {

    public DruidDataSourceFactory() {
        this.dataSource = new DruidDataSource();
    }
}

MyBatis配置文件

<?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="druid.properties"/>

    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"/>
            <dataSource type="com.xxxIt.DruidDataSourceFactory">			<!--修改数据库连接池-->

                <!--数据库的连接信息-->
                <property name="driverClass" value="${driverClassName}"/>
                <property name="url" value="${url}"/>
                <property name="username" value="${username}"/>
                <property name="password" value="${password}"/>
            </dataSource>
        </environment>
    </environments>

    <!--sql映射文件路径-->
    <mappers>
<!--        <package name="main.java.com.xxxIt.dao.UserMapper"/>-->
        <mapper class="com.xxxIt.dao.UserMapper"/>
    </mappers>
</configuration>

dao mapper代理操作数据库

package com.xxxIt.dao;

import com.xxxIt.pojo.User;
import org.apache.ibatis.annotations.Select;

public interface UserMapper {

    // 使用代理开发，注解开发
    @Select("select * from tb_user where id = #{id}")
    public User selectById(Integer id);

}

MyBatisDruidDemo

package com.xxxIt;

import com.xxxIt.pojo.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 com.xxxIt.dao.UserMapper;

import java.io.InputStream;

public class MyBatisDemo {

    public static void main(String[] args) throws Exception {
        // 1 加载mybatis核心配置文件，获取sqlsessionFactory
        String resource = "mybatis-config.xml";
        InputStream inputStream = Resources.getResourceAsStream(resource);
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);

        // 2 获取sqlSession对象
        SqlSession sqlSession = sqlSessionFactory.openSession();

        // 3 执行userMapper对象
        UserMapper userMapper = sqlSession.getMapper(UserMapper.class);

        // 4 执行sql语句
        User user = userMapper.selectById(3);

        // 5 输出结果
        System.out.println(user);
    }

}