userservice.java

SpringSide开源代码

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);
	}
}