📄 forum_edit_ok.java
字号:
package ec;import javax.servlet.*;import javax.servlet.http.*;import java.io.*;import java.util.*;import java.sql.*;public class forum_edit_ok 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"; }public static String returnToBr(String sStr) {if (sStr == null || sStr.equals("")) {return sStr;}StringBuffer sTmp = new StringBuffer();int i = 0;while (i <= sStr.length()-1) {if (sStr.charAt(i) == '\n'||sStr.charAt(i)=='\r') {sTmp = sTmp.append("<br>");} else if (sStr.charAt(i) == ' ') {sTmp = sTmp.append(" ");}else {sTmp = sTmp.append(sStr.substring(i,i+1));}i++;}String S1;S1=sTmp.toString();return S1;}public static String returnToHTML(String sStr) {if (sStr == null || sStr.equals("")) {return sStr;}StringBuffer sTmp1 = new StringBuffer();int i = 0;while (i <= sStr.length()-1) {if (sStr.charAt(i) == '<') {sTmp1 = sTmp1.append("<");} else if (sStr.charAt(i) == '>') {sTmp1 = sTmp1.append(">");}else {sTmp1 = sTmp1.append(sStr.substring(i,i+1));}i++;}String S2;S2=sTmp1.toString();return S2;} /**Process the HTTP Get request*/ public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType(CONTENT_TYPE); PrintWriter out = response.getWriter(); } /**Process the HTTP Post request*/ public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType(CONTENT_TYPE); PrintWriter out = response.getWriter(); HttpSession session=request.getSession(true); String title,author,content,aemail; title=returnToBr(returnToHTML(request.getParameter("title"))); author=returnToBr(returnToHTML(request.getParameter("author"))); content=returnToBr(returnToHTML(request.getParameter("content"))); aemail=returnToBr(returnToHTML(request.getParameter("aemail"))); if(aemail.equals("")){ aemail="null"; } title=getStr(title); author=getStr(author); content=getStr(content); aemail=getStr(aemail); String mode,id; id=request.getParameter("id"); mode=request.getParameter("mode"); if(mode.equals("topic")) { mode="topic"; } else { mode="reply"; } String sqlinsert="update "+mode+" set title='"+title+"',author='"+author+"',email='"+aemail+"',content='"+content+"' where id="+id; // out.println(sqlinsert); executeQuery(sqlinsert); out.println("<html>"); out.println("<head><title>forum_edit_ok</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> -> "); out.println("<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=\"post.jsp\">"); out.println(" <table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">"); out.println(" <tr><td colspan=\"3\" height=\"20\">你已经成功修改贴子 ，<a href=\"ec.forum_index\">返回</a>！ </td></tr>"); out.println(" </table>"); out.println(" </form>"); out.println(" </td>"); out.println(" </tr>"); 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 + -