managerdeleteservlet.java

图片管理功能：图片的上载及下载

package servlets;

import beans.DataBean;

import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.ServletException;
import java.io.IOException;
import java.io.File;
import java.util.ArrayList;
import java.sql.ResultSet;

/**
 * Created by IntelliJ IDEA.
 * User: Administrator
 * Date: 2006-6-27
 * Time: 9:31:57
 * To change this template use File | Settings | File Templates.
 */
public class ManagerDeleteServlet extends HttpServlet {
       public void doGet(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException {
        req.setCharacterEncoding("GBK");
        res.setContentType("text/html");
        ArrayList picids = new ArrayList();
        String sql = "select pos from pictures where ";
        String delsql = "delete from pictures where ";
        String sqltemp = "";
        String[] picid = req.getParameterValues("picdelete");
        for(int i = 0 ;i < picid.length ;i ++){

            picids.add( Integer.parseInt(picid[i]))  ;
            if(i == 0)
                sqltemp = sqltemp+"id="+Integer.parseInt(picid[i]);
            else
                sqltemp = sqltemp+" or id="+Integer.parseInt(picid[i]);
        }
        sql = sql + sqltemp;
        DataBean db = new DataBean();
          try{
              ResultSet del =  db.selectObj(sql);
              while(del.next() ){
                 String d = del.getString(1);
                 File f=new File( del.getString(1));
                 if(f.exists()){
                    f.delete();
                 }
             }
        }catch(Exception e){
            e.getMessage() ;
          }
        try{
            db.insertObj(delsql+sqltemp);
        }catch(Exception e){
            e.getMessage() ;
        }
         res.sendRedirect("/managerindex.jsp");
      }
       public void doPost(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException{
       doGet(req,res);
    }
}