cheppanel.java

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

package bus;

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


public class ChepPanel
    extends JPanel {
  JPanel pe1 = new JPanel();
  JPanel pe2 = new JPanel();
  JButton bt2 = new JButton("增加");
  JButton bt3 = new JButton("删除");
  JButton bt4 = new JButton("修改");
  JButton bt5 = new JButton("取消");
  BorderLayout borderLayout1 = new BorderLayout();
  JLabel le1 = new JLabel();
  JComboBox box = new JComboBox();
  JButton bt1 = new JButton();
  Vector head = new Vector();
  BusManager bm = new BusManager();
  DefaultTableModel model = new DefaultTableModel();
  JButton bt_save = new JButton();
  static String ip;
  JTable table = new JTable();
  MainFrame mf;
  ChepPanel() {
    try {
      jbInit();
    }
    catch (Exception ex) {
      ex.printStackTrace();
    }
  }

  public void jbInit() throws Exception {
    this.setLayout(borderLayout1);
    le1.setFont(new java.awt.Font("Dialog", 0, 14));
    le1.setText("请输入查询车辆：");
    bt1.setBackground(new Color(254, 231, 251));
    bt1.setFont(new java.awt.Font("Dialog", 0, 12));
    bt1.setPreferredSize(new Dimension(60, 25));
    bt1.setText("查询");
    box.setBackground(new Color(254, 231, 251));
    box.setPreferredSize(new Dimension(150, 22));
    box.setRequestFocusEnabled(true);
    box.setPopupVisible(false);
    bt2.setBackground(new Color(254, 231, 251));
    bt2.setFont(new java.awt.Font("Dialog", 0, 12));
    bt2.setPreferredSize(new Dimension(60, 25));
    bt3.setBackground(new Color(254, 231, 251));
    bt3.setFont(new java.awt.Font("Dialog", 0, 12));
    bt3.setPreferredSize(new Dimension(60, 25));
    bt4.setBackground(new Color(254, 231, 251));
    bt4.setFont(new java.awt.Font("Dialog", 0, 12));
    bt4.setPreferredSize(new Dimension(60, 25));
    bt4.setFocusPainted(true);
    bt5.setBackground(new Color(254, 231, 251));
    bt5.setFont(new java.awt.Font("Dialog", 0, 12));
    bt5.setPreferredSize(new Dimension(60, 25));
    bt_save.setBackground(new Color(254, 231, 251));
    bt_save.setFont(new java.awt.Font("Dialog", 0, 12));
    bt_save.setPreferredSize(new Dimension(60, 25));
    bt_save.setText("保存");
    this.setBackground(new Color(224, 224, 254));
    this.setFont(new java.awt.Font("Dialog", 0, 16));
    pe1.setBackground(new Color(224, 224, 254));
    pe2.setBackground(new Color(224, 224, 254));
    table.setBackground(new Color(224, 224, 254));
    table.setFont(new java.awt.Font("Dialog", 0, 16));
    pe1.add(le1, null);
    this.add(pe1, BorderLayout.NORTH);
    pe1.add(box, null);
    pe1.add(bt1, null);
    pe2.add(bt2);
    pe2.add(bt_save, null);
    pe2.add(bt3);
    pe2.add(bt4);
    pe2.add(bt5);
    JScrollPane sp = new JScrollPane(table);
    sp.getViewport().setBackground(new Color(224, 224, 254));
    sp.setFont(new java.awt.Font("Dialog", 0, 16));
    this.add(sp, "Center");
    sp.getViewport().add(table, null);
    this.add(pe2, "South");
    head.add("ID");
    head.add("车牌号");
    head.add("出车时间");
    head.add("收入金额");
    model.setColumnIdentifiers(head);
    table.setModel(model);
    table.setGridColor(Color.pink);
    table.getTableHeader().setBackground(new Color(224, 224, 254));
    table.getTableHeader().setFont(new Font("宋体", Font.PLAIN, 16));
    table.setRowHeight(30);
    box.addItem("全部");
    Vector no = new Vector();
    no = bm.selectBus("select BusPai from BusGuanli");
    for (int i = 0; i < no.size(); i++) {
      Vector vt = new Vector();
      vt = (Vector) no.get(i);
      box.addItem(vt.get(0));
    }
    bt1.addActionListener(new AL());
    bt2.addActionListener(new AL());
    bt3.addActionListener(new AL());
    bt4.addActionListener(new AL());
    bt_save.addActionListener(new AL());
  }

  class AL
      implements ActionListener {
    public void actionPerformed(ActionEvent e) {
      if (e.getSource() == bt1) {
        String name = box.getSelectedItem().toString();
        if (name.equals("全部")) {
          String s = "select * from PiaoRu";
          Vector one = bm.selectBus(s);
          model.setDataVector(one, head);
        }
        else {
          String s = "select * from PiaoRu where BusPai='" + name + "'";
          Vector one = bm.selectBus(s);
          model.setDataVector(one, head);
        }
      }
      if (e.getSource() == bt2) {
        String s2 = "select Dengji from QuanXian where People='" + Login.s1 +
            "'";
        Vector vt = bm.selectBus(s2);
        String s3 = ( (Vector) vt.get(0)).get(0).toString();
        int a = Integer.parseInt(s3);
        if (a < 100) {
          JOptionPane.showMessageDialog(null, "您的权限太低，不能进行此项操作");
        }
        else {
          model.addRow(new Vector());
          Vector no = bm.selectBus("select max(id) from PiaoRu");
          Object obj = ( (Vector) no.get(0)).get(0);
          model.setValueAt(obj, table.getRowCount() - 1, 0);
        }

      }
      if (e.getSource() == bt3) {
        String s2 = "select Dengji from QuanXian where People='" + Login.s1 +
            "'";
        Vector vt = bm.selectBus(s2);
        String s3 = ( (Vector) vt.get(0)).get(0).toString();
        int a = Integer.parseInt(s3);
        if (a < 100) {
          JOptionPane.showMessageDialog(null, "您的权限太低，不能进行此项操作");
        }
        else {
          int row = table.getSelectedRow();
          if (row < 0)
            return;
          String obj = model.getValueAt(row, 0).toString();
          int b = Integer.parseInt(obj);
          String s = "delete from PiaoRu where id=" + obj;
          bm.updateBus(s);
          model.removeRow(row);
          JOptionPane.showMessageDialog(null, "删除成功");
        }

      }
      if (e.getSource() == bt_save) {
        String s2 = "select Dengji from QuanXian where People='" + Login.s1 +
            "'";
        Vector vt = bm.selectBus(s2);
        String s3 = ( (Vector) vt.get(0)).get(0).toString();
        int a = Integer.parseInt(s3);
        if (a < 100) {
          JOptionPane.showMessageDialog(null, "您的权限太低，不能进行此项操作");
        }
        else {
          int row = table.getSelectedRow();
          Object id = model.getValueAt(row, 0);
          String pai = model.getValueAt(row, 1).toString();
          String time = model.getValueAt(row, 2).toString();
          String money = model.getValueAt(row, 3).toString();
          String s = "insert into PiaoRu (BusPai,InTime,InLiang) values('" +
              pai + "','" + time + "','" + money + "')";
          bm.updateBus(s);
        }

      }
      if (e.getSource() == bt4) {
        String s2 = "select Dengji from QuanXian where People='" + Login.s1 +
            "'";
        Vector vt = bm.selectBus(s2);
        String s3 = ( (Vector) vt.get(0)).get(0).toString();
        int a = Integer.parseInt(s3);
        if (a < 100) {
          JOptionPane.showMessageDialog(null, "您的权限太低，不能进行此项操作");
        }
        else {
          int row = table.getSelectedRow();
          ip = model.getValueAt(row, 0).toString();
          new XFrame();
        }

      }
      if (e.getSource() == bt5) {
        mf.pc.removeAll();
        mf.pc.validate();
      }
    }
  }
}