userserviceimpl.java

SSH示范

package com.iplan.portal.start.service;

import java.util.List;

import org.hibernate.criterion.DetachedCriteria;
import org.hibernate.criterion.Restrictions;

import com.iplan.portal.framework.base.BaseService;
import com.iplan.portal.start.pojo.Role;
import com.iplan.portal.start.pojo.User;

/**
 * http://www.hao-se.cn
 * 
 * @author ws
 */
public class UserServiceImpl extends BaseService implements IUserService {
	public User getUserById(String id){
		return (User) this.getCommonDAO().get(User.class, id);
	}
	
	public List getUserList(){
		StringBuffer sql = new StringBuffer();
		sql.append("select user.guid as guid,user.userid as userid,user.username as username,user.flg as flg,role.rolename as rolename from USER user ");
		sql.append("INNER JOIN ROLE role ON user.roleid = role.guid ");
		List list = this.getCommonDAO().findBySQL(sql.toString()).getRows();

		return list;
	}
	
	public List getUsedUserList(){
		StringBuffer sql = new StringBuffer();
		sql.append("select user.guid as guid,user.userid as userid,user.username as username,user.flg as flg,role.rolename as rolename from USER user ");
		sql.append("INNER JOIN ROLE role ON user.roleid = role.guid ");
		sql.append("where user.flg='0'");
		List list = this.getCommonDAO().findBySQL(sql.toString()).getRows();

		return list;
	}
	
	public void saveUser(User user) {
		this.getCommonDAO().save(user);
	}

	public void deleteUser(User user) {
		this.getCommonDAO().update(user);
	}

	public void updateUser(User user) {
		this.getCommonDAO().update(user);
	}

	public User getUser(String userId, String password) {
		User user = null;
		DetachedCriteria detachedCriteria = DetachedCriteria
				.forClass(User.class);
		detachedCriteria.add(Restrictions.eq("userId", userId));
		detachedCriteria.add(Restrictions.eq("password", password));

		List list = this.getCommonDAO().findByCriteria(detachedCriteria);

		if (!list.isEmpty()) {
			user = (User) list.get(0);
		}

		return user;
	}

	public Role getRole(String roleId) {
		Role role = null;
		DetachedCriteria detachedCriteria = DetachedCriteria
				.forClass(Role.class);
		detachedCriteria.add(Restrictions.eq("guid", roleId));
		
		List list = this.getCommonDAO().findByCriteria(detachedCriteria);
		if (!list.isEmpty()) {
			role = (Role) list.get(0);
		}	
		
		return role;
	}
	
	public List getRoleList(){
		StringBuffer sql = new StringBuffer();
		sql.append("select * from ROLE");
		List list = this.getCommonDAO().findBySQL(sql.toString()).getRows();

		return list;
	}
}