professiontype.java~24~

一个基于JAVA的BS结构的宠物诊所管理系统.是当年在学校时写的,大家指点一下.

package gxaccp.t07.guoneng_wei.petclinicmanagesystem.beans;

import java.io.*;
import java.sql.*;
import java.util.*;

import gxaccp.t07.guoneng_wei.jdbc.*;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class ProfessionType
    implements Serializable {
  private String id = "";//兽医类型编号
  private String professionName = "";//兽医类型名
  public ProfessionType() {
  }
  public static Vector getProfessionTypes() {
      String select = "SELECT * FROM ProfessionType";
      Connection con = DataBaseAccess.getConnection();
      PreparedStatement pst = null;
      ResultSet rs = null;
      try {
        Vector v = new Vector();
        pst = con.prepareStatement(select);
        rs = pst.executeQuery();
        while (rs.next()) {
          ProfessionType pft = new ProfessionType();
          pft.setId(rs.getString("ID"));
          pft.setProfessionName(rs.getString("ProfessionName"));
          v.addElement(pft);
        }
        return v;
      }
      catch (Exception ex) {
        System.out.println("!!!!!!!!!异常出现在获取宠物类型时的getProfessionType方法里!!!!!!!!!");
      }
      finally {
        DataBaseAccess.closeResultSet(rs);
        DataBaseAccess.closeStatement(pst);
        DataBaseAccess.closeConnection(con);
      }
      return null;
  }

  public String getId() {
    return id;
  }

  public String getProfessionName() {
    return professionName;
  }

  public void setId(String id) {
    this.id = id;
  }

  public void setProfessionName(String professionName) {
    this.professionName = professionName;
  }

  public boolean addNewProfessionType(){
    Connection con = DataBaseAccess.getConnection();
     PreparedStatement pst = null;
     boolean insert =false;
     try {
       pst = con.prepareStatement("");
       pst.setString(1,this.getProfessionName());
       if (pst.executeUpdate()>0) {
          insert  =true ;
       }

     }
     catch (Exception ex) {
       System.out.println("!!!!!!!!!异常出现在获取宠物类型时的addProfessionType方法里!!!!!!!!!");
     }
     finally {

       DataBaseAccess.closeStatement(pst);
       DataBaseAccess.closeConnection(con);
     }

     if (insert>0) {

     }

  }
}