cl.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 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("删除");
	PicButton bt_save=new PicButton("保存");
	PicButton bt_qx=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);
		ps.add(bt_save);
		ps.add(bt_qx);
		this.add(ps,"South");
		head.add("ID");
		head.add("BusNum");

		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_save.addActionListener(new Al());
		bt_add.addActionListener(new Al());
		bt_del.addActionListener(new Al());
		bt_qx.addActionListener(new Al());
		}
	class Al implements ActionListener
	{
	  public void actionPerformed(ActionEvent e)
	  {
	  	BusManager bm=new BusManager();
	  	if(e.getSource()==bt_add)
	  	{
	  	        model.addRow(new Vector());
	    	    String s="insert into BusGuanli  (BusPai) values('')";
	    	    System.out.println (s);
	    	    bm.updateBus(s);
	    	    Vector vt=bm.selectBus("select max(ID) from BusGuanli");
	    	    Object obj=((Vector)vt.get(0)).get(0);
	    	  //  System.out.println (obj.toString()+"\t"+table.getRowCount());
	    	    model.setValueAt(obj,table.getRowCount()-1,0);
	  	}
	  	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);
	  	}
	    else if(e.getSource()==bt_save)
	  	{
	  	    	int row=table.getSelectedRow();
    	    	String s1=
    	    	Object name=model.getValueAt(row,1);
    	    	Object area=model.getValueAt(row,2);
    	    	String s="update BusGuanli set BusPai='"+name+"',BusNum='"+area+"' where ID="+id;
    	    	System.out.println (s);
    	    	bm.updateBus(s);
	  	}
	  	else if(e.getSource()==bt_qx)
	  	{
	  	  JOptionPane.showMessageDialog(null,"确实要退出吗？");
	  	}
	  	}
	}
	}