Maven项目以注解方式配置Mybatis

配置pom.xml依赖

    <!-- mybatis maven环境搭建 -->
    <dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis</artifactId>
      <version>3.4.5</version>
    </dependency>

    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>8.0.15</version>
    </dependency>


    <dependency>
      <groupId>log4j</groupId>
      <artifactId>log4j</artifactId>
      <version>1.2.12</version>
    </dependency>

创建实体类和dao的接口

package com.mybatis.pojo.User.java

package com.mybatis.pojo;

import java.io.Serializable;

/**
 * Created by Zhao Wen on 2020/10/17
 */

public class User implements Serializable {
    private String user_id;
    private String user_num;
    private String user_name;
    private String password;
    private String phone;
    private String rolo_id;

    public User(String user_id, String user_num, String user_name, String password, String phone, String rolo_id) {
        this.user_id = user_id;
        this.user_num = user_num;
        this.user_name = user_name;
        this.password = password;
        this.phone = phone;
        this.rolo_id = rolo_id;
    }

    public String getUser_id() {
        return user_id;
    }

    public void setUser_id(String user_id) {
        this.user_id = user_id;
    }

    public String getUser_num() {
        return user_num;
    }

    public void setUser_num(String user_num) {
        this.user_num = user_num;
    }

    public String getUser_name() {
        return user_name;
    }

    public void setUser_name(String user_name) {
        this.user_name = user_name;
    }

    public String getPassword() {
        return password;
    }

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

    public String getPhone() {
        return phone;
    }

    public void setPhone(String phone) {
        this.phone = phone;
    }

    public String getRolo_id() {
        return rolo_id;
    }

    public void setRolo_id(String rolo_id) {
        this.rolo_id = rolo_id;
    }
}

package com.mybatis.dao.impl.IUserDao.Impl.java

package mybatis.dao.impl;


import mybatis.pojo.User;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * Created by Zhao Wen on 2020/10/17
 */

public interface IUserDao {
    /**
     * 查询所有操作
     * @return
     */
    @Select("select * from user")
    List<User> findAll();
}

创建Mybatis的主配置文件 - 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">

<configuration>
    <!-- 配置环境 -->
    <environments default="mysql">
        <!--配置mysql的环境-->
        <environment id="">
            <!-- 配置事务的类型 -->
            <transactionManager type="JDBC"></transactionManager>
            <!-- 配置数据源（连接池）-->
            <dataSource type="POOLED">
                <!-- 配置连接数据库的4个基本信息 -->
                <property name="driver" value="com.mysql.jdbc.Driver" />
                <property name="url" value="jdbc:mysql://localhost:3306/sams"/>
                <property name="username" value="root"/>
                <property name="password" value="666666"/>
            </dataSource>
        </environment>
    </environments>

    <!-- 使用注解配置，此处使用class属性执行被注解的dao全限定类名 -->
    <mappers>
        <mapper class="com.mybatis.dao.impl.IUserDao"/>
    </mappers>
</configuration>

项目目录

环境搭建注意事项

1. 不要忘记在映射配置中告知mybatis要封装到哪个实体类中
2. 配置的方式：指定实体类的全限定类名