Create Record
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.
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="insert" parameterClass="com.bethecoder.tutorials.ibatis.common.Student">
09 <selectKey resultClass="int" keyProperty="studentId">
10 select STUDENT_ID_SEQ.nextval as studentId from DUAL
13 insert into STUDENT (STUDENT_ID, FIRST_NAME, LAST_NAME, AGE, PHONE, HOBBY)
14 values (#studentId#, #firstName#, #lastName#, #age#, #phone#, #hobby#)
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 Insert { /** * @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 ( "Sriram" , "Kasireddi" , ( short ) 1 , "+919999999999" , "Boxing" ) ; sqlMapClent.insert ( "Student.insert" , student ) ; System.out.println ( student + " record created successfully.." ) ; } }
Student[6, Sriram, Kasireddi, 1, Boxing, +919999999999] record created successfully..
