Spring + SpringMVC + MyBatis 实现数据库数据渲染到前端页面

前言

Spring + SpringMVC + MyBatis 实现数据库数据渲染到前端页面

tomcat 9.0.62

学习地址

青空の霞光 超级强！！！

lbwnb!!!

以下内容用作模板

---

内容

添加依赖

 <!--  Spring框架依赖  -->
        <dependency>
            <groupId>org.springframework.security</groupId>
            <artifactId>spring-security-web</artifactId>
            <version>5.5.3</version>
        </dependency>
        <dependency>
            <groupId>org.springframework.security</groupId>
            <artifactId>spring-security-config</artifactId>
            <version>5.5.3</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-webmvc</artifactId>
            <version>5.3.14</version>
        </dependency>
        <dependency>
            <groupId>org.thymeleaf</groupId>
            <artifactId>thymeleaf-spring5</artifactId>
            <version>3.0.14.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.thymeleaf.extras</groupId>
            <artifactId>thymeleaf-extras-springsecurity5</artifactId>
            <version>3.0.4.RELEASE</version>
        </dependency>

        <!--  持久层框架依赖  -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.27</version>
        </dependency>
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis-spring</artifactId>
            <version>2.0.6</version>
        </dependency>
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.5.7</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-jdbc</artifactId>
            <version>5.3.14</version>
        </dependency>
        <dependency>
            <groupId>com.zaxxer</groupId>
            <artifactId>HikariCP</artifactId>
            <version>3.4.5</version>
        </dependency>

        <!--  其他工具框架依赖：Lombok、Slf4j  -->
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <version>1.18.22</version>
        </dependency>
        <dependency>
            <groupId>org.slf4j</groupId>
            <artifactId>slf4j-jdk14</artifactId>
            <version>1.7.32</version>
        </dependency>

配置类

1. MvcConfiguration

@ComponentScan("com.example.controller")
@Configuration
@EnableWebMvc
public class MvcConfiguration {     
    
    //配置模板解析器
    @Bean
    public SpringResourceTemplateResolver templateResolver(){
        SpringResourceTemplateResolver resolver = new SpringResourceTemplateResolver();
        resolver.setCharacterEncoding("UTF-8");
        resolver.setSuffix(".html");
        resolver.setPrefix("/WEB-INF/");
        return resolver;
    }

    //配置模板引擎Bean
    @Bean
    public SpringTemplateEngine springTemplateEngine(@Autowired ITemplateResolver resolver){
        SpringTemplateEngine engine = new SpringTemplateEngine();
        engine.setTemplateResolver(resolver);
        return engine;
    }
}

//我们需要使用ThymeleafViewResolver作为视图解析器，并解析我们的HTML页面
    @Bean
    public ThymeleafViewResolver thymeleafViewResolver(@Autowired SpringTemplateEngine springTemplateEngine){
        ThymeleafViewResolver resolver = new ThymeleafViewResolver();
        resolver.setOrder(1);
        resolver.setCharacterEncoding("UTF-8");
        resolver.setTemplateEngine(springTemplateEngine);
        return resolver;
    }

// templateResolver -> templateEngine -> ViewResolver

2. RootConfiguration

@ComponentScan("com.example.service")
@MapperScan("com.example.mapper")
@Configuration
public class RootConfiguration {    // 数据库
    @Bean
    public DataSource dataSource(){
        HikariDataSource dataSource = new HikariDataSource();
        dataSource.setJdbcUrl("jdbc:mysql://localhost:3306/book_manage");
        dataSource.setDriverClassName("com.mysql.cj.jdbc.Driver");
        dataSource.setUsername("root");
        dataSource.setPassword("DXH");
        return dataSource;
    }

    @Bean
    public SqlSessionFactoryBean sqlSessionFactoryBean(@Autowired DataSource dataSource){
        SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
        bean.setDataSource(dataSource);
        return bean;
    }
}

初始化类

MvcInitializer

// 对 Servlet 进行调度
public class MvcInitializer extends AbstractAnnotationConfigDispatcherServletInitializer {
    @Override
    protected Class<?>[] getRootConfigClasses() {
        return new Class[]{RootConfiguration.class };
    }

    @Override
    protected Class<?>[] getServletConfigClasses() {
        return new Class[]{MvcConfiguration.class};
    }

    @Override
    protected String[] getServletMappings() {
        return new String[]{"/"};
    }
}

Bean

@Data
public class Book {
    int bid;
    String title;
    String desc;
    double price;
}

Mapper

@Mapper
public interface BookMapper {
    @Select("select `desc` from book")
    List<Book> allBookDesc();

}

Serivce

public interface BookService {
    List<Book> getAllBookDesc();
}

@Service
public class BookServiceImpl implements BookService{

    @Resource
    BookMapper mapper;

    @Override
    public List<Book> getAllBookDesc() {
            return mapper.allBookDesc();
    }
}

Controller

@org.springframework.stereotype.Controller
public class Controller {
    @Resource
    BookService service;

    @RequestMapping("/book")
    public String index( Model model) {
        model.addAttribute("descList",service.getAllBookDesc());
        return "book";
    }

}

html

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>一个测试</title>
</head>
<body>
    <ul th:each="d : ${descList}">
        <li th:text="${d.getDesc()} "></li>
    </ul>
</body>
</html>

包顺序

configuration -> initializer

bean -> mapper -> service -> controller

效果

---

最后

这段时间学的有些赶，接下来会复习一段时间