?? newsdetail.java
字號:
package mypackage;
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.PrintWriter;
import java.io.IOException;
import java.sql.*;
public class NewsDetail 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 title = null;
String date = null;
String content = null;
String id = request.getParameter("id");
String sql = "select * from news where id="+id;
ConnectionDB db = new ConnectionDB();
ResultSet rs = db.executeQuery(sql);
//將游標置于結果集第一個結果位置
try{
rs.next();
}
catch(Exception e){
System.out.println(e.getMessage());
}
out.println("<html>");
out.println("<head><title>NewsDetail</title></head>");
out.println("<body>");
out.println("<table width=75% height=420 border=0 align=center cellpadding=0 cellspacing=1 bgcolor=#999999>");
out.println("<tr>");
out.println("<td height=28 bgcolor=#FFFFFF align=center><b>");
//取出查詢字段
try{
title = rs.getString("title");
out.println(title);
}
catch(Exception e){
System.out.println(e.getMessage());
}
out.println("</b></td>");
out.println("</tr>");
out.println("<tr>");
out.println("<td height=361 valign=top bgcolor=#FFFFFF>");
try{
content = rs.getString("content");
out.println(content);
}
catch(Exception e){
System.out.println(e.getMessage());
}
out.println("</td>");
out.println("</tr>");
out.println("<tr>");
out.println("<td align=right bgcolor=#FFFFFF><font size=2>發布時間：");
try{
date = rs.getString("addtime");
out.println(date);
}
catch(Exception e){
System.out.println(e.getMessage());
}
//顯式關閉連接
db.CloseDataBase();
out.println("</font></td>");
out.println("</tr>");
out.println("</table>");
out.println("</body></html>");
out.close();
}
}?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -