MyBatis入门

直接开干，无废话

1. 新建项目 Mybatis_quick 略过步骤，请看之前的文章

 

2. pom.xml 引用包

​

<dependencies>
    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>8.0.22</version>
    </dependency>
    <dependency>
        <groupId>org.mybatis</groupId>
        <artifactId>mybatis</artifactId>
        <version>3.5.6</version>
    </dependency>
    <dependency>
        <groupId>junit</groupId>
        <artifactId>junit</artifactId>
        <version>4.12</version>
        <scope>test</scope>
    </dependency>
    <dependency>
        <groupId>log4j</groupId>
        <artifactId>log4j</artifactId>
        <version>1.2.14</version>
    </dependency>
</dependencies>

​3. 创建实体类

package com.hhm.domain;

public class User {
    private int id;
    private String username;

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

    private String password;

    public int getId() {
        return id;
    }

    public void setId(int 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;
    }
}

4. 创建数据库表,MySql数据库，如果不行，请自行创建

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(30) DEFAULT NULL,
  `password` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('1', 'zhangsan', '123');
INSERT INTO `user` VALUES ('2', 'lisi', '123');
INSERT INTO `user` VALUES ('3', 'lucy', '888');

 

5. 创建核心配置文件 sqlMapConfig.xml 在 resources

<?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>
    <!--定义一下类型的别名,以便在Mapper.xml中直接可以使用 user-->
    <typeAliases>
        <typeAlias type="com.hhm.domain.User" alias="user"></typeAlias>
    </typeAliases>
    <!--数据源环境-->
    <environments default="developement">
        <environment id="developement">
            <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/test?useSSL=false&amp;useUnicode=true&amp;characterEncoding=UTF-8&amp;serverTimezone=Asia/Shanghai&amp;zeroDateTimeBehavior=convertToNull&amp;autoReconnect=true"/>
                <property name="username" value="root"/>
                <property name="password" value="123456"/>

            </dataSource>
        </environment>
    </environments>
    <!--指定mapper.xml 存放sql语句-->
    <mappers>
        <mapper resource="com\hhm\mapper\UserMapper.xml"></mapper>
    </mappers>
</configuration>

 

6. 创建sql映射文件 UserMapper.xml 在 resources下com/hhm/mapper/

里面定义了要执行的sql语句

<?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="userMapper">
    <select id="findAll" resultType="com.hhm.domain.User">
        SELECT * FROM user
    </select>
    <insert id="add" parameterType="com.hhm.domain.User">
        INSERT INTO user VALUES (#{id},#{username},#{password})
    </insert>
    <update id="update" parameterType="com.hhm.domain.User">
        UPDATE user SET username=#{username},password=#{password} WHERE id = #{id}
    </update>
    <delete id="delete" parameterType="java.lang.Integer">
        DELETE FROM user WHERE id=#{id}
    </delete>
    <select id="findById" parameterType="int" resultType="user">
        SELECT * FROM user WHERE id = #{id}
    </select>
</mapper>

 

这边的 namespace="userMapper" 可以随意取名字

这边定义了最基本的增删改查的语句

resultType 表示返回的类型，这边需要指定全包名，除非在 sqlMapConfig.xml 为全包名指定了别名

例如这边指定 <typeAlias type="com.hhm.domain.User" alias="user"></typeAlias>

 

parameterType="int" 指定了传入参数的类型

其中参数的定义为 #{username} username需要与传入类型的属性名一致

 

id="findAll" 这里的id需要唯一，调用的时候需要用到

 

7. 调用测试

创建测试类 com.hhm.test.MyBatisTest

完整代码如下：

package com.hhm.test;

import com.hhm.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.Test;

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

public class MyBatisTest {

    /*
    查询方法
     */
    @Test
    public void test1() throws IOException {
        //获得核心配置文件
        InputStream resourceAsStream = Resources.getResourceAsStream("sqlMapConfig.xml");
        //获得session工厂对象
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(resourceAsStream);
        //获取session会话对象
        SqlSession sqlSession = sqlSessionFactory.openSession();
        //执行操作 参数：namespace_id
        List<User> userList = sqlSession.selectList("userMapper.findAll");
        sqlSession.close();
        //打印数据
        System.out.println(userList);

    }

    /*
        新增方法
     */
    @Test
    public void test2() throws IOException {
        InputStream resourceAsStream = Resources.getResourceAsStream("sqlMapConfig.xml");
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(resourceAsStream);
        SqlSession sqlSession = sqlSessionFactory.openSession();
        User user = new User();
        user.setUsername("tom");
        user.setPassword("abc");
        sqlSession.insert("userMapper.add",user);
        sqlSession.commit();
        sqlSession.close();
    }

    /*
    修改方法
     */
    @Test
    public void test3() throws IOException {
        InputStream resourceAsStream = Resources.getResourceAsStream("sqlMapConfig.xml");
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(resourceAsStream);
        SqlSession sqlSession = sqlSessionFactory.openSession(true);//这边为true，则表示会自动提交，不需要自行调用 sqlSession.commit();
        User user = new User();
        user.setId(3);
        user.setUsername("lucy");
        user.setPassword("999");
        int update = sqlSession.update("userMapper.update",user);
        //sqlSession.commit();
        sqlSession.close();
        System.out.println("更新条目："+update);
    }

    @Test
    public void test4() throws IOException {
        InputStream resourceAsStream = Resources.getResourceAsStream("sqlMapConfig.xml");
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(resourceAsStream);
        SqlSession sqlSession = sqlSessionFactory.openSession();
        int delete = sqlSession.delete("userMapper.delete", 5);
        sqlSession.commit();
        sqlSession.close();
        System.out.println("删除条目："+delete);
    }

    @Test
    public void test5() throws IOException {
        InputStream resourceAsStream = Resources.getResourceAsStream("sqlMapConfig.xml");
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(resourceAsStream);
        SqlSession sqlSession = sqlSessionFactory.openSession();
        User user = sqlSession.selectOne("userMapper.findById", 2);
        sqlSession.close();
        System.out.println(user);
    }
}

 

 

8. 完整项目截图