Технология Enterprise Java Beans. Часть 1

public interface OrdersListRemote extends EJBObject  
{
public List getOrdersForUser(String username)   throws RemoteException, SQLException;
public List getCommodityOrdersForOrder(int orderId)   throws RemoteException,   SQLException;
}

public interface OrdersListHome extends EJBHome  
{
public OrdersListRemote create()   throws RemoteException,   CreateException;
}

public class OrdersListBean implements SessionBean  
{
private static final long serialVersionUID = 2767604097827994556L; 
private DataSource dataSource = null;
public List getOrdersForUser(String username)   throws SQLException  
	{
	if   (dataSource == null)
	throw new SQLException("Datasource not loaded");
	Connection conn = dataSource.getConnection();
	PreparedStatement p = conn.prepareStatement
		("SELECT * FROM " + "  ORDERS WHERE USERNAME=?");
	p.setString(1, username);
	ResultSet r = p.executeQuery();
	List arrayList = new ArrayList();
	
	while(r.next())   
		{
		Order order = new Order();
		order.setId(r.getInt("ID"));
		order.setName(r.getString("USERNAME"));
		order.setDate(r.getDate("DATE_CREATED"));
		arrayList.add(order);
		}
	conn.close();
	return arrayList;
	}
	
public List getCommodityOrdersForOrder(int orderId) throws SQLException  
	{
	if   (dataSource == null)
	throw new SQLException("Datasource not loaded");
	Connection conn = dataSource.getConnection();
	PreparedStatement p = conn.prepareStatement
		("SELECT * FROM " + "  COMMODITY_ORDER WHERE ORDER_ID=?");
	
	p.setInt(1,  orderId);
	ResultSet r = p.executeQuery();
	List arrayList = new ArrayList();
	while(r.next())   
		{
		CommodityOrder order = new CommodityOrder(); 
		order.setId(r.getInt("ID"));
		order.setCommodityId(r.getInt("COMMODITY_ID"));
		order.setCommodityQuantity(r.getInt("QUANTITY"));
		arrayList.add(order);
		}
	conn.close(); 
	return arrayList;
	}

public void ejbCreate()   {}

public void ejbActivate()   throws EJBException,   RemoteException  {}

public void ejbPassivate()   throws EJBException,   RemoteException  {}

public void ejbRemove()   throws EJBException,   RemoteException  {}
public void setSessionContext(SessionContext arg0)   throws EJBException, RemoteException  
	{
	try 
		{
		InitialContext ctx = new InitialContext(); 
		if   (dataSource == null)
		dataSource =   (DataSource)   ctx.lookup("java:/OracleDS");
		System.out.println("Data source aquired"); 
		}   
	catch   (NamingException ex)   
		{
		throw new EJBException(ex);
		}
	}
}

public class TestClient3  
{
public static void main(String args[])   
	{
	try 
		{
		Context jndiContext = createJBossContext();
		
		Object ref = jndiContext.lookup("OrdersListBean"); 
		OrdersListHome home =   (OrdersListHome) PortableRemoteObject.narrow(ref, OrdersListHome.class);
		OrdersListRemote remote = home.create();
		List orders = remote.getOrdersForUser("Boris");
		System.out.println("Orders  for user Boris");
		
		for   (Iterator iter = orders.iterator();  iter.hasNext();)   
			{ 
			Order order =   (Order)   iter.next();
			List commodityList =remote.
			getCommodityOrdersForOrder(order.getId()); 
			System.out.println("Commodities  for order " +
			order.getId()   + "  " + order.getDate().toString());
			
			for   (Iterator iter2 = commodityList.iterator(); iter2.hasNext();)   
				{ 
				CommodityOrder cOrder = (CommodityOrder) iter2.next(); 
				System.out.println(cOrder.getCommodityId() + "  " + cOrder.getCommodityQuantity());
				}
			}
		}   
	catch (RemoteException e)   
		{
		e.printStackTrace(); 
		}   
	catch   (NamingException e)   
		{
		e.printStackTrace(); 
		}   
	catch   (CreateException e)   
		{
		e.printStackTrace(); 
		}   
	catch   (SQLException e)   
		{
		e.printStackTrace();
		}
	}

public static Context createJBossContext()   throws NamingException  
	{ 
	Properties p = new Properties(); 
	p.put("java.naming.factory.initial", "org.jnp.interfaces.NamingContextFactory"); 
	p.put("java.naming.provider.url", "jnp://127.0.0.1:1099"); 
	p.put("java.naming.factory.url.pkgs",
	"org.jboss.naming:org.jnp.interfaces"); 
	Context jndiContext = new InitialContext(p); 
	return jndiContext;
	}
}

