Untitled

1.Program to accept the text from text box and change the color of the text and
background

Html file (first.html)


<!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>Insert title here</title>
</head>
<body>
<form action="second" method="get">
enter the font color name:<input type="text" name="font" ><br>
enter the back ground color name<input type="text" name="bg" ><br>
<input type="submit">
</form>
</body>
</html>


Java file(second.java)


mport java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class second extends javax.servlet.http.HttpServlet {
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
// TODO Auto-generated method stub
String co=request.getParameter("font");
String co1=request.getParameter("bg");
PrintWriter out=response.getWriter();
out.println("<html><head><title>My First</title></head><body><font
size=\"12px\"color=\""+co+"\">National College, Jayanagar<br></font></body></html>");
out.println("<html><head><body bgcolor="+co1+"></body></head></html>");
}
}


Web xml file

<?xml version="1.0" encoding="UTF-8"?>
<web-app id="WebApp_ID" version="2.4" xmlns="http://java.sun.com/xml/ns/j2ee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee
http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">
<display-name>
Prog1</display-name>
<servlet>
<description>
</description>
<display-name>
second</display-name>
<servlet-name>second</servlet-name>
<servlet-class>
second</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>second</servlet-name>
<url-pattern>/second</url-pattern>
</servlet-mapping>
<welcome-file-list>
<welcome-file>first.html</welcome-file>
</welcome-file-list>
</web-app>


2..Program to display the usage of get and post method in the same servlet


Java file-servlet(getpost.java)

import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class Getpost extends HttpServlet{
protected void doGet(HttpServletRequest req, HttpServletResponse res) throws
ServletException, IOException {
res.setContentType("text/html");
PrintWriter out=res.getWriter();
out.println("<html><head><title>getpost</title></head><body>");
out.println("the servlet has recieved a get."+"now click the button below");
out.println("<br>");
out.println("<form method=post>");
out.println("<input type=submit value=SUBMIT>");
out.println("</form></body></html>");
}
protected void doPost(HttpServletRequest req, HttpServletResponse res) throws
ServletException, IOException {
res.setContentType("text/html");
PrintWriter out=res.getWriter();
out.println("<html><head><title></title></head><body>");
out.println("the servlet has received a post.</body></html>");
}
}

3.Program to check for username and password


Html file(login.html)


<!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>Insert title here</title>
</head>
<body>
<form action="Login" method="get">
USER NAME:<input type="text" name="username"><br>
PASSWORD:<input type="password" name="password"><br>
<input type="submit" name="submit" value="SUBMIT">
</form>
</body>
</html>


Java file- servlet(Login.html)


import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.ServletRequest;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class Login extends HttpServlet
{
protected void doGet(HttpServletRequest req, HttpServletResponse res) throws
ServletException, IOException
{
res.setContentType("text/html");
PrintWriter out=res.getWriter();
String un = req.getParameter("username");
String pa = req.getParameter("password");
if(un!=null&&pa!=null&&un.equals("admin")&&pa.equals("123"))
{
out.println("LOGIN SUCCESSFULL");
}
else
{
out.println("LOGIN FAILED");
}
}
}


Xml file
<?xml version="1.0" encoding="UTF-8"?>
<web-app id="WebApp_ID" version="2.4" xmlns="http://java.sun.com/xml/ns/j2ee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee
http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">
<servlet>
<servlet-name>Login</servlet-name>
<servlet-class> Login</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>Login</servlet-name>
<url-pattern>/Login</url-pattern>
</servlet-mapping>
<welcome-file-list>
<welcome-file>login.html</welcome-file>
</welcome-file-list>
</web-app>


4.Hobbies

application.html


<!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>Insert title here</title>
</head>
<body>
<center>
<form action="StudentD" method="get">
<table>
<tr>
<td>name:</td>
<td><input type="text" name="uname"></td>
</tr>
<tr>
<td>age:</td>
<td><input type="text" name="dob"></td>
</tr>
<tr>
<td>gender:</td>
<td><input type= "radio" name="gender" value="male"> male</td>
<td><input type="radio" name="gender" value="female">female</td>

