MyBatis用序列插入对象
映射文件：
?
<insert id="insertStudentBySequence" parameterType="Student">
??<selectKey?resultType="int" keyProperty="s_id"?order="BEFORE">
???select studentPKSequence.nextVal
???from dual
??</selectKey>
??
??insert into student(s_id,s_name,s_age)
??values ??????(#{s_id},#{s_name},#{s_age})
?</insert>
-----------------------
resultType="int" 返回的是一个int类型
keyProperty 把返回值，赋值给：parameterType中对象的对象的属性，也就是Student类中的s_id属性
order属性，在mybatis-3.1.0要加上该属性，表示先执行此步骤
-----------------------
DAO：
?
public void addStudentBySequence(Student stu) {
??SqlSession sqlSession = null;
??try{
???sqlSession = sf.openSession();
???sqlSession.insert("insertStudentBySequence", stu);
???System.out.println("s_id: "+stu.getS_id());
???sqlSession.commit();//这里一定要提交，不然数据进不去数据库中
??}finally{
???sqlSession.close();
??}
?}
?
----------------------------------------------------
测试：
?@Test
?public void addStudentBySequenceTest(){
??IStudentDAO sDAO = new IStudentDAOIbatisImpl();
??Student student = new Student();
??//student.setS_id(500);
??student.setS_age(18);
??student.setS_name("yyy");
??sDAO.addStudentBySequence(student);
??System.out.println("add ok!");
?}
?
