CREATE TABLE ACCOUNT_INFO (
 "ID" NUMBER(12) NOT NULL ,
 "USERNAME" VARCHAR2(64 BYTE) NULL ,
 "PASSWORD" VARCHAR2(64 BYTE) NULL ,
 "GENDER" CHAR(1 BYTE) NULL ,
 "EMAIL" VARCHAR2(64 BYTE) NULL ,
 "CREATE_DATE" DATE NULL 
)

package com.oracle.entity;

import java.sql.Date;

public class AccountInfo {
 private Long id;
 private String userName;
 private String password;
 private String gender;
 private String email;
 private Date createDate;

 public Long getId() {
 return id;
 }

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

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

 public String getGender() {
 return gender;
 }

 public void setGender(String gender) {
 this.gender = gender;
 }

 public String getEmail() {
 return email;
 }

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

 public Date getCreateDate() {
 return createDate;
 }

 public void setCreateDate(Date createDate) {
 this.createDate = createDate;
 }

 @Override
 public String toString() {
 return "AccountInfo [id=" + id + ", userName=" + userName
 + ", password=" + password + ", gender=" + gender + ", email="
 + email + ", createDate=" + createDate + "]";
 }

}

package com.oracle.mapper;

import java.util.List;

import com.oracle.entity.AccountInfo;

public interface AccountInfoMapper {
 /**
 * 查询所有的数据
 * @return
 */
 List<AccountInfo> queryAllAccountInfo();
 
 /**
 * 批量插入数据
 * 
 * @param accountInfoList
 * @return
 */
 int batchInsertAccountInfo(List<AccountInfo> accountInfoList);
}

<?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="oracle.jdbc.driver.OracleDriver" />
 <property name="url" value="jdbc:oracle:thin:@localhost:1521:orcl" />
 <property name="username" value="xxx" />
 <property name="password" value="xxx" />
 </dataSource>
 </environment>
 </environments>
 <mappers>
 <mapper resource="config/AccountInfoMapper.xml" />
 </mappers>
</configuration>