mybatis入门配置

概述

什么是mybatis请自行搜索，这篇文章是入门级配置。如果是学过Hibernate框架的话，学起来会更加轻松。

项目基本结构

1.mybatisconfig.xml配置文件
2.mapper.xml配置文件（
3.po类（对应表）
4.代理接口

1.mybatisconfig.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.jdbc.Driver"/>
<!-- 数据库路径    -->
        <property name="url" value="jdbc:mysql://localhost:3306/mytest"/>
<!-- 账号 -->
        <property name="username" value="root"/>
<!-- 密码 -->
        <property name="password" value=""/>
      </dataSource>
    </environment>
  </environments>
<!-- 导入定义的mapper.xml，mapper具体作用，请看其他文章 -->
  <mappers>
    <mapper resource="com/test/user.xml"/>
  </mappers>
</configuration>

2.mapper.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">
 <!-- 面向接口的实现 namespace是一个接口   -->
<mapper namespace="com.test.GetUserInter">
<!-- id对应了接口的方法，帮你实现这个接口， parameterType 传入参数的类型   resultType 返回结果的类型    -->
  <select id="selectUser" parameterType="int" resultType="com.test.User" >
    select * from user where id = #{id}
  </select>
</mapper>

3.po类的实现

public class User {

    private int id;
    private String username;
    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;
    }
    @Override
    public String toString() {
        return "User [id=" + id + ", username=" + username + ", password=" + password + "]";
    }
}

4.接口的实现

//请务必和mapper.xml对应
public interface GetUserInter {
    public User selectUser();
}

测试类

        //读取mybatis的配置文件 
        String resource = "mybatisconfig.xml";
        InputStream inputStream = Resources.getResourceAsStream(resource);
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
        //开启session
        SqlSession  session =sqlSessionFactory.openSession();
        //查询一个id为8的user用户 
        User user = session.selectOne("com.test.GetUserInter.selectUser",1);

        System.out.println(user);

结束语

文章是最最入门的配置。每个xml的具体作用，及其与springmvc整合，请移步其他文章