查看“IntelliJ IDEA Spring Boot”的源代码
←
IntelliJ IDEA Spring Boot
跳到导航
跳到搜索
因为以下原因,您没有权限编辑本页:
您请求的操作仅限属于该用户组的用户执行:
用户
您可以查看和复制此页面的源代码。
Spring Boot helps you to create Spring-powered, production-grade applications and services with absolute minimum fuss. It takes an opinionated view of the Spring platform so that new and existing users can quickly get to the bits they need. Spring Boot 是一个基于 Spring 的框架,旨在简化 Spring 应用的配置和开发过程,通过自动配置和约定大于配置的原则,使开发者能够快速搭建独立、生产级别的应用程序。 * Environment: IntelliJ IDEA 2023.1 (Ultimate Edition) * Features: web, mysql * Course: # New project -> Spring Initializr -> type: maven: testSprintBoot # Dependency -> Web: Spring Web,SQL: MyBatis Framework, MySQL Driver/H2 Database # src/main/resources: application.properties -> application.yml # src/main/resources/static: index.html # com.example.testspringboot: bean, controller, mapper, service === pom.xml === <small><nowiki> <!-- spring-boot --> <parent> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-parent</artifactId> <version>3.3.2</version> <relativePath/> </parent> <dependencies> <!-- spring-boot --> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-web</artifactId> </dependency> <!-- mybatis --> <dependency> <groupId>org.mybatis.spring.boot</groupId> <artifactId>mybatis-spring-boot-starter</artifactId> <version>3.0.3</version> </dependency> <!-- MySQL --> <dependency> <groupId>com.mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>8.0.33</version> </dependency> .... </dependencies></small></nowiki> === application.yml === <small><nowiki>spring.application.name: testSprintBoot server: port: 8083 spring: datasource: url: jdbc:mysql://192.168.0.83:3306/mysql?serverTimezone=Asia/Shanghai&characterEncoding=utf-8 username: root password: 123456 driver-class-name: com.mysql.cj.jdbc.Driver mybatis: type-aliases-package: com.example.testspringboot.bean</nowiki></small> === index.html === <small><nowiki><!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title>Title</title> </head> <body> This is a test web page. </body> </html></nowiki></small> === TestSprintBootApplication === <small><nowiki># main.java/com.example.testspringboot.TestspringbootApplication package com.example.testspringboot; import org.springframework.boot.SpringApplication; import org.springframework.boot.autoconfigure.SpringBootApplication; @SpringBootApplication public class TestspringbootApplication { public static void main(String[] args) { SpringApplication.run(TestspringbootApplication.class, args); } }</nowiki></small> === bean === ==== SysUser ==== <small><nowiki>package com.example.testsprintboot.bean; import org.springframework.format.annotation.DateTimeFormat; import java.time.LocalDateTime; import java.util.Date; public class SysUser { private String host; private String user; private String passwordLastChanged; public String getHost() { return host; } public void setHost(String host) { this.host = host; } public String getUser() { return user; } public void setUser(String user) { this.user = user; } public String getPasswordLastChanged() { return passwordLastChanged; } public void setPasswordLastChanged(String passwordLastChanged) { this.passwordLastChanged = passwordLastChanged; } }</nowiki></small> === mapper === ==== SysUserMapper ==== <small><nowiki>package com.example.testsprintboot.mapper; import com.example.testsprintboot.bean.SysUser; import org.apache.ibatis.annotations.Mapper; import org.apache.ibatis.annotations.Select; import java.util.List; @Mapper public interface SysUserMapper { @Select({ "select", "host, user, date_format(password_last_changed, '%Y-%m-%d %H:%i:%s') password_last_changed", "from user" }) List<SysUser> selectAll(); }</nowiki></small> === service === ==== SysUserService ==== <small><nowiki>package com.example.testsprintboot.service; import com.example.testsprintboot.bean.SysUser; import java.util.List; public interface SysUserService { public List<SysUser> selectAll(); } # service: SysUserServiceImpl package com.example.testsprintboot.service; import com.example.testsprintboot.bean.SysUser; import com.example.testsprintboot.mapper.SysUserMapper; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import java.util.List; @Service("SysUserService") public class SysUserServiceImpl implements SysUserService { @Autowired private SysUserMapper sysUserMapper; @Override public List<SysUser> selectAll() { return sysUserMapper.selectAll(); } }</nowiki></small> === controller === ==== SysUserController ==== <small><nowiki>package com.example.testsprintboot.controller; import com.example.testsprintboot.bean.SysUser; import com.example.testsprintboot.service.SysUserService; import com.example.testsprintboot.service.SysUserServiceImpl; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RequestMethod; import org.springframework.web.bind.annotation.RestController; import jakarta.annotation.Resource; import java.util.List; @RestController @RequestMapping("/sysuser") public class SysUserController { @Resource private SysUserService sysUserService = new SysUserServiceImpl(); @RequestMapping(value = "/selectAll", method = RequestMethod.GET) public List<SysUser> selectAll() { List<SysUser> list = sysUserService.selectAll(); return list; } }</nowiki></small> === Test === <small><nowiki>http://127.0.0.1:8083/sysuser/selectAll [{"host":"%","user":"root","passwordLastChanged":null},{"host":"localhost","user":"mysql.infoschema","passwordLastChanged":null},{"host":"localhost","user":"mysql.session","passwordLastChanged":null},{"host":"localhost","user":"mysql.sys","passwordLastChanged":null},{"host":"localhost","user":"root","passwordLastChanged":null}]</nowiki></small> == See also == # [https://www.cnblogs.com/detailNew/p/14967528.html IDEA搭建一个SpringBoot项目] # [https://www.cnblogs.com/caizhaokai/p/10982727.html SpringBoot + MyBatis(注解版),常用的SQL方法] # [https://springdoc.cn/spring-and-cors/ 在 Spring 应用中处理 CORS 跨域] [[分类:Develop]] [[分类:Java]]
返回
IntelliJ IDEA Spring Boot
。
导航菜单
个人工具
登录
命名空间
页面
讨论
大陆简体
查看
阅读
查看源代码
查看历史
更多
搜索
导航
首页
最近更改
随机页面
目录
文章分类
侧边栏
帮助
工具
链入页面
相关更改
特殊页面
页面信息