maintestforsimplejdbctemplate.java

来自「随书光盘：精通Sping 2.0 的随书源代码」· Java 代码 · 共 48 行

package org.springframework.samples;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.List;

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.simple.ParameterizedRowMapper;
import org.springframework.jdbc.core.simple.SimpleJdbcTemplate;
import org.springframework.samples.petclinic.Person;

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

	private static final Log log = LogFactory.getLog(MainTestForSimpleJdbcTemplate.class);
	
	public static void main(String[] args) {		
		ListableBeanFactory cbf = new ClassPathXmlApplicationContext("ac3.xml");		
		GenericBeanFactoryAccessor gbfa = new GenericBeanFactoryAccessor(cbf);
		
		SimpleJdbcTemplate sjt = gbfa.getBean("simpleJdbcTemplate");
				
		List<Person> perList = sjt.query("select * from vets", 
				new ParameterizedRowMapper<Person>(){
					public Person mapRow(ResultSet rs, int rowNum) throws SQLException {
						Person pers = new Person();
						pers.setId(rs.getInt("id"));
						pers.setFirstName(rs.getString("first_name"));
						pers.setLastName(rs.getString("last_name"));
						return pers;
					}
		});
		log.info(perList);
		
		ISimpleJdbcDaoSupport sjd = gbfa.getBean("simpleJdbcDaoSupportImpl");
		sjd.operationAll();
	}

}