staffmanage.java

JAVA编写的单击的PIZZA店销售系统

package Staff;
import Dbprocess.*;
import java.sql.*;
import java.util.ArrayList;
import java.util.List;

public class Staffmanage {
	List staffs = new ArrayList();
	List staffsent;
	public Staffmanage() {
		super();
		try{
			DBmanager dbm = new DBmanager();
			Connection con = dbm.getCon();
			Statement state = con.createStatement();
			ResultSet rs= state.executeQuery("Select staffid,name From staff");
			while(rs.next()){
				Staff temp = new Staff();
				temp.setStaffid(rs.getString("staffid"));
				temp.setName(rs.getString("name"));
				temp.setWage(0);
				temp.setTimes(0);
				staffs.add(temp);		
			}
			state.close();
			}catch(Exception e) {
		        e.printStackTrace();
			}
			
	}
	
	public void addwage(String staffid,int wageadd){
		int i;
		for(i=0;i<staffs.size();i++){
			if(((Staff)staffs.get(i)).getStaffid().equals(staffid)){
				((Staff)staffs.get(i)).setWage(((Staff)staffs.get(i)).getWage()+wageadd);
			}
		}
	}
	public List getStaffWage(){
		List staffwage = new ArrayList();
		try{
			DBmanager dbm = new DBmanager();
			Connection con = dbm.getCon();
			Statement state = con.createStatement();
			ResultSet rs= state.executeQuery("Select staffid,name From staff");
			while(rs.next()){
				Staff temp = new Staff();
				temp.setStaffid(rs.getString("staffid"));
				temp.setName(rs.getString("name"));
				Statement state2 = con.createStatement();
				ResultSet rs2= state2.executeQuery("Select staffid,Count(*) AS times,SUM(wage) AS totalwage From staffsent Group by staffid");
				while(rs2.next()){
					if(rs.getString("staffid").equals(rs2.getString("staffid")))
					{
						temp.setWage(rs2.getInt("totalwage"));
						temp.setTimes(rs2.getInt("times"));
					}
						
				}
				staffwage.add(temp);	
			}
			state.close();
			
		}catch(Exception e) {
	        e.printStackTrace();
	        return staffwage;
		}
		return staffwage;
	}
	
	public List getStaffSent(){
		try{
			staffsent= new ArrayList();
			DBmanager dbm = new DBmanager();
			Connection con = dbm.getCon();
			Statement state = con.createStatement();
			ResultSet rs= state.executeQuery("Select saleid,staffid,senttime From staffsent Where backtime is null Order by senttime");
				while(rs.next()){
					StaffSent temp = new StaffSent();
					temp.setSaleid(rs.getString("saleid"));
					temp.setStaffid(rs.getString("staffid"));
					temp.setSenttime(rs.getTimestamp("senttime"));		
					staffsent.add(temp);		
				}
			dbm.close();
			}catch(Exception e) {
		        e.printStackTrace();
		        return staffsent;
			}
			return staffsent;
	}
	/**
	 * Getting and Setting.
	 * @return
	 */
	public List getStaffs() {
		return staffs;
	}
	public void setStaffs(List staffs) {
		this.staffs = staffs;
	}

	
	
	
}