效果如下
后台代码
项目结构
1. 数据库Config
由于hibernate自动建表字符集为latin不能插入中文，故需要在application.properties中指定：
spring.jpa.properties.hibernate.dialect=com.ikeguang.paging.config.MysqlConfig。
MysqlConfig.java代码：
package com.ikeguang.paging.config; import org.hibernate.dialect.MySQL5Dialect; import org.springframework.stereotype.Component; /** * @ Author: keguang * @ Date: 2019/7/16 9:58 * @ version: v1.0.0 * @ description: 解决hibernate自动建表字符集为latin不能插入中文的问题。 */ @Component @SuppressWarnings("deprecation") public class MysqlConfig extends MySQL5Dialect{ @Override public String getTableTypeString() { return "ENGINE=InnoDB DEFAULT CHARSET=utf8"; } }
2. 实体类Model
package com.ikeguang.paging.model; import javax.persistence.Column; import javax.persistence.Entity; import javax.persistence.GeneratedValue; import javax.persistence.Id; import java.io.Serializable; /** * @ Author: keguang * @ Date: 2019/6/24 20:18 * @ version: v1.0.0 * @ description: */ @Entity public class User implements Serializable{ private static final long serialVersionUID = 1L; @Id @GeneratedValue private Long id; @Column(nullable = false, unique = true) private String userName; @Column(nullable = false) private String passWord; @Column(nullable = false, unique = true) private String email; @Column(nullable = true, unique = true) private String nickName; @Column(nullable = false) private String regTime; public User(){} public User(String userName, String passWord, String email, String nickName, String regTime) { this.userName = userName; this.passWord = passWord; this.email = email; this.nickName = nickName; this.regTime = regTime; } // 省略了必须的getter、setter方法 }
3. Jpa操作数据库
UserRepository.java代码
package com.ikeguang.paging.repository; import com.ikeguang.paging.model.User; import org.springframework.data.jpa.repository.JpaRepository; /** * @ Author: keguang * @ Date: 2019/7/18 10:23 * @ version: v1.0.0 * @ description: */ public interface UserRepository extends JpaRepository<User, Long>{ User findById(long id); void deleteById(long id); }
4. service层
UserService代码
package com.ikeguang.paging.service; import com.ikeguang.paging.model.User; import org.springframework.data.domain.Page; /** * @ Author: keguang * @ Date: 2019/7/18 10:26 * @ version: v1.0.0 * @ description: */ public interface UserService { Page<User> getUserList(int pageNum, int pageSize); User findUserById(long id); void save(User user); void edit(User user); void delete(long id); }
service实现层
UserServiceImpl.java代码
package com.ikeguang.paging.service.impl; import com.ikeguang.paging.model.User; import com.ikeguang.paging.repository.UserRepository; import com.ikeguang.paging.service.UserService; 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.Service; /** * @ Author: keguang * @ Date: 2019/7/18 10:27 * @ version: v1.0.0 * @ description: */ @Service public class UserServiceImpl implements UserService { @Autowired private UserRepository userRepository; @Override public Page<User> getUserList(int pageNum, int pageSize) { Sort sort = new Sort(Sort.Direction.DESC, "id"); Pageable pageable = PageRequest.of(pageNum, pageSize, sort); Page<User> users = userRepository.findAll(pageable); return users; } @Override public User findUserById(long id) { return userRepository.findById(id); } @Override public void save(User user) { userRepository.save(user); } @Override public void edit(User user) { userRepository.save(user); } @Override public void delete(long id) { userRepository.deleteById(id); } }
5. Controller层
UserController .java代码
package com.ikeguang.paging.web; import com.ikeguang.paging.model.User; import com.ikeguang.paging.service.UserService; import org.springframework.data.domain.Page; import org.springframework.stereotype.Controller; import org.springframework.ui.Model; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RequestParam; import javax.annotation.Resource; import java.util.Iterator; /** * @ Author: keguang * @ Date: 2019/7/18 10:29 * @ version: v1.0.0 * @ description: */ @Controller public class UserController { @Resource UserService userService; @RequestMapping("/") public String index() { return "redirect:/list"; } @RequestMapping("/list") public String list(Model model, @RequestParam(value = "pageNum", defaultValue = "0") int pageNum, @RequestParam(value = "pageSize", defaultValue = "2") int pageSize) { System.out.println("============================"); Page<User> users=userService.getUserList(pageNum, pageSize); System.out.println("总页数" + users.getTotalPages()); System.out.println("当前页是：" + pageNum); System.out.println("分页数据："); Iterator<User> u = users.iterator(); while (u.hasNext()){ System.out.println(u.next().toString()); } model.addAttribute("users", users); return "user/list"; } @RequestMapping("/toAdd") public String toAdd() { return "user/userAdd"; } @RequestMapping("/add") public String add(User user) { userService.save(user); return "redirect:/list"; } @RequestMapping("/toEdit") public String toEdit(Model model,Long id) { User user=userService.findUserById(id); model.addAttribute("user", user); return "user/userEdit"; } @RequestMapping("/edit") public String edit(User user) { userService.edit(user); return "redirect:/list"; } @RequestMapping("/delete") public String delete(Long id) { userService.delete(id); return "redirect:/list"; } }
application.properties配置文件
主要配制了mysql数据源，数据库驱动com.mysql.cj.jdbc.Driver，对于mysql-connector-java用的6.0以上的，如果用com.mysql.jdbc.Driver，就会报错。
spring.datasource.url=jdbc:mysql://localhost/test?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC&useSSL=true spring.datasource.username=root spring.datasource.password=root spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver # 表不存在则新建表 spring.jpa.properties.hibernate.hbm2ddl.auto=update spring.jpa.properties.hibernate.dialect=com.ikeguang.paging.config.MysqlConfig spring.jpa.show-sql= true spring.thymeleaf.cache=false
模板文件
这里用了bootstrap.css里面的样式。这里主要展示一下分页代码，前面的table主要装一个Pageable的N条数据，接着是一个add添加数据的按钮，最下面就是分页部分，主要有5部分：首页，上一页，中间页，下一页，尾页。
<!DOCTYPE html> <html lang="en" xmlns:th="http://www.thymeleaf.org"> <head> <meta charset="UTF-8"/> <title>userList</title> <link rel="stylesheet" th:href="@{/css/bootstrap.css}"></link> </head> <body class="container"> <br/> <h1>用户列表</h1> <br/><br/> <div class="with:80%"> <table class="table table-hover"> <thead> <tr> <th>#</th> <th>userName</th> <th>passWord</th> <th>email</th> <th>nickName</th> <th>regTime</th> <th>Edit</th> <th>Delete</th> </tr> </thead> <tbody> <tr th:each="user : ${users}"> <th scope="row" th:text="${userStat.index + 1}">1</th> <td th:text="${user.userName}">neo</td> <td th:text="${user.passWord}">Otto</td> <td th:text="${user.email}">6</td> <td th:text="${user.nickName}">6</td> <td th:text="${user.regTime}">6</td> <td><a th:href="@{/toEdit(id=${user.id})}">edit</a></td> <td><a th:href="@{/delete(id=${user.id})}">delete</a></td> </tr> </tbody> </table> </div> <div class="form-group"> <div class="col-sm-2 control-label"> <a href="/toAdd" th:href="@{/toAdd}" class="btn btn-info">add</a> </div> </div> <div class="modal-footer no-margin-top"> <ul class="pagination pull-right no-margin"> <!-- 首页 --> <li> <a th:href="'/list?pageNum=0'">首页</a> </li> <!-- 上一页 --> <li th:if="${users.hasPrevious()}"> <a th:href="'/list?pageNum=' + ${users.previousPageable().getPageNumber()}" th:text="上一页"></a> </li> <!-- 中间页 --> <li th:each="pageNum:${#numbers.sequence(0, users.getTotalPages() - 1)}"> <a th:href="'/list?pageNum=' + ${pageNum}" th:text="${pageNum + 1}" th:if="${pageNum ne users.pageable.getPageNumber()}"></a> <a th:href="'/list?pageNum=' + ${pageNum}" th:text="${pageNum + 1}" th:if="${pageNum eq users.pageable.getPageNumber()}" th:style="'font-weight:bold;background: #6faed9;'"></a> </li> <!-- 下一页 --> <li th:if="${users.hasNext()}"> <a th:href="'/list?pageNum=' + ${users.nextPageable().getPageNumber()}" th:text="下一页"></a> </li> <!-- 尾页 --> <li> <a th:href="'/list?pageNum=' + ${users.getTotalPages() - 1}">尾页</a> </li> </ul> </div> </body> </html>
