SpringBoot（二）（Web开发，页面国际化，拦截器，整合数据库）

最新推荐文章于 2024-08-07 07:30:00 发布

锦鱼不忘旧时晨

最新推荐文章于 2024-08-07 07:30:00 发布

阅读量268

点赞数

分类专栏：框架文章标签： spring boot

本文链接：https://blog.csdn.net/weixin_44324174/article/details/107474550

版权

框架专栏收录该内容

8 篇文章 0 订阅

订阅专栏

1、Web开发

（1）静态资源导入

webjars:以maven的方式引入静态资源，访问路径http://localhost:8080/webjars/
static、public、resources，优先级关系：resources>static(默认)>public，访问路径http://localhost:8080/

（2）模板引擎Thymeleof

Thymeleaf是一个适用于Web和独立环境的现代服务器端Java模板引擎，能够处理HTML，XML，JavaScript，CSS甚至纯文本。
Thymeleaf的主要目标是提供一种优雅且高度可维护的模板创建方式。为实现这一目标，它以自然模板的概念为基础，将其逻辑注入模板文件，其方式不会影响模板被用作设计原型。这改善了设计沟通，缩小了设计和开发团队之间的差距。

导入thymeleof的启动器

<dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-thymeleaf</artifactId>
</dependency>

index.html

<!DOCTYPE html>
<html lang="en" xmlns:th="http://www.thymeleaf.org">  <!--引入thymeleaf命名空间-->
<head>
    <meta charset="UTF-8">
    <title>Title</title>
</head>
<body>
<!--获取变量值-->
<div th:text="${msg}"></div> <!--不会解析html标签-->
<div th:utext="${msg}"></div><!--会解析html标签-->
<!--解析列表数据-->
<tr th:each="name:${msg1}">
    <td th:text="${name}"></td><hr>
    <!--<td>[[${name}]]</td><hr>-->  <!--行内写法-->
</tr>
</body>
</html>

HelloController

package com.example.demo.Controller;

import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import java.util.Arrays;
@Controller
public class HelloController {
    @RequestMapping("/hello")
    public String hello(Model model){
        model.addAttribute("msg","<h1>呼呼呼呼呼呼</h1>");
        model.addAttribute("msg1", Arrays.asList("123","345","567"));
        return "index";
    }
}

2、页面国际化

国际化配置及解析
在这里插入图片描述
application.yml

spring:
  messages:
    basename: i18n.login

index.html

<form class="form-signin" action="dashboard.html">
    <img class="mb-4" src="/img/bootstrap-solid.svg" alt="" width="72" height="72">
    <h1 class="h3 mb-3 font-weight-normal" th:text="#{login.tip}">Please sign in</h1>
    <label class="sr-only" th:text="#{login.username}">Username</label>
    <input type="text" class="form-control" th:placeholder="#{login.username}" required="" autofocus="">
    <label class="sr-only" th:text="#{login.password}">Password</label>
    <input type="password" class="form-control" th:placeholder="#{login.password}" required="">
    <div class="checkbox mb-3">
        <label>
            <input type="checkbox" value="remember-me" th:text="#{login.remember}"> Remember me
        </label>
    </div>
    <button class="btn btn-lg btn-primary btn-block" type="submit" th:text="#{login.btn}">Sign in</button>
    <p class="mt-5 mb-3 text-muted">© 2017-2018</p>
    <a class="btn btn-sm">中文</a>
    <a class="btn btn-sm">English</a>
</form>

如果要在项目中进行按钮自动切换，需要定义一个组件LocalResolver，然后将自己写的组件配置到spring容器@Bean

配置请求路径

<button class="btn btn-lg btn-primary btn-block" type="submit" th:text="#{login.btn}">Sign in</button>
    <p class="mt-5 mb-3 text-muted">© 2017-2018</p>
    <a class="btn btn-sm" th:href="@{/index.html(l='zh_CN')}">中文</a>
    <a class="btn btn-sm" th:href="@{/index.html(l='en_US')}">English</a>

MyLocalResolver

package com.example.demo.Config;

import org.springframework.web.servlet.LocaleResolver;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.util.Locale;

