Printing multiple lines of query from servlet to jsp ///
Below is the code of the servlet and jsp file
Connect.java
@WebServlet("/calendar")
public class Connect extends HttpServlet {
@Override
protected void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String fromDate = request.getParameter("fromDate");
String toDate = request.getParameter("toDate");
String query = "SELECT action_time,user_action,user_ip,user_id FROM di.login_detail where (action_time, action_time) OVERLAPS (DATE '"
+ fromDate+ "',DATE '"+ toDate+ "'+ integer '1')" +
" order by action_time desc";
Connection conn = null;
PreparedStatement statement = null;
ResultSet resultSet = null;
System.out.println("done4");
try {
conn = ConnectionUtil.getConnection();
statement = conn.prepareStatement(query);
resultSet = statement.executeQuery();
if (resultSet.next()) {
while(resultSet.next()){
String action_time=resultSet.getString("action_time");
String user_action=resultSet.getString("user_action");
String user_ip=resultSet.getString("user_ip");
String user_id=resultSet.getString("user_id");
request.setAttribute("action_time",action_time);
request.setAttribute("user_action",user_action);
request.setAttribute("user_ip",user_ip);
request.setAttribute("user_id",user_id);
RequestDispatcher view = request.getRequestDispatcher("calendar.jsp");
view.forward(request,response);
}
} else {
System.out.println("not found");
}
} catch (SQLException e) {
throw new ServletException("DB interaction failed", e);
} catch (Exception e) {
e.printStackTrace();
} finally {
if (resultSet != null) try { resultSet.close(); } catch (SQLException ignore) {}
if (statement != null) try { statement.close(); } catch (SQLException ignore) {}
if (conn != null) try { conn.close(); } catch (SQLException ignore) {}
}
}
}
Calendar.jsp
<%@ page import="java.sql.*" %>
<%
String path = request.getContextPath();
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<script src="<%=path%>/js/calendar.js"></script>
<link href="<%=path %>/css/calendar.css" rel="stylesheet">
</head>
<body>
<form action="calendar">
<div class="container">
From:<input name="fromDate" type="text" class="calendarSelectDate" />
To: <input name="toDate" type="text" class="calendarSelectDate" />
<input type="submit" name="b1" value="Go">
</div>
<div id="calendarDiv"></div>
<%= request.getAttribute("action_time")%>
<%= request.getAttribute("user_action")%>
<%= request.getAttribute("user_ip")%>
<%= request.getAttribute("user_id")%>
</form>
</body>
</html>
I am trying to show the result of calender.jsp from my servlet, the request passed above generates multiple lines as a result, but in the jsp page, it only generates the output of the first line and stops executing. What else can be done here to get the full jsp result. Thank.////
source to share
Create a class like:
public class User {
private String actionTime;
private String userAction;
private String userIp;
private String userId;
//Getters and setters
}
Then you must change your code like this:
ArrayList<User> users = new ArrayList<User>();
while (resultSet.next()) {
User user = new User();
user.setActionTime(resultSet.getString("action_time"));
user.setUserAction(resultSet.getString("user_action"));
user.setUserId(resultSet.getString("user_ip"));
user.setUserIp(resultSet.getString("user_id"));
users.add(user);
}
request.setAttribute("users", users);
RequestDispatcher view = request.getRequestDispatcher("calendar.jsp");
view.forward(request, response);
In the loop, always create a new user, add him to the list of users, and when the loop is over, the whole list will be listed as a request attribute.
Then, in your JSP, use JSTL to process the list:
<c:forEach var="user" items="${users}">
<c:out value="${user.actionTime}"/>
<c:out value="${user.userAction}"/>
<c:out value="${user.userIp}"/>
<c:out value="${user.userId}"/>
</c:forEach>
See also:
source to share
As mentioned, with each iteration, you rewrite the request attribute. You also call
RequestDispatcher view = request.getRequestDispatcher("calendar.jsp");
view.forward(request,response);
which forwards the response in the first iteration. Create a list or hash and set this attribute then access it from you JSP
source to share