【郑州校区】传智健康项目讲义第九章二 - 黑马程序员技术交流社区

[AppleScript] 纯文本查看 复制代码

package com.itheima.service;

import com.itheima.pojo.User;

/**

* 用户服务接口

*/

public interface UserService {

public User findByUsername(String username);

}

[AppleScript] 纯文本查看 复制代码

package com.itheima.service;

import com.alibaba.dubbo.config.annotation.Service;

import com.itheima.dao.PermissionDao;

import com.itheima.dao.RoleDao;

import com.itheima.dao.UserDao;

import com.itheima.pojo.Permission;

import com.itheima.pojo.Role;

import com.itheima.pojo.User;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.transaction.annotation.Transactional;

import java.util.Set;

@Service(interfaceClass = UserService.class)

@Transactional

public class UserServiceImpl implements UserService {

@Autowired

private UserDao userDao;

@Autowired

private RoleDao roleDao;

@Autowired

private PermissionDao permissionDao;

public User findByUsername(String username) {

User user = userDao.findByUsername(username);

if(user == null){

return null;

}

Integer userId = user.getId();

Set<Role> roles = roleDao.findByUserId(userId);

if(roles != null && roles.size() > 0){

for(Role role : roles){

Integer roleId = role.getId();

Set<Permission> permissions =

permissionDao.findByRoleId(roleId);

if(permissions != null && permissions.size() > 0){

role.setPermissions(permissions);

}

}

user.setRoles(roles);}

return user;

}

}

[AppleScript] 纯文本查看 复制代码

package com.itheima.dao;

import com.itheima.pojo.User;

public interface UserDao {

public User findByUsername(String username);

}

[AppleScript] 纯文本查看 复制代码

package com.itheima.dao;

import com.itheima.pojo.Role;

import java.util.Set;

public interface RoleDao {

public Set<Role> findByUserId(int id);

}

[AppleScript] 纯文本查看 复制代码

package com.itheima.dao;

import com.itheima.pojo.Permission;

import java.util.Set;

public interface PermissionDao {

public Set<Permission> findByRoleId(int roleId);

}

[AppleScript] 纯文本查看 复制代码

<?xml version="1.0" encoding="UTF‐8" ?>

<!DOCTYPE mapper PUBLIC "‐//mybatis.org//DTD Mapper 3.0//EN"

"http://mybatis.org/dtd/mybatis‐3‐mapper.dtd" >

<mapper namespace="com.itheima.dao.UserDao" >

<select id="findByUsername"

parameterType="string"

resultType="com.itheima.pojo.User">

select * from t_user where username = #{username}

</select>

</mapper>

[AppleScript] 纯文本查看 复制代码

<?xml version="1.0" encoding="UTF‐8" ?>

<!DOCTYPE mapper PUBLIC "‐//mybatis.org//DTD Mapper 3.0//EN"

"http://mybatis.org/dtd/mybatis‐3‐mapper.dtd" >

<mapper namespace="com.itheima.dao.RoleDao" >

<select id="findByUserId"

parameterType="int"

resultType="com.itheima.pojo.Role">

select r.*

from t_role r ,t_user_role ur

where r.id = ur.role_id and ur.user_id = #{userId}

</select>

</mapper>

[AppleScript] 纯文本查看 复制代码

<?xml version="1.0" encoding="UTF‐8" ?>

<!DOCTYPE mapper PUBLIC "‐//mybatis.org//DTD Mapper 3.0//EN"

"http://mybatis.org/dtd/mybatis‐3‐mapper.dtd" >

<mapper namespace="com.itheima.dao.PermissionDao" >

<select id="findByRoleId"

parameterType="int"

resultType="com.itheima.pojo.Permission">

select p.*

from t_permission p ,t_role_permission rp

where p.id = rp.permission_id and rp.role_id = #{roleId}

</select>

</mapper>