Empoloyers: Salary Surveys

<%@ 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 <% System.out.println("-------------jobsonline_s_select_comp_exp.jsp--------------"); //Connection con=null; Statement stmt = null; ResultSet rs=null; stmt=con.createStatement(); session.putValue("total_marks",""+0); rs=stmt.executeQuery("select * from test_details"); String subject_name=""; rs=stmt.executeQuery("SELECT DISTINCT companyname FROM master, test_given_from WHERE master.id=test_given_from.id"); log("rs"+rs); %>

SPSJOBS
Online Test

Select the Experience

Select the Company Name

Accessibility General test Test for selected candidates

Home Close

<% //-------------------------------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--------------------------------- %>