?? cd.java~11~
字號:
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);
}
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -