(LMS)
studentid.java
package userLogin;
import connection.Databasecon;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
//import java.util.Map;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
public class studentid extends HttpServlet
{
private String studentid = null;
private Connection con = null;
private Statement stmt = null;
private ResultSet rs = null;
Databasecon dbcon = new Databasecon();
@Override
public void doPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException
{
response.setContentType("text/html");
PrintWriter out = response.getWriter();
RequestDispatcher rds;
HttpSession session = request.getSession(true);
if(dbcon!=null)
{
try
{
con = dbcon.getConnection();
stmt = con.createStatement();
String query = "select * from studentinfo where studentid = '"+request.getParameter("studentid")+"'";
/*studentid,studentbranch,studentyear*/
rs = stmt.executeQuery(query);
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
out.println("<html><head><meta http-equiv='Content-Type' content='text/html; charset=iso-8859-1' /><title>Library Management System - Link Software Bhopal</title><link href='css/first.css' rel='stylesheet' />");
out.println("</head><body>");
out.println("<div id='header'><table width='80%' height='147' border='0' align='center' cellpadding='0' cellspacing='0' bgcolor='#FFFFFF'><!--DWLayoutTable--><tr><td width='141' bgcolor='#F10403'><div align='center'></div></td><td width='475' height='19' background='Images/bg-1.gif'><div align='center'><span class='style2'>LIBRARY MANAGEMENT SOFTWARE </span></div></td><td width='180' background='Images/bg-1.gif'><div align='center'><span class='style11'><strong><a href='/LMS/UserControl/signout.jsp' class='menu1'>Sign Out</a></strong></span> </div></td></tr><tr><td bgcolor='#990000'><!--DWLayoutEmptyCell--> </td><td height='19' colspan='2' bgcolor='#990000'><!--DWLayoutEmptyCell--> </td></tr><tr><td width='141' rowspan='3' bgcolor='#990000'><!--DWLayoutEmptyCell--> </td><td height='42' colspan='2' bgcolor='#990000'><div align='center' class='style1 style26'>Link Software Bhopal</div></td></tr><tr><td height='14' colspan='2' bgcolor='#990000'><div align='right' class='menu1'>");
out.println(new java.util.Date());
out.println("</div></td></tr><tr><td height='14' colspan='2' bgcolor='#990000'><div align='center' class='style22'><a href='/LMS/index.jsp' class='menu1'>Home</a> | <a href='/LMS/aboutus.jsp' class='menu1'>About us</a> | <a href='/LMS/gallary.jsp' class='menu1'>Gallery </a>| <a href='/LMS/sitemap.jsp' class='menu1'>Sitemap </a>|<a href='/LMS/contact.jsp' class='menu1'> Contact us </a></div></td></tr><tr><td height='29' colspan='3' valign='top' bgcolor='#990000' style='border-bottom:#F10403 thick solid;'> </td><tr><td height='29' colspan='3' valign='top' bgcolor='#FFFFCC'><h4>");
out.println(session.getAttribute("username"));
out.println("</h4></td> <!-- <tr><td height='29' colspan='3' valign='top' bgcolor='#990000' style='border-bottom:#F10403 thick solid;'> </td>--></table></div>");
//out.println("<br />");
out.println("<br /><br /><br /><br /><br />");
//////////////////////////
//UnComplete
/////////////////////
out.println("<script type='text/javascript'>");
out.println("function validator()");
out.println("{");
out.println("var searching = document.getElementById('id1');");
out.println("if(notEmpty(searching,'Please Enter Book Name'))");
out.println("{ ");
out.println("return true;");
out.println("}");
out.println("return false;");
out.println("}");
out.println("function notEmpty(elem, helperMsg){");
out.println("if(elem.value.length == 0){");
out.println("alert(helperMsg);elem.focus(); return false;");
out.println("}return true;");
out.println("}");
out.println("</script>");
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
if(rs.next()==true)
{
String studentid;
studentid=rs.getString("studentid");
out.println("<table align='center' border='1' class='menu'>");
out.println("<tr align='left' class='main'><th>Student id:</th><td>"+rs.getString("studentid")+"</td></tr>");
out.println("<tr align='left'><th>Student Name: </th><td>"+rs.getString("FirstName")+"</td></tr>");
out.println("<tr align='left'><th>Last Name:</th> <td>"+rs.getString("lastName")+"</td></tr>");
out.println("<tr align='left'><th>Father Name:</th><td>"+rs.getString("Fathername")+"</td></tr>");
out.println("<tr align='left'><th>Home Contect:</th><td>"+rs.getString("Homecontect")+"</td></tr>");
out.println("<tr align='left'><th>Student Branch: </th><td>"+rs.getString("studentbranch")+"</td></tr>");
out.println("<tr align='left'><th>Student Year:</th><td>"+rs.getString("studentyear")+"</td></tr>");
out.println("</table>");
/////////////////////////////////////////////////////////////////
out.println("<div align='right'><table width = '80%' align='center'><tr align='right'><td>");
out.println("<form action = 'SearchBook' method = 'post' class='menu' onsubmit='return validator()'></td></tr><tr align='right'><td>");
out.println("<input type='hidden' name='studentid' value = '"+studentid+"'></td></tr><tr align='right'><td class='menu'>");
out.println("Search Book: <input type = 'text' name = 'searching' id='id1'/></td></tr><tr align='right'><td>");
out.println("<input type = 'submit' value='Search Book'></td></tr><tr align='right'><td>");
out.println("</form></td></tr><tr align='right'><td>");
out.println("</td></tr></table></div>");
//////////////////////////////////////////////////////
// session.put("studentid", studentid);
//rds = request.getRequestDispatcher("/searchbook.jsp");
//rds.forward(request,response);
//out.println("Login Successful");
}
else
{
out.println("<h1 align = 'center' class = 'menu'>Your Id is Invalid.Re-Enter Student ID</h1>");
//rds = request.getRequestDispatcher("UserControl/LibrarianLogin.jsp");
//rds.forward(request,response);
// out.println("Re-Enter User Id and Password");
}
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
out.println("</td>");
// out.println("<td>");
// out.println("<table border = '1' align = 'center'>");
// out.println("<tr>");
// out.println("<td>");
//
// out.println("<div align = 'right'>");
// out.println("<img src='C://LMS/web/image/barcode.jpg' width = '110' height='50'><br>");
// String qry = "select id from ddc where branch = '"+request.getParameter("selectbranch")+"'";
// rs = stmt.executeQuery(qry);
// System.out.println(qry);
// if(rs.next()==true)
// {
// //session.put("selectbranch", selectbranch);
//
// out.println("<div align='right' class='menu'><b>"+rs.getString(1)+"<b></div>");
//
// }
//
// out.println("</td>");
// out.println("</tr>");
// out.println("</table>");
// out.println("</td>");
out.println("<br /><br /><br /><br /><br />");
out.println("<div align='left'><table width = '80%' align='center'><tr><td>");
out.println("<a href='/LMS/UserControl/LibrarianLogin.jsp' class='menu'>Librarian Home</a></td></tr></table></div>");
out.println("<div id='footer'><table width='80%' border='0' align='center' cellpadding='0' cellspacing='0' bgcolor='#FFFFFF'><tr><td colspan='3'> </td></tr><tr><td height='26' colspan='3' bgcolor='#990000'><div align='center'><span class='style22'><a href='index.jsp' class='menu1'>Home</a> | <a href='aboutus.jsp' class='menu1'>About us</a> | <a href='gallary.jsp' class='menu1'>Gallery </a>| <a href='sitemap.jsp' class='menu1'>Sitemap </a>|<a href='contact.jsp' class='menu1'> Contact us </a> </span></div></td></tr><tr><td width='24%' bgcolor='#990000'><div align='center'><span class='style15'>Copyright © 2017, Link Software Solution</span> </div></td><td width='56%'><div align='center'><span class='style17'><strong>Best view:</strong> 1024x724 Pixel (Resolution) </span></div></td><td width='20%' bgcolor='#990000'><div align='center' class='style23'><span class='style19'><strong><u>Created & Designed by:</u> <br /></strong>Balwant Chandel</span></div></td></tr><tr><td bgcolor='#990000'> </td><td bgcolor='#990000'> </td><td bgcolor='#990000'> </td></tr></table></div></body></html>");
}
catch(Exception ex)
{
System.out.println("This is a Connection Error"+ex);
}
}
else
{
System.out.println("Connection not Established");
}
}
}
Comments
Post a Comment