📄 updatenews.java
字号:
package mypackage;
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.PrintWriter;
import java.io.IOException;
import java.sql.*;
public class UpdateNews 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 content = null;
String date = null;
String sql = null;
ConnectionDB db = null;
ResultSet rs = null;
//输出HTML头
out.println("<html>");
out.println("<head><title>UpdateNews</title></head>");
out.println("<body>");
out.println("<div align=center><font color=#FF0000 size=6 face=隶书>新闻发布系统</font></div>");
//变量赋值
id = request.getParameter("id");
sql = "select * from news where id="+id;
db = new ConnectionDB();
rs = db.executeQuery(sql);
//将游标置于结果集第一个结果位置
try{
rs.next();
}
catch(Exception e){
System.out.println(e.getMessage());
}
//输出HTML表单
out.println("<table width=59% border=0 align=center cellpadding=2 cellspacing=1 bgcolor=#999999>");
out.println("<form action=UpdateNewsSave method=post name=form>");
out.println("<tr>");
out.println("<td width=79% bgcolor=#FFFFFF>>>更新新闻:</td>");
out.println("<td width=21% height=23 align=left bgcolor=#FFFFFF>");
out.println("<a href=Admin>管理首页</a>-<a href=NewsList>新闻首页</a></td>");
out.println("</tr>");
out.println("<tr>");
out.println("<td height=16 bgcolor=#FFFFFF>标题:</td>");
out.println("<td height=16 bgcolor=#FFFFFF>");
//取出查询结果
try{
title = rs.getString("title");
out.println("<input name=title type=text size=30 value='"+title+"'>");
}
catch(Exception e){
System.out.println(e.getMessage());
}
out.println("</td>");
out.println("</tr>");
out.println("<tr>");
out.println("<td bgcolor=#FFFFFF width=104 height=58>内容:</td>");
out.println("<td bgcolor=#FFFFFF width=471 valign=middle height=58>");
out.println("<table width=98% border=0 cellspacing=0 cellpadding=0>");
out.println("<tr>");
out.println("<td width=70% height=59><textarea name=content cols=60 rows=15>");
try{
content = rs.getString("content");
out.println(content);
}
catch(Exception e){
System.out.println(e.getMessage());
}
out.println("</textarea></td>");
out.println("</tr>");
out.println("</table></td>");
out.println("</tr>");
out.println("<tr align=center>");
out.println("<td colspan=2 bgcolor=#FFFFFF><input name=Submit type=submit value=更新> <input name=Submit1 type=reset value=重置></td>");
out.println("</tr>");
out.println("<input name=id type=hidden value='"+id+"'>");
out.println("</form>");
out.println("</table>");
out.println("</body></html>");
out.close();
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -