新建Project 

File-New-Project...  新建一个Project

左侧选择Empty Project，给project起名，并设置路径，点Finish

新建Module

File-New-Module... 

左侧选择Maven，勾选Create from archetype，选择这个quickstart，起名设路径，点Next。

 设置本地Maven和repository的路径，点Finish

右下角选择Enable Auto-Import

 得到下图的项目架构(如果没有这个src文件夹，很可能是jdk版本不对，要去设置里修改)

 在main文件夹下右键新建Directory，选择这个resources

在 org.example文件夹下新建dao,entity,utils三个文件夹 

查询Oracle版本

在cmd窗口输入sqlplus -v，得到Oracle版本为11.1.0.6.0

导入pom依赖，Oracle版本为11.1.0.6.0，MyBatis使用3.5.1版本：

  <properties>
    <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    <maven.compiler.source>1.8</maven.compiler.source>
    <maven.compiler.target>1.8</maven.compiler.target>
  </properties>

  <dependencies>
    <dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>4.11</version>
      <scope>test</scope>
    </dependency>
    <!--oracle驱动-->
    <dependency>
      <groupId>com.oracle</groupId>
      <artifactId>ojdbc6</artifactId>
      <version>11.1.0.6.0</version>
    </dependency>
    <!--mybatis依赖-->
    <dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis</artifactId>
      <version>3.5.1</version>
    </dependency>
  </dependencies>

  <build>
    <resources>
      <resource>
        <directory>src/main/java</directory><!--所在的目录   src/main/java-->
        <includes><!--包括目录下的.properties,.xml 文件都会扫描到-->
          <include>**/*.properties</include>
          <include>**/*.xml</include>
        </includes>
        <filtering>false</filtering>
      </resource>
      <resource>
        <directory>src/main/resources</directory><!--所在的目录   src/main/java-->
        <includes><!--包括目录下的.properties,.xml 文件都会扫描到-->
          <include>**/*.properties</include>
          <include>**/*.xml</include>
        </includes>
        <filtering>false</filtering>
      </resource>
    </resources>
  </build>

Oracle版本号爆红，需要手动导入jar包

在oracle安装路径找到ojdbc6.jar(这些jar包不同版本oracle的路径不一样，搜索一下jdbc文件夹)

打开cmd,定位到jar包位置

执行maven安装jar包：

mvn install:install-file -Dfile=ojdbc6.jar -Dpackaging=jar -DgroupId=com.oracle -DartifactId=ojdbc6 -Dversion=11.1.0.6.0

命令解释：mvn install:install-file -Dfile=“jar包的绝对路径” -Dpackaging=“文件打包方式” -DgroupId=groupid名 -DartifactId=artifactId名 -Dversion=jar版本 （我这里是oracle的版本11.1.0.6.0）。

出现BUILD SUCCESS表示安装成功。

 Oracle版本号的爆红消失。

 

 添加完依赖记得刷新一下，右键pom.xml-Maven-Reimport

 检查一下右侧Maven-Dependencies中的oracle依赖，如果仍然爆红，重启一下IDEA就好了

在Oracle中新建t_student表

CREATE TABLE t_student (
 id number(10) NOT NULL,
 name varchar2(50) DEFAULT NULL,
 email varchar2(50) DEFAULT NULL,
 age number(10) DEFAULT NULL,
 PRIMARY KEY (id)
); 

创建主配置文件mybatis.xml

在resources文件夹下，右键New-File-mybatis.xml(文件名的.xml也要输入)

输入如下内容，其中username和password改成自己oracle数据库的账号密码

<?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>
    <typeAliases>
        <typeAlias type="org.example.entity.Student" alias="Student"></typeAlias>
    </typeAliases>
    <environments default="mydev">
        <environment id="mydev">
            <transactionManager type="JDBC"></transactionManager>
            <dataSource type="POOLED">
                <property name="driver" value="oracle.jdbc.driver.OracleDriver"/>
                <property name="url" value="jdbc:oracle:thin://localhost:1521:orcl"/>
                <property name="username" value="bby"/>
                <property name="password" value="123"/>
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <mapper resource="org/example/dao/StudentDao.xml"></mapper>
    </mappers>
</configuration>

 在entity路径下创建实体类Student--用来保存表中的一行数据

