为什么不能显示页面呢?

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

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />

<meta http-equiv="X-UA-Compatible"content="IE=9; IE=8; IE=7; IE=EDGE" />

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

<link href="<%=basePath %>rescource/css/all.css" rel="stylesheet" type="text/css" />

</head>

<body style="background: #e1e9eb;">

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

<div class="right">

<div class="current">当前位置:<a href="javascript:void(0)" style="color:#6E6E6E;">内容管理</a> &gt; 内容列表</div>

<div class="rightCont">

<p class="g_title fix">内容列表 <a class="btn03" href="#">新 增</a>&nbsp;&nbsp;&nbsp;&nbsp;<a class="btn03" href="#">删 除</a></p>

<table class="tab1">

<tbody>

<tr>

<td width="90" align="right">指令:</td>

<td>

<input name="command" type="text" class="allInput" value=""/>

</td>

<td width="90" align="right">描述:</td>

<td>

<input name="description" type="text" class="allInput" value=""/>

</td>

                           <td width="85" align="right"><input type="submit" class="tabSub" value="查 询" /></td>

      </tr>

</tbody>

</table>

<div class="zixun fix">

<table class="tab2" width="100%">

<tbody>

<tr>>

   <th><input type="checkbox" id="all" onclick="#"/></th>

   <th>序号</th>

   <th>指令</th>

   <th>描述</th>

   <th>操作</th>

</tr>

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

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

<td><input type="checkbox" /></td>

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

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

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

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

<td>

<a href="#">修改</a>&nbsp;&nbsp;&nbsp;

<a href="#">删除</a>

</td>

</tr>

</c:forEach>

</tbody>

</table>

<div class='page fix'>

共 <b>4</b> 条

<a href='###' class='first'>首页</a>

<a href='###' class='pre'>上一页</a>

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

<a href='###' class='next'>下一页</a>

<a href='###' class='last'>末页</a>

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

<a href='###' class='go'>GO</a>

</div>

</div>

</div>

</div>

   </form>

</body>

</html>


缪斯侄女Heng
浏览 1300回答 1
1回答

rubyc

请问出现什么错误提示,还是什么都没有?
打开App,查看更多内容
随时随地看视频慕课网APP

相关分类

Java