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

private Integer widgetId;
private String description;
private double price;
private EntityContext context;
public Integer getId()   
{
return widgetId;
}
public String getDescription()   
{
return description;
}
public double getPrice()   
{ 
return price;
}

public void setDescription(String description)   
{ 
this.description = description;
}
public void setPrice(double price)   
{ 
this. price = price;
}

public void ejbLoad()   
{
widgetId =  (Integer)   context.getPrimaryKey();
try 
	{
	loadRow();
	}   
catch   (Exception ex)   
	{
	throw new EJBException("ejbLoad:   " + ex.getMessage());
	}
}

public void ejbStore()   
{
try 
	{
	storeRow();
	}   
catch   (Exception ex)   
	{
	throw new EJBException("ejbLoad:   " + ex.getMessage());
	}
}
private void loadRow()   throws SQLException  
	{ 
	Connection con = null; 
	PreparedStatement prepStmt = null;
	try 
		{
		con = dataSource.getConnection(); 
		String selectStatement ="select DESCRIPTION, PRICE " +
		"from WIDGETS where ID = ?  ";
		prepStmt = con.prepareStatement(selectStatement); 
		prepStmt.setInt(1,  widgetId); 
		ResultSet rs = prepStmt.executeQuery();
		if   (rs.next())   
			{
			this.description = rs.getString(1); 
			this.price = rs.getDouble(2); 
			prepStmt.close();
			}
		else  
			{
			prepStmt.close();
			throw new NoSuchEntityException("Row for widgetId " + widgetId + " not found in database.");
			}
		con.close();
		}   
	catch   (Exception e)   
		{
		} 
	finally 
		{
		if   (prepStmt   != null)   
			{
			try 
			{
			prepStmt.close(); 
			}   
			catch   (Exception e)
			{
			}
			}
		if   (con   != null)   
			{
			try 
			{
			con.close();
			}   
			catch   (Exception e)
			{
			}
			}
		}
	}

private void storeRow()   throws SQLException  
	{ 
	Connection con = null; 
	PreparedStatement prepStmt = null;
	try 
		{
		con = dataSource.getConnection(); 
		String updateStatement = "update WIDGETS set DESCRIPTION =   ? , 
			" + "PRICE = ? " + "where ID = ?";
		prepStmt = con.prepareStatement(updateStatement);
		prepStmt.setString(1,  description); 
		prepStmt.setDouble(2,  price); 
		prepStmt.setInt(3,  widgetId);
		int rowCount = prepStmt.executeUpdate();
		prepStmt.close();
		con.close();
		
		if   (rowCount == 0)   
			{
			throw new EJBException("Storing row for widgetId " + widgetId + " failed.");
			}
		}   
	catch   (Exception e)   
		{
		} 
	finally 
		{
		if (prepStmt != null) 
			{
			try 
			{
			prepStmt.close(); 
			}   
			catch   (Exception e)   
			{
			}
		}
		if   (con   != null)   
			{
			try 
			{
			con.close();
			}   
			catch   (Exception e)   
			{
			}
			}
		}
	}