Java Question

[Kapadia Mitesh-C23457]

I've been trying to compile my BLB (Business Logic Bean) and have been getting errors 
during compilation.  I haven't a clue as to how I could debug this.  Any assistance 
would be appreciated.

Thanks in advance.

- Mitesh

Error Messages during compilation:

    [javac] Compiling 2 source files to 
C:\jakarta-tomcat-4.1.27\webapps\benchmark\WEB-INF\classes
    [javac] 
C:\jakarta-tomcat-4.1.27\webapps\benchmark\WEB-INF\src\net\reumann\OrgIdService.java:56:
 stmt is already defined in execute(net.reumann.DataHash)
    [javac]                                     Statement stmt = 
conn.createStatement();
    [javac]                                                   ^
    [javac] 
C:\jakarta-tomcat-4.1.27\webapps\benchmark\WEB-INF\src\net\reumann\OrgIdService.java:57:
 rs is already defined in execute(net.reumann.DataHash)
    [javac]                                     ResultSet rs = 
stmt.executeQuery("SELECT FACIL_ID, FACIL_NAME, FACIL_NAME_SHORT, ORG_ID FROM FACILITY 
WHERE FACIL_ID = '" + facilId + "'");
    [javac]                                                   ^
    [javac] 2 errors

Here is the code from my BLB:

package net.reumann;

import java.io.*;
import java.util.ArrayList;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
import javax.sql.*;
import net.reumann.*;
import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.action.ActionForm;
import org.apache.log4j.*;
import org.apache.commons.beanutils.BeanUtils;


public class OrgIdService implements Serializable {

        //Declare and initialize variables
        Connection conn = null;
        Statement stmt = null;
        ResultSet rs = null;
        ArrayList facilList = new ArrayList();

        //The execute() method of OrgIdService is called by OrgIdAction to execute a 
query against the SS Test DB
        public ArrayList execute(DataHash beanHash)     {

                //Get mode from DataHash
                int mode = beanHash.getMode();

                try{
                        switch (mode)   {
                                case 0:
                                        
Class.forName("oracle.jdbc.driver.OracleDriver");
                                        conn = 
DriverManager.getConnection("jdbc:oracle:thin:@sources:1521:TEST","Test1234","Test1234");
                                        Statement stmt = conn.createStatement();
                                        ResultSet rs = stmt.executeQuery("SELECT 
DISTINCT FACIL_ID FROM FACILITY");

                                        //Read ResultSet into instance of FacilBean 
and add to facilList Array object
                                        while (rs.next()) {
                                                FacilBean facil = new FacilBean();
                                                
facil.setFacilId(rs.getString("FACIL_ID"));
                                                facilList.add(facil);
                                        }

                                        //Close ResultSet and Connection objects
                        rs.close();
                                        conn.close();
                                case 1:
                                        //Extract the facilId from the DataHash to 
query the FACILITY table
                                        String facilId = (String) 
beanHash.get("FacilId");

                                        
Class.forName("oracle.jdbc.driver.OracleDriver");
                                        conn = 
DriverManager.getConnection("jdbc:oracle:thin:@sources:1521:TEST","Test1234","Test1234");
                                        Statement stmt = conn.createStatement();
                                        ResultSet rs = stmt.executeQuery("SELECT 
FACIL_ID, FACIL_NAME, FACIL_NAME_SHORT, ORG_ID FROM FACILITY WHERE FACIL_ID = '" + 
facilId + "'");

                                        //Read ResultSet into instance of FacilBean 
and add to facilList Array object
                                        while (rs.next()) {
                                                FacilBean facil = new FacilBean();
                                                
facil.setFacilId(rs.getString("FACIL_ID"));
                                                
facil.setFacilName(rs.getString("FACIL_NAME"));
                                                
facil.setFacilName(rs.getString("FACIL_NAME_SHORT"));
                                                facil.setOrgId(rs.getString("ORG_ID"));
                                                facilList.add(facil);
                                        }

                                        //Close ResultSet and Connection objects
                                        rs.close();
                                        conn.close();
                                default:
                                        return null;
                        }//end Switch
                }//end try
                catch (Exception e) {
                        return null;
                        e.printStackTrace();
                }//end catch

                //Return facilList Array Object to OrgIdAction
                return facilList;
        }//end Execute () method
}//end class