Query for Map 

Spring JDBC Framework simplifies the use of JDBC and helps to avoid common errors. The following example shows querying for a map using JdbcTemplate class.

File Name  :   /SpringJDBC001/conf/basic/applicationContext.xml

view sourceprint? 01 <?xml version="1.0" encoding="UTF-8"?> 02 <beans xmlns="http://www.springframework.org/schema/beans" 03        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 04        xsi:schemaLocation="http://www.springframework.org/schema/beans 05            http://www.springframework.org/schema/beans/spring-beans-3.0.xsd"> 06   07     <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"> 08         <property name="driverClassName" value="org.h2.Driver" /> 09         <property name="url" value="jdbc:h2:tcp://localhost/~/test" /> 10         <property name="username" value="sa" /> 11         <property name="password" value="" /> 12     </bean> 13   14 </beans>

File Name  :   com/bethecoder/tutorials/spring3/tests/QueryForMapTest.java  Author  :   Sudhakar KV Email  :   kvenkatasudhakar@gmail.com

package com.bethecoder.tutorials.spring3.tests; import java.util.Map; import javax.sql.DataSource; import org.springframework.context.ApplicationContext; import org.springframework.context.support.ClassPathXmlApplicationContext; import org.springframework.jdbc.core.JdbcTemplate; public class QueryForMapTest {   /**    * @param args    */   public static void main(String[] args) {          /**      * Initialize context and get the JdbcTemplate      */     ApplicationContext appContext = new ClassPathXmlApplicationContext("applicationContext.xml");     DataSource dataSource = (DataSource) appContext.getBean("dataSource");     JdbcTemplate template = new JdbcTemplate(dataSource);     /**      * The 'queryForMap' API expects a single resultant row from the query.      */     String statusToCheck = "RESOLVED";     Map<String, Object> row = template.queryForMap(         "select * from BUG_STAT where STATUS = ? ", statusToCheck);     System.out.println(row);               Map<String, Object> stat = template.queryForMap(         "select count(*) as ROW_COUNT, sum(COUNT) as BUG_COUNT, " +          "avg(COUNT) as AVG_BUG_COUNT from BUG_STAT");     System.out.println(stat);   } }

{ID=3, STATUS=RESOLVED, COUNT=16}
{ROW_COUNT=6, BUG_COUNT=60, AVG_BUG_COUNT=10}