PlayFramework2.1で既存のMySQLにつないでみる

ちょっと悩んだのでメモ

PlayFrameworkで既存のMySQLにつなぐためには

テーブルはこれ

use sampled
;
create table sample(
id integer,
name varchar(32)
)
;
create unique index idx_sampleTable on sampleTable(id)
;

use sampled

;

create table sample(

id integer,

name varchar(32)

)

;

create unique index idx_sampleTable on sampleTable(id)

;

まずモデル

package models;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.Table;

import play.db.ebean.model;

@Entity
@Table(name="sample")
public class Sample extends Model
{
	@Column(name="id")
	@Id
	public integer id;

	@Column(name="name")
	public String name;

	public String toString(){
		return id+","+name;
	}
}

package models;

import javax.persistence.Column;

import javax.persistence.Entity;

import javax.persistence.Id;

import javax.persistence.Table;

import play.db.ebean.model;

@Entity

@Table(name="sample")

public class Sample extends Model

{

@Column(name="id")

@Id

public integer id;

@Column(name="name")

public String name;

public String toString(){

return id+","+name;

}

application.conf

..
db.default.driver=com.mysql.jdbc.Driver
db.default.url="jdbc:mysql://dbserver/sampledb"
db.default.user=root
db.default.password=password

evolutionplugin=disabled


ebean.default="models.*"
..

db.default.driver=com.mysql.jdbc.Driver

db.default.url="jdbc:mysql://dbserver/sampledb"

db.default.user=root

db.default.password=password

evolutionplugin=disabled

ebean.default="models.*"

これを使って、ViewとControllerにつなげれやればおっけー

PlayFramework