 |
<% if ((request.getParameter("submit_lib_search.x") != null && !request.getParameter("submit_lib_search.x").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 getLibraryDetailsRS = null;
ResultSet getCountLibraryRS = 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_lib_search.x");
String getCountLibrary = "";
if (submit_value != null && !submit_value.equals(""))
{
if ((request.getParameter("accession_no") == null || request.getParameter("accession_no").equals("")) && (request.getParameter("author") == null || request.getParameter("author").equals(""))&& (request.getParameter("title") == null || request.getParameter("title").equals(""))&& (request.getParameter("publication") == null || request.getParameter("publication").equals("")))
{
getCountLibrary = "select count(*) as total from library ";
}
else
{
// get Total Count
getCountLibrary = "select count(*) as total from library where ";
if (request.getParameter("accession_no") != null && !request.getParameter("accession_no").equals(""))
{
getCountLibrary += " accesionno = '" + request.getParameter("accession_no") + "'";
if (request.getParameter("author") != null && !request.getParameter("author").equals("")) {
getCountLibrary += " and author like '" + request.getParameter("author") + "%'";
}
if (request.getParameter("title") != null && !request.getParameter("title").equals("")) {
getCountLibrary += " and title like '" + request.getParameter("title") + "%'";
}
if (request.getParameter("publication") != null && !request.getParameter("publication").equals("")) {
getCountLibrary += " and publication like '" + request.getParameter("publication") + "%'";
}
}
else if (request.getParameter("author") != null && !request.getParameter("author").equals("")) {
getCountLibrary += " author like '" + request.getParameter("author") + "%'";
if (request.getParameter("title") != null && !request.getParameter("title").equals("")) {
getCountLibrary += " and title like '" + request.getParameter("title") + "%'";
}
if (request.getParameter("publication") != null && !request.getParameter("publication").equals("")) {
getCountLibrary += " and publication like '" + request.getParameter("publication") + "%'";
}
}
else if (request.getParameter("title") != null && !request.getParameter("title").equals("")) {
getCountLibrary += " title like '" + request.getParameter("title") + "%'";
if (request.getParameter("publication") != null && !request.getParameter("publication").equals("")) {
getCountLibrary += " and publication like '" + request.getParameter("publication") + "%'";
}
}
else if (request.getParameter("publication") != null && !request.getParameter("publication").equals("")) {
getCountLibrary += " publication like '" + request.getParameter("publication") + "%'";
}
} // if ends for checking whether all field are empty or not
getCountLibraryRS = stmt1.executeQuery(getCountLibrary);
if (getCountLibraryRS.next())
{
totalTopics = getCountLibraryRS.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 getLibraryDetails = "";
if ((request.getParameter("accession_no") == null || request.getParameter("accession_no").equals("")) && (request.getParameter("author") == null || request.getParameter("author").equals(""))&& (request.getParameter("title") == null || request.getParameter("title").equals(""))&& (request.getParameter("publication") == null || request.getParameter("publication").equals("")))
{
getLibraryDetails = "select * from library order by accesionno LIMIT " + start_no + "," + RECORDS_PER_PAGE + "";
}
else
{
getLibraryDetails = "select * from library where ";
if (request.getParameter("accession_no") != null && !request.getParameter("accession_no").equals(""))
{
getLibraryDetails += " accesionno = '" + request.getParameter("accession_no") + "'";
if (request.getParameter("author") != null && !request.getParameter("author").equals("")) {
getLibraryDetails += " and author like '" + request.getParameter("author") + "%'";
}
if (request.getParameter("title") != null && !request.getParameter("title").equals("")) {
getLibraryDetails += " and title like '" + request.getParameter("title") + "%'";
}
if (request.getParameter("publication") != null && !request.getParameter("publication").equals("")) {
getLibraryDetails += " and publication like '" + request.getParameter("publication") + "%'";
}
}
else if (request.getParameter("author") != null && !request.getParameter("author").equals("")) {
getLibraryDetails += " author like '" + request.getParameter("author") + "%'";
if (request.getParameter("title") != null && !request.getParameter("title").equals("")) {
getLibraryDetails += " and title like '" + request.getParameter("title") + "%'";
}
if (request.getParameter("publication") != null && !request.getParameter("publication").equals("")) {
getLibraryDetails += " and publication like '" + request.getParameter("publication") + "%'";
}
}
else if (request.getParameter("title") != null && !request.getParameter("title").equals("")) {
getLibraryDetails += " title like '" + request.getParameter("title") + "%'";
if (request.getParameter("publication") != null && !request.getParameter("publication").equals("")) {
getLibraryDetails += " and publication like '" + request.getParameter("publication") + "%'";
}
}
else if (request.getParameter("publication") != null && !request.getParameter("publication").equals("")) {
getLibraryDetails += " publication like '" + request.getParameter("publication") + "%'";
}
getLibraryDetails = getLibraryDetails + " order by accesionno LIMIT " + start_no + "," + RECORDS_PER_PAGE + ""; // get Only 15 records at a time
}// if ends for checking whether all field are empty or not
getLibraryDetailsRS = stmt.executeQuery(getLibraryDetails);
%> <%if (!getLibraryDetailsRS.next())
{ // if there are no records
%> Sorry!!! No matches found for your search.
<% }
else
{ // if records exists
//************************************************************************************
if(totalPages>1)
{%>
<%}
//**************************************************************************************
//border="1" bordercolorlight="#E4EAF5" bordercolordark="#FFFFFF"
%> | # | Author | Title | Publication |
<% do
{ // while loop starts
String accesionno = getLibraryDetailsRS.getString("accesionno");
String author = getLibraryDetailsRS.getString("author");
String title = getLibraryDetailsRS.getString("title");
String publication = getLibraryDetailsRS.getString("publication");
%> | <%=accesionno%> | <%=author%> | <% if ( title != null && !title.equals("null"))
{
%> <%=title%> | <% }
else
{
%> -- | <% }
if ( publication != null && !publication.equals("null"))
{
%> <%=publication%> | <% }
else
{
%> -- | <% }
%> <% } while(getLibraryDetailsRS.next()); //while loop ends
%>
<% } // if ends
} // try ends
catch(Exception e)
{
System.out.println("error While retrieving:::::::"+e);
}
finally
{
try
{
if(getLibraryDetailsRS!=null)getLibraryDetailsRS.close(); // Close the ResultSet
if(connection!=null)connection.close(); // Close the Connection
}
catch(Exception er){}
}
}
else
{ // border="1" bordercolorlight="#E4EAF5" bordercolordark="#FFFFFF"
%>
<% }
%>
|
©
Copyright 2003 Sohan Lal DAV College of Education, Ambala. | Privacy
Policy |
Site Designed and Maintained by VardhmanSoft, Ambala, India. |