maven项目创建MyBatis教程

先创建一个新的maven项目

然后把配置文件放pom.xml中在刷新导入

  
        
            mysql
            mysql-connector-java
            5.1.38

        
        
            org.mybatis
            mybatis
            3.5.1
        
        
            org.slf4j
            slf4j-api
            1.7.30

全选后创建好四个文件

创建mybatis-config配置文件文件内容

创建测速数据库


SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for sss
-- ----------------------------
DROP TABLE IF EXISTS `sss`;
CREATE TABLE `sss`  (
  `ids` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `orderdate` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `cost` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sss
-- ----------------------------
INSERT INTO `sss` VALUES ('1', 'jack', '2020-01-12', '30');
INSERT INTO `sss` VALUES ('2', 'rose', '2020-01-12', '40');
INSERT INTO `sss` VALUES ('3', 'tom', '2020-01-12', '50');
INSERT INTO `sss` VALUES ('4', 'tom', '2020-01-22', '60');
INSERT INTO `sss` VALUES ('5', 'jack', '2020-02-12', '70');
INSERT INTO `sss` VALUES ('6', 'jack', '2020-01-10', '70');

SET FOREIGN_KEY_CHECKS = 1;

创建实体类

package com.mybatis.pojo;

public class User {
    private String ids;
    private String name;
    private String orderdate;
    private String cost;

    @Override
    public String toString() {
        return "User{" +
                "ids='" + ids + ''' +
                ", name='" + name + ''' +
                ", orderdate='" + orderdate + ''' +
                ", cost='" + cost + ''' +
                '}';
    }

    public String getIds() {
        return ids;
    }

    public void setIds(String ids) {
        this.ids = ids;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getOrderdate() {
        return orderdate;
    }

    public void setOrderdate(String orderdate) {
        this.orderdate = orderdate;
    }

    public String getCost() {
        return cost;
    }

    public void setCost(String cost) {
        this.cost = cost;
    }
}

创建mapper接口

##创建MyBatis映射文件

创建mappers文件夹专门用来存放配置文件

名字和map接口名字保持一致写入映射文件




    
        insert into sss values(null,'admin','2020-01-12','200')

namespace的值跟mapper接口的路径一致

id 是sql语句的唯一标识
映射文件中Sql语句的id要和mapper接口中的方法名保持一致
当他调用接口的时候就可以通过map接口中的全类名找到映射文件
然后在通过匹配的方法名找到匹配的ID sql语句

引入配置文件修改映射文件为mappers中的路径

测试功能

package com.mybatis.pojo.Action;

import com.mybatis.pojo.mapper.UserMapper;
import com.mybatis.pojo.model.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 javax.annotation.Resource;
import java.io.IOException;
import java.io.InputStream;

public class MyBatis {
    public static void main(String[] args) throws IOException {
        //加载核心配置文件
        //通过字节输入流来获取
        InputStream resourceAsStream = Resources.getResourceAsStream("mybatis-config.xml");
        SqlSessionFactoryBuilder sqlSessionFactoryBuilder = new SqlSessionFactoryBuilder();
        SqlSessionFactory sqlsessionfactory = sqlSessionFactoryBuilder.build(resourceAsStream);
        //获取操作数据库的会话对象,代码java和数据库之间的会话
        SqlSession sqlSession = sqlsessionfactory.openSession();
        //获取mapper接口对象
        //返回一个接口对应的实现类的对象
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);
    
        //测试功能
        int result = mapper.insertUser();
        System.out.println(result);
            //提交事务
        sqlSession.commit();
        sqlSession.close();


    }
}

maven项目创建MyBatis教程

Java相关栏目本月热门文章