kumaresanramu/PdfServlet.java

## login.css
@CHARSET "ISO-8859-1";
* Bordered form */
form {
    border: 3px solid #f1f1f1;
}

/* Full-width inputs */
input[type=text], input[type=password] {
    width: 25%;
    padding: 10px 10px;
    margin: 8px 0;
    display: inline-block;
    border: 1px solid #ccc;
    box-sizing: border-box;
}

/* Set a style for all buttons */
button {
     background-color: #4CAF50; /* Green */
    border: none;
    color: white;
    padding: 15px 32px;
    text-align: center;
    text-decoration: none;
    display: inline-block;
    font-size: 16px;


}

/* Extra style for the cancel button (red) */
.cancelbtn {
    width: auto;
    padding: 15px 32px;
    background-color: #f44336;
}

/* Center the avatar image inside this container */
.imgcontainer {
    text-align: center;
    margin: 24px 0 12px 0;
}

/* Add padding to containers */
.container {
    padding: 10px;
}

/* The "Forgot password" text */
span.psw {
    float: right;
    padding-top: 16px;
}
}

## login.jsp
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>loginpage</title>
<link href="login.css" rel="stylesheet" type="text/css">
<script>
function validateForm() {
    var x = document.forms["myForm"]["uname"].value;
    var y = document.forms["myForm"]["psw"].value;
    if ((x == null || x == "")) {
        alert("Name must be filled out");
        return false;
    }
    else if ((y == null || y == "")) {
    	 alert("password must be filled out");
    	 return false;
	}
}
</script>

</head>
<body>

<div class="city">
 <center><div class="imgcontainer">
    <img src="https://upload.wikimedia.org/wikipedia/en/thumb/c/cc/Ace-logo.svg/1280px-Ace-logo.svg.png" alt="Avatar" height="100" width="100">
  </div></center>
<p>This login is only for college employees.this website is used for maintain student student records </p>
<h1 style="color:green;"><b>description</b></h1>
  <p>A rapidly changing world is one of the biggest challenges facing today's graduates. New technologies, new working practices and changes in tastes and fashions require graduates who are equipped with flexible attitudes. AEC provides students with the skills to succeed.
AEC, a Co-Educational institution was established in the year 1993. The college is spread out on serene sylvan settings on the Chittor - Cuddalore national highway, providing a holistic environment, ideal for dedicated study with discipline, away from the hustle and bustle of the modern cities...</p>
 </div>

<div class="city">

 <form name="myForm" method="post" action="loginServlet" onsubmit="return validateForm()">
<center><div class="imgcontainer">
    <img src="http://www.iconskid.com/images/3/login-iconpng-3068.png" height="100" width="100">
  </div></center>


<center><h1 style="color:blue;"><b>AdminLogin</b></h1></center>
  <center><div class="container">
    <label><b>Username </b></label>
    <input type="text"  name="uname" >
  </div>

  <div class="container">
    <label><b>Password </b></label>
    <input type="password" name="psw" >
	 </div>
 <div class="container">
    <button type="submit">Login</button>
    </div></center>

  <div class="container" style="background-color:#f1f1f1">
   <a href="signup.jsp"> <button type="button" class="cancelbtn">signup</button></a>
    <span class="psw">Forgot <a href="signup.jsp">password?</a></span>
  </div>
  </form>
  </div>

</body>
</html>

## loginServlet.java


import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.text.BreakIterator;
import java.util.Date;

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

/**
 * Servlet implementation class loginServlet
 */
@WebServlet("/loginServlet")
public class loginServlet extends HttpServlet {
	private static final long serialVersionUID = 1L;


	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		  response.setContentType("text/html;charset=UTF-8");
	        PrintWriter out = response.getWriter();

	        String name = request.getParameter("uname");

	        String pass = request.getParameter("psw");


