Mybatis快速入门开发

.Mybatis快速入门开发步骤

添加坐标

  <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>5.1.32</version>
    </dependency>
<dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis</artifactId>
      <version>3.4.6</version>
    </dependency>
  <dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>4.11</version>
      <scope>test</scope>
    </dependency>

创建数据表

 

创建实体类

我们创建一个user类，属性有id，username，passwword

package com.cheng.domian;

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

    public User() {
    }


    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 + '\'' +
                '}';
    }
}

编写映射文件

我把这个文件命名为UserMapper.xml ，可以随便命名，但最好要见名知意

<mapper namespace="UserMapper">

<select id="findAll" resultType="com.cheng.domian.User" >
        select * from user
    </select>
</mapper>

编写mybatis核心配置文件

<configuration>
<!--    数据源环境-->
    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"></transactionManager>
            <dataSource type="POOLED">
                <property name="driver" value="com.mysql.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql://localhost:3306/test"/>
                <property name="username" value="root"/>
                <property name="password" value="root"/>
            </dataSource>
        </environment>
    </environments>
<!--    加载映射文件-->
    <mappers>
        <mapper resource="com/cheng/mapper/UserMapper.xml"></mapper>
    </mappers>
</configuration>

测试

public class MybatisTest {
    @Test
    public void test1() throws IOException {
       User user = new User();
        //获得核心配置文件
        InputStream resourceAsStream = Resources.getResourceAsStream("SqlMapConfig.xml");
        //获得session工厂对象
        SqlSessionFactory sqlSessionFactory = new                     
        SqlSessionFactoryBuilder().build(resourceAsStream);
        //获得session会话对象
        SqlSession sqlSession =  sqlSessionFactory.openSession();
        List<User> userList = sqlSession.selectList("UserMapper.findAll", user);
        System.out.println(userList);
        //关闭
        sqlSession.close();
    }
}

结果