第二章：Mybatis+Maven环境，集成oracle数据库

一）创建一个Maven项目

项目结构图：

在pom.xml文件中引入mybatis和oracle的jar

<dependency>
    <groupId>org.mybatis</groupId>
    <artifactId>mybatis</artifactId>
    <version>3.5.4</version>
</dependency>
	
<!-- oracle jdbc jar-->
<dependency>
    <groupId>com.oracle</groupId>
    <artifactId>ojdbc6</artifactId>
    <version>11.1.0.6.0</version>
</dependency>

 

二）新增实体类和配置文件

在oracle数据库创建一个表，脚本如下：

--创建一个员工表
create table tab_employee(
    emp_id number,
    emp_name varchar2(100),
    emp_no varchar2(100),
    create_date number
);

delete from tab_employee;

select * from tab_employee;

 

EmployeeEntity.java：

package com.oysept.entity;

/**
 * 员工表 Entity
 * @author ouyangjun
 */
public class EmployeeEntity {
	
    private Integer empId;
    private String empName;
    private String empNO;
    private Long createDate;

    public Integer getEmpId() {return empId;}
    public void setEmpId(Integer empId) {this.empId = empId;}

    public String getEmpName() {return empName;}
    public void setEmpName(String empName) {this.empName = empName;}

    public String getEmpNO() {return empNO;}
    public void setEmpNO(String empNO) {this.empNO = empNO;}

    public Long getCreateDate() {return createDate;}
    public void setCreateDate(Long createDate) {this.createDate = createDate;}
}

 

EmployeeEntity.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">
<mapper namespace="com.oysept.dao.EmployeeDAO">

    <insert id="addEmployee">
        insert into tab_employee(emp_id,emp_name,emp_no,create_date)
        values(#{empId}, #{empName}, #{empNO}, #{createDate})
    </insert>
	
    <select id="getEmployeeByEmpId" parameterType="java.lang.String" resultType="EmployeeEntity">
        select 
            emp_id as empId,
            emp_name as empName,
            emp_no as empNO,
            create_date as createDate
        from tab_employee where emp_id = #{empId}
    </select>
	
    <update id="updateEmployee">
		
    </up