JavaPersistenceAPI.ppt

@ManyToOne(cascade=CascadeType.ALL) @JoinColumn(name=“userid”) //外键 public User getUser(){ return user; } public void setUser(User user) { this.user=user; } @ManyToOne(cascade=CascadeType.ALL) @JoinColumn(name=“stockid”) //外键 public Stock getStock(){ return stock; } public void setStock(Stock stock) { this.stock=stock; } …… } TradeDAO …… @remote public interface TradeDAO { public boolean insertTrade(String id,User user, Stock stock, String type, int number, double price, Date date); …… } TradeDAOBean …… @Stateless public class TradeDaoBean implements TradeDao{ @PersistenceContext(unitName = UserManagement) protected EntityManager em; public boolean insertTrade(String id, User user, Stock stock, String type, int number, double price, Date date) { try{ Trade trade = new Trade(); trade.setId(id); trade.setUser(user); trade.setStock(stock); trade.setType(type); trade.setNumber(number); trade.setPrice(price); trade.setDate(date); em.persist(trade); //保存Entity到数据库中 }catch(Exception e){ e.printStackTrace(); return false; } return true; } …… } BuyStockServlet …… @EJB private TradeDao tradeDao; …… User u = new User(); u.setId((long)1234567895); u.setUserid(user005); …… BuyStockServlet Stock s =new Stock(); s.setId(300); s.setCompanyName(nju); …… tradeDao.insertTrade(205,u, s, buy, 200, 150, new Date(2010-01-01)); …… 运行结果 在trade表中增加一条交易记录； 在user和stock表中也各增加一条记录（新用户和新股票）。 * Queries That Navigate to Related Entities Data retrieved: All players who belong to a team. SELECT DISTINCT p FROM Player p, IN(p.teams) t SELECT DISTINCT p FROM Player p JOIN p.teams t SELECT DISTINCT p FROM Player p WHERE p.team IS NOT EMPTY Joins A LEFT JOIN or LEFT OUTER JOIN retrieves a set of entities where matching values in the join condition may be absent. A FETCH JOIN is a join operation that returns associated entities as a side-effect of running the query. Example: SELECT d FROM Department d LEFT JOIN FETCH d.employees WHERE d.deptno = 1 The query returns a set of departments, and as a sid