
how to dispaly the output coming from servlet in a particular text field of html.

1)Servlet.java
import java.io.*;
import java.sql.*;
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class Servlet extends HttpServlet{
protected void doPost(HttpServletRequest req, HttpServletResponse res)
throws ServletException, IOException{
ArrayList list=new ArrayList();
try{
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "root");
Statement st=con.createStatement();
ResultSet rs=st.executeQuery("select * from employee");
while(rs.next()){
list.add(rs.getString("name"));
list.add(rs.getString("address"));
list.add(rs.getString("contactNo"));
list.add(rs.getString("email"));
}
req.setAttribute("data", list);
RequestDispatcher rd = req.getRequestDispatcher("/jsp/data.jsp");
rd.forward(req, res);
}
catch(Exception e){
}
}
}
2)data.jsp:
<%@page language="java" import="java.util.*" %>
<html>
<body>
<table border="1" width="303">
<tr>
<td width="119"><b>Name</b></td>
<td width="168"><b>Address</b></td>
<td width="119"><b>Contact no</b></td>
<td width="168"><b>Email</b></td>
</tr>
<% Iterator itr;%>
<% List data=(List)request.getAttribute("data");
for(itr=data.iterator(); itr.hasNext(); ){
%>
<tr>
<td width="119"><input type="text" value=<%=itr.next()%>></td>
<td width="168"><input type="text" value=<%=itr.next()%>></td>
<td width="168"><input type="text" value=<%=itr.next()%>></td>
<td width="168"><input type="text" value=<%=itr.next()%>></td>
</tr>
<%}%>
</table>
</body>
</html>