MyBatis入门

MyBatis基础

• 持久化

  • 数据从瞬时状态转化为持久状态（即数据保存到可永久存储的设备中）

• 持久层

  • 完成持久化工作的代码块（Data Access Object）

• MyBatis

  • 基于java的持久层框架
  • 便于数据库中数据的存储以及读取
  • 传统的jdbc操作有许多重复的代码块（例如：对于读取后的数据进行封装，数据库的建立连接等）。通过框架可以减少重复工作，提供工作效率
  • 是一个半自动化的ORM框架
    
    • ORM(Object Relationship Mapping)
  • 功能: 支持普通SQL查询，存储过程和高级映射

• MyBatis使用

  • 导入MyBatis JAR包、mysql JAR包

  • 编写mybatis核心配置文件，放于src下

    <?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/test" />
                    <property name="username" value="root" />
                    <property name="password" value="chenyu123" />
                </dataSource>
            </environment>
        </environments>
        <!-- <mappers>
            <mapper resource="org/mybatis/example/BlogMapper.xml" />
        </mappers> -->
    </configuration>

    • 创建SqlSessionFactory以及获取SqlSession

      public class MyBatisUtil {
          public static SqlSessionFactory getSqlSessionFactory() throws IOException {
              String resource = "mybatis-config.xml";
              InputStream inputStream = Resources.getResourceAsStream(resource);
              SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
              return sqlSessionFactory;
          }
      
          public static SqlSession getSession() throws IOException {
              SqlSessionFactory sqlSessionFactory = getSqlSessionFactory();
              return sqlSessionFactory.openSession();
          }
      }

    • 创建实体类

      public class User {
          private int id;
          private String name;
          private String pwd;
      
          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 String getPwd() {
              return pwd;
          }
          public void setPwd(String pwd) {
              this.pwd = pwd;
          }
      }

    • 编写sql语句的映射文件

      <?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.eric.entity.UserMapper">
          <select id="selectUser" resultType="com.eric.entity.User">
              select * from user where id = #{id}
          </select>
      </mapper>

    • 测试代码

---

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.cj.jdbc.Driver" />
                <property name="url" value="jdbc:mysql://localhost:3306/test" />
                <property name="username" value="root" />
                <property name="password" value="chenyu123" />
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <mapper resource="com/eric/entity/user.mapper.xml" />
    </mappers>
</configuration>

• mapper配置文件

<?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.eric.entity.UserMapper">
    <select id="selectAll" resultType="com.eric.entity.User">
        select * from user
    </select>

    <select id="selectUser" resultType="com.eric.entity.User">
        select * from user where id = #{id}
    </select>

    <insert id="addUser" parameterType="com.eric.entity.User" useGeneratedKeys="true">
        insert into user (name, pwd) values(#{name}, #{pwd})
        <!-- 参数名称和对象参数名称一致 -->
    </insert>

    <update id="updateUser" parameterType="com.eric.entity.User">
        update user set name=#{name}, pwd=#{pwd} where id=#{id}  
    </update>

    <delete id="deleteUser">
        delete from user where id=#{id}
    </delete>
</mapper>

• UserDao

public class UserDao {
    public List<User> getAll() throws IOException {
        SqlSession session = MyBatisUtil.getSession();
        List<User> list = session.selectList("com.eric.entity.UserMapper.selectAll");
        session.close();
        return list;
    }

    public User getById(int id) throws IOException {
        SqlSession session = MyBatisUtil.getSession();
        User user = session.selectOne("com.eric.entity.UserMapper.selectUser", id);
        session.close();
        return user;
    }

    public int add(User user) throws IOException {
        SqlSession session = MyBatisUtil.getSession();
        int result = session.insert("com.eric.entity.UserMapper.addUser", user);

        //需要手动提交
        session.commit();
        session.close();
        return result;
    }

    public int update(User user) throws IOException {
        SqlSession session = MyBatisUtil.getSession();
        int result = session.update("com.eric.entity.UserMapper.updateUser", user);

        //需要手动提交
        session.commit();
        session.close();
        return result;
    }

    public int delete(int id) throws IOException {
        SqlSession session = MyBatisUtil.getSession();
        int result = session.delete("com.eric.entity.UserMapper.deleteUser", id);
        session.commit();
        session.close();
        return result;
    }
}

• entity

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

    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 String getPwd() {
        return pwd;
    }
    public void setPwd(String pwd) {
        this.pwd = pwd;
    }
    @Override
    public String toString() {
        return "User [id: " + id + ", name: " + name + ", pwd: " + pwd + "]\n";
    }
}

• 测试代码

public class Test {
    public static void main(String[] args) throws IOException {
        UserDao userDao = new UserDao();
        //查询所有
        List<User> list = userDao.getAll();

        for(User user : list) {
            System.out.print(user);
        }

//      //查询数据
//      System.out.println(userDao.getById(1));

//      //添加数据
//      User user = new User();
//      user.setName("charlie");
//      user.setPwd("1998");
//      System.out.println(userDao.add(user));

//      //更新数据
//      User user = userDao.getById(1);
//      user.setPwd("1998");
//      System.out.println(userDao.update(user));

//      //删除数据
//      System.out.println(userDao.delete(10));

    }
}