更新时间:2022-06-18 23:50:48
“年轻就不应该让自己过得太舒服” – From yong
a.创建数据库 springbootdb:
1
|
CREATE DATABASE springbootdb; |
1
2
3
4
5
6
7
8
|
DROP TABLE IF EXISTS `city`; CREATE TABLE `city` ( ` id ` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '城市编号' ,
`province_id` int(10) unsigned NOT NULL COMMENT '省份编号' ,
`city_name` varchar(25) DEFAULT NULL COMMENT '城市名称' ,
`description` varchar(25) DEFAULT NULL COMMENT '描述' ,
PRIMARY KEY (` id `)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8; |
c.插入数据
1
|
INSERT city VALUES (1 ,1, '温岭市' , 'BYSocket 的家在温岭。' );
|
org.spring.springboot.controller – Controller 层org.spring.springboot.dao – 数据操作层 DAOorg.spring.springboot.domain – 实体类org.spring.springboot.service – 业务逻辑层Application – 应用启动类resources/application.properties – 应用配置文件,应用启动会自动读取配置resources/web – *.ftl文件,是 FreeMarker 文件配置路径。在 application.properties 配置resources/mapper – DAO Maper XML 文件
1
|
localhost:8080 /api/city/1
|
1
|
localhost:8080 /api/city
|
pom.xml 代码如下:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
|
<? xml version = "1.0" encoding = "UTF-8" ?>
< project xmlns = "http://maven.apache.org/POM/4.0.0" xmlns:xsi = "http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation = "http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd" >
< modelVersion >4.0.0</ modelVersion >
< groupId >springboot</ groupId >
< artifactId >springboot-freemarker</ artifactId >
< version >0.0.1-SNAPSHOT</ version >
< name >springboot-freemarker :: Spring Boot 集成 FreeMarker 案例</ name >
<!-- Spring Boot 启动父依赖 -->
< parent >
< groupId >org.springframework.boot</ groupId >
< artifactId >spring-boot-starter-parent</ artifactId >
< version >1.5.1.RELEASE</ version >
</ parent >
< properties >
< mybatis-spring-boot >1.2.0</ mybatis-spring-boot >
< mysql-connector >5.1.39</ mysql-connector >
</ properties >
< dependencies >
<!-- Spring Boot Freemarker 依赖 -->
< dependency >
< groupId >org.springframework.boot</ groupId >
< artifactId >spring-boot-starter-freemarker</ artifactId >
</ dependency >
<!-- Spring Boot Web 依赖 -->
< dependency >
< groupId >org.springframework.boot</ groupId >
< artifactId >spring-boot-starter-web</ artifactId >
</ dependency >
<!-- Spring Boot Test 依赖 -->
< dependency >
< groupId >org.springframework.boot</ groupId >
< artifactId >spring-boot-starter-test</ artifactId >
< scope >test</ scope >
</ dependency >
<!-- Spring Boot Mybatis 依赖 -->
< dependency >
< groupId >org.mybatis.spring.boot</ groupId >
< artifactId >mybatis-spring-boot-starter</ artifactId >
< version >${mybatis-spring-boot}</ version >
</ dependency >
<!-- MySQL 连接驱动依赖 -->
< dependency >
< groupId >mysql</ groupId >
< artifactId >mysql-connector-java</ artifactId >
< version >${mysql-connector}</ version >
</ dependency >
<!-- Junit -->
< dependency >
< groupId >junit</ groupId >
< artifactId >junit</ artifactId >
< version >4.12</ version >
</ dependency >
</ dependencies >
</ project >
|
然后在 application.properties 中加入 FreeMarker 相关的配置:
1
2
3
4
5
6
7
8
9
10
11
|
## Freemarker 配置 ## 文件配置路径 spring.freemarker.template-loader-path=classpath: /web/
spring.freemarker.cache= false
spring.freemarker.charset=UTF-8 spring.freemarker.check-template-location= true
spring.freemarker.content- type =text /html
spring.freemarker.expose-request-attributes= true
spring.freemarker.expose-session-attributes= true
spring.freemarker.request-context-attribute=request spring.freemarker.suffix=.ftl |
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
spring.freemarker.allow-request-override= false # Set whether HttpServletRequest attributes are allowed to override (hide) controller generated model attributes of the same name.
spring.freemarker.allow-session-override= false # Set whether HttpSession attributes are allowed to override (hide) controller generated model attributes of the same name.
spring.freemarker.cache= false # Enable template caching.
spring.freemarker.charset=UTF-8 # Template encoding.
spring.freemarker.check-template-location= true # Check that the templates location exists.
spring.freemarker.content- type =text /html # Content-Type value.
spring.freemarker.enabled= true # Enable MVC view resolution for this technology.
spring.freemarker.expose-request-attributes= false # Set whether all request attributes should be added to the model prior to merging with the template.
spring.freemarker.expose-session-attributes= false # Set whether all HttpSession attributes should be added to the model prior to merging with the template.
spring.freemarker.expose-spring-macro-helpers= true # Set whether to expose a RequestContext for use by Spring's macro library, under the name "springMacroRequestContext".
spring.freemarker.prefer- file -system-access= true # Prefer file system access for template loading. File system access enables hot detection of template changes.
spring.freemarker.prefix= # Prefix that gets prepended to view names when building a URL.
spring.freemarker.request-context-attribute= # Name of the RequestContext attribute for all views.
spring.freemarker.settings.*= # Well-known FreeMarker keys which will be passed to FreeMarker's Configuration.
spring.freemarker.suffix= # Suffix that gets appended to view names when building a URL.
spring.freemarker.template-loader-path=classpath: /templates/ # Comma-separated list of template paths.
spring.freemarker.view-names= # White list of view names that can be resolved.
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
|
/** * 城市 Controller 实现 Restful HTTP 服务
* <p>
* Created by bysocket on 07/02/2017.
*/
@Controller public class CityController {
@Autowired
private CityService cityService;
@RequestMapping (value = "/api/city/{id}" , method = RequestMethod.GET)
public String findOneCity(Model model, @PathVariable ( "id" ) Long id) {
model.addAttribute( "city" , cityService.findCityById(id));
return "city" ;
}
@RequestMapping (value = "/api/city" , method = RequestMethod.GET)
public String findAllCity(Model model) {
List<City> cityList = cityService.findAllCity();
model.addAttribute( "cityList" ,cityList);
return "cityList" ;
}
} |