mybatis操作oracle数据库主键自增(触发器)

create table Student(
 Student_ID int(6) NOT NULL PRIMARY KEY AUTO_INCREMENT,
 Student_Name varchar(10) NOT NULL,
 Student_Age int(2) NOT NULL
);

insert into student(student_name,student_age) values('zhangsan',20);

create table Student(
 Student_ID int primary key identity(1,1),
 Student_Name varchar2(10) NOT NULL,
 Student_Age number(2) NOT NULL
);
insert into student(student_name,student_age) values('zhangsan',20);

create table Student(
 Student_ID number(6) NOT NULL PRIMARY KEY,
 Student_Name varchar2(10) NOT NULL,
 Student_Age number(2) NOT NULL
);

CREATE SEQUENCE student_sequence 
INCREMENT BY 1
NOMAXVALUE
NOCYCLE
CACHE 10;

insert into Student values(student_sequence.nextval,'aa',20);

create or replace trigger student_trigger
 before insert on student 
 for each row
begin
 select student_sequence.nextval into :new.student_id from dual;
end student_trigger;
/

insert into student(student_name,student_age) values('wangwu',20);

username=go
password=go
url=jdbc:oracle:thin:@127.0.0.1:1521:orcl
driver=oracle.jdbc.driver.OracleDriver

	
 
 select student_sequence.nextval from dual
 
如果未使用触发器，请保留该注释
--!>
 insert into student(student_id,student_name,student_age) values(#{student_id},#{student_name},#{student_age})
 
	
	
	select * from student where student_id=#{student_id}
	

	
	delete from student where student_id=#{student_id}
	
	
	
	update student set student_name=#{student_name},student_age=#{student_age} where student_id=#{student_id}
	
	
	
	select * from student
	

public class TestMybatis {
	
	@Test
	public void testAdd() { //为原始的获取配置文件，自己创建session，一步一步走的
	try {
	InputStream is = Resources.getResourceAsStream("mybatis-config.xml");
	SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(is);

	SqlSession session = factory.openSession();
	Student u = new Student();
	u.setStudent_name("sunwukong");
	u.setStudent_age(50);
	session.insert("com.bean.Student.add", u);
	session.commit();
	session.close();
	} catch (IOException e) {
	e.printStackTrace();
	}
	}
	
	@Test
	public void testUpdate(){
	SqlSession session = null;
	try {
	session = MyBatisUtil.createSession();
	Student stu = new Student();
	stu.setStudent_id(11);
	stu.setStudent_name("bajie");
	stu.setStudent_age(20);
	session.update(Student.class.getName()+".update", stu);
	session.commit();
	session.close();
	} catch (Exception e) {
	// TODO: handle exception
	e.printStackTrace();
	}
	}
	
	/*@Test
	public void testDelete() {
	SqlSession session= null;
	try {
	session = MyBatisUtil.createSession();
	session.delete(Student.class.getName()+".delete",105);
	session.commit();
	session.close();
	} catch (IOException e) {
	e.printStackTrace();
	}
	}*/
	
	@Test
	public void testLoad() {
	SqlSession session = null;
	try{
	session = MyBatisUtil.createSession();
	Student u = (Student)session.selectOne(Student.class.getName()+".load", 11);
	System.out.println(u.getStudent_name());
	} finally {
	MyBatisUtil.closeSession(session);
	}
	}
	
	@Test
	public void testList() {
	SqlSession session = null;
	try{
	session = MyBatisUtil.createSession();
	List us = session.selectList(Student.class.getName()+".list", null);
	System.out.println(us.size());
	} finally {
	MyBatisUtil.closeSession(session);
	}
	}
}

public class MyBatisUtil {
	public static SqlSessionFactory factory;
	static {
	try {
	InputStream is = Resources.getResourceAsStream("mybatis-config.xml");
	factory = new SqlSessionFactoryBuilder().build(is);
	} catch (IOException e) {
	e.printStackTrace();
	}
	}
	
	public static SqlSession createSession() {
	return factory.openSession();
	}
	
	public static void closeSession(SqlSession session) {
	if(session!=null) session.close();
	}
}