	        try{

	        //loading drivers for mysql
	        Class.forName("com.mysql.jdbc.Driver");

		//creating connection with the database
	          Connection  con=DriverManager.getConnection
	                     ("jdbc:mysql://localhost:3306/kumaresanlogin","root","root");

	        PreparedStatement ps=con.prepareStatement("select username, password from kumaresanlogin.signup where username =? and password=?");

	        ps.setString(1, name);

	        ps.setString(2, pass);
	        ResultSet rs=ps.executeQuery();

	          if(rs.next()==true)
	          {
	            out.println("You are sucessfully loggedin");
	            HttpSession session=request.getSession();
				session.setAttribute("student","true");
				request.getRequestDispatcher("student.jsp").include(request, response);

	          }
	          else{
	        	  out.println("user name(or) password is incorrect");


					request.getRequestDispatcher("signup.jsp").include(request, response);


	        }
	          con.close();
	          ps.close();
	          rs.close();
	        }
	        catch(Exception se)
	        {
	            se.printStackTrace();
	        }
	}
}

## pdf.jsp
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
	pageEncoding="ISO-8859-1"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<META HTTP-EQUIV="Pragma" CONTENT="no-cache">
<META HTTP-EQUIV="Expires" CONTENT="-1">
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>PDF GENERATOR</title>
<link href="login.css" rel="stylesheet" type="text/css">
</head>
<body bgcolor=#6B8E23>
	<form name="myForm1" method="post" action="PdfServlet" >
		<center>
			<div class="clearfix">
				<button type="submit">Pdf</button>
			</div>
		</center>
		<p><h3>This PDF page and Pdf button one and only for generationg pdf file.</h3></p>
		<p><b><u>copy rights </u></b></p>
		<p><b>www.kumaresanramu.in</b></p>

	</form>
</body>
</html>

## PdfServlet.java
import java.awt.image.BufferedImage;
import java.io.File;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.Date;
import javax.imageio.ImageIO;
import javax.servlet.ServletException;
import javax.servlet.annotation.MultipartConfig;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.lowagie.text.Document;
import com.lowagie.text.DocumentException;
import com.lowagie.text.Image;
import com.lowagie.text.Paragraph;
import com.lowagie.text.Phrase;
import com.lowagie.text.pdf.PdfPCell;
import com.lowagie.text.pdf.PdfPTable;
import com.lowagie.text.pdf.PdfWriter;

/**
 * Servlet implementation class PdfServlet
 */
@WebServlet("/PdfServlet")
@MultipartConfig(maxFileSize = 16177215)
public class PdfServlet extends HttpServlet {
	private static final long serialVersionUID = 388110564278942780L;