</tr>
<tr>
<td>Hobbies:</td></tr>
<tr><td></td><td><input type="checkbox" name="hobbies" value="dance">dance</td></tr>
<tr><td></td><td><input type="checkbox" name="hobbies" value="singing">singing</td></tr>
<tr><td></td><td><input type="checkbox" name="hobbies" value="drawing">drawing</td></tr>
<tr><td></td><td><input type="checkbox" name="hobbies" value="photography">photography</td></tr>
<tr>
<td><input type="submit" value="submit"></td>
<td><input type="reset" value="reset"></td></tr>
</table>
</form>
</center>
</body>
</html>


studentd.java


import java.io.IOException;
import java.io.PrintWriter;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;


 public class StudentD extends HttpServlet
 {
   static final long serialVersionUID = 1L;


	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		PrintWriter out=response.getWriter();
		String na=request.getParameter("uname");
		String gen=request.getParameter("gender");
		String dob=request.getParameter("dob");
		String[] hob=request.getParameterValues("hobbies");

		out.println("<html>");
		out.println("<body><center><font style= cooper size= 14px>");
		out.println("application form details<br>");
		out.println("name:"+na+"<br>");
		out.println("age:"+dob+"<br>");
		out.println("gender:"+gen+"<br>");
		out.println("selected hobbies are:<br>");
		if(hob!=null)
		{
			int len = hob.length;
			for(int i=0;i<len;i++)
			{
				out.println(hob[i]+"<br>");
			}

		}
		out.println("</font></center></body></html>");

	}
}

5.Include & frwd


index.html


<html>
<head>
<title> inlcude and Forward Demo </title>
</head>
<body>
<center>
<h1> INCLUDE AND FORWARD DEMO </h1>
</center>
<b> Please Enter the Mode Of Operation
<form action="Demo">
<p>
<p><input type="text" name ="mode" length=40>
<input type="submit" value="submit">
<input type="reset" value="clear">
</form>
</body>
</html>


 WEB.xml
	<servlet>
		 		<servlet-name>Demo</servlet-name>
		<servlet-class>
		com.ex.Demo</servlet-class>
	</servlet>
	<servlet>
		 <servlet-name>ForwardDemo</servlet-name>
		<servlet-class>
		com.ex.ForwardDemo</servlet-class>
	</servlet>
	<servlet>
		<servlet-name>IncludeDemo</servlet-name>
		<servlet-class>
		com.ex.IncludeDemo</servlet-class>
	</servlet>
	<servlet-mapping>
		<servlet-name>Demo</servlet-name>
		<url-pattern>/Demo</url-pattern>
	</servlet-mapping>
	<servlet-mapping>
		<servlet-name>ForwardDemo</servlet-name>
		<url-pattern>/ForwardDemo</url-pattern>
	</servlet-mapping>
	<servlet-mapping>
		<servlet-name>IncludeDemo</servlet-name>
		<url-pattern>/IncludeDemo</url-pattern>
	</servlet-mapping>
	<welcome-file-list>

		<welcome-file>Demo.html</welcome-file>
	</welcome-file-list>
</web-app>


Demo.java:

package com.ex;

import java.io.IOException;
import java.io.PrintWriter;

import javax.servlet.ServletException;
import javax.servlet.http.*;
import javax.servlet.*;
public class Demo extends HttpServlet
{
public void doGet(HttpServletRequest req,HttpServletResponse res) throws IOException, ServletException
{
String mode=req.getParameter("mode");
try {
res.setContentType("text/html");
PrintWriter out=res.getWriter();
RequestDispatcher rd=null;
if(mode.equals("forward"))
{
req.setAttribute("mode","Forward Response.....");
rd=req.getRequestDispatcher("ForwardDemo");
rd.forward(req,res);
}
else if(mode.equals("include"))
{
req.setAttribute("mode","Include Respone....");
out.println("<html>");
out.println("<head>");
out.println("<title> Include Demo </title>");
out.println("</head>");
out.println("<body>");
out.println("<h1> Hello Form Level </h1>");
out.println("This text is displayed at Level 1");
rd=req.getRequestDispatcher("IncludeDemo");
rd.include(req,res);
out.println("</body>");
out.println("</html>");
out.close();
}
else
{
out.println("<h1> Enter Incude or Forward </h1>");
out.close();
}
}
catch(Exception e) { e.printStackTrace();
}
}
}


