为什么不能显示页面呢？

package cn.edu.ujn.zhouheng.servlet;

import java.io.IOException;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.util.ArrayList;

import java.util.List;

import javax.servlet.ServletException;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import cn.edu.ujn.zhouheng.beans.Message;

@SuppressWarnings("serial")

public class ListServlet extends HttpServlet {

private String driver = "com.mysql.jdbc.Driver";

private String url = "jdbc:mysql://localhost:3306/wechat";

private String username = "root";

private String password = "root";

@Override

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

// TODO Auto-generated method stub

try {

Class.forName(driver);

Connection conn = DriverManager.getConnection(url, username, password);

String sql = "select id,command,description,content from message";

PreparedStatement ps = conn.prepareStatement(sql);

ResultSet rs = ps.executeQuery();

List<Message> messageList = new ArrayList<Message>();

while(rs.next()) {

Message message = new Message();

message.setId(rs.getInt("id"));

message.setCommand(rs.getString("command"));

message.setDescription(rs.getString("description"));

message.setContent(rs.getString("content"));

messageList.add(message);

}

request.setAttribute("messageList", messageList);

} catch (ClassNotFoundException e) {

// TODO Auto-generated catch block

e.printStackTrace();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

//request.getRequestDispatcher("/WEB-INF/jsp/back/list.jsp").forward(request, response);

}

@Override

protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

// TODO Auto-generated method stub

this.doGet(request, response);

}

<%@ page language="java" contentType="text/html; charset=UTF-8"

pageEncoding="UTF-8"%>

<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>

String path = request.getContextPath();

String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>内容列表页面</title>

</head>

<form action="<%=basePath %>List.action" id="mainForm" method="get">

<tbody>

<tr>

<td>

</td>

<td>

</td>

</tr>

</tbody>

</table>

<tbody>

<tr>>

</tr>

<c:forEach items="messageList" var="message" varStatus="status">

<tr <c:if test="status.index%2!=0">style="background-color:#ECF6EE;"</c:if>>>

<td>${status.index+1}</td>

<td>${message.command}</td>

<td>${message.description}</td>

<td>${message.content}</td>

<td>

</td>

</tr>

</c:forEach>

</tbody>

</table>

共 <b>4</b> 条

当前第<span>1/1</span>页

跳至 <input type='text' value='1' class='allInput w28' /> 页 

</div>

</form>

</body>

</html>

缪斯侄女Heng

浏览 1295回答 1

为什么不能显示页面呢？

1回答