package Frame;
|
import java.awt.BorderLayout;
|
import java.awt.Color;
|
import java.awt.Component;
|
import java.awt.Container;
|
import java.awt.Font;
|
import java.awt.event.ActionEvent;
|
import java.awt.event.ActionListener;
|
import java.awt.event.KeyEvent;
|
import java.awt.event.KeyListener;
|
import java.util.Iterator;
|
import java.util.Timer;
|
import java.util.TimerTask;
|
import java.util.Vector;
|
import javax.swing.Box;
|
import javax.swing.ImageIcon;
|
import javax.swing.JInternalFrame;
|
import javax.swing.JProgressBar;
|
import javax.swing.JScrollPane;
|
import javax.swing.JTable;
|
import javax.swing.JTextField;
|
import javax.swing.UIManager;
|
import javax.swing.table.DefaultTableModel;
|
import javax.swing.table.TableCellRenderer;
|
import javax.swing.table.TableColumn;
|
import ColorAndFont.English;
|
import ColorAndFont.NothJPanel;
|
import ColorAndFont.UIColor;
|
import ColorAndFont.buttonTitle;
|
import DataBase.DatabaseManagement;
|
import PbuliClass.JButtonModel;
|
import PbuliClass.Leds;
|
import PbuliClass.OutButton;
|
import PbuliClass.ShowMessage;
|
import PbuliClass.Systems;
|
import PbuliClass.WarningMessage;
|
import PbuliClass.greateTables;
|
import PbuliClass.jinternalFrame;
|
import fence.kaoqing.Dell_KaoQing;
|
import fence.kaoqing.TbRealKaoQing;
|
/**ʵʱ¿¼ÇڼǼ±í*/
|
@SuppressWarnings("rawtypes")
|
public class RealKaoQingTable extends jinternalFrame {
|
/**
|
*
|
*/
|
private static final long serialVersionUID = 1L;
|
jinternalFrame jinerFrame=null;
|
JInternalFrame jinFrame=null;
|
NothJPanel northPanel=null;//±±²¿Ãæ°å
|
JTextField searchFileld=null;//ËÑË÷Îı¾¿ò
|
JTextField kaoqing_num=null;//ʵʱ¿¼ÇÚÈËÊý
|
JButtonModel search=null;//ËÑË÷°´Å¥
|
JButtonModel shuaxin=null;//ˢа´Å¥
|
JButtonModel add=null;//ÐÂÔö°´Å¥
|
JButtonModel alter=null;//Ð޸İ´Å¥
|
JButtonModel delete=null;//ɾ³ý°´Å¥
|
JButtonModel deleteAll=null;//È«²¿É¾³ý°´Å¥
|
JButtonModel enterPort=null;//µ¼ÈëÈËÔ±°´Å¥
|
JButtonModel download=null;//Ä£°åÏÂÔØ°´Å¥
|
JScrollPane gd=null;//¹ö¶¯Ãæ°å
|
JTable table=null;//ÉêÃ÷±í¸ñ
|
Vector<Vector<String>> rowData=null;
|
DefaultTableModel tableModel=null;//ÉùÃ÷±í¸ñÄ£ÐÍ
|
Container rq;
|
Box topicBox;
|
Font font=new Font("ºÚÌå", Font.BOLD, 14);
|
|
|
int selectedRow;//±»Ñ¡ÖеÄÐÐ
|
public RealKaoQingTable() {//¹¹Ôì·½·¨
|
topicBox = Box.createHorizontalBox();// ´´½¨Ò»¸öˮƽÏäÈÝÆ÷
|
rowData=new Vector<>();
|
rq=getContentPane();//»ñÈ¡ÈÝÆ÷
|
rq.setLayout(new BorderLayout());
|
rq.setBackground(Color.white);
|
String title="ʵʱ¿¼ÇÚÐÅÏ¢±í";
|
if(Systems.sys().getLanguage().equals("English")) {
|
title="Real-time Attendance Information Sheet";
|
}
|
this.setTitle(title);
|
this.setFrameIcon(new ImageIcon("image/icon/kaoqingicon.png"));//ÉèÖô°Ìåͼ±ê
|
rq.add(getNorthPanel(),BorderLayout.NORTH);
|
rq.add(getGd(),BorderLayout.CENTER);
|
ding_shi_qi();
|
|
}
|
|
|
/**»ñÈ¡±±²¿Ãæ°åµÄ·½·¨*/
|
public NothJPanel getNorthPanel() {
|
if(northPanel==null) {
|
northPanel=new NothJPanel();
|
topicBox.add(getKaoqing_num());
|
topicBox.add(Box.createHorizontalStrut(10));// Ìí¼ÓÒ»¸ö3ÏñËØ¿íµÄˮƽ֧Öù
|
topicBox.add(getSearchFileld());//Ìí¼ÓËÑË÷Îı¾¿ò
|
topicBox.add(Box.createHorizontalStrut(3));// Ìí¼ÓÒ»¸ö3ÏñËØ¿íµÄˮƽ֧Öù
|
topicBox.add(getSearch());//Ìí¼ÓËÑË÷°´Å¥
|
topicBox.add(Box.createHorizontalStrut(5));// Ìí¼ÓÒ»¸ö5ÏñËØ¿íµÄˮƽ֧Öù
|
topicBox.add(getShuaxin());//Ìí¼Óˢа´Å¥
|
topicBox.add(Box.createHorizontalStrut(5));// Ìí¼ÓÒ»¸ö5ÏñËØ¿íµÄˮƽ֧Öù
|
topicBox.add(getDelete());//Ìí¼Óɾ³ý°´Å¥
|
topicBox.add(Box.createHorizontalStrut(5));// Ìí¼ÓÒ»¸ö5ÏñËØ¿íµÄˮƽ֧Öù
|
topicBox.add(getDeleteAll());//Ìí¼Óɾ³ýÈ«²¿°´Å¥
|
northPanel.add(topicBox );
|
|
|
}
|
return northPanel;
|
}
|
|
/**»ñÈ¡ËÑË÷Îı¾¿òµÄ·½·¨*/
|
public JTextField getSearchFileld() {
|
if(searchFileld==null){
|
searchFileld=new JTextField(10);
|
searchFileld.addKeyListener(new KeyListener() { //¼üÅÌʼþ¼àÌý
|
public void keyTyped(KeyEvent e) {
|
|
}
|
public void keyReleased(KeyEvent e) {
|
int keyCode=e.getKeyCode();
|
if(keyCode==KeyEvent.VK_ENTER) {
|
getSearch().doClick();//ËÑË÷°´Å¥±»µã»÷
|
}
|
}
|
public void keyPressed(KeyEvent e) {
|
|
}
|
});
|
|
}
|
return searchFileld;
|
}
|
/**»ñÈ¡ËÑË÷°´Å¥µÄ·½·¨*/
|
public JButtonModel getSearch() {
|
if(search==null){
|
search=new JButtonModel(buttonTitle.getSerch());
|
search.addActionListener(new ActionListener() {
|
public void actionPerformed(ActionEvent e) {
|
// Ö´ÐÐSQL²éѯÓï¾ä»ñµÃµÄ½á¹û¼¯
|
try {
|
if(getSearchFileld().getText().length()>1) {
|
String go=getSearchFileld().getText();
|
updateSerch(go);
|
}
|
|
} catch (Exception er) {
|
er.printStackTrace();
|
}
|
}
|
});
|
|
}
|
return search;
|
}
|
|
/**»ñÈ¡µ¼³ö±í¸ñ°´Å¥µÄ·½·¨*/
|
public JButtonModel getDao_chu_table() {
|
OutButton.setAddtime("intime");
|
OutButton.setDataName("tb_realkaoqing");
|
return new OutButton().get_ouotport_button();
|
}
|
|
/**»ñȡˢа´Å¥µÄ·½·¨*/
|
public JButtonModel getShuaxin() {
|
if(shuaxin==null){
|
shuaxin=new JButtonModel(buttonTitle.getRefresh());
|
shuaxin.addActionListener(new ActionListener() {
|
public void actionPerformed(ActionEvent e) {
|
updateTable() ;
|
}
|
});
|
|
}
|
return shuaxin;
|
}
|
|
|
/**»ñÈ¡±í¸ñ±»Ñ¡ÖеÄÐз½·¨*/
|
public int getSelectedRow() {
|
selectedRow=getTable().getSelectedRow();
|
return selectedRow;
|
|
}
|
|
/**»ñȡɾ³ý°´Å¥µÄ·½·¨*/
|
public JButtonModel getDelete() {
|
if(delete==null){
|
delete=new JButtonModel(buttonTitle.getDelete());
|
delete.addActionListener(new ActionListener() {
|
public void actionPerformed(ActionEvent e) {
|
int[] selectedRows=table.getSelectedRows();//±»Ñ¡ÖÐÐеÄË÷Òý¼¯ºÏ
|
if(selectedRows.length !=0) {
|
for(int i=0;i<selectedRows.length;i++){
|
String tagid=(String) table.getValueAt(selectedRows[i], 3);
|
String araname=(String) table.getValueAt(selectedRows[i], 0);
|
String deleteSql="DELETE FROM tb_realkaoqing WHERE tagid='"+tagid+"'";
|
TbRealKaoQing tbkq=Dell_KaoQing.get_tbkq(araname, tagid);
|
Dell_KaoQing.delete_TbRealKaoQing(tbkq, tagid);
|
DatabaseManagement.update(deleteSql);// ɾ³ý
|
|
}
|
//ɾ³ý³É¹¦ÌáʾÐÅÏ¢
|
ShowMessage.delteSuccess(selectedRows.length);
|
updateTable();//ˢбí¸ñ
|
|
}
|
else {
|
ShowMessage.zidingyi("ÇëÑ¡ÖÐÐèҪɾ³ýµÄÐУ¡");
|
}
|
|
}
|
});
|
|
}
|
return delete;
|
}
|
/**»ñÈ¡È«²¿É¾³ý°´Å¥µÄ·½·¨*/
|
public JButtonModel getDeleteAll() {
|
if(deleteAll==null){
|
deleteAll=new JButtonModel("Çå¿Õ¿¼ÇÚ");
|
deleteAll.addActionListener(new ActionListener() {
|
public void actionPerformed(ActionEvent e) {
|
//Ñ¡Ôñ¶Ô»°¿òÈçyes·µ»Ø0£¬NO·µ»Ø1£¬È¡Ïû·µ»Ø2
|
WarningMessage warning=new WarningMessage();
|
warning.setMessage("Ñ¡Ôñɾ³ýÈ«²¿½«»á°Ñ±í¸ñÊý¾ÝÈ«²¿É¾³ýÈ·¶¨Âð£¿");
|
int warn=warning.getwarMss(getNorthPanel());
|
int tagnum=table.getRowCount();//±í¸ñ×ÜÐÐÊý
|
if(tagnum!=0 && warn==0) {
|
Dell_KaoQing.cleartallkaoqing();
|
ShowMessage.zidingyi("ɾ³ý³É¹¦");
|
rq.repaint();
|
}
|
}
|
});
|
|
}
|
return deleteAll;
|
}
|
|
/**»ñÈ¡¹ö¶¯Ãæ°åµÄ·½·¨*/
|
public JScrollPane getGd() {
|
if(gd==null){
|
gd=new JScrollPane(getTable());
|
gd.getViewport().setBackground(UIColor.getNorth_color());
|
|
}
|
return gd;
|
}
|
|
|
/**Ìí¼Ó±í¸ñÐÐÏòÁ¿Êý¾Ý·½·¨*/
|
@SuppressWarnings("unchecked")
|
public void getRowData(Vector<TbRealKaoQing> list ) {
|
Iterator<TbRealKaoQing> it = list.iterator();//´´½¨µü´úÆ÷
|
Vector row;
|
while (it.hasNext()) {//µü´úÆ÷´æÔÚÔªËØ
|
TbRealKaoQing tb=it.next();
|
row = new Vector();
|
row.add(tb.getArea());
|
row.add(tb.getName());
|
row.add(tb.getBumen());
|
row.add(tb.getTagid());
|
row.add(Integer.parseInt(tb.getPower()));
|
row.add(tb.getIntime());
|
row.add("");
|
tableModel.addRow(row);
|
}
|
|
}
|
|
|
|
/**»ñÈ¡¿¼ÇÚ±í¸ñµÄ·½·¨*/
|
public JTable getTable() {
|
if(table==null) {
|
String[] name1= {"¿¼ÇÚÇøÓò","ÐÕ Ãû","²¿ ÃÅ","±êÇ©ID","±êÇ©µçÁ¿","½øÈëʱ¼ä","±¸ ×¢"};//±í¸ñÁÐÃû
|
String[] name2= {"Attendance Area", "Name", "Department",
|
"Tag ID", "Tag Power", "Entry Time", "Remarks"};//±í¸ñÁÐÃû
|
String[] columnNames=English.columnNames(name1, name2);
|
//Ìí¼Ó±í¸ñÁÐÏòÁ¿
|
Vector<String> columnName=new Vector<>();
|
for(int i=0;i<columnNames.length;i++){
|
columnName.add(columnNames[i]);
|
}
|
|
|
|
greateTables tables=new greateTables();
|
tableModel=new DefaultTableModel(rowData, columnName){
|
/**
|
*
|
*/
|
private static final long serialVersionUID = 1L;
|
|
// ʵÏÖÈÃÕû¸ö±í¸ñ²»²»ÔÊÐí±»±à¼
|
public boolean isCellEditable(int row,int column){
|
return false;
|
}
|
};
|
|
table=tables.getTable(tableModel);
|
getRowData(Dell_KaoQing.getrealkaoqings());
|
table.getColumnModel().getColumn(5).setPreferredWidth(174);// ÉèÖÃÁпí
|
table.getColumnModel().getColumn(6).setPreferredWidth(174);// ÉèÖÃÁпí
|
TableColumn column = table.getColumnModel().getColumn(4);// »ñÈ¡±í¸ñµÚ4ÁжÔÏó
|
column.setCellRenderer(new TableCellRenderer() {// ÉèÖõÚ4ÁеÄäÖȾÆ÷
|
public Component getTableCellRendererComponent(
|
JTable table, Object value, boolean isSelected,
|
boolean hasFocus, int row, int column) {
|
if (value instanceof Integer) {
|
JProgressBar bar=new JProgressBar();//´´½¨½ø¶ÈÌõ
|
Integer percent=(Integer)value;//°Ñµ±Ç°Öµ×ªÎªÕûÊý
|
bar.setValue(percent);//ÉèÖýø¶ÈÌõµÄÖµ
|
bar.setStringPainted(true);//ÏÔʾ½ø¶ÈÌõÎı¾
|
//δ¸²¸ÇÇ°µÄ½ø¶ÈÌõÑÕÉ«
|
UIManager.put("ProgressBar.selectionBackground",Color.black);
|
//¸²¸ÇºóµÄ½ø¶ÈÌõÑÕÉ«
|
UIManager.put("ProgressBar.selectionForeground",Color.blue);
|
if(percent<15) {
|
bar.setForeground(Color.red);//ÏÔʾ½ø¶ÈÌõµÄÑÕÉ«
|
}
|
else {
|
bar.setForeground(Color.green);//ÏÔʾ½ø¶ÈÌõµÄÑÕÉ«
|
}
|
bar.setBackground(UIColor.getNorth_color());
|
|
bar.setBorderPainted(false);//ÊÇ·ñÏÔʾ½ø¶ÈÌõ±ß¿ò
|
if (row % 2 == 0) {
|
bar.setBackground(UIColor.getTable_1());
|
} else {
|
bar.setBackground(UIColor.getTable_2());
|
}
|
|
if(isSelected) {
|
bar.setBackground(UIColor.getTable_sekected());
|
}
|
|
|
|
return bar;// °Ñͼ±ê×÷ΪΪäÖȾ¿Ø¼þ
|
}
|
else {
|
return null;
|
}
|
}
|
});
|
|
}
|
return table;
|
|
}
|
|
//ʵʱ¿¼ÇÚÎı¾¿ò
|
public JTextField getKaoqing_num() {
|
if(kaoqing_num==null) {
|
kaoqing_num=new JTextField(50);
|
kaoqing_num.setBorder(null);
|
kaoqing_num.setBackground(null);
|
kaoqing_num.setEnabled(true);
|
kaoqing_num.setFont(font);
|
kaoqing_num.setForeground(UIColor.getGrenn());
|
}
|
return kaoqing_num;
|
}
|
|
/**ˢбí¸ñ·½·¨*/
|
public void updateTable() {
|
|
if(tableModel !=null) {
|
tableModel.getDataVector().clear();
|
getRowData(Dell_KaoQing.getrealkaoqings());
|
gd.validate();
|
}
|
}
|
|
/**´´½¨Ò»¸ö¶¨Ê±Æ÷ÓÃÓÚˢбí¸ñ*/
|
public void ding_shi_qi() {
|
if (Leds.get_tb_led()==null){
|
return;
|
}
|
int time=Integer.parseInt(Leds.get_tb_led().getGengxintime());
|
Integer cacheTime = 1000 *time;//´¥·¢Æ÷ʱ¼ä
|
Timer timer = new Timer();
|
// (TimerTask task, long delay, long period)ÈÎÎñ£¬ÑÓ³Ùʱ¼ä£¬¶à¾ÃÖ´ÐÐ
|
timer.schedule(new TimerTask() {
|
@Override
|
public void run() {
|
try {
|
updateTable() ;//Ë¢ÐÂʵʱ¿¼ÇÚ±í¸ñ
|
kaoqing_num.setText(Dell_KaoQing.all_kaoqing_num());
|
} catch (Exception e) {
|
// TODO ×Ô¶¯Éú³ÉµÄ catch ¿é
|
e.printStackTrace();
|
}
|
}
|
}, 1000, cacheTime);
|
|
}
|
|
|
|
/**ËÑË÷·½·¨*/
|
public void updateSerch(String serch) {
|
int tagnum=getTable().getRowCount();//±í¸ñ×ÜÐÐÊý
|
if(tagnum !=0 ) {
|
for (int i = 0; i < tagnum; i++) {//ɾ³ýËùÓÐÐÐ
|
tableModel.removeRow(0);
|
}
|
getRowData(Dell_KaoQing.serch(serch));
|
}
|
}
|
|
|
}
|
