📄 updatenewssave.java
字号:
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 UpdateNewsSave 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);
request.setCharacterEncoding("GBK");
PrintWriter out = response.getWriter();
//声明变量并初始化
int num = 0;
String id = null;
String title = null;
String content = null;
String date = null;
String sql = null;
ConnectionDB db = null;
//输出HTML头
out.println("<html>");
out.println("<head><title>UpdateNewsSave</title></head>");
out.println("<body>");
//变量赋值
id = request.getParameter("id");
title = request.getParameter("title");
content = request.getParameter("content");
db = new ConnectionDB();
sql = "update news set title='"+title+"', content='"+content+"' where id=" +id;
//执行更新方法
try{
num = db.executeUpdate(sql);
}
catch(Exception e){
out.println("数据库更新错误！");
}
//判断更新是否成功
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 + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -