⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 newsdetail.java

📁 新闻发布系统
💻 JAVA
字号:
🔍 
package mypackage;

import javax.servlet.*;
import javax.servlet.http.*;
import java.io.PrintWriter;
import java.io.IOException;
import java.sql.*;

public class NewsDetail extends HttpServlet 
{
  private static final String CONTENT_TYPE = "text/html; charset=GBK";

  public void init(ServletConfig config) throws ServletException
  {
    super.init(config);
  }

  public void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
  {
    response.setContentType(CONTENT_TYPE);
    PrintWriter out = response.getWriter();
    
    //声明变量并初始化
    String title = null;
    String date = null;
    String content = null;
    String id = request.getParameter("id");
    String sql = "select * from news where id="+id;
    ConnectionDB db = new ConnectionDB();
    ResultSet rs = db.executeQuery(sql);
    
    //将游标置于结果集第一个结果位置
    try{
      rs.next();
    }
    catch(Exception e){
      System.out.println(e.getMessage());
    }
    
    out.println("<html>");
    out.println("<head><title>NewsDetail</title></head>");
    out.println("<body>");
    out.println("<table width=75% height=420 border=0 align=center cellpadding=0 cellspacing=1 bgcolor=#999999>");
    out.println("<tr>");
    out.println("<td height=28 bgcolor=#FFFFFF align=center><b>");
    
    //取出查询字段
    try{
      title = rs.getString("title");
      out.println(title);
    }
    catch(Exception e){
      System.out.println(e.getMessage());
    }
    
    out.println("</b></td>");
    out.println("</tr>");
    out.println("<tr>");
    out.println("<td height=361 valign=top bgcolor=#FFFFFF>");
    
    try{
      content = rs.getString("content");
      out.println(content);
    }
    catch(Exception e){
      System.out.println(e.getMessage());
    }
    out.println("</td>");
    out.println("</tr>");
    out.println("<tr>");
    out.println("<td align=right bgcolor=#FFFFFF><font size=2>发布时间：");
    
    try{
      date = rs.getString("addtime");
      out.println(date);
    }
    catch(Exception e){
      System.out.println(e.getMessage());
    }
    
    //显式关闭连接
    db.CloseDataBase();
    out.println("</font></td>");
    out.println("</tr>");
    out.println("</table>");
    out.println("</body></html>");
    out.close();
  }
}

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -