problem sendRedirect to JSP page

[Thamu Gurung]

Hi,

I am having problems in sendind Re-direct to JSP page .

I am able to get the datas displayed in the servlet ,, bu no idea of redirecting it to JSP page ...fresher in JSP and Servlets

My codings for sevlet is as follows:-

import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;

public class ListUsersServlet extends HttpServlet{
  public void doGet(HttpServletRequest request, HttpServletResponse response) throws
                             ServletException, IOException{
    response.setContentType("text/html");
    PrintWriter pw = response.getWriter();
    String connectionURL = "jdbc:mysql://127.0.0.1:3306/lsa";
    Connection connection=null;
    try{
      Class.forName("com.mysql.jdbc.Driver");
      connection = DriverManager.getConnection(connectionURL, "root", "hello");
      PreparedStatement pst = connection.prepareStatement("Select * from users");
      ResultSet rs = pst.executeQuery();
      while(rs.next()){
        long id = rs.getLong("ID");
		String firstName = rs.getString("firstname");
		String lastName = rs.getString("surname");
		String email = rs.getString("contact_email");
		String storedUsername = rs.getString("username");
		String storedPassword = rs.getString("password");
        String telephone = rs.getString("contact_number");
      }
    getServletContext().getRequestDispatcher("/users.jsp").forward(request, response);
    }

    catch (Exception e){
      pw.println(e);
    }
    pw.println("hello");
  }
}

now I want o get all these seven fields to be displayed in a jsp file (users.jsp),, please give me some guidelines to do this .

How to pass the above values in the jsp file.

as my users.jsp file is having errors ..

[Bear Bibeault]

A few points:

You are doing a forward, not a redirect. They are not the same. In this case, a forward is correct.

The logic in your servlet is such that the values are being over-written on each loop. At the end of the loop all you have is the data from the last iteration. Ths is certainly not your intention.

To make the data available to a forwarded JSP, you create scoped variables in the request. You do this with request.setAttribute().

In your JSP, be sure to avoid old-fashioned scriptlets and use modern mechanisms such as the JSTL and EL.

[Thamu Gurung]

hi,

Thankyou . I will try this and let you know.

Regards

[Thamu Gurung]

hi,

my error is like this now :-

An error occurred at line: 48 in the jsp file: /users.jsp
Duplicate local variable user
45:                           
46:                           // for each of the results display the columns of information
47:                           for (int i = 0; i < users.size(); i++) {
48:                               User user = (User) users.get(i);
49:                       %>
50:                               <tr>
51:                                   <td><%=user.getId()%></td>

I could not figure out , how i have used the duplicationn of the local variable user

:- User is a class file which having getter methods returning the values; and " users" is the attribute which was setted.

Regards

[Bear Bibeault]

So I see that you ignored my advice not to use scriptlets.

[Ilya Cyclone]

Hi Thamu,

in yout JSP there should be smth like:

  <c:forEach items=${users} var="user">
${user.id} | ${user.name} <br/>
</c:forEach>  

[Thamu Gurung]

Hi Ilya and Bear ,
Sorry for using the scriplets , and thankyou for your logic

And thankyou Ilya for giving me that hint.

Now its done .

Regards ,