selectaction.java

来自「实现一个J2EE上传功能完整的源代码」· Java 代码 · 共 80 行

package com.action;

import java.io.IOException;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;

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

import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.action.ActionMessage;
import org.apache.struts.action.ActionMessages;

import com.actionForm.UpFileForm;
import com.dao.DB;


public class SelectAction extends Action {
	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response)
			throws IOException, ServletException {
		String selectid = request.getParameter("selectid");
		String target = "upload";
		if (selectid == null || selectid.equals("")) {
			selectid = "up";
		}
		if (selectid.equals("up")) {
			target = "upload";
		}
		if (selectid.equals("down")) {
			target = "download";
			ResultSet rs = getRs();
			getListFiles(rs, request);
		}
		return mapping.findForward(target);
	}

	private ResultSet getRs() {
		DB db = new DB();
		String sql = "select*from b_file";
		ResultSet rs = db.seach(sql);
		return rs;
	}

	private void getListFiles(ResultSet rs, HttpServletRequest request) {
		ArrayList filelist = new ArrayList();
		try {
			if (rs.next()) {
				rs.previous();
				while (rs.next()) {
					UpFileForm upfile = new UpFileForm();
					upfile.setFid(rs.getInt("fid"));
					upfile.setFname(rs.getString("fname"));
					upfile.setFtype(rs.getString("ftype"));
					upfile.setFsize(rs.getInt("fsize"));
					upfile.setFinfo(rs.getString("finfo"));
					filelist.add(upfile);
				}
				HttpSession session = request.getSession();
				session.setAttribute("downlist", filelist);
			} else {
				ActionMessages messages = new ActionMessages();
				messages.add("noanyfile",
						new ActionMessage("file.sql.nofile.e"));
				saveErrors(request, messages);

			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}

}