public interface ShoppingBasketRemote extends EJBObject  
{
public List getCurrentCommoditiesList()   throws RemoteException; 
public boolean isEmpty()   throws RemoteException;
public void addCommodity(int commodityId)   throws RemoteException; 
public void recalculateCommodity(int commodityId,   int newCount)
throws RemoteException; 
public void deleteCommodity(int commodityId)   throws RemoteException; 
public void processOrder()   throws RemoteException,   SQLException;
}

public interface ShoppingBasketHome extends EJBHome  
{
public ShoppingBasketRemote create(String username)   throws RemoteException,   CreateException;

}

Iterator iter = commodityOrderList.iterator(); 
CommodityOrder order = null; 
while   (iter.hasNext())   
{
CommodityOrder currentOrder =   (CommodityOrder)   iter.next();
if   (currentOrder.getCommodityId()   == commodityId)     
	{ 
	order = currentOrder;
	break;
	}
}
return order;

this.username = username; commodityOrderList = new ArrayList();

PreparedStatement p = conn.prepareStatement("insert into " "ORDERS(DATE_CREATED, USERNAME) values (?, ?)");
p.setDate(1,new java.sql.Date(System.currentTimeMillis()));
p.setString(2,username);
p.executeUpdate();

p = conn.prepareStatement("select ORDER_ID_PKG.GET_LAST_ID from dual"); 
ResultSet r = p.executeQuery(); 
int orderId = -1;
if (r.next()) 
{
orderId = r.getInt(1);
}