	protected void doPost(HttpServletRequest request,
			HttpServletResponse response) throws ServletException, IOException {
		response.setContentType("text/html;charset=UTF-8");
		try {
			Class.forName("com.mysql.jdbc.Driver");
			Connection conn = DriverManager.getConnection(
					"jdbc:mysql://localhost:3306/kumaresanlogin", "root",
					"root");
			Statement stmt = conn.createStatement();
			/* Define the SQL query */
			ResultSet set = stmt
					.executeQuery("SELECT * from kumaresanlogin.student");
			Document document = new Document();

			PdfWriter writer = PdfWriter
					.getInstance(
							document,
							new FileOutputStream(
									"C:\\Users\\i00588\\Desktop\\vairavan\\WebContent\\GeneratedResults\\HelloWorld.pdf"));
			document.open();

			PdfPTable firsttable = new PdfPTable(8);
			PdfPCell table_cell;
			// Add table column Names
			firsttable.addCell("NAME");
			firsttable.addCell("AGE");
			firsttable.addCell("ADDRESS");
			firsttable.addCell("PHONE NUMBER");
			firsttable.addCell("EMAIL ID");
			firsttable.addCell("STUDETN NUMBER");
			firsttable.addCell("GENDER");
			firsttable.addCell("IMAGE");

			while (set.next()) {
				String name = set.getString("name");
				table_cell = new PdfPCell(new Phrase(name));
				firsttable.addCell(table_cell);

				String age = set.getString("age");
				table_cell = new PdfPCell(new Phrase(age));
				firsttable.addCell(table_cell);

				String address = set.getString("address");
				table_cell = new PdfPCell(new Phrase(address));
				firsttable.addCell(table_cell);

				String phone_no = set.getString("phone number");
				table_cell = new PdfPCell(new Phrase(phone_no));
				firsttable.addCell(table_cell);

				String emailId = set.getString("emailId");
				table_cell = new PdfPCell(new Phrase(emailId));
				firsttable.addCell(table_cell);

				String student_no = set.getString("student no");
				table_cell = new PdfPCell(new Phrase(student_no));
				firsttable.addCell(table_cell);

				String gender = set.getString("gender");
				table_cell = new PdfPCell(new Phrase(gender));
				firsttable.addCell(table_cell);

				// adding image to pdf
				java.sql.Blob blob = set.getBlob("image");
				InputStream in = blob.getBinaryStream();
				BufferedImage image = ImageIO.read(in);

				java.awt.Image awtImage = image;
				com.lowagie.text.Image img1 = com.lowagie.text.Image
						.getInstance(awtImage, null);

				Image image1 = Image.getInstance(img1);// extra line just for verification
				image1.scaleAbsolute(50, 50);
				firsttable.addCell(image1);
				//document.add(image1);

			}

			document.add(firsttable);

			document.add(new Paragraph(new Date().toString()));
			PrintWriter our = response.getWriter();
			if ((new File(
					"C:\\Users\\i00588\\Desktop\\vairavan\\WebContent\\GeneratedResults\\HelloWorld.pdf"))
					.exists()) {

				Process p = Runtime
						.getRuntime()
						.exec("rundll32 url.dll,FileProtocolHandler C:\\Users\\i00588\\Desktop\\vairavan\\WebContent\\GeneratedResults\\HelloWorld.pdf");

				p.waitFor();
				our.println("pdf File genertated");
				request.getRequestDispatcher("student.jsp").include(request,
						response);
				response.setHeader("Cache-Control", "no-cache, no-store, must-revalidate"); // HTTP 1.1.
				response.addHeader("Cache-Control", "post-check=0, pre-check=0");
		        response.setHeader("Pragma", "no-cache"); // HTTP 1.0.
		        response.setDateHeader("Expires", 0);


			} else {

				// System.out.println("File is not exists");
				our.println("File is not exists");
				request.getRequestDispatcher("student.jsp").include(request,
						response);
				response.setHeader("Cache-Control", "no-cache, no-store, must-revalidate"); // HTTP 1.1.
				response.addHeader("Cache-Control", "post-check=0, pre-check=0");
		        response.setHeader("Pragma", "no-cache"); // HTTP 1.0.
		        response.setDateHeader("Expires", 0);


			}

			document.close();
			writer.close();

		} catch (DocumentException e) {
			e.printStackTrace();
		} catch (FileNotFoundException e) {
			e.printStackTrace();
		} catch (Exception e) {

			e.printStackTrace();
		}

	}

}
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
	pageEncoding="ISO-8859-1"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<META HTTP-EQUIV="Pragma" CONTENT="no-cache">
<META HTTP-EQUIV="Expires" CONTENT="-1">
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>PDF GENERATOR</title>
<link href="login.css" rel="stylesheet" type="text/css">
</head>
<body bgcolor=#6B8E23>
	<form name="myForm1" method="post" action="PdfServlet" >
		<center>
			<div class="clearfix">
				<button type="submit">Pdf</button>
			</div>
		</center>
		<p><h3>This PDF page and Pdf button one and only for generationg pdf file.</h3></p>
		<p><b><u>copy rights </u></b></p>
		<p><b>www.kumaresanramu.in</b></p>

	</form>
</body>
</html>

## signup.jsp
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>signup</title>
<link href="login.css" rel="stylesheet">
<script >
function validateForm() {
    var x = document.forms["myForm"]["user"].value;
    var y = document.forms["myForm"]["pass1"].value;
    var z = document.forms["myForm"]["pass2"].value;

    if ((x == null || x == "")) {
        alert("Name must be filled out");
        return false;
    }
    else if ((y == null || y == "")) {
    	 alert("password must be filled out");
    	 return false;
	}
    else if ((z == null || z != y)) {
   	 alert("password must be same");
   	 return false;
	}

	}

