sortdel.java

仓库管理系统,适合各种行业的仓库管理系统

package com.sort.action;

import java.io.IOException;
import java.sql.Connection;
import java.sql.SQLException;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.bean.DAO.ProductDAO;
import com.bean.DAO.ProductsortDAO;
import com.bean.DTO.UserinforDTO;
import com.database.DataSourceFactory;
import com.servlet.AbstractAction;
import com.system.action.popedomCheck;

public class sortDel extends AbstractAction {

	public String process(HttpServletRequest request,
			HttpServletResponse response) throws ServletException, IOException {
		String url="sortList.do";
		UserinforDTO udt = (UserinforDTO) request.getSession().getAttribute(
				"userinfor");
		popedomCheck pc = new popedomCheck(udt);
		if (pc.adminCheck()) {
			Connection con;
			try {
				con = DataSourceFactory.getDataSource().getConnection();
				ProductsortDAO ps = new ProductsortDAO();
				ProductDAO pd = new ProductDAO();
				String str[] = request.getParameterValues("checkbox");

				for (int i = 0; i < str.length; i++) {
					ps.Delproductsort(Integer.parseInt(str[i]), con);
					pd.updsort(Integer.parseInt(str[i]), con);
				}
				con.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		} else {
			url = "User/login.jsp";
		}
		return url;
	}

}