missing return statement

[brian]

both methods are giving me a missing return statement and I can't figure out why.

import java.sql.*;

public class practice1 {
    String driver = "com.mysql.jdbc.Driver";
    public static void main(String []args){
        practice1 practice = new practice1();
        practice.addUser("Brian1", "asddsg");
    }


public boolean addUser(String UserName, String Password){

Connection conn = null;
Statement stmt = null;

String username = UserName;
String password = Password;
try{
Class.forName(driver).newInstance();
String connURL = "jdbc.mysql://localhost/prog38081";
String dbUsername = "root";
String dbPassword = "";

conn = DriverManager.getConnection(connURL, dbUsername, dbPassword);

stmt = conn.createStatement();

String sql = "Insert into Login (username, password)" + " Values ('" + username + "', '" + password + "')"; 
int rows = stmt.executeUpdate(sql);

if (rows > 0){
    return true;
}else{
    return false;
}


}catch(ClassNotFoundException cnf){
   System.out.println("class not found");
    return false;
}catch(InstantiationException ie){
     System.out.println("instantiation");
    return false;
}catch(IllegalAccessException iae){
     System.out.println("Illegal access");
    return false;
}catch(SQLException sql){
     System.out.println("sql");
    
}finally{
    try{
        if(stmt != null){
            stmt.close();
        }
        if(conn != null){
        conn.close();
    }
        
    }catch(Exception ex){
    }
    

}
      
}
    public boolean delUser(String UserName, String Password){
        
        Connection conn = null;
        Statement stmt = null;
        
        String username = UserName;
        String password = Password;
      try{  
        Class.forName(driver).newInstance();
        
        String connURL = "jbdc.mysql://localhost/prog38081";
       String dbusername = "root";
       String dbpassword = "";
        conn = DriverManager.getConnection(connURL, dbusername, dbpassword);
        stmt = conn.createStatement();
        
        String sql = "delete from Login " + "where username =  '" + username +  "' and password = '" + password + "'";
        
        int rows = stmt.executeUpdate(sql);
        
        if (rows > 0) {

return true;

} else {

return false;

}
        
        
    
}catch(ClassNotFoundException cnf){
    
}catch(InstantiationException ins){
    
}catch(IllegalAccessException iae){
    
}catch(SQLException sql){
    
}finally{
    try{
        if(stmt != null){
            stmt.close();
        }
        if(conn != null){
        conn.close();
    }
        
    }catch(Exception ex){
    }
}
    }
}

[jim829]

Let's say you catch an exception, process it, and then continue. What do you return?

Regards,
Jim

[brian]

thanks, I figured it out. I missed a couple return statements on the exceptions.