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:

