📄 forum_delete.java

📁 jsp 应用开发详解源代码电子工业出版社包含书中个源代码

💻 JAVA

字号:

package ec;import javax.servlet.*;import javax.servlet.http.*;import java.io.*;import java.util.*;import java.sql.*;public class forum_delete 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();    out.println("<html>");    out.println("<head><title>forum_delete</title></head>");    out.println("<body>");    out.println("<p>The servlet has received a get. This is the reply.</p>");    out.println("</body></html>");    String mode,id;    id=request.getParameter("id");    mode=request.getParameter("mode");    if(mode.equals("topic"))    {            mode="topic";    }    else    {            mode="reply";    }    String sql="delete from "+mode+" where id="+id;	//	out.println(sqlinsert);    executeQuery(sql);    response.sendRedirect("ec.forum_index");  }  /**Process the HTTP Post request*/  public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {    response.setContentType(CONTENT_TYPE);    PrintWriter out = response.getWriter();    out.println("<html>");    out.println("<head><title>forum_delete</title></head>");    out.println("<body>");    out.println("<p>The servlet has received a Post. This is the reply.</p>");    out.println("</body></html>");    String mode,id;  }  /**Clean up resources*/  public void destroy() {  }}

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -