一.在你建立的工程下創建 module 選擇spring initializr創建。
二.在type處選擇: maven project(項目的構建工具)
三.創建依賴時勾上web,mybatis,mysql(這個看你個人需要吧,可以自主選擇)
建立好的項目結構如下:
注意:application.properties和application.yml是同一個東西,均為項目的核心配置文件
內容如下:
1
2
3
4
5
6
7
8
9
|
#連接數據庫 spring.datasource.url=jdbc:mysql: //localhost:3306/smbms spring.datasource.username=root spring.datasource.password= 1234 spring.datasource.driverclassname=com.mysql.jdbc.driver #引入mybatis的配置文件 mybatis: mybatis.mapper-locations=classpath:mapper/*.xml mybatis.type-aliases- package =com.example.sprboot.pojo |
相應的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
65
66
67
68
|
<?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>com.example</groupid> <artifactid>springboot</artifactid> <version> 0.0 . 1 -snapshot</version> <packaging>jar</packaging> <name>springboot</name> <description>demo project for spring boot</description> <parent> <groupid>org.springframework.boot</groupid> <artifactid>spring-boot-starter-parent</artifactid> <version> 2.0 . 5 .release</version> <relativepath/> <!-- lookup parent from repository --> </parent> <properties> <project.build.sourceencoding>utf- 8 </project.build.sourceencoding> <project.reporting.outputencoding>utf- 8 </project.reporting.outputencoding> <java.version> 1.8 </java.version> </properties> <dependencies> <!--添加web依賴--> <dependency> <groupid>org.springframework.boot</groupid> <artifactid>spring-boot-starter-web</artifactid> </dependency> <!--引入spring boot包--> <dependency> <groupid>org.springframework.boot</groupid> <artifactid>spring-boot-starter-test</artifactid> <scope>test</scope> </dependency> <!-- spring-mybatis --> <dependency> <groupid>org.mybatis.spring.boot</groupid> <artifactid>mybatis-spring-boot-starter</artifactid> <version> 1.3 . 0 </version> </dependency> <!-- mysql --> <dependency> <groupid>mysql</groupid> <artifactid>mysql-connector-java</artifactid> </dependency> <!--使用json對象--> <dependency> <groupid>com.alibaba</groupid> <artifactid>fastjson</artifactid> <version> 1.2 . 49 </version> </dependency> <!--使用thymeleaf標簽--> <dependency> <groupid>org.springframework.boot</groupid> <artifactid>spring-boot-starter-thymeleaf</artifactid> </dependency> </dependencies> <build> <plugins> <plugin> <groupid>org.springframework.boot</groupid> <artifactid>spring-boot-maven-plugin</artifactid> </plugin> </plugins> </build> </project> |
相應的接口usermapper如下:
1
2
3
4
|
@repository public interface usermapper { list<user> getlist(); } |
service如下:
1
2
3
|
public interface userservice { list<user> getlist(); } |
impl如下:
1
2
3
4
5
6
7
8
9
|
@service public class userserviceimpl implements userservice { @resource private usermapper usermapper; @override public list<user> getlist() { return usermapper.getlist(); } } |
在resources中建一個文件夾mapper里面放mapper.xml文件,代碼如下:
1
2
3
|
<select id= "getlist" resulttype= "user" > select * from smbms_user </select> |
在templates文件夾中建html文件(注意:spring boot中不能跳轉到.jsp文件,所以只能用html)
核心代碼如下:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
|
<table> <th>工號</th> <th>用戶名</th> <th>姓名</th> <th>性別</th> <th>生日</th> <th>電話</th> <th>地址</th> <th>創建時間</th> <tr th:each= "user : ${users}" > <td th:text= "${user.id}" ></td> <td th:text= "${user.usercode}" ></td> <td th:text= "${user.username}" ></td> <td th:text= "${user.gender}" ></td> <td th:text= "${user.birthday}" ></td> <td th:text= "${user.phone}" ></td> <td th:text= "${user.address}" ></td> <td th:text= "${user.createdby}" ></td> </tr> </table> |
此處有一個th標簽,需要引入一個<html xmlns:th="http://www.thymeleaf.org">
并在pom.xml中引入對應的jar包(html中不能使用jstl表達式)
大家可以擴展一下thymeleaf的知識
控制器代碼如下:
1
2
3
4
5
6
7
8
9
10
11
12
|
@controller public class usercontroller { @resource private userservice userservice; @requestmapping ( "/" ) public string getstuinforlist(httpservletrequest request, model model){ list<user> list=userservice.getlist(); model.addattribute( "users" ,list); system.out.println(list); return "/index.html" ; } } |
注:在調通的時候,可能會報很多的錯,基本上都是注解的使用出錯,希望各位能夠細心點
以上就是本文的全部內容,希望對大家的學習有所幫助,也希望大家多多支持服務器之家。
原文鏈接:http://www.cnblogs.com/merakfire/p/9805235.html