public void actionPerformed(ActionEvent ev) { try { // stok String query = "DELETE FROM stok_produk WHERE id_produk=" + idProduk; int hasil1 = stm.executeUpdate(query); // pemasukkan query = "DELETE FROM pemasukan WHERE id_produk=" + idProduk; int hasil2 = stm.executeUpdate(query); // pengeluaran query = "DELETE FROM pengeluaran WHERE id_produk=" + idProduk; int hasil3 = stm.executeUpdate(query); // produk query = "DELETE FROM produk WHERE id_produk=" + idProduk; int hasil4 = stm.executeUpdate(query); if (hasil1 == 1 || hasil2 == 1 || hasil3 == 1 && hasil4 == 1) { setDataTabel(); JOptionPane.showMessageDialog(null, "berhasil hapus"); } else { JOptionPane.showMessageDialog(null, "gagal"); } } catch (SQLException SQLerr) { SQLerr.printStackTrace(); } catch (Exception e) { e.printStackTrace(); } }
private void btnDeleteActionPerformed( java.awt.event.ActionEvent evt) { // GEN-FIRST:event_btnDeleteActionPerformed // TODO add your handling code here: if (txtKodeAbsen.getText().equals("")) { JOptionPane.showMessageDialog( null, "Isi Kode Absen yang Akan dihapus !!!", "Peringatan", JOptionPane.ERROR_MESSAGE); txtKodeAbsen.requestFocus(); } else { try { Class.forName(KoneksiDatabase.driver); java.sql.Connection c = DriverManager.getConnection( KoneksiDatabase.database, KoneksiDatabase.user, KoneksiDatabase.pass); Statement s = c.createStatement(); String sql = "DELETE FROM absensi_lembur where kd_absen ='" + txtKodeAbsen.getText() + "'"; s.executeUpdate(sql); JOptionPane.showMessageDialog(null, "Data Berhasil Dihapus !"); Baru(); } catch (Exception e) { JOptionPane.showMessageDialog( null, "Kemungkinan terjadi kegagalan koneksi", "Warning", JOptionPane.ERROR_MESSAGE); } } } // GEN-LAST:event_btnDeleteActionPerformed
public void totalExport() { File expf = new File("export"); if (expf.exists()) rmrf(expf); expf.mkdirs(); for (int sto = 0; sto < storeLocs.size(); sto++) { try { String sl = storeLocs.get(sto).getAbsolutePath().replaceAll("/", "-").replaceAll("\\\\", "-"); File estore = new File(expf, sl); estore.mkdir(); File log = new File(estore, LIBRARY_NAME); PrintWriter pw = new PrintWriter(log); for (int i = 0; i < store.getRowCount(); i++) if (store.curStore(i) == sto) { File enc = store.locate(i); File dec = sec.prepareMainFile(enc, estore, false); pw.println(dec.getName()); pw.println(store.getValueAt(i, Storage.COL_DATE)); pw.println(store.getValueAt(i, Storage.COL_TAGS)); synchronized (jobs) { jobs.addLast(expJob(enc, dec)); } } pw.close(); } catch (IOException exc) { exc.printStackTrace(); JOptionPane.showMessageDialog(frm, "Exporting Failed"); return; } } JOptionPane.showMessageDialog(frm, "Exporting to:\n " + expf.getAbsolutePath()); }
private void Simpan() { if (btnSave.getText().equals("Edit")) { try { Class.forName(KoneksiDatabase.driver); java.sql.Connection c = DriverManager.getConnection( KoneksiDatabase.database, KoneksiDatabase.user, KoneksiDatabase.pass); Statement s = c.createStatement(); String sql; sql = "update absensi_lembur set tipehari = '"; sql += cmbJenisHari.getSelectedItem() + "', tot_waktu_lembur='"; sql += txtTotalLembur.getText() + "'"; sql += "where kd_absen = '" + txtKodeAbsen.getText() + "'"; s.executeQuery(sql); JOptionPane.showMessageDialog( null, "Data Berhasil Disimpan!!!", "Informasi", JOptionPane.INFORMATION_MESSAGE); } catch (Exception e) { JOptionPane.showMessageDialog( null, "Gagal Disimpan, Data Harus Lengkap !!!", "Peringatan", JOptionPane.WARNING_MESSAGE); } } Baru(); }
@Override public void actionPerformed(ActionEvent e) { ID = (Integer) hashRoomType.get(boxRoomTypeID.getSelectedItem().toString()); IDSTATUS = (Integer) hashRoomStatus.get(boxRoomStatusID.getSelectedItem().toString()); if (e.getSource() == buttonInsert) { try { Rooms rooms = new Rooms(txtRoomNumber.getText(), txtDescription.getText(), ID, IDSTATUS); RoomsController.roomsController.save(rooms); int c = model.getRowCount(); for (int i = c - 1; i >= 0; i--) { model.removeRow(i); jRoom.revalidate(); } all(); JOptionPane.showMessageDialog(this, "ok"); } catch (Exception ex) { ex.printStackTrace(); } } if (e.getSource() == buttonUpdate) { try { Rooms rooms = new Rooms(txtRoomNumber.getText(), txtDescription.getText(), ID, IDSTATUS); rooms.setRoomID(IDROOM); RoomsController.roomsController.update(rooms); int c = model.getRowCount(); for (int i = c - 1; i >= 0; i--) { model.removeRow(i); jRoom.revalidate(); } all(); JOptionPane.showMessageDialog(this, "Update to succeed !"); } catch (Exception ex) { ex.printStackTrace(); } } if (e.getSource() == buttonDelete) { try { List<CheckIn> temp = CheckInController.checkInController.all(); for (int i = 0; i < temp.size(); i++) { if (IDROOM == temp.get(i).getRoomID()) { this.error = 0; } else { this.error = 0; RoomsController.roomsController.delete(IDROOM); int c = model.getRowCount(); for (int ii = c - 1; ii >= 0; ii--) { model.removeRow(ii); jRoom.revalidate(); } all(); } } JOptionPane.showMessageDialog(this, "Delete to succeed !"); } catch (Exception ex) { JOptionPane.showMessageDialog(this, "can't delete row bcause check still !"); } } if (e.getSource() == buttonRefresh) {} }
private void prosesEdit(String query) { try { int hasil = stm.executeUpdate(query); if (hasil == 1) { setDataTabel(); JOptionPane.showMessageDialog(null, "edit berhasil"); } else { JOptionPane.showMessageDialog(null, "gagal"); } } catch (SQLException SQLerr) { SQLerr.printStackTrace(); } }
@Override public void actionPerformed(ActionEvent e) { // Object o = table.getModel().getValueAt(table.getSelectedRow(), 0); int row = table.convertRowIndexToModel(table.getEditingRow()); Object o = table.getModel().getValueAt(row, 0); JOptionPane.showMessageDialog(table, "Editing: " + o); }
public int submit() { String newName = produktgruppeFormular.nameField.getText(); if (isProdGrAlreadyKnown(newName)) { // not allowed: changing name to one that is already registered in DB JOptionPane.showMessageDialog( this, "Fehler: Produktgruppe '" + newName + "' bereits vorhanden!", "Info", JOptionPane.INFORMATION_MESSAGE); produktgruppeFormular.nameField.setText(""); return 0; } Integer parentProdGrID = produktgruppeFormular.parentProdGrIDs.get( produktgruppeFormular.parentProdGrBox.getSelectedIndex()); Vector<Integer> idsNew = produktgruppeFormular.idsOfNewProdGr(parentProdGrID); Integer topID = idsNew.get(0); Integer subID = idsNew.get(1); Integer subsubID = idsNew.get(2); Integer mwstID = produktgruppeFormular.mwstIDs.get(produktgruppeFormular.mwstBox.getSelectedIndex()); Integer pfandID = produktgruppeFormular.pfandIDs.get(produktgruppeFormular.pfandBox.getSelectedIndex()); return insertNewProdGr(topID, subID, subsubID, newName, mwstID, pfandID); }
public void secureDelete() { int rw = tblItems.getSelectedRow(); if (rw == -1) { JOptionPane.showMessageDialog(frm, "No item selected", "Error", JOptionPane.ERROR_MESSAGE); return; } int idx = tblItems.convertRowIndexToModel(rw); if (JOptionPane.showConfirmDialog( frm, "Delete " + store.plainName(idx) + "?", "Confirm Delete", JOptionPane.YES_NO_OPTION) != JOptionPane.YES_OPTION) return; File del = store.delete(idx); store.fireTableDataChanged(); if (del != null) { if (del.delete()) { // successful needsSave = true; } else { System.err.println("Delete " + del.getAbsolutePath() + " failed"); } } updateStatus(); }
/** * Make the selected line of the table to the given line, if it is displayed. Otherwise a warning * message is displayed. */ private void gotoLine() { if (gotoTextField.getText().equals("")) { return; } int index = Integer.parseInt(gotoTextField.getText()); ConstantPoolTableModel model = (ConstantPoolTableModel) table.getModel(); if (model.isEmpty()) { gotoTextField.setText(""); return; } if (index < 0 || (model.getFullRowCount() - 1) < index) { JOptionPane.showMessageDialog( this, gotoTextField.getText() + " is not in the allowed range [0.." + (model.getFullRowCount() - 1) + "] !", "Warning:", JOptionPane.ERROR_MESSAGE); gotoTextField.setText(""); return; } int indexes[] = model.getIndexes(); boolean found = false; for (int i = 0; i < indexes.length; ++i) { if (found = (indexes[i] == index)) { table.changeSelection(i, 0, false, false); break; } } if (!found) { JOptionPane.showMessageDialog( this, "Index " + gotoTextField.getText() + " is not present in the filtered pool!", "Warning:", JOptionPane.ERROR_MESSAGE); gotoTextField.setText(""); return; } gotoTextField.setText(""); } // gotoLine
private void Baru() { btnSave.setText("Save"); txtNip.requestFocus(); txtNip.setText(""); try { Class.forName(KoneksiDatabase.driver); java.sql.Connection c = DriverManager.getConnection( KoneksiDatabase.database, KoneksiDatabase.user, KoneksiDatabase.pass); Statement s = c.createStatement(); String sql = "select * from absensi_lembur"; ResultSet rs = s.executeQuery(sql); final String[] headers = { "Kd Absen", "NIP", "Tgl Absen", "Masuk", "Pulang", "Hari", "Tipe Hari", "Terlambat", "Lembur", "Tipe Lembur", "Tot Lembur", "Tunj Makan", "Tunj Transport" }; rs.last(); int n = rs.getRow(); Object[][] data = new Object[n][13]; int p = 0; rs.beforeFirst(); while (rs.next()) { data[p][0] = rs.getString(1); data[p][1] = rs.getString(2); data[p][2] = rs.getString(3); data[p][3] = rs.getString(4); data[p][4] = rs.getString(5); data[p][5] = rs.getString(6); data[p][6] = rs.getString(7); data[p][7] = rs.getString(8); data[p][8] = rs.getString(9); data[p][9] = rs.getString(10); data[p][10] = rs.getString(11); data[p][11] = rs.getString(12); data[p][12] = rs.getString(13); p++; } tblLembur.setModel(new DefaultTableModel(data, headers)); tblLembur.setAlignmentX(CENTER_ALIGNMENT); } catch (Exception e) { JOptionPane.showMessageDialog( null, "Gagal Koneksi, Ada Kesalahan.", "Warning", JOptionPane.WARNING_MESSAGE); } }
void find() { String query = ""; try { query = m_table.getCriterion(); } catch (Exception ex) { JOptionPane.showMessageDialog(this, ex.getMessage()); return; } try { HRMBusinessLogic logic = new HRMBusinessLogic(m_conn); m_panel.reset( logic.getEmployeeByCriteria(m_sessionid, IDBConstants.MODUL_MASTER_DATA, query)); if (m_panel.m_panel_rptEmployeProfile != null) m_panel.m_panel_rptEmployeProfile.m_employee = null; else if (m_panel.m_panel_rptPaycheq != null) m_panel.m_panel_rptPaycheq.m_employee = null; } catch (Exception ex) { JOptionPane.showMessageDialog(this, ex.getMessage(), "Warning", JOptionPane.WARNING_MESSAGE); } }
/** Runs this thread. */ public void run() { CommonFileChooser file_chooser = new CommonFileChooser(); file_chooser.setDialogTitle("Save selected data."); file_chooser.setMultiSelectionEnabled(false); if (file_chooser.showSaveDialog(pane) == JFileChooser.APPROVE_OPTION) { try { File file = file_chooser.getSelectedFile(); if (file.exists()) { String message = "Overwrite to " + file.getPath() + " ?"; if (0 != JOptionPane.showConfirmDialog( pane, message, "Confirmation", JOptionPane.YES_NO_OPTION)) { return; } } AstrometricaWriter writer = new AstrometricaWriter(file); writer.open(); int check_column = getCheckColumn(); for (int i = 0; i < model.getRowCount(); i++) { if (((Boolean) getValueAt(i, check_column)).booleanValue()) { Variability record = (Variability) record_list.elementAt(index.get(i)); writer.write(record.getStar()); } } writer.close(); String message = "Completed."; JOptionPane.showMessageDialog(pane, message); } catch (IOException exception) { String message = "Failed to save file."; JOptionPane.showMessageDialog(pane, message, "Error", JOptionPane.ERROR_MESSAGE); } catch (UnsupportedStarClassException exception) { String message = "Failed to save file."; JOptionPane.showMessageDialog(pane, message, "Error", JOptionPane.ERROR_MESSAGE); } } }
public void actionPerformed(ActionEvent clickEvent) { RecorderDialog recorderInfo = new RecorderDialog(parent); recorderInfo.show(); JOptionPane.showMessageDialog(null, "Clock Reset\nrecordingRTP session..."); stopRTPrecording.setEnabled(true); startRTPrecording.setEnabled(false); }
/** Runs this thread. */ public void run() { CommonFileChooser file_chooser = new CommonFileChooser(); file_chooser.setDialogTitle("Save package file."); file_chooser.setMultiSelectionEnabled(false); file_chooser.addChoosableFileFilter(new XmlFilter()); file_chooser.setSelectedFile(new File("package.xml")); if (file_chooser.showSaveDialog(pane) == JFileChooser.APPROVE_OPTION) { try { File file = file_chooser.getSelectedFile(); if (file.exists()) { String message = "Overwrite to " + file.getPath() + " ?"; if (0 != JOptionPane.showConfirmDialog( pane, message, "Confirmation", JOptionPane.YES_NO_OPTION)) { return; } } // Outputs the variability XML file. XmlVariabilityHolder holder = new XmlVariabilityHolder(); Variability[] records = getSelectedRecords(); for (int i = 0; i < records.length; i++) { XmlVariability variability = new XmlVariability(records[i]); holder.addVariability(variability); } holder.write(file); String message = "Completed."; JOptionPane.showMessageDialog(pane, message); } catch (IOException exception) { String message = "Failed."; JOptionPane.showMessageDialog(pane, message, "Error", JOptionPane.ERROR_MESSAGE); } } }
public void secureMove() { int rw = tblItems.getSelectedRow(); if (rw == -1) { JOptionPane.showMessageDialog(frm, "No item selected", "Error", JOptionPane.ERROR_MESSAGE); return; } int idx = tblItems.convertRowIndexToModel(rw); String[] opts = new String[storeLocs.size()]; for (int i = 0; i < opts.length; i++) opts[i] = storeLocs.get(i).getAbsolutePath(); JComboBox cmbMove = new JComboBox(opts); cmbMove.setSelectedIndex(store.curStore(idx)); if (JOptionPane.showConfirmDialog(frm, cmbMove, "Move item", JOptionPane.OK_CANCEL_OPTION) != JOptionPane.OK_OPTION) return; File newLoc = store.move(idx, cmbMove.getSelectedIndex()); if (newLoc == null) System.err.println("move " + store.plainName(idx) + " unsuccessful"); else needsSave = true; }
void okButton_actionPerformed(ActionEvent e) { int num_rows = filtersTable.getRowCount(); EditableDefinablePlugin edp = m_data.getPlugin(); for (int row = 0; row < num_rows; row++) { String mimeType = (String) filtersTable.getValueAt(row, 0); String mimeTypeValue = (String) filtersTable.getValueAt(row, 1); try { mimeTypeEditorBuilder.checkValue(edp, mimeType, mimeTypeValue); } catch (DynamicallyLoadedComponentException dlce) { String logMessage = "Failed to set the " + mimeTypeEditorBuilder.getValueName() + " for MIME type " + mimeType + " to " + mimeTypeValue; logger.error(logMessage, dlce); if (!EDPInspectorTableModel.handleDynamicallyLoadedComponentException(this, dlce)) { return; } else { logger.debug("User override; allow " + mimeTypeValue); } } } mimeTypeEditorBuilder.clear(edp); for (int row = 0; row < num_rows; row++) { String mimeType = (String) filtersTable.getValueAt(row, 0); String mimeTypeValue = (String) filtersTable.getValueAt(row, 1); try { mimeTypeEditorBuilder.put(edp, mimeType, mimeTypeValue); } catch (DynamicallyLoadedComponentException dlce) { String logMessage = "Internal error; MIME type " + mimeType + " not set to " + mimeTypeValue; logger.error(logMessage, dlce); } catch (PluginException.InvalidDefinition ex) { JOptionPane.showMessageDialog( this, ex.getMessage(), WordUtils.capitalize(mimeTypeEditorBuilder.getValueName()) + " Warning", JOptionPane.WARNING_MESSAGE); } } setVisible(false); }
/** * * Each non abstract class that implements the ActionListener must have this method. * * @param e the action event. */ public void actionPerformed(ActionEvent e) { if (e.getSource() == submitButton) { int result = submit(); if (result == 0) { JOptionPane.showMessageDialog( this, "Fehler: Produktgruppe " + produktgruppeFormular.nameField.getText() + " konnte nicht eingefügt werden.", "Fehler", JOptionPane.ERROR_MESSAGE); } else { produktgruppenListe.updateAll(); closeButton.doClick(); } return; } super.actionPerformed(e); }
public MimeTypeEditor( MimeTypeEditorBuilder mimeTypeEditorBuilder, Frame frame, String title, boolean modal) { super(frame, title, modal); this.mimeTypeEditorBuilder = mimeTypeEditorBuilder; this.m_model = new MimeTypeTableModel(); try { jbInit(); pack(); } catch (Exception exc) { String logMessage = "Could not set up the " + mimeTypeEditorBuilder.getValueName() + " editor"; logger.critical(logMessage, exc); JOptionPane.showMessageDialog( frame, logMessage, WordUtils.capitalize(mimeTypeEditorBuilder.getValueName()) + " Editor", JOptionPane.ERROR_MESSAGE); } }
public TableDeneme() { super("Dictionary Window"); qtm = new QueryTableModel(); table = new JTable(qtm); scrollpane = new JScrollPane(table); p1 = new JPanel(); jb = new JButton("get em all"); p1.add(jb); getContentPane().add(p1, BorderLayout.NORTH); getContentPane().add(scrollpane, BorderLayout.CENTER); addWindowListener(new BasicWindowMonitor()); setSize(500, 500); setVisible(true); JOptionPane.showMessageDialog( new Frame(), "Press the button,\n" + "It will fill the table with all records.\n" + "Then you can edit the cells.\n" + "When you select another cell, the previous one will updated.\n\n" + "*****@*****.**"); /** * ****show selection***** table.setSelectionMode(ListSelectionModel.SINGLE_SELECTION); rowSM = * table.getSelectionModel(); rowSM.addListSelectionListener(new ListSelectionListener(){ public * void valueChanged(ListSelectionEvent e){ if (e.getValueIsAdjusting()) return; * ListSelectionModel lsm = (ListSelectionModel)e.getSource(); if (lsm.isSelectionEmpty()){ * System.out.println("No rows are selected."); } else{ * System.out.println(table.getValueAt(table.getSelectionModel().getMinSelectionIndex(),0)); * System.out.println(table.getValueAt(table.getSelectionModel().getMinSelectionIndex(),1)); } } * }); ******************** */ jb.addActionListener( new ActionListener() { public void actionPerformed(ActionEvent e) { qtm.setHostURL( "jdbc:odbc:;DRIVER=Microsoft Access Driver (*.mdb);UID=admin;UserCommitSync=Yes;Threads=3;SafeTransactions=0;PageTimeout=5;MaxScanRows=8;MaxBufferSize=2048;FIL=MS Access;DriverId=281;DBQ=db1.mdb"); qtm.setQuery("select * from soz"); } }); }
/** Finds the previous occurance of the given string in the 3rd column of the table. */ private void findPrev() { String infix = findTextField.getText(); if (infix.equals("")) { return; } if (!matchCase) { infix = infix.toLowerCase(); } String desc[] = ((ConstantPoolTableModel) table.getModel()).getDescriptions(); if (null == desc) { return; } if (table.getSelectedRowCount() != 0) { actIndex = table.getSelectedRow(); } int rows = ((ConstantPoolTableModel) table.getModel()).getRowCount(); boolean found = false, end = false; int start = actIndex; while (!end && !found) { if (0 < actIndex) { actIndex--; } else { actIndex = (rows - 1); } found = desc[actIndex].toLowerCase().contains(infix); end = (start == actIndex) && !found; } if (found) { table.changeSelection(actIndex, 0, false, false); } else if (end) { Toolkit.getDefaultToolkit().beep(); JOptionPane.showMessageDialog( this, "String " + infix + " was not found.", "Alert:", JOptionPane.ERROR_MESSAGE); } } // findPrev
public void genSeed(ActionEvent e) { long seed = 0; boolean redo = false; do { redo = false; String seedString = JOptionPane.showInputDialog( this, "Enter a number:", Long.toString(rand.nextLong(), 36) // "Random Seed", JOptionPane.QUESTION_MESSAGE ); if (seedString == null) return; try { seed = Long.parseLong(seedString, 36); } catch (NumberFormatException ex) { JOptionPane.showMessageDialog(this, "Use only letters and numbers, max 12 characters."); redo = true; } } while (redo); genSeed(seed); }
@SuppressWarnings("unused") @Override public void mouseClicked(MouseEvent e) { int iDongDaChon = jRoom.getSelectedRow(); if (iDongDaChon == -1) { JOptionPane.showMessageDialog(this, "you select 1 row"); } else { buttonDelete.setVisible(true); buttonUpdate.setEnabled(true); Vector vDongDaChon = (Vector) tableRecords.get(iDongDaChon); IDROOM = Integer.parseInt(vDongDaChon.get(0).toString()); String roomNumber = vDongDaChon.get(1).toString(); String roomType = vDongDaChon.get(2).toString(); String numBeds = vDongDaChon.get(3).toString(); String roomTypeRate = vDongDaChon.get(4).toString(); String roomStatus = vDongDaChon.get(5).toString(); String des = vDongDaChon.get(6).toString(); txtRoomNumber.setText(roomNumber); boxRoomTypeID.setSelectedItem(roomType.toString()); boxRoomStatusID.setSelectedItem(roomStatus.toString()); txtDescription.setText(des); try { List<CheckIn> temp = CheckInController.checkInController.all(); for (int i = 0; i < temp.size(); i++) { if (IDROOM == temp.get(i).getRoomID()) { this.error = 0; buttonUpdate.setEnabled(false); buttonDelete.setEnabled(false); break; } else { this.error = 0; buttonUpdate.setEnabled(true); buttonDelete.setEnabled(true); } } } catch (Exception e2) { e2.printStackTrace(); } } }
public void actionPerformed(ActionEvent e) { JButton b = (JButton) e.getSource(); if (b == bu) { j14 = new JLabel("NEW IMAGE"); j14.setBounds(840, 200, 300, 300); q.add(j14); JFileChooser filechooser = new JFileChooser(); int result = filechooser.showOpenDialog(this); f = filechooser.getSelectedFile(); try { String dir1 = f.getAbsolutePath(); // setText(dir); str = dir1; // ResizeImage.resize(dir); f = new File(dir1); } catch (Exception e1) { } repaint(); // b=(JButton)e.getSource(); } if (b == ba) { try { read(); patient.add(tadd.getText(), tsym.getText(), f, str); JOptionPane.showMessageDialog(null, "Patient ID: " + patient.pid + " Record Added"); } catch (Exception e4) { System.out.println("" + e4); } } if (b == bm) { try { setVisible(false); } catch (Exception e4) { System.out.println("" + e4); } } }
@Override public void mouseClicked(MouseEvent e) { // TODO Auto-generated method stub if (e.getSource() == table) { if (e.getClickCount() == 2) { int row = table.getSelectedRow(); String sabun = model.getValueAt(row, 0).toString(); EmpDAO dao = new EmpDAO(); EmpDTO d = dao.empDetailData(Integer.parseInt(sabun)); String msg = "사번:" + d.getEmpno() + "\n" + "이름:" + d.getEname() + "\n" + "직위:" + d.getJob() + "\n" + "사수번호:" + d.getMgr() + "\n" + "입사일:" + d.getHiredate().toString() + "\n" + "급여:" + d.getSal() + "\n" + "성과급:" + d.getComm() + "\n" + "부서번호:" + d.getDeptno(); JOptionPane.showMessageDialog(this, msg); } } }
public void tableChanged(TableModelEvent tme) { int baris = tme.getFirstRow(); int kolom = tme.getColumn(); TableModel model = (TableModel) tme.getSource(); int id = (Integer) model.getValueAt(baris, 0); String query = ""; switch (kolom) { case 1: String nama = (String) model.getValueAt(baris, kolom); query = "UPDATE produk SET nama_produk='" + nama + "' WHERE id_produk=" + id; prosesEdit(query); break; case 2: String jenis = (String) model.getValueAt(baris, kolom); try { query = "select * from jenis where nama_jenis='" + jenis + "'"; ResultSet rs = stm.executeQuery(query); if (rs.next()) { int idJenis = rs.getInt("id_jenis"); query = "UPDATE produk SET id_jenis=" + idJenis + " WHERE id_produk=" + id; prosesEdit(query); } else { setDataTabel(); JOptionPane.showMessageDialog(null, "gagal,jenis tidak ada"); } } catch (SQLException SQLerr) { SQLerr.printStackTrace(); } break; case 3: int stok = (Integer) model.getValueAt(baris, kolom); query = "UPDATE `stok_produk` SET stok=" + stok + " WHERE id_produk=" + id; prosesEdit(query); break; case 4: int harga = (Integer) model.getValueAt(baris, kolom); query = "UPDATE produk SET harga=" + harga + " WHERE id_produk=" + id; prosesEdit(query); break; case 5: String suplier = (String) model.getValueAt(baris, kolom); try { query = "SELECT * FROM suplier WHERE nama_suplier='" + suplier + "'"; ResultSet rs = stm.executeQuery(query); if (rs.next()) { int idSuplier = rs.getInt("id_suplier"); query = "UPDATE produk SET id_suplier=" + idSuplier + " WHERE id_produk=" + id; prosesEdit(query); } else { setDataTabel(); JOptionPane.showMessageDialog(null, "gagal,suplier belum terdaftar"); } } catch (SQLException SQLerr) { SQLerr.printStackTrace(); } break; default: break; } }
// Method: private void populateData() { textpadSeq_ = new RCT.TextpadMsgHistSeqHolder(); data_ = new Object[0][0]; if (ARCH_SEL_TODAY == selectionType_) { // Get today's date Date now = new Date(); Calendar cal = Calendar.getInstance(); cal.setTime(now); int day = cal.get(Calendar.DAY_OF_MONTH); int month = cal.get(Calendar.MONTH) + 1; int year = cal.get(Calendar.YEAR); String fromDate = year + "-" + month + "-" + day + " 00:00:00"; String toDate = year + "-" + month + "-" + day + " 23:59:59"; try { TeamModule.getTextpadArchiveTimeRange(className_, teamName_, fromDate, toDate, textpadSeq_); } catch (RCT.TeamServerPackage.DataSelectionExceedsLimit dsel) { JOptionPane.showMessageDialog( SessionModule.getFrame(), LangModule.i18n.getString("ExceptionDialog3"), LangModule.i18n.getString("ExceptionDialog1"), JOptionPane.WARNING_MESSAGE); return; } } else if (ARCH_SEL_TIMERANGE == selectionType_) { try { TeamModule.getTextpadArchiveTimeRange( className_, teamName_, fromDate_, toDate_, textpadSeq_); } catch (RCT.TeamServerPackage.DataSelectionExceedsLimit dsel) { JOptionPane.showMessageDialog( SessionModule.getFrame(), LangModule.i18n.getString("ExceptionDialog3"), LangModule.i18n.getString("ExceptionDialog1"), JOptionPane.WARNING_MESSAGE); return; } } // Check if we received any textpads if (0 < textpadSeq_.value.length) { data_ = new Object[textpadSeq_.value.length][TEXTPAD_N_FIELDS]; for (int i = 0; i < textpadSeq_.value.length; i++) { data_[i][TEXTPAD_ID] = textpadSeq_.value[i].id; data_[i][TEXTPAD_NAME] = textpadSeq_.value[i].name; data_[i][TEXTPAD_DATE] = Utility.getDateAndTime(textpadSeq_.value[i].date); } } }
public void setContent(String cat) { cat = cat.trim(); selectAllCB.setVisible(false); selectAllCB.setSelected(false); deleteBut.setVisible(false); restoreBut.setVisible(false); refreshBut.setVisible(true); Object columns[] = null; int count = 0; switch (cat) { case "Inbox": columns = new Object[] {"", "From", "Date", "Subject", "Content"}; count = Database.getCount("Inbox"); workingSet = db.getData("SELECT * FROM messages WHERE tag='inbox' ORDER BY msg_id desc"); ; break; case "SentMail": columns = new Object[] {"", "To", "Date", "Subject", "Content"}; count = Database.getCount("Sentmail"); workingSet = db.getData("SELECT * FROM messages WHERE tag='sentmail' ORDER BY msg_id desc"); break; case "Draft": columns = new Object[] {"", "To", "Date", "Subject", "Content"}; count = Database.getCount("Draft"); workingSet = db.getData("SELECT * FROM messages WHERE tag='draft' ORDER BY msg_id desc"); break; case "Outbox": columns = new Object[] {"", "To", "Date", "Subject", "Content"}; count = Database.getCount("Outbox"); workingSet = db.getData("SELECT * FROM messages WHERE tag='outbox' ORDER BY msg_id desc"); break; case "Trash": // restoreBut.setVisible(true); columns = new Object[] {"", "To/From", "Date", "Subject", "Content"}; count = Database.getCount("Trash"); workingSet = db.getData( "SELECT * FROM messages,trash WHERE messages.tag='trash' and messages.msg_id=trash.msg_id ORDER BY deleted_at desc"); break; default: System.out.println("in default case"); } if (count > 0) { selectAllCB.setVisible(true); rows = new Object[count][]; msgID = new int[count]; try { workingSet.beforeFirst(); for (int i = 0; i < count && workingSet.next(); i++) { msgID[i] = workingSet.getInt(1); rows[i] = new Object[] { false, workingSet.getString(2), workingSet.getDate(3), workingSet.getString(4), workingSet.getString(5) }; } } catch (SQLException sqlExc) { JOptionPane.showMessageDialog(null, sqlExc, "EXCEPTION", JOptionPane.ERROR_MESSAGE); sqlExc.printStackTrace(); } tableModel = new MyDefaultTableModel(rows, columns); table = new JTable(tableModel); table.getSelectionModel().addListSelectionListener(this); table.addMouseListener(this); table.getTableHeader().setOpaque(true); table.getTableHeader().setReorderingAllowed(false); // table.getTableHeader().setBackground(Color.blue); table.getTableHeader().setForeground(Color.blue); // table.setRowSelectionAllowed(false); // table.setColumnSelectionAllowed(false); table.setFont(new Font(Font.SANS_SERIF, Font.PLAIN, 14)); table.setRowHeight(20); table.setFillsViewportHeight(true); TableColumn column = null; for (int i = 0; i < 5; i++) { column = table.getColumnModel().getColumn(i); if (i == 0) { column.setPreferredWidth(6); } else if (i == 3) { column.setPreferredWidth(250); } else if (i == 4) { column.setPreferredWidth(450); } else { column.setPreferredWidth(40); } } table.setAutoResizeMode(JTable.AUTO_RESIZE_SUBSEQUENT_COLUMNS); remove(contentPan); contentPan = new JScrollPane(table); contentPan.setBackground(Color.orange); contentPan.setOpaque(true); contentPan.setBorder(BorderFactory.createEmptyBorder(0, 0, 0, 0)); add(contentPan, "Center"); Home.home.homeFrame.setVisible(true); } else { JPanel centPan = new JPanel(new GridBagLayout()); centPan.setBackground(new Color(52, 86, 70)); JLabel label = new JLabel("No Messages In This Category"); label.setFont(new Font(Font.SANS_SERIF, Font.BOLD, 22)); label.setForeground(Color.orange); centPan.add(label); remove(contentPan); contentPan = new JScrollPane(centPan); contentPan.setBorder(BorderFactory.createEmptyBorder(0, 0, 0, 0)); add(contentPan, "Center"); contentPan.repaint(); } }
public Ssys3() { store = new Storage(); tableSorter = new TableRowSorter<Storage>(store); jobs = new LinkedList<String>(); makeGUI(); frm.setSize(800, 600); frm.addWindowListener( new WindowListener() { public void windowActivated(WindowEvent evt) {} public void windowClosed(WindowEvent evt) { try { System.out.println("joining EDT's"); for (EDT edt : encryptDecryptThreads) { edt.weakStop(); try { edt.join(); System.out.println(" - joined"); } catch (InterruptedException e) { System.out.println(" - Not joined"); } } System.out.println("saving storage"); store.saveAll(tempLoc); } catch (IOException e) { e.printStackTrace(); System.err.println( "!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!\n\nFailed to save properly\n\n!!!!!!!!!!!!!!!!!!!!!!!!!"); System.exit(1); } clean(); System.exit(0); } public void windowClosing(WindowEvent evt) { windowClosed(evt); } public void windowDeactivated(WindowEvent evt) {} public void windowDeiconified(WindowEvent evt) {} public void windowIconified(WindowEvent evt) {} public void windowOpened(WindowEvent evt) {} }); ImageIcon ico = new ImageIcon(ICON_NAME); frm.setIconImage(ico.getImage()); frm.setLocationRelativeTo(null); frm.setVisible(true); // load config storeLocs = new ArrayList<File>(); String ossl = "openssl"; int numThreadTemp = 2; boolean priorityDecryptTemp = true; boolean allowExportTemp = false; boolean checkImportTemp = true; try { Scanner sca = new Scanner(CONF_FILE); while (sca.hasNextLine()) { String ln = sca.nextLine(); if (ln.startsWith(CONF_SSL)) { ossl = ln.substring(CONF_SSL.length()); } else if (ln.startsWith(CONF_THREAD)) { try { numThreadTemp = Integer.parseInt(ln.substring(CONF_THREAD.length())); } catch (Exception exc) { // do Nothing } } else if (ln.equals(CONF_STORE)) { while (sca.hasNextLine()) storeLocs.add(new File(sca.nextLine())); } else if (ln.startsWith(CONF_PRIORITY)) { try { priorityDecryptTemp = Boolean.parseBoolean(ln.substring(CONF_PRIORITY.length())); } catch (Exception exc) { // do Nothing } } else if (ln.startsWith(CONF_EXPORT)) { try { allowExportTemp = Boolean.parseBoolean(ln.substring(CONF_EXPORT.length())); } catch (Exception exc) { // do Nothing } } else if (ln.startsWith(CONF_CONFIRM)) { try { checkImportTemp = Boolean.parseBoolean(ln.substring(CONF_CONFIRM.length())); } catch (Exception exc) { // do Nothing } } } sca.close(); } catch (IOException e) { } String osslWorks = OpenSSLCommander.test(ossl); while (osslWorks == null) { ossl = JOptionPane.showInputDialog( frm, "Please input the command used to run open ssl\n We will run \"<command> version\" to confirm\n Previous command: " + ossl, "Find open ssl", JOptionPane.OK_CANCEL_OPTION); if (ossl == null) { System.err.println("Refused to provide openssl executable location"); System.exit(1); } osslWorks = OpenSSLCommander.test(ossl); if (osslWorks == null) JOptionPane.showMessageDialog( frm, "Command " + ossl + " unsuccessful", "Unsuccessful", JOptionPane.ERROR_MESSAGE); } if (storeLocs.size() < 1) JOptionPane.showMessageDialog( frm, "Please select an initial sotrage location\nIf one already exists, or there are more than one, please select it"); while (storeLocs.size() < 1) { JFileChooser jfc = new JFileChooser(); jfc.setFileSelectionMode(JFileChooser.DIRECTORIES_ONLY); if (jfc.showOpenDialog(frm) != JFileChooser.APPROVE_OPTION) { System.err.println("Refused to provide an initial store folder"); System.exit(1); } File sel = jfc.getSelectedFile(); if (sel.isDirectory()) storeLocs.add(sel); } numThreads = numThreadTemp; priorityExport = priorityDecryptTemp; allowExport = allowExportTemp; checkImports = checkImportTemp; try { PrintWriter pw = new PrintWriter(CONF_FILE); pw.println(CONF_SSL + ossl); pw.println(CONF_THREAD + numThreads); pw.println(CONF_PRIORITY + priorityExport); pw.println(CONF_EXPORT + allowExport); pw.println(CONF_CONFIRM + checkImports); pw.println(CONF_STORE); for (File fi : storeLocs) { pw.println(fi.getAbsolutePath()); } pw.close(); } catch (IOException e) { System.err.println("Failed to save config"); } File chk = null; for (File fi : storeLocs) { File lib = new File(fi, LIBRARY_NAME); if (lib.exists()) { chk = lib; // break; } } char[] pass = null; if (chk == null) { JOptionPane.showMessageDialog( frm, "First time run\n Create your password", "Create Password", JOptionPane.INFORMATION_MESSAGE); char[] p1 = askPassword(); char[] p2 = askPassword(); boolean same = p1.length == p2.length; for (int i = 0; i < Math.min(p1.length, p2.length); i++) { if (p1[i] != p2[i]) same = false; } if (same) { JOptionPane.showMessageDialog( frm, "Password created", "Create Password", JOptionPane.INFORMATION_MESSAGE); pass = p1; } else { JOptionPane.showMessageDialog( frm, "Passwords dont match", "Create Password", JOptionPane.ERROR_MESSAGE); System.exit(1); } } else { pass = askPassword(); } sec = OpenSSLCommander.getCommander(chk, pass, ossl); if (sec == null) { System.err.println("Wrong Password"); System.exit(1); } store.useSecurity(sec); store.useStorage(storeLocs); tempLoc = new File("temp"); if (!tempLoc.exists()) tempLoc.mkdirs(); // load stores try { store.loadAll(tempLoc); store.fireTableDataChanged(); } catch (IOException e) { System.err.println("Storage loading failure"); System.exit(1); } needsSave = false; encryptDecryptThreads = new EDT[numThreads]; for (int i = 0; i < encryptDecryptThreads.length; i++) { encryptDecryptThreads[i] = new EDT(i); encryptDecryptThreads[i].start(); } updateStatus(); txaSearch.grabFocus(); }
public void read() { try { // patient.dt=""+tdt.getText(); patient.pid = Integer.parseInt(tpid.getText()); patient.pfnm = tpfnm.getText(); patient.pmnm = tpmnm.getText(); patient.plnm = tplnm.getText(); patient.gen = cbg.getSelectedCheckbox().getLabel(); try { patient.age = Integer.parseInt(tage.getText()); tage.setText("" + patient.age); } catch (Exception e) { JOptionPane.showMessageDialog(null, "Invalid age inputed."); patient.age = Integer.parseInt(JOptionPane.showInputDialog("Please enter valid age:")); tage.setText("" + patient.age); } try { int wet = Integer.parseInt(twt.getText()); twt.setText("" + wet); } catch (Exception e) { JOptionPane.showMessageDialog(null, "Invalid weight inputed."); int wet = Integer.parseInt(JOptionPane.showInputDialog("Please enter valid weight:")); twt.setText("" + wet); } patient.wt = twt.getText(); patient.addr = tadd.getText(); this.ad = tadd.getText(); System.out.println(tadd.getText()); while (true) { patient.cno = tcno.getText(); if (patient.cno.length() == 10) break; else { JOptionPane.showMessageDialog(null, "Invalid Phone No."); patient.cno = JOptionPane.showInputDialog("Please enter valid 10-digit Phone No.:"); tcno.setText(patient.cno); } } patient.dnm = tdnm.getText(); patient.sym = tsym.getText(); System.out.println(tsym.getText()); patient.dig = tdig.getText(); try { patient.fee = Integer.parseInt(tfee.getText()); tfee.setText("" + patient.fee); } catch (Exception e) { JOptionPane.showMessageDialog(null, "Invalid Fee inputed."); patient.fee = Integer.parseInt(JOptionPane.showInputDialog("Please enter valid Fee:")); tfee.setText("" + patient.fee); } patient.bg = tbg.getText(); patient.path = str; } catch (Exception e) { } }