play链接管理数据库也是挺方便的。
为了链接数据库需要修改配置application.conf文件和build.sbt文件
application.conf
# Database configuration
db.default.driver=com.mysql.jdbc.Driver
db.default.url="jdbc:mysql://127.0.0.1:3306/wish"
db.default.user="root"
db.default.password="tiger"
# Ebean configuration
ebean.default="model.*"#谨记这是你实体类的包名
build.sbt
libraryDependencies ++= Seq(
javaJdbc,
javaEbean,
cache,
"mysql" % "mysql-connector-java" % "5.1.18"
)
添加"mysql" % "mysql-connector-java" % "5.1.18" 一行
实体类
package model;
import javax.persistence.Entity;
import javax.persistence.Id;
import play.db.ebean.Model;
@Entity
public class Person extends Model{
private static final long serialVersionUID = 1L;
@Id
public Integer id;
public String name;
}
实体dao类
package dao;
import java.util.List;
import model.Person;
import play.db.ebean.Model.Finder;
public class PersonDao {
public static Finder<Integer,Person> find =
new Finder<Integer,Person>(Integer.class, Person.class);
public static List<Person> findAll() {
return find.all();
}
public static Person findByName (String name) {
return find.where().eq("name", name).findUnique();
}
}
ok,使用play run来运行服务器。
访问: http://127.0.0.1:9000/
出现下面页面,并点击按钮(成功了!)