How To Run SQL query in OAF

Prepared statement in oaf

1. import java.sql.Connection;  
2. import java.sql.PreparedStatement;  
3. import java.sql.ResultSet;  
4.   
5. Expample 1:-
6.              
7.  try
8.               {
9.                   Connection conn = pageContext.getApplicationModule(webBean).getOADBTransaction().getJdbcConnection();
10.               String query = "select REQUEST_NUMBER from mtl_txn_request_headers mtrh where mtrh.header_id="+VHEADER_ID+"";
11.               PreparedStatement stmt = conn.prepareStatement(query);
12.              // String resultset = stmt.executeQuery().toString();
13.                   ResultSet resultset = stmt.executeQuery();
14.                   resultset.next();
15.               System.out.println("Move Oredr number Is"+resultset.getInt("REQUEST_NUMBER") );
16.                   OAHeaderBean headerBean = (OAHeaderBean)webBean.findChildRecursive("region2");
17.                   headerBean.setText("Move Order Number "+resultset.getInt("REQUEST_NUMBER"));
18.               }     
19.              catch(Exception e)
20.               {
21.                   throw OAException.wrapperException(e);
22.               }
23. 
    
24. 
    
25. Example 2:-
26. 
    
28. try  
29.   
30. {  
31.   
32.   
33. Connection conn = pageContext.getApplicationModule(webBean).getOADBTransaction().getJdbcConnection();  
34.   
35. String Query = "SELECT count(*) count from XX_PA_SCO_V where project_id=:1 and CI_ID is not null";  
36.   
37. PreparedStatement stmt = conn.prepareStatement(Query);  
38. stmt.setString(1, project_id);  
39. for(ResultSet resultset = stmt.executeQuery(); resultset.next();)  
40. {  
41. pageContext.writeDiagnostics(this, "Query Executed", 1);  
42. result = resultset.getInt("count");;  
43. pageContext.writeDiagnostics(this, "Query Executed"+ result, 1);  
44. }  
45. }  
46.   
47. catch(Exception exception)  
48.   
49. {   
50. throw new OAException("Error in Staffing Query"+exception, OAException.ERROR);  
51. }