Spring JdbcTemplate 简单示例

package com.xiva.jdbc.spring;import java.io.InputStream;import java.sql.ResultSet;import java.sql.SQLException;import java.util.Properties;import javax.sql.DataSource;import org.apache.commons.dbcp.BasicDataSourceFactory;import org.springframework.jdbc.core.JdbcTemplate;import org.springframework.jdbc.core.RowMapper;import com.xiva.jdbc.domain.Person;public class JDBCTemplateSpring {static DataSource myDataSource;static DataSource getDataSource(){Properties prop = new Properties();try{InputStream is = JDBCTemplateSpring.class.getClassLoader().getResourceAsStream("dataSource.properties");prop.load(is);myDataSource = BasicDataSourceFactory.createDataSource(prop);}catch(Exception ioE){throw new ExceptionInInitializerError();}return myDataSource;}static Person findPerson(){Person person = new Person(); JdbcTemplate jdbc = new JdbcTemplate(getDataSource());String sql = "select * from person where id=5";//这个方法只能获取rs size为1的对象；否则抛出异常IncorrectResultSizeDataAccessExceptionperson = jdbc.queryForObject(sql, new RowMapper<Person>(){@Overridepublic Person mapRow(ResultSet rs, int rowNum) throws SQLException {// TODO Auto-generated method stubPerson person = new Person();person.setId(rs.getInt("id"));person.setName(rs.getString("name"));return person;}});return person;}/** * @param args */public static void main(String[] args) {Person person = findPerson();System.out.println(person);}}

?

spring-transaction.jar------之前的spring版本中有一个叫spring-dao.jar的集成到这个包中

spring-jdbc.jar

以及其依赖的包