Mybatis入门-idea版

创建一个mybatis项目需要的步骤

1. 准备数据库

CREATE DATABASE mybatis
USE mybatis
CREATE TABLE USER
(id INT(20) NOT NULL ,
NAME VARCHAR(30) DEFAULT NULL,
pwd VARCHAR(30) DEFAULT NULL,
PRIMARY KEY(id) 

)ENGINE=INNODB DEFAULT VARCHAR;
SELECT * FROM USER

2.创建一个maven项目，并且导入mybatis的依赖

<!-- 以后创建的modules都不用再导包啦 -->
 <modules>
   <module>mybatis-01</module>
 </modules>
 <dependencies>
   <dependency>
     <groupId>mysql</groupId>
     <artifactId>mysql-connector-java</artifactId>
     <version>5.1.46</version>
   </dependency>
   <dependency>
     <groupId>org.mybatis</groupId>
     <artifactId>mybatis</artifactId>
     <version>3.5.5</version>
   </dependency>
   <dependency>
     <groupId>junit</groupId>
     <artifactId>junit</artifactId>
     <version>4.12</version>
     <scope>test</scope>
   </dependency>
 </dependencies>

3.删除项目中的src目录，并且在该项目下创建一个module，
4.编写mybatis配置文件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.jdbc.Driver"/>
        <property name="url" value="jdbc:mysql://localhost:3306/mybatis?useSSL=true&amp;useUnicode=true&amp;characterEncoding=UTF-8"/>
        <property name="username" value="root"/>
        <property name="password" value="root"/>
      </dataSource>
    </environment>
  </environments>
  <mappers>
  <!--mapper的配置-->
    <mapper resource="com/lty/dao/UserMapper.xml"/>
  </mappers>
</configuration>

5.编写实体类

package com.lty.pojo;

public class User {
  private int id;
  private String name;
  private String pwd;

  @Override
  public String toString() {
    return "User{" +
            "id=" + id +
            ", name='" + name + '\'' +
            ", pwd='" + pwd + '\'' +
            '}';
  }

  public User() {
  }

  public int getId() {
    return id;
  }

  public void setId(int id) {
    this.id = id;
  }

  public String getName() {
    return name;
  }

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

  public User(int id, String name, String pwd) {
    this.id = id;
    this.name = name;
    this.pwd = pwd;
  }

  public String getPwd() {
    return pwd;
  }

  public void setPwd(String pwd) {
    this.pwd = pwd;
  }
}

6.编写持久层，UserDao，或者UserMapper，他是一个接口

package com.lty.dao;
import com.lty.pojo.User;
import java.util.List;

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

7.编写接口对应的配置文件，UserDaoMapper.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">
<!--这个命名空间和user实体类绑定起来啦！-->
<mapper namespace="com.lty.dao.UserDao">
<!--  查询语句 其中id值和接口中对应的方法名尽量保持一致-->
  <select id="getUserList" resultType="com.lty.pojo.User">
    select * from user;
  </select>
</mapper>

8.编写一个mybatis工具类

package com.lty.utils;

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 java.io.IOException;
import java.io.InputStream;

public class MybatisUtils {
  private static SqlSessionFactory sqlSessionFactory ;
  //加载资源
  static{
    try {
      String resource = "mybatis-config.xml";
      InputStream inputStream  = Resources.getResourceAsStream(resource);
      sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
    } catch (IOException e) {
      e.printStackTrace();
    }
  }
  public static SqlSession  getSession(){
    return sqlSessionFactory.openSession();
  }
}

9.测试

package com.lty.dao;
import com.lty.pojo.User;
import com.lty.utils.MybatisUtils;
import org.apache.ibatis.session.SqlSession;
import org.junit.Test;

import java.util.List;

public class UserDaoTest {
  @Test
  public void test(){
    //获得Session对象

    SqlSession session = MybatisUtils.getSession();
    //执行sql
    UserDao mapper = session.getMapper(UserDao.class);
    List<User> users = mapper.getUserList();
    for (User user : users) {
      System.out.println(user);
    }
    //关闭session
    session.close();

  }
}

9.错误处理

 <build>
    <resources>
      <resource>
        <directory>src/main/resources</directory>
        <includes>
          <include>**/*.properties</include>
          <include>**/*.xml</include>
        </includes>
        <filtering>false</filtering>
      </resource>
      <resource>
        <directory>src/main/java</directory>
        <includes>
          <include>**/*.properties</include>
          <include>**/*.xml</include>
        </includes>
        <filtering>false</filtering>
      </resource>
    </resources>
  </build>