maintestforrowset.java

随书光盘：精通Sping 2.0 的随书源代码

package test;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.springframework.beans.factory.ListableBeanFactory;
import org.springframework.beans.factory.generic.GenericBeanFactoryAccessor;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.support.rowset.SqlRowSet;

/**
 * 
 * @author worldheart
 *
 */
public class MainTestForRowSet {

	private static final Log log = LogFactory.getLog(MainTestForRowSet.class);
	
	public static void main(String[] args) {		
		ListableBeanFactory cbf = new ClassPathXmlApplicationContext("ac2.xml");		
		GenericBeanFactoryAccessor gbfa = new GenericBeanFactoryAccessor(cbf);
		
		JdbcTemplate jt = gbfa.getBean("jdbcTemplate");		
		
		SqlRowSet rs = jt.queryForRowSet("selects empno, sal from emp");
		
		while(rs.next())
			log.info(rs.getString("empno")  + ":->"+ rs.getFloat("sal"));
	}

}