📄 forum_article.java
字号:
package ec;import javax.servlet.*;import javax.servlet.http.*;import java.io.*;import java.util.*;import java.sql.*;public class forum_article extends HttpServlet { private static final String CONTENT_TYPE = "text/html; charset=GBK"; /**Initialize global variables*/ public void init() throws ServletException { String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver"; try { Class.forName(sDBDriver); } catch(java.lang.ClassNotFoundException e) { System.err.println( e.getMessage()); } } public ResultSet executeQuery(String sql) { String sConnStr = "jdbc:odbc:faq"; Connection connect = null; ResultSet rs = null; rs = null; try { connect = DriverManager.getConnection(sConnStr); Statement stmt = connect.createStatement(); rs = stmt.executeQuery(sql); } catch(SQLException ex) { System.err.println(ex.getMessage()); } return rs; } public String getStr(String str){ try { String temp_p=str; byte[] temp_t=temp_p.getBytes("GBK"); String temp=new String(temp_t,"ISO8859_1"); return temp; } catch(Exception e) { } return "null";} /**Process the HTTP Get request*/ public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType(CONTENT_TYPE); PrintWriter out = response.getWriter(); HttpSession session=request.getSession(true); out.println("<html>"); out.println("<head><title>forum_article</title></head>"); out.println("<body>"); out.println("<TABLE border=0 cellPadding=0 cellSpacing=0 width=760 align=\"center\">"); out.println("<TBODY>"); out.println(" <tr><td align=\"left\" height=25>当前位置：<a href=\"../ec/index.jsp\">首页</a> -> <a href=\"ec.forum_index\">论坛</a> </td>"); out.println(" </tr>"); out.println(" <TR bgColor=#3399ff>"); out.println(" <TD height=1 colspan=\"2\"><IMG height=1 src=\"images/spacer.gif\" "); out.println(" width=16></TD></TR>"); out.println(" <tr><td height=10 colspan=\"2\"><IMG height=1 src=\"images/spacer.gif\" "); out.println(" width=16></td></tr>"); out.println(" </TBODY></TABLE>"); out.println(" <table align=\"center\" border=\"0\" width=\"760\" cellspacing=\"0\" cellpadding=\"0\" height=\"355\">"); out.println(" <tr> "); out.println(" <td width=\"150\" height=\"355\" valign=\"top\"> "); out.println(" </td> "); out.println(" <td width=\"10\" height=\"100%\"></td>"); out.println(" <td width=\"1\" height=\"100%\" bgcolor=\"#3399ff\"></td>"); out.println(" <td width=\"10\" height=\"100%\"></td>"); out.println(" <td width=\"589\" height=\"331\" valign=\"top\" background=\"images/bg1.gif\">"); out.println(" <table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\"> "); out.println(" <tr> "); out.println(" <td colspan=\"3\" width=\"100%\" height=\"20\" bgcolor=\"#3399ff\"> <font color=\"#ffffff\">论坛 -> 详细查看</font>"); out.println(" </td>"); out.println(" </tr>"); out.println(" <tr>"); out.println(" <td align=\"center\" colspan='3' valign=\"top\">"); String id; id=request.getParameter("id"); String strSQL="SELECT * FROM topic where id="+id; ResultSet RSa = executeQuery(strSQL); //out.println(strSQL); try { while (RSa.next()) { String a_author; int topic_id; topic_id=RSa.getInt("id"); a_author=(RSa.getString("author")); out.print("<br><b><font color=red>"+(RSa.getString("title"))+"</font></b><br>"+a_author+" "+RSa.getDate("date")+"<br><br></td></tr><tr><td colspan='3' align='right'>"); if(a_author.equals(session.getValue("username"))) { out.print("<a href=ec.forum_edit?mode=topic&id="+topic_id+">编 辑</a> <a href=ec.forum_delete?mode=topic&id="+topic_id+">删 除</a> "); } out.print("<a href=ec.forum_reply?id="+id+">回 复</a> <a href=ec.forum_index>返 回</a></td></tr><tr><td colspan='3' height='1' bgcolor='#3399ff'></td></tr><tr><td width='5%'></td>"); out.print("<td><br>作者："+a_author+"<br><br>"); out.print((RSa.getString("content"))); } RSa.close(); } catch(Exception sqlEx) { System.err.println(sqlEx.getMessage()); } out.println("</td>"); out.println(" <td width=\"5%\"></td>"); out.println(" </tr>"); String strRe="SELECT * FROM reply where topicID="+id; ResultSet RSr = executeQuery(strRe); //out.println(strSQL); try { while (RSr.next()) { String a_author,t_id; t_id=RSr.getString("id"); a_author=getStr(RSr.getString("author")); out.println("<tr><td colspan='3' height='1' bgcolor='#3399ff'></td></tr>"); out.println("<tr><td colspan='3' align='right'>"); if(a_author.equals(session.getValue("username"))) { out.print("<a href=ec.forum_edit?mode=reply&id="+t_id+">编 辑</a> <a href=ec.forum_delete?mode=reply&id="+t_id+">删 除</a> "); } out.print("<a href=ec.forum_reply?id="+id+">回 复</a> <a href=ec.forum_index>返 回</a></td></tr>"); out.println("<tr><td align=center colspan='3' valign=top>"); out.print("<br><b>"+(RSr.getString("title"))+"</b><br>"+a_author+" "+RSr.getDate("date")+"<br><br></td></tr>"); out.print("<tr><td width='5%'></td>"); out.print("<td><br>作者："+a_author+"<br><br>"); out.print((RSr.getString("content"))); out.println("</td>"); out.println(" <td width=\"5%\"></td>"); out.println(" </tr>"); } RSr.close(); } catch(Exception sqlEx2) { System.err.println(sqlEx2.getMessage()); } out.println(" </table> "); out.println(" </td>"); out.println(" </tr>"); out.println(" </table>"); out.println("</body></html>"); } /**Clean up resources*/ public void destroy() { }}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -