
Untitled
By: a guest on
Sep 14th, 2012 | syntax:
Java | size: 1.38 KB | hits: 34 | expires: Never
///Populate jComboBox
private void FillCombo(){
String sql = "Select ID_osoba, Ime, Prezime from osoba";
try{
pst = conn.prepareStatement(sql);
rs = pst.executeQuery();
while (rs.next()){
String nme = rs.getString("Ime");
String gg = rs.getString("ID_osoba");
String ggg = rs.getString("Prezime");
int gggg = rs.getInt("ID_osoba");
jComboBox1.addItem(gggg +"."+" "+" "+ nme +" "+ ggg);
}
}
catch(Exception e){
JOptionPane.showMessageDialog(null, e);
}
}
///Insert into database
private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
conn = Connect.ConnectDB();
String sql = "INSERT INTO adresa (Naziv_ulice, Br_ulice, ID_Osoba_FK, Id_grad_FK) VALUES ('"+ULICA.getText()+"','"+BROJUL.getText()+"','"+jComboBox1.getSelectedObjects()+"','"+jComboBox2.getItemAt(WIDTH) +"')" ;
try{
pst = conn.prepareStatement(sql);
pst.execute();
JOptionPane.showMessageDialog(null, "Saved");
UpdateJTable();
//conn.close();
}
catch(Exception e){
JOptionPane.showMessageDialog(null, e);
}
}