JSP: Differing Prepared statements based on if/else logic

[robtyketto]

Greetings,

Im struggling with the very simple task of having TWO different prepated statements based on a string value (code below)

if(userSelectedCategory != null) {
 
        PreparedStatement myFAQStatement = null, myFAQStatement1 = null, myFAQStatement2 = null;
 
        if (userSelectedCategory == "ALL categories") 
        { 
            PreparedStatement myFAQStatement1 = conn.prepareStatement("SELECT * FROM FAQ");
        }
        else 
        {
            PreparedStatement myFAQStatement2 = conn.prepareStatement("SELECT Id, Category, Question, Answer, Sequence, ViewCount, Rating, UserId, Created, LastUpdated, LastUpdateBy FROM FAQ WHERE Category ='" + userSelectedCategory + "'");
        } 
 
        if(myFAQStatement1 == null) myFAQStatement= myFAQStatement2;
        else myFAQStatement = myFAQStatement1;

It errors with

Duplicate local variable myFAQStatement1
Duplicate local variable myFAQStatement2

Any help would be appreciated, I get confused in java/jsp as with some other languages you can set variables value all over the place without complaints.

Cheers
Rob

[robtyketto]

Bump, any advice (I've use this method before for connections choices) ?

[JosAH]

Leave out the 'PreparedStatement' at the start of line 7 and 11. That way you
don't redefine those two variables. Read a tutorial on Java because this would
happen with any type, not just with PreparedStatements.

kind regards,

Jos