Tutoriel Hibernate/JPA - Spring2.5 - Tapestry5

<properties>
    <env>LOCAL</env>
    <maven.test.failure.ignore>true</maven.test.failure.ignore>
 
    <mysql-version>5.1.6</mysql-version>
    <hibernate-version>3.2.6.GA</hibernate-version>
    <hibernate-annotations-version>3.3.1.GA</hibernate-annotations-version>
    <hibernate-entitymanager-version>3.3.2.GA</hibernate-entitymanager-version>
    <tapestry-version>5.0.18</tapestry-version>
</properties>

<!-- MySQL -->
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>${mysql-version}</version>
</dependency>
 
<!-- Hibernate -->
<dependency>
    <groupId>org.hibernate</groupId>
    <artifactId>hibernate</artifactId>
    <version>${hibernate-version}</version>
</dependency>
 
<dependency>
    <groupId>org.hibernate</groupId>
    <artifactId>hibernate-annotations</artifactId>
    <version>${hibernate-annotations-version}</version>
</dependency>
 
<dependency>
    <groupId>org.hibernate</groupId>
    <artifactId>hibernate-entitymanager</artifactId>
    <version>${hibernate-entitymanager-version}</version>
</dependency>

CREATE DATABASE skillbrowser;
CREATE TABLE `skill` (
  `skill_id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(45) NOT NULL default '',
  PRIMARY KEY  (`skill_id`),
  UNIQUE KEY `UNIQUE_NAME` USING HASH (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE `user` (
  `user_id` int(10) unsigned NOT NULL auto_increment,
  `login` varchar(25) NOT NULL default '',
  `password` varchar(25) NOT NULL default '',
  `fullname` varchar(45) NOT NULL default '',
  PRIMARY KEY  (`user_id`),
  UNIQUE KEY `UNIQUE_LOGIN` USING BTREE (`login`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE `user_skills` (
  `user_id` int(10) unsigned NOT NULL default '0',
  `skill_id` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`user_id`,`skill_id`),
  KEY `FK_user_skills_2` (`skill_id`),
  CONSTRAINT `FK_user_skills_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`user_id`) ON DELETE CASCADE,
  CONSTRAINT `FK_user_skills_2` FOREIGN KEY (`skill_id`) REFERENCES `skill` (`skill_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

<?xml version="1.0" encoding="UTF-8"?>
<persistence version="1.0" xmlns="http://java.sun.com/xml/ns/persistence">
    <persistence-unit name="jpaTutos" transaction-type="RESOURCE_LOCAL">
        <provider>org.hibernate.ejb.HibernatePersistence</provider>
    </persistence-unit>
</persistence>

hibernate.connection.driver_class=com.mysql.jdbc.Driver
hibernate.connection.url=jdbc:mysql://localhost:3307/skillbrowser
hibernate.connection.username=skillbrowser
hibernate.connection.password=skillbrowser
hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect
hibernate.show_sql=true
jpa.dialect=org.springframework.orm.jpa.vendor.HibernateJpaDialect
jpa.vendor.adapter=HibernateJpaVendorAdapter

package net.ilabs.skillbrowser.domain.model;
 
// Generated 1 juil. 2008 17:15:44 by Hibernate Tools 3.2.0.CR1
 
import static javax.persistence.GenerationType.IDENTITY;
 
import java.util.HashSet;
import java.util.Set;
 
import javax.persistence.CascadeType;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.FetchType;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.JoinTable;
import javax.persistence.ManyToMany;
import javax.persistence.Table;
import javax.persistence.UniqueConstraint;
 
/**
 * User generated by hbm2java
 */
@Entity
@Table(name = "user", catalog = "tutotapestryspringhibernate", uniqueConstraints = @UniqueConstraint(columnNames = "login"))
public class User implements java.io.Serializable {
 
    private Integer userId;
    private String login;
    private String password;
    private String fullname;
    private Set<Skill> skills = new HashSet<Skill>(0);
 
    public User() {
    }
 
    public User(String login, String password, String fullname) {
        this.login = login;
        this.password = password;
        this.fullname = fullname;
    }
 
    public User(String login, String password, String fullname, Set<Skill> skills) {
        this.login = login;
        this.password = password;
        this.fullname = fullname;
        this.skills = skills;
    }
 
    @Id
    @GeneratedValue(strategy = IDENTITY)
    @Column(name = "user_id", unique = true, nullable = false)
    public Integer getUserId() {
        return this.userId;
    }
 
    public void setUserId(Integer userId) {
        this.userId = userId;
    }
 
    @Column(name = "login", unique = true, nullable = false, length = 25)
    public String getLogin() {
        return this.login;
    }
 
    public void setLogin(String login) {
        this.login = login;
    }
 
    @Column(name = "password", nullable = false, length = 25)
    public String getPassword() {
        return this.password;
    }
 
    public void setPassword(String password) {
        this.password = password;
    }
 
    @Column(name = "fullname", nullable = false, length = 45)
    public String getFullname() {
        return this.fullname;
    }
 
    public void setFullname(String fullname) {
        this.fullname = fullname;
    }
 
    @ManyToMany(cascade = CascadeType.ALL, fetch = FetchType.LAZY)
    @JoinTable(name = "user_skills", catalog = "tutotapestryspringhibernate",
        joinColumns = { @JoinColumn(name = "user_id", nullable = false, updatable = false) },
        inverseJoinColumns = { @JoinColumn(name = "skill_id", nullable = false, updatable = false) })
    public Set<Skill> getSkills() {
        return this.skills;
    }
 
    public void setSkills(Set<Skill> skills) {
        this.skills = skills;
    }
 
    public void addSkill(Skill skill) {
        skills.add(skill);
    }
 
    public void removeSkill(Skill skill) {
        skills.remove(skill);
    }
}

package net.ilabs.skillbrowser.domain.model;
 
// Generated 1 juil. 2008 17:15:44 by Hibernate Tools 3.2.0.CR1
 
import static javax.persistence.GenerationType.IDENTITY;
 
import java.util.HashSet;
import java.util.Set;
 
import javax.persistence.CascadeType;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.FetchType;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.ManyToMany;
import javax.persistence.Table;
import javax.persistence.UniqueConstraint;
 
/**
 * Skill generated by hbm2java
 */
@Entity
@Table(name = "skill", catalog = "tutotapestryspringhibernate", uniqueConstraints = @UniqueConstraint(columnNames = "name"))
public class Skill implements java.io.Serializable {
 
    private Integer skillId;
    private String name;
    private Set<User> users = new HashSet<User>(0);
 
    public Skill() {
    }
 
    public Skill(String name) {
        this.name = name;
    }
 
    public Skill(String name, Set<User> users) {
        this.name = name;
        this.users = users;
    }
 
    @Id
    @GeneratedValue(strategy = IDENTITY)
    @Column(name = "skill_id", unique = true, nullable = false)
    public Integer getSkillId() {
        return this.skillId;
    }
 
    public void setSkillId(Integer skillId) {
        this.skillId = skillId;
    }
 
    @Column(name = "name", unique = true, nullable = false, length = 45)
    public String getName() {
        return this.name;
    }
 
    public void setName(String name) {
        this.name = name;
    }
 
    @ManyToMany(cascade = CascadeType.ALL, fetch = FetchType.LAZY, mappedBy = "skills")
    public Set<User> getUsers() {
        return this.users;
    }
 
    public void setUsers(Set<User> users) {
        this.users = users;
    }
}

    <properties>
        &#8230;&#8230;&#8230;&#8230;
 
        <spring-version>2.5.6</spring-version>
    </properties>

        <!-- Spring Framework -->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-context</artifactId>
            <version>${spring-version}</version>
        </dependency>
 
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-aop</artifactId>
            <version>${spring-version}</version>
        </dependency>
 
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-context-support</artifactId>
            <version>${spring-version}</version>
        </dependency>
 
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-tx</artifactId>
            <version>${spring-version}</version>
        </dependency>
 
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-orm</artifactId>
            <version>${spring-version}</version>
        </dependency>
 
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-core</artifactId>
            <version>${spring-version}</version>
        </dependency>
 
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-jdbc</artifactId>
            <version>${spring-version}</version>
        </dependency>
 
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-web</artifactId>
            <version>${spring-version}</version>
        </dependency>
 
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-beans</artifactId>
            <version>${spring-version}</version>
        </dependency>
 
        <dependency>
            <groupId>org.apache.tapestry</groupId>
            <artifactId>tapestry-spring</artifactId>
            <version>${tapestry-version}</version>
        </dependency>

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xmlns:context="http://www.springframework.org/schema/context"
    xmlns:tx="http://www.springframework.org/schema/tx"
    xsi:schemaLocation="http://www.springframework.org/schema/beans 
           http://www.springframework.org/schema/beans/spring-beans-2.5.xsd
           http://www.springframework.org/schema/context
           http://www.springframework.org/schema/context/spring-context-2.5.xsd
           http://www.springframework.org/schema/tx 
           http://www.springframework.org/schema/tx/spring-tx-2.5.xsd">
 
 
    <!-- Placholders to import inherited variables -->
    <bean id="project-properties" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
        <property name="ignoreUnresolvablePlaceholders">
            <value>true</value>
        </property>
        <property name="locations">
            <list>
                <value>
                    classpath*:net/ilabs/skillbrowser/domain/dao/database.properties
                </value>
            </list>
        </property>
    </bean>
 
    <!-- post-processors for all standard config annotations -->
    <context:annotation-config />
    <context:component-scan base-package="net.ilabs.skillbrowser" />
 
    <!-- Exception translation bean post processor -->
    <bean class="org.springframework.dao.annotation.PersistenceExceptionTranslationPostProcessor" />
 
    <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource" destroy-method="close">
        <property name="driverClassName" value="${hibernate.connection.driver_class}" />
        <property name="url" value="${hibernate.connection.url}" />
        <property name="username" value="${hibernate.connection.username}" />
        <property name="password" value="${hibernate.connection.password}" />
    </bean>
 
    <bean id="entityManagerFactory" class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean">
        <property name="dataSource" ref="dataSource" />
        <property name="jpaDialect">
            <bean class="${jpa.dialect}" />
        </property>
        <property name="jpaVendorAdapter">
            <bean class="org.springframework.orm.jpa.vendor.${jpa.vendor.adapter}">
                <property name="showSql" value="${hibernate.show_sql}" />
                <property name="databasePlatform" value="${hibernate.dialect}" />
                <!-- On ne genere pas la BDD au demarrage -->
                <property name="generateDdl" value="false" />
            </bean>
        </property>
    </bean>
 
    <bean id="txManager" class="org.springframework.orm.jpa.JpaTransactionManager">
        <property name="entityManagerFactory" ref="entityManagerFactory" />
    </bean>
 
    <!-- enable the configuration of transactional behavior based on annotations -->
    <tx:annotation-driven transaction-manager="txManager" />
 
</beans>

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE web-app
        PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
        "http://java.sun.com/dtd/web-app_2_3.dtd">
<web-app>
    <display-name>SkillBrowser</display-name>
 
    <context-param>
        <param-name>contextConfigLocation</param-name>
        <param-value>classpath*:net/ilabs/skillbrowser/domain/dao/applicationContext*.xml</param-value>
    </context-param>
 
    <context-param>
        <!-- The only significant configuration for Tapestry 5, this informs Tapestry of where to look for pages, components and mixins. -->
        <param-name>tapestry.app-package</param-name>
        <param-value>net.ilabs.skillbrowser.web</param-value>
    </context-param>
 
    <filter> 
        <filter-name>JpaFilter</filter-name>
        <filter-class>org.springframework.orm.jpa.support.OpenEntityManagerInViewFilter</filter-class>
    </filter>
 
    <filter-mapping>
        <filter-name>JpaFilter</filter-name>
        <url-pattern>/*</url-pattern>
    </filter-mapping>
 
    <filter>
        <filter-name>app</filter-name>
        <filter-class>org.apache.tapestry5.spring.TapestrySpringFilter</filter-class>
    </filter>
 
    <filter-mapping>
        <filter-name>app</filter-name>
        <url-pattern>/*</url-pattern>
    </filter-mapping>
 
    <listener>
        <listener-class>
            org.springframework.web.context.ContextLoaderListener
        </listener-class>
    </listener>
 
    <welcome-file-list>
        <welcome-file>Index</welcome-file>
    </welcome-file-list>
</web-app>

package net.ilabs.skillbrowser.domain.dao;
 
import java.util.List;
 
import net.ilabs.skillbrowser.domain.model.User;
 
/**
 * DAO for domain model class User.
 * 
 * @see net.ilabs.skillbrowser.domain.model.User
 * @author loic.frering
 */
public interface UserDao {
 
    /**
     * Persist a User entity in the database
     * 
     * @param transientUser
     */
    public void persist(User transientUser);
 
    /**
     * Remove a persisted User from the database
     * 
     * @param persistentUser
     */
    public void remove(User persistentUser);
 
    /**
     * Remove a persisted User from the database
     * 
     * @param userId
     */
    public void remove(Integer userId);
 
    /**
     * Update a User in the database
     * 
     * @param detachedUser
     * @return merged User
     */
    public User merge(User detachedUser);
 
    /**
     * Find a User by id
     * 
     * @param id
     * @return the found User
     */
    public User findById(Integer id);
 
    /**
     * Find a User by login
     * 
     * @param login
     * @return the found User
     */
    public User findByLogin(String login);
 
    /**
     * Find a User by fullname
     * 
     * @param fullname
     * @return the found User
     */
    public User findByFullname(String fullname);
 
    /**
     * Find a User by his fullname
     * 
     * @return the found User
     */
    public List<User> findAll();
 
    /**
     * Search Users
     * 
     * @param searchString
     * @return the found Users
     */
    public List<User> search(String searchString);
 
}

package net.ilabs.skillbrowser.domain.dao.jpa;
 
import java.util.ArrayList;
import java.util.List;
 
import javax.persistence.EntityManager;
import javax.persistence.PersistenceContext;
import javax.persistence.Query;
 
import net.ilabs.skillbrowser.domain.dao.UserDao;
import net.ilabs.skillbrowser.domain.model.User;
 
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.springframework.stereotype.Repository;
 
/**
 * DAO for domain model class User.
 * 
 * @see net.ilabs.skillbrowser.domain.model.User
 * @author loic.frering
 */
@Repository("userDao")
public class JpaUserDao implements UserDao {
 
    private static final Log log = LogFactory.getLog(JpaUserDao.class);
 
    @PersistenceContext
    private EntityManager entityManager;
 
    /**
     * {@inheritDoc}
     */
    public void persist(User transientUser) {
        log.debug("persisting User instance");
        try {
            entityManager.persist(transientUser);
            log.debug("persist successful");
        } catch (RuntimeException re) {
            log.error("persist failed", re);
        }
    }
 
    /**
     * {@inheritDoc}
     */
    public void remove(User persistentUser) {
        log.debug("removing User instance");
        try {
            entityManager.remove(persistentUser);
            log.debug("remove successful");
        } catch (RuntimeException re) {
            log.error("remove failed", re);
        }
    }
 
    /**
     * {@inheritDoc}
     */
    public void remove(Integer userId) {
        this.remove(this.findById(userId));
    }
 
    /**
     * {@inheritDoc}
     */
    public User merge(User detachedUser) {
        log.debug("merging User instance");
        try {
            User result = entityManager.merge(detachedUser);
            log.debug("merge successful");
            return result;
        } catch (RuntimeException re) {
            log.error("merge failed", re);
            return null;
        }
    }
 
    /**
     * {@inheritDoc}
     */
    public User findById(Integer id) {
        log.debug("getting User instance with id: " + id);
        try {
            User instance = entityManager.find(User.class, id);
            log.debug("findById successful");
            return instance;
        } catch (RuntimeException re) {
            log.error("findById failed", re);
            return null;
        }
    }
 
    /**
     * {@inheritDoc}
     */
    public User findByLogin(String login) {
        log.debug("getting User instance with login: " + login);
        try {
            Query query = entityManager.createQuery("select u from User u where u.login like :login");
            query.setParameter("login", login);
            User user = (User) query.getSingleResult();
            log.debug("findByLogin successful");
            return user;
        } catch (RuntimeException re) {
            log.error("findByLogin failed", re);
            return null;
        }
    }
 
    /**
     * {@inheritDoc}
     */
    public User findByFullname(String fullname) {
        log.debug("getting User instance with fullname: " + fullname);
        try {
            Query query = entityManager.createQuery("select u from User u where u.fullname like :fullname");
            query.setParameter("fullname", fullname);
            User user = (User) query.getSingleResult();
            log.debug("findByFullname successful");
            return user;
        } catch (RuntimeException re) {
            log.error("findByFullname failed", re);
            return null;
        }
    }
 
    /**
     * {@inheritDoc}
     */
    public List<User> findAll() {
        log.debug("getting all User instances");
        try {
            Query query = entityManager.createQuery("select u from User u");
            List<User> userList = (List<User>) query.getResultList();
            log.debug("findAll successful");
            return userList;
        } catch (RuntimeException re) {
            log.error("findAll failed", re);
            return new ArrayList<User>();
        }
    }
 
    /**
     * {@inheritDoc}
     */
    public List<User> search(String searchString) {
        log.debug("Search User instances with search string: " + searchString);
        try {
            Query query = entityManager.createQuery("select u from User u where u.login like :searchString or u.fullname like :searchString");
            query.setParameter("searchString", searchString);
            List<User> userList = (List<User>) query.getResultList();
            log.debug("search successful");
            return userList;
        } catch (RuntimeException re) {
            log.error("search failed", re);
            return new ArrayList<User>();
        }
    }
 
}

package net.ilabs.skillbrowser.domain.dao;
 
import java.util.List;
 
import net.ilabs.skillbrowser.domain.model.Skill;
 
/**
 * DAO for domain model class Skill.
 * 
 * @see net.ilabs.skillbrowser.domain.model.Skill
 * @author loic.frering
 */
public interface SkillDao {
 
    /**
     * Persist a Skill entity in the database
     * 
     * @param transientSkill
     */
    public void persist(Skill transientSkill);
 
    /**
     * Remove a persisted Skill from the database
     * 
     * @param persistentSkill
     */
    public void remove(Skill persistentSkill);
 
    /**
     * Remove a persisted Skill from the database
     * 
     * @param persistentSkill
     */
    public void remove(Integer skillId);
 
    /**
     * Update a Skill in the database
     * 
     * @param detachedSkill
     * @return merged Skill
     */
    public Skill merge(Skill detachedSkill);
 
    /**
     * Find a Skill by id
     * 
     * @param id
     * @return the found Skill
     */
    public Skill findById(Integer id);
 
    /**
     * Find a Skill by name
     * 
     * @param id
     * @return the found Skill
     */
    public Skill findByName(String name);
 
    /**
     * Find all Skills
     * 
     * @param id
     * @return the found Skills
     */
    public List<Skill> findAll();
}

package net.ilabs.skillbrowser.domain.dao.jpa;
 
import java.util.ArrayList;
import java.util.List;
 
import javax.persistence.EntityManager;
import javax.persistence.PersistenceContext;
import javax.persistence.Query;
 
import net.ilabs.skillbrowser.domain.dao.SkillDao;
import net.ilabs.skillbrowser.domain.model.Skill;
import net.ilabs.skillbrowser.domain.model.User;
 
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.springframework.stereotype.Repository;
 
/**
 * JPA implementation of the DAO for domain model class Skill.
 * 
 * @see net.ilabs.skillbrowser.domain.model.Skill
 * @author loic.frering
 */
@Repository("skillDao")
public class JpaSkillDao implements SkillDao {
 
    private static final Log log = LogFactory.getLog(JpaSkillDao.class);
 
    @PersistenceContext
    private EntityManager entityManager;
 
    /**
     * {@inheritDoc}
     */
    public void persist(Skill transientSkill) {
        log.debug("persisting Skill instance");
        try {
            entityManager.persist(transientSkill);
            log.debug("persist successful");
        } catch (RuntimeException re) {
            log.error("persist failed", re);
        }
    }
 
    /**
     * {@inheritDoc}
     */
    public void remove(Skill persistentSkill) {
        log.debug("removing Skill instance");
        try {
            entityManager.remove(persistentSkill);
            log.debug("remove successful");
        } catch (RuntimeException re) {
            log.error("remove failed", re);
        }
    }
 
    /**
     * {@inheritDoc}
     */
    public void remove(Integer skillId) {
        this.remove(this.findById(skillId));
    }
 
    /**
     * {@inheritDoc}
     */
    public Skill merge(Skill detachedSkill) {
        log.debug("merging Skill instance");
        try {
            Skill result = entityManager.merge(detachedSkill);
            log.debug("merge successful");
            return result;
        } catch (RuntimeException re) {
            log.error("merge failed", re);
            return null;
        }
    }
 
    /**
     * {@inheritDoc}
     */
    public Skill findById(Integer id) {
        log.debug("getting Skill instance with id: " + id);
        try {
            Skill instance = entityManager.find(Skill.class, id);
            log.debug("findById successful");
            return instance;
        } catch (RuntimeException re) {
            log.error("findById failed", re);
            return null;
        }
    }
 
    /**
     * {@inheritDoc}
     */
    public Skill findByName(String name) {
        log.debug("getting Skill instance with name: " + name);
        try {
            Query query = entityManager.createQuery("select s from Skill s where s.name like :name");
            query.setParameter("name", name);
            Skill skill = (Skill) query.getSingleResult();
            log.debug("findByName successful");
            return skill;
        } catch (RuntimeException re) {
            log.error("findByName failed", re);
            return null;
        }
    }
 
    /**
     * {@inheritDoc}
     */
    public List<Skill> findAll() {
        log.debug("getting all Skill instances");
        try {
            Query query = entityManager.createQuery("select s from Skill s order by s.name asc");
            List<Skill> skillList = query.getResultList();
            log.debug("findAll successful");
            return skillList;
        } catch (RuntimeException re) {
            log.error("findAll failed", re);
            return new ArrayList<Skill>();
        }
    }
 
}

package net.ilabs.skillbrowser.service;
 
import java.util.List;
 
import net.ilabs.skillbrowser.domain.model.User;
 
/**
 * Manager for domain model class User
 * 
 * @see net.ilabs.skillbrowser.service.User
 * @author loic.frering
 */
public interface UserManager {
 
    /**
     * Persist a User entity in the database
     * 
     * @param transientUser
     */
    public void persist(User transientUser);
 
    /**
     * Remove a persisted User from the database
     * 
     * @param persistentUser
     */
    public void remove(User persistentUser);
 
    /**
     * Update a User in the database
     * 
     * @param detachedUser
     * @return merged User
     */
    public User merge(User detachedUser);
 
    /**
     * Find a User by id
     * 
     * @param id
     * @return the found User
     */
    public User findById(Integer id);
 
    /**
     * Find a User by login
     * 
     * @param login
     * @return the found User
     */
    public User findByLogin(String login);
 
    /**
     * Find a User by fullname
     * 
     * @param fullname
     * @return the found User
     */
    public User findByFullname(String fullname);
 
    /**
     * Find a User by his fullname
     * 
     * @return the found User
     */
    public List<User> findAll();
 
    /**
     * Search Users
     * 
     * @param searchString
     * @return the found Users
     */
    public List<User> search(String searchString);
 
}
 
L'implémentation :
package net.ilabs.skillbrowser.service.impl;
 
import java.util.List;
 
import net.ilabs.skillbrowser.domain.dao.UserDao;
import net.ilabs.skillbrowser.domain.model.User;
import net.ilabs.skillbrowser.service.UserManager;
 
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Propagation;
import org.springframework.transaction.annotation.Transactional;
 
@Service("userManager")
@Transactional(propagation = Propagation.REQUIRED, readOnly = true)
public class UserManagerImpl implements UserManager {
 
    private final Log log = LogFactory.getLog(this.getClass());
 
    @Autowired
    private UserDao userDao;
 
    /**
     * {@inheritDoc}
     */
    public List<User> findAll() {
        return userDao.findAll();
    }
 
    /**
     * {@inheritDoc}
     */
    public User findByFullname(String fullname) {
        return userDao.findByFullname(fullname);
    }
 
    /**
     * {@inheritDoc}
     */
    public User findById(Integer id) {
        return userDao.findById(id);
    }
 
    /**
     * {@inheritDoc}
     */
    public User findByLogin(String login) {
        return userDao.findByLogin(login);
    }
 
    /**
     * {@inheritDoc}
     */
    @Transactional(readOnly = false)
    public User merge(User detachedUser) {
        return userDao.merge(detachedUser);
    }
 
    /**
     * {@inheritDoc}
     */
    @Transactional(readOnly = false)
    public void persist(User transientUser) {
        userDao.persist(transientUser);
    }
 
    /**
     * {@inheritDoc}
     */
    @Transactional(readOnly = false)
    public void remove(User persistentUser) {
        userDao.remove(persistentUser);
    }
 
    /**
     * {@inheritDoc}
     */
    @Transactional(readOnly = false)
    public void remove(Integer userId) {
        userDao.remove(userId);
    }
 
    /**
     * {@inheritDoc}
     */
    public List<User> search(String searchString) {
        return userDao.search(searchString);
    }
 
}

package net.ilabs.skillbrowser.service;
 
import java.util.List;
 
import net.ilabs.skillbrowser.domain.model.Skill;
 
/**
 * Manager for domain model class Skill.
 * 
 * @see net.ilabs.skillbrowser.domain.model.Skill
 * @author loic.frering
 */
public interface SkillManager {
    /**
     * Persist a Skill entity in the database
     * 
     * @param transientSkill
     */
    public void persist(Skill transientSkill);
 
    /**
     * Remove a persisted Skill from the database
     * 
     * @param persistentSkill
     */
    public void remove(Skill persistentSkill);
 
    /**
     * Update a Skill in the database
     * 
     * @param detachedSkill
     * @return merged Skill
     */
    public Skill merge(Skill detachedSkill);
 
    /**
     * Find a Skill by id
     * 
     * @param id
     * @return the found Skill
     */
    public Skill findById(Integer id);
 
    /**
     * Find a Skill by name
     * 
     * @param id
     * @return the found Skill
     */
    public Skill findByName(String name);
 
    /**
     * Find all Skills
     * 
     * @param id
     * @return the found Skills
     */
    public List<Skill> findAll();
}

package net.ilabs.skillbrowser.service.impl;
 
import java.util.List;
 
import net.ilabs.skillbrowser.domain.dao.SkillDao;
import net.ilabs.skillbrowser.domain.model.Skill;
import net.ilabs.skillbrowser.service.SkillManager;
 
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Propagation;
import org.springframework.transaction.annotation.Transactional;
 
@Service("skillManager")
@Transactional(propagation = Propagation.REQUIRED, readOnly = true)
public class SkillManagerImpl implements SkillManager {
 
    private final Log log = LogFactory.getLog(this.getClass());
 
    @Autowired
    private SkillDao skillDao;
 
    /**
     * {@inheritDoc}
     */
    public List<Skill> findAll() {
        return skillDao.findAll();
    }
 
    /**
     * {@inheritDoc}
     */
    public Skill findById(Integer id) {
        return skillDao.findById(id);
    }
 
    /**
     * {@inheritDoc}
     */
    public Skill findByName(String name) {
        return skillDao.findByName(name);
    }
 
    /**
     * {@inheritDoc}
     */
    @Transactional(readOnly = false)
    public Skill merge(Skill detachedSkill) {
        return skillDao.merge(detachedSkill);
    }
 
    /**
     * {@inheritDoc}
     */
    @Transactional(readOnly = false)
    public void persist(Skill transientSkill) {
        skillDao.persist(transientSkill);
    }
 
    /**
     * {@inheritDoc}
     */
    @Transactional(readOnly = false)
    public void remove(Skill persistentSkill) {
        skillDao.remove(persistentSkill);
    }
 
    /**
     * {@inheritDoc}
     */
    @Transactional(readOnly = false)
    public void remove(Integer skillId) {
        skillDao.remove(skillId);
    }
 
}

@Transactional(propagation = Propagation.REQUIRED, readOnly = true)

@Transactional(readOnly = false)

package net.ilabs.skillbrowser.web.pages.skills;
 
import java.util.List;
 
import net.ilabs.skillbrowser.domain.model.Skill;
import net.ilabs.skillbrowser.service.SkillManager;
 
import org.apache.tapestry5.annotations.OnEvent;
import org.apache.tapestry5.annotations.Property;
import org.apache.tapestry5.ioc.annotations.Inject;
 
public class SkillsIndex {
 
    @Inject
    private SkillManager skillManager;
 
    @Property
    private Skill skill;
 
    public List<Skill> getSkillList() {
        return skillManager.findAll();
    }
 
    @OnEvent(value="action", component="DeleteSkill")
    public void deleteSkill(Integer skillId) {
        skillManager.remove(skillId);
    }
}

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns:t="http://tapestry.apache.org/schema/tapestry_5_0_0.xsd">
    <head>
        <title>Skills</title>
    </head>
    <body>
        <h1>Skills</h1>
        <ul>
            <li t:type="loop" t:source="skillList" t:value="skill">
                ${skill.name}
                - <t:pagelink page="skills/Save" context="skill.skillId">Edit</t:pagelink>
                - <t:actionlink t:id="deleteSkill" context="skill.skillId">Delete</t:actionlink>
            </li>
        </ul>
        <p>
            <t:pagelink page="skills/Save">New skill</t:pagelink>
        </p>
    </body>
</html>

package net.ilabs.skillbrowser.web.pages.skills;
 
import net.ilabs.skillbrowser.domain.model.Skill;
import net.ilabs.skillbrowser.service.SkillManager;
 
import org.apache.tapestry5.annotations.Component;
import org.apache.tapestry5.annotations.OnEvent;
import org.apache.tapestry5.annotations.Property;
import org.apache.tapestry5.corelib.components.Form;
import org.apache.tapestry5.corelib.components.TextField;
import org.apache.tapestry5.ioc.annotations.Inject;
import org.springframework.dao.DataIntegrityViolationException;
 
public class SkillsSave {
 
    @Inject
    private SkillManager skillManager;
 
    @Component(id = "add_skill_form")
    private Form addSkillForm;
 
    @Component
    private TextField skillName;
 
    @Property
    private Skill skill;
 
    @OnEvent("activate")
    public void activate() {
        skill = new Skill();
    }
 
    @OnEvent("activate")
    public Boolean activate(Integer id) {
        skill = skillManager.findById(id);
        if(null == skill) {
            return false;
        }
        return true;
    }
 
    @OnEvent("passivate")
    public Integer passivate() {
        return (skill != null) ? skill.getSkillId() : null;
    }
 
    @OnEvent(Form.SUCCESS)
    public String addSkillSuccess() {
        try {
            skillManager.persist(skill);
        } catch (DataIntegrityViolationException dive) {
            addSkillForm.recordError(skillName, dive.getMostSpecificCause().getMessage());
            return null;
        } catch (Exception e) {
            addSkillForm.recordError(skillName, e.getMessage());
            return null;
        }
 
        return "skills/SkillsIndex";
    }
 
    // Necessary cause ValidationTrackers are stored into session and so record
    // errors would not be cleaned automatically
    void cleanupRender() {
        addSkillForm.clearErrors();
    }
 
}

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns:t="http://tapestry.apache.org/schema/tapestry_5_0_0.xsd">
    <head>
        <title>Add a skill</title>
    </head>
    <body>
        <h1>Add a skill</h1>
        <t:form t:id="add_skill_form" accept-charset="iso-8859-1">
            <fieldset>
                <legend>New skill</legend>
                <t:errors />
                <p>
                    <t:label for="skillName">Name</t:label>&nbsp;
                    <t:textfield t:id="skillName" t:value="skill.name" t:validate="required" />
                </p>
                <p>
                    <t:submit t:id="submit" value="Submit" />
                </p>
            </fieldset>
        </t:form>
        <p>
            <t:pagelink page="skills/Index">Cancel</t:pagelink>
        </p>
    </body>
</html>

package net.ilabs.skillbrowser.web.pages.users;
 
import java.util.ArrayList;
import java.util.List;
 
import net.ilabs.skillbrowser.domain.model.Skill;
import net.ilabs.skillbrowser.domain.model.User;
import net.ilabs.skillbrowser.service.SkillManager;
import net.ilabs.skillbrowser.service.UserManager;
 
import org.apache.tapestry5.annotations.Service;
import org.apache.tapestry5.ioc.annotations.Inject;
 
public class UsersSkills {
 
    @Inject
    @Service("userManager")
    private UserManager userManager;
 
    @Inject
    @Service("skillManager")
    private SkillManager skillManager;
 
    @Property
    private User user;
 
    @Property
    private Skill skill;
 
    public List<Skill> getSkills() {
        return skillManager.findAll();
    }
 
    public List<Skill> getUserSkills() {
        return new ArrayList<Skill>(user.getSkills());
    }
 
    public void onActivate(Integer id) {
        user = userManager.findById(id);
    }
 
    public Integer onPassivate() {
        return user.getUserId();
    }
 
    public String onActionFromAddSkill(Integer skillId) {
        user.addSkill(skillManager.findById(skillId));
        userManager.persist(user);
        return null;
    }
 
    public String onActionFromDeleteSkill(Integer skillId) {
        return onActionFromDeleteUserSkill(skillId);
    }
 
    public String onActionFromDeleteUserSkill(Integer skillId) {
        user.removeSkill(skillManager.findById(skillId));
        userManager.persist(user);
        return null;
    }
}

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns:t="http://tapestry.apache.org/schema/tapestry_5_0_0.xsd">
    <head>
        <meta http-equiv="Content-Type" content="text/html;charset=utf-8" />
        <title>Skills for ${user.fullname}</title>
    </head>
    <body>
        <h1>Skills for ${user.fullname}</h1>
 
        <fieldset xmlns="http://www.w3.org/1999/xhtml">
            <t:loop source="skills" value="skill">
                <t:actionlink t:id="addSkill" context="skill.skillId">${skill.name}</t:actionlink>&nbsp;
            </t:loop>
        </fieldset>
 
        <ul xmlns="http://www.w3.org/1999/xhtml">
            <li t:type="loop" t:source="userSkills" t:value="skill">
                ${skill.name}
                - <t:actionlink t:id="deleteUserSkill" context="skill.skillId">Delete</t:actionlink>
            </li>
        </ul>
 
        <p>
            <t:pagelink page="users/Index">Back</t:pagelink>
        </p>
 
    </body>
</html>