title: How to use INSERT INTO ALL statement in jdbc prepared statement with beans
body: <p>Kindly give me some example that how we can use "INSERT INTO ALL STATEMENT" in jdbc prepared statement inside a jsf bean?</p>
  
  <p>Actually i want to take employee id's of present employees using single jsf page and using one textbox for each employee id.</p>
  
  <p>How can i use INSERT INTO ALL statement to achieve this?  </p>
  
  <p>Following is my code snippet.</p>
  
  <p>AttendanceBean.java:</p>
  
  <pre><code>public class AttendanceBean {
  private int atteid;                    
      private String attdname; 
  private int attday;
  private int attmonth;
  private int attyear;
  
      public static Connection getAttConnection() throws Exception {
      String driver = "oracle.jdbc.driver.OracleDriver";
      String url = "jdbc:oracle:thin:@localhost:1521:globldb3";
      String username = "scott";
      String password = "tiger";
      Class.forName(driver);
      Connection conn = DriverManager.getConnection(url, username, password);
      return conn;
    }
  public String addAttendance(){
      Connection conn = null;
      PreparedStatement pstmt = null;
      boolean committed = false;
  try {
      conn = getAttConnection();
      conn.setAutoCommit(false);
      String query = "INSERT ALL INTO attendance VALUES (?,?,?,?,?)";
      pstmt = conn.prepareStatement(query); 
      pstmt.setInt(1,this.atteid); 
      pstmt.setString(2,this.attdname);
      pstmt.setInt(3,this.attday);
      pstmt.setInt(4,this.attmonth);
      pstmt.setInt(5,this.attyear);
              pstmt.executeUpdate();
          conn.commit();
          conn.setAutoCommit(true);
          committed = true;
      return "home.xhtml";
      } catch (Exception e) {
          e.printStackTrace();
          return "CRM.xhtml";
      }   finally {
              try{
                  if (!committed) conn.rollback();
                  if (pstmt != null) pstmt.close();
                  if (conn != null) conn.close();
              }catch(Exception e){
                  e.printStackTrace();
              }
          }
        }
      }    
  </code></pre>