cheppanel.java~4~

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();
  JTable table=new JTable();
  Vector head=new Vector();
  BusManager bm=new BusManager();
   DefaultTableModel model=new  DefaultTableModel();
  JButton bt_save = new JButton();
  static String ip;
 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("保存");
    table.setGridColor(Color.pink);
    table.getTableHeader().setBackground(new Color(224, 224, 254));
    table.getTableHeader().setFont(new Font("宋体",Font.PLAIN,16));
    table.setRowHeight(30);
    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));
    sp.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));
    this.add(sp,"Center");
    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(254, 231, 251));
    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){
            model.addRow(new Vector());
            //String s="insert into PiaoRu(BusPai) values(' ')";
            //bm.updateBus(s);
            Vector vt=bm.selectBus("select max(id) from PiaoRu");
            Object obj=((Vector)vt.get(0)).get(0);
            model.setValueAt(obj,table.getRowCount()-1,0);
            //String s="insert into PiaoRu(Buspai) values('')";
            //System.out.print(s);
            //bm.updateBus(s);
          }
          if(e.getSource()==bt3){
            int row=table.getSelectedRow();
            if(row<0)
              return;
            String obj=model.getValueAt(row,0).toString();
            int a=Integer.parseInt(obj);
            String s="delete from PiaoRu where id="+obj;
            System.out.println(obj);
            System.out.println(s);
            bm.updateBus(s);
            model.removeRow(row);
            System.out.println("删除成功");
          }
          if(e.getSource()==bt_save){
            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){
            int row=table.getSelectedRow();
            ip=model.getValueAt(row,0).toString();
            new XFrame();
          }
          if(e.getSource()==bt5){

          }
       }
  }
}