|
|
Result Mapping to Entity
The following example shows using a result map.
It provides a way of mapping resultant columns with properties in java object.
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 | <resultMap id="studentRM" class="com.bethecoder.tutorials.ibatis.common.Student" > |
08 | <result property="studentId" column="STUDENT_ID" /> |
09 | <result property="firstName" column="FIRST_NAME" /> |
10 | <result property="lastName" column="LAST_NAME" /> |
11 | <result property="age" column="AGE" /> |
12 | <result property="hobby" column="HOBBY" /> |
13 | <result property="phone" column="PHONE" /> |
16 | <select id="getAllFromRM" resultMap="studentRM"> |
|
| |
package com.bethecoder.tutorials.ibatis.tests.basic;
import java.io.IOException;
import java.io.Reader;
import java.sql.SQLException;
import java.util.List;
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 ResultMap {
/**
* @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);
List <Student> studs = (List<Student>) sqlMapClent.queryForList("Student.getAllFromRM");
for (Student stud : studs) {
System.out.println(stud);
}
}
}
|
| | |
It gives the following output,
Student[1, Jim, Attic, 32, Painting, +919999999999]
Student[2, Raj, Kumar, 18, Reading books, +914444488888]
Student[3, Ram, Prasad, 24, Painting, +918888888888]
Student[4, Arjun, Mishra, 28, Football, +917777777777]
Student[5, Vishal, Pratap, 19, Cricket, +91666666666]
|
|
