|
|
Servlet Examples
Steps to Execute Jsp |
Module 1 |
Module 2 |
Module 3 |
|
|
| Step 1: Design code for Login Page |
<html>
<head>
<title>user Enter ID</title>
</head>
<body>
<form method="post" action="StudentDB">
<center>
<font color="green" size="4">Enter your ID:<input type="text" name="id"><br><br>
<pre> <input type="submit" value="Login"></pre></center></font>
</center>
</form>
</body>
</html>
|
 |
| Step 2: Design code for Access values from DB |
package com;
import java.sql.*;
import java.io.*;
import javax.servlet.*;
import javax.servlet.Servlet.*;
import javax.servlet.http.*;
public class StudentDB extends HttpServlet
{
public void doPost(HttpServletRequest request,HttpServletResponse response)
throws IOException,ServletException
{
response.setContentType("text/html");
PrintWriter out=response.getWriter();
String id=request.getParameter("id");
String name=null;
String age=null;
String major=null;
String address=null;
String sql="select * from students where idd="+id;
try
{
Class.forName("com.mysql.jdbc.Driver");
Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/vijikumar","root","sun");
Statement st = con.createStatement();
ResultSet rs=st.executeQuery(sql);
out.println("<p align=\"center\"> </p>");
out.println("<p align=\"center\"> </p>");
out.println("<div align=\"center\">");
out.println("<table border=\"1\" align=center>");
out.println("<tr>");
out.println("<td><font color=\"#008000\"><b> id </b></font></td>");
out.println("<td> name </td>");
out.println("<td>age</td>");
out.println("<td>major</td>");
out.println("<td>address</td>");
out.println("</tr>");
while(rs.next())
{
out.println("<tr>");
name=rs.getString(2);
age=rs.getString(3);
major=rs.getString(4);
address=rs.getString(5);
out.println("<td>"+id+"</td>");
out.println("<td>"+name+"</td>");
out.println("<td>"+age+"</td>");
out.println("<td>"+major+"</td>");
out.println("<td>"+address+"</td>");
out.println("</tr>");
}
out.println("</table>");
out.println("</center>");
out.println("</div>");
}
catch(Exception e)
{
System.out.println(e);
}
}
}
|
 |
|
Back to Top |
|
