Sprint Boot的完整實(shí)例,從數(shù)據(jù)庫讀取數(shù)據(jù)并使用Postman測試。
項(xiàng)目地址:https://github.com/Snowstorm0/learn-spring-boot
1 本地?cái)?shù)據(jù)庫
本地?cái)?shù)據(jù)庫創(chuàng)建教程:
創(chuàng)建本地?cái)?shù)據(jù)庫user_data:
2 代碼主體
2.1 Controller
文件名MyController,內(nèi)容為:
@RestController
@RequestMapping("/homepage")
public class MyController {
@Resource
MyService myService;
@GetMapping("/learnSpringBoot")
public String learnController(@RequestParam("number") int number){
return myService.learnService(number);
}
}
2.2 Service
文件名MyService,內(nèi)容為:
@Service
@EnableScheduling
public class MyService {
@Resource
MyMapper myMapper;
public String learnService(int number){
UserDTO res = myMapper.LearnMapper(number);
String name = res.getName();
System.out.println("name:" + name + "\\n");
return name;
}
}
2.3 dao
文件名MyMapper,內(nèi)容為:
@Mapper
public interface MyMapper {
UserDTO LearnMapper(int number);
}
2.4 model
文件名UserDTO,內(nèi)容為:
@Data
public class UserDTO {
private Integer number;
private String name;
public Integer getNumber() {
return number;
}
public void setNumber(Integer number) {
this.number = number;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
}
2.5 Application
在application.properties配置:
# 設(shè)置端口號
server.port=8888
在application.yml配置:
# 連接數(shù)據(jù)庫
spring:
datasource:
url: jdbc:mysql://localhost:3306/sys
driver-class-name: com.mysql.cj.jdbc.Driver
password: root
username: root
# 配置mapper.xml路徑
mybatis:
mapper-locations: classpath:mapper/*.xml
type-aliases-package: com.spring.root.dao
3 Postman
配置Get,地址為: http://localhost:8888/homepage/learnSpringBoot
輸入number:1001
即可獲得返回的name:趙一
審核編輯:湯梓紅
-
JAVA
+關(guān)注
關(guān)注
20文章
2984瀏覽量
106786 -
數(shù)據(jù)庫
+關(guān)注
關(guān)注
7文章
3900瀏覽量
65728 -
spring
+關(guān)注
關(guān)注
0文章
340瀏覽量
14870 -
Boot
+關(guān)注
關(guān)注
0文章
153瀏覽量
36525 -
SpringBoot
+關(guān)注
關(guān)注
0文章
175瀏覽量
312
發(fā)布評論請先 登錄
SpringBoot 學(xué)習(xí)筆記
springboot集成mqtt
SpringBoot應(yīng)用啟動運(yùn)行run方法
SpringBoot配置嵌入式Servlet
什么是 SpringBoot?

SpringBoot的核心注解1

SpringBoot的核心注解2

評論