public void initialFill(String month) { try { ResultSet query = dbm.query("SELECT * FROM prcr_margin_dates WHERE month LIKE '" + month + "'"); row = 0; while (query.next()) { division = query.getString("division"); margin = query.getShort("margin"); workingdays = query.getShort("total"); table.setValueAt(division, row, 0); table.setValueAt(margin, row, 2); table.setValueAt(workingdays, row, 1); row++; } if (row == 0) { query = dbm.query("SELECT * FROM division_details"); while (query.next()) { division = query.getString("code"); table.setValueAt(division, row, 0); row++; } } query.close(); } catch (SQLException ex) { Logger.getLogger(PRCR_change_margin_dates.class.getName()).log(Level.SEVERE, null, ex); } }
public boolean checkDataAvailability( String table_name, String table_column_giving1, String row_element1, String table_column_giving2, String row_element2, String table_column_need) { // DatabaseManager dbm = DatabaseManager.getDbCon(); try { ResultSet query = dbm.query( "SELECT * FROM " + table_name + " where " + table_column_giving1 + " LIKE '" + row_element1 + "' AND " + table_column_giving2 + " LIKE '" + row_element2 + "'"); while (query.next()) { // s = query.getString(table_column_need); return true; } query.close(); } catch (SQLException ex) { return false; } return false; }
private void division_comboItemStateChanged( java.awt.event.ItemEvent evt) { // GEN-FIRST:event_division_comboItemStateChanged DatabaseManager dbma = DatabaseManager.getDbCon(); String Name = null; if (evt.getStateChange() == ItemEvent.SELECTED) { String item = evt.getItem().toString(); try { ResultSet query = dbma.query("SELECT * FROM division_details WHERE code =" + item + ""); while (query.next()) { Name = query.getString("division"); System.out.println(Name); } } catch (SQLException ex) { System.out.println("error"); } division_lb.setText("" + Name); } } // GEN-LAST:event_division_comboItemStateChanged