</script>
</head>
<body>
<form name="myForm" method="post" action="SignupServlet" onsubmit="return validateForm()">

 <h1 style="color:green;"><b>Admin signup:</b></h1>
	<center><div class="imgcontainer">
    <img src="http://previews.123rf.com/images/faysalfarhan/faysalfarhan1605/faysalfarhan160504742/57292278-Sign-up-member-icon-glossy-cyan-blue-round-button-Stock-Photo.jpg" alt="Avatar" height="100" width="100">
  </div></center>
	<p>Username: <input type="text" name="user" size="20"></p>
	<p>Password: <input type="password" name="pass1" size="20"></p>
	<p>Re-type password: <input type="password" name="pass2" size="20"></p><hr>
	<p>First name: <input type="text" name="firstname" size="20"></p>
	<p>Last name: <input type="text" name="lastname" size="20"></p>
	 <br />
    <input type="radio" name="gender" value="M" /> Male
    <br />
    <input type="radio" name="gender" value="F" /> Female
    <br />
    <center><input type="submit" name="sub" value="Submit"></center>


</form>

</body>
</html>

## SignupServlet.java


import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

/**
 * Servlet implementation class SignupServlet
 */
@WebServlet("/SignupServlet")
public class SignupServlet extends HttpServlet {
	private static final long serialVersionUID = 1L;

    /**
     * @see HttpServlet#HttpServlet()
     */
    public SignupServlet() {
        super();
        // TODO Auto-generated constructor stub
    }


	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

		   response.setContentType("text/html;charset=UTF-8");
	        PrintWriter out = response.getWriter();

	        String username = request.getParameter("user");

	        String password = request.getParameter("pass1");

	        String firstname = request.getParameter("firstname");
	        String lastname = request.getParameter("lastname");
	        String gender = request.getParameter("gender");
	        try{

	        //loading drivers for mysql
	        Class.forName("com.mysql.jdbc.Driver");

		//creating connection with the database
	          Connection  con=DriverManager.getConnection
	                     ("jdbc:mysql://localhost:3306/kumaresanlogin","root","root");

	        PreparedStatement ps=con.prepareStatement
	                  ("insert into kumaresanlogin.signup values(?,?,?,?,?)");

	        ps.setString(1, username);

	        ps.setString(2, password);
	        ps.setString(3, firstname);

	        ps.setString(4, lastname);
	        ps.setString(5, gender);
	        int i=ps.executeUpdate();

	          if(i>0)
	          {
	            out.println("You are sucessfully registered");

				request.getRequestDispatcher("login.jsp").include(request, response);
	          }
	          con.close();
	          ps.close();

	        }

	        catch(Exception se)
	        {
	        	out.println("---mismatching error--");
	            se.printStackTrace();
	        }
	       }
	}


## student.jsp
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>student</title>
<link href="login.css" rel="stylesheet">
</head>
<script>
function validateForm() {
    var x = document.forms["myForm"]["name"].value;
    var y = document.forms["myForm"]["age"].value;
    var z = document.forms["myForm"]["address"].value;
    var a = document.forms["myForm"]["phno"].value;
    var b = document.forms["myForm"]["eid"].value;
    var c = document.forms["myForm"]["stdno"].value;
    if ((x == null || x == "")) {
        alert("Name must be filled out");
        return false;
    }
    else if ((y == null || y == "")) {
    	 alert("age must be filled out");
    	 return false;
	}
    else if ((z == null || z == "")) {
   	 alert("address must be filled out");
   	 return false;
	}
    else if ((a == null || a == "")) {
      	 alert("phoneno id must be filled out");
      	 return false;
   	}
    else if ((b == null || b == "")) {
     	 alert("email id id must be filled out");
     	 return false;
  	}
    else if ((c == null || a == "")) {
     	 alert("studentno must be filled out");
     	 return false;
  	}
}
</script>
<body>
<form name="myForm" method="post" action="StudentServlet" onsubmit="return validateForm()">
 <center><div class="imgcontainer">
    <img src="http://www.gbscampuscare.in/Images/Student.png" alt="Avatar" height="100" width="100">
  </div></center>
<h1 style="color:green;"><b>Enter Student Details:</b></h1>
  <div class="container">

    <label><b>student name:</b></label>
    <input type="text"  name="name"   >
 </div>
  <div class="container">

    <label><b>Age:</b></label>
    <input type="number"  name="age"  >
 </div>
  <div class="container">
    <label><b>address:</b></label>
    <input type="text"  name="address"   >
