mybatis连接Oracle做增删改查

孟哥1989

已于 2022-03-10 15:58:12 修改

阅读量9.2k

点赞数 1

CC 4.0 BY-SA版权

分类专栏：数据库相关文章标签： mybatis oracle

于 2014-06-25 11:24:05 首次发布

本文链接：https://blog.youkuaiyun.com/liumengcheng/article/details/34422475

本文介绍了如何使用Mybatis连接Oracle数据库进行增删改查操作。从创建表开始，逐步讲解了User.java实体类、UsersMapper接口、OracleClobTypeHandler自定义类型处理器以及main.java主程序和configuration.xml、UsersMapper.xml配置文件的详细内容。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

入门请看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