使用Ebean访问SQL Database

    根据你的数据库类型,你也需要加入相应的JDBC访问包的依赖。比如:

    1. <dependency>
    2. <groupId>com.h2database</groupId>
    3. <artifactId>h2</artifactId>
    4. <version>1.4.178</version>
    5. </dependency>

    配置

    1. firstName
    2. lastName
    3. address
    1. package com.mycom.myprj;
    2. import act.db.DB;
    3. import javax.persistence.Entity;
    4. import javax.persistence.Id;
    5. @Entity(name = "ctct")
    6. public class Contact {
    7. @Id
    8. private String fn;
    9. private String ln;
    10. private String addr;
    11. public long getId() {
    12. return null == id ? -1 : id;
    13. }
    14. public String getFirstName() {
    15. return fn;
    16. }
    17. public void setFirstName(String fn) {
    18. this.fn = fn;
    19. }
    20. return ln;
    21. }
    22. this.ln = ln;
    23. }
    24. public String getAddress() {
    25. return addr;
    26. }
    27. public void setAddress(String addr) {
    28. this.addr = addr;
    29. }
    30. }

    注意 和Morphia访问层不同,Ebean访问层目前暂时不提供类似MorphiaModel的父类.

    数据访问对象和CRUD

    1. // find by last name
    2. Iterable<Contact> contacts = dao.findBy("firstName", firstName);
    3. // find by both first and last name
    4. Iterable<Product> contacts = dao.findBy("firstName,lastName", firstName, lastName);
    5. Iterable<Product> contacts = dao.findBy("firstName", Pattern.compile(firstName));

    扩展

    TBD