editpanel.java~220~

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

package pcdiysystem.Panel;

import java.awt.*;
import pcdiysystem.Dao.MotherboardsDAO;
import javax.swing.JTable;
import javax.swing.ListSelectionModel;
import java.util.Vector;
import pcdiysystem.Dao.ProcessorsDAO;
import javax.swing.table.DefaultTableModel;
import javax.swing.table.TableModel;
import javax.swing.DefaultCellEditor;
import javax.swing.JPanel;
import java.awt.event.ActionEvent;
import javax.swing.JOptionPane;
import javax.swing.JButton;
import javax.swing.JTextField;
import javax.swing.JTextArea;
import javax.swing.JLabel;
import java.awt.event.MouseEvent;
import pcdiysystem.Dao.DefaultProjectDAO;
import pcdiysystem.Panel.TableModelOfEditPanel;
import pcdiysystem.Panel.ComponentListPanel_cboManufacturer_itemAdapter;
import java.awt.event.ActionListener;
import java.awt.event.ItemListener;
import java.awt.event.ItemEvent;
import java.awt.event.MouseAdapter;

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

  //JPanel pnlBottomContainer=new JPanel(new BorderLayout());
  JButton btnAdd=new JButton("添加记录");
  JButton btnNextRecord=new JButton("再添加一条记录");
  JButton btnReload=new JButton("刷新");
  JButton btnWrite=new JButton("把数据写入数据库");
  //JTextArea txtDetail=new JTextArea(5,50);
  DefaultTableModel editTableModel;
  JTable tabAddRecord;
  EditPanel_cboManufacturer_mouseAdapter cboMouseEvent;

  public EditPanel() {
    try {
      jbInit();
    }
    catch (Exception exception) {
      exception.printStackTrace();
    }


  }

  private void jbInit() throws Exception {
    btnSelect.setText("修改当前选中记录");
    btnCancel.setText("删除当前选中记录");
    creatNewComponentTable("Intel");
    pnlBottom.add(btnReload);
    pnlBottom.add(btnAdd);
    pnlBottom.add(btnNextRecord);
    pnlBottom.add(btnWrite);
    //pnlBottomContainer.add(pnlBottom,BorderLayout.CENTER);
    //pnlBottomContainer.add(txtDetail,BorderLayout.NORTH);
    //pnlBottomContainer.add(new JLabel("硬件细节"),BorderLayout.WEST);
    //this.add(pnlBottomContainer,BorderLayout.SOUTH);
    btnNextRecord.setEnabled(false);
    btnWrite.setEnabled(false);
    btnAdd.addActionListener(new EditPanel_btnAdd_actionAdapter(this));
    btnReload.addActionListener(new EditPanel_btnReload_actionAdapter(this));
    btnNextRecord.addActionListener(new EditPanel_btnNextRecord_actionAdapter(this));
    btnWrite.addActionListener(new EditPanel_btnWrite_actionAdapter(this));
  }

  void creatNewComponentTable(String manufacturer){
    int index=cboComponents.getSelectedIndex();
    Vector colName=new Vector();
    Vector cellData=new Vector();
    switch(index){
      case 0:
        ProcessorsDAO pd=new ProcessorsDAO();
        cellData=pd.getBaseInfomation(manufacturer);
        colName.add("型号");colName.add("主频");colName.add("前端总线");
        colName.add("接口类型");colName.add("库存");colName.add("价格");
        break;
      case 1:{
        break;
      }
      case 2:{
        MotherboardsDAO md=new MotherboardsDAO();
        cellData=md.getBaseInfomation(manufacturer,MotherboardsDAO.EDITPANEL);
        colName.add("数据库记录编号");colName.add("型号");colName.add("CPU插槽类型");colName.add("北桥芯片");
        colName.add("支持CPU类型");colName.add("支持显卡标准");colName.add("硬件描述");colName.add("库存");
        colName.add("价格");
      }
    }
    editTableModel=new TableModelOfEditPanel();
    editTableModel.setDataVector(cellData,colName);
    tabComData=new JTable(editTableModel);
    tabComData.addMouseMotionListener(new
                                      ComponentListPanel_tabComData_mouseMotionAdapter(this));
    tabComData.addMouseListener(new ComponentListPanel_tabComData_mouseAdapter(this));
    for(int i=0;i<colName.size();i++){
      tabComData.getColumnModel().getColumn(i).setPreferredWidth(150);
    }
    tabComData.getColumnModel().getColumn(4).setPreferredWidth(200);
    tabComData.setAutoResizeMode(tabComData.AUTO_RESIZE_OFF);
    tabComData.setDragEnabled(false);
    tabComData.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);
    tabComData.setRowSelectionInterval(0,0);
    tabComData.setDragEnabled(false);
    tabComData.getTableHeader().setReorderingAllowed(false);
    scpListOfComponent.getViewport().add(tabComData);
  }

  public void creatInsertTable(){
    JTextField txtTemp=new JTextField("tt");
    txtTemp.setToolTipText("标识列，不允许修改！");
    txtTemp.setEditable(false);
    tabAddRecord=new JTable(1,9);
    tabAddRecord.getColumnModel().getColumn(0).setCellEditor(new DefaultCellEditor(txtTemp));
    for(int i=0;i<9;i++){
      tabAddRecord.getColumnModel().getColumn(i).setPreferredWidth(150);
    }
    tabAddRecord.getColumnModel().getColumn(4).setPreferredWidth(200);
    tabAddRecord.setValueAt("￥",0,8);
    tabAddRecord.setTableHeader(tabComData.getTableHeader());
    tabAddRecord.setAutoResizeMode(tabAddRecord.AUTO_RESIZE_OFF);
    tabAddRecord.setDragEnabled(false);
    tabAddRecord.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);
    tabAddRecord.setDragEnabled(false);
    tabAddRecord.getTableHeader().setReorderingAllowed(false);
    scpListOfComponent.getViewport().add(tabAddRecord);
  }

  public void btnSelect_actionPerformed(ActionEvent e) {
    int selectedRow=tabComData.getSelectedRow();
    Object recordId=tabComData.getValueAt(selectedRow,0);
    Vector data=new Vector();
    for(int i=1;i<tabComData.getColumnCount();i++){
      data.add(tabComData.getValueAt(selectedRow,i));
    }
    Object[] buttonText = {
        "是的，不改了", "让我再想想"};
    int index = JOptionPane.showOptionDialog(this, "您确定修改数据库编号为"+recordId+"的记录吗？", "",
                                             JOptionPane.OK_CANCEL_OPTION,
                                             JOptionPane.QUESTION_MESSAGE, null,
                                             buttonText, buttonText[0]);
    if(index==0){
      MotherboardsDAO md = new MotherboardsDAO();
      boolean isSuceed = md.updateRecord(Integer.parseInt(String.valueOf(
          recordId)), data);
      if (isSuceed) {
        JOptionPane.showMessageDialog(this, "已经成功修改数据");
      }
      else {
        JOptionPane.showMessageDialog(this, "修改数据失败，请检查输入的数据是否合法");
      }
    }
  }

  public void btnCancel_actionPerformed(ActionEvent e) {
    int selectedRow=tabComData.getSelectedRow();
    Object recordId=tabComData.getValueAt(selectedRow,0);
    Object[] buttonText = {
        "是的，我要删除", "让我再想想"};
    int index = JOptionPane.showOptionDialog(this, "您确定删除数据据库编号为"+recordId+"的记录吗？", "",
                                             JOptionPane.OK_CANCEL_OPTION,
                                             JOptionPane.QUESTION_MESSAGE, null,
                                             buttonText, buttonText[0]);
    if(index==0){
      MotherboardsDAO md = new MotherboardsDAO();
      boolean isSuceed = md.deleteRecord(Integer.parseInt(String.valueOf(
          recordId)));
      if (isSuceed) {
        JOptionPane.showMessageDialog(this, "已经成功删除数据");
      }
      else {
        JOptionPane.showMessageDialog(this, "删除数据失败");
      }
      System.out.println(isSuceed);
    }
  }

  public void btnAdd_actionPerformed(ActionEvent e){
    if(btnSelect.isEnabled()){
      cboMouseEvent=new EditPanel_cboManufacturer_mouseAdapter(this);
      JOptionPane.showMessageDialog(this,"进入添加记录模式");
      this.creatInsertTable();
      btnNextRecord.setEnabled(true);
      btnWrite.setEnabled(true);
      btnAdd.setText("退出添加记录模式");
      cboComponents.setEnabled(false);
      for(int i=0;i<cboManufacturer.getItemListeners().length;i++){
        cboManufacturer.removeItemListener(cboManufacturer.
                                           getItemListeners()[i]);
      }
      cboManufacturer.addItemListener(new EditPanel_cboManufacturer_itemAdapter(this));
      cboManufacturer.addMouseListener(cboMouseEvent);
      btnSelect.setEnabled(false);
      btnCancel.setEnabled(false);
    }else{
      JOptionPane.showMessageDialog(this,"退出添加记录模式");
      btnNextRecord.setEnabled(false);
      btnWrite.setEnabled(false);
      cboComponents.setEnabled(true);
      btnSelect.setEnabled(true);
      btnCancel.setEnabled(true);
      for(int i=0;i<cboManufacturer.getItemListeners().length;i++){
        cboManufacturer.removeItemListener(cboManufacturer.
                                           getItemListeners()[i]);
      }
      cboManufacturer.removeMouseListener(cboMouseEvent);
      if(cboManufacturer.getItemCount()!=0){
        this.creatNewComponentTable(String.valueOf(cboManufacturer.
            getSelectedItem()));
      }
      cboManufacturer.addItemListener(new ComponentListPanel_cboManufacturer_itemAdapter(this));
    }
  }

  public void btnReload_actionPerformed(ActionEvent e){
    if(cboManufacturer.getItemCount()!=0){
      this.creatNewComponentTable(String.valueOf(cboManufacturer.
                                                 getSelectedItem()));
    }
  }

  public void btnNextRecord_actionPerformed(ActionEvent e){
    DefaultTableModel temp=((DefaultTableModel)tabAddRecord.getModel());
    temp.addRow(new Vector());
    tabAddRecord.setValueAt("￥",temp.getRowCount()-1,8);
  }

  public void btnWrite_actionPerformed(ActionEvent e){
    Object[] buttonText = {
        "是的，我确定", "不，让我再想想"};
    int index = JOptionPane.showOptionDialog(this, "您确定把表格中的数据添加到数据库吗？", "",
                                             JOptionPane.OK_CANCEL_OPTION,
                                             JOptionPane.QUESTION_MESSAGE, null,
                                             buttonText, buttonText[0]);
    if(index==0){
      int i;
      int lastColumn = tabAddRecord.getModel().getColumnCount();
      int rowCount = tabAddRecord.getModel().getRowCount();
      for (i = 0; i < rowCount; i++) {
        MotherboardsDAO md = new MotherboardsDAO(this);
        if (!md.isPriceFormatCorrect(String.valueOf(tabAddRecord.getModel().
            getValueAt(i, lastColumn - 1)))) {
          break;
        }
      }
      if (i == rowCount) {
        int id=cboManufacturer.getSelectedIndex();
        MotherboardsDAO md=new MotherboardsDAO();
        Vector insertData=md.getDataFromTableMOdel(tabAddRecord.getModel());
        md.insertFile(String.valueOf(id),insertData);
        JOptionPane.showMessageDialog(this, "已经成功写入数据库");
        System.out.println(((Vector)insertData.get(0)).get(0));
      }
    }
  }

  public void tabComData_mouseClicked(MouseEvent e) {
    if(e.getClickCount()==1 && e.getButton()==e.BUTTON1){
      int row=tabComData.getSelectedRow();
      String text=String.valueOf(tabComData.getValueAt(row,6));
      String [] words=text.split("/");
      txtDetail.setText("");
      for(int i=0;i<words.length;i++){
        txtDetail.append(words[i]+"\n");
      }
    }
  }

  public void tabComData_mouseMoved(MouseEvent e) {
    int rowIndex=this.tabComData.getSelectedRow();
    int lastColumnIndex=this.tabComData.getColumnCount()-1;
    tabComData.setToolTipText("数据库记录编号："+tabComData.getValueAt(rowIndex,0));
  }

  public void EditPanel_cboManufacturer_itemStateChanged(ItemEvent e){
    creatInsertTable();
  }

  public void cboManufacturer_mouseEntered(MouseEvent e) {
    JOptionPane.showMessageDialog(this,"做出选择后未保存数据将会丢失！","警告",JOptionPane.INFORMATION_MESSAGE);
  }

}

