 |
<% if ((request.getParameter("submit_alumni_search.x") != null && !request.getParameter("submit_alumni_search.x").equals("")) || (request.getParameter("alumni_id") != null && !request.getParameter("alumni_id").equals("")) || (request.getParameter("pageNo") != null && !request.getParameter("pageNo").equals("")))
{
String pageNo = request.getParameter("pageNo");
if (pageNo == "" || pageNo == null)
{
pageNo = "1";
}
%>
<%@ page import="java.sql.*" %>
<%@ page language="java" import="java.util.*,javax.mail.*,javax.mail.internet.*,javax.activation.*"%>
<%
String connectionURL = "jdbc:mysql://localhost/sldaveducation_org?user=sldavedu&password=sdvedu88"; // SLDAV
// String connectionURL = "jdbc:mysql://localhost/sldaveducation_org?user=kiran&password=mysql"; // CT
Connection connection = null;
Statement stmt = null;
Statement stmt1 = null;
ResultSet getAlumniDetailsRS = null;
ResultSet getCountAlumniRS = null;
int insertResult=0;
int totalTopics = 0; // ResultSet Count
try
{
Class.forName("org.gjt.mm.mysql.Driver").newInstance(); // MySQL Driver Loaded
connection = DriverManager.getConnection(connectionURL, "", ""); // Connected to Database
stmt = connection.createStatement();
stmt1 = connection.createStatement();
String submit_value = request.getParameter("submit_alumni_search.x");
String getCountAlumni = "";
if (submit_value != null && !submit_value.equals(""))
{
if ((request.getParameter("first_name") == null || request.getParameter("first_name").equals("")) && (request.getParameter("last_name") == null || request.getParameter("last_name").equals(""))&& (request.getParameter("eq").equals("-1"))&& (request.getParameter("year_of_passing") == null || request.getParameter("year_of_passing").equals("")))
{
getCountAlumni = "select count(*) as total from alumni_reg where status = 0 ";
}
else
{
// get Total Count
getCountAlumni = "select count(*) as total from alumni_reg where ";
if (request.getParameter("first_name") != null && !request.getParameter("first_name").equals("")) {
getCountAlumni += " first_name like '" + request.getParameter("first_name") + "%' ";
if (request.getParameter("last_name") != null && !request.getParameter("last_name").equals("")) {
getCountAlumni += " and last_name like '" + request.getParameter("last_name") + "%'";
}
if (!request.getParameter("eq").equals("-1")) {
getCountAlumni += " and (eq1 = '" + request.getParameter("eq") + "'";
getCountAlumni += " or eq2 = '" + request.getParameter("eq") + "')";
}
if (request.getParameter("year_of_passing") != null && !request.getParameter("year_of_passing").equals("")) {
getCountAlumni += " and (eq1_yop = " + request.getParameter("year_of_passing");
getCountAlumni += " or eq2_yop = " + request.getParameter("year_of_passing") + ")";
}
}
else if (request.getParameter("last_name") != null && !request.getParameter("last_name").equals("")) {
getCountAlumni += " last_name like '" + request.getParameter("last_name") + "%'";
if (!request.getParameter("eq").equals("-1")) {
getCountAlumni += " and (eq1 = '" + request.getParameter("eq") + "'";
getCountAlumni += " or eq2 = '" + request.getParameter("eq") + "')";
}
if (request.getParameter("year_of_passing") != null && !request.getParameter("year_of_passing").equals("")) {
getCountAlumni += " and (eq1_yop = " + request.getParameter("year_of_passing");
getCountAlumni += " or eq2_yop = " + request.getParameter("year_of_passing") + ")";
}
}
else if (!request.getParameter("eq").equals("-1")) {
getCountAlumni += " ( eq1 = '" + request.getParameter("eq") + "'";
getCountAlumni += " or eq2 = '" + request.getParameter("eq") + "')";
if (request.getParameter("year_of_passing") != null && !request.getParameter("year_of_passing").equals("")) {
getCountAlumni += " and (eq1_yop = " + request.getParameter("year_of_passing");
getCountAlumni += " or eq2_yop = " + request.getParameter("year_of_passing") + ")";
}
}
else if (request.getParameter("year_of_passing") != null && !request.getParameter("year_of_passing").equals("")) {
getCountAlumni += " (eq1_yop = " + request.getParameter("year_of_passing");
getCountAlumni += " or eq2_yop = " + request.getParameter("year_of_passing") + ")";
}
getCountAlumni = getCountAlumni + " and status = 0 ";
} // if ends for checking whether all field are empty or not
getCountAlumniRS = stmt1.executeQuery(getCountAlumni);
if (getCountAlumniRS.next())
{
totalTopics = getCountAlumniRS.getInt("total");
}
}// if ends for Checking the value of Submit Button
else
{
totalTopics = Integer.parseInt(request.getParameter("totalTopics"));
}
final int RECORDS_PER_PAGE = 15; //Declare the number of records per page
int totalPages=totalTopics/RECORDS_PER_PAGE; //Calculate No.Of Pages
if(totalTopics%RECORDS_PER_PAGE!=0)totalPages+=1;
int start_no = (Integer.parseInt(pageNo)-1)*RECORDS_PER_PAGE;
String getAlumniDetails = "";
if ((request.getParameter("first_name") == null || request.getParameter("first_name").equals("")) && (request.getParameter("last_name") == null || request.getParameter("last_name").equals(""))&& (request.getParameter("eq").equals("-1"))&& (request.getParameter("year_of_passing") == null || request.getParameter("year_of_passing").equals("")))
{
getAlumniDetails = "select * from alumni_reg where status = 0 order by alumni_id LIMIT " + start_no + "," + RECORDS_PER_PAGE + "";
}
else
{
getAlumniDetails = "select * from alumni_reg where ";
if (request.getParameter("first_name") != null && !request.getParameter("first_name").equals("")) {
getAlumniDetails += " first_name like '" + request.getParameter("first_name") + "%' ";
if (request.getParameter("last_name") != null && !request.getParameter("last_name").equals("")) {
getAlumniDetails += " and last_name like '" + request.getParameter("last_name") + "%'";
}
if (!request.getParameter("eq").equals("-1")) {
getAlumniDetails += " and (eq1 = '" + request.getParameter("eq") + "'";
getAlumniDetails += " or eq2 = '" + request.getParameter("eq") + "')";
}
if (request.getParameter("year_of_passing") != null && !request.getParameter("year_of_passing").equals("")) {
getAlumniDetails += " and (eq1_yop = " + request.getParameter("year_of_passing");
getAlumniDetails += " or eq2_yop = " + request.getParameter("year_of_passing") + ")";
}
}
else if (request.getParameter("last_name") != null && !request.getParameter("last_name").equals("")) {
getAlumniDetails += " last_name like '" + request.getParameter("last_name") + "%'";
if (!request.getParameter("eq").equals("-1")) {
getAlumniDetails += " and (eq1 = '" + request.getParameter("eq") + "'";
getAlumniDetails += " or eq2 = '" + request.getParameter("eq") + "')";
}
if (request.getParameter("year_of_passing") != null && !request.getParameter("year_of_passing").equals("")) {
getAlumniDetails += " and (eq1_yop = " + request.getParameter("year_of_passing");
getAlumniDetails += " or eq2_yop = " + request.getParameter("year_of_passing") + ")";
}
}
else if (!request.getParameter("eq").equals("-1")) {
getAlumniDetails += " ( eq1 = '" + request.getParameter("eq") + "'";
getAlumniDetails += " or eq2 = '" + request.getParameter("eq") + "')";
if (request.getParameter("year_of_passing") != null && !request.getParameter("year_of_passing").equals("")) {
getAlumniDetails += " and (eq1_yop = " + request.getParameter("year_of_passing");
getAlumniDetails += " or eq2_yop = " + request.getParameter("year_of_passing") + ")";
}
}
else if (request.getParameter("year_of_passing") != null && !request.getParameter("year_of_passing").equals("")) {
getAlumniDetails += " (eq1_yop = " + request.getParameter("year_of_passing");
getAlumniDetails += " or eq2_yop = " + request.getParameter("year_of_passing") + ")";
}
getAlumniDetails = getAlumniDetails + " and status = 0 order by alumni_id LIMIT " + start_no + "," + RECORDS_PER_PAGE + "";
}// if ends for checking whether all field are empty or not
// out.println(getAlumniDetails);
getAlumniDetailsRS = stmt.executeQuery(getAlumniDetails);
if (!getAlumniDetailsRS.next())
{
%> Sorry!!! No matches found for your search.
<% }
else
{
//************************************************************************************
if(totalPages>1)
{%>
<%}
//**************************************************************************************
//border="1" bordercolorlight="#E4EAF5" bordercolordark="#FFFFFF"
%>
| Alumni Name |
B.Ed |
Passed Out |
M.Ed |
Passed Out |
|
<% do
{ // while loop starts
int alumni_id = getAlumniDetailsRS.getInt("alumni_id");
String eq1 = getAlumniDetailsRS.getString("eq1");
String eq1_yop = getAlumniDetailsRS.getString("eq1_yop");
String eq2 = getAlumniDetailsRS.getString("eq2");
String eq2_yop = getAlumniDetailsRS.getString("eq2_yop");
String date_of_birth = getAlumniDetailsRS.getString("date_of_birth");
String present_address = getAlumniDetailsRS.getString("present_address");
String e_mail = getAlumniDetailsRS.getString("e_mail");
String present_org = getAlumniDetailsRS.getString("present_org");
String present_desig = getAlumniDetailsRS.getString("present_desig");
String phone_off = getAlumniDetailsRS.getString("phone_off");
if (eq1 != null && !eq1.equals(""))
{
eq1 = "Yes";
}
else
{
eq1 = "--";
}
if (eq1_yop != null && !eq1_yop.equals(""))
{
eq1_yop = getAlumniDetailsRS.getString("eq1_yop");
}
else
{
eq1_yop = "--";
}
if (eq2 != null && !eq2.equals(""))
{
eq2 = "Yes";
}
else
{
eq2 = "--";
}
if (eq2_yop != null && !eq2_yop.equals(""))
{
eq2_yop = getAlumniDetailsRS.getString("eq2_yop");
}
else
{
eq2_yop = "--";
}
%>
| <%=getAlumniDetailsRS.getString("title")%><%=getAlumniDetailsRS.getString("first_name")%> <%=getAlumniDetailsRS.getString("last_name")%> |
<%=eq1%> |
<%=eq1_yop%> |
<%=eq2%> |
<%=eq2_yop%> |
View Details |
<% } while(getAlumniDetailsRS.next()); //while loop ends
%>
<% } // if ends
%>
<% } // try ends
catch(Exception e)
{
System.out.println("error While retrieving:::::::"+e);
}
finally
{
try
{
if(getAlumniDetailsRS!=null)getAlumniDetailsRS.close(); // Close the ResultSet
if(connection!=null)connection.close(); // Close the Connection
}
catch(Exception er){}
}
}
else
{
%>
<% }
%>
|
© Copyright 2003 Sohan Lal DAV College of Education, Ambala. | Privacy
Policy |
Site Designed and Maintained by VardhmanSoft, Ambala, India. |