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
