📄 forum_edit.java
字号:
package ec;import javax.servlet.*;import javax.servlet.http.*;import java.io.*;import java.util.*;import java.sql.*;public class forum_edit 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("ISO8859-1"); String temp=new String(temp_t); 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); if(session.getAttribute("username")==null) { response.sendRedirect("ec.chat_login?url="+request.getRequestURI()); } out.println("<html>"); out.println("<head><title>forum_edit</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>"); if(session.getAttribute("username")!=null) { out.println(session.getAttribute("username")); } out.println("当前位置：<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\" height=\"307\"> "); out.println(" <tr> "); out.println(" <td width=\"100%\" height=\"20\" bgcolor=\"#3399ff\"> <font color=\"#ffffff\">修改贴子</font>"); out.println(" </td>"); out.println(" </tr>"); out.println(" <tr>"); out.println(" <td>"); out.println(" <form name=\"form1\" method=\"post\" action=\"ec.forum_edit_ok\">"); out.println(" <table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">"); out.println(" <tr><td colspan=\"3\" height=\"20\"></td></tr>"); out.println(" <tr> "); out.println(" <td align=\"right\" width=\"120\" valign=\"top\">说明：</td>"); out.println(" <td width=\"20\"> </td>"); out.println(" <td width=\"450\">"); out.println(" <ul type=\"square\">"); out.println(" <li>不支持HTML，请用文本格式。所有输入的HTML标记，都会被还原！</li>"); out.println(""); out.println(" </ul>"); out.println(" </td>"); out.println(" </tr>"); String id,mode; id=request.getParameter("id"); mode=request.getParameter("mode"); if(mode.equals("topic")) { mode="topic"; } else { mode="reply"; } String strSQL="SELECT * FROM "+mode+" where id="+id; ResultSet RSa = executeQuery(strSQL); //out.println(strSQL); try { while (RSa.next()) { String a_author,title,aemail,content; a_author=(RSa.getString("author")); title=(RSa.getString("title")); aemail=(RSa.getString("email")); content=(RSa.getString("content")); out.println("<tr> "); out.println("<td align=\"right\">标题：</td>"); out.println(" <td width=\"20\">*</td>"); out.println(" <td width=\"500\"> "); out.println(" <input type=\"hidden\" name=\"id\" value=\""+id+"\">"); out.println(" <input type=\"hidden\" name=\"mode\" value=\""+mode+"\">"); out.println(" <input type=\"text\" name=\"title\" size=\"64\" value=\""+title+"\">"); out.println(" </td>"); out.println(" </tr>"); out.println(" <tr> "); out.println(" <td align=\"right\">作者：</td>"); out.println(" <td width=\"20\">*</td>"); out.println(" <td width=\"500\"> "); out.println(" <input type=\"text\" name=\"author\" size=\"64\" value=\""+session.getValue("username")+"\" readonly>"); out.println(" </td>"); out.println(" </tr>"); out.println(" <tr> "); out.println(" <td align=\"right\">作者的电子邮件：</td>"); out.println(" <td width=\"20\"> </td>"); out.println(" <td width=\"500\"> "); out.println(" <input type=\"text\" name=\"aemail\" size=\"64\" value=\""+aemail+"\">"); out.println(" </td>"); out.println(" </tr>"); out.println(" <tr> "); out.println(" <td align=\"right\" valign=\"top\">内容：</td>"); out.println(" <td width=\"20\" valign=\"top\">*</td>"); out.println(" <td>"); out.println(" <textarea name=\"content\" cols=\"64\" rows=\"8\">"+content+"</textarea>"); out.println(" </td>"); out.println(" </tr>"); out.println(" <tr> "); out.println(" <td align=\"right\"> </td>"); out.println(" <td width=\"20\"> </td>"); out.println(" <td align=\"right\">"); out.println(" <input type=\"button\" name=\"post\" value=\"张贴\" onclick=\"sub()\">"); out.println(" </td>"); out.println(" </tr>"); out.println("</table>"); out.println("</form>"); } RSa.close(); } catch(Exception sqlEx) { System.err.println(sqlEx.getMessage()); } out.println("</td>"); out.println(" </tr>"); out.println(" </table>"); out.println(" <script language=\"javascript\">"); out.println(" function sub()"); out.println(" {"); out.println(" if(document.form1.title.value==\"\")"); out.println(" {"); out.println(" window.alert(\"请输入文章标题！\");"); out.println(" document.form1.title.focus();"); out.println(" return false;"); out.println(" }"); out.println(" if(document.form1.author.value==\"\")"); out.println(" {"); out.println(" window.alert(\"请输入作者姓名！\");"); out.println(" document.form1.author.focus();"); out.println(" return false;"); out.println(" }"); out.println(" if(document.form1.content.value==\"\")"); out.println(" {"); out.println(" window.alert(\"请输入文章内容！\");"); out.println(" document.form1.content.focus();"); out.println(" return false;"); out.println(" }"); out.println(" document.form1.submit();"); out.println(" }"); out.println(" </script>"); out.println(" </td>"); out.println(" </tr>"); out.println(" </table>"); out.println("</body></html>"); } /**Process the HTTP Post request*/ public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType(CONTENT_TYPE); PrintWriter out = response.getWriter(); } /**Clean up resources*/ public void destroy() { }}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -