manuofmotdao.java

些程序用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.ManuOfMotBean;

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

  public ManuOfMotDAO() {
  }

  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 motList = "select manufacturer from manufacturersofmotherboard";
      pStatement = dbConnection.prepareStatement(motList);
      resultSet=pStatement.executeQuery();
      while(resultSet.next()){
        ManuOfMotBean mmb=new ManuOfMotBean();
        //mmb.setRecord(resultSet.getString(1));
        //list.addElement(mmb.getRecord());
        mmb.setManufacturer(resultSet.getString(1));
        list.addElement(mmb.getManufacturer());
      }
    }
    catch (SQLException ex) {
    }finally{
      ConnectionManager.closeResultSet(resultSet);
      ConnectionManager.closeStatement(pStatement);
      ConnectionManager.closeConnection(dbConnection);
    }
    return list;
  }
}