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

📄 admin.java

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

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

public class Admin 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 id = null;
    String title = null;
    String date = null;
    String sql = null;
    sql = "select * from news";
    
    //调用公共类并调用它的查询方法
    ConnectionDB db = new ConnectionDB();
    ResultSet rs = db.executeQuery(sql);
    
    //输出HTML
    out.println("<html>");
    out.println("<head><title>Admin</title></head>");
    out.println("<body>");
    out.println("<div align=center><font color=#FF0000 size=6 face=隶书>新闻发布系统</font></div>");
    out.println("<table width=70% border=0 align=center cellpadding=0 cellspacing=1 bgcolor=#999999>");
    out.println("<tr>");
    out.println("<td width=48% bgcolor=#FFFFFF>&gt;&gt;新闻管理:</td>");
    out.println("<td width=52% height=23 align=center bgcolor=#FFFFFF>");
    out.println("<a href=IssueNews>发布新闻</a>-<a href=NewsList>新闻首页</a> ");
    out.println("</td>");
    out.println("</tr>");
    out.println("<tr>");
    out.println("<td height=240 colspan=2 align=center bgcolor=#FFFFFF>");
    out.println("<table width=98% cellpadding=0 cellspacing=1 bgcolor=#999999>");
    
    
    //显示所有查询结果
    try{
      while(rs.next()){
        title = rs.getString("title");
        date = rs.getString("addtime");
        id = rs.getString("id");
        out.println("<tr>");
        out.println("<td bgcolor=#FFFFFF>"+title+"("+date+")</td>");
        out.println("<td bgcolor=#FFFFFF><a href=UpdateNews?id="+id+">更新</a></td>");
        out.println("<td bgcolor=#FFFFFF><a href=DeleteNews?id="+id+">删除</a></td>");
        out.println("</tr>");
      }
    }
    catch(Exception e){
      System.out.println(e.getMessage());
    }
    //关闭连接
    finally{
      db.CloseDataBase();
    }
    out.println("</table>");
    out.println("</td>");
    out.println("</tr>");
    out.println("</body></html>");
    out.close();
  }
}

⌨️ 快捷键说明

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