?? updatenews.java
字號(hào):
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=隸書(shū)>新聞發(fā)布系統(tǒng)</font></div>");
//變量賦值
id = request.getParameter("id");
sql = "select * from news where id="+id;
db = new ConnectionDB();
rs = db.executeQuery(sql);
//將游標(biāo)置于結(jié)果集第一個(gè)結(jié)果位置
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>管理首頁(yè)</a>-<a href=NewsList>新聞首頁(yè)</a></td>");
out.println("</tr>");
out.println("<tr>");
out.println("<td height=16 bgcolor=#FFFFFF>標(biāo)題：</td>");
out.println("<td height=16 bgcolor=#FFFFFF>");
//取出查詢(xún)結(jié)果
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>內(nèi)容：</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();
}
}?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -