cd.java~4~

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

package bus;

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

class cd extends JPanel{
	JTable table=new JTable();
	DefaultTableModel model=new DefaultTableModel();
	Vector head=new Vector();
	PicButton bt_sel=new PicButton("查询");
	PicButton bt_add=new PicButton("添加");
	PicButton bt_del=new PicButton("删除");
	Border border=BorderFactory.createLineBorder(Color.darkGray);
	Border border1=BorderFactory.createLoweredBevelBorder();
	public cd(){
		this.setLayout(new BorderLayout());
		JScrollPane sp=new JScrollPane(table);
		this.add(sp,"Center");
		JPanel ps=new JPanel();

		ps.add(bt_sel);
		ps.add(bt_add);
		ps.add(bt_del);
		this.add(ps,"South");
		head.add("编号");
		head.add("车牌号");
		head.add("车辆类型");
        head.add("车辆颜色");
		head.add("司机");

		model.setColumnIdentifiers(head);
		table.setModel(model);
		table.setBorder(border);
		table.getTableHeader().setBackground(Color.cyan);
		table.setRowHeight(20);
        table.setGridColor(Color.black);
        table.setBackground(Color.yellow);
		ps.setBorder(border1);
		bt_sel.addActionListener(new Al());
		bt_add.addActionListener(new Al());
		bt_del.addActionListener(new Al());
		}
	class Al implements ActionListener
	{
	  public void actionPerformed(ActionEvent e)
	  {
	  	BusManager bm=new BusManager();
	  	if(e.getSource()==bt_sel)
	  	{
	  	   String s="select * from BusGuanli";
	  	   Vector vt=bm.selectBus(s);
	  	   model.setDataVector(vt,head);
	  	}
	  	else if(e.getSource()==bt_add)
	  	{
               
	  	         tj t=new tj();
	  	}
	    else if(e.getSource()==bt_del)
	  	{
	  		    int row=table.getSelectedRow();//获得行号
	    	    if(row<0)
	    	    return;
	    	    Object obj=model.getValueAt(row,0);
	    	    model.removeRow(row);
	    	    String s="delete from BusGuanli where id="+obj;
	    	    bm.updateBus(s);
	         	
	  	}
	  	}
	}
	}