class TableModelOfEditPanel
    extends DefaultTableModel{
  public TableModelOfEditPanel() {
  }

  public boolean isCellEditable(int rowIndex, int columnIndex) {
    if (columnIndex == 0) {
      return false;
    }
    return true;
  }
}

class EditPanel_btnAdd_actionAdapter
    implements ActionListener {
  private EditPanel adaptee;
  EditPanel_btnAdd_actionAdapter(EditPanel adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {
    adaptee.btnAdd_actionPerformed(e);
  }
}

class EditPanel_btnReload_actionAdapter
    implements ActionListener {
  private EditPanel adaptee;
  EditPanel_btnReload_actionAdapter(EditPanel adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {
    adaptee.btnReload_actionPerformed(e);
  }
}

class EditPanel_btnNextRecord_actionAdapter
    implements ActionListener {
  private EditPanel adaptee;
  EditPanel_btnNextRecord_actionAdapter(EditPanel adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {
    adaptee.btnNextRecord_actionPerformed(e);
  }
}

class EditPanel_btnWrite_actionAdapter
    implements ActionListener {
  private EditPanel adaptee;
  EditPanel_btnWrite_actionAdapter(EditPanel adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {
    adaptee.btnWrite_actionPerformed(e);
  }
}

class EditPanel_cboManufacturer_itemAdapter
    implements ItemListener {
  private EditPanel adaptee;
  EditPanel_cboManufacturer_itemAdapter(EditPanel adaptee) {
    this.adaptee = adaptee;
  }

  public void itemStateChanged(ItemEvent e) {
    adaptee.EditPanel_cboManufacturer_itemStateChanged(e);
  }
}

class EditPanel_cboManufacturer_mouseAdapter
    extends MouseAdapter {
  private EditPanel adaptee;
  EditPanel_cboManufacturer_mouseAdapter(EditPanel adaptee) {
    this.adaptee = adaptee;
  }

  public void mouseEntered(MouseEvent e) {
    adaptee.cboManufacturer_mouseEntered(e);
  }
}