cl.java~5~

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 CL extends JPanel{
	JTable table=new JTable();
	DefaultTableModel model=new DefaultTableModel();
	Vector head=new Vector();
    JLabel bt=new JLabel("车辆类型信息");
	PicButton bt_add=new PicButton("点我");
	PicButton bt_del=new PicButton("删除");
	JLabel lab=new JLabel("车辆类型");
	JTextField tf=new JTextField(10);
	Border border=BorderFactory.createLineBorder(Color.green);
	Border border1=BorderFactory.createRaisedBevelBorder();
	public CL(){
		this.setLayout(new BorderLayout());
      
		this.add(bt,"North");
		bt.setPreferredSize(new Dimension(70,25));
		JScrollPane sp=new JScrollPane(table);
		this.add(sp,"Center");
		JPanel p=new JPanel();
		p.setLayout(new FlowLayout());
		p.add(lab);
		p.add(tf);
		this.add(p,"East");
		JPanel ps=new JPanel();
		ps.add(bt_add);
		ps.add(bt_del);
		this.add(ps,"South");
		head.add("编号");
		head.add("车辆类型");
		model.setColumnIdentifiers(head);
		table.setModel(model);
		table.setBorder(border);
		table.getTableHeader().setBackground(Color.cyan);
		table.setRowHeight(20);
        table.setGridColor(Color.pink);
        table.setBackground(Color.white);
		ps.setBorder(border1);
		bt_add.addActionListener(new Al());
		bt_del.addActionListener(new Al());
		table.addMouseListener(new ML());
		}
	class ML extends MouseAdapter{
		public void mouseClicked(MouseEvent e){
			String sm=model.getValueAt(table.getSelectedRow(),1).toString();
		    tf.setText(sm);
			}
		}
	class Al implements ActionListener
	{
	  public void actionPerformed(ActionEvent e)
	  {
	  	BusManager bm=new BusManager();
	  	if(e.getSource()==bt_add)
	  	{
	  			String s="select ID,BusNum from BusGuanli ";
                Vector vt=bm.selectBus(s);
   	            model.setDataVector(vt,head);
	  	}
	  	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);
	  	}

	  	}
	}
	}