java SSH 超市后台管理系统

package com.bzu.action; //Download by http://www.codefans.net import java.text.SimpleDateFormat; import java.util.Date; import java.util.Iterator; import java.util.List; import java.util.Map; import javax.servlet.http.HttpSession; import org.apache.struts2.ServletActionContext; import com.bzu.entity.Employer; import com.bzu.entity.EmployerWage; import com.bzu.entity.GoodsSpend; import com.bzu.entity.IntoGoods; import com.bzu.service.inter.EmployerService; import com.bzu.service.inter.EmployerWageService; import com.bzu.service.inter.IntoGoodsService; import com.bzu.service.inter.WorkdayService; import com.bzu.util.ToolMethodUtil; import com.opensymphony.xwork2.ActionSupport; public class EmployerWageAction extends ActionSupport { private EmployerWage employerWage; private EmployerWageService employerWageService; private IntoGoodsService intoGoodsService; private Double beginWage; private Double endWage; private int index; public String employerWageList() { String hql = ""; if (employerWage != null) { if (employerWage.getEmployer().getId() != -1) hql += " and s.employer.id = " + employerWage.getEmployer().getId(); if (beginWage != null && endWage != null) hql += " and s.wage between " + beginWage + " and " + endWage + ""; } List<EmployerWage> list = index != 0 ? employerWageService.getByPage( index, EmployerWage.class, hql) : employerWageService .getByPage(1, EmployerWage.class, hql); HttpSession session = ServletActionContext.getRequest().getSession(); session.setAttribute("list", list); session.setAttribute("thisindex", index == 0 ? 1 : index); session.setAttribute("count", employerWageService.getAllEmployerWage( EmployerWage.class, hql).size()); Map<Integer, String> map = employerWageService.getAllEmployer( Employer.class, ""); ServletActionContext.getRequest().setAttribute("map", map); return "employerWageList"; } private EmployerService employerService; private WorkdayService workdayService; public String createWage() { List<Employer> emplist = employerService.getAllEmployer(Employer.class, "");// 获得所有的员工 // List<EmployerWage> wagelist=new ArrayList<EmployerWage>(); String months = ToolMethodUtil.getYearAndMonth(); String num = ((List) (employerWageService .getInfo("select count(*) from EmployerWage e where e.months='" + months + "'"))).get(0).toString(); if (Integer.parseInt(num) != 0) return "createWageSuccess"; for (Iterator iterator = emplist.iterator(); iterator.hasNext();) {// 遍历所有的员工，通过他们的id获得到他们的月薪 Employer employer = (Employer) iterator.next(); double monthpay = employer.getMonthpay(); int workday = workdayService.getWorkday(employer.getId()); Double dempWage = (monthpay * (((float) workday) / 30)); int empWage = dempWage.intValue(); EmployerWage employerWage = new EmployerWage(employer, months, empWage); employerWageService.addempWage(employerWage); // wagelist.add(employerWage); } return "createWageSuccess"; } public String createGoodsSpend() { String date = ToolMethodUtil.getDate(); String num = ((List) (employerWageService//getInfo方法就是通过hql语句获得list的集合,这里是查询物品消费表里面是否有本月的记录 .getInfo("select count(*) from GoodsSpend g where month(g.intoGoods.intoDate)=month('" + date + "')"))).get(0).toString(); System.out.println(num); if (Integer.parseInt(num) != 0) return "createWageSuccess"; List<IntoGoods> inglist=intoGoodsService.getAllIntoGoods(IntoGoods.class, " and month(s.intoDate)=month('" + date + "')");//获得所有本月的进货记录 for (Iterator iterator = inglist.iterator(); iterator.hasNext();) { IntoGoods intoGoods = (IntoGoods) iterator.next(); double money=intoGoods.getNum()*intoGoods.getGoods().getInputPrise(); GoodsSpend goodSpend=new GoodsSpend(intoGoods, money); intoGoodsService.addGoodsSpend(goodSpend); } return "createWageSuccess";//创建货物花费金额成功，为了少写一个result，就直接返回createWageSuccess。 } public String goodsSpendList(){ String date = ToolMethodUtil.getDate(); List<GoodsSpend> list=intoGoodsService.getGoodsSpendList(GoodsSpend.class, "and month(s.intoGoods.intoDate)=month('"+date + "')"); HttpSession session = ServletActionContext.getRequest().getSession(); session.setAttribute("spendlist", list); return "spendlist"; } public WorkdayService getWorkdayService() { return workdayService; } public void setWorkdayService(WorkdayService workdayService) { this.workdayService = workdayService; } public EmployerService getEmployerService() { return employerService; } public void setEmployerService(EmployerService employerService) { this.employerService = employerService; } public Double getBeginWage() { return beginWage; } public void setBeginWage(Double beginWage) { this.beginWage = beginWage; } public Double getEndWage() { return endWage; } public void setEndWage(Double endWage) { this.endWage = endWage; } public int getIndex() { return index; } public void setIndex(int index) { this.index = index; } public EmployerWageService getEmployerWageService() { return employerWageService; } public void setEmployerWageService(EmployerWageService employerWageService) { this.employerWageService = employerWageService; } public EmployerWage getEmployerWage() { return employerWage; } public void setEmployerWage(EmployerWage employerWage) { this.employerWage = employerWage; } public IntoGoodsService getIntoGoodsService() { return intoGoodsService; } public void setIntoGoodsService(IntoGoodsService intoGoodsService) { this.intoGoodsService = intoGoodsService; } public static void main(String[] args) { Date date = new Date(System.currentTimeMillis()); SimpleDateFormat format = new SimpleDateFormat("yy-MM-dd"); String date1 = format.format(date); System.out.println(date1); // System.out.println("20" + date1.substring(0, date1.indexOf("-"))); System.out.println(date1.substring(date1.indexOf("-") + 1, date1 .indexOf("-") + 3)); } }