JSP+Servlet+Tomcat+Mysql实现注册、登陆、修改、添加、查看、分页实例之----查看单个明细

本文链接：https://blog.csdn.net/u012926354/article/details/79679934

1、新建页面detail.jsp

<%--
  Created by IntelliJ IDEA.
  User: lvjun
  Date: 2018-03-22
  Time: 17:18
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/fmt" prefix="fmt"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/functions" prefix="fn"%>

<html>
    <head>
        <title>详情</title>
    </head>
    <body>
        <table border="1">
            <tr>
                <td colspan="3" align="center">${detail.title}</td>
            </tr>
            <tr>
                <td>${detail.author}</td>
                <td>${detail.ctime}</td>
                <td>${detail.type}</td>
            </tr>
            <tr>
                <td colspan="3">${detail.content}</td>
            </tr>
            <tr>
                <td colspan="3" align="center"><a href="/return">返回首页</a></td>
            </tr>
        </table>
    </body>
</html>

2、DetailServlet

package com.servlet.bbs;

import com.dao.BbsDao;
import com.entity.BbsEntity;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;

/**
 * 详情
 * Created by lvjun on 2018-03-22.
 */
@WebServlet(name = "DetailServlet")
public class DetailServlet extends HttpServlet {
    protected void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        int id = Integer.parseInt(request.getParameter("id"));
        BbsDao bbsDao = new BbsDao();
        BbsEntity bbsEntity = bbsDao.GetDetail(id);
        request.setAttribute("detail", bbsEntity);
        request.getRequestDispatcher("/detail.jsp").forward(request, response);
    }
}

3、数据库操作方法

/***
     * 查看明细详情
     */
    public BbsEntity GetDetail(int id) {
        Dbmanage dbmanage = new Dbmanage();
        Connection conn = null;
        Statement sta = null;
        ResultSet rs = null;
        BbsEntity bbsEntity = null;
        try {
            conn = dbmanage.initDB();
            sta = conn.createStatement();
            String sql = "SELECT * FROM bbs WHERE id=" + id + "";
            rs = sta.executeQuery(sql);
            while (rs.next()) {
                bbsEntity = new BbsEntity();
                bbsEntity.setId(rs.getInt("id"));
                bbsEntity.setTitle(rs.getString("title"));
                bbsEntity.setAuthor(rs.getString("author"));
                bbsEntity.setCtime(rs.getString("ctime"));
                bbsEntity.setContent(rs.getString("content"));
                bbsEntity.setType(rs.getInt("type"));
                bbsEntity.setType(rs.getInt("stat"));
            }
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            dbmanage.closeDB(rs, sta, conn);
        }
        return bbsEntity;
    }