入门请看http://blog.youkuaiyun.com/liumengcheng/article/details/34409783
首先创建表
create table T_USERS
(
ID NUMBER not null,
NAME VARCHAR2(30),
SEX VARCHAR2(3),
BIRS DATE,
MESSAGE CLOB
);
create sequence SEQ_T_USERS_ID
minvalue 1
maxvalue 99999999
start with 1
increment by 1
cache 20;
User.java
package com.southgis.scout.demo;
import java.util.Date;
/**
* 用户类
*
* @author lmc
*
*/
public class User {
private String name;
private String sex;
private Integer id;
private Date birs;
private String message;
public String getMessage() {
return message;
}
public void setMessage(String pMessage) {
this.message = pMessage;
}
public Date getBirs() {
return birs;
}
public void setBirs(Date pbirs) {
this.birs = pbirs;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getSex() {
return sex;
}
public void setSex(String psex) {
this.sex = psex;
}
public Integer getId() {
return id;
}
public void setID(Integer pid) {
this.id = pid;
}
public User() {
}
}
UsersMapper.java
package com.southgis.scout.demo;
import java.util.List;
import com.southgis.scout.demo.User;
public interface UsersMapper {
public void add(User t);
public void update(User t);
public void updateBySelective(User t);
public void delete(Object id);
public User queryById(Object id);
public List<User> queryBySelective(User t);
public int queryByCount(User t);
public List<User> queryByList(User t);
}
OracleClobTypeHandler.java
package com.southgis.scout.demo;
import java.sql.CallableStatement;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import oracle.sql.CLOB;
import org.apache.ibatis.type.JdbcType;
import org.apache.ibatis.type.TypeHan