第一个Mybatis程序

Mybatis

1、配置资源 mybatis-config.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="development">
        <environment id="development">
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <property name="driver" value="com.mysql.cj.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql://localhost:3306/studentmanagers?useUnicode=utf8&amp;characterEncoding=utf8&amp;useSSL=false&amp;serverTimezone=GMT%2B8"/>
                <property name="username" value="root"/>
                <property name="password" value="root"/>
            </dataSource>
        </environment>
    </environments>
    
    
<!--  //注册MAPPer-->
    <mappers>
<!--&lt;!&ndash;        <mapper resource="org/mybatis/example/BlogMapper.xml"/>&ndash;&gt;//注册MAPPer-->
        <mapper resource="com/bo/DAO/UserMapper.xml"/>
    </mappers>
     
</configuration>

​

 

2、编写Mybatis 工具 mybatisUtils

public class mybatisUtils {
    //SqlSessionFactory -->SqlSession
        private static SqlSessionFactory sqlSessionFactory;
        static {
​
            try {
                //使用Mybaties第一步：获取sqlSessionFactory对象
                String resource = "mybatis-config.xml";
                InputStream inputStream = Resources.getResourceAsStream(resource);
                sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
            } catch (Exception e) {
                e.printStackTrace();
            }
        }
​
        //既然有了 SqlSessionFactory，顾名思义，我们可以从中获得 SqlSession 的实例。
        // SqlSession 提供了在数据库执行 SQL 命令所需的所有方法。你可以通过 SqlSession 实例来直接执行已映射的 SQL 语句。
        public static SqlSession getSqlSession(){
//        SqlSession sqlSession =  sqlSessionFactory.openSession();
//        return sqlSession;
            return sqlSessionFactory.openSession();
        }
​
​
}

3、编写实体类 User

package com.bo.POJO;
​
public class User {
    private int id;
    private String Username;
    private  String Password;
    private String Email;
​
    public User() {
    }
​
    public User(int id, String username, String password, String email) {
        this.id = id;
        Username = username;
        Password = password;
        Email = email;
    }
​
    public int getId() {
        return id;
    }
​
    public void setId(int id) {
        this.id = id;
    }
​
    public String getUsername() {
        return Username;
    }
​
    public void setUsername(String username) {
        Username = username;
    }
​
    public String getPassword() {
        return Password;
    }
​
    public void setPassword(String password) {
        Password = password;
    }
​
    public String getEmail() {
        return Email;
    }
​
    public void setEmail(String email) {
        Email = email;
    }
​
    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", Username='" + Username + '\'' +
                ", Password='" + Password + '\'' +
                ", Email='" + Email + '\'' +
                '}';
    }
}

4、编写DAO接口UserDao

public interface UserDao {
    List<User> getUserList();
​
}

5、编写接口实现 UserMapper.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.bo.DAO.UserDao">
    <select id="getUserList" resultType="com.bo.POJO.User">
           select * from user
    </select>
</mapper>

6、注册Mapper 在第一步配置文件中注册。

7、Test UserDaoTest

public class UserDaoTest {
    @Test
    public void test(){
        SqlSession sqlSession = mybatisUtils.getSqlSession();
        UserDao mapper = sqlSession.getMapper(UserDao.class);
        List<User> userList = mapper.getUserList();
        for (User user : userList) {
            System.out.println(user);
        }
        sqlSession.close();
    }
}
​

8、注意问题：

• org.apache.ibatis.binding.BindingException: Type interface com.bo.dao.UserDao is not known to the MapperRegistry.

  解决问题：注册mapper

• 在build中配置resources，来防止我们资源导出失败的问题-->pom.xml添上以下代码即可

<!--在build中配置resources，来防止我们资源导出失败的问题-->
    <build>
        <resources>
            <resource>
                <directory>src/main/resources</directory>
                <includes>
                    <include>**/*.properties</include>
                    <include>**/*.xml</include>
                </includes>
            </resource>
            <resource>
                <directory>src/main/java</directory>
                <includes>
                    <include>**/*.properties</include>
                    <include>**/*.xml</include>
                </includes>
                <filtering>true</filtering>
            </resource>
        </resources>
    </build>

整体文件图：