简单权限系统基于shiro-springmvc-spring-mybatis(学习笔记 1)

最新推荐文章于 2018-08-02 00:02:14 发布

beyond_zl

最新推荐文章于 2018-08-02 00:02:14 发布

阅读量1k

点赞数

本文链接：https://blog.csdn.net/qq_15370821/article/details/52798276

版权

JavaEE 专栏收录该内容

14 篇文章 0 订阅

订阅专栏

一个简单的权限管理系统，实现用户、权限、资源的增删改查，这三者之间相互的授权和取消授权，如：一个用户可以拥有多个权限并且一个权限可以拥有多个资源。

系统基于shiro、springmvc、spring、mybatis，使用mysql数据库。
项目地址：https://git.oschina.net/beyondzl/spring-shiro
（前端视图由于时间原因没有全部完成，后端功能测试可行）

log4j的属性文件：

# Global logging configuration
#\u5F00\u53D1\u73AF\u5883\u65E5\u5FD7\u7EA7\u522B\u8BBE\u7F6EDEBUG,\u751F\u4EA7\u73AF\u5883\u8BBE\u7F6E\u6210INFO\u6216ERROR
log4j.rootLogger=DEBUG, stdout
# MyBatis logging configuration...

# Console output...
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%5p [%t] - %m%n

Dao层：

使用mapper代理开发
SqlMapConfig.xml:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE configuration  
  PUBLIC "-//mybatis.org//DTD Config 3.0//EN"  
  "http://mybatis.org/dtd/mybatis-3-config.dtd"> 

<configuration>
    <settings>
        <setting name="cacheEnabled" value="false"></setting>
        <setting name="lazyLoadingEnabled" value="false"></setting>
        <setting name="aggressiveLazyLoading" value="true"></setting>
        <setting name="logImpl" value="LOG4J"></setting>
    </settings>

    <typeAliases>
        <typeAlias type="com.spring.shiro.main.common.utils.PageInfo" alias="PageInfo"></typeAlias>
        <typeAlias type="com.spring.shiro.main.java.model.User" alias="User"></typeAlias>
        <typeAlias type="com.spring.shiro.main.common.result.UserVo" alias="UserVo"></typeAlias>
        <typeAlias type="com.spring.shiro.main.java.model.Resource" alias="Resourcce"></typeAlias>
        <typeAlias type="com.spring.shiro.main.java.model.Role" alias="Role"></typeAlias>
        <typeAlias type="com.spring.shiro.main.java.model.Organization" alias="Organization"></typeAlias>
        <typeAlias type="com.spring.shiro.main.java.model.SysLog" alias="SysLog"></typeAlias>
    </typeAliases>

    <!-- (与spring整合后可舍弃)<environments default="development">
    使用JDBC事务管理
        <environment id="development">
            <transactionManager type="JDBC"></transactionManager>
            数据库连接池
            <dataSource type="POOLED">
                <property name="driver" value="com.mysql.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql://localhost:3306/spring?characterEncoding=utf-8"/>
                <property name="username" value="root"/>
                <property name="password" value="xz19950122xz"/>
            </dataSource>
        </environment>
    </environments> -->
    <mappers >
    <!-- 加载映射文件 -->
        <mapper resource="mappers/OrganizationMapper.xml"></mapper>
        <mapper resource="mappers/ResourceMapperl.xml"></mapper>
        <mapper resource="mappers/RoleMapper.xml"></mapper>
        <mapper resource="mappers/RoleResourceMapper.xml"></mapper>
        <mapper resource="mappers/SlaveMapper.xml"></mapper>
        <mapper resource="mappers/SysLogMapper.xml"></mapper>
        <mapper resource="mappers/UserMapper.xml"></mapper>
        <mapper resource="mappers/UserRoleMapper.xml"></mapper>
    </mappers>
</configuration>

mapper.xml中命名空间对应相应mapper接口路径

主键返回语句：

