01_MyBatis_简介_第一个MyBatis程序

MyBatis

1. 什么是MyBatis
   是一个基于Java持久层的框架

2. 什么是持久化
   数据从瞬时状态变为持久状态

3. 什么是持久层
   完成持久化功能的代码块（DAO–data access object）

4. MyBatis帮助程序猿将数据存入数据库中及从数据库中取数据

5. 传统的jdbc操作有很多重复的代码块（数据取出时的封装，数据库的建立连接）通过框架可以减少重复代码，提高开发效率

6. MyBatis是一个半自动化的ORM（Object-Relationship-Mapping）框架

7. MyBatis的功能

   MyBatis 是支持普通 SQL查询，存储过程和高级映射的优秀持久层框架。MyBatis 消除了几乎所有的JDBC代码和参数的手工设置以及结果集的检索。MyBatis 使用简单的 XML或注解用于配置和原始映射，将接口和 Java 的POJOs（Plain Ordinary Java Objects，普通的 Java对象）映射成数据库中的记录。

8. 如何使用MyBatis

步骤：
1）导入MyBatis相关的Jar包
ant-1.9.6.jar
ant-launcher-1.9.6.jar
asm-5.2.jar
cglib-3.2.5.jar
commons-logging-1.2.jar
javassist-3.21.0-GA.jar
log4j-1.2.17.jar
log4j-api-2.3.jar
log4j-core-2.3.jar
mybatis-3.4.4.jar
ognl-3.1.14.jar
slf4j-api-1.7.25.jar
slf4j-log4j12-1.7.25.jar
+数据库连接的驱动包

2）编写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/zhushen"/>
        <property name="username" value="root"/>
        <property name="password" value="Code531182"/>
      </dataSource>
    </environment>
  </environments>
  <mappers>
    <mapper resource="com/zhushen/entity/user-mapper.xml"/>
  </mappers>
</configuration>

3）创建SqlSessionFactory以及获得SqlSession

package com.zhushen.util;

import java.io.IOException;
import java.io.InputStream;

import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;

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();
    }
}

4）创建实体类

public class User {
    private int userId;
    private String userName;
    private String passWord;
    public int getUserId() {
        return userId;
    }
    public void setUserId(int userId) {
        this.userId = userId;
    }
    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;
    }

}

5）编写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.zhushen.entity.UserMapper">
  <select id="selectUser" resultType="com.zhushen.entity.User">
    select * from user where userId = #{id}
  </select>
</mapper>

6）测试

package com.zhushen.test;

import java.io.IOException;

import org.apache.ibatis.session.SqlSession;

import com.zhushen.entity.User;
import com.zhushen.util.MyBatisUtil;

public class Test {
    public static void main(String[] args) throws IOException {
        SqlSession session=MyBatisUtil.getSession();
        User user=session.selectOne("com.zhushen.entity.UserMapper.selectUser", 14241182);
        System.out.println("id:"+user.getUserId());
        System.out.println("username:"+user.getUserName());
        System.out.println("password:"+user.getPassWord());
    }
}