一、開發環境：
1、windows 7 企業版
2、idea 14
3、jdk 1.8
4、maven 3.5.2
5、mariadb
6、sqlyog
二、maven設置：
maven目錄下的conf目錄下的settings.xml做如下內容的添加：
1、使用阿里云的倉庫，比官網訪問速度快很多
|
1
2
3
4
5
6
|
<mirror> <id>nexus-aliyun</id> <mirrorof>central</mirrorof> <name>nexus aliyun</name><url>http://maven.aliyun.com/nexus/content/groups/public</url></mirror> |
2、全局jdk配置
|
1
2
3
4
5
6
7
8
9
10
11
12
13
|
<!-- 全局jdk配置，settings.xml --> <profile> <id>jdk18</id> <activation> <activebydefault>true</activebydefault> <jdk>1.8</jdk> </activation> <properties> <maven.compiler.source>1.8</maven.compiler.source> <maven.compiler.target>1.8</maven.compiler.target> <maven.compiler.compilerversion>1.8</maven.compiler.compilerversion> </properties> </profile> |
三、idea基本設置：
1、maven設置：選擇maven目錄，同時配置文件和本地倉庫
2、字符編碼設置
四、使用idea創建maven工程：
選擇enable auto-import，創建好的工程目錄如下圖：
五、體驗springboot結合jpa的快速開發吧
1、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
|
<?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>cn.temptation</groupid> <artifactid>studyspringboot</artifactid> <version>1.0-snapshot</version> <!-- 使用spring boot的默認設置 --> <parent> <groupid>org.springframework.boot</groupid> <artifactid>spring-boot-starter-parent</artifactid> <version>2.0.0.release</version> </parent> <dependencies> <!-- web --> <dependency> <groupid>org.springframework.boot</groupid> <artifactid>spring-boot-starter-web</artifactid> </dependency> <!-- thymeleaf --> <dependency> <groupid>org.springframework.boot</groupid> <artifactid>spring-boot-starter-thymeleaf</artifactid> </dependency> <!-- mysql--> <dependency> <groupid>mysql</groupid> <artifactid>mysql-connector-java</artifactid> <version>5.1.21</version> </dependency> <!-- jpa--> <dependency> <groupid>org.springframework.boot</groupid> <artifactid>spring-boot-starter-data-jpa</artifactid> </dependency> </dependencies></project> |
2、resources目錄下新建application.properties（當然喜歡用yaml的可以用yaml）
|
1
2
3
4
5
6
7
|
# 數據庫連接spring.datasource.url=jdbc:mysql://127.0.0.1:3306/testspring.datasource.username=rootspring.datasource.password=saspring.datasource.driver-class-name=com.mysql.jdbc.driver# jpa配置spring.jpa.properties.hibernate.hbm2ddl.auto=update |
3、創建springboot程序啟動類springbootapplication.java
|
1
2
3
4
5
6
7
8
9
10
11
12
|
package cn.temptation;import org.springframework.boot.springapplication;import org.springframework.boot.autoconfigure.springbootapplication;@springbootapplicationpublic class springbootapplication { public static void main(string[] args) { // springboot項目啟動 springapplication.run(springbootapplication.class, args); }} |
4、創建實體類category.java
|
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
|
package cn.temptation.model;import javax.persistence.*;// 建庫建表//drop table category;////create table category//(// categoryid int auto_increment primary key,// categoryname varchar(10) not null//);////insert into category values(null, '手機'), (null, '圖書'), (null, '服裝'), (null, '鞋帽');////select * from category;@entity@table(name = "category")public class category { @id @generatedvalue(strategy = generationtype.identity) @column(name = "categoryid") private integer categoryid; @column(name = "categoryname") private string categoryname; public integer getcategoryid() { return categoryid; } public void setcategoryid(integer categoryid) { this.categoryid = categoryid; } public string getcategoryname() { return categoryname; } public void setcategoryname(string categoryname) { this.categoryname = categoryname; }} |
5、創建dao接口categorydao.java
|
1
2
3
4
5
|
package cn.temptation.dao;import cn.temptation.model.category;import org.springframework.data.jpa.repository.jparepository;public interface categorydao extends jparepository<category, integer> {} |
6、創建控制器類categorycontroller.java
|
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
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
|
package cn.temptation.web;import cn.temptation.dao.categorydao;import cn.temptation.model.category;import org.springframework.beans.factory.annotation.autowired;import org.springframework.data.domain.page;import org.springframework.data.domain.pagerequest;import org.springframework.data.domain.pageable;import org.springframework.data.domain.sort;import org.springframework.stereotype.controller;import org.springframework.web.bind.annotation.requestmapping;import org.springframework.web.bind.annotation.requestparam;import org.springframework.web.servlet.modelandview;import java.util.list;@controllerpublic class categorycontroller { @autowired private categorydao categorydao; /** * 不分頁查詢 * * @return */// @requestmapping("/categorylist")// public modelandview categorylist() {// list<category> list = categorydao.findall();//// modelandview mav = new modelandview("categorylist");// mav.addobject("list", list);// return mav;// } /** * 分頁查詢 * * @return */ @requestmapping("/categorylist") public modelandview categorylist(@requestparam(value = "start", defaultvalue = "0") integer start, @requestparam(value = "limit", defaultvalue = "2") integer limit) { start = start < 0 ? 0 : start; sort sort = new sort(sort.default_direction, "categoryid"); pageable pageable = new pagerequest(start, limit, sort); page<category> page = categorydao.findall(pageable);// system.out.println(page.getnumber());// system.out.println(page.getnumberofelements());// system.out.println(page.getsize());// system.out.println(page.gettotalelements());// system.out.println(page.gettotalpages());// system.out.println(page.isfirst());// system.out.println(page.islast()); modelandview mav = new modelandview("categorylist"); mav.addobject("page", page); return mav; } /** * 類別新增視圖 * @return */ @requestmapping("/categoryinit") public string categoryinit() { return "categoryinit"; } /** * 類別新增操作 * @param model * @return */ @requestmapping("/categoryinsert") public string categoryinsert(category model) { categorydao.save(model); return "redirect:categorylist"; } /** * 類別刪除操作 * @param categoryid * @return */ @requestmapping("/categorydelete") public string categorydelete(integer categoryid) { categorydao.deletebyid(categoryid); return "redirect:categorylist"; } /** * 類別編輯視圖 * @param categoryid * @return */ @requestmapping("/categoryedit") public modelandview categoryedit(integer categoryid) { category model = categorydao.getone(categoryid); modelandview mav = new modelandview("categoryedit"); mav.addobject("category", model); return mav; } /** * 類別編輯操作 * @param model * @return */ @requestmapping("/categoryupdate") public string categoryupdate(category model) { categorydao.save(model); return "redirect:categorylist"; }} |
7、resources目錄下新建templates目錄，創建表現層：類別列表頁面（categorylist.html）、類別新增頁面（categoryinit.html）、類別編輯頁面（categoryedit.html）
類別列表頁面（categorylist.html）
|
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
|
<!doctype html><html lang="en"><head> <meta charset="utf-8"> <title>類別列表</title> <style> table, th, td { border: 1px solid green; border-collapse: collapse; } </style></head><body><a th:href="@{/categoryinit}">新增</a><table> <tr> <th>類別編號</th> <th>類別名稱</th> <th>操 作</th> </tr> <!--不分頁遍歷--> <!--<tr th:each="item : ${list}">--> <!--分頁遍歷--> <tr th:each="item : ${page.content}"> <td th:text="${item.categoryid}">類別編號</td> <td th:text="${item.categoryname}">類別名稱</td> <td> <a th:href="@{/categoryedit(categoryid=${item.categoryid})}">編輯</a> <a th:href="@{/categorydelete(categoryid=${item.categoryid})}">刪除</a> </td> </tr></table><div> <a th:href="@{/categorylist(start=0)}">[首頁]</a> <a th:if="${not page.isfirst()}" th:href="@{/categorylist(start=${page.number-1})}">[上頁]</a> <a th:if="${not page.islast()}" th:href="@{/categorylist(start=${page.number+1})}">[下頁]</a> <a th:href="@{/categorylist(start=${page.totalpages-1})}">[末頁]</a></div></body></html> |
類別新增頁面（categoryinit.html）
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
|
<!doctype html><html lang="en"><head> <meta charset="utf-8"> <title>類別新增</title></head><body><form action="categoryinsert" method="post"> <label for="txtcategoryname">類別名稱：</label> <input type="text" id="txtcategoryname" name="categoryname" /><br/> <input type="submit" value="提交"></form></body></html> |
類別編輯頁面（categoryedit.html）
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
|
<!doctype html><html lang="en"><head> <meta charset="utf-8"> <title>類別編輯</title></head><body><form action="categoryupdate" method="post"> <input type="hidden" id="txtcategoryid" name="categoryid" th:field="${category.categoryid}"/><br/> <label for="txtcategoryname">類別名稱：</label> <input type="text" id="txtcategoryname" name="categoryname" th:field="${category.categoryname}"/><br/> <input type="submit" value="提交"></form></body></html> |
六、啟動項目，運行效果如下
總結
以上所述是小編給大家介紹的idea+maven+springboot+jpa+thymeleaf實現crud及分頁，希望對大家有所幫助，如果大家有任何疑問請給我留言，小編會及時回復大家的。在此也非常感謝大家對服務器之家網站的支持！
原文鏈接：https://www.cnblogs.com/iflytek/p/8526182.html
