oracle-ds.xml
<?xml version="1.0" encoding="UTF-8"?>
<datasources>
<local-tx-datasource>
<jndi-name>OracleDS</jndi-name>
<connection-url>jdbc:oracle:thin:@127.0.0.1:1521:sailor</connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<user-name>test</user-name>
<password>test</password>
<SetBigStringTryClob>true</SetBigStringTryClob>
<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>persistence.xml
<persistence>
<persistence-unit name="foshanshop">
<jta-data-source>java:/OracleDS</jta-data-source>
<properties>
<property name="hibernate.hbm2ddl.auto" value="create-drop"/>
</properties>
</persistence-unit>
</persistence>person.java
package entity;import java.io.Serializable;import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;@SuppressWarnings("serial")
@Entity
@Table(name = "Person")public class Person implements Serializable {
private Integer peronid;
private String name;
@Id
@GeneratedValue(strategy=GenerationType.AUTO)
public Integer getPeronid() {
return peronid;
} public void setPeronid(Integer peronid) {
this.peronid = peronid;
}


@Column(nullable=false,length=32)
public String getName() {
return name;
} public void setName(String name) {
this.name = name;
}
}
PersonDAOBean.jsp
package entity;import javax.ejb.Remote;
import javax.ejb.Stateless;
import javax.persistence.EntityManager;
import javax.persistence.PersistenceContext;
@Stateless
@Remote({PersonDAO.class})
public class PersonDAOBean implements PersonDAO {

@PersistenceContext(unitName="foshanshop")
protected EntityManager em;

public boolean insertPerson(String name) {
//
try {
Person person = new Person();
person.setName(name);
em.persist(person);
} catch (Exception e) {
e.printStackTrace();
return false;
}
return true;
} public String getPersonNameByID(int personid) {
Person person = em.find(Person.class,personid);
return person.getName();
}}