Spring基于jdbcTemplate对数据库的操作

Spring 对jdbc的封装，提供的模板类jdbcTemplate

	<context:component-scan base-package="com.test"/>
	<context:annotation-config/>
	<context:property-placeholder location="classpath*:db.properties" />
	<!-- 开启自动代理功能 -->
	<aop:aspectj-autoproxy/>
	<!-- 1. 数据源 : DriverManagerDataSource 寻找propertues映射文件 -->
	<bean id="datasource"
		  class="org.springframework.jdbc.datasource.DriverManagerDataSource">
		<property name="driverClassName" value="${jdbc.driverClassName}" />
		<property name="url" value="${jdbc.url}" />
		<property name="username" value="${jdbc.username}" />
		<property name="password" value="${jdbc.password}" />
	</bean>
	<!--配置jdbc模板,将数据源注入到模板中-->
	<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
		<property name="dataSource" ref="datasource"/>
	</bean>

@Repository
public class UserDAO {
    @Resource
    private JdbcTemplate jdbcTemplate;

    public void save() {
        String sql="insert into test(`name`,age) values(?,?)";
        jdbcTemplate.update(sql,"zlisi",20);
    }

    public void update(int age,int id){
        String sql = "update test set age=? where id=?";
        int update = jdbcTemplate.update(sql, age, id);
        System.out.println(update);
    }

    /**
     * 查询条数
     * @return
     */
    public int countId(){
        String sql="select count(id) from test";
       return jdbcTemplate.queryForInt(sql);
    }

    public String selectIterm(int id){
        String sql="select name from test where id=?";
        return jdbcTemplate.queryForObject(sql,String.class,2);
    }

    public UserModel selectObjectById(int id){
        String sql = "select id,name,age from test where id=?";
        //映射规则
        RowMapper<UserModel> rowMap = new RowMapper<UserModel>() {
            public UserModel mapRow(ResultSet rs, int i) throws SQLException {
                UserModel userModel = new UserModel();
                userModel.setAge(rs.getInt("age"));
                userModel.setName(rs.getString("name"));
                userModel.setId(rs.getInt("id"));
                return userModel;
            }
        };
        //单个数据用queryForObject
        return jdbcTemplate.queryForObject(sql, rowMap, 2);
    }

    public List<UserModel> selectOList(int age){
        String sql = "select id,name,age from test where age=?";
        //映射规则
        RowMapper<UserModel> rowMap = new RowMapper<UserModel>() {
            public UserModel mapRow(ResultSet rs, int i) throws SQLException {
                UserModel userModel = new UserModel();
                userModel.setAge(rs.getInt("age"));
                userModel.setName(rs.getString("name"));
                userModel.setId(rs.getInt("id"));
                return userModel;
            }
        };
        //List数据用query
        return jdbcTemplate.query(sql, rowMap,age);
    }
}