addressbookbean.java

经典的java初学者的材料里面有最基本的java的应用

package addressbook.model;

import java.sql.*;
import java.util.*;
import addressbook.Constants;

public class AddressBookBean {

  String classes;
  String name;
  String phone;
  String partymember;
  String address;


  public AddressBookBean() {
	  
  }
  public AddressBookBean(String classes,String name,String phone,String partymember,String address) {
	this.classes=classes;
    this.name=name;
    this.phone=phone;
    this.partymember=partymember;
    this.address=address;
  
  }
  public String getClasses() {
		return classes;
  }
  public String getName(){
    return name;
  }
  public String getPhone(){
    return phone;
  }
  public String getPartymember() {
		return partymember;
  }
  public String getAddress(){
    return address;
  }

  public void setClasses(String classes) {
		this.classes = classes;
  }
	
  public void setName(String name){
    this.name=name;
  }
  public void setPhone(String phone){
    this.phone=phone;
  }
  public void setAddress(String address){
    this.address=address;
  }
  public void setPartymember(String partymember) {
		this.partymember = partymember;
  }

  public void insert()throws Exception{
      Connection con= DBUtils.getConnection();
      PreparedStatement pStmt=null;
      try{
              pStmt=con.prepareStatement("INSERT INTO " + Constants.TABLENAME +
                                              " (classes,name,phone,partymember,address)"+
                                              " values(?,?,?,?,?)");
              con.setAutoCommit(false);

              pStmt.setString(1,classes);
              pStmt.setString(2,name);
              pStmt.setString(3,phone);
              pStmt.setString(4,partymember);
              pStmt.setString(5,address);
              int j=pStmt.executeUpdate();
              con.commit();
        }
      catch(Exception ex)
      {
              try{
                      con.rollback();
                }catch(SQLException sqlex){
                      sqlex.printStackTrace(System.out);
              }
              throw ex;
      }finally{
        try{
          pStmt.close();
          con.close();
        }catch(Exception e){e.printStackTrace();}
      }

  }
  public static Vector search(String strSql)throws Exception{
      Vector addressbookBeans=new Vector();
      Connection con= DBUtils.getConnection();
      PreparedStatement pStmt=null;
      ResultSet rs=null;
      try{
        pStmt=con.prepareStatement(strSql);
        rs=pStmt.executeQuery();
        while(rs.next())
          addressbookBeans.add(new AddressBookBean(
          rs.getString("CLASSES"),rs.getString("NAME"),rs.getString("PHONE"),rs.getString("PARTY MEMBER"),rs.getString("ADDRESS")));

        return addressbookBeans;
      }finally{
          try{
            rs.close();
            pStmt.close();
            con.close();
          }catch(Exception e){e.printStackTrace();}
      }
   }

}