ForwardDemo.java

package com.ex;
import java.io.PrintWriter;

import javax.servlet.http.*;
import javax.servlet.*;
public class ForwardDemo extends HttpServlet
{
public void doGet(HttpServletRequest req,HttpServletResponse res)
{
try{
res.setContentType("text/html");
PrintWriter writer=res.getWriter();
String mode=(String)req.getAttribute("mode");
writer.println("This is another doGet");
writer.close();
}
catch(Exception e)
{
}
}
}


IncludeDemo.java:

package com.ex;
import javax.servlet.http.*;
import java.io.*;
public class IncludeDemo extends HttpServlet
{
public void doGet(HttpServletRequest request,HttpServletResponse response)
{
try
{
response.setContentType("text/html");
PrintWriter writer=response.getWriter();
String mode=(String)request.getAttribute("mode");
writer.println("<br><b>This is another text of "+mode);
writer.close();
} catch(Exception e){
e.printStackTrace();
}
}
}


6. Student into DB


InsertServ.java:

 public class InsertServ extends HttpServlet
{
       protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
       {
		String regno = request.getParameter("regno");
		String name = request.getParameter("name");
		String stuclass = request.getParameter("stuclass");
		String age = request.getParameter("age");
		String gender = request.getParameter("gender");
		PrintWriter out = response.getWriter();
		try
                 {
	Class.forName("com.mysql.jdbc.Driver");

Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/Student", "root", "");

	   Statement stmt = conn.createStatement();

  int a = stmt.executeUpdate("insert into stud values('"+regno+"','"+name+"','"+stuclass+"','"+age+"','"+gender+"')");
out.println(“value inserted”);
}
Catch(Exception e)
{
}

}
}


InsertDB.html:


<html>
<body>
<form action="InsertServ" method="post">
<center><h1>STUDENT INFO</h1><br></center>
<center>
<table border="1">
<tr>
<td>REG_NO:</td>
<td><input type="Text" name="regno"></td>
</tr>
<tr>
<td>NAME:</td>
<td><input type="Text" name="name"></td>
</tr>
<tr>
<td>CLASS:</td>
<td><input type="Text" name="stuclass"></td>
</tr>
<tr>
<td>AGE:</td>
<td><input type="Text" name="age"></td>
</tr>
<tr>
<td>GENDER:</td>
<td><input type="Text" name="gender"></td>
</tr>
<tr>
<td></td><td><input type="Submit" value="submit" ></td>
</tr>
</table>
</center>
</form>
</body>
</html>

7.Student from DB


SelHtml.html:

<html>
<body>
<form action="SelServ" method="post">
<center><h1>STUDENT INFO</h1><br></center>
<center>
<table border="1">
<tr>
<td>REG_NO:</td>
<td><input type="Text" name="regno"></td>
</tr>

<tr>
<td></td><td><input type="Submit" value="Display" ></td>
</tr>
</table>
</center>
</form>
</body>
</html>


SelServ.java:


package com.ex;

import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;


