namedparameterjdbcdaosupportimpl.java

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

package org.springframework.samples;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.springframework.jdbc.core.namedparam.BeanPropertySqlParameterSource;
import org.springframework.jdbc.core.namedparam.NamedParameterJdbcDaoSupport;
import org.springframework.jdbc.core.namedparam.SqlParameterSource;
import org.springframework.samples.petclinic.Person;

/**
 * 
 * @author worldheart
 * 
 */
public class NamedParameterJdbcDaoSupportImpl extends
		NamedParameterJdbcDaoSupport implements INamedParameterJdbcDaoSupport {

	protected static final Log log = LogFactory
			.getLog(NamedParameterJdbcDaoSupportImpl.class);

	public void operationAll() {
		log.info(this.getJdbcTemplate());

		Person person = new Person();
		person.setAddress("GuangZhou");
		SqlParameterSource sps = new BeanPropertySqlParameterSource(person);

		log.info(this.getNamedParameterJdbcTemplate().queryForInt("select count(*) from owners where address = :address", sps));
	}
}