package de.vogella.gae.java.todo.model;

import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;

/**
 * Model class which will store the Todo Items
 * 
 * @author Lars Vogel
 * 
 */
@Entity
public class Todo {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;
    private String author;

    private String summary;
    private String description;
    private String url;
    boolean finished;

    public Todo(String author, String summary, String description,
            String url) {
        this.author = author;
        this.summary = summary;
        this.description = description;
        this.url = url;
        finished = false;
    }

    public Long getId() {
        return id;
    }

    public String getAuthor() {
        return author;
    }

    public void setAuthor(String author) {
        this.author = author;
    }

    public String getShortDescription() {
        return summary;
    }

    public void setShortDescription(String shortDescription) {
        this.summary = shortDescription;
    }

    public String getLongDescription() {
        return description;
    }

    public void setLongDescription(String longDescription) {
        this.description = longDescription;
    }

    public String getUrl() {
        return url;
    }

    public void setUrl(String url) {
        this.url = url;
    }

    public boolean isFinished() {
        return finished;
    }

    public void setFinished(boolean finished) {
        this.finished = finished;
    }

}

<?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_1_0.xsd" version="1.0">

    <persistence-unit name="transactions-optional">
        <provider>org.datanucleus.store.appengine.jpa.DatastorePersistenceProvider</provider>
        <properties>
            <property name="datanucleus.NontransactionalRead" value="true"/>
            <property name="datanucleus.NontransactionalWrite" value="true"/>
            <property name="datanucleus.ConnectionURL" value="appengine"/>
        </properties>
    </persistence-unit>
</persistence>

package de.vogella.gae.java.todo.dao;

import javax.persistence.EntityManagerFactory;
import javax.persistence.Persistence;

public class EMFService {
    private static final EntityManagerFactory emfInstance = Persistence
            .createEntityManagerFactory("transactions-optional");

    private EMFService() {
    }

    public static EntityManagerFactory get() {
        return emfInstance;
    }
}

package de.vogella.gae.java.todo.dao;

import java.util.List;

import javax.persistence.EntityManager;
import javax.persistence.Query;

import de.vogella.gae.java.todo.model.Todo;

public enum Dao {
    INSTANCE;

    public List<Todo> listTodos() {
        EntityManager em = EMFService.get().createEntityManager();
        // read the existing entries
        Query q = em.createQuery("select m from Todo m");
        List<Todo> todos = q.getResultList();
        return todos;
    }

    public void add(String userId, String summary, String description,
            String url) {
        synchronized (this) {
            EntityManager em = EMFService.get().createEntityManager();
            Todo todo = new Todo(userId, summary, description, url);
            em.persist(todo);
            em.close();
        }
    }

    public List<Todo> getTodos(String userId) {
        EntityManager em = EMFService.get().createEntityManager();
        Query q = em
                .createQuery("select t from Todo t where t.author = :userId");
        q.setParameter("userId", userId);
        List<Todo> todos = q.getResultList();
        return todos;
    }

    public void remove(long id) {
        EntityManager em = EMFService.get().createEntityManager();
        try {
            Todo todo = em.find(Todo.class, id);
            em.remove(todo);
        } finally {
            em.close();
        }
    }
}

package de.vogella.gae.java.todo;

import java.io.IOException;

import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.google.appengine.api.users.User;
import com.google.appengine.api.users.UserService;
import com.google.appengine.api.users.UserServiceFactory;

import de.vogella.gae.java.todo.dao.Dao;

@SuppressWarnings("serial")
public class ServletCreateTodo extends HttpServlet {
    public void doPost(HttpServletRequest req, HttpServletResponse resp)
            throws IOException {
        System.out.println("Creating new todo ");
        User user = (User) req.getAttribute("user");
        if (user == null) {
            UserService userService = UserServiceFactory.getUserService();
            user = userService.getCurrentUser();
        }

        String summary = checkNull(req.getParameter("summary"));
        String longDescription = checkNull(req.getParameter("description"));
        String url = checkNull(req.getParameter("url"));

        Dao.INSTANCE.add(user.getUserId(), summary, longDescription, url);

        resp.sendRedirect("/TodoApplication.jsp");
    }

    private String checkNull(String s) {
        if (s == null) {
            return "";
        }
        return s;
    }
}

package de.vogella.gae.java.todo;

import java.io.IOException;

import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import de.vogella.gae.java.todo.dao.Dao;

public class ServletRemoveTodo extends HttpServlet {
    private static final long serialVersionUID = 1L;

    public void doGet(HttpServletRequest req, HttpServletResponse resp)
    throws IOException {
        String id = req.getParameter("id");
        Dao.INSTANCE.remove(Long.parseLong(id));
        resp.sendRedirect("/TodoApplication.jsp");
    }
}

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ page import="java.util.List" %>
<%@ page import="com.google.appengine.api.users.User" %>
<%@ page import="com.google.appengine.api.users.UserService" %>
<%@ page import="com.google.appengine.api.users.UserServiceFactory" %>
<%@ page import="de.vogella.gae.java.todo.model.Todo" %>
<%@ page import="de.vogella.gae.java.todo.dao.Dao" %>

<!DOCTYPE html>


<%@page import="java.util.ArrayList"%>

<html>
    <head>
        <title>Todos</title>
        <link rel="stylesheet" type="text/css" href="css/main.css"/>
          <meta charset="utf-8"> 
    </head>
    <body>
<%
Dao dao = Dao.INSTANCE;

UserService userService = UserServiceFactory.getUserService();
User user = userService.getCurrentUser();

String url = userService.createLoginURL(request.getRequestURI());
String urlLinktext = "Login";
List<Todo> todos = new ArrayList<Todo>();
            
if (user != null){
    url = userService.createLogoutURL(request.getRequestURI());
    urlLinktext = "Logout";
    todos = dao.getTodos(user.getUserId());
}
    
%>
    <div style="width: 100%;">
        <div class="line"></div>
        <div class="topLine">
            <div style="float: left;"><img src="images/todo.png" /></div>
            <div style="float: left;" class="headline">Todos</div>
            <div style="float: right;"><a href="<%=url%>"><%=urlLinktext%></a> <%=(user==null? "" : user.getNickname())%></div>
        </div>
    </div>

<div style="clear: both;"/> 
You have a total number of <%= todos.size() %>  Todos.

<table>
  <tr>
      <th>Short description </th>
      <th>Long Description</th>
      <th>URL</th>
      <th>Done</th>
    </tr>

<% for (Todo todo : todos) {%>
<tr> 
<td>
<%=todo.getShortDescription()%>
</td>
<td>
<%=todo.getLongDescription()%>
</td>
<td>
<%=todo.getUrl()%>
</td>
<td>
<a class="done" href="/done?id=<%=todo.getId()%>" >Done</a>
</td>
</tr> 
<%}
%>
</table>


<hr />

<div class="main">

<div class="headline">New todo</div>

<% if (user != null){ %> 

<form action="/new" method="post" accept-charset="utf-8">
    <table>
        <tr>
            <td><label for="summary">Summary</label></td>
            <td><input type="text" name="summary" id="summary" size="65"/></td>
        </tr>
        <tr>
            <td valign="description"><label for="description">Description</label></td>
            <td><textarea rows="4" cols="50" name="description" id="description"></textarea></td>
        </tr>
    <tr>
        <td valign="top"><label for="url">URL</label></td>
        <td><input type="url" name="url" id="url" size="65" /></td>
    </tr>
    <tr>
            <td colspan="2" align="right"><input type="submit" value="Create"/></td>
        </tr>
    </table>
</form>

<% }else{ %>

Please login with your Google account

<% } %>
</div>
</body>
</html>

body {
    margin: 5px; 
    font-family: Arial, Helvetica, sans-serif;
}

hr {
    border: 0;
    background-color: #DDDDDD;
    height: 1px;
    margin: 5px;
}



table th {
    background:#EFEFEF none repeat scroll 0 0;
    border-top:1px solid #CCCCCC;
    font-size:small;
    padding-left:5px;
    padding-right:4px;
    padding-top:4px;
    vertical-align:top;
    text-align:left;
}

table tr {  
    background-color: #e5ecf9;
    font-size:small;
}


.topLine {
    height: 1.25em;
    background-color: #e5ecf9;
    padding-left: 4px;
    padding-right: 4px;
    padding-bottom: 3px;
    padding-top: 2px;
}

.headline {
    font-weight: bold;
    color: #3366cc;
}



.done {
    font-size: x-small;
    vertical-align: top;
}


.email {
    font-size: x-small;
    vertical-align: top;
}

form td {
    font-size: smaller;
}

<?xml version="1.0" encoding="utf-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xmlns="http://java.sun.com/xml/ns/javaee" xmlns:web="http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"
    xsi:schemaLocation="http://java.sun.com/xml/ns/javaee
http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"
    version="2.5">
    <servlet>
        <servlet-name>CreateNewTodo</servlet-name>
        <servlet-class>de.vogella.gae.java.todo.ServletCreateTodo</servlet-class>
    </servlet>
    <servlet>
        <servlet-name>RemoveTodo</servlet-name>
        <servlet-class>de.vogella.gae.java.todo.ServletRemoveTodo</servlet-class>
    </servlet>
    <servlet-mapping>
        <servlet-name>RemoveTodo</servlet-name>
        <url-pattern>/done</url-pattern>
    </servlet-mapping>
    <servlet-mapping>
        <servlet-name>CreateNewTodo</servlet-name>
        <url-pattern>/new</url-pattern>
    </servlet-mapping>
    <welcome-file-list>
        <welcome-file>TodoApplication.jsp</welcome-file>
    </welcome-file-list>
</web-app>

<?xml version="1.0" encoding="utf-8"?>
<appengine-web-app xmlns="http://appengine.google.com/ns/1.0">
    <application>vogellatodo</application>
    <version>1</version>
    
    <!-- Configure java.util.logging -->
    <system-properties>
        <property name="java.util.logging.config.file" value="WEB-INF/logging.properties"/>
    </system-properties>
    
</appengine-web-app>

<admin-console>
        <page name="Static List" url="/static.html" />
</admin-console>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>
  <head>
    <meta http-equiv="content-type" content="text/html; charset=UTF-8">
    <title>Integrated into the Admin Console</title>
  </head>

  <body>
    <h1>Hello Admin Console!</h1>
    
    <table>
      <tr>
        <td colspan="2" style="font-weight:bold;">This could be a dynamic site:</td>        
      </tr>
      <tr>
        <td>But it isn't.</td>
      </tr>
    </table>
  </body>
</html>