<insert id="insert">
        <selectKey keyProperty="id" order="AFTER" resultType="long">
            SELECT LAST_INSERT_ID();
        </selectKey>
        insert into user_role(user_id, role_id)
        values(#{userId},#{roleId})
    </insert>

还可以使用<set>、<if>标签 ：

<update id="updateByPrimaryKeySelective">
        update user_role 
        <set>
            <if test="userId != null">
                user_id = #{userId}
            </if>
            <if test="roleId != null">
                role_id = #{roleId}
            </if>
        </set>
        where id = #{id}
    </update>

**<sql>标签的使用：**

<sql id="Base">
        id, name, url, description, icon, pid, seq, status, resourcetype, createdate
    </sql>

    <select id="findResourceById">
        select
        <include refid="Base"></include>
        from resource where id= #{id};
    </select>

Dao层测试类：

public class UserRoleMapperTest {
    private UserRoleMapper mapper;
    @Before
    public void setUp() throws Exception {
        String resource = "SqlMapConfig.xml";
        InputStream config = Resources.getResourceAsStream(resource);
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(config);
        SqlSession sqlSession = sqlSessionFactory.openSession();
        mapper = sqlSession.getMapper(UserRoleMapper.class);
    }

    @Test
    public void testInsert() {

        UserRole userRole = new UserRole();
        userRole.setRoleId((long) 3);
        userRole.setUserId((long) 2);
        int i = mapper.insert(userRole);
    }

spring整合mybatis:

spring-mybatis.xml:

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xmlns:context="http://www.springframework.org/schema/context"
    xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
        http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.1.xsd">
    <!-- 加载资源文件 -->
    <context:property-placeholder location="classpath:db.properties"/>

    <!-- 数据库连接池  使用c3p0 -->
    <bean id="DataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
        <property name="driverClass" value="${jdbc.driver}"></property>
        <property name="jdbcUrl" value="${jdbc.url}"></property>
        <property name="user" value="${jdbc.username}"></property>
        <property name="password" value="${jdbc.password}"></property>
    </bean>

    <!-- SqlSessionFactory -->
    <bean id="SqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <!-- 加载mybatis配置 -->
        <property name="mapperLocations" value="classpath*:config/mappers/*.xml"></property> 
        <property name="configLocation" value="classpath:/SqlMapConfig.xml"></property>
        <property name="dataSource" ref="DataSource"></property>
    </bean>

    <!-- <bean id="userRoleMapper" class="org.mybatis.spring.mapper.MapperFactoryBean">
        <property name="mapperInterface" value="com.spring.shiro.main.java.mapper.UserRoleMapper"></property>
        <property name="sqlSessionFactory" ref="SqlSessionFactory"></property>
    </bean> -->


    <!-- mapper代理批量配置 -->
    <bean id="mapperScanConfigurer" class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="basePackage" value="com.spring.shiro.main.java.mapper"></property>
    </bean>
</beans>

测试时一直报错找不到mapper接口中方法在mapper.xml中对应的id,
后将下面配置改动了一下，测试通过——

<bean id="SqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <!-- 加载mybatis配置 -->
        <property name="mapperLocations" value="classpath*:config/mappers/*.xml"></property> 
        <property name="configLocation" value="classpath:/SqlMapConfig.xml"></property>
        <property name="dataSource" ref="DataSource"></property>
    </bean>

将classpath*:/mappers/*.xml改成了classpath*:config/mappers/*.xml

Service层：

applicationContext.xml:

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xmlns:p="http://www.springframework.org/schema/p"
    xmlns:context="http://www.springframework.org/schema/context"
    xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.1.xsd
        http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.1.xsd">

    <context:component-scan base-package="com.spring.shiro.main.java.service。impl,com.spring.shiro.main.java.mapper"></context:component-scan>

    <import resource="spring/spring-mybatis.xml"></import>
</beans>

使用注解开发，service实现类：
（调用mapperBean,组合使用mapper操作数据库的方法实现业务逻辑处理）

@Service
public class UserServiceImpl implements UserService {
    public static Logger LOGGER = LoggerFactory.getLogger(UserServiceImpl.class);
    private ApplicationContext apl = new ClassPathXmlApplicationContext("applicationContext.xml");


    //@Autowired
    private UserMapper userMapper = (UserMapper) apl.getBean("userMapper");
    @Resource
    private UserRoleMapper userRoleMapper;

    @Override
    public User findUserByLoginName(String username) {

        return userMapper.findUserByLoginName(username);
    }

    @Override
    public User findUserById(Long id) {

        return userMapper.findUserById(id);
    }

    @Override
    public void findUserGrid(PageInfo pageInfo) {
        pageInfo.setRows(userMapper.findUserPageCondition(pageInfo));
        pageInfo.setTotal(userMapper.findUserPageCount());

    }

    @Override
    public void addUser(UserVo userVo) {
        User user = new User();
        try{
            PropertyUtils.copyProperties(user, userVo);
        }catch(Exception e) {
            LOGGER.error("类转换异常：{}", e);
            throw new RuntimeException("类转换异常：{}",e);
        }
        System.out.println(user);
        userMapper.insert(user);
        Long id = user.getId();
        String[]  roles = userVo.getRoleIds().split(",");
        UserRole userRole = new UserRole();
        for(String roleId : roles) {
            userRole.setUserId(id);
            userRole.setRoleId(Long.valueOf(roleId));
            userRoleMapper.insert(userRole);
        }
    }

    @Override
    public void updateUserPwdById(Long userId, String pwd) {
        userMapper.updateUserPasswordById(userId, pwd);

    }

    @Override
    public UserVo findUserVoById(Long id) {
        return userMapper.findUserVoById(id);

    }

    @Override
    public void updateUser(UserVo userVo) {
        User user = new User();
        try{
            PropertyUtils.copyProperties(user, userVo);

        }catch(Exception e) {
            LOGGER.error("类转换异常：{}", e);
            throw new RuntimeException("类转换异常：{}",e);
        }

        userMapper.updateUser(user);
        Long id = userVo.getId();
        List<UserRole> userRoles = userRoleMapper.findUserRoleByUserId(id);
        if(userRoles != null && (!userRoles.isEmpty())) {
            for(UserRole userRole : userRoles) {
                userRoleMapper.deleteById(userRole.getId());
            }
        }

        String[] roleIds = userVo.getRoleIds().split(",");
        UserRole userRole = new UserRole();
        for(String roleId : roleIds) {
            userRole.setId(id);
            userRole.setRoleId(Long.parseLong(roleId));
            userRoleMapper.insert(userRole);
        }
    }

    @Override
    public void deleteUserById(Long id) {
        int delete = userMapper.deleteById(id);
        if(delete != 1) {
            throw new RuntimeException("删除用户失败！");
        }

    }

测试时，@Autowired注解不能自动装载mapperBean,mapperBean中始终为空值。最终改成了从容器中获取mapperBean。

@Autowired
private UserMapper userMapper;

改成了如上

private ApplicationContext apl = new ClassPathXmlApplicationContext("applicationContext.xml");


    //@Autowired
    private UserMapper userMapper = (UserMapper) apl.getBean("userMapper");

service测试类(导入了spring的Junit测试环境)：

@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration(locations={"classpath:applicationContext.xml"})
public class UserServiceImplTest extends AbstractJUnit4SpringContextTests{

    @Before
    public void setUp() throws Exception {
    }

    @Test
    public void test() {
        UserVo userVo = new UserVo();
        userVo.setAge(3);
        userVo.setCreatedate(new Date());
        userVo.setId((long) 3);
        userVo.setLoginName("abcss");
        userVo.setName("aaa");
        userVo.setPassword("123");
        userVo.setPhone("123466");
        userVo.setRoleIds("4,6,7");
        userVo.setSex(1);
        userVo.setStatus(3);
        userVo.setUserType(3);
        userVo.setOrganizationId(2);

        UserServiceImpl userServiceImpl = new UserServiceImpl();
        userServiceImpl.addUser(userVo);
    }
    @Test
    public void testMapper() {
        ApplicationContext apl = new ClassPathXmlApplicationContext("applicationContext.xml");
        UserMapper userMapper = (UserMapper) apl.getBean("userMapper");
        User user = new User();
        user.setAge(12);
        user.setCreatedate(new Date());
        user.setLoginName("abcd");
        user.setName("name");
        user.setOrganizationId(2);
        user.setPassword("123456");
        user.setPhone("136");
        user.setSex(1);
        user.setStatus(3);
        user.setUserType(2);
        int i = userMapper.insert(user);

    }

}