quanxian.java~10~

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();

  public QuanXian() {
    try {
      jbInit();
    }
    catch(Exception ex) {
      ex.printStackTrace();
    }
  }
  void jbInit() throws Exception {
    this.setLayout(borderLayout1);
    p1.setFont(new java.awt.Font("Dialog", 0, 16));
    p1.setLayout(borderLayout2);
    jTabbedPane1.setFont(new java.awt.Font("Dialog", 0, 16));
    bt1.setFont(new java.awt.Font("Dialog", 0, 12));
    bt1.setPreferredSize(new Dimension(60, 25));
    bt1.setText("修改");
    bt2.setFont(new java.awt.Font("Dialog", 0, 12));
    bt2.setPreferredSize(new Dimension(60, 25));
    bt2.setText("取消");
    bt3.setFont(new java.awt.Font("Dialog", 0, 12));
    bt3.setPreferredSize(new Dimension(60, 25));
    bt3.setText("重置");
    tb.setFont(new java.awt.Font("Dialog", 0, 16));
    tb.setColumnSelectionAllowed(true);
    tb.setRowHeight(30);
    sp.setFont(new java.awt.Font("Dialog", 0, 16));
    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);
    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());
  }
  class AL implements ActionListener
  {
    public void actionPerformed(ActionEvent e)
    {
      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,"修改成功");
    }
  }
}