类名建议和表名一致方便记忆。定义id,name,email,age属性，属性名和列名一样。

Alt+Insert创建set get方法，并重写toString方法。

package org.example.entity;

public class Student {
    private int id;
    private String name;
    private String email;
    private int age;

    public int getId() {
        return id;
    }

    public String getName() {
        return name;
    }

    public String getEmail() {
        return email;
    }

    public int getAge() {
        return age;
    }

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

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

    public void setEmail(String email) {
        this.email = email;
    }

    public void setAge(int age) {
        this.age = age;
    }

    @Override
    public String toString() {
        return "Student{" +
                "id=" + id +
                ", name='" + name + '\'' +
                ", email='" + email + '\'' +
                ", age=" + age +
                '}';
    }
}

在dao文件夹下创建StudentDao接口--定义操作数据库的方法

package org.example.dao;

import org.example.entity.Student;

import java.util.List;

public interface StudentDao {
    //查
    public List<Student> selectStudent();
    //增
    public int insertStudent(Student student);
    //删
    public int deleteStudent(int id);
    //改
    public int updateStudent(Student student);
}

在dao文件夹下创建StudentDao.xml映射文件--写和Dao接口中方法对应的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="org.example.dao.StudentDao">
    <select id="selectStudent" resultType="Student">
        select * from t_student
    </select>
    <insert id="insertStudent">
        insert into t_student values(#{id},#{name},#{email},#{age})
    </insert>
    <delete id="deleteStudent">
        delete from t_student where id = #{id}
    </delete>
    <update id="updateStudent">
        update t_student set name=#{name},email=#{email},age=#{age} where id=#{id}
    </update>
</mapper>

在utils文件夹下添加MyBatisUtils工具类--创建获取sqlSession的方法

package org.example.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 factory=null;
    static{
        String config = "mybatis.xml";
        try {
            InputStream in = Resources.getResourceAsStream(config);
            //创建SqlSessionFactory对象，由于整个项目有一个就够了，所以写在静态代码块中只执行一次
//            SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(in);
            factory = new SqlSessionFactoryBuilder().build(in);
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
    public static SqlSession getSqlSession(){
        SqlSession sqlSession = null;
        if (factory!=null){
            sqlSession = factory.openSession();//非自动提交事务 没给true参数
        }
        return sqlSession;
    }
}

 创建测试类，在test.java.org.example目录下创建TestMyBatis类--实现增删改查操作

package org.example;

import org.apache.ibatis.session.SqlSession;
import org.example.dao.StudentDao;
import org.example.entity.Student;
import org.example.utils.MyBatisUtils;
import org.junit.Test;

import java.util.List;

public class TestMyBatis {

    @Test//查
    public void testSelectStudent(){
        SqlSession sqlSession = MyBatisUtils.getSqlSession();
        StudentDao dao = sqlSession.getMapper(StudentDao.class);

        List<Student> students = dao.selectStudent();
        for (Student stu: students){
            System.out.println("查询到的学生信息:"+stu);
        }
    }

    @Test//增
    public void testInsertStudent(){
        SqlSession sqlSession = MyBatisUtils.getSqlSession();
        StudentDao dao = sqlSession.getMapper(StudentDao.class);

        Student student = new Student();
        student.setId(2);
        student.setName("abb");
        student.setEmail("[email protected]");
        student.setAge(19);
        int nums = dao.insertStudent(student);
        sqlSession.commit();
        System.out.println("增加成功条数为：" + nums);
    }

    @Test//删
    public void testDeleteStudent(){
        SqlSession sqlSession = MyBatisUtils.getSqlSession();
        StudentDao dao = sqlSession.getMapper(StudentDao.class);

        int nums = dao.deleteStudent(2);
        sqlSession.commit();
        System.out.println("删除成功条数为：" + nums);
    }

    @Test//改
    public void testUpdateStudent(){
        SqlSession sqlSession = MyBatisUtils.getSqlSession();
        StudentDao dao = sqlSession.getMapper(StudentDao.class);

        Student student = new Student();
        student.setId(2);
        student.setName("ABB");
        student.setEmail("[email protected]");
        student.setAge(99);
        int nums = dao.updateStudent(student);
        sqlSession.commit();
        System.out.println("修改成功条数为：" + nums);
    }
}

 最后附上项目最终的结构图