<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
??<property name="driverClassName" value="org.hsqldb.jdbcDriver" />
??<property name="username" value="sa" />
??<property name="password" value="" />
??<property name="url" value="jdbc:hsqldb:hsql://localhost:9001" />
?</bean>
?
?<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
??<property name="dataSource" ref="dataSource"></property>
?</bean>

ListableBeanFactory cbf = new ClassPathXmlApplicationContext("ac1.xml");
??JdbcTemplate jt = (JdbcTemplate) cbf.getBean("jdbcTemplate");??
??List rsList = jt.queryForList("select * from pets");
??//////////////////// 首先取得list
??for(Iterator iterator = rsList.iterator();iterator.hasNext() ;){
//////////////////////////////將所有的list迭代出來
???System.out.println(iterator.next());
??}??

1. List?rows?=?jdbcTemplate.queryForList("SELECT?*?FROM?USER"); ??
2. Iterator?it?=?rows.iterator(); ??
3. while(it.hasNext())?{ ??
4. ????Map?userMap?=?(Map)?it.next(); ??
5. ????System.out.print(userMap.get("user_id")?+?"\t"); ??
6. ????System.out.print(userMap.get("name")?+?"\t"); ??
7. ????System.out.print(userMap.get("sex")?+?"\t"); ??
8. ????System.out.println(userMap.get("age")?+?"\t"); ??
9. }

大盤預測 國富論