DbUtils 备忘

package com;

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 DBhelp {
 
 public static void main(String args []){
  
  String url="jdbc:mysql://127.0.0.1:3309/bbs";
  String sql="select * from article";
  DbUtils.loadDriver("com.mysql.jdbc.Driver");
  try {
   Connection conn=DriverManager.getConnection(url,"root","root");
   QueryRunner qr= new QueryRunner();
   List rs=(List) qr.query(conn,sql,new MapListHandler());
   DbUtils.close(conn);
   Map map=null;
   for(int i=0;i<rs.size();i++){
    map=(Map) rs.get(i);
    
    System.out.println(map.get("title"));
    System.out.println(map.get("pdate"));
    System.out.println(map.get("cont"));
    System.out.println(map.get("id"));
    
  
    
    
   }
   
  } catch (SQLException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
   
  }
  
  
 }
 

}

 

 

 

 

package com;

public class guestbook {
 
 private String  title;
 private String cont;
 private String pdate;
 private String id;
 public String getTitle() {
  return title;
 }
 public void setTitle(String title) {
  this.title = title;
 }
 public String getCont() {
  return cont;
 }
 public void setCont(String cont) {
  this.cont = cont;
 }
 public String getPdate() {
  return pdate;
 }
 public void setPdate(String pdate) {
  this.pdate = pdate;
 }
 public String getId() {
  return id;
 }
 public void setId(String id) {
  this.id = id;
 }

}