public void display(ResultSet rs) {
try {
boolean recordNumber = rs.next();
if (recordNumber) {
payNo = rs.getString(1);
pasNo = rs.getString(2);
pasName = rs.getString(3);
mode = rs.getString(4);
dt = rs.getString(5);
amount = rs.getString(6);
rev = rs.getString(7);
text1.setText(payNo);
combo1.setSelectedItem(pasNo);
combo2.setSelectedItem(pasName);
combo4.setSelectedItem(mode);
p_date.setText(dt);
combo8.setSelectedItem(amount);
combo3.setSelectedItem(rev);
} else {
JOptionPane.showMessageDialog(
null, "Record Not found", "ERROR", JOptionPane.DEFAULT_OPTION);
}
} catch (SQLException sqlex) {
sqlex.printStackTrace();
}
}
// Вид формы при изменении сотрудника
public void sotrDiaUpdate(Sotrudnik s) {
label_id_hidden.setText(Integer.toString(s.getId_sotrudnika()));
textField_familiya.setText(s.getFamiliya());
textField_imya.setText(s.getImya());
textField_otchestvo.setText(s.getOtchestvo());
textField_phone.setText(s.getPhone());
textField_date.setText(s.getData_priema().toString());
comboBox_doljnost.removeAllItems();
comboBox_kvalification.removeAllItems();
try {
DBClass db = new DBClass();
ArrayList<Doljnost> d = db.doljnostFromDB();
DBClass db2 = new DBClass();
Doljnost dd = db2.doljnostFromDB(s);
for (int i = 0; i < d.size(); i++) {
comboBox_doljnost.addItem(d.get(i));
Doljnost ddd = (Doljnost) comboBox_doljnost.getItemAt(i);
if (dd.getNazvanie_doljnosti().equals(ddd.getNazvanie_doljnosti())) dd = ddd;
}
comboBox_doljnost.setSelectedItem(dd);
DBClass db3 = new DBClass();
ArrayList<Kvalification> k = db3.kvalificationFromDB();
DBClass db4 = new DBClass();
Kvalification kk = db4.kvalificationFromDB(s);
for (int i = 0; i < k.size(); i++) {
comboBox_kvalification.addItem(k.get(i));
Kvalification kkk = (Kvalification) comboBox_kvalification.getItemAt(i);
if (kk.getNazvanie_kvalification().equals(kkk.getNazvanie_kvalification())) kk = kkk;
}
comboBox_kvalification.setSelectedItem(kk);
} catch (ClassNotFoundException e) {
e.printStackTrace();
JOptionPane.showMessageDialog(panelException, e.getMessage());
} catch (SQLException ee) {
ee.printStackTrace();
JOptionPane.showMessageDialog(panelException, ee.getMessage());
}
}