SelectKey Type
The following example shows inserting a student record into DB.
The selectKey tag allows us to generate a primary key.
Depending upon the database and primary key generation strategy
the selectKey tag has to be specified before or
after the insert query. Instead of manually ordering the queries we can use
select key type attribute to specify the order of
query execution. The possible values are pre and
post .
01<?xml version="1.0" encoding="UTF-8"?>
02<!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"
05<sqlMap namespace="Student">
07 <insert id="selKeyType" parameterClass="com.bethecoder.tutorials.ibatis.common.Student">
09 insert into STUDENT (STUDENT_ID, FIRST_NAME, LAST_NAME, AGE, PHONE, HOBBY)
10 values (#studentId#, #firstName#, #lastName#, #age#, #phone#, #hobby#)
12 <selectKey resultClass="int" keyProperty="studentId" type="pre">
13 select STUDENT_ID_SEQ.nextval as studentId from DUAL
package com.bethecoder.tutorials.ibatis.tests.basic; import java.io.IOException; import java.io.Reader; import java.sql.SQLException; import com.bethecoder.tutorials.ibatis.common.Student; import com.ibatis.common.resources.Resources; import com.ibatis.sqlmap.client.SqlMapClient; import com.ibatis.sqlmap.client.SqlMapClientBuilder; public class SelectKeyType { /** * @param args * @throws IOException * @throws SQLException */ public static void main ( String [] args ) throws IOException, SQLException { Reader reader = Resources.getResourceAsReader ( "SqlMapConfig.xml" ) ; SqlMapClient sqlMapClent = SqlMapClientBuilder.buildSqlMapClient ( reader ) ; Student student = new Student ( "Prasad" , "Kasireddi" , ( short ) 29 , "+914444444444" , "Singing" ) ; sqlMapClent.insert ( "Student.selKeyType" , student ) ; System.out.println ( student + " record created successfully.." ) ; } }
Student[7, Prasad, Kasireddi, 29, Singing, +914444444444] record created successfully..
