Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Connection net=DriverManager.getConnection("jdbc:mysql://localhost:3306/Biblioteca?&useSSL=false", "root", "");
- Statement stmt=net.createStatement();
- 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()+"')");
- 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()+"')");
- stmt.executeUpdate("UPDATE Aval SET Usos=Usos+1 WHERE Nombre='"+textField_6.getText()+"' AND Apellido='"+textField_7.getText()+"'");
- textPane.setText("Registro exitoso.");
- }catch(Exception ex){
- textPane.setText(ex.toString());
- ex.printStackTrace();
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement