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);
    bt_sel.setBorder(BorderFactory.createBevelBorder(BevelBorder.RAISED));
    bt_add.setBorder(BorderFactory.createBevelBorder(BevelBorder.RAISED));
    bt_del.setBorder(BorderFactory.createBevelBorder(BevelBorder.RAISED));
    bt_sel.setFont(new java.awt.Font("Dialog", 0, 12));
    bt_sel.setPreferredSize(new Dimension(60, 25));
    bt_sel.setBackground(new Color(254, 231, 251));
    bt_add.setFont(new java.awt.Font("Dialog", 0, 12));
    bt_add.setPreferredSize(new Dimension(60, 25));
    bt_add.setBackground(new Color(254, 231, 251));
    bt_del.setFont(new java.awt.Font("Dialog", 0, 12));
    bt_del.setPreferredSize(new Dimension(60, 25));
    bt_del.setBackground(new Color(254, 231, 251));
    this.add(sp, "Center");
    JPanel ps = new JPanel();
    ps.setBackground(new Color(224, 224, 254));
    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);
    sp.getViewport().setBackground(new Color(224, 224, 254));
    table.setModel(model);
    table.setBorder(border);
    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));
    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);

      }
    }
  }
}