/* //************************************************************************************* // FileName : stmtRequest.java // Author : Rahimunisa // Creation Date : 17/10/1999 // Description : This file contains a class "stmtRequest" which contains all the methods to handle print satement request of a customer. // List Of Methods : // Maintenance History : // Change Request Ref Date Modified Modified By Brief Description //************************************************************************************* */ import java.io.*; import java.sql.*; import javax.servlet.*; import javax.servlet.http.*; import oracle.jdbc.driver.*; public class stmtRequest extends HttpServlet { public void init() { System.out.println("initialed stmtRequest class"); } public void doGet(HttpServletRequest req,HttpServletResponse res) { try { System.out.println("entered doGet "); res.setContentType("text/html"); PrintWriter pw= res.getWriter(); new ebancDB().initDB(); // Prepare a PL/SQL call CallableStatement call = ebancDB.conn.prepareCall ("{ ? = call pkg_ebanc.fun_transaction (?)}"); // Find out all the SALES person call.registerOutParameter (1, OracleTypes.CURSOR); call.setString (2, "5"); call.execute (); ResultSet rset = (ResultSet)call.getObject (1); pw.println(""+ "Statement Request"+ "
"+ "

Statement of Arun

"+ "
Account No : 1111323200034


"+ ""+ " "+ ""+ ""+ ""+ ""+ ""+ ""+ ""); while(rset.next()) { pw.println(""); pw.println(""); pw.println(""); pw.println(""); pw.println(""); pw.println(""); pw.println(""); pw.println(""); } pw.println("
DateCheque NoDescriptionDebitCrebitBalance
"+rset.getString("D002TRANSCDATE")+""+rset.getString("X003TRNSCHEQNO")+""+rset.getString("X004OTHPARTICU")+""+rset.getString("A005WITHDRAAMT")+""+rset.getString("A006TRANSDEPOS")+""+rset.getString("A007TRANSBALAN")+"


"); } catch(Exception e){System.out.println("Display Error = "+e);} } // End of method goGet } // End of class stmtRequest