issuenewssave.java

来自「新闻发布系统」· Java 代码 · 共 62 行

JAVA
62
字号
package mypackage;

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

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

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

  public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
  {
    response.setContentType(CONTENT_TYPE);
    request.setCharacterEncoding("GBK");
    PrintWriter out = response.getWriter();
    
    //声明变量并初始化
    String title = null;
    String date = null;
    String content = null;
    ConnectionDB db = null;
    String sql;
    int num = 0;
    
    out.println("<html>");
    out.println("<head><title>IssueNewsSave</title></head>");
    out.println("<body>");
    
    //变量赋值
    title = request.getParameter("title");
    content = request.getParameter("content");
    db = new ConnectionDB();
    date = new SimpleDateFormat("yyyy-M-d").format(new Date());
    sql = "insert into news(title, addtime, content) values('"+title+"', '"+date+"', '"+content+"')";
    
    //执行公共类的插入方法
    try{
      num = db.executeInsert(sql);
    }
    catch(Exception e){
      System.out.println(e.getMessage());
    }
    
    //判断是否插入成功
    if(num == 0)
      out.println("发布失败!");
    else
      out.println("发布成功!");
    out.println("<a href=Admin>返回</a>");
    out.println("</body></html>");
    out.close();
  }
}

⌨️ 快捷键说明

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