dl.java~3~

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 DL 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 DL(){
		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);
        table.setFont(font);
		ps.setBorder(border1);
		bt_add.addActionListener(new Al());
		bt_del.addActionListener(new Al());

		table.addMouseListener(new ML());
    try {
      jbInit();
    }
    catch(Exception e) {
      e.printStackTrace();
    }
		}
	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,BusPai 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);
	  	}
	  	}
	}
  private void jbInit() throws Exception {
    this.setFont(new java.awt.Font("Dialog", 0, 16));
  }
	}