JDBC将结果打包成一个List或Map

JDBC将结果封装成一个List或Map
需要的jar包，第一要相应的数据库连接的jar包，第二就是commons-dbutils-1.3.jar????????????????? 先看List

package www.libinxuan.dbutils;import java.sql.Connection;import java.sql.DriverManager;import java.sql.SQLException;import java.util.List;import java.util.Map;import org.apache.commons.dbutils.DbUtils;import org.apache.commons.dbutils.QueryRunner;import org.apache.commons.dbutils.handlers.BeanListHandler;public class BeanListExample {public static void main(String[] args){DbUtils.loadDriver("com.mysql.jdbc.Driver");String url = "jdbc:mysql://localhost:3306/usertable" ;String sql = "select * from user";try {Connection conn = DriverManager.getConnection(url,"root","root");QueryRunner qr = new QueryRunner();List results = (List)qr.query(conn, sql, new BeanListHandler<User>(User.class));DbUtils.close(conn);User user = null;for(int i=0; i<results.size(); i++){user = (User)results.get(i);System.out.println("用户名： " + user.getUsername());System.out.println("密码： " + user.getPassword());}} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}}

package www.libinxuan.dbutils;import java.sql.Connection;import java.sql.DriverManager;import java.sql.SQLException;import java.util.List;import java.util.Map;import org.apache.commons.dbutils.DbUtils;import org.apache.commons.dbutils.QueryRunner;import org.apache.commons.dbutils.handlers.MapListHandler;public class MapListExample {public static void main(String[] args){DbUtils.loadDriver("com.mysql.jdbc.Driver");String url = "jdbc:mysql://localhost:3306/usertable" ;String sql = "select * from user";try {Connection conn = DriverManager.getConnection(url,"root","root");QueryRunner qr = new QueryRunner();List results = (List)qr.query(conn, sql, new MapListHandler());DbUtils.close(conn);for(int i=0; i<results.size(); i++){Map map = (Map)results.get(i);System.out.println("用户名： " + map.get("username"));System.out.println("密码： " + map.get("password"));}} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}}

package www.libinxuan.dbutils;public class User {private String username;private String password;public String getUsername() {return username;}public void setUsername(String username) {this.username = username;}public String getPassword() {return password;}public void setPassword(String password) {this.password = password;}}