BE THE CODER > iBATIS > Basic Examples > Get All Records from a Table

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

File Name :	com/bethecoder/tutorials/ibatis/tests/basic/GetAll.java
Author :	Sudhakar KV
Email :	[email protected]


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);

    }    

  }

}