public class MyLocaleResolver  implements LocaleResolver {
    //解析请求
    @Override
    public Locale resolveLocale(HttpServletRequest request) {
        String language = request.getParameter("l");
        Locale locale = Locale.getDefault();
        if(language!=null){
            String[] split = language.split("_");
            locale=new Locale(split[0],split[1]);
        }
        return locale;
    }
    @Override
    public void setLocale(HttpServletRequest httpServletRequest, HttpServletResponse httpServletResponse, Locale locale) {

    }
}

自定义组件生效

package com.example.demo.Config;

import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.web.servlet.LocaleResolver;
import org.springframework.web.servlet.config.annotation.ViewControllerRegistry;
import org.springframework.web.servlet.config.annotation.WebMvcConfigurer;

@Configuration
public class MyMvcConfig implements WebMvcConfigurer {
    @Override
    public void addViewControllers(ViewControllerRegistry registry) {
        registry.addViewController("/").setViewName("index");
        registry.addViewController("/index.html").setViewName("index");
    }
    //自定义组件生效
    @Bean
    public LocaleResolver localeResolver(){
        return new MyLocaleResolver();
    }
}

3、拦截器实现

自定义拦截器类

package com.example.demo.Config;
import org.springframework.web.servlet.HandlerInterceptor;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

/*登录拦截器*/
public class LoginHandlerInterceptor implements HandlerInterceptor {
    @Override
    public boolean preHandle(HttpServletRequest request, HttpServletResponse response, Object handler) throws Exception {
        Object loginUser = request.getSession().getAttribute("loginUser");
        if(loginUser==null){
            request.setAttribute("msg","没有权限，请先登录");
            request.getRequestDispatcher("/index.html").forward(request,response);
            return false;
        }else{
            return true;
        }
    }
}

注册到springboot中

package com.example.demo.Config;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.web.servlet.LocaleResolver;
import org.springframework.web.servlet.config.annotation.InterceptorRegistry;
import org.springframework.web.servlet.config.annotation.ViewControllerRegistry;
import org.springframework.web.servlet.config.annotation.WebMvcConfigurer;

@Configuration
public class MyMvcConfig implements WebMvcConfigurer {
    @Override
    public void addViewControllers(ViewControllerRegistry registry) {
        registry.addViewController("/").setViewName("index");
        registry.addViewController("/index.html").setViewName("index");
        registry.addViewController("/main.html").setViewName("dashboard");

    }
    //自定义组件生效
    @Bean
    public LocaleResolver localeResolver(){
        return new MyLocaleResolver();
    }
    //注册拦截器
    @Override
    public void addInterceptors(InterceptorRegistry registry) {
        /*addPathPatterns拦截那些请求
        * excludePathPatterns 那些请求放行*/
        registry.addInterceptor(new LoginHandlerInterceptor()).addPathPatterns("/**").excludePathPatterns("/index.html","/","/user/login","/css/**","/js/**","/img/**");
    }
}

4、整合数据库

对于数据访问层，无论是SQL（关系型数据库）还是NOSQL（非关系型数据库），SpringBoot底层都是采用SpringDate的方式进行统一处理，SpringData也是Spring中与SpringBoot、SpringCloud等齐名的知名项目。

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-jdbc</artifactId>
        </dependency>

        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>

（1）整合JDBC

配置数据源

spring:
  datasource:
    username: root
    password: 123456
    url: jdbc:mysql://localhost:3306/music?useUnicode=true&characterEncoding=utf-8&useSSL=true&serverTimezone=UTC
    driver-class-name: com.mysql.jdbc.Driver

（2）Druid

引入依赖

       <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>1.1.22</version>
        </dependency>

spring:
  datasource:
    username: root
    password: 123456
    url: jdbc:mysql://localhost:3306/mydeno?useUnicode=true&characterEncoding=utf-8&useSSL=true&serverTimezone=UTC
    driver-class-name: com.mysql.jdbc.Driver
    type: com.alibaba.druid.pool.DruidDataSource
      #Spring Boot 默认是不注入这些属性值的，需要自己绑定
      #druid 数据源专有配置
    initialSize: 5
    minIdle: 5
    maxActive: 20
    maxWait: 60000
    timeBetweenEvictionRunsMillis: 60000
    minEvictableIdleTimeMillis: 300000
    validationQuery: SELECT 1 FROM DUAL
    testWhileIdle: true
    testOnBorrow: false
    testOnReturn: false
    poolPreparedStatements: true
    #配置监控统计拦截的filters，stat:监控统计、log4j：日志记录、wall：防御sql注入
    #如果允许时报错  java.lang.ClassNotFoundException: org.apache.log4j.Priority
    #则导入 log4j 依赖即可，Maven 地址：https://mvnrepository.com/artifact/log4j/log4j
    filters: stat,wall,log4j
    maxPoolPreparedStatementPerConnectionSize: 20
    useGlobalDataSourceStat: true
    connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=500

