Can we use two quries using prepared statement in one method

[Adnan Gondal]

HI all!

Can we use two quries in one method while using prepared statement, i have tried using this but invalid column name exception is comeing. Any idea please?

My code snippets is as follows.

 public double getPayroll(){
            ResultSet rs = null;
            ResultSet rs2 = null;
            Connection conn = null;
            PreparedStatement pstmt = null;
            try {
              conn = getDBConnection();
              int employeeId;
              String q1 = "select e_salary,e_house_rent,e_conv_allow,e_id 
                            from employee";
              pstmt = conn.prepareStatement(q1);
              rs = pstmt.executeQuery();
              double dailyPay=0,basicPay=0,payroll2=0;
              int houseRent=0,convAllow=0;
              while (rs.next()) {
                dailyPay = rs.getInt(1)*.03;
                houseRent=rs.getInt(2);
                convAllow=rs.getInt(3);
                employeeId=rs.getInt(4);
              }
              String q2="select att_status from attendance where 
                            e_id=employeeId";
              pstmt = conn.prepareStatement(q2);
              rs2 = pstmt.executeQuery();
              int noOfPresents = 0;
              while(rs2.next()){
                  noOfPresents+=1;
             }    
             basicPay=dailyPay*noOfPresents;
             payroll2+=basicPay+houseRent+convAllow;

              return payroll2;  
            } catch (Exception e) {
              e.printStackTrace();
              return 0.0;
            } finally {
              try {
                rs.close();
                pstmt.close();
                conn.close();
              } catch (Exception e) {
                e.printStackTrace();
              }
            }
}

[Paul Clapham]

Kajal, please don't cross-post your questions to multiple forums. Especially don't repost in a second forum when you already have responses to the original post. I'm closing this one.

(Original post here: https://coderanch.com/t/538753/JSF/java/we-two-quries-prepared-statement for anybody who wants to respond.)