public void showTables() { if (this.tab_PosList.getSelectedRow() == 0) { this.btn_PosDel.setEnabled(false); this.btn_PosUpdate.setEnabled(false); this.btn_StaffPosUpdata.setEnabled(true); } else { this.btn_PosDel.setEnabled(true); this.btn_PosUpdate.setEnabled(true); this.btn_StaffPosUpdata.setEnabled(true); } // String tabSelect = tab_PosList.getValueAt(this.tab_PosList.getSelectedRow(), // 0).toString(); String sql = ""; ResultSet rs_Pos = null; try { if (tab_PosList.getSelectedRow() == 0) { sql = " SELECT staff_info.s_no AS NO, " + "concat(staff_info.firstname, staff_info.lastName) AS Name, " + "staff_info.nia_no AS ID_NO, " + "staff_info.s_id AS Account " + " FROM staff_info " + " WHERE staff_info.posi_guid IS null" + " AND staff_info.exist = 1"; } else if (tab_PosList.getSelectedRow() != 0 && tab_PosList.getSelectedRow() != -1) { sql = " SELECT staff_info.s_no AS NO, " + "concat(staff_info.firstname, staff_info.lastName) AS Name, " + "staff_info.nia_no AS ID_NO, " + "staff_info.s_id AS Account " + " FROM staff_info,position " + " WHERE staff_info.posi_guid = position.guid " + " AND position.name = '" + tab_PosList.getValueAt(this.tab_PosList.getSelectedRow(), 0).toString() + "' " + " AND staff_info.exist = 1 ORDER BY s_id"; } rs_Pos = DBC.executeQuery(sql); if (rs_Pos.next()) { tab_PosDetail.setModel(HISModel.getModel(rs_Pos, null)); } else { tab_PosDetail.setModel( getModle( new String[] {"Message"}, new String[][] {{paragraph.getLanguage(line, "NOFORMATION")}})); // 將表格清空 } } catch (SQLException e) { ErrorMessage.setData( "Staff", "Frm_ Position", "showTables()", e.toString().substring(e.toString().lastIndexOf(".") + 1, e.toString().length())); System.out.println(e); } }
public void initTables() { ResultSet rs = null; try { rs = DBC.executeQuery("SELECT name FROM position"); this.tab_PosList.setModel( new TableModels(rs, new String[] {paragraph.getLanguage(line, "POSITIONNAME")})); } catch (SQLException e) { ErrorMessage.setData( "Staff", "Frm_ Position", "initTables()", e.toString().substring(e.toString().lastIndexOf(".") + 1, e.toString().length())); System.out.println(e); } tab_PosDetail.setModel( getModle( new String[] {paragraph.getLanguage(line, "MESSAGE")}, new String[][] {{paragraph.getLanguage(line, "NOINFORMATION")}})); }