Entity Select Parameter Map
The following example shows using select parameter map.
It lets the user to map properties from a java object.
Note that map properties are substituted in place of ? in SQL in the same order.
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 <parameterMap class="com.bethecoder.tutorials.ibatis.common.Student" id="nameParamMap">
08 <parameter property="firstName" />
09 <parameter property="lastName" />
12 <select id="getByName" parameterMap="nameParamMap"
13 resultClass="com.bethecoder.tutorials.ibatis.common.Student">
16 STUDENT_ID as studentId,
17 FIRST_NAME as firstName,
18 LAST_NAME as lastName,
22 FROM STUDENT where FIRST_NAME = ? AND LAST_NAME = ?
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 SelectParameterMap2 { /** * @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 () ; student.setFirstName ( "Ram" ) ; student.setLastName ( "Prasad" ) ; student = ( Student ) sqlMapClent.queryForObject ( "Student.getByName" , student ) ; System.out.println ( student ) ; } }
Student[3, Ram, Prasad, 24, Painting, +918888888888]
