%@ 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
|
Hot Jobs
|
Apply Now |
|
Job Title |
Description |
Date |
<%
while(rs.next())
{
%>
|
<%= 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 %>
|
<%
tot_rec += 1;
}
%>
<%
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");
}
%>