myeclips8+jboss5+mysql5配置测试实体bean

最后的目录层次结构：

mysql数据库结构：

按目录层次，给出各个类文件：

Person.java:（此为）

package com.ejb;import java.io.Serializable; import java.util.Date; import javax.persistence.Column; import javax.persistence.Entity; import javax.persistence.GeneratedValue; import javax.persistence.Id; import javax.persistence.Table;  @SuppressWarnings("serial") @Entity @Table(name = "Person") public class Person implements Serializable{      private Integer personid;     private String name;         private boolean sex;     private Short age;     private Date birthday;        @Id     @GeneratedValue        public Integer getPersonid() {         return personid;     }     public void setPersonid(Integer personid) {         this.personid = personid;     }           @Column(name = "PersonName",nullable=false,length=32)     public String getName() {         return name;     }     public void setName(String name) {         this.name = name;     }          @Column(nullable=false)     public boolean getSex() {         return sex;     }     public void setSex(boolean sex) {         this.sex = sex;     }          @Column(nullable=false)        public Short getAge() {         return age;     }     public void setAge(Short age) {         this.age = age;     }           public Date getBirthday() {         return birthday;     }     public void setBirthday(Date birthday) {         this.birthday = birthday;     }    }

PersonDAO.java:

package com.session;import java.util.Date; import java.util.List; import com.ejb.Person;  public interface PersonDAO {          public boolean insertPerson(String name, boolean sex,short age, Date birthday);     public String getPersonNameByID(int personid);     public boolean updatePerson(Person person);     public Person getPersonByID(int personid);     public List getPersonList(); } 

PersonDAOBean.java:(此为，用于测试实体bean)

package com.session;import java.util.Date; import java.util.List; import javax.ejb.Remote; import javax.ejb.Stateless; import javax.persistence.EntityManager; import javax.persistence.PersistenceContext; import javax.persistence.Query; import com.session.PersonDAO; import com.ejb.Person;  @Stateless @Remote ({PersonDAO.class}) public class PersonDAOBean implements PersonDAO {      @PersistenceContext     protected EntityManager em;      public String getPersonNameByID(int personid) {         Person person = em.find(Person.class, Integer.valueOf(personid));         return person.getName();     }         public boolean insertPerson(String name, boolean sex,short age, Date birthday) {        try {             Person person = new Person();             person.setName(name);             person.setSex(sex);             person.setAge(Short.valueOf(age));             person.setBirthday(birthday);             em.persist(person);         } catch (Exception e) {             e.printStackTrace();             return false;         }          return true;     }      public Person getPersonByID(int personid) {                return em.find(Person.class, Integer.valueOf(personid));     }          public boolean updatePerson(Person person) {         try {             em.merge(person);         } catch (Exception e) {             e.printStackTrace();             return false;         }          return true;     }          public List getPersonList() {         try {             Query query = em.createQuery("from Person p order by personid asc");             List list = query. getResultList();             em.clear();//分离内存中受EntityManager管理的实体bean，让VM进行垃圾回收             return list;                      } catch (Exception e) {             e.printStackTrace();             return null;         }     }  } 

 

然后创建一个web项目EntityBeanTest，在默认路径建一个jsp测试文件Test.jsp:

             

Test.jsp:

<%@ page contentType="text/html; charset=GBK"%> <%@ page import="com.session.*,          com.ejb.*,         javax.naming.*,          java.util.Properties,          java.util.Date,         java.util.List,         java.util.Iterator,         java.text.SimpleDateFormat"%> <%     Properties props = new Properties();     props.setProperty("java.naming.factory.initial", "org.jnp.interfaces.NamingContextFactory");     props.setProperty("java.naming.provider.url", "localhost:1099");     props.setProperty("java.naming.factory.url.pkgs", "org.jboss.naming");       InitialContext ctx = new InitialContext(props);     try {            PersonDAO persondao = (PersonDAO) ctx.lookup("PersonDAOBean/remote");       SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd");            persondao.insertPerson("刘宽", true, (short)26,formatter.parse("1980-9-30"));//添加一个人       out.println(persondao.getPersonNameByID(1)); //取personid为1的人姓名        Person person = persondao.getPersonByID(1); //取personid为1的person,此时的person已经脱离容器的管理       person.setName("张小艳"); //把姓名改为张小艳       persondao.updatePerson(person); //更新person        out.println("<br> personid为1的person姓名已由“刘宽”改为“张小艳”<br>");       List list = persondao.getPersonList(); //分页结果集      if (list!=null){         Iterator it = list.iterator();         while (it.hasNext()) {           Person p = (Person)it.next();           out.println("人员编号:"+ p.getPersonid() + "\t姓名："+ p.getName() + "<Br>");         }       }     } catch (Exception e) {       out.println(e.getMessage());     } %> 

结出persistence.xml:

<?xml version="1.0" encoding="UTF-8"?><persistence xmlns="http://java.sun.com/xml/ns/persistence"    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"    xsi:schemaLocation="http://java.sun.com/xml/ns/persistence    http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd" version="1.0">    <persistence-unit name="entityPU" transaction-type="JTA">  <jta-data-source>java:/MySqlDS</jta-data-source></persistence-unit>  </persistence>

 

最后，发布ejb和web项目，在地址栏输入：http://localhost:8080/EntityBeanTest/Test.jsp

在网页下的输出结果如下：

张小艳
personid 为1的person姓名已由“刘宽”改为“张小艳”
人员编号:1 姓名：张小艳

 

本人亲测可行！至于其他平台和不同版本的情况下可能会有问题，欢迎探讨！