</div>
  <div class="container">
    <label><b>phone no:</b></label>
    <input type="number"  name="phno" >

    </div>
	<div class="container">
    <label><b>emailId</b></label>
    <input type="text"  name="eid"   value="">

    </div>

   <div class="container">
    <label><b>student no</b></label>
    <input type="text"  name="stdno"  value="">

    </div>
    <br />
    <input type="radio" name="gender" value="M" /> Male
    <br />
    <input type="radio" name="gender" value="F" /> Female
    <br />

   <center> <div class="clearfix">
      <button type="submit" class="signupbtn">Submit</button></div></center>

</form>
</body>
</html>

## StudentServlet.java


import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

/**
 * Servlet implementation class StudentServlet
 */
@WebServlet("/StudentServlet")
public class StudentServlet extends HttpServlet {
	private static final long serialVersionUID = 1L;

    /**
     * @see HttpServlet#HttpServlet()
     */
    public StudentServlet() {
        super();
        // TODO Auto-generated constructor stub
    }

	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		 response.setContentType("text/html;charset=UTF-8");
	        PrintWriter out = response.getWriter();

	        String name = request.getParameter("name");

	        String age = request.getParameter("age");
	        String address = request.getParameter("address");
	        String phoneno = request.getParameter("phno");
	        String eid = request.getParameter("eid");
	        String studentno = request.getParameter("stdno");
	        String gender = request.getParameter("gender");
	        try{

	        //loading drivers for mysql
	        Class.forName("com.mysql.jdbc.Driver");

		//creating connection with the database
	          Connection  con=DriverManager.getConnection
	                     ("jdbc:mysql://localhost:3306/kumaresanlogin","root","root");

	        PreparedStatement ps=con.prepareStatement
	                  ("insert into kumaresanlogin.student values(?,?,?,?,?,?,?)");

	        ps.setString(1, name);

	        ps.setString(2, age);
	        ps.setString(3, address);

	        ps.setString(4, phoneno);
	        ps.setString(5, eid);

	        ps.setString(6, studentno);
	        ps.setString(7, gender);

	        int i=ps.executeUpdate();

	          if(i>0)
	        {
	        	  out.println("your details successfully added!!!");
	        	  HttpSession session=request.getSession();
					session.setAttribute("student","true");
					request.getRequestDispatcher("student.jsp").include(request, response);


	          }
	          else{
	        	  out.println("please re_enter details");

					request.getRequestDispatcher("student.jsp").include(request, response);
	          }
	          con.close();
	          ps.close();

	        }
	        catch(Exception se)
	        {
	            se.printStackTrace();
	        }
	}

}

## web.xml
<?xml version="1.0" encoding="UTF-8"?>
<web-app id="WebApp_ID" version="3.0"
 xmlns="http://java.sun.com/xml/ns/javaee"
 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd">
 <display-name>vairavan</display-name>
 <welcome-file-list>
  <welcome-file>/login.jsp</welcome-file>
 </welcome-file-list>
 <servlet>
 <servlet-name>loginServlet</servlet-name>
 <servlet-class>loginServlet</servlet-class>
 </servlet>
 <servlet>
 <servlet-name>SignupServlet</servlet-name>
 <servlet-class>SignupServlet</servlet-class>
 </servlet>
 <servlet-mapping>
 <servlet-name>loginServlet</servlet-name>
 <url-pattern>/loginServlet</url-pattern>
 </servlet-mapping>
  <servlet-mapping>
 <servlet-name>SignupServlet</servlet-name>
 <url-pattern>/SignupServlet</url-pattern>
 </servlet-mapping>
