manuofprodao.java~5~

些程序用java实现一个装机程序,不过是一个C/S架构,但是在数据库的设计方面与3层架构的构造方案我想对一些朋友还是否有一定的帮助吧

package pcdiysystem.Dao;

import java.sql.PreparedStatement;
import java.util.Vector;
import java.sql.ResultSet;
import java.sql.Connection;
import java.sql.SQLException;
import pcdiysystem.Beans.ManufacturersOfProcessorBean;

/**
 * <p>Title: 自助装机系统</p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2006</p>
 *
 * <p>Company: </p>
 *
 * @author kamiiiyu
 * @version 1.0
 */
public class ManuOfProDAO {
  public ManuOfProDAO() {
  }

  public Vector getManufacturer(){
    Vector list=new Vector();
    Connection dbConnection=null;
    PreparedStatement pStatement=null;
    ResultSet resultSet=null;
    try {
      dbConnection = ConnectionManager.getConnection();
      if(dbConnection!=null)
        System.out.println("OK!");
      String proList = "select manufacturer from manufacturersofprocessor";
      pStatement = dbConnection.prepareStatement(proList);
      resultSet=pStatement.executeQuery();
      while(resultSet.next()){
        ManufacturersOfProcessorBean mpb=new ManufacturersOfProcessorBean();
        mpb.setRecord(resultSet.getString(1));
        list.addElement(mpb.getRecord());
      }
    }
    catch (SQLException ex) {
    }finally{
      ConnectionManager.closeResultSet(resultSet);
      ConnectionManager.closeStatement(pStatement);
      ConnectionManager.closeConnection(dbConnection);
    }
    return list;
  }
}