详细的Spring JDBC用法

Danny1000

/**
* @(#)JdbcTest.java
*
*
* @author
* @version 1.00 2007/8/7
*/
import org.springframework.context.support.ClassPathXmlApplicationContext;
import org.springframework.context.ApplicationContext;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.PreparedStatementCallback;
import org.springframework.jdbc.core.PreparedStatementCreator;
import org.springframework.jdbc.core.StatementCallback;
import org.springframework.jdbc.core.RowMapper;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import org.springframework.dao.DataAccessException;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.sql.ResultSet;
import org.springframework.jdbc.core.PreparedStatementSetter;
import org.springframework.jdbc.core.ResultSetExtractor;
import org.springframework.jdbc.core.RowCallbackHandler;
import org.springframework.jdbc.object.SqlFunction;
import javax.sql.DataSource;

public class JdbcTest  {
        
    public static void main(String[] args) throws Exception{
        // TODO code application logic here
        ApplicationContext ctx = new ClassPathXmlApplicationContext("bean.xml");
        DataSource ds = (DataSource)ctx.getBean("dataSource");
        JdbcTemplate jt = (JdbcTemplate)ctx.getBean("jdbcTemplate");
        /**
        String sql = "select * from person where id =?";
        Object[] param = new Object[]{new Integer(3)};
        final PersonBean p = new PersonBean();
  jt.query(sql,param,new RowCallbackHandler(){
    public void processRow(ResultSet rs ) throws SQLException{
     //PersonBean p = new PersonBean();
     p.setId(rs.getInt("id"));
     p.setAge(rs.getInt("age"));
     p.setName("name");
     
    }
   });
      System.out.println(p.getId()+"  "+p.getAge()+"  "+p.getName());
        */
        
        /**
        String sql = "select id,age,name from person where name like ?";
        Object[] param = new Object[]{"%e%"};
        List list = jt.query(sql,param,new RowMapper(){
         public Object mapRow(ResultSet rs, int rowNumber) throws SQLException {
    // TODO: Add your code here
    PersonBean p = new PersonBean();
    p.setId(rs.getInt("id"));
    p.setAge(rs.getInt("age"));
    p.setName(rs.getString("name"));
    return p;
   }
         });
         
        for(int i=0;i

}



本文来自ChinaUnix博客，如果查看原文请点：http://blog.chinaunix.net/u1/45398/showart_362539.html