</web-app>
	@CHARSET "ISO-8859-1";
	* Bordered form */
	form {
	border: 3px solid #f1f1f1;
	}

	/* Full-width inputs */
	input[type=text], input[type=password] {
	width: 25%;
	padding: 10px 10px;
	margin: 8px 0;
	display: inline-block;
	border: 1px solid #ccc;
	box-sizing: border-box;
	}

	/* Set a style for all buttons */
	button {
	background-color: #4CAF50; /* Green */
	border: none;
	color: white;
	padding: 15px 32px;
	text-align: center;
	text-decoration: none;
	display: inline-block;
	font-size: 16px;


	}

	/* Extra style for the cancel button (red) */
	.cancelbtn {
	width: auto;
	padding: 15px 32px;
	background-color: #f44336;
	}

	/* Center the avatar image inside this container */
	.imgcontainer {
	text-align: center;
	margin: 24px 0 12px 0;
	}

	/* Add padding to containers */
	.container {
	padding: 10px;
	}

	/* The "Forgot password" text */
	span.psw {
	float: right;
	padding-top: 16px;
	}
	}
	<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
	pageEncoding="ISO-8859-1"%>
	<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
	<html>
	<head>
	<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
	<title>loginpage</title>
	<link href="login.css" rel="stylesheet" type="text/css">
	<script>
	function validateForm() {
	var x = document.forms["myForm"]["uname"].value;
	var y = document.forms["myForm"]["psw"].value;
	if ((x == null \|\| x == "")) {
	alert("Name must be filled out");
	return false;
	}
	else if ((y == null \|\| y == "")) {
	alert("password must be filled out");
	return false;
	}
	}
	</script>

	</head>
	<body>

	<div class="city">
	<center><div class="imgcontainer">
	<img src="https://upload.wikimedia.org/wikipedia/en/thumb/c/cc/Ace-logo.svg/1280px-Ace-logo.svg.png" alt="Avatar" height="100" width="100">
	</div></center>
	<p>This login is only for college employees.this website is used for maintain student student records </p>
	<h1 style="color:green;"><b>description</b></h1>
	<p>A rapidly changing world is one of the biggest challenges facing today's graduates. New technologies, new working practices and changes in tastes and fashions require graduates who are equipped with flexible attitudes. AEC provides students with the skills to succeed.
	AEC, a Co-Educational institution was established in the year 1993. The college is spread out on serene sylvan settings on the Chittor - Cuddalore national highway, providing a holistic environment, ideal for dedicated study with discipline, away from the hustle and bustle of the modern cities...</p>
	</div>

	<div class="city">

	<form name="myForm" method="post" action="loginServlet" onsubmit="return validateForm()">
	<center><div class="imgcontainer">
	<img src="http://www.iconskid.com/images/3/login-iconpng-3068.png" height="100" width="100">
	</div></center>


	<center><h1 style="color:blue;"><b>AdminLogin</b></h1></center>
	<center><div class="container">
	<label><b>Username </b></label>
	<input type="text" name="uname" >
	</div>

	<div class="container">
	<label><b>Password </b></label>
	<input type="password" name="psw" >
	</div>
	<div class="container">
	<button type="submit">Login</button>
	</div></center>

	<div class="container" style="background-color:#f1f1f1">
	<a href="signup.jsp"> <button type="button" class="cancelbtn">signup</button></a>
	<span class="psw">Forgot <a href="signup.jsp">password?</a></span>
	</div>
	</form>
	</div>

	</body>
	</html>


	import java.io.IOException;
	import java.io.PrintWriter;
	import java.sql.Connection;
	import java.sql.DriverManager;
	import java.sql.PreparedStatement;
	import java.sql.ResultSet;
	import java.text.BreakIterator;
	import java.util.Date;

	import javax.servlet.RequestDispatcher;
	import javax.servlet.ServletException;
	import javax.servlet.annotation.WebServlet;
	import javax.servlet.http.HttpServlet;
	import javax.servlet.http.HttpServletRequest;
	import javax.servlet.http.HttpServletResponse;
	import javax.servlet.http.HttpSession;

	/**
	* Servlet implementation class loginServlet
	*/
	@WebServlet("/loginServlet")
	public class loginServlet extends HttpServlet {
	private static final long serialVersionUID = 1L;





	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
	// TODO Auto-generated method stub
	response.setContentType("text/html;charset=UTF-8");
	PrintWriter out = response.getWriter();

	String name = request.getParameter("uname");

	String pass = request.getParameter("psw");


	try{

	//loading drivers for mysql
	Class.forName("com.mysql.jdbc.Driver");

	//creating connection with the database
	Connection con=DriverManager.getConnection
	("jdbc:mysql://localhost:3306/kumaresanlogin","root","root");

	PreparedStatement ps=con.prepareStatement("select username, password from kumaresanlogin.signup where username =? and password=?");

	ps.setString(1, name);

	ps.setString(2, pass);
	ResultSet rs=ps.executeQuery();

	if(rs.next()==true)
	{
	out.println("You are sucessfully loggedin");
	HttpSession session=request.getSession();
	session.setAttribute("student","true");
	request.getRequestDispatcher("student.jsp").include(request, response);

	}
	else{
	out.println("user name(or) password is incorrect");


	request.getRequestDispatcher("signup.jsp").include(request, response);


	}
	con.close();
	ps.close();
	rs.close();
	}
	catch(Exception se)
	{
	se.printStackTrace();
	}
	}
	}
	import java.awt.image.BufferedImage;
	import java.io.File;
	import java.io.FileNotFoundException;
	import java.io.FileOutputStream;
	import java.io.IOException;
	import java.io.InputStream;
	import java.io.PrintWriter;
	import java.sql.Connection;
	import java.sql.DriverManager;
	import java.sql.ResultSet;
	import java.sql.Statement;
	import java.util.Date;
	import javax.imageio.ImageIO;
	import javax.servlet.ServletException;
	import javax.servlet.annotation.MultipartConfig;
	import javax.servlet.annotation.WebServlet;
	import javax.servlet.http.HttpServlet;
	import javax.servlet.http.HttpServletRequest;
	import javax.servlet.http.HttpServletResponse;
	import com.lowagie.text.Document;
	import com.lowagie.text.DocumentException;
	import com.lowagie.text.Image;
	import com.lowagie.text.Paragraph;
	import com.lowagie.text.Phrase;
	import com.lowagie.text.pdf.PdfPCell;
	import com.lowagie.text.pdf.PdfPTable;
	import com.lowagie.text.pdf.PdfWriter;

	/**
	* Servlet implementation class PdfServlet
	*/
	@WebServlet("/PdfServlet")
	@MultipartConfig(maxFileSize = 16177215)
	public class PdfServlet extends HttpServlet {
	private static final long serialVersionUID = 388110564278942780L;

	protected void doPost(HttpServletRequest request,
	HttpServletResponse response) throws ServletException, IOException {
	response.setContentType("text/html;charset=UTF-8");
	try {
	Class.forName("com.mysql.jdbc.Driver");
	Connection conn = DriverManager.getConnection(
	"jdbc:mysql://localhost:3306/kumaresanlogin", "root",
	"root");
	Statement stmt = conn.createStatement();
	/* Define the SQL query */
	ResultSet set = stmt
	.executeQuery("SELECT * from kumaresanlogin.student");
	Document document = new Document();

	PdfWriter writer = PdfWriter
	.getInstance(
	document,
	new FileOutputStream(
	"C:\\Users\\i00588\\Desktop\\vairavan\\WebContent\\GeneratedResults\\HelloWorld.pdf"));
	document.open();

	PdfPTable firsttable = new PdfPTable(8);
	PdfPCell table_cell;
	// Add table column Names
	firsttable.addCell("NAME");
	firsttable.addCell("AGE");
	firsttable.addCell("ADDRESS");
	firsttable.addCell("PHONE NUMBER");
	firsttable.addCell("EMAIL ID");
	firsttable.addCell("STUDETN NUMBER");
	firsttable.addCell("GENDER");
	firsttable.addCell("IMAGE");

	while (set.next()) {
	String name = set.getString("name");
	table_cell = new PdfPCell(new Phrase(name));
	firsttable.addCell(table_cell);

	String age = set.getString("age");
	table_cell = new PdfPCell(new Phrase(age));
	firsttable.addCell(table_cell);

	String address = set.getString("address");
	table_cell = new PdfPCell(new Phrase(address));
	firsttable.addCell(table_cell);

	String phone_no = set.getString("phone number");
	table_cell = new PdfPCell(new Phrase(phone_no));
	firsttable.addCell(table_cell);

	String emailId = set.getString("emailId");
	table_cell = new PdfPCell(new Phrase(emailId));
	firsttable.addCell(table_cell);

	String student_no = set.getString("student no");
	table_cell = new PdfPCell(new Phrase(student_no));
	firsttable.addCell(table_cell);

	String gender = set.getString("gender");
	table_cell = new PdfPCell(new Phrase(gender));
	firsttable.addCell(table_cell);

	// adding image to pdf
	java.sql.Blob blob = set.getBlob("image");
	InputStream in = blob.getBinaryStream();
	BufferedImage image = ImageIO.read(in);

	java.awt.Image awtImage = image;
	com.lowagie.text.Image img1 = com.lowagie.text.Image
	.getInstance(awtImage, null);

	Image image1 = Image.getInstance(img1);// extra line just for verification
	image1.scaleAbsolute(50, 50);
	firsttable.addCell(image1);
	//document.add(image1);

	}

	document.add(firsttable);

	document.add(new Paragraph(new Date().toString()));
	PrintWriter our = response.getWriter();
	if ((new File(
	"C:\\Users\\i00588\\Desktop\\vairavan\\WebContent\\GeneratedResults\\HelloWorld.pdf"))
	.exists()) {

	Process p = Runtime
	.getRuntime()
	.exec("rundll32 url.dll,FileProtocolHandler C:\\Users\\i00588\\Desktop\\vairavan\\WebContent\\GeneratedResults\\HelloWorld.pdf");

	p.waitFor();
	our.println("pdf File genertated");
	request.getRequestDispatcher("student.jsp").include(request,
	response);
	response.setHeader("Cache-Control", "no-cache, no-store, must-revalidate"); // HTTP 1.1.
	response.addHeader("Cache-Control", "post-check=0, pre-check=0");
	response.setHeader("Pragma", "no-cache"); // HTTP 1.0.
	response.setDateHeader("Expires", 0);


	} else {

	// System.out.println("File is not exists");
	our.println("File is not exists");
	request.getRequestDispatcher("student.jsp").include(request,
	response);
	response.setHeader("Cache-Control", "no-cache, no-store, must-revalidate"); // HTTP 1.1.
	response.addHeader("Cache-Control", "post-check=0, pre-check=0");
	response.setHeader("Pragma", "no-cache"); // HTTP 1.0.
	response.setDateHeader("Expires", 0);


	}

	document.close();
	writer.close();

	} catch (DocumentException e) {
	e.printStackTrace();
	} catch (FileNotFoundException e) {
	e.printStackTrace();
	} catch (Exception e) {

	e.printStackTrace();
	}

	}

	}
	<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
	pageEncoding="ISO-8859-1"%>
	<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
	<html>
	<head>
	<META HTTP-EQUIV="Pragma" CONTENT="no-cache">
	<META HTTP-EQUIV="Expires" CONTENT="-1">
	<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
	<title>PDF GENERATOR</title>
	<link href="login.css" rel="stylesheet" type="text/css">
	</head>
	<body bgcolor=#6B8E23>
	<form name="myForm1" method="post" action="PdfServlet" >
	<center>
	<div class="clearfix">
	<button type="submit">Pdf</button>
	</div>
	</center>
	<p><h3>This PDF page and Pdf button one and only for generationg pdf file.</h3></p>
	<p><b><u>copy rights </u></b></p>
	<p><b>www.kumaresanramu.in</b></p>

	</form>
	</body>
	</html>
	<?xml version="1.0" encoding="UTF-8"?>
	<web-app id="WebApp_ID" version="3.0"
	xmlns="http://java.sun.com/xml/ns/javaee"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd">
	<display-name>vairavan</display-name>
	<welcome-file-list>
	<welcome-file>/login.jsp</welcome-file>
	</welcome-file-list>
	<servlet>
	<servlet-name>loginServlet</servlet-name>
	<servlet-class>loginServlet</servlet-class>
	</servlet>
	<servlet>
	<servlet-name>SignupServlet</servlet-name>
	<servlet-class>SignupServlet</servlet-class>
	</servlet>
	<servlet-mapping>
	<servlet-name>loginServlet</servlet-name>
	<url-pattern>/loginServlet</url-pattern>
	</servlet-mapping>
	<servlet-mapping>
	<servlet-name>SignupServlet</servlet-name>
	<url-pattern>/SignupServlet</url-pattern>
	</servlet-mapping>
	</web-app>