Jpql和ejb注解

package com.tudou.t1Test; import java.util.List; import javax.ejb.Stateless; import javax.persistence.EntityManager; import javax.persistence.PersistenceContext; import javax.persistence.Query; @Stateless(mappedName = "StudentDaoBean") public class StudentDaoBean implements StudentDao { // 动态生成entityManager @PersistenceContext public EntityManager em; public boolean addStu(Student student) { try { em.persist(student); } catch (Exception e) { return false; } return true; } public boolean updateStu(Student student) { try { em.merge(student); } catch (Exception e) { return false; } return true; } public boolean delStu(int sid) { try { Student s = selectOneById(sid); em.remove(s); // Query query = em // .createQuery("delete from Student as s where s.sid =?1"); // // 占位符从1开始 // query.setParameter(1, sid); // if (query.executeUpdate() <= 0) { // return false; // } } catch (Exception e) { return false; } return true; } // 使用EntityManager获取对象 public Student selectOneById(int id) { Student s = null; try { s = em.find(Student.class, id); } catch (Exception e) { return null; } return s; } // 使用JPQL词句获取对象order by,group by,having,max,min此处不作详细赘述 public Student getOneById(int id) { Student s = null; try { Query query = em .createQuery("select s from Student as s where sid =?1"); // 占位符从1开始 query.setParameter(1, id); s = (Student) query.getSingleResult(); } catch (Exception e) { return null; } return s; } @SuppressWarnings("unchecked") public List<Student> queryStudents() { Query query = em.createQuery("select s from Student as s"); return query.getResultList(); } }

package com.tudou.t1Test; import java.io.Serializable; import javax.persistence.CascadeType; import javax.persistence.Entity; import javax.persistence.FetchType; import javax.persistence.GeneratedValue; import javax.persistence.Id; import javax.persistence.JoinColumn; import javax.persistence.ManyToOne; import javax.persistence.Table; @SuppressWarnings("serial") @Entity @Table(name = "tb_student") public class Student implements Serializable { @Id @GeneratedValue private int sid; // optional指定有student时必须有class.立即检索 @ManyToOne(optional = false, cascade = { CascadeType.PERSIST, CascadeType.PERSIST, CascadeType.REFRESH }, fetch = FetchType.EAGER) @JoinColumn(name = "cid") private Classes classes; private String stuNo; private String stuName; private String createDate; public Student() { super(); } public Student(Classes classes, String stuNo, String stuName, String createDate) { super(); this.classes = classes; this.stuNo = stuNo; this.stuName = stuName; this.createDate = createDate; } public Student(int sid, Classes classes, String stuNo, String stuName, String createDate) { super(); this.sid = sid; this.classes = classes; this.stuNo = stuNo; this.stuName = stuName; this.createDate = createDate; } public int getSid() { return sid; } public void setSid(int sid) { this.sid = sid; } public Classes getClasses() { return classes; } public void setClasses(Classes classes) { this.classes = classes; } public String getStuNo() { return stuNo; } public void setStuNo(String stuNo) { this.stuNo = stuNo; } public String getStuName() { return stuName; } public void setStuName(String stuName) { this.stuName = stuName; } public String getCreateDate() { return createDate; } public void setCreateDate(String createDate) { this.createDate = createDate; } }