Update Record
The following example shows updating a student record into DB.
The parameterClass attribute allows us to
pass the student record to be updated as parameter to the 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 <update id="updateHobby" parameterClass="com.bethecoder.tutorials.ibatis.common.Student">
08 UPDATE STUDENT SET HOBBY = #hobby# WHERE STUDENT_ID = #studentId#
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 Update { /** * @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 stud = ( Student ) sqlMapClent.queryForObject ( "Student.getById" , 1 ) ; System.out.println ( stud ) ; stud.setHobby ( "My new hobby" ) ; sqlMapClent.update ( "Student.updateHobby" , stud ) ; System.out.println ( stud + " record updated successfully.." ) ; stud = ( Student ) sqlMapClent.queryForObject ( "Student.getById" , 1 ) ; System.out.println ( stud ) ; } }
Student[1, Jim, Attic, 32, Painting, +919999999999]
Student[1, Jim, Attic, 32, My new hobby, +919999999999] record updated successfully..
Student[1, Jim, Attic, 32, My new hobby, +919999999999]
