Get All Records 

The following example shows getting all records from a particular table. Note that alias names provided in the SQL query matches with property names in result class POJO. iBatis invokes appropriate setter method based on alias names. This POJO should have a no argument default constructor so that iBatis creates an instance and sets mapped properties.

We have used Student.getAll string to query all students, where Student is the query namespace and getAll is the actual query id. There can be N number of queries in a single namespace.

File Name  :   /IBATIS001/config/basic/GetAll.xml

view sourceprint? 01 <?xml version="1.0" encoding="UTF-8"?> 02 <!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN" 03 "http://ibatis.apache.org/dtd/sql-map-2.dtd"> 04   05 <sqlMap namespace="Student"> 06   07     <select id="getAll" resultClass="com.bethecoder.tutorials.ibatis.common.Student"> 08   09         SELECT 10             STUDENT_ID as studentId, 11             FIRST_NAME as firstName, 12             LAST_NAME as lastName, 13             AGE as age, 14             PHONE as phone, 15             HOBBY as hobby 16         FROM STUDENT 17   18     </select> 19   20 </sqlMap>

File Name  :   com/bethecoder/tutorials/ibatis/tests/basic/GetAll.java  Author  :   Sudhakar KV Email  :   kvenkatasudhakar@gmail.com

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 GetAll {   /**    * @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.getAll");     for (Student stud : studs) {       System.out.println(stud);     }       } }

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]