while   (iter.hasNext())   
{
CommodityOrder currentOrder =  (CommodityOrder)   iter.next();
p = conn.prepareStatement("insert into COMMODITY_ORDER
	(ORDER_ID,   " + "COMMODITY_ID,  QUANTITY)   values   (?,   ?,   ?)");
p.setInt(1,  orderId);
p.setInt(2,  currentOrder.getCommodityId()); 
p.setInt(3,  currentOrder.getCommodityQuantity()); 
p.execute();
}

CommodityOrder order = findOrderById(commodityId);
if   (order == null)   
	{
	order = new CommodityOrder(); 
	order.setCommodityId(commodityId); 
	order.setCommodityQuantity(1); 
	commodityOrderList.add(order); 
	}  
else  
	{
	order.setCommodityQuantity(order.getCommodityQuantity()   + 1);
	}

CommodityOrder order = findOrderById(commodityId);
if   (order == null)   
	{
	if   (newCount > 0)   
		{
		order = new CommodityOrder(); 
		order.setCommodityId(commodityId); 
		order.setCommodityQuantity(1); 
		commodityOrderList.add(order);
		}
	}  
else  
	{
	if   (newCount > 0)   
		{
		order.setCommodityQuantity(newCount);
		}  
	else  
		{
		commodityOrderList.remove(order);
		}
	}

public class ShoppingBasketBean implements SessionBean  
{
private static final long serialVersionUID = 8173942031447022589L;
private String username = null;
private DataSource dataSource = null;
private List commodityOrderList;
public void ejbCreate(String username)   
	{
	this.username = username;
	commodityOrderList = new ArrayList();
	}
private CommodityOrder findOrderById(int commodityId)   
	{ 
	Iterator iter = commodityOrderList.iterator(); 
	CommodityOrder order = null; 
	while   (iter.hasNext())   
		{
		CommodityOrder currentOrder =   (CommodityOrder)   iter.next(); 
		if   (currentOrder.getCommodityId()  == commodityId)     
			{ 
			order = currentOrder; break;
			}
		}	
	return order;
	}

public List getCurrentCommoditiesList()   
	{ 
	return commodityOrderList;
	}

public boolean isEmpty()     
	{
	return   (commodityOrderList.size()   == 0);
	}
public void addCommodity(int commodityId)   
	{
	CommodityOrder order = findOrderById(commodityId);
	if   (order == null)   
		{
		// Creating new order
		order = new CommodityOrder();
		order.setCommodityId(commodityId);
		order.setCommodityQuantity(1);
		commodityOrderList.add(order); 
		}  
	else  
		{
		order.setCommodityQuantity(order.getCommodityQuantity()   + 1);
		}
	}

public void recalculateCommodity(int commodityId,   int newCount)   
	{
	CommodityOrder order = findOrderById(commodityId);
	if   (order == null)   
		{
		if   (newCount > 0)   
			{
			// Creating new order
			order = new CommodityOrder();
			order.setCommodityId(commodityId);
			order.setCommodityQuantity(1);
			commodityOrderList.add(order);
			}
		}  
	else  
		{
		if   (newCount > 0)   
			{
			order.setCommodityQuantity(newCount); 
			}  
		else  
			{
			commodityOrderList.remove(order);
			}
		}
	}

public void deleteCommodity(int commodityId)   
	{ 
	recalculateCommodity(commodityId,   0);
	}

public void processOrder()   throws SQLException  
	{ 
	if   (dataSource == null)
		throw new SQLException("Datasource not loaded"); 
	Connection conn = dataSource.getConnection();
	
	if   (commodityOrderList.size() == 0) 
		return;
	PreparedStatement p = conn.prepareStatement
		("insert into " + "ORDERS(DATE_CREATED, USERNAME) "  + "values (?,   ?)");
	
	p.setDate(1,  new java.sql.Date(System.currentTimeMillis()));
	p.setString(2,  username);
	p.executeUpdate();
	
	p = conn.prepareStatement("select max(ID) from ORDERS where " + "USERNAME = ?");
	p.setString(1,  username);
	
	ResultSet r = p.executeQuery(); 
	int orderId = -1;
	
	if (r.next()) 
		{
		orderId = r.getInt(1);
		}
	
	Iterator iter = commodityOrderList.iterator(); 
	while   (iter.hasNext())   
		{
		CommodityOrder currentOrder =   (CommodityOrder)   iter.next();
		p = conn.prepareStatement
	      ("insert into COMMODITY_ORDER
	      	(" + " ORDER_ID, COMMODITY_ID, QUANTITY) " + "values (?, ?, ?)");
		
		p.setInt(1,   orderId);
		p.setInt(2,   currentOrder.getCommodityId()); 
		p.setInt(3,   currentOrder.getCommodityQuantity()); 
		p.execute();
		}
	commodityOrderList.clear(); conn.close();
	}
	
public void ejbActivate()   throws EJBException,   RemoteException  
	{}

public void ejbPassivate()   throws EJBException,   RemoteException  
	{}

public void ejbRemove()   throws EJBException,   RemoteException  
	{}

public void setSessionContext(SessionContext arg0)   throws EJBException, RemoteException  
	{
	try 
		{
		InitialContext ctx = new InitialContext(); 
		if   (dataSource == null)
		dataSource =   (DataSource)
		ctx.lookup("java:/OracleDS");
		System.out.println("Data source aquired");
		}   
	catch   (NamingException ex)   
		{
		throw new EJBException(ex);
		}
	}
}