memorydao.java

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

package pcdiysystem.Dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Vector;
import pcdiysystem.Beans.MemoryBean;
import javax.swing.JOptionPane;
import pcdiysystem.Panel.EditPanel;
import javax.swing.table.TableModel;

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

  public MemoryDAO() {
  }

  public Vector getBaseInfomation(String manufacturer){
  Connection dbConnection=null;
  PreparedStatement pStatement=null;
  ResultSet resultSet=null;
  try {
    dbConnection = ConnectionManager.getConnection();
    if(dbConnection!=null)
      System.out.println("OK!");
    String proList = "select p.* from memory as p left outer join Manufacturersofmemory as ma on ma.Manufacturerid=p.manufacturerid where ma.manufacturer=?";
    pStatement = dbConnection.prepareStatement(proList);
    pStatement.setString(1, manufacturer);
    resultSet=pStatement.executeQuery();
    MemoryBean mb=new MemoryBean();
    while(resultSet.next()){
     mb.setRecord(resultSet.getString(3));
     mb.setRecord(resultSet.getString(4));
     mb.setRecord(resultSet.getString(5));
     mb.setRecord(resultSet.getString(6));
     mb.setRecord(resultSet.getString(7));
     mb.setRecord(resultSet.getString(8));
     mb.setRecord(resultSet.getString(9));
     mb.setFile(mb.getRecord());
    }
    return mb.getFile();
  }
  catch (SQLException ex) {
    System.out.println("mErr");
    return null;
  }finally{
    ConnectionManager.closeResultSet(resultSet);
    ConnectionManager.closeStatement(pStatement);
    ConnectionManager.closeConnection(dbConnection);
  }
}

}