spring jdbc查询 依赖JdbcTemplate这个类模版封装JDBC的操作

package cn.itcast.spring.jdbc;

import java.util.List;

import org.springframework.jdbc.core.support.JdbcDaoSupport;

public class PersonDao extends JdbcDaoSupport{
    public void update(){
        this.getJdbcTemplate().execute("update person set pname='a' where pid=3");
    }
    
    public void query(){
13         List<Person> persons = this.getJdbcTemplate().query("select * from person", new PersonRowMapper());
        for(Person person:persons){
            System.out.println(person.getPname());
        }
    }
}

 

package cn.itcast.spring.jdbc;

import java.sql.ResultSet;
import java.sql.SQLException;

import org.springframework.jdbc.core.RowMapper;

public class PersonRowMapper implements RowMapper{

    @Override
    public Object mapRow(ResultSet rs, int rowNum) throws SQLException {
        // TODO Auto-generated method stub
        Person person = new Person();
        person.setPid(rs.getLong("pid"));
        person.setPname(rs.getString("pname"));
        person.setPsex(rs.getString("psex"));
        return person;
    }
    /**
     * crud做一下
     */

}

 

public class PersonTest {
    @Test
    public void test(){
        ApplicationContext context = new ClassPathXmlApplicationContext("cn/itcast/spring/jdbc/applicationContext.xml");
        PersonDao personDao = (PersonDao)context.getBean("personDao");
        personDao.query();
    }
}