MyBatis Pagehelper分頁

1. pom引入pagehelper包

<!--Spring Boot版的pagehelper-->
<dependency>
            <groupId>com.github.pagehelper</groupId>
            <artifactId>pagehelper-spring-boot-starter</artifactId>
            <version>1.2.3</version>
        </dependency>

2. 在application.properties配置PageHelper

#MyBatis分頁插件配置
pagehelper.helperDialect=mysql
pagehelper.reasonable=true
pagehelper.supportMethodsArguments=true
pagehelper.params=count=countSql

3. 創(chuàng)建實體類

public class User {

    Integer id;
    String name;
    Integer age;

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public Integer getAge() {
        return age;
    }

    public void setAge(Integer age) {
        this.age = age;
    }
}

4. 創(chuàng)建mapper類userMapper

public interface UserMapper {

    @Select("select * from user")
    List<User> findAll();
}

5.創(chuàng)建service類userService

@Service
public class UserService {

    @Autowired
    UserMapper userMapper;

    public PageInfo findAll(int pageNum, int pageSize) {
        PageHelper.startPage(pageNum, pageSize);
        List<User> userList = userMapper.findAll();
        PageInfo<User> pageInfo = new PageInfo<>(userList);
        return pageInfo;
    }
}

6. 創(chuàng)建 controller 類 UserController

@RestController
public class UserController {

    @Autowired
    UserService userService;

    @GetMapping("findAll")
    public PageInfo getUser(int pageNum, int pageSize) {
        return userService.findAll(pageNum,pageSize);
    }
}

7. 運行程序后，使用Http請求測試

Shiro-Spring-Boot-Web-Starter

1. pom文件導入jar包

  <!--shiro-->
        <dependency>
            <groupId>org.apache.shiro</groupId>
            <artifactId>shiro-spring-boot-web-starter</artifactId>
            <version>1.4.0</version>
        </dependency>
        <!--shiro+thymeleaf   thymeleaf使用shiro標簽的作用的包-->
        <dependency>
            <groupId>com.github.theborakompanioni</groupId>
            <artifactId>thymeleaf-extras-shiro</artifactId>
            <version>2.0.0</version>
        </dependency>

2. 在application.properties配置Shiro

<!--登錄的路徑-->
shiro.loginUrl=/login  
<!--登陸成功后跳轉(zhuǎn)的路徑-->
shiro.successUrl=/home
<!--未授權頁面路徑-->
shiro.unauthorizedUrl=/403

4. 創(chuàng)建編寫shiroConfig配置類

package com.truth.bug.shiro;

import at.pollux.thymeleaf.shiro.dialect.ShiroDialect;
import org.apache.shiro.authz.AuthorizationException;
import org.apache.shiro.cache.CacheManager;
import org.apache.shiro.cache.MemoryConstrainedCacheManager;
import org.apache.shiro.realm.Realm;
import org.apache.shiro.spring.web.config.DefaultShiroFilterChainDefinition;
import org.apache.shiro.spring.web.config.ShiroFilterChainDefinition;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.http.HttpStatus;
import org.springframework.web.bind.annotation.ControllerAdvice;
import org.springframework.web.bind.annotation.ExceptionHandler;
import org.springframework.web.bind.annotation.ResponseStatus;


@Configuration
@ControllerAdvice
public class ShiroConfig {

    private Logger logger = LoggerFactory.getLogger(ShiroConfig.class);

    /**
     * 處理Shiro異常
     */
    @ExceptionHandler(AuthorizationException.class)
    @ResponseStatus(HttpStatus.FORBIDDEN)
    public void authorizationExceptionHandler() {
        logger.error("沒有權限訪問該資源");
    }


    @Bean
    public Realm realm() {
        return new MyShiroRealm();
    }

    @Bean
    public CacheManager cacheManager() {
        return new MemoryConstrainedCacheManager();
    }


    @Bean
    public ShiroFilterChainDefinition shiroFilterChainDefinition() {
        DefaultShiroFilterChainDefinition chainDefinition = new DefaultShiroFilterChainDefinition();
        chainDefinition.addPathDefinition("/favicon.ico", "anon");
        chainDefinition.addPathDefinition("/dist/**", "anon");
        chainDefinition.addPathDefinition("/bootstrap/**", "anon");
        chainDefinition.addPathDefinition("/plugins/**", "anon");
        chainDefinition.addPathDefinition("/css/**", "anon");
        chainDefinition.addPathDefinition("/js/**", "anon");
        chainDefinition.addPathDefinition("/img/**", "anon");
        chainDefinition.addPathDefinition("/", "anon");
        chainDefinition.addPathDefinition("/logout", "logout");
        chainDefinition.addPathDefinition("/**", "authc");
        return chainDefinition;
    }

    @Bean
    public ShiroDialect shiroDialect() {
        return new ShiroDialect();
    }

}

4. 編寫自己Realm類

package com.truth.bug.shiro;

import com.truth.bug.entity.Role;
import com.truth.bug.entity.User;
import com.truth.bug.service.UserService;
import org.apache.shiro.authc.AuthenticationException;
import org.apache.shiro.authc.AuthenticationInfo;
import org.apache.shiro.authc.AuthenticationToken;
import org.apache.shiro.authc.SimpleAuthenticationInfo;
import org.apache.shiro.authz.AuthorizationInfo;
import org.apache.shiro.authz.SimpleAuthorizationInfo;
import org.apache.shiro.realm.AuthorizingRealm;
import org.apache.shiro.subject.PrincipalCollection;
import org.springframework.beans.factory.annotation.Autowired;

import java.util.HashSet;
import java.util.List;
import java.util.Set;

/**
 * Created by Truth on 2018/8/31 0031 14:34
 */

public class MyShiroRealm extends AuthorizingRealm {

    @Autowired
    private UserService userService;

    //用戶認證
    @Override
    protected AuthorizationInfo doGetAuthorizationInfo(PrincipalCollection principalCollection) {
        if (principalCollection == null){
            throw new AuthenticationException("PrincipalCollection方法參數(shù)不能為null");
        }
        User user = (User) getAvailablePrincipal(principalCollection);
        SimpleAuthorizationInfo info = new SimpleAuthorizationInfo();

        <!--這段是因為數(shù)據(jù)庫結構原因加的，info.setRoles只支持String-->
        List<Role> roleList = user.getRoles();
        Set<String> roles = new HashSet<>();
        for (int i = 0;i < roleList.size();i++){
            roles.add(roleList.get(i).getRoleName());
        }

        info.setRoles(roles);
        return null;
    }

    //用戶認證
    @Override
    protected AuthenticationInfo doGetAuthenticationInfo(AuthenticationToken authenticationToken) throws AuthenticationException {
        //加這一步的目的是在Post請求的時候會先進認證铲掐，然后在到請求
        if (authenticationToken.getPrincipal() == null){
            return null;
        }
        //獲取用戶信息
        String phone = authenticationToken.getPrincipal().toString();
        User user = userService.findUser(phone);
        if (user == null){
            //這里返回后會報出對應異常
            return null;
        }
        SimpleAuthenticationInfo authenticationInfo = new SimpleAuthenticationInfo(user,user.getPassword(),getName());
        authenticationInfo.setCredentials(user);
        return authenticationInfo;
    }
}

4. Login控制器示例

  @PostMapping("/login")
    @ResponseBody
    public AjaxResult login(String phone,String password, HttpSession session){

        UsernamePasswordToken token = new UsernamePasswordToken(phone, DigestUtils.md5Hex(password + passwordSalt));
        Subject subject = SecurityUtils.getSubject();

        try {
            subject.login(token);
            session.setAttribute("user",subject.getPrincipal());
            return AjaxResult.success();
        }catch (AuthenticationException ex){
            return  AjaxResult.error("賬號或密碼錯誤");
        }
    }

5.登錄用戶修改個人信息后，不重新登陸進行同步更新

 public AjaxResult updateUser(User user){
            <!--subject獲取當前登錄的對象-->
           User user1 = (User)SecurityUtils.getSubject().getPrincipal();
          <!--數(shù)據(jù)庫修改用戶信息-->
           userService.updateUser(user);
          <!--將修改的信息賦值給登錄對象的User串纺，前端就會跟著更新了-->
           user1.setUserName(user.getUserName());
           return AjaxResult.success();
        }