<%@ page  import="java.io.*, java.sql.*,java.util.*, java.text.*,spsjobs.*" %>
<%! Connection con=null; %>
<%! 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 -------------------------------
%>
<%
	//String student="student";
    /*
	try
    {
		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		con=DriverManager.getConnection("jdbc:odbc:spsjobsonline");
    }catch(Exception e)
    {
		
		System.out.println("error in loading the database"+e);
    }
*/
  
    try
    {	
		
		Statement statement2 = null;
		//int number =0;
		
		//int num=0;
	//	String loginname = (String) session.getValue("loginname");
	//	String password = (String) session.getValue("password");

 if( true)
	{
			String Sub_type=null;
			String Sub_type1=null;
			int count=0;
				try{
						
						statement2 = con.createStatement();
						
						ResultSet rs1=statement2.executeQuery("select * from Subscribe order by Id");
						
						while(rs1.next())
						{
							 count++;
				             Sub_type="Subscribe "+count;
							 Sub_type1="Subscribe1 "+count;
							 session.putValue(Sub_type,rs1.getString(1));
							 session.putValue(Sub_type1,rs1.getString(2));
						
						}
						statement2.close();								 
					}catch(Exception e)
						{
					 		
							 System.out.println("error in  subscribe table access"+e);
						}
					
				%>
				
				<%@ include file="jobsonline_trainingcenterG.jsp" %>
				
			<%		
					
	
	}else  
	{ 	 %>
	
			<%@ include file="jobsonline_loginerror1.htm" %>
			
		
	<%		}
    	}catch(Exception ex)
    	{
			%>
			<%@ include file="jobsonline_loginerror.htm" %>
			<% System.out.println("Getting data error "+ex);
				  
    	 } 
			%>
								
<%	
//-------------------------------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){
	}
	finally{
    	   	try{         
			if (con!=null){
	          		insert.freeConnection(con);
			}
	   	}
        	catch(Exception e){
		}
	}
//-------------------------------close of Second  Cut---------------------------------	
%>