useraction.java

图书馆管理系统 能满足 查询

package com.jxyd.action.admin;

import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.GregorianCalendar;
import java.util.List;

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

import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.actions.DispatchAction;

import com.jxyd.common.Char;
import com.jxyd.common.Fenye;
import com.jxyd.dao.AdminDAO;
import com.jxyd.dao.UserDAO;
import com.jxyd.sql.AccessDBConn;
import com.jxyd.vo.LendBean;
import com.jxyd.vo.UserBean;

public class UserAction extends DispatchAction {
	public ActionForward Adduserpage(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		if (request.getSession().getAttribute("loginfoA") == null) {
			return new ActionForward("/login.jsp");
		}
		return mapping.findForward("adduserpage");// 点击添加读者时的跳转页面
	}

	/**
	 * 添加读者
	 * 
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return
	 */
	public ActionForward AddUser(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		String name = request.getParameter("name").trim();
		String userId = request.getParameter("userId").trim();
		String unit =request.getParameter("unit").trim();
		
		System.out.println("=========="+unit);
		
		Integer age = Integer.parseInt(request.getParameter("age").trim());
		String code = request.getParameter("code").trim();
		String adddate = request.getParameter("adddate");
		Integer sign = Integer.parseInt(request.getParameter("sign"));
		String mark =request.getParameter("mark").trim();
		Double yj = Double.valueOf(request.getParameter("yj"));
		Integer sex = Integer.parseInt(request.getParameter("sex"));
		String mphone = request.getParameter("mphone");

		UserBean ub = new UserBean();
		ub.setName(name);
		ub.setUserId(userId);
		ub.setUnit(unit);
		ub.setAge(age);
		ub.setBarCode(code);
		ub.setAddDate(adddate);
		ub.setSign(sign);
		ub.setYJ(yj);
		ub.setMark(mark);
		ub.setPassword(userId);
		ub.setSex(sex);
		ub.setMphone(mphone);

		if (sign == 1) {
			ub.setLimitLendNum(10);
			ub.setLimitlendTime(90);
		} else if (sign == 2) {
			ub.setLimitLendNum(5);
			ub.setLimitlendTime(60);
		}

		UserDAO udao = new UserDAO();
		boolean flag = udao.AddUer(ub);
		if (flag) {
			return mapping.findForward("selectuser");
		}
		return null;
	}

	/**
	 * 查询显示所有读者
	 * 
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return
	 */
	public ActionForward SelectUser(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {

		if (request.getSession().getAttribute("loginfoA") == null) {
			return new ActionForward("/login.jsp");
		}
		String sv = request.getParameter("select");
		String user = request.getParameter("user");
		UserDAO udao = new UserDAO();

		Fenye fenye = new Fenye();
		fenye.setPageSize(15);
		fenye.init(request, "muser.do", null, udao.count(user, sv), "p", 3);
		ArrayList<?> list = null;

		list = udao.SelectAllBook(fenye.getStart(), fenye.getPageSize(), user,
				sv);// 图书查询
		request.setAttribute("user", list);
		request.setAttribute("fenye", fenye);

		return mapping.findForward("alluserpage");
	}

	public ActionForward EditeUser(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		String usrcode = request.getParameter("usercode");
		UserDAO udao = new UserDAO();
		UserBean ub = udao.SelectUserByUId(usrcode);
		request.setAttribute("ub", ub);
		return mapping.findForward("editeuser");
	}

	public ActionForward DeleteUser(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		Integer id = Integer.parseInt(request.getParameter("userid"));
		UserDAO udao = new UserDAO();
		udao.DeleteUser(id);
		return new ActionForward("/muser.do?method=SelectUser");
	}

	/**
	 * 显示要到期的读者 查询全部的借出信息，并将快要到期的状态设置为1，
	 * 
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return
	 */
	public ActionForward SelectOverDateUser(ActionMapping mapping,
			ActionForm form, HttpServletRequest request,
			HttpServletResponse response) {
		UserDAO ud = new UserDAO();
		ArrayList<LendBean> list = ud.SelectAllLent(null, null, null);
		System.out.println("==========" + list.size());
		for (LendBean ld : list) {
			String shoureturndate = ld.getShouldReturnDate();
			GregorianCalendar now = new GregorianCalendar();
			SimpleDateFormat f = new SimpleDateFormat("yyyy-MM-dd");
			String nowdate = f.format(now.getTime());
			try {
				Date t1 = f.parse(shoureturndate);
				Date t2 = f.parse(nowdate);
				Integer remaindate = Integer.valueOf((int) ((t1.getTime() - t2
						.getTime()) / (1000 * 60 * 60 * 24)));// 查询将要超期的读者
				if (remaindate <= 3) {
					if (ld.getRemain() == 0) {// 判断该读者是不是被提醒过，若为0表示还没被提醒过
						System.out.println("**************" + ld.getRemain());
						ld.setRemain(1);
						ud.Updateremain(ld.getId(), ld.getRemain());
					}
				}
			} catch (ParseException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		List<LendBean> dlist = new ArrayList<LendBean>();
		Fenye fenye = new Fenye();
		fenye.setPageSize(15);
		fenye.init(request, "muser.do", null, ud.count(), "p", 3);
		dlist = ud.SelectAllLent(fenye.getStart(), fenye.getPageSize(), 1);// 查询全部需要提醒的读者

		if (!dlist.isEmpty()) {
			request.getSession().setAttribute("lend", dlist);
			request.setAttribute("lend", dlist);
			request.setAttribute("fenye", fenye);
		} else {
			request.setAttribute("error", "	<script language=JavaScript>alert("
					+ "'没有过期要提醒的读者！'" + ");</script>");
		}

		return mapping.findForward("overdateuser");
	}

	/**
	 * 发出到期提醒
	 * 
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return
	 */
	public ActionForward RemindOverDateUser(ActionMapping mapping,
			ActionForm form, HttpServletRequest request,
			HttpServletResponse response) {
		List<LendBean> list = (List) request.getSession().getAttribute("lend");
		UserDAO ud = new UserDAO();
		AccessDBConn conn = new AccessDBConn();
		if (list!=null) {
			for (LendBean ld : list) {
				UserBean ub = ud.SelectUserByUId(ld.getUserId());// 根据读者借阅证号返回读者信息
				conn.executeUpdate(ub.getName(), ub.getMphone(), "您好，您于"
						+ ld.getLendDate() + "从图书馆借出的" + ld.getBookName()
						+ "将于" + ld.getShouldReturnDate() + "到期，请即使归还！");
				ud.Updateremain(ld.getId(), 2);
			}

			request.setAttribute("error", "	<script language=JavaScript>alert("
					+ "'短信提醒已经发出！！'" + ");</script>");
		}

		List<LendBean> dlist = new ArrayList<LendBean>();
		Fenye fenye = new Fenye();
		fenye.setPageSize(15);
		fenye.init(request, "muser.do", null, ud.count(), "p", 3);
		dlist = ud.SelectAllLent(fenye.getStart(), fenye.getPageSize(), 1);// 查询全部需要提醒的读者

		if (!dlist.isEmpty()) {
			request.getSession().setAttribute("lend", dlist);
			request.setAttribute("lend", dlist);
			request.setAttribute("fenye", fenye);
		} else {
			request.setAttribute("error", "	<script language=JavaScript>alert("
					+ "'没有过期要提醒的读者！'" + ");</script>");
		}

		return mapping.findForward("overdateuser");
	}

}