Advertisement
Guest User

Untitled

a guest
Oct 9th, 2016
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.31 KB | None | 0 0
  1. Connection net=DriverManager.getConnection("jdbc:mysql://localhost:3306/Biblioteca?&useSSL=false", "root", "");
  2. Statement stmt=net.createStatement();
  3. stmt.executeUpdate("INSERT INTO Clientes(Id, Nombre, Apellidos, Ocupación, Dirección, Correo, Teléfono, Identificación, `Nombre Aval`, `Apellidos Aval`) Values(NULL,'"+textField.getText()+"','"+textField_1.getText()+"','"+textField_2.getText()+"','"+textField_3.getText()+"','"+textField_4.getText()+"','"+textField_5.getText()+"','"+textField_13.getText()+"','"+textField_6.getText()+"','"+textField_7.getText()+"')");
  4. stmt.executeUpdate("INSERT INTO Aval(Id, Nombre, Apellidos, Dirección, Correo, Teléfono, Ocupación, Parentesco, Identificación) Values(NULL,'"+textField_6.getText()+"','"+textField_7.getText()+"','"+textField_8.getText()+"','"+textField_9.getText()+"',"+textField_10.getText()+",'"+textField_11.getText()+"','"+textField_12.getText()+"','"+textField_14.getText()+"')");
  5. stmt.executeUpdate("UPDATE Aval SET Usos=Usos+1 WHERE Nombre='"+textField_6.getText()+"' AND Apellido='"+textField_7.getText()+"'");
  6. textPane.setText("Registro exitoso.");
  7. }catch(Exception ex){
  8. textPane.setText(ex.toString());
  9. ex.printStackTrace();
  10. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement