1.创建springboot项目,添加web依赖
-
只能添加web依赖,不能添加jdbc,mysql,不然添加数据库配置
测试tomcat
@RestController
public class HelloController {
@RequestMapping("/hello")
public String hello(){
return "hello";
}
}
2.导入静态资源
css,js,img放在static下,html放在templates
导入thymeleaf依赖
<!--thymeleaf-->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-thymeleaf</artifactId>
</dependency>
使用thymeleaf修改静态页面
<html lang="en"xmlns:th="http://www.thymeleaf.org">
<link th:href="@{/css/bootstrap.min.css}" rel="stylesheet">
<!-- Custom styles for this template -->
<link th:href="@{/css/signin.css}" rel="stylesheet">
首页实现,扩展MVC,添加视图控制实现WebMvcConfigurer
//扩展MVC
@Configuration
public class MyMvcConfig implements WebMvcConfigurer {
@Override
public void addViewControllers(ViewControllerRegistry registry) {
registry.addViewController("/").setViewName("index");
registry.addViewController("/index.html").setViewName("index");
}
}
3.创建对象
导入lomlok依赖
<!-- lombok-->
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
</dependency>
User
@Data
@AllArgsConstructor
@NoArgsConstructor
public class User {
private Integer id;
private String username;
private String password;
}
Employee
@Data
@AllArgsConstructor
@NoArgsConstructor
public class Employee {
private Integer id;
private String lastName;
private String email;
private Integer gender;
private String department;
private Date birth;
}
4.创建数据库,添加jdbc,mysql依赖,并创建application.yaml文件配置数据库
导入jdbc,mysql依赖
<!--jdbc-->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>
<!-- mysql-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<scope>runtime</scope>
</dependency>
创建数据库
CREATE DATABASE mydatabase;
create table `t_employee` (
`id` int (11),
`lastName` varchar (96),
`email` varchar (96),
`gender` int (32),
`department` varchar (96),
`birth` datetime
);
insert into `t_employee` (`id`, `lastName`, `email`, `gender`, `department`, `birth`) values('7','wanglichen','26735786@qq.com','1','科研部','1999-10-05 16:00:00.000000')