deleteaction.java

用JSP+MySQL+Struts写的简单的留言版

package onlyfun.caterpillar;
        
import java.sql.*;
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;
import org.apache.struts.action.*;
import org.apache.commons.beanutils.*;
                                                                               
public class DeleteAction extends Action {
    public ActionForward execute(ActionMapping mapping,
                                 ActionForm form,
                                 HttpServletRequest request,
                                 HttpServletResponse response)
    throws Exception {
        if(request.getSession().getAttribute("user").toString().equals("admin")) {

            Class.forName("com.mysql.jdbc.Driver");
            String sqluri = "jdbc:mysql://localhost:3306/GUESTBOOK?useUnicode=true&characterEncoding=big5";
            String sqluser = servlet.getServletContext().getInitParameter("sqluser");
            String sqlpwd = servlet.getServletContext().getInitParameter("sqlpwd");
            Connection conn = DriverManager.getConnection(sqluri, sqluser, sqlpwd);
            Enumeration params = request.getParameterNames();
            Statement stmt = conn.createStatement();
            while(params.hasMoreElements()) {
                String param = (String) params.nextElement();
                String sql = "DELETE FROM message WHERE id=" + param;
                stmt.executeUpdate(sql);
            }
            conn.close();
        }
        return mapping.findForward("showmessage");
    }
}