callpanel.java

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

package bus;

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

public class CallPanel extends JPanel{
  BorderLayout borderLayout1 = new BorderLayout();
  JPanel jPanel1 = new JPanel();
  JTabbedPane jTabbedPane1 = new JTabbedPane();
  BorderLayout borderLayout2 = new BorderLayout();
  JPanel jPanel2 = new JPanel();
  BorderLayout borderLayout3 = new BorderLayout();
  JPanel jPanel3 = new JPanel();
  JPanel jPanel4 = new JPanel();
  JScrollPane jScrollPane1 = new JScrollPane();
  JTable table = new JTable();
  BorderLayout borderLayout4 = new BorderLayout();
  JLabel la = new JLabel();
  JComboBox box = new JComboBox();
  DefaultTableModel model=new DefaultTableModel();
  Vector head=new Vector();
  BusManager bm=new BusManager();
  JButton bt = new JButton();
  String st="";

  public CallPanel() {
    try {
      jbInit();
    }
    catch(Exception ex) {
      ex.printStackTrace();
    }
  }
  void jbInit() throws Exception {
    this.setBackground(new Color(224, 224, 254));
    this.setFont(new java.awt.Font("Dialog", 0, 16));
    this.setLayout(borderLayout1);
    jPanel1.setBackground(new Color(224, 224, 254));
    jPanel1.setFont(new java.awt.Font("Dialog", 0, 16));
    jPanel1.setLayout(borderLayout2);
    jPanel2.setBackground(new Color(224, 224, 254));
    jPanel2.setFont(new java.awt.Font("Dialog", 0, 16));
    jPanel2.setLayout(borderLayout3);
    jTabbedPane1.setBackground(new Color(224, 224, 254));
    jTabbedPane1.setFont(new java.awt.Font("Dialog", 0, 16));
    jPanel3.setBackground(new Color(224, 224, 254));
    jPanel3.setFont(new java.awt.Font("Dialog", 0, 16));
    jPanel3.setPreferredSize(new Dimension(60, 30));
    jPanel4.setBackground(new Color(224, 224, 254));
    jPanel4.setFont(new java.awt.Font("Dialog", 0, 16));
    jPanel4.setLayout(borderLayout4);
    jScrollPane1.getViewport().setBackground(new Color(224, 224, 254));
    table.setBackground(new Color(224, 224, 254));
    table.setGridColor(Color.pink);
    table.getTableHeader().setBackground(new Color(224, 224, 254));
    table.getTableHeader().setFont(new Font("宋体", Font.PLAIN, 16));
    table.setRowHeight(30);
    table.setFont(new java.awt.Font("Dialog", 0, 16));
    table.setModel(model);
    bt.setBackground(new Color(254, 231, 251));
    bt.setFont(new java.awt.Font("Dialog", 0, 12));
    bt.setPreferredSize(new Dimension(60, 25));
    bt.setText("查询");
    head.add("序号");
    head.add("城市");
    head.add("省份");
    head.add("电话区号");
    head.add("邮政编码");
    model.setColumnIdentifiers(head);
    la.setFont(new java.awt.Font("Dialog", 0, 16));
    la.setText("请选择省：");
    box.setBackground(new Color(254, 231, 251));
    box.setFont(new java.awt.Font("Dialog", 0, 16));
    box.setPreferredSize(new Dimension(100, 25));
    this.add(jPanel1,  BorderLayout.CENTER);
    jPanel1.add(jTabbedPane1,  BorderLayout.CENTER);
    jTabbedPane1.add(jPanel2,  "电话区号邮政编码");
    jPanel2.add(jPanel3,  BorderLayout.NORTH);
    jPanel3.add(la, null);
    jPanel3.add(box, null);
    jPanel3.add(bt, null);
    jPanel2.add(jPanel4,  BorderLayout.CENTER);
    jPanel4.add(jScrollPane1,  BorderLayout.CENTER);
    jScrollPane1.getViewport().add(table, null);
    String sr="select State from State";
    Vector vt=bm.selectBus(sr);
    Vector one=new Vector();
    String s="";
    for (int i = 0; i < vt.size(); i++)
    {
      s=((Vector)vt.get(i)).get(0).toString();
      box.addItem(s);
    }
    box.addItemListener(new BL());
    bt.addActionListener(new AL());
  }
  class BL implements ItemListener
  {
    public void itemStateChanged(ItemEvent e)
    {
      if(e.getStateChange()==ItemEvent.SELECTED)
      {
        st=box.getSelectedItem().toString();
      }
    }
  }
  class AL implements ActionListener
  {
    public void actionPerformed(ActionEvent e)
    {
      if(e.getSource()==bt)
      {
        String s1="select * from City where State='"+st+"'";
        Vector no=bm.selectBus(s1);
        model.setDataVector(no,head);
      }
    }
  }
}