<%@ page import="java.io.*,java.sql.*,java.util.*,spsjobs.*" %> <%! Connection con; %> <%! JobsOnlineConnectionPoolS insert=null; %> <% //-----------------------------Code for connection pool begins ------------ insert=new JobsOnlineConnectionPoolS(); boolean conCheck=true; try { con=insert.getConnection(); if (con==null) { Thread.sleep(50); con=insert.getConnection(); if (con==null) { Thread.sleep(50); con=insert.getConnection(); if (con==null) { conCheck=false; } } } if(conCheck){ //--------------------------------First cut ------------------------------- %> Empoloyers: Salary Surveys
SPSJOBS
Online Test
<% }//end of if block check for the true of resultset else { %> <%} pmt.close(); rs.close(); //master id is added into session session.putValue("id",""+Master_id); System.out.println("ok"); session.putValue("pages",""+pages_no); System.out.println("session value"+session.getValue("pages")); }//end of try block catch(Exception e) { System.out.println("catch the exception "+e); log("catch the exception "+e); }%>
Edit Section
 
<% log("con"+con); int i=0; long count=0; String loginname=(String)session.getValue("loginname"); log("loginname"+loginname ); //String loginname="dd"; String ExperienceStr=""; int pages_no=0; boolean exp=true; PreparedStatement pmt1,pmt; ResultSet rs,rscount; String experStr=""; int Master_id=0; try { ExperienceStr="Select distinct t.experience,t.Id from test_given_from t where t.Id=(select m.id from master m where m.LoginName=?)"; pmt=con.prepareStatement(ExperienceStr); System.out.println("ExperienceStr"+ExperienceStr); pmt.setString(1,loginname); rs=pmt.executeQuery(); exp=rs.next(); log("exp"+exp); if(exp) { %> Select the Experience    
No Question inputed.
 
Home     Close
© 2000-2001 SPS Intrad Pvt Ltd. World Wide. Developed by http://www.spsintrad.com/
<% //-------------------------------Second Cut--------------------------------- }//end of if block for connection boolean else{ %> <%@ include file="jobsonline_connection.jsp" %> <% }//end of else block for connection boolean }//end of try catch(Exception ex){ log("ex"+ex); } finally{ try{ if (con!=null){ insert.freeConnection(con); } } catch(Exception e){ } } //-------------------------------close of Second Cut--------------------------------- %>