apache common dbutils1.3 库使用样例

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.List;

import org.apache.commons.dbutils.DbUtils;
import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanListHandler;

public class Test {

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		Connection conn = null;
//        String url = "jdbc:mysql://localhost:3306/test";
        String url = "jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf8";
        String jdbcDriver = "com.mysql.jdbc.Driver";
        String user = "root";
        String password = "root";
        
        if (!DbUtils.loadDriver(jdbcDriver)){
        	System.out.printf("未找到驱动: %s",jdbcDriver);
        	System.out.println();
        	return;
        }
        
        try {
        	conn = DriverManager.getConnection(url, user, password);
        	
        	QueryRunner qr = new QueryRunner();
            
//            int [] inid = new int[6];
//            for(int i = 1; i < 7; i++){
//            	inid[i-1] = qr.update(conn, "INSERT INTO users(id,email,password) VALUES(" + (i + 10) + ",'vb" + i +"@q.com','32450')");
//            }
//            
//            System.out.println(inid);
            
            List results = (List) qr.query(conn, "select id,email,password from users", new BeanListHandler(User.class));
        	
            for (int i = 0; i < results.size(); i++) {
            	User gb = (User) results.get(i);
                System.out.println("id:" + gb.getId() + ",email:" + gb.getEmail());
            }
            
		} catch (SQLException e) {
			
			e.printStackTrace();
		}finally {
            DbUtils.closeQuietly(conn);
        }
        
	}

}

 

public class User {
	private Integer id;
	private String email;
	private String password;
	
	public Integer getId() {
		return id;
	}
	public void setId(Integer id) {
		this.id = id;
	}
	public String getEmail() {
		return email;
	}
	public void setEmail(String email) {
		this.email = email;
	}
	public String getPassword() {
		return password;
	}
	public void setPassword(String password) {
		this.password = password;
	}
	
}

 

 

此处要注意的是 bean规范,并且 bean 类必须是 public 的