【原】无脑操作:IDEA + maven + SpringBoot + JPA + Thymeleaf实现CRUD及分页
一、开发环境:
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 <mirror> 2 <id>nexus-aliyun</id> 3 <mirrorOf>central</mirrorOf> 4 <name>Nexus aliyun</name> 5 <url>http://maven.aliyun.com/nexus/content/groups/public</url> 6 </mirror>
2、全局JDK配置
1 <!-- 全局jdk配置,settings.xml --> 2 <profile> 3 <id>jdk18</id> 4 <activation> 5 <activeByDefault>true</activeByDefault> 6 <jdk>1.8</jdk> 7 </activation> 8 <properties> 9 <maven.compiler.source>1.8</maven.compiler.source> 10 <maven.compiler.target>1.8</maven.compiler.target> 11 <maven.compiler.compilerVersion>1.8</maven.compiler.compilerVersion> 12 </properties> 13 </profile>
三、IDEA基本设置:
1、Maven设置:选择Maven目录,同时配置文件和本地仓库
2、字符编码设置
四、使用IDEA创建Maven工程:
选择Enable Auto-Import,创建好的工程目录如下图:
五、体验SpringBoot结合JPA的快速开发吧
1、pom.xml
1 <?xml version="1.0" encoding="UTF-8"?> 2 <project xmlns="http://maven.apache.org/POM/4.0.0" 3 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 4 xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"> 5 <modelVersion>4.0.0</modelVersion> 6 7 <groupId>cn.temptation</groupId> 8 <artifactId>studySpringBoot</artifactId> 9 <version>1.0-SNAPSHOT</version> 10 11 <!-- 使用spring boot的默认设置 --> 12 <parent> 13 <groupId>org.springframework.boot</groupId> 14 <artifactId>spring-boot-starter-parent</artifactId> 15 <version>2.0.0.RELEASE</version> 16 </parent> 17 18 <dependencies> 19 <!-- web --> 20 <dependency> 21 <groupId>org.springframework.boot</groupId> 22 <artifactId>spring-boot-starter-web</artifactId> 23 </dependency> 24 <!-- thymeleaf --> 25 <dependency> 26 <groupId>org.springframework.boot</groupId> 27 <artifactId>spring-boot-starter-thymeleaf</artifactId> 28 </dependency> 29 <!-- mysql--> 30 <dependency> 31 <groupId>mysql</groupId> 32 <artifactId>mysql-connector-java</artifactId> 33 <version>5.1.21</version> 34 </dependency> 35 <!-- jpa--> 36 <dependency> 37 <groupId>org.springframework.boot</groupId> 38 <artifactId>spring-boot-starter-data-jpa</artifactId> 39 </dependency> 40 </dependencies> 41 </project>
2、resources目录下新建application.properties(当然喜欢用yaml的可以用yaml)
1 # 数据库连接 2 spring.datasource.url=jdbc:mysql://127.0.0.1:3306/test 3 spring.datasource.username=root 4 spring.datasource.password=sa 5 spring.datasource.driver-class-name=com.mysql.jdbc.Driver 6 7 # JPA配置 8 spring.jpa.properties.hibernate.hbm2ddl.auto=update
3、创建SpringBoot程序启动类SpringbootApplication.java
1 package cn.temptation; 2 3 import org.springframework.boot.SpringApplication; 4 import org.springframework.boot.autoconfigure.SpringBootApplication; 5 6 @SpringBootApplication 7 public class SpringbootApplication { 8 public static void main(String[] args) { 9 // SpringBoot项目启动 10 SpringApplication.run(SpringbootApplication.class, args); 11 } 12 }
4、创建实体类Category.java
1 package cn.temptation.model; 2 3 import javax.persistence.*; 4 5 // 建库建表 6 //DROP TABLE category; 7 // 8 //CREATE TABLE category 9 //( 10 // categoryid INT AUTO_INCREMENT PRIMARY KEY, 11 // categoryname VARCHAR(10) NOT NULL 12 //); 13 // 14 //INSERT INTO category VALUES(NULL, '手机'), (NULL, '图书'), (NULL, '服装'), (NULL, '鞋帽'); 15 // 16 //SELECT * FROM category; 17 @Entity 18 @Table(name = "category") 19 public class Category { 20 @Id 21 @GeneratedValue(strategy = GenerationType.IDENTITY) 22 @Column(name = "categoryid") 23 private Integer categoryid; 24 25 @Column(name = "categoryname") 26 private String categoryname; 27 28 public Integer getCategoryid() { 29 return categoryid; 30 } 31 32 public void setCategoryid(Integer categoryid) { 33 this.categoryid = categoryid; 34 } 35 36 public String getCategoryname() { 37 return categoryname; 38 } 39 40 public void setCategoryname(String categoryname) { 41 this.categoryname = categoryname; 42 } 43 }
5、创建DAO接口CategoryDao.java
1 package cn.temptation.dao; 2 3 import cn.temptation.model.Category; 4 import org.springframework.data.jpa.repository.JpaRepository; 5 6 public interface CategoryDao extends JpaRepository<Category, Integer> { 7 8 }
6、创建控制器类CategoryController.java
1 package cn.temptation.web; 2 3 import cn.temptation.dao.CategoryDao; 4 import cn.temptation.model.Category; 5 import org.springframework.beans.factory.annotation.Autowired; 6 import org.springframework.data.domain.Page; 7 import org.springframework.data.domain.PageRequest; 8 import org.springframework.data.domain.Pageable; 9 import org.springframework.data.domain.Sort; 10 import org.springframework.stereotype.Controller; 11 import org.springframework.web.bind.annotation.RequestMapping; 12 import org.springframework.web.bind.annotation.RequestParam; 13 import org.springframework.web.servlet.ModelAndView; 14 15 import java.util.List; 16 17 @Controller 18 public class CategoryController { 19 @Autowired 20 private CategoryDao categoryDao; 21 22 /** 23 * 不分页查询 24 * 25 * @return 26 */ 27 // @RequestMapping("/categorylist") 28 // public ModelAndView categorylist() { 29 // List<Category> list = categoryDao.findAll(); 30 // 31 // ModelAndView mav = new ModelAndView("categorylist"); 32 // mav.addObject("list", list); 33 // return mav; 34 // } 35 36 /** 37 * 分页查询 38 * 39 * @return 40 */ 41 @RequestMapping("/categorylist") 42 public ModelAndView categorylist(@RequestParam(value = "start", defaultValue = "0") Integer start, 43 @RequestParam(value = "limit", defaultValue = "2") Integer limit) { 44 start = start < 0 ? 0 : start; 45 46 Sort sort = new Sort(Sort.DEFAULT_DIRECTION, "categoryid"); 47 Pageable pageable = new PageRequest(start, limit, sort); 48 Page<Category> page = categoryDao.findAll(pageable); 49 50 // System.out.println(page.getNumber()); 51 // System.out.println(page.getNumberOfElements()); 52 // System.out.println(page.getSize()); 53 // System.out.println(page.getTotalElements()); 54 // System.out.println(page.getTotalPages()); 55 // System.out.println(page.isFirst()); 56 // System.out.println(page.isLast()); 57 58 ModelAndView mav = new ModelAndView("categorylist"); 59 mav.addObject("page", page); 60 return mav; 61 } 62 63 /** 64 * 类别新增视图 65 * @return 66 */ 67 @RequestMapping("/categoryinit") 68 public String categoryinit() { 69 return "categoryinit"; 70 } 71 72 /** 73 * 类别新增操作 74 * @param model 75 * @return 76 */ 77 @RequestMapping("/categoryinsert") 78 public String categoryinsert(Category model) { 79 categoryDao.save(model); 80 return "redirect:categorylist"; 81 } 82 83 /** 84 * 类别删除操作 85 * @param categoryid 86 * @return 87 */ 88 @RequestMapping("/categorydelete") 89 public String categorydelete(Integer categoryid) { 90 categoryDao.deleteById(categoryid); 91 return "redirect:categorylist"; 92 } 93 94 /** 95 * 类别编辑视图 96 * @param categoryid 97 * @return 98 */ 99 @RequestMapping("/categoryedit") 100 public ModelAndView categoryedit(Integer categoryid) { 101 Category model = categoryDao.getOne(categoryid); 102 103 ModelAndView mav = new ModelAndView("categoryedit"); 104 mav.addObject("category", model); 105 return mav; 106 } 107 108 /** 109 * 类别编辑操作 110 * @param model 111 * @return 112 */ 113 @RequestMapping("/categoryupdate") 114 public String categoryupdate(Category model) { 115 categoryDao.save(model); 116 return "redirect:categorylist"; 117 } 118 }
7、resources目录下新建templates目录,创建表现层:类别列表页面(categorylist.html)、类别新增页面(categoryinit.html)、类别编辑页面(categoryedit.html)
类别列表页面(categorylist.html)
1 <!DOCTYPE html> 2 <html lang="en"> 3 <head> 4 <meta charset="UTF-8"> 5 <title>类别列表</title> 6 <style> 7 table, th, td { 8 border: 1px solid green; 9 border-collapse: collapse; 10 } 11 </style> 12 </head> 13 <body> 14 <a th:href="@{/categoryinit}">新增</a> 15 <table> 16 <tr> 17 <th>类别编号</th> 18 <th>类别名称</th> 19 <th>操 作</th> 20 </tr> 21 <!--不分页遍历--> 22 <!--<tr th:each="item : ${list}">--> 23 <!--分页遍历--> 24 <tr th:each="item : ${page.content}"> 25 <td th:text="${item.categoryid}">类别编号</td> 26 <td th:text="${item.categoryname}">类别名称</td> 27 <td> 28 <a th:href="@{/categoryedit(categoryid=${item.categoryid})}">编辑</a> 29 <a th:href="@{/categorydelete(categoryid=${item.categoryid})}">删除</a> 30 </td> 31 </tr> 32 </table> 33 <div> 34 <a th:href="@{/categorylist(start=0)}">[首页]</a> 35 <a th:if="${not page.isFirst()}" th:href="@{/categorylist(start=${page.number-1})}">[上页]</a> 36 <a th:if="${not page.isLast()}" th:href="@{/categorylist(start=${page.number+1})}">[下页]</a> 37 <a th:href="@{/categorylist(start=${page.totalPages-1})}">[末页]</a> 38 </div> 39 </body> 40 </html>
类别新增页面(categoryinit.html)
1 <!DOCTYPE html> 2 <html lang="en"> 3 <head> 4 <meta charset="UTF-8"> 5 <title>类别新增</title> 6 </head> 7 <body> 8 <form action="categoryinsert" method="post"> 9 <label for="txtCategoryname">类别名称:</label> 10 <input type="text" id="txtCategoryname" name="categoryname" /><br/> 11 <input type="submit" value="提交"> 12 </form> 13 </body> 14 </html>
类别编辑页面(categoryedit.html)
1 <!DOCTYPE html> 2 <html lang="en"> 3 <head> 4 <meta charset="UTF-8"> 5 <title>类别编辑</title> 6 </head> 7 <body> 8 <form action="categoryupdate" method="post"> 9 <input type="hidden" id="txtCategoryid" name="categoryid" th:field="${category.categoryid}"/><br/> 10 <label for="txtCategoryname">类别名称:</label> 11 <input type="text" id="txtCategoryname" name="categoryname" th:field="${category.categoryname}"/><br/> 12 <input type="submit" value="提交"> 13 </form> 14 </body> 15 </html>
六、启动项目,运行效果如下
上一篇: 00001_Java概述
下一篇: Cocopods Search失败的坑
推荐阅读
-
【原】无脑操作:IDEA + maven + Shiro + SpringBoot + JPA + Thymeleaf实现基础认证权限
-
【原】无脑操作:IDEA + maven + SpringBoot + JPA + Thymeleaf实现CRUD及分页
-
IDEA+maven+SpringBoot+JPA+Thymeleaf实现Crud及分页
-
【原】无脑操作:IDEA + maven + Shiro + SpringBoot + JPA + Thymeleaf实现基础认证权限
-
IDEA+maven+SpringBoot+JPA+Thymeleaf实现Crud及分页
-
【原】无脑操作:IDEA + maven + SpringBoot + JPA + Thymeleaf实现CRUD及分页