pizzafactory.java

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

package PizzaProduct;
import java.util.*;
import Dbprocess.*;
import java.sql.*;
import java.util.Date;


public class PizzaFactory {
	List pizzas;
	boolean orderfinish=false;
	
	public List getUndoPizzas(){
		try{
		pizzas= new ArrayList();
		DBmanager dbm = new DBmanager();
		Connection con = dbm.getCon();
		Statement state = con.createStatement();
		ResultSet rs= state.executeQuery("Select pizzaid,name,type,size,topping,begintime From pizzasaled Where finishtime is null Order by begintime");
		while(rs.next()){
			Pizza temp = new Pizza();
			temp.setPizzaid(rs.getString("pizzaid"));
			temp.setName(rs.getString("name"));
			temp.setType(rs.getString("type"));		
			temp.setSize(rs.getString("size"));
			temp.setTopping(rs.getString("topping"));
			temp.setBegintime(rs.getTimestamp("begintime"));
			pizzas.add(temp);		
		}
		}catch(Exception e) {
	        e.printStackTrace();
	        return pizzas;
		}
		return pizzas;
	}
	
	public void finishPizza(Pizza[] pizzas){
		try{
			DBmanager dbm = new DBmanager();
			Connection con = dbm.getCon();
			Date date= new Date();
			Timestamp ts = new Timestamp(date.getTime());
			String sql = "Update pizzasaled set finishtime=? where name like ? AND type like ? AND size like ? AND topping like ?";
			PreparedStatement pstate = con.prepareStatement(sql);
			int i;
			for(i=0;i<pizzas.length;i++){
				pstate.setTimestamp(1,ts);
				pstate.setString(2,pizzas[i].getName());
				pstate.setString(3,pizzas[i].getType());
				pstate.setString(4,pizzas[i].getSize());
				pstate.setString(5,pizzas[i].getTopping());
				pstate.executeUpdate();
			}
		}catch (Exception e) {
		         e.printStackTrace();
		}
	}
	public void finishPizza(String[] pid){
		try{
			orderfinish =false;
			DBmanager dbm = new DBmanager();
			Connection con = dbm.getCon();
			Date date= new Date();
			Timestamp ts = new Timestamp(date.getTime());
			String sql = "Update pizzasaled set finishtime=? where pizzaid like ?";
			PreparedStatement pstate = con.prepareStatement(sql);
			String sql2 = "SELECT * FROM pizzasaled WHERE finishtime is null AND saleid IN (SELECT saleid FROM pizzasaled WHERE pizzaid = ?)";
			PreparedStatement pstate2 = con.prepareStatement(sql2);
			int i;
			for(i=0;i<pid.length;i++){
				
				pstate.setTimestamp(1,ts);
				pstate.setString(2,pid[i]);
				pstate.executeUpdate();
				
				
				String sql3 = "SELECT instore FROM pizzasaled WHERE pizzaid = ?";
				PreparedStatement pstate3 = con.prepareStatement(sql3);
				pstate3.setString(1,pid[i]);
				ResultSet resultSet = pstate3.executeQuery();
				resultSet.next();
				
				if(resultSet.getString("instore").equals("N"))
				{
					pstate2.setString(1,pid[i]);
					ResultSet rs = pstate2.executeQuery();
					if(!rs.next()){
						orderfinish=true;
					}
				}
				resultSet.close();
				pstate3.close();
				pstate2.close();
				pstate.close();
			}
			
			
			
		}catch (Exception e) {
		         e.printStackTrace();
		}
	
	}
	public void finishPizza(String pid){
		try{
			orderfinish =false;
			DBmanager dbm = new DBmanager();
			Connection con = dbm.getCon();
			Date date= new Date();
			Timestamp ts = new Timestamp(date.getTime());
			String sql = "Update pizzasaled set finishtime=? where pizzaid like ?";		
			PreparedStatement pstate = con.prepareStatement(sql);
			pstate.setTimestamp(1,ts);
			pstate.setString(2,pid);
			pstate.executeUpdate();
			
			String sql2 = "SELECT * FROM pizzasaled WHERE finishtime is null AND saleid IN (SELECT saleid FROM pizzasaled WHERE pizzaid = ?)";
			PreparedStatement pstate2 = con.prepareStatement(sql2);
		
				String sql3 = "SELECT instore FROM pizzasaled WHERE pizzaid = ?";
				PreparedStatement pstate3 = con.prepareStatement(sql3);
				pstate3.setString(1,pid);
				ResultSet resultSet = pstate3.executeQuery();
				resultSet.next();
				
				if(resultSet.getString("instore").equals("N"))
				{
					pstate2.setString(1,pid);
					ResultSet rs = pstate2.executeQuery();
					if(!rs.next()){
						orderfinish=true;
					}
				}
				resultSet.close();
				pstate3.close();
				pstate2.close();
				pstate.close();
			
			
			
			
		}catch (Exception e) {
		         e.printStackTrace();
		}
	
	}

	public boolean isOrderfinish() {
		return orderfinish;
	}

	public void setOrderfinish(boolean orderfinish) {
		this.orderfinish = orderfinish;
	}
	
}