com.itliupengcheng.atcrowdfunding.controller
com..itliupengcheng.atcrowdfunding.dao
package com.atguigu.atcrowdfunding.dao; import java.util.List; import org.apache.ibatis.annotations.Select; import com.atguigu.atcrowdfunding.bean.Permission; import com.atguigu.atcrowdfunding.bean.User; public interface PermissionDao { @Select("select * from t_permission where pid is null") Permission queryRootPermission(); @Select("select * from t_permission where pid = #{pid}") List<Permission> queryChildPermissions(Integer pid); @Select("select * from t_permission") List<Permission> queryAll(); void insertPermission(Permission permission); @Select("select * from t_permission where id = #{id}") Permission queryById(Integer id); void updatePermission(Permission permission); void deletePermission(Permission permission); @Select("select permissionid from t_role_permission where roleid = #{roleid}") List<Integer> queryPermissionidsByRoleid(Integer roleid); List<Permission> queryPermissionsByUser(User dbUser); }
package com.atguigu.atcrowdfunding.dao; import java.util.List; import java.util.Map; import org.apache.ibatis.annotations.Select; import com.atguigu.atcrowdfunding.bean.Role; public interface RoleDao { List<Role> pageQueryData(Map<String, Object> map); int pageQueryCount(Map<String, Object> map); @Select("select * from t_role") List<Role> queryAll(); void insertRolePermission(Map<String, Object> paramMap); void deleteRolePermissions(Map<String, Object> paramMap); }
package com.atguigu.atcrowdfunding.dao; import java.util.List; import java.util.Map; import org.apache.ibatis.annotations.Select; import com.atguigu.atcrowdfunding.bean.User; public interface UserDao { @Select("select * from t_user") List<User> queryAll(); @Select("select * from t_user where loginacct = #{loginacct} and userpswd = #{userpswd}") User query4Login(User user); List<User> pageQueryData(Map<String, Object> map); int pageQueryCount(Map<String, Object> map); void insertUser(User user); @Select("select * from t_user where id = #{id}") User queryById(Integer id); void updateUser(User user); void deleteUserById(Integer id); void deleteUsers(Map<String, Object> map); void insertUserRoles(Map<String, Object> map); void deleteUserRoles(Map<String, Object> map); @Select("select roleid from t_user_role where userid = #{userid}") List<Integer> queryRoleidsByUserid(Integer id); }
com.itliupengcheng.atcrowdfunding.servise
package com.atguigu.atcrowdfunding.service; import java.util.List; import com.atguigu.atcrowdfunding.bean.Permission; import com.atguigu.atcrowdfunding.bean.User; public interface PermissionService { Permission queryRootPermission(); List<Permission> queryChildPermissions(Integer pid); List<Permission> queryAll(); void insertPermission(Permission permission); Permission queryById(Integer id); void updatePermission(Permission permission); void deletePermission(Permission permission); List<Integer> queryPermissionidsByRoleid(Integer roleid); List<Permission> queryPermissionsByUser(User dbUser); }
package com.atguigu.atcrowdfunding.service; import java.util.List; import java.util.Map; import com.atguigu.atcrowdfunding.bean.Role; public interface RoleService { List<Role> pageQueryData(Map<String, Object> map); int pageQueryCount(Map<String, Object> map); List<Role> queryAll(); void insertRolePermission(Map<String, Object> paramMap); }
package com.atguigu.atcrowdfunding.service; import java.util.List; import java.util.Map; import com.atguigu.atcrowdfunding.bean.User; public interface UserService { List<User> queryAll(); User query4Login(User user); List<User> pageQueryData(Map<String, Object> map); int pageQueryCount(Map<String, Object> map); void insertUser(User user); User queryById(Integer id); void updateUser(User user); void deleteUserById(Integer id); void deleteUsers(Map<String, Object> map); void deleteUserRoles(Map<String, Object> map); void insertUserRoles(Map<String, Object> map); List<Integer> queryRoleidsByUserid(Integer id); }
com.itliupengcheng.atcrowdfunding.servise.impl
package com.atguigu.atcrowdfunding.service.impl; import java.util.List; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import com.atguigu.atcrowdfunding.bean.Permission; import com.atguigu.atcrowdfunding.bean.User; import com.atguigu.atcrowdfunding.dao.PermissionDao; import com.atguigu.atcrowdfunding.service.PermissionService; @Service public class PermissionServiceImpl implements PermissionService { @Autowired private PermissionDao permissionDao; public Permission queryRootPermission() { return permissionDao.queryRootPermission(); } public List<Permission> queryChildPermissions(Integer pid) { return permissionDao.queryChildPermissions(pid); } public List<Permission> queryAll() { return permissionDao.queryAll(); } public void insertPermission(Permission permission) { permissionDao.insertPermission(permission); } public Permission queryById(Integer id) { return permissionDao.queryById(id); } public void updatePermission(Permission permission) { permissionDao.updatePermission(permission); } public void deletePermission(Permission permission) { permissionDao.deletePermission(permission); } public List<Integer> queryPermissionidsByRoleid(Integer roleid) { return permissionDao.queryPermissionidsByRoleid(roleid); } public List<Permission> queryPermissionsByUser(User dbUser) { return permissionDao.queryPermissionsByUser(dbUser); } }
package com.atguigu.atcrowdfunding.service.impl; import java.util.List; import java.util.Map; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import com.atguigu.atcrowdfunding.bean.Role; import com.atguigu.atcrowdfunding.dao.RoleDao; import com.atguigu.atcrowdfunding.service.RoleService; @Service public class RoleServiceImpl implements RoleService { @Autowired private RoleDao roleDao; public List<Role> pageQueryData(Map<String, Object> map) { return roleDao.pageQueryData(map); } public int pageQueryCount(Map<String, Object> map) { return roleDao.pageQueryCount(map); } public List<Role> queryAll() { return roleDao.queryAll(); } public void insertRolePermission(Map<String, Object> paramMap) { roleDao.deleteRolePermissions(paramMap); roleDao.insertRolePermission(paramMap); } }
package com.atguigu.atcrowdfunding.service.impl; import java.util.List; import java.util.Map; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import com.atguigu.atcrowdfunding.bean.User; import com.atguigu.atcrowdfunding.dao.UserDao; import com.atguigu.atcrowdfunding.service.UserService; @Service public class UserServiceImpl implements UserService { @Autowired private UserDao userDao; public List<User> queryAll() { return userDao.queryAll(); } public User query4Login(User user) { return userDao.query4Login(user); } public List<User> pageQueryData(Map<String, Object> map) { return userDao.pageQueryData(map); } public int pageQueryCount(Map<String, Object> map) { return userDao.pageQueryCount(map); } public void insertUser(User user) { userDao.insertUser(user); } public User queryById(Integer id) { return userDao.queryById(id); } public void updateUser(User user) { userDao.updateUser(user); } public void deleteUserById(Integer id) { userDao.deleteUserById(id); } public void deleteUsers(Map<String, Object> map) { userDao.deleteUsers(map); } public void deleteUserRoles(Map<String, Object> map) { userDao.deleteUserRoles(map); } public void insertUserRoles(Map<String, Object> map) { userDao.insertUserRoles(map); } public List<Integer> queryRoleidsByUserid(Integer id) { return userDao.queryRoleidsByUserid(id); } }