storagemanager.java

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

package Storage;
import Dbprocess.*;
import java.sql.*;
import java.util.ArrayList;
import java.util.List;
import java.util.Date;

public class StorageManager {
	List storages;
	
	public List getStorageRecord(){
		try{
			storages= new ArrayList();
			DBmanager dbm = new DBmanager();
			Connection con = dbm.getCon();
			Statement state = con.createStatement();
			ResultSet rs= state.executeQuery("Select name,type,size,quantity From storage");
			while(rs.next()){
				StorageItem temp = new StorageItem();
				temp.setName(rs.getString("name"));
				temp.setType(rs.getString("type"));		
				temp.setSize(rs.getString("size"));
				temp.setQuantity(rs.getInt("quantity"));
				storages.add(temp);		
			}
			}catch(Exception e) {
		        e.printStackTrace();
		        return storages;
			}
			return storages;		
	}
	
	public List getStorageWarnning(){
		try{
			storages= new ArrayList();
			DBmanager dbm = new DBmanager();
			Connection con = dbm.getCon();
			Statement state = con.createStatement();
			ResultSet rs= state.executeQuery("Select name,type,size,quantity From storage WHERE quantity<10");
			while(rs.next()){
				StorageItem temp = new StorageItem();
				temp.setName(rs.getString("name"));
				temp.setType(rs.getString("type"));		
				temp.setSize(rs.getString("size"));
				temp.setQuantity(rs.getInt("quantity"));
				storages.add(temp);		
			}
			}catch(Exception e) {
		        e.printStackTrace();
		        return storages;
			}
			return storages;		
	}
	
	public List getBalance(){
		try{
			storages= new ArrayList();
			DBmanager dbm = new DBmanager();
			Connection con = dbm.getCon();
			Statement state = con.createStatement();
			String sql = "Select name,type,Count(*) as totalquantity From pizzasaled WHERE begintime BETWEEN ? AND ? GROUP BY name,type";
			PreparedStatement ps = con.prepareStatement(sql);
			Date date= new Date();
			Timestamp ts = new Timestamp(date.getTime());
			Timestamp ts2 = new Timestamp(date.getTime()-(date.getHours()*60*60+date.getMinutes()*60+date.getSeconds())*1000);
			ps.setTimestamp(1, ts2);
			ps.setTimestamp(2, ts);
			ResultSet rs = ps.executeQuery();
			//	ResultSet rs= state.executeQuery("Select name,type,Count(*) as totalquantity,begintime From pizzasaled GROUP BY name,type");
			while(rs.next()){
			/*	Timestamp ts = rs.getTimestamp("begintime");
				Date date= new Date();
				Timestamp ts2 = new Timestamp(date.getTime());
				if(ts.getDate()==ts2.getDate()){*/
					StorageItem temp = new StorageItem();
					temp.setName(rs.getString("name"));
					temp.setType(rs.getString("type"));		
					temp.setQuantity(rs.getInt("totalquantity"));
					storages.add(temp);	
				//}
			}
			dbm.close();
			}catch(Exception e) {
		        e.printStackTrace();
		        return storages;
			}
			return storages;		
	}
}