配置Druid数据源监控

@Configuration
public class DruidConfig {

    @ConfigurationProperties(prefix = "spring.datasource")
    @Bean
    public DataSource druidDataSource(){
        return new DruidDataSource();
    }
    //后台监控 web.xml
    @Bean
    public ServletRegistrationBean statViewServlet(){
        ServletRegistrationBean<StatViewServlet> registrationBean = new ServletRegistrationBean<>(new StatViewServlet(), "/druid/*");
        //后台需要有人登陆，账号密码配置
        HashMap<String, String> hashMap = new HashMap<>();
        hashMap.put("loginUsername","admin");//登陆的key是固定的
        hashMap.put("loginPassword","123456");
        //允许谁可以访问
        hashMap.put("allow","");
        //进制谁访问
        hashMap.put("ttt","192.168.11.123");
        registrationBean.setInitParameters(hashMap);
        return registrationBean;
    }

配置filter 过滤器

@Bean
    public FilterRegistrationBean webRigsterFilter(){
        FilterRegistrationBean<Filter> bean = new FilterRegistrationBean<>();
        HashMap<String, String> hashMap = new HashMap<>();
        //排除在外
        hashMap.put("exclusions","*.js,*.css,/druid/*");

        bean.setInitParameters(hashMap);
        return bean;
    }

（3）Mybatis

依赖

<!-- https://mvnrepository.com/artifact/org.mybatis.spring.boot/mybatis-spring-boot-starter -->
<dependency>
    <groupId>org.mybatis.spring.boot</groupId>
    <artifactId>mybatis-spring-boot-starter</artifactId>
    <version>2.1.3</version>
</dependency>

yml配置

spring:
  datasource:
    username: root
    password: 123456
    url: jdbc:mysql://localhost:3306/mydeno?useUnicode=true&characterEncoding=utf-8&useSSL=true&serverTimezone=UTC
    driver-class-name: com.mysql.jdbc.Driver
# 整合mybatis
mybatis:
  type-aliases-package: com.example.demo.PoJo
  mapper-locations: classpath:mybatis/mapper/*.xml

UserMapper

package com.example.demo.Mapper;

import com.example.demo.PoJo.User;
import org.apache.ibatis.annotations.Mapper;
import org.springframework.stereotype.Repository;

import java.util.List;

@Mapper
@Repository
public interface UserMapper {
    List<User> QueryAll();
    User QueryById(int id);
    int AddUser(User user);
    int DeleteUser(int id);
}

UserMapper.xml

<?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.example.demo.Mapper.UserMapper">
    <select id="QueryAll" resultType="User">
        select *from user1
    </select>
    <select id="QueryById" resultType="User">
        select *from user1 where id = #{id}
    </select>
    <insert id="AddUser" parameterType="User">
        insert into user1(id,username,password,money) values(#{id},#{username},#{password},#{money})
    </insert>
    <delete id="DeleteUser" parameterType="int">
        delete from user1 where id=#{id}
    </delete>
</mapper>

锦鱼不忘旧时晨

关注

0
点赞
踩
2

收藏

觉得还不错? 一键收藏
0
评论
SpringBoot（二）（Web开发，页面国际化，拦截器，整合数据库）

1、Web开发（1）静态资源导入webjars:以maven的方式引入静态资源，访问路径http://localhost:8080/webjars/static、public、resources，优先级关系：resources>static(默认)>public，访问路径http://localhost:8080/（2）模板引擎ThymeleofThymeleaf是一个适用于Web和独立环境的现代服务器端Java模板引擎，能够处理HTML，XML，JavaScript，CSS甚至纯
复制链接

扫一扫

专栏目录