Tuesday, 11 December 2012

Prepared Statement - Controller

    //In Controller
   
    import java.sql.Connection; 
    import java.sql.PreparedStatement;

                                     
 Connection conn = pageContext.getApplicationModule(webBean).getOADBTransaction().getJdbcConnection(); 
 String Query = " UPDATE tpc_pklist_roll_details_temp SET interface_id = :1 WHERE roll_line_id=:2"; 
 PreparedStatement stmt = conn.prepareStatement(Query); 
  stmt.setString(1, pseqno);
  stmt.setString(2, rolllineid);
  stmt.executeUpdate();
  conn.commit();