Advertisement
Guest User

Untitled

a guest
Nov 7th, 2017
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.29 KB | None | 0 0
  1. try{
  2. Class.forName("org.postgresql.Driver");
  3. con=DriverManager.getConnection("jdbc:postgresql://localhost:5432/ejemplo","postgres","199314");
  4. stmt = con.createStatement();
  5. String insert="insert into personas values('"+rut+"','"+nombres+"','"+apellidos+"','"+edad+"','"+sueldo+"')";
  6. String consulta="select from personas where rut='"+rut+"'";
  7. rs=stmt.executeQuery(consulta);
  8. if(rs.next()){
  9. JOptionPane.showMessageDialog(null, "El rut ya existe en la base de datos");
  10. }else{
  11.  
  12. stmt.execute(insert);
  13. JOptionPane.showMessageDialog(null,"Datos ingresados correctamente");
  14. }
  15. con.close();
  16.  
  17.  
  18. }catch(Exception e){
  19. JOptionPane.showMessageDialog(null,"erro al conectar ala base de datos");
  20. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement