quanxian.java

cs结构的一个公交车系统好有使用价值啊下吧--- --- ---

package bus;

import java.awt.*;
import javax.swing.*;
import java.util.*;
import javax.swing.table.*;
import java.awt.event.*;

public class QuanXian extends JPanel {
  BorderLayout borderLayout1 = new BorderLayout();
  JTabbedPane jTabbedPane1 = new JTabbedPane();
  JPanel p1 = new JPanel();
  JScrollPane sp = new JScrollPane();
  BorderLayout borderLayout2 = new BorderLayout();
  JTable tb = new JTable();
  JPanel p2 = new JPanel();
  JButton bt1 = new JButton();
  JButton bt2 = new JButton();
  JButton bt3 = new JButton();
  Vector head = new Vector();
  DefaultTableModel model=new DefaultTableModel();
  BusManager bm=new BusManager();
  Vector vt=new Vector();
  MainFrame mf;

  public QuanXian() {
    try {
      jbInit();
    }
    catch(Exception ex) {
      ex.printStackTrace();
    }
  }
  void jbInit() throws Exception {
    this.setLayout(borderLayout1);
    p1.setBackground(new Color(224, 224, 254));
    p1.setFont(new java.awt.Font("Dialog", 0, 16));
    p1.setLayout(borderLayout2);
    jTabbedPane1.setBackground(new Color(224, 224, 254));
    jTabbedPane1.setFont(new java.awt.Font("Dialog", 0, 16));
    bt1.setBackground(new Color(254, 231, 251));
    bt1.setFont(new java.awt.Font("Dialog", 0, 12));
    bt1.setPreferredSize(new Dimension(60, 25));
    bt1.setText("修改");
    bt2.setBackground(new Color(254, 231, 251));
    bt2.setFont(new java.awt.Font("Dialog", 0, 12));
    bt2.setPreferredSize(new Dimension(60, 25));
    bt2.setText("取消");
    bt3.setBackground(new Color(254, 231, 251));
    bt3.setFont(new java.awt.Font("Dialog", 0, 12));
    bt3.setPreferredSize(new Dimension(60, 25));
    bt3.setText("重置");
    tb.setBackground(new Color(224, 224, 254));
    tb.setFont(new java.awt.Font("Dialog", 0, 16));
    tb.setColumnSelectionAllowed(true);
    tb.setRowHeight(30);
    sp.getViewport().setBackground(new Color(224, 224, 254));
    sp.setFont(new java.awt.Font("Dialog", 0, 16));
    this.setBackground(new Color(224, 224, 254));
    this.setFont(new java.awt.Font("Dialog", 0, 16));
    p2.setBackground(new Color(224, 224, 254));
    this.add(jTabbedPane1,  BorderLayout.CENTER);
    jTabbedPane1.add(p1,   "用户权限修改");
    p1.add(sp,  BorderLayout.CENTER);
    p1.add(p2,  BorderLayout.SOUTH);
    p2.add(bt1, null);
    p2.add(bt2, null);
    p2.add(bt3, null);
    sp.getViewport().add(tb, null);
    tb.setGridColor(Color.pink);
    tb.getTableHeader().setBackground(new Color(224, 224, 254));
    tb.getTableHeader().setFont(new Font("宋体",Font.PLAIN,16));
    tb.setRowHeight(30);
    head.add("序号");
    head.add("人员");
    head.add("权限大小");
    model.setColumnIdentifiers(head);
    tb.setModel(model);
    String s1="select * from QuanXian";
    vt=bm.selectBus(s1);
    for(int i=0;i<vt.size();i++)
    {
      Vector one=(Vector)vt.get(i);
      model.addRow(one);
    }
    bt1.addActionListener(new AL());
    bt2.addActionListener(new AL());
    bt3.addActionListener(new AL());
  }
  class AL implements ActionListener
  {
    public void actionPerformed(ActionEvent e)
    {
      if(e.getSource()==bt1)
      {
        Object re = model.getValueAt(tb.getSelectedRow(), 1);
        Object dj = model.getValueAt(tb.getSelectedRow(), 2);
        String s1 =JOptionPane.showInputDialog(null,"请输入修改后的权限大小：");
        String s2 = "update QuanXian set Dengji='"+s1+"' where People='" +
            re + "'";
        bm.updateBus(s2);
        JOptionPane.showMessageDialog(null, "修改成功");
      }
      if(e.getSource()==bt2)
      {
        mf.pc.removeAll();
        mf.pc.validate();
      }
      if(e.getSource()==bt3)
      {
        String s1 = "select * from QuanXian";
        vt = bm.selectBus(s1);
        for (int i = 0; i < vt.size(); i++)
        {
          Vector one = (Vector) vt.get(i);
          model.addRow(one);
        }
      }
    }
  }
}