Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Scanner sc = new Scanner(System.in);
- System.out.println("Titulo del nuevo album 1: ");
- String titulo = sc.nextLine();
- System.out.println("Autor del nuevo album 1: ");
- String autor = sc.nextLine();
- System.out.println("Titulo del nuevo album 2: ");
- String titulo2 = sc.nextLine();
- System.out.println("Autor del nuevo album 2: ");
- String autor2 = sc.nextLine();
- PreparedStatement consulta;
- try {
- conexion.setAutoCommit(false);
- consulta = conexion.prepareStatement("INSERT INTO albumes (id, titulo, autor) VALUES (default, ?, ?);");
- consulta.setString(1, titulo);
- consulta.setString(2, autor);
- consulta.executeUpdate();
- consulta = conexion.prepareStatement("INSERT INTO albumes (id, titulo, autor) VALUES (default, ?, ?);");
- consulta.setString(1, titulo2);
- consulta.setString(2, autor2);
- consulta.executeUpdate();
- conexion.commit();
- } catch (SQLException e) {
- conexion.rollback();
- e.printStackTrace();
- }
- sc.close();
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement