play framework2開發（七）

整合JPA

1、在conf/application.conf

db.epay.driver=com.mysql.jdbc.Driverdb.epay.url="jdbc:mysql://localhost:3306/epay"db.epay.user=rootdb.epay.password="1234"db.epay.jndiName=epayDShibernate.use_sql_comments=truejpa.default=defaultPersistenceUnit

資料庫如果不存在，請在資料庫中手動建立

2、在project/build.scala

val appDependencies = Seq(    // Add your project dependencies here,    javaCore,    javaJdbc,    javaEbean,     "mysql" % "mysql-connector-java" % "5.1.18",     "org.hibernate" % "hibernate-entitymanager" % "3.6.9.Final",     "play" % "play-java-jpa_2.10" % "2.1.0"       )

3、接下裡要建立一個正確的JPA設定檔persistence.xml。把它放進conf/META-INF目錄（沒有則建立）

<?xml version="1.0" encoding="UTF-8"?><persistence xmlns="http://java.sun.com/xml/ns/persistence"             xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"             xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd"             version="2.0">             <persistence-unit name="defaultPersistenceUnit" transaction-type="RESOURCE_LOCAL"><provider>org.hibernate.ejb.HibernatePersistence</provider><non-jta-data-source>epayDS</non-jta-data-source><properties><property name="hibernate.hbm2ddl.auto" value="update" /><property name="hibernate.dialect" value="org.hibernate.dialect.MySQL5Dialect" /></properties></persistence-unit></persistence>

註解：persistence-unit name就是application.conf裡的jpa.default值，non-jta-data-source就是db.epay.jndiName。

4、java類

import play.db.jpa.*;public class UserControl extends Controller { final static Form<User> userForm = form(User.class); @Transactional public static Result register() {// DataSource ds = DB.getDataSource("epay");// try {//System.out.println("conn:"+!ds.getConnection().isClosed());//} catch (SQLException e) {//// TODO Auto-generated catch block//e.printStackTrace();//}     return ok(form.render()); }

方法加個@Transactional。

啟動測試看有無錯誤。