这算一种记录，方便遇到相同的代码直接复制，后端使用springboot
数据库

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `users`
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `id` int NOT NULL,
  `username` varchar(100) COLLATE utf8_croatian_ci DEFAULT NULL,
  `password` varchar(100) COLLATE utf8_croatian_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_croatian_ci;

-- ----------------------------
-- Records of users
-- ----------------------------
INSERT INTO `users` VALUES ('1', '222', '222');
INSERT INTO `users` VALUES ('2', '333', '3333');
INSERT INTO `users` VALUES ('3', '3333', '333');

pom.xml

    4.0.0
    com.example
    wh_paimai
    0.0.1-SNAPSHOT
    wh_paimai
    Demo project for Spring Boot

    
        1.8
        UTF-8
        UTF-8
        2.3.7.RELEASE
    

    
        
            org.springframework.boot
            spring-boot-starter-jdbc
        
        
            org.springframework.boot
            spring-boot-starter-web
        
        
            org.mybatis.spring.boot
            mybatis-spring-boot-starter
            2.1.4
        

        
            mysql
            mysql-connector-java
        
        
            org.mybatis.spring.boot
            mybatis-spring-boot-starter
            1.3.0
        


        
            org.apache.tomcat.embed
            tomcat-embed-jasper
        

        
        
            javax.servlet
            servlet-api
            2.5
        
        
            javax.servlet.jsp
            jsp-api
            2.2
        
        
            javax.servlet
            jstl
            1.2
        


        
            mysql
            mysql-connector-java
            runtime
        
        
            org.projectlombok
            lombok
            true
        
        
            org.springframework.boot
            spring-boot-starter-test
            test
            
                
                    org.junit.vintage
                    junit-vintage-engine
                
            
        
    

    
        
            
                org.springframework.boot
                spring-boot-dependencies
                ${spring-boot.version}
                pom
                import
            
        
    



    
        
            
                org.apache.maven.plugins
                maven-compiler-plugin
                3.8.1
                
                    1.8
                    1.8
                    UTF-8
                
            
            
                org.springframework.boot
                spring-boot-maven-plugin
                2.3.7.RELEASE
                
                    com.wh.wh_paimai.WhPaimaiApplication
                
                
                    
                        repackage
                        
                            repackage
                        
                    
                
            
        
    

application.yml

server:
  port: 9999
spring:
  mvc:
    view:
      prefix: /jsp/
      suffix: .jsp
  datasource:
    url: jdbc:mysql://localhost:3306/paimai?serverTimezone=CST&useUnicode=true&characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull&useSSL=true
    username: root
    password: 123456
    driver-class-name: com.mysql.cj.jdbc.Driver

controller

@RestController
public class UsersController {

       @Resource
        private UsersService usersService;

        @GetMapping("/allusers")
        public List allUsers(Model model) {
            List list = usersService.queryAllUsers();
            model.addAttribute("list", list);
            return list;
        }
    }

前端

<%@ page contentType="text/html;charset=UTF-8" language="java" %>


    
    



    

        

            

                

                    用户管理
                
            
        
    



    

        
            <%--         书籍从数据库查询出来 ，从list之中遍历出来--%>
            

            

            
用户编号
            
用户名称
            
用户密码