Problema IF-ELSE

[Jack496]

Ecco a te

public class Database {    Connection con = null;
    Statement stmt = null;
    ResultSet rs = null;
    PreparedStatement pst = null;
    
    String hostName="locahost";
    String dbPort = "3306";
    String databaseName="lspd";
    String dbUser="root";
    String dbPassword="ciao";
    String jdbc_driver = "com.mysql.jdbc.Driver";
    String user,pw,subname;
    public Database(String nome,String password,String cognome){
        this.user = nome; 
        this.pw = password;
        this.subname=cognome;
        connect(hostName,dbPort,databaseName,dbUser,dbPassword);
         
    }
    
    public void connect(String hostName,String dbPort,String databaseName,String dbUser,String dbPassword){
         
        try {
            Class.forName(jdbc_driver);
            //con = (Connection) DriverManager.getConnection("jdbc:mysql://"+hostName+":"
                   // + dbPort+"/"+databaseName+"?"+"user="+dbUser+"&password=" + dbPassword);
             /*con = DriverManager.getConnection("jdbc:mysql://"+hostName+":"
                    + dbPort+"/"+databaseName, dbUser, dbPassword);*/
             
             String connectionString = "jdbc:mysql://localhost/" + databaseName+ "?user=" + dbUser + "&password=" + dbPassword + "&useUnicode=true&characterEncoding=UTF-8";
            con = DriverManager.getConnection(connectionString);
            
             if(con != null)
            {
                System.out.println("Connesso");
            }
            
             
            /*String query = "SELECT * FROM `account` where nome=? and password=?";
            try{
                pst = con.prepareStatement(query);
                pst.setString(1,user);
                pst.setString(2, pw);
                rs = pst.executeQuery();
                
                if(rs.next())
                {
                    System.out.println("Trovato utente");
                }else{
                    System.out.println("non trovato");
                }
            }catch(Exception e){
                
            }*/
             String databaseUsername="",databasePassword="",databaseCognome="";
             System.out.println("user"+user+"\npw:"+pw+"\n Cog:"+subname);
             Statement stmt = con.createStatement();
            String SQL = "SELECT * FROM account WHERE nome='" + user + "' && cognome='" + subname +"' && password='" + pw + "'";


            ResultSet rs = stmt.executeQuery(SQL);


            // Check Username and Password
            while (rs.next()) {
                databaseUsername = rs.getString("nome");
                databaseCognome = rs.getString("cognome");
                databasePassword = rs.getString("password");
                if(user.equals(databaseUsername) && subname.equals(databaseCognome) && pw.equals(databasePassword)){
                JOptionPane.showMessageDialog(null, "Login effettuato con successo", "Info", JOptionPane.INFORMATION_MESSAGE);
                new Menu();
                break;
                }else{
                    JOptionPane.showMessageDialog(null, "Non sono stati inseriti i campi in modo corretto", "Info", JOptionPane.INFORMATION_MESSAGE);   }
            }
  
            
        } catch (SQLException ex) {
            Logger.getLogger(Database.class.getName()).log(Level.SEVERE, null, ex);
        } catch (ClassNotFoundException ex) {
            Logger.getLogger(Database.class.getName()).log(Level.SEVERE, null, ex);
        }
    }
}