Java Program to Develop Java Server Pages applications using JSP Tags

by

Aim:

Develop Java Server Pages applications using JSP Tags.

Procedure:

  • Step 1: Open a New Java Web Application on Netbeans Editor.
  • Step 2: Open Netbeans Ide, Choose File -> new Project.
  • Step 3: New Open a New Project and Choose a Web Application and Open a New Servlet File.
  • Step 4: Create a Database in Mysql and Establish a Prepare Jdbc With Java Application.
  • Step 5: the Give Proper Database Connections Through Web Services.
  • Step 6: Write a Prepare Query in Servlet Page.
  • Step 7: Design a Html Page With Label Textbox and Button for Searching.
  • Step 8: Run the Project and Display the Search Result in Browser.
  • Step 9: Save the Project (Ctrl+s).
  • Step 10: Run the Project (F5).

Program:

FORM:

<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
 <head>
 <title>form</title>
 </head>
 <body><h1>Student Information Management System</h1><br>
 <form method="post" action="insert.jsp">
 <table>
 <tr><td>rollno</td><td><input type="text"
name="rollno"/></td></tr>
 <tr><td>sname</td><td><input type="text"
name="sname"/></td></tr>
 <tr><td>Age</td><td><input type="text" name="age"/></td></tr>
 <tr><td>Grade</td><td><input type="text" name="grade"/></td>
 <td><input type="submit" value="Insert"/></td>
 </table>
 </form>
 <br>
 <form method="post" action="delete.jsp">
 <table>
 <tr><td>Enter The Roll No</td><td><input type="input"
name="del"/></td>
 <td><input type="submit" value="delete"><br></td></tr>
 </table>
 </form>
 <form action="view.jsp">
 <input type="submit" value="view"/>
 </form>
 </body> 
</html>

Search.java

import java.io.*;
import java.sql.*;
import javax.servlet.ServletException;
import javax.servlet.http.*;
public class search extends HttpServlet {
public void doGet(HttpServletRequest request, HttpServletResponse response)
 throws ServletException, IOException {
response.setContentType("text/html");
PrintWriter out = response.getWriter();
String rollno=request.getParameter("regno");
int roll=Integer.valueOf(rollno);
try{
Class.forName("com.mysql.jdbc.Driver");
 Connection
con=DriverManager.getConnection("jdbc:mysql://localhost:3306/msc","root","ram
");
PreparedStatement ps=con.prepareStatement("select * from stud where regno=?");
ps.setInt(1,roll);
out.print("<table width=50% border=1>"); 
out.print("<caption>Result:</caption>");
ResultSet rs=ps.executeQuery();
ResultSetMetaData rsmd=rs.getMetaData();
int total=rsmd.getColumnCount();
out.print("<tr>");
for(int i=1;i<=total;i++)
{
out.print("<th>"+rsmd.getColumnName(i)+"</th>");
}
out.print("</tr>");
while(rs.next())
{
out.print("<tr><td>"+rs.getInt(1)+"</td><td>"+rs.getString(2)+"
</td><td>"+rs.getString(3)+"</td><td>"+rs.getString(4)+"</td></tr>");
}
out.print("</table>");
}catch (Exception e2) {e2.printStackTrace();}
finally{out.close();}
}
}

INSERT:

<%@page contentType="text/html" language="java" import="java.sql.*"%>
<!DOCTYPE html>
<html>
 <head>
 <body>
 <%
 String rollno=request.getParameter("rollno");
 String sname=request.getParameter("sname");
 String age=request.getParameter("age");
 String grade=request.getParameter("grade");
 try
 {
 Class.forName("com.mysql.jdbc.Driver");
 Connection
con=DriverManager.getConnection("jdbc:mysql://localhost/demo","root","cheran"
);
 Statement st=con.createStatement();
 String sql="INSERT INTO
stud(rollno,sname,age,grade)values("+rollno+",'"+sname+"',"+age+",'"+grade+"')";
 int rs=st.executeUpdate(sql);
 }

 catch(ClassNotFoundException | SQLException e)
 {
 out.println(e.toString());
 }
 finally
 {}
 %>
 <h1>Insert Successfully...!></h1>
 <br>
 <a href="Form.jsp">Back</a>
</body>
</html>

DELETE:

<%@page contentType="text/html" language="java" import="java.sql.*"%>
<!DOCTYPE html>
<html>
 <body>
 <%
 String rollno=request.getParameter("del");
 try
 {
 Class.forName("com.mysql.jdbc.Driver");
 Connection
con=DriverManager.getConnection("jdbc:mysql://localhost:3306/demo","root","ch
eran");
 Statement st=con.createStatement();
 String sql= "DELETE FROM stud WHERE rollno = '"+rollno+"'";
 int rs=st.executeUpdate(sql);
 }
 catch(SQLException e)
 {
 out.println(e.toString());
 }
 finally
 {
 }
 %>
 <h1>Delete successfully</h1>
 <br><a href="Form.jsp">back</a>
 </body>

VIEWS:

<%@page contentType="text/html" language="java" import="java.sql.*"%>
<!DOCTYPE html>
<!DOCTYPE html>
<html>
 <body>
 <table border="2" cellpadding="5" cellspacing="5">
 <tr>
 <td>rollno</td>
 <td>sname</td>
 <td>age</td>
 <td>grade</td>
 </tr>
 <%
 try
 {
 Class.forName("com.mysql.jdbc.Driver");
 Connection
con=DriverManager.getConnection("jdbc:mysql://localhost/demo","root","cheran"
);
 Statement st=con.createStatement();
 ResultSet rs=st.executeQuery("select * from stud");
 while(rs.next())
 {
 %>
 <tr><td><%=rs.getInt("rollno")%></td>
 <td><%=rs.getString("sname")%></td>
 <td><%=rs.getInt("age")%></td>
 <td><%=rs.getString("grade")%></tr>
 <%
}
}
catch(ClassNotFoundException | SQLException e)
{ 
out.println(e.toString());
}
%>
<h1>View Table</h1>
 </table>
 <br>
 <a href="Form.jsp">Back</a>
 </body>
</html>

Output:

Leave a Comment