public class SelServ extends HttpServlet
{
       protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
       {
		String s = request.getParameter("regno");

		PrintWriter out = response.getWriter();
		try
                 {
		       Class.forName("com.mysql.jdbc.Driver");
		       Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/Student", "root", "");
	                      Statement stmt = conn.createStatement();


		       ResultSet rs = stmt.executeQuery("Select * from stud where regno='"+s+"'");

		       out.println("<html><body  ><center><h2>STUDENT INFO</h1></center>");

				out.println("<table align=center border=1    >");
				out.println("<tr  >");
				out.println("<th>  StudentID</font></th>");
				out.println("<th> StudentName</font></th>");
				out.println("<th> Class</font></th>");
				out.println("<th> Age</font></th>");
				out.println("<th> Gender</font></th>");
				out.println("</tr>");


		while (rs.next())
		{
		   out.println("<tr bgcolor=ivory>");
	       	   out.println("<td>" + rs.getString(1) + "</td>");
		   out.println("<td>" + rs.getString(2) + "</td>");
	 	   out.println("<td>" + rs.getString(3) + "</td>");
            out.println("<td>" + rs.getString(4) + "</td>");
            out.println("<td>" + rs.getString(5) + "</td>");
 	         out.println("</tr>"); }
	           out.println("</table><br>");
	          out.println("</body></html>");

		 }
		  catch (Exception e)
		  {
			System.out.println(e);
		  }

	}
}

8.Cookies

html


<!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>Insert title here</title>
</head>
<body>
<form action="CookieDemo" method="get">
NAME:<input type="text" name="name">
<input type="submit" value="ok">
</form>
</body>
</html>

cookiedemo.java

import java.io.IOException;
import java.io.PrintWriter;

import javax.servlet.ServletException;
import javax.servlet.http.Cookie;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;


 public class CookieDemo extends HttpServlet  {
   static final long serialVersionUID = 1L;


	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		response.setContentType("text/html");
		PrintWriter o=response.getWriter();
		String n=request.getParameter("name");
		o.println("<h2>welcome "+n+"</h2>");
		Cookie ex=new Cookie("name",n);
		response.addCookie(ex);
		o.println("<form action=Second method=post>");
		o.println("<input type=submit value=ok>");
		o.println("</form>");
	}
}

second.java


import java.io.IOException;
import java.io.PrintWriter;

import javax.servlet.ServletException;
import javax.servlet.http.Cookie;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;


 public class Second extends HttpServlet {
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		try{
			response.setContentType("text/html");
			PrintWriter out= response.getWriter();
			Cookie ck[]=request.getCookies();
			out.println("<h1>Hello "+ck[0].getValue()+"</h1>");


		}
		catch(Exception e)
		{
			System.out.println(e);
		}
	}

}
9.Sessions

login.html


<!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>Insert title here</title>
</head>
<body>
<form action="Session1" method="get">
<center>
<table>

<tr></tr>
<tr>
<td>NAME</td>
<td><input type="text" name="name"></td>
</tr>
<tr></tr>
<tr>
<td>PASSWORD</td>
<td><input type="password" name="pass"></td>
</tr>
<tr>
<td></td>
<td><input type="submit" value="submit"></td>
</tr>
</table>
</center>
</form>
</body>
</html>


login.java


import java.io.IOException;
import java.io.PrintWriter;


 public class Session1 extends HttpServlet  {

	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		PrintWriter out=response.getWriter();
		response.setContentType("text/html");
		String un=request.getParameter("name");
		String pass=request.getParameter("pass");
		if(un.equals("computer"))
		{
			out.println("welcome"+un);
			HttpSession s=request.getSession(true);
			s.setAttribute("user", un);
			s.setMaxInactiveInterval(5);
			response.sendRedirect("Home");
		}
		else{
			RequestDispatcher rd=request.getRequestDispatcher("Login.html");
			out.println("<font color=red>");
			rd.include(request,response);

		}
	}
}


home serv.java

import java.io.IOException;
import java.io.PrintWriter;


 public class Home extends HttpServlet  {


	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		PrintWriter out=response.getWriter();
		response.setContentType("text/html");
		out.println("keep the page idel for 5 seconds after that if reloaded it will redirect to login page");
		HttpSession s=request.getSession(true);
		if(s!=null)
		{
			 if(s.getAttribute("user")!=null)
			 {
				 String n=(String)s.getAttribute("user");
				 out.println("Hello" +n);

			 }
			 else
			 {
				 response.sendRedirect("Login.html");

			 }
		}
		out.println("<form action=Logout method=get>");
		out.println("<input type=submit value=Logout>");

	}
}


logout.java

