Aim:
Develop a Web application Working with Servlet and JDBC.
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:
Index.html
<html> <body> <form action="search"> Enter your Rollno:<input type="text" name="regno"/><br/> <input type="submit" value="search"/> </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();} } }
Output:

