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();
}}
<?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();
}}
解决方案 »
- J2EE真的不行了吗?
- jdk版本问题造成eclipse发布后不能运行,怎么办?
- hibernate级联更新的问题
- 求J2EE资料~
- 救命啊﹐急﹐搞了好久了
- jsp程序发布到tomcat服务器为什么找不到sqlserver驱动程序.
- Apache和tomcat整合问题:如何很好的显示servlet?
- 怎样在JSP中实现从一个XML文件中读取所有元素?以树型显示
- struts的错误问题:java.lang.NoClassDefFoundError: org/apache/commons/logging/LogFactory
- JDBC联接MySQL,不能正常输出中文
- ssh中有关于分页的API吗?
- hibernate如何实现数据库动态表单映射
说的做
<property name="hibernate.dialect" value="org.hibernate.dialect.Oracle9Dialect"/>
is
ok