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

<?xml version="1.0" encoding="UTF-8"?>
<datasources>
<local-tx-datasource>
<!-JNDI имя,  по которому мы будет получать подключение-->
<jndi-name>OracleDS</jndi-name>
<!-Строка подключения к БД-->
<connection-url>
jdbc:oracle:thin:@localhost:1521:ejbdb </connection-url>
<!-Класс драйвера БД-->
<driver-class>oracle.jdbc.OracleDriver</driver-class>
<!-Имя пользователя в БД и пароль-->
<user-name>boris</user-name>
<password>quasimodo</password>
<exception-sorter-class-name>
org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter </exception-sorter-class-name>
<!-Название описания соответствий типов-->
<metadata>
<type-mapping>Oracle9i</type-mapping>
</metadata>
</local-tx-datasource>
</datasources>

public void setSessionContext(SessionContext arg0)   throws EJBException, RemoteException  
{
try 
	{
	InitialContext ctx = new InitialContext();
	if   (dataSource == null)
	// Получаем объект DataSource из JNDI контекста 
	dataSource =   (DataSource)   ctx.lookup("java:/OracleDS");
	System.out.println("Data source aquired");
	}   
catch   (NamingException ex)   
	{
	throw new EJBException(ex);
	}
}

public double convert(String cur1,   String cur2,  double amount)
throws CurrencyRateNotFoundUpgException  
{
if   (dataSource == null)   
	{ 
	return -1;
	}
try 
	{
	// Получаем подключение к базе данных из пула соединений 
	Connection conn = dataSource.getConnection(); 
	
	// Готовим SQL-команду к выполнению
	PreparedStatement p = conn.prepareStatement
		("SELECT RATE FROM CURRENCY_EXCHANGE_RATE  "  + "WHERE CUR1NAME=? AND CUR2NAME=?");
	
	p.setString(1,   cur1);
	p.setString(2,   cur2);
	ResultSet r = p.executeQuery();
	
	// Обрабатываем полученный результат
	if (r.next()) 
		{
		double rate = r.getDouble(1); 
		return rate * amount; 
		}  
	else  
		{
		throw new
		CurrencyRateNotFoundUpgException(cur1,   cur2);
		}
	}   
catch   (SQLException e)   
	{ 
	e.printStackTrace();
	}
return -1;
}

create or replace package ORDER_ID_PKG as LAST_ID integer;
function GET_LAST_ID return integer; 
end ORDER_ID_PKG; 

/

create or replace package body ORDER_ID_PKG as function GET_LAST_ID return integer is 
begin
return LAST_ID; end GET_LAST_ID;
end ORDER_ID_PKG;

/

create table COMMODITIES_LIST 
(
ID integer not null,
NAME varchar(20)   not null,
DESCRIPTION varchar(50)   not null,
PRICE float not null,
IMAGEPATH varchar(30), primary key(ID));

create sequence COMMODITIES_SEQ start with 1 increment by 1 nomaxvalue;

create trigger COMMODITIES_TRIGGER
before insert on COMMODITIES_LIST
for each row 
begin
select COMMODITIES_SEQ.nextval into  :new.id from dual; 
end;

/

insert into COMMODITIES_LIST(NAME, DESCRIPTION, PRICE, IMAGEPATH)

values('Kent 1',   'Normal cigarettes',   1.99,   'img/kent1.jpg');

insert into COMMODITIES_LIST(NAME, DESCRIPTION, PRICE, IMAGEPATH)

values('Kent 4',   'Light cigarettes',   1.99,   'img/kent4.jpg');

insert into COMMODITIES_LIST(NAME, DESCRIPTION, PRICE, IMAGEPATH)

values('Kent 8',   'Very light cigarettes',   1.99,   'img/kent8.jpg');

insert into COMMODITIES_LIST(NAME, DESCRIPTION, PRICE, IMAGEPATH)

values('Lucky Strike',   'Pure American Taste',   2.30,   'img/lucky.jpg');

insert into COMMODITIES_LIST(NAME, DESCRIPTION, PRICE, IMAGEPATH)
values('Portugas',   'Fine Cuban Cigar',   10.95,   'img/portugas.jpg'); select *  from COMMODITIES_LIST;

/

create table ORDERS
(
ID integer not null,
DATE_CREATED DATE not null,
USERNAME varchar(20)   not null, primary key(ID)
);

create sequence ORDERS_SEQ start with 1 increment by 1 nomaxvalue;
create trigger ORDERS_TRIGGER before insert on ORDERS for each row 
begin
select ORDERS_SEQ.nextval into :new.id from dual; 
end;

/

create table COMMODITY_ORDER
(
ID integer not null, ORDER_ID integer not null, COMMODITY_ID integer not null, QUANTITY integer not null, primary key(ID)
);

alter table COMMODITY_ORDER add constraint FK_ORDER foreign key (ORDER_ID) references ORDERS(ID);

alter table COMMODITY_ORDER add constraint FK_COMMODITIES foreign key(COMMODITY_ID) references COMMODITIES_LIST(ID);

create sequence COMMODITY_ORDER_SEQ start with 1 increment by 1 nomaxvalue;

create trigger COMMODITY_ORDER_TRIGGER

before insert on COMMODITY_ORDER

for each row
begin
select COMMODITY_ORDER_SEQ.nextval into  :new.id from dual; 
end;

/

drop table COMMODITY_ORDER;
drop table ORDERS;
drop table COMMODITIES_LIST;
drop sequence COMMODITY_ORDER_SEQ; drop sequence COMMODITIES_SEQ; drop sequence ORDERS_SEQ;

public abstract class DataItem implements Serializable  
{ 
protected int id = -1;
public int getId()   
	{
	return id;
	}
public void setId(int id)   
	{
	this.id = id;
	}
}

public class Commodity extends DataItem 
{
private static final long serialVersionUID = -7004067843847157531L;
private String name;
private String description;
private String imagePath;
private double price;
public String getName()   
	{ 
	return name;
	}

public void setName(String name)   
	{ 
	this.name = name;
	}

public String getDescription()   
	{ 
	return description;
	}

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

public double getPrice()   
	{ 
	return price;
	}
public void setPrice(double price)   
	{ 
	this.price = price;
	}

public String getImagePath()   
	{ 
	return imagePath;
	}

public void setImagePath(String imagePath)   
	{ 
	this.imagePath = imagePath;
	}

public String toString()   
	{
	return "ID=" + id + ";  NAME=" + name + ";  DESCRIPTION" + description + ";   PRICE=" + price + ";   IMAGEPATH=" + imagePath;
	}
}

public class CommodityOrder extends DataItem 
{
private static final long serialVersionUID = -592875988844838475L;
private int commodityId;
private int commodityQuantity;
public int getCommodityId()   
	{ 
	return commodityId;
	}

public void setCommodityId(int commodityId)   
	{ 
	this.commodityId = commodityId;
	}

public int getCommodityQuantity()   
	{ 
	return commodityQuantity;
	}

public void setCommodityQuantity(int commodityQuantity)   
	{ 
	this.commodityQuantity = commodityQuantity;
	}
}

public class Order extends DataItem 
{
private static final long serialVersionUID = -3276613990865210869L;
private String name; private Date date;
public String getName()   
	{ 
	return name;
	}

public void setName(String name)   
	{ 
	this.name = name;
	}

public Date getDate()   
	{
	return date;
	}

public void setDate(Date date)   
	{
	this.date = date;
	}
}