import java.io.IOException;
import java.io.PrintWriter;
 public class Logout extends HttpServlet
 {
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
	{
		PrintWriter out=response.getWriter();
		out.println("Thank you!! your session is destroyed");
		HttpSession s=request.getSession(false);
		s.removeAttribute("user");
	}
}

10.Request object


INDEX.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>Insert title here</title>
</head>
<body>
<form action="Port" method="post">
<h1>WELCOME</h1><br>
<label><font size="6" >ENTER PARAMETER NAME:</font></label>
<input type =text name=text><br>
<input type=submit value=submit>
</form>
</body>
</html>


PORT.java


import java.io.IOException;
import java.io.PrintWriter;
import java.util.Enumeration;

 public class Port extends HttpServlet  {

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

		PrintWriter out=response.getWriter();
		out.println("<html><body><font size=5>");
		out.println("<br>server port:"+request.getServerPort());
		out.println("<br>server name:"+request.getServerName());
		out.println("<br>protocol:"+request.getProtocol());
		out.println("<br> charecter encoding:"+request.getCharacterEncoding());
		out.println("<br>content type:"+request.getContentType());
		out.println("<br>remote address:"+request.getRemoteAddr());
		out.println("<br>remote host"+request.getRemoteHost());
		out.println("<br>scheme:"+request.getScheme());
		out.println("</font></body></html>");
		Enumeration Param=request.getParameterNames();
		String paramname=(String)Param.nextElement();
		out.println("<html><body><font size=5>");
		out.println("<br>parameter name:"+paramname);
		out.println("<br>parameter value:"+request.getParameter(paramname));
		out.println("</font></body></html>");


11.Timedate


<%@ 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">


<%@page import="java.util.Calendar"%>
<%@page import="java.util.Date"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Insert title here</title>
</head>
<body>
<font size="6">
Welcome..The server time is now..
<%@page import="java.util.* "%>
<%@page import="java.text.SimpleDateFormat" %>
 <%
 Calendar now=Calendar.getInstance();
    int hour=now.get(Calendar.HOUR_OF_DAY);
   int minute=now.get(Calendar.MINUTE);
   int second=now.get(Calendar.SECOND);
   if(hour<10)
   out.println("0"+hour);
   else
    out.println(hour);
    out.print(":");
    if(minute<10)
    out.println("0"+minute);
    else
    out.println(minute);
    out.print(":");
    if(second<10)
    out.print("0"+second);
    else
    out.print(second);
    %>
      <br>The current date is
      <%SimpleDateFormat ff=new SimpleDateFormat("YYY/MM/DD");
      Date n=new Date();

      out.println("="+ff.format(n));%>

</body>
</html>


12.Implicit

implict.java


<%@ 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">

<%@page import="java.util.Date;"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Insert title here</title>
</head>
<body>
<b>current date and time is :</b><%out.print(new Date()); %><br><br>
<b>request user_agent:</b><%=request.getHeader("user-agent") %><br><br>
<% response.addCookie(new Cookie("test","ncj")); %>
<b>user init param value:</b><%=config.getInitParameter("user") %><br><br>
<b>user context param value:</b><%=application.getInitParameter("user") %>
<br><br>
<b>user session id:</b><%=session.getId() %>
<br><br>
<%
pageContext.setAttribute("test","jayanagar");%>

<b>page context attribute</b>

{name="test",value="<%=pageContext.getAttribute("test")  %>"}

<b>Generated Servlet name:</b>
<%=page.getClass().getName()%>

</body>

<?xml version="1.0" encoding="UTF-8"?>
<web-app id="WebApp_ID" version="2.4" xmlns="http://java.sun.com/xml/ns/j2ee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">
	<display-name>
	pro4</display-name>
	<context-param>
  <param-name>user</param-name>
  <param-value>national college</param-value>
  </context-param>
	<welcome-file-list>
		<welcome-file>imp.jsp</welcome-file>
	</welcome-file-list>
</web-app>

</html>


13..Add & delete

add.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">
<%@page import="java.sql.*"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Insert title here</title>
</head>
<body>
<h1 align="center">
<u> ADD AND REMOVE RECORD FROM DB</u></h1>
<hr size="4" color=blue>
<center>
<form action="Delete" method="get"><br><br>
<h2>enter name:&nbsp;</h2>
<input type=text name=name1><br><br>
<input type="submit" value="Add">
</form>

<form action="Delete" method="post">
<h2> select an item and click remove:<br></h2><br>
<select style ="width:200px" name="list1" multiple="multiple">
<% Class.forName("com.mysql.jdbc.Driver");
Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/stud","root","");
Statement s=con.createStatement();
ResultSet rs=s.executeQuery("select name from addstd");
if(rs!=null)
	while(rs.next())
	{
		out.println("<option>"+rs.getString(1)+"</option>");
	}
	%>
</select>
<br><br>
<input type="submit" value="remove">
</form>
</center>
</body>
</html>


Delete.java


import java.io.IOException;
import java.io.PrintWriter;

import java.sql.*;

 public class Delete extends HttpServlet  {
   static final long serialVersionUID = 1L;


	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		PrintWriter out=response.getWriter();
		String name=request.getParameter("name1");
		try{

			Class.forName("com.mysql.jdbc.Driver");
            Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/stud","root","");
            Statement s=con.createStatement();
            int n=s.executeUpdate("insert into addstd values('"+name+"')");
            response.sendRedirect("Add.jsp");

		}
		catch(Exception e)
		{
		System.out.println(e);
		}

	}


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

		String[] list1 =request.getParameterValues("list1");
		try
		{
			Class.forName("com.mysql.jdbc.Driver");
			Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/stud","root","");
		Statement s=con.createStatement();
		String qry;
		for(int i=0;i<list1.length;i++)
		{
			int s2=s.executeUpdate("delete from addstd where name='"+list1[i]+"'");

		}
		response.sendRedirect("Add.jsp");

		}
		catch(Exception e){
			System.out.println(e);
		}
	}
}


