how do java play sql,Playframework(五)Java Project and SQL Database

当前位置:我的异常网» 数据库 » Playframework(五)Java Project and SQL Database

Playframework(五)Java Project and SQL Database

www.myexceptions.net  网友分享于：2013-01-09  浏览：53次

Playframework(5)Java Project and SQL Database

Playframework(5)Java Project and SQL Database

8. Accessing an SQL Database

Configuring JDBC connection pools

conf/application.conf

# Default database configuration

db.default.driver=org.h2.Driver

db.default.url="jdbc:h2:mem:play"

#Orders database

db.orders.driver=org.h2.Driver

db.orders.url="jdbc:h2:mem:order"

#customers database

db.customers.driver=org.h2.Driver

db.customers.url="jdbc:h2:mem:customers"

Accessing the JDBC database: Database ds = DB.getDatasource();

Obtaining a JDBC connection    Connection connection = DB.getConnection();

Exposing the datasource through JNDI

db.default.driver=org.h2.Driver

db.default.url="jdbc:h2:men:play"

db.default.jndiName=DefaultDS

Using Ebean ORM

http://www.avaje.org/

conf/application.conf:

ebean.default="models.*"

ebean.orders="models.Order, models.OrderItem"

ebean.customer="models.Customer, models.Address"

Using the play.dv.ebean.Model Superclass

@Entity

public class Task extends Model{

@Id

@Constraints.Min(10)

public Long id;

@constraints.Required

public String name;

public boolean done;

@Format.DateTime(pattern="dd/MM/yyyy")

public Data dueDate = new Date();

public static Finder find = new Finder(

Long.class, Task.class

);

}

Allmost like hibernate

Transactional actions

We need to enable the helper for that on Ebean.

Intergrating with JPA

Exposing the datasource through JNDI

Adding a JPA implementation to my project

"org.hibernate" % "hibernate-entitymanager" % "3.6.9.Final"

Creating a persistence unit

conf/META-INF/persistence.xml

Annotating JPA actions with @Transactional

Using the play.db.jpa.JPA helper

public static Company findById(Long id){

return JPA.em().find(Company.class, id);

}

9 The Play Cache API

The default cache API uses EHCache.    play.cache.Cache

Cache.set("item.key", frontPageNews);

News news = Cache.get("item.key");

Remove the cache, Cache.set("item.key", null, 0)       Cache.remove("item.key")

Caching HTTP Responses

@Cached("homePage")

public static Result index(){

return ok("Hello world");

}

10. Calling WebService

play.libs.WS provides a way to make asynchronous HTTP calls.

We will use promise then.

11. Integration with Akka

12. Internationalization

13. Application Global Settings

The Global Object

We need to define a global object in the root package

import play.*;

public class Global extends GlobalSettings{

}

Intercepting application start-up and shutdown

public class Global extends GlobalSettings{

public void onStart(Application app){

Logger.info("Application has started");

}

public void onStop(Application app){

Logger.info("Application shutdown...");

}

}

Providing an application error page

When an exception occurs in my application, the onError operation will be called.

public class Global extends GlobalSettings{

public Result onError(Throwable t){

return internalSeverError(

views.html.errorPage(t)

);

}

}

Handling action not found

If the framework doesn't find an action method for a request, the onHandlerNotFound operation will be called:

public class Global extends GlobalSettings{

public Result onHandlerNotFound(String uri){

return notFound(

views.html.pageNotFound(uri)

);

}

}

The onBadRequest operation will be called if a route was found, but it was not possible to bind the request parameters.

public class Global extends GlobalSettings{

public Result onBadRequest(String uri, String error){

return badRequest("Don't try to hack the URI!");

}

}

Intercepting Requests

One important aspect of the GlobalSettings class is that it provides a way to intercept requests and execute business logic before a request is dispatched to an action.

public class Global extends GlobalSettings{

public Action onRequest(Request request, Method actionMethod){

System.out.println("before each request…" + request.toString());

return super.onRequest(request, actionMethod);

}

}

14. Testing Your Application

Using JUnit and Running a fake application

fakeApplication(inMemoryDatabase())

Writing functional tests

Testing a template

@Test

public void renderTemplate(){

Content html = views.html.index.render("Coco");

assertThat(contentType(html)).isEqualTo("text/html");

assertThat(ContentAsString(html)).contains("Coco");

}

Testing your controllers

@Test

public void callIndex(){

Result result = callAction(

controllers.routes.ref.Application.index("Kiko");

);

assertThat(status(result)).isEqualTo(OK);

assertThat(contentType(result)).isEqualTo("text/html");

assertThat(charset(result)).isEqualTo("utf-8");

assertThat(contentAsString(result)).contains("Hello Kiki");

}

Testing the router

Instead of calling the Action, we can let the Router do it.

@Test

public void badRoute(){

Result result = routeAndCall(fakeRequest(GET, "/xx/Kiki"));

assertThat(result).isNull();

}

Starting a real HTTP server

@Test

public void testInServer(){

running(testServe(3333), new Callback0(){

assertThat(

WS.url("http://localhot:3333").get().get().status

).isEqualTo(OK);

});

}

Testing from within a web browser

Selenium WebDriver

@Test

public void runInBrowser(){

running(testServer(3333), HTMLUNIT, new Callback(){

public void invoke(TestBrowser browser){

browser.goTo("http://localhost:3333");

assertThat(browser.$("#title").getTexts().get(0)).isEqualTo("Hello Guest");

browser.$("a").click();

assertThat(browser.url()).isEqualTo("http://localhost:3333/Coco");

assertThat(browser.$("#title", 0).getText()).isEqualTo("Hello Coco");

}

})

}

References:

http://www.playframework.org/documentation/2.0.4/JavaHome

http://www.playframework.org/documentation/2.0.4/JavaDatabase

文章评论