Play+Ebean操作数据库快速上手

来源：互联网发布：网络商标注册保护编辑：程序博客网时间：2024/06/06 01:31

配置：

application.conf：db.default.driver=com.mysql.jdbc.Driverdb.default.url="mysql://root:root@192.168.xxx.xxx:3306/bigdata?characterEncoding=UTF-8"//db.default.username="root"//db.default.password="root"ebean.default=["models.*"]

build.sbt:

lazy val `maxi` = (project in file(".")).enablePlugins(PlayJava, PlayEbean/*, PlayEnhancer*/)"mysql" % "mysql-connector-java" % "5.1.18"

plugins.sbt:

addSbtPlugin("com.typesafe.sbt" % "sbt-play-ebean" % "1.0.0")

之前加入PlayEnhancer和
addSbtPlugin(“com.typesafe.sbt” % “sbt-play-enhancer” % “1.1.0”)
之后报错
Bean class models.* is not enhanced?
屏蔽之后即可。

使用

创建

models目录下（没有则创建一个）创建一个model

package models;import com.avaje.ebean.Model;import javax.persistence.Entity;import javax.persistence.Id;import javax.persistence.Table;/** * Created by maxi on 2016/12/28. */@Entity@Table(name="user")public class UsersModel extends Model{    @Id    public int id;    public String name;    public String password;    public String email;    public static Finder find = new Finder(            Long.class, UsersModel.class    );    public int getId() {        return id;    }    public void setId(int id) {        this.id = id;    }    public String getName() {        return name;    }    public void setName(String name) {        this.name = name;    }    public String getPassword() {        return password;    }    public void setPassword(String password) {        this.password = password;    }    public String getEmail() {        return email;    }    public void setEmail(String email) {        this.email = email;    }}

查询

    Ebean.execute(() -> {        UsersModel user = Ebean.find(UsersModel.class,1);        play.Logger.debug("staff login email: {}, pwd: {}", user.email, user.password);    });

0 0