14.Bank

Login.html


<html>
 <body>
<form action="Bank.jsp" method="post">
<center><h1>Customer Login</h1><br></center>
<center>
<table border="1">
<tr>
<td>Name:</td>
<td><input type="text" name="nam"></td>
</tr>

<tr>
<td>AccNumber:</td>
<td><input type="text" name="accno"></td>
</tr>
<tr>
<td>Password:</td>
<td><input type="text" name="pass"></td>
</tr>
<tr>
<td>Amount:</td>
<td><input type="text" name="amt"></td>
</tr>
<tr>

<td><input type="radio" name="trans" value="deposit">Deposit</td>
</tr>
<tr>

<td><input type="radio" name="trans" value="withdraw">Withdraw</td>
</tr>


<tr>
<td></td><td><input type="Submit" value="DONE" ></td>
</tr>
</table>
</center>
</form>
</body>
</html>

Bank.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>
<body>
<%@ page import="java.sql.*" %>
<% String acc = request.getParameter("accno");

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

	 try
    {
	Class.forName("com.mysql.jdbc.Driver");
Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/JSP", "root", "");
 Statement stmt = conn.createStatement();

ResultSet rs = stmt.executeQuery("Select * from bank where accno='"+acc+"'");
if(rs.next())
{
if(pass.equals(rs.getString("pass")))
{
int amt=Integer.parseInt(request.getParameter("amt"));

String tr=request.getParameter("trans");

if(tr.equals("deposit"))
{

	   int dbal= Integer.parseInt(rs.getString("balance"));
	   dbal=dbal+amt;

 stmt.executeUpdate("update BANK set balance='"+dbal+"'");
		out.println("Amount Deposited");
	}

if(tr.equals("withdraw"))
{

	int dbal=Integer.parseInt(rs.getString("balance"));
	dbal=dbal-amt;
	 stmt.executeUpdate("update BANK set balance='"+dbal+"'");

	out.println("Amount Withdrawn successfully");
	out.println("available balance is="+dbal);
}
}
else
{
	out.println("password not match");
}

}
}
	 catch(Exception e)
	 {
		 out.println("erro is "+e);
	 }
	%>

</body>
</html>

.