spring+hibernate annotation 完整示例，带数据库脚本

package org.springside.examples.extremeweb.service; import java.util.Collection; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import org.springside.examples.extremeweb.entity.User; import org.springside.examples.extremeweb.util.SimpleJdbcSupport; @Service @Transactional public class UserService extends SimpleJdbcSupport { private static String QUERY_ALL_USER = "select name,login_name,password from users"; private static String QUERY_USER = "select name,login_name,password from users where login_name=?"; private static String INSERT_USER = "insert into users (name,login_name,password) values(:name,:loginName,:password)"; private static String DELETE_USER = "delete from users where login_name=?"; private static String DELETE_USER_ROLES = "delete from users_roles where user_id in (select id from users where login_name=?)"; @Transactional(readOnly = true) public Collection<User> getAllUser() { return jdbcTemplate.query(QUERY_ALL_USER, resultBeanMapper(User.class)); } public User getUser(String loginName) { return jdbcTemplate.queryForObject(QUERY_USER, resultBeanMapper(User.class), loginName); } public void createUser(User user) { jdbcTemplate.update(INSERT_USER, paramBeanMapper(user)); } public void deleteUser(String loginName) { jdbcTemplate.update(DELETE_USER_ROLES, loginName); jdbcTemplate.update(DELETE_USER, loginName); } }