SpringBoot整合Mybatis

最新推荐文章于 2024-05-19 10:45:02 发布

Pluto372

最新推荐文章于 2024-05-19 10:45:02 发布

阅读量119

点赞数 1

本文链接：https://blog.csdn.net/Pluto372/article/details/112291418

版权

Spring boot 专栏收录该内容

15 篇文章 0 订阅

订阅专栏

SpringBoot整合Mybatis

访问jsp页面

1、添加依赖

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

    <dependency>
        <groupId>org.projectlombok</groupId>
        <artifactId>lombok</artifactId>
        <optional>true</optional>
    </dependency>
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-test</artifactId>
        <scope>test</scope>
    </dependency>
    <!--devtools热部署-->
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-devtools</artifactId>
    </dependency>

    <dependency>
        <groupId>org.mybatis.spring.boot</groupId>
        <artifactId>mybatis-spring-boot-starter</artifactId>
        <version>2.1.1</version>
    </dependency>
    <!-- 数据库驱动 -->
    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>5.1.47</version>
    </dependency>
    <!--servlet依赖 -->
    <!-- https://mvnrepository.com/artifact/javax.servlet/javax.servlet-api -->
   <!--如果报错，可以去点这个api依赖 -->
    <dependency>
        <groupId>javax.servlet</groupId>
        <artifactId>javax.servlet-api</artifactId>
        <version>3.1.0</version>
        <scope>provided</scope>
    </dependency>
    <!-- https://mvnrepository.com/artifact/javax.servlet/jstl -->
    <dependency>
        <groupId>javax.servlet</groupId>
        <artifactId>jstl</artifactId>
        <version>1.2</version>
    </dependency>


    <!-- tomcat支持 -->
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-tomcat</artifactId>
        <scope>provided</scope>
    </dependency>
    <!-- https://mvnrepository.com/artifact/org.apache.tomcat.embed/tomcat-embed-jasper -->
    <dependency>
        <groupId>org.apache.tomcat.embed</groupId>
        <artifactId>tomcat-embed-jasper</artifactId>
    </dependency>
</dependencies>

2、编写配置文件 application.yml

spring:
  datasource:
    username: root
    password: 123456
    url: jdbc:mysql://localhost:3306/yqxcms?serverTimezone=UTC&useUnicode=true&characterEncoding=utf-8
    driver-class-name: com.mysql.jdbc.Driver
  mvc:
    view:
      prefix: /WEB-INF/jsp/
      suffix: .jsp

3、编写代码

dao层:

@Repository
public interface SysUserMapper {
    @Select("select * from sysuser")
    List<SysUser> selectUser();
}

controller层：

@Controller
@RequestMapping("/user")
public class UserController {

    @Autowired
    private SysUserService service;
    @RequestMapping("/list")
    public String selectUser2(Model model){
        List<SysUser> sysUsers = service.selectUser();
        model.addAttribute("list", sysUsers);
        return "user";
    }
}

user.jsp:

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<html>
<head>
    <title>用户管理</title>
</head>
<body>
   <table>
       <tr>
           <th>userid</th>
           <th>username</th>
           <th>usersex</th>
           <th>userstate</th>
       </tr>
       <c:forEach items="${list}" var="user">
           <tr>
               <td>${user.userid}</td>
               <td>${user.username}</td>
               <td>${user.usersex}</td>
               <td>${user.userstate==1?"可用":"不可用"}</td>
           </tr>
       </c:forEach>
   </table>
</body>
</html>

Pluto372

关注

1
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
SpringBoot整合Mybatis

SpringBoot整合Mybatis访问jsp页面1、添加依赖<dependencies> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-web</artifactId> </dependency> <dependency&
复制链接

扫一扫