Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ///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);
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement