Paritosh Das
How can I do this? Suppose I have jsp page aaa.jsp. From aaa.jsp on form action I have made a call to a servlet xxx.java. In xxx.java I have written code to retrieve data from database through List and data is being retrieve.
Now I want to pass this List to another jsp page bbb.jsp from xxx.java. How can I do this? How can I get the accurate path of the bbb.jsp? To be frankly, managing path is one of the great headache to me. Please help me.
May 20, 2011 at 5:23 PM
1)callServlet.jsp:
<form method="post" action="../Servlet"> <input type="submit" value="Call Servlet"> </form>
2)Put the servlet in the classes folder and do the servlet mapping in web.xml.Here is 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){
}
}
}
3)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"><%=itr.next()%></td>
<td width="168"><%=itr.next()%></td>
<td width="168"><%=itr.next()%></td>
<td width="168"><%=itr.next()%></td>
</tr>
<%}%>
</table>
</body>
</html>
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.
