<%@ page contentType="text/html;charset=UTF-8" import="java.io.PrintWriter" session="false" %> <%@ page import="java.io.IOException"%> <%@ page import="java.sql.*"%> <%@ page import="javax.sql.*"%> <%@ page import="javax.naming.*"%> Contact Us
   
 
 
 
 
 

Empowering your IT Initiatives

HBI has a proven track record of meeting demanding quality and delivery schedules in highly competitive markets.
<%! private static final String CONTENT_TYPE = "text/html; charset=UTF-8"; Connection con = null; Context ctx = null; DataSource ds = null; PreparedStatement ps=null; ResultSet rs=null; private Connection MyConnection() throws Exception { Context init =new InitialContext(); ctx =(Context) init.lookup("java:comp/env"); ds = (DataSource) ctx.lookup("jdbc/HBISite"); synchronized(ds) { con=ds.getConnection(); } return con; } %> <% String ss=null; String job_tit = "", query="select * from hbijobs order by srno"; int tot_rec=0, srno=0; try { con = MyConnection(); ps = con.prepareStatement(query, ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE); ResultSet rs = ps.executeQuery(); %>
Hot jobs
<% while(rs.next()) { %> <% tot_rec += 1; } %>

Hot Jobs Apply Now
Job Title
Description
Date
<%= rs.getString(2) %> <%= rs.getString(3) %> <% String dt = rs.getString(4); dt = dt.substring(8, dt.length()) +"-"+ dt.substring(5,7)+"-"+ dt.substring(0,4); %> <%= dt %>

Total hot jobs : <%= tot_rec %>

  | Add Jobs |    Modify Jobs |    Delete Jobs |  
<% rs.close(); ps.close(); con.close(); /* } catch(Exception e) { out.println(e); } */ //} } catch(NullPointerException ne) { out.println("null pointer exception arised......"); response.sendRedirect("/HBISite/Login.htm"); } catch(Exception e) { response.sendRedirect("/HBISite/Login.htm"); } %>