|
|
| |
|
| |
|
| |
|
| |
|
| |
CAREERS |
| |
| |
|
<%
try
{
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
Connection con = DriverManager.getConnection("jdbc:mysql:///wadia", "", "");
Statement statement = con.createStatement();
String temp= "select * from groupmaster,careers_admin where groupmaster.comp_id=careers_admin.comp_id order by careers_admin.comp_id";
ResultSet rs=statement.executeQuery(temp);
String pos;
String swap;
swap="";
while (rs.next())
{
String job_pos = rs.getString("job_pos");
job_pos=job_pos.replace('~','\'');
String comp_id = rs.getString("comp_id");
String job_div = rs.getString("job_div");
job_div=job_div.replace('~','\'');
if (swap.equals(rs.getString ("comp_name") ))
{
}
else
{
out.println("| | ");
out.println(rs.getString ("comp_name"));
out.println(" | ");
swap=rs.getString ("comp_name");
swap=swap.trim();
//out.println("| | | ");
}
%>
| |
|
<%
}
rs.close();
con.close();
}
catch (IOException ioe)
{
out.println(ioe.getMessage());
}
catch (SQLException sqle)
{
out.println(sqle.getMessage());
}
catch (Exception e)
{
System.err.println(e.getMessage());
}
%>
|
|
