manuofmemdao.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.ManuOfMemBean;

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

  public ManuOfMemDAO() {
  }

  public Vector getManufacturer() {
    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 manufacturersofmemory";
      pStatement = dbConnection.prepareStatement(motList);
      resultSet = pStatement.executeQuery();
      ManuOfMemBean mmb=new ManuOfMemBean();
      while (resultSet.next()) {
        mmb.setRecord(resultSet.getString(1));
      }
      return mmb.getRecord();
    }
    catch (SQLException ex) {
      System.out.println("gmErr");
      return null;
    }
    finally {
      ConnectionManager.closeResultSet(resultSet);
      ConnectionManager.closeStatement(pStatement);
      ConnectionManager.closeConnection(dbConnection);
    }
  }

}