<%--
Document : index
Created on : Mar 22, 2021, 12:25:31 PM
Author : VIKRAM
Create a Telephone directory using JSP and store all the information within a database, so that later could be retrieved as per the requirement. Make your own assumptions.
--%>
<%@page contentType=“text/html” pageEncoding=“UTF-8”%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv=“Content-Type” content=“text/html; charset=UTF-8”>
<title>Practical 6-1</title>
</head>
<body>
<form action=“Process.jsp”>
<table align=“center”>
<tr align=“center”>
<td style=“color:red;padding:10px”>${param.message}</td>
</tr>
</table>
<table border=“1” align=“center” cellpadding=“10px”>
<thead>
<th colspan=“2” style=“background-color: yellow; padding: 10px”>Telephone-Entry-
Form</th>
</tr>
</thead>
<tbody>
<tr>
<td>Name</td>
<td><input type=“text” name=“txtName” value=““ /></td>
</tr>
<tr>
<td>Telephone Number</td>
<td><input type=“text” name=“txtTel” value=““ /></td>
</tr>
<tr>
<td><input type=“submit” value=“Add Entry” /></td>
<td><input type=“reset” value=“Reset” /></td>
</tr>
</tbody>
</table>
</form>
</body>
</html>
<%--
Document : Process
Created on : Mar 22, 2021, 11:07:53 AM
Author : VIKRAM
--%>
<%@page import=“java.sql.ResultSet”%>
<%@page import=“java.sql.SQLException”%>
<%@page import=“java.sql.DriverManager”%>
<%@page import=“java.sql.Statement”%>
<%@page import=“java.sql.PreparedStatement”%>
<%@page import=“java.sql.Connection”%>
<%@page contentType=“text/html” pageEncoding=“UTF-8”%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv=“Content-Type” content=“text/html; charset=UTF-8”>
<title>Process</title>
</head>
<%
String url=“jdbc:mysql://localhost:3306/studentdb?zeroDateTimeBehavior=convertToNull”; String user=“root”;
String password=““;
String uname=request.getParameter(“txtName”); String tel=request.getParameter(“txtTel”); Connection conn;
PreparedStatement ps; Statement st;
ResultSet rs;
// connection Initialization Class.forName(“com.mysql.jdbc.Driver”); conn=DriverManager.getConnection(url, user, password);
try
{
//checking the record already exist in database or not st=conn.createStatement();
rs=st.executeQuery(“select * from teldir”); while(rs.next())
{
if(rs.getString(2).equals(uname)&& rs.getString(3).equals(tel))
{%>
<jsp:forward page=“index.jsp”>
<jsp:param name=“message” value=“User is already exits, Give New Entry !!!” />
</jsp:forward>
<%
}
}
//inserting record in database
String sql=“insert into teldir(name,telephone) values(?,?)”; ps=conn.prepareStatement(sql);
ps.setString(1,uname); ps.setString(2,tel); ps.executeUpdate();
conn.close();
out.println(“<h3 align=‘center’>“); out.println(“Record inserted successfully”); out.println(“</h3>“);
out.println(“<h3 align=‘center’>“);
out.println(“Click “+”<a href=‘index.jsp’>here</a>“+”to Enter another record”); out.println(“</h3>“);
}
catch(SQLException e)
{
e.printStackTrace();
}
%>
</body>
</html>
Index.jsp
<%--
Document : index
Created on : Mar 19, 2021, 12:54:11 PM Author : VIKRAM
Write a JSP page to display the Registration form
--%>
<%@page contentType=“text/html” pageEncoding=“UTF-8”%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv=“Content-Type” content=“text/html; charset=UTF-8”>
<title>Registration Form </title>
<link rel=“stylesheet” href=“https://code.jquery.com/ui/1.12.1/themes/base/jquery-ui.css”>
<script src=“https://code.jquery.com/jquery-1.12.4.js”></script>
<script src=“https://code.jquery.com/ui/1.12.1/jquery-ui.js”></script>
<script>
$(function() {
$.datepicker.setDefaults({onClose:function(date, inst){
$(“#selectedDtaeVal”).html(date);
}
});
$(“#datepicker”).datepicker();});
</script>
</head>
<body>
<form action=“process.jsp”>
<table border=“1” cellpadding=“10px” align=“center”>
<thead>
<tr>
<th colspan=“2” style=“background-color: yellow” padding=“10px”>Registration Form</th>
</tr>
</thead>
<tr>
<td>Full Name</td>
<td><input type=“text” name=“txtName” value=““ /></td>
</tr>
<tr>
<td>Email</td>
<td><input type=“text” name=“txtEmail” value=““ /></td>
</tr>
<tr>
<td>Date of Birth</td>
<td><input type=“text” name=“txtbdate” id=“datepicker”></td>
</tr>
<tr>
<td>Educational Qualification</td>
<td><select name=“opt-qualify”>
<option>HSC</option>
<option>Diploma</option>
<option>Graduate</option>
<option>Post-Graduate</option>
</select></td>
</tr>
<tr>
<td>Languages Known</td>
<td><input type=“checkbox” name=“lk” value=“English”/>English
<input type=“checkbox” name=“lk” value=“Marathi” />Marathi
<input type=“checkbox” name=“lk” value=“Hindi” />Hindi
</td>
<tr>
<td valign=“top”>Write about yourself</td>
<td><textarea name=“about” rows=“8” cols=“30” >
</textarea></td>
</tr>
<tr>
<td>Gender </td>
<td><input type=“radio” name=“gen” value=“Male” />Male
<input type=“radio” name=“gen” value=“Female” />Female
<input type=“radio” name=“gen” value=“Tgen” />Tgen</td>
</tr>
<tr>
<td><input type=“submit” value=“Submit” /></td>
<td><input type=“reset” value=“Reset” /></td>
</tr>
</tbody>
</table>
</form>
</body>
</html>
process.jsp
<%--
Document : process
Created on : Mar 19, 2021, 2:16:48 PM Author : VIKRAM
--%>
<%@page import=“java.util.Arrays”%>
<%@page import=“java.util.List”%>
<%@page contentType=“text/html” pageEncoding=“UTF-8”%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv=“Content-Type” content=“text/html; charset=UTF-8”>
<title>Practical6-2</title>
<body>
<h1>You are successfully Registered </h1>
<h4>Your details are as follows </h4>
<% String name,email,dob,equalify,lang,yourself,gen; name=request.getParameter(“txtName”); email=request.getParameter(“txtEmail”); dob=request.getParameter(“txtbdate”); equalify=request.getParameter(“opt-qualify”); lang=request.getParameter(“English”); yourself=request.getParameter(“about”); gen=request.getParameter(“gen”);
String [] lknown=request.getParameterValues(“lk”);
List list=Arrays.asList(lknown); request.setAttribute(“lknown”,list);
List<String> lk = (List<String>)request.getAttribute(“lknown”); out.println(“<table border=‘1’ cellpadding=‘15px’>“);
out.print(“<tr>“);
out.print(“<td>“);
out.print(“Name”);
out.print(“</td>“);
out.print(“<td>“); out.print(name);
out.print(“</td>“);
out.print(“</tr>“);
out.print(“<tr>“);
out.print(“<td>“);
out.print(“Email”);
out.print(“</td>“);
out.print(“<td>“); out.print(email); out.print(“</td>“);
out.print(“</tr>“);
out.print(“<tr>“);
out.print(“<td>“); out.print(“Date of Birth”); out.print(“</td>“);
out.print(“<td>“); out.print(dob); out.print(“</td>“);
out.print(“</tr>“);
out.println(“<tr>“);
out.println(“<td>“);
out.println(“Educational Qualifiation”); out.println(“</td>“);
out.println(“<td>“);
out.println(equalify);
out.println(“</td>“);
out.println(“</tr>“);
out.println(“<tr>“); out.println(“<td>“); out.println(“Gender”); out.println(“</td>“); out.println(“<td>“); out.println(gen); out.println(“</td>“); out.println(“</tr>“);
out.println(“<tr>“); out.println(“<td>“); out.println(“Languages known”);
out.println(“</td>“); out.println(“<td>“); for(String item:lk)
{
out.println(item);
}
out.println(“</td>“); out.println(“</tr>“);
out.println(“<tr>“); out.println(“<td>“); out.println(“About yourself”); out.println(“</td>“); out.println(“<td>“); out.println(yourself); out.println(“</td>“); out.println(“</tr>“); out.println(“</table>“);
%>
</body>
</html>
<%--
Document : index
Created on : Mar 18, 2021, 8:49:16 AM Author : VIKRAM
--%>
<%@page contentType=“text/html” pageEncoding=“UTF-8”%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv=“Content-Type” content=“text/html; charset=UTF-8”>
<title>Index page</title>
<style>
#content
{
margin-top:10px;
}
#tablehead
{
background-color: yellow; padding:10px;
}
</style>
</head>
<body>
<%@include file=“header.jsp” %>
<div id=“content”>
<h2 align=“center”>Adding Record </h2>
<tr align=“center” style=“color:blue”>
<td>${param.message}</td>
</tr>
</table>
<form action=“addrecord.jsp”>
<table border=“1” align=“center” cellpadding=“10px”>
<thead>
<tr id=‘tablehead’>
<th colspan=“2”>Student Master Form</th>
</tr>
</thead>
<tbody>
<tr>
<td>Name</td>
<td><input type=“text” name=“txtname” value=““ /></td>
</tr>
<tr>
<td>Semester</td>
<td><select name=“optsem”>
<option>Sem I</option>
<option>Sem II</option>
<option>Sem III</option>
<option>Sem IV</option>
</select></td>
</tr>
<tr>
<td>Course</td>
<option>MCA</option>
<option>M.Sc[Comp.Sc]</option>
<option>M.Sc[I.T.]</option>
</select></td>
</tr>
<tr>
<td><input type=“submit” value=“Add Record” /></td>
<td><input type=“reset” value=“Reset” /></td>
</tr>
</tbody>
</table>
</form>
<%@include file=“footer.jsp” %>
</body>
</html>
Addrecord.jsp
<%--
Document : addrecord
Created on : Mar 18, 2021, 8:57:40 AM
Author : VIKRAM
--%>
<%@page import=“java.sql.ResultSetMetaData”%>
<%@page import=“java.sql.Statement”%>
<%@page import=“java.sql.DriverManager”%>
<%@page import=“java.sql.PreparedStatement”%>
<%@page import=“java.sql.Connection”%>
<%@page import=“java.sql.ResultSet”%>
<%@page contentType=“text/html” pageEncoding=“UTF-8”%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv=“Content-Type” content=“text/html; charset=UTF-8”>
<title>Add Record process</title>
</head>
<body>
<%
String sname=request.getParameter(“txtname”);
String sem=request.getParameter(“optsem”);
String course=request.getParameter(“optcourse”); Connection conn;
PreparedStatement ps;
String url=“jdbc:mysql://localhost:3306/studentdb”; String user=“root”;
String password=““;
//step 1 try
{
Class.forName(“com.mysql.jdbc.Driver”); conn=DriverManager.getConnection(url, user, password);
String sql=“insert into student(sname,semester,course)value(?,?,?)”;
ps=conn.prepareStatement(sql); ps.setString(1, sname);
ps.setString(2, sem);
ps.setString(3, course); ps.executeUpdate(); conn.close();
}catch(ClassNotFoundException e)
{
e.printStackTrace();
}catch(Exception e)
{
e.printStackTrace();}
<jsp:forward page=“add.jsp”>
<jsp:param name=“message” value=“record inserted successfully” />
</jsp:forward>
</body>
</html>
display.jsp
<%--
Document : index
Created on : Mar 18, 2021, 8:49:16 AM Author : VIKRAM
--%>
<%@page import=“java.sql.ResultSetMetaData”%>
<%@page import=“java.sql.Statement”%>
<%@page import=“java.sql.SQLException”%>
<%@page import=“java.sql.ResultSet”%>
<%@page import=“java.sql.PreparedStatement”%>
<%@page import=“java.sql.DriverManager”%>
<%@page import=“java.sql.Connection”%>
<%@page contentType=“text/html” pageEncoding=“UTF-8”%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv=“Content-Type” content=“text/html; charset=UTF-8”>
<title>Index page</title>
<style>
#content
{
margin-top:10px;
}
.tablehead
{
background-color: yellow; padding:10px;
}
</style>
</head>
<body>
<%
String rollno=request.getParameter(“optrollno”);
Connection conn;
ResultSetMetaData rsmd; ResultSet rs1=null,rs2=null; Statement st; PreparedStatement ps;
String rn=null,nam=null,sam=null,co=null;
{
conn=DriverManager.getConnection(“jdbc:mysql://localhost:3306/studentdb”,”root”,”“);
st=conn.createStatement();
rs1=st.executeQuery(“select rollno from student”); ps=conn.prepareStatement(“select * from student where rollno=?”);
ps.setInt(1, Integer.parseInt(rollno));
rs2=ps.executeQuery(); rs2.next(); rn=rs2.getString(1); nam=rs2.getString(2); sam=rs2.getString(3); co=rs2.getString(4);
}catch(NumberFormatException e)
{
e.printStackTrace();
}
catch(SQLException e)
{
e.printStackTrace();
}
%>
<%@include file=“header.jsp” %>
<div id=“content”>
<h4 align=“center”>Selecting Record </h4>
<form action=“display.jsp” name=“myform”>
<table border=“1” align=“center” cellpadding=“10px”>
<thead>
<tr class=‘tablehead’>
<th colspan=“2”>Display Record</th>
</tr>
</thead>
<tbody>
<td>Choose Rollno</td>
<td><select name=“optrollno” onchange=“document.myform.submit()”>
<%
rsmd=rs1.getMetaData();
int tcol=rsmd.getColumnCount();
out.println(“<option>“); out.println(“Select Rollno”); out.println(“</option>“); while(rs1.next())
{
out.println(“<option>“); out.println(rs1.getString(1)); out.println(“</option>“);
}
%>
</select></td>
</tr>
</tbody>
</table>
<br>
<div id=“output”>
<table border=“1” align=“center” cellpadding=“10px”>
<thead>
<tr>
<th colspan=“4” align=“center” class=“tablehead”>Record </th>
</tr>
</thead>
<tbody>
<tr>
<th>Roll No</th>
<th>Name</th>
<th>Semester</th>
</tr>
<tr>
<td><%= rn%></td>
<td><%= nam%></td>
<td><%= sam%></td>
<td><%= co%></td>
</tr>
</tbody>
</table>
</div>
</form>
<%@include file=“footer.jsp” %>
</body>
</html>
<%--
Document : index
Created on : Mar 18, 2021, 8:49:16 AM Author : VIKRAM
--%>
<%@page import=“java.sql.SQLException”%>
<%@page import=“java.sql.DriverManager”%>
<%@page import=“java.sql.Statement”%>
<%@page import=“java.sql.ResultSet”%>
<%@page import=“java.sql.Connection”%>
<%@page import=“java.sql.ResultSetMetaData”%>
<%@page contentType=“text/html” pageEncoding=“UTF-8”%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv=“Content-Type” content=“text/html; charset=UTF-8”>
<title>Index page</title>
<style>
#content
{
margin-top:10px;
}
.tablehead
{
background-color: yellow; padding:10px;
}
</style>
<body>
<%
String rollno=request.getParameter(“optrollno”); Connection conn;
ResultSetMetaData rsmd;
ResultSet rs=null; Statement st;
try
{
conn=DriverManager.getConnection(“jdbc:mysql://localhost:3306/studentdb”,”root”,”“);
st=conn.createStatement();
rs=st.executeQuery(“select rollno from student”);
}catch(NumberFormatException e)
{
e.printStackTrace();
}
catch(SQLException e)
{
e.printStackTrace();
}
%>
<%@include file=“header.jsp” %>
<div id=“content”>
<h4 align=“center”>Deleting Record </h4>
<form action=“deleterecord.jsp” name=“myform”>
<table border=“1” align=“center” cellpadding=“10px”>
<thead>
<tr class=‘tablehead’>
<th colspan=“2”>Delete Record</th>
</thead>
<tbody>
<tr>
<td>Choose Rollno</td>
<td><select name=“optrollno” onchange=“document.myform.submit();”>
<%
rsmd=rs.getMetaData();
int tcol=rsmd.getColumnCount(); out.println(“<option>“); out.println(“Select Rollno”); out.println(“</option>“); while(rs.next())
{
out.println(“<option>“); out.println(rs.getString(1)); out.println(“</option>“);
}
%>
</select></td>
</tr>
</tbody>
</table>
<table align=“center”>
<tr>
<td colspan=“2”>${param.message}</td>
</tr>
</table>
<%@include file=“footer.jsp” %>
</body>
</html>
<%--
Document : deleterecord
Created on : Mar 18, 2021, 9:19:27 AM Author : VIKRAM
--%>
<%@page import=“java.sql.SQLException”%>
<%@page import=“java.sql.DriverManager”%>
<%@page import=“java.sql.PreparedStatement”%>
<%@page import=“java.sql.ResultSet”%>
<%@page import=“java.sql.Connection”%>
<%@page import=“java.sql.ResultSetMetaData”%>
<%@page contentType=“text/html” pageEncoding=“UTF-8”%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv=“Content-Type” content=“text/html; charset=UTF-8”>
<title>JSP Page</title>
</head>
<body>
<%
String rollno=request.getParameter(“optrollno”); Connection conn;
PreparedStatement ps;
try
{
conn=DriverManager.getConnection(“jdbc:mysql://localhost:3306/studentdb”,”root”,”“);
ps=conn.prepareStatement(“delete from student where rollno = ?”);
ps.setInt(1, Integer.parseInt(rollno)); ps.executeUpdate();
conn.commit(); conn.close();
}catch(NumberFormatException e)
{
e.printStackTrace();
}
catch(SQLException e)
{
e.printStackTrace();
}
%>
<jsp:forward page=“delete.jsp”>
<jsp:param name=“message” value=“Records Deleted successfully”/>
</jsp:forward>
</body>
</html>
Index.jsp
<%--
Document : index
Created on : Mar 23, 2021, 7:31:15 AM Author : VIKRAM
Write a program using JSP that displays a webpage consisting Application form for change of Study Center which can be filled by any student who wants to change his/her study center.
Make necessary assumptions
--%>
<%@page contentType=“text/html” pageEncoding=“UTF-8”%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv=“Content-Type” content=“text/html; charset=UTF-8”>
<title>Practical 6-5</title>
</head>
<body>
<h1 align=“Center”>Application form for Change of Study Center</h1>
<form action=“Process.jsp”>
<table border=“1” align=“center” cellpadding=“20px”>
<tbody>
<tr>
<td>Registration id</td>
<td><input type=“text” name=“txtRegid” value=““ /></td>
</tr>
<tr>
<td>Name</td>
<td><input type=“text” name=“txtName” value=““ /></td>
</tr>
<tr>
<td>Old Study center address</td>
<td><textarea name=“txtOldaddress” rows=“4” cols=“20”>
</textarea></td>
<tr>
<td>New Study center address</td>
<td><textarea name=“txtNewaddress” rows=“4” cols=“20”>
</textarea></td>
</tr>
<tr>
<td><input type=“submit” value=“Change It” /></td>
<td><input type=“reset” value=“Reset” /></td>
</tr>
</tbody>
</table>
</form>
</body>
</html>
Process.jsp
<%--
Document : Process
Created on : Mar 23, 2021, 7:36:34 AM Author : VIKRAM
--%>
<%@page contentType=“text/html” pageEncoding=“UTF-8”%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv=“Content-Type” content=“text/html; charset=UTF-8”>
<title>JSP Page</title>
</head>
<body>
<h1 align=“center”>Address is Successfully change</h1>
<%
String regid=request.getParameter(“txtRegid”);
String name=request.getParameter(“txtName”);
String oldadd=request.getParameter(“txtOldaddress”);
String newadd=request.getParameter(“txtNewaddress”);
out.println(“<table border=‘1’ align=‘center’ cellpadding=‘20px’ “);
out.println(“<tr>“); out.println(“<td>“); out.println(“Registration Id”); out.println(“</td>“); out.println(“<td>“); out.println(regid);
out.println(“</td>“); out.println(“</tr>“);
out.println(“<tr>“); out.println(“<td>“); out.println(“Name”); out.println(“</td>“); out.println(“<td>“); out.println(name); out.println(“</td>“); out.println(“</tr>“);
out.println(“<tr>“); out.println(“<td>“); out.println(“Old address”); out.println(“</td>“); out.println(“<td>“); out.println(oldadd); out.println(“</td>“); out.println(“</tr>“);
out.println(“<tr>“); out.println(“<td>“); out.println(“New address”); out.println(“</td>“); out.println(“<td>“); out.println(newadd); out.println(“</td>“); out.println(“</tr>“);
out.println(“</table>“);
%>
</body>
</html>
index.jsp
<%--
Document : index
Created on : Mar 18, 2021, 8:10:33 AM Author : VIKRAM
Write a JSP program that demonstrates the use of JSP declaration, scriptlet, directives, expression, header and footer.
--%>
<%@page contentType=“text/html” pageEncoding=“UTF-8”%>
<!DOCTYPE html>
<head>
<meta http-equiv=“Content-Type” content=“text/html; charset=UTF-8”>
<title>Practical 6-6</title>
<style>
#content
{
margin-top:10px;
}
</style>
</head>
<body>
<!--use of Include Directives as header -->
<%@include file=“header.jsp” %>
<div id=“content”>
<!--JSP Declaration -->
<%! int number1=10,number2=20;%> Value of number is= <%= number1%> <br>
<!-- use of JSP scriptlet -->
Today’s Date is <% out.println(new java.util.Date()); %><br>
<!-- use of expression --> Number1=<%=number1%><br> Number2=<%=number2%><br>
Addition of two numbers are <%=number1+number2%><br>
</div>
<!--use of Include Directives as footer-->
<%@include file=“footer.jsp” %>
</body>
</html>
header.jsp
<%--
Created on : Mar 18, 2021, 8:24:06 AM Author : VIKRAM
--%>
<%@page contentType=“text/html” pageEncoding=“UTF-8”%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv=“Content-Type” content=“text/html; charset=UTF-8”>
<title>JSP Page</title>
<style>
#menu
{
background-color:orange; padding: 2px;
}
li
{
display:inline; padding:5px;
}
a
{
text-decoration: none; color:brown;
}
</style>
</head>
<body>
<div id=“menu”>
<ul>
<li> <a href=“#”>Home</a></li>
<li> <a href=“#”>Service</a></li>
<li> <a href=“#”>Contact us </a></li>
<li> <a href=“#”>About us</a></li>
</ul>
</div>
</body>
</html>
footer.jsp
<%--
Document : footer
Created on : Mar 18, 2021, 8:16:07 AM Author : VIKRAM
--%>
<%@page contentType=“text/html” pageEncoding=“UTF-8”%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv=“Content-Type” content=“text/html; charset=UTF-8”>
<title>JSP Page</title>
<style>
#foot
{
color:white;
background-color: black; margin-top:200px; padding:10px;
}
</style>
</head>
<body>
<div id=“foot”>
© All rights reserved for Hiray Institute of computer technology</div>
</body>
</html>