spring.datasource.username=root
spring.datasource.password=123
spring.datasource.url=jdbc:mysql:///test05?serverTimezone=Asia/Shanghai

public class User {
? ? private Integer id;
? ? private String username;
? ? private String address;
? ? private String password;
? ? private String email;
? ? //省略 getter/setter
}
@Mapper
public interface UserMapper {
? ? List<User> getUserByUsername(String username);
}
@Service
public class UserService {
? ? @Autowired
? ? UserMapper userMapper;
? ? public List<User> getUserByUsername(String username){
? ? ? ? return userMapper.getUserByUsername(username);
? ? }
}
@RestController
public class UserController {
? ? @Autowired
? ? UserService userService;

? ? @GetMapping("/user")
? ? public List<User> getUser(String username) {
? ? ? ? return userService.getUserByUsername(username);
? ? }
}

<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="org.javaboy.druid_monitor.mapper.UserMapper">
    <select id="getUserByUsername" resultType="org.javaboy.druid_monitor.model.User">
        select * from user where username=#{username}
    </select>
</mapper>

<dependency>
    <groupId>com.alibaba</groupId>
    <artifactId>druid-spring-boot-starter</artifactId>
    <version>1.2.8</version>
</dependency>

# 啟用 WebStatFilter
spring.datasource.druid.web-stat-filter.enabled=true
# 配置攔截規(guī)則
spring.datasource.druid.web-stat-filter.url-pattern=/*
# 排除一些不必要的 url，這些 URL 不會(huì)涉及到 SQL 查詢
spring.datasource.druid.web-stat-filter.exclusions=*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*
# 開啟 session 統(tǒng)計(jì)功能
spring.datasource.druid.web-stat-filter.session-stat-enable=true
# 缺省 sessionStatMaxCount 是 1000 個(gè)，我們可以按需要進(jìn)行配置
spring.datasource.druid.web-stat-filter.session-stat-max-count=1000
# 配置 principalSessionName，使得 druid 能夠知道當(dāng)前的 session 的用戶是誰(shuí)
# 根據(jù)需要，這個(gè)參數(shù)的值是 user 信息保存在 session 中的 sessionName
#spring.datasource.druid.web-stat-filter.principal-session-name=
# 下面這個(gè)配置的作用和上面配置的作用類似，這個(gè)是通過 Cookie 來(lái)識(shí)別用戶
#spring.datasource.druid.web-stat-filter.principal-cookie-name=
# 開啟 profile 后就能夠監(jiān)控單個(gè) URL 地址調(diào)用列表
#spring.datasource.druid.web-stat-filter.profile-enable=

# 啟用內(nèi)置的監(jiān)控頁(yè)面
spring.datasource.druid.stat-view-servlet.enabled=true
# 內(nèi)置監(jiān)控頁(yè)面的地址
spring.datasource.druid.stat-view-servlet.url-pattern=/druid/*
# 開啟 Reset All 功能
spring.datasource.druid.stat-view-servlet.reset-enable=true
# 設(shè)置登錄用戶名
spring.datasource.druid.stat-view-servlet.login-username=javaboy
# 設(shè)置登錄密碼
spring.datasource.druid.stat-view-servlet.login-password=123
# 白名單（如果allow沒有配置或者為空，則允許所有訪問）
spring.datasource.druid.stat-view-servlet.allow=127.0.0.1
# 黑名單（deny 優(yōu)先于 allow，如果在 deny 列表中，就算在 allow 列表中，也會(huì)被拒絕）
spring.datasource.druid.stat-view-servlet.deny=

init : function() {
 this.buildFooter();
 druid.lang.init();
},
buildFooter : function() {
 var html ='';
 $(document.body).append(html);
},

@WebFilter(urlPatterns = "/druid/js/common.js")
public class RemoveAdFilter implements Filter {
    @Override
    public void doFilter(ServletRequest servletRequest, ServletResponse servletResponse, FilterChain filterChain) throws IOException, ServletException {
        String text = Utils.readFromResource("support/http/resources/js/common.js");
        text = text.replace("this.buildFooter();", "");
        servletResponse.getWriter().write(text);
    }
}

@SpringBootApplication
@ServletComponentScan("org.javaboy.druid_monitor.filter")
public class DruidMonitorApplication {

? ? public static void main(String[] args) {
? ? ? ? SpringApplication.run(DruidMonitorApplication.class, args);
? ? }

}