java servlet 输出_java – 从servlet到JSP的输出

我将参数从JSP页面calendar.jsp传递给servlet connect.

java.

在

Java类中,我从数据库传递查询.它检索数据很好但我需要它将结果打印回JSP页面.

我尝试了以下代码,但在out.println()中出现错误.

@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");

System.out.println("fromDate---->"+fromDate);

System.out.println("toDate---->"+toDate);

String query = "SELECT action_time,user_action,user_ip,user_id FROM ksdi.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;

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");

System.out.println((action_time) + " " + (user_action) + " "+(user_ip) + " "+(user_id) + " ");

response.setContentType("text/html");

PrintWriter out = response.getWriter();

out.println("action time"+((ResultSet) request).getString("action_time")+"
");

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) {}

}

}

}

这是我的JSP文件：

From:

To: