areadao.java

来自「自己做的3个spring的小例子」· Java 代码 · 共 28 行

package sp.demo3;

import java.util.List;

import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.RowMapperResultReader;

public class AreaDao {
	JdbcTemplate jdbcTemplate =  new JdbcTemplate();

	/**
	 * @param jdbcTemplate The jdbcTemplate to set.
	 */
	public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {
		this.jdbcTemplate = jdbcTemplate;
	}
	
	/*
	 * return : Area List 
	 */
	public List getArea(final Integer id) {
		String sql = "select * from map_area where areaid>=?";
		final Object[] params = new Object[] {id};
		
		return jdbcTemplate.query(sql, params, new RowMapperResultReader(new AreaRowMapper()));
	}
}