Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- case 3: //FATTO iuuu
- try {
- scanner.nextLine();
- System.out.println("Inserimento account: ");
- System.out.print("Codice fiscale cliente: ");
- appoggio=scanner.nextLine();
- String controllo= "SELECT Modello FROM VENDITA, ROBOT_1 WHERE VENDITA.CF_C='"+appoggio+"'AND ROBOT_1.Seriale=VENDITA.Seriale;";
- ResultSet sql_controllo= statement.executeQuery(controllo);
- int i=1;
- int punti_ac=0;
- while(avvio==1){
- try {
- sql_controllo.next();
- if(sql_controllo.getString(i).equals("TM5"))
- punti_ac+=300;
- else punti_ac=350;
- i++;
- } catch (SQLException errore) {
- break;
- }
- }
- String sql_query="INSERT INTO ACCOUNTT VALUES(?,?,?,?); ";
- PreparedStatement prepared=connection.prepareStatement(sql_query);
- System.out.print("Username: ");
- prepared.setString(1, scanner.nextLine());
- System.out.print("Password: ");
- prepared.setString(2, scanner.nextLine());
- prepared.setInt(3, punti_ac);
- prepared.setString(4, appoggio);
- prepared.executeUpdate();
- } catch (SQLException e) {
- System.out.println("Non è stato inserito l'account");
- }
- break;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement