• Spring Data JDBC结合MyBatis、MySQL 和 Thymeleaf 实现分页、排序和全字段LIKE过滤/搜索功能

        在本教程中，您将学习使用 Spring Data JDBC结合MyBatis、MySQL 和 Thymeleaf 为现有 Spring Boot 应用程序实现分页、排序和过滤/搜索功能。

     

     

    pom.xml

    1. "1.0" encoding="UTF-8"?>
    2. <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 https://maven.apache.org/xsd/maven-4.0.0.xsd">
    3.     <modelVersion>4.0.0modelVersion>
    4.     <parent>
    5.         <groupId>org.springframework.bootgroupId>
    6.         <artifactId>spring-boot-starter-parentartifactId>
    7.         <version>2.7.4version>
    8.         <relativePath/> 
    9.     parent>
    10.     <groupId>net.codejavagroupId>
    11.     <artifactId>ProductManagerSpringDataJdbcMyBatisartifactId>
    12.     <version>0.0.1-SNAPSHOTversion>
    13.     <name>ProductManagerSpringDataJdbcMyBatisname>
    14.     <description>Spring Boot Web Appdescription>
    15.  
    16.     <properties>
    17.         <java.version>17java.version>
    18.     properties>
    19.  
    20.     <dependencies>
    21.         <dependency>
    22.             <groupId>org.springframework.bootgroupId>
    23.             <artifactId>spring-boot-starter-data-jdbcartifactId>
    24.         dependency>
    25.         <dependency>
    26.             <groupId>org.springframework.bootgroupId>
    27.             <artifactId>spring-boot-starter-thymeleafartifactId>
    28.         dependency>
    29.         <dependency>
    30.             <groupId>org.springframework.bootgroupId>
    31.             <artifactId>spring-boot-starter-webartifactId>
    32.         dependency>
    33.  
    34.         <dependency>
    35.             <groupId>org.springframework.bootgroupId>
    36.             <artifactId>spring-boot-starter-testartifactId>
    37.             <scope>testscope>
    38.         dependency>
    39.  
    40.         <dependency>
    41.             <groupId>mysqlgroupId>
    42.             <artifactId>mysql-connector-javaartifactId>
    43.             <scope>runtimescope>
    44.         dependency>
    45.  
    46.         <dependency>
    47.             <groupId>org.springframework.bootgroupId>
    48.             <artifactId>spring-boot-devtoolsartifactId>
    49.             
    50.         dependency>
    51.         <dependency>
    52.             <groupId>org.projectlombokgroupId>
    53.             <artifactId>lombokartifactId>
    54.         dependency>
    55.         <dependency>
    56.             <groupId>org.mybatis.spring.bootgroupId>
    57.             <artifactId>mybatis-spring-boot-starterartifactId>
    58.             <version>2.2.2version>
    59.         dependency>
    60.         <dependency>
    61.             <groupId>org.mybatis.generatorgroupId>
    62.             <artifactId>mybatis-generator-coreartifactId>
    63.             <version>1.4.1version>
    64.         dependency>
    65.     dependencies>
    66.  
    67.     <build>
    68.         <plugins>
    69.             <plugin>
    70.                 <groupId>org.springframework.bootgroupId>
    71.                 <artifactId>spring-boot-maven-pluginartifactId>
    72.             plugin>
    73.         plugins>
    74.     build>
    75.  
    76. project>

    application.properties

    1. spring.jpa.hibernate.ddl-auto=none
    2. spring.datasource.url=jdbc:mysql://localhost:3306/sales?autoReconnect=true&useSSL=false&useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai
    3. spring.datasource.username=root
    4. spring.datasource.password=root
    5. #logging.level.root=
    6. #debug=true
    7. logging.level.org.springframework.jdbc.core.JdbcTemplate=DEBUG
    8.  
    9. logging.level.net.codejava=DEBUG
    10.

    ProductManagerApplication.java

    1. package net.codejava;
    2.  
    3. import org.apache.ibatis.type.MappedTypes;
    4. import org.mybatis.spring.annotation.MapperScan;
    5. import org.springframework.boot.SpringApplication;
    6. import org.springframework.boot.autoconfigure.SpringBootApplication;
    7.  
    8. @MappedTypes(Product.class)
    9. @MapperScan("net.codejava")
    10. @SpringBootApplication
    11. public class ProductManagerApplication {
    12.  
    13.     public static void main(String[] args) {
    14.         SpringApplication.run(ProductManagerApplication.class, args);
    15.     }
    16.  
    17. }

    Product.java

    1. package net.codejava;
    2.  
    3. import org.springframework.data.annotation.Id;
    4. import org.springframework.data.relational.core.mapping.Column;
    5. import org.springframework.data.relational.core.mapping.Table;
    6.  
    7. import lombok.Data;
    8.  
    9. @Table("product")
    10. @Data // lomok
    11. public class Product {
    12.  
    13.     @Id
    14.     private Long id;
    15.     private String name;
    16.     private String brand;
    17.     private String madein;
    18.     private float price;
    19.  
    20.     protected Product() {
    21.     }
    22.  
    23.     public Long getId() {
    24.         return id;
    25.     }
    26.  
    27.     public void setId(Long id) {
    28.         this.id = id;
    29.     }
    30.  
    31.     public String getName() {
    32.         return name;
    33.     }
    34.  
    35.     public void setName(String name) {
    36.         this.name = name;
    37.     }
    38.  
    39.     public String getBrand() {
    40.         return brand;
    41.     }
    42.  
    43.     public void setBrand(String brand) {
    44.         this.brand = brand;
    45.     }
    46.  
    47.     public String getMadein() {
    48.         return madein;
    49.     }
    50.  
    51.     public void setMadein(String madein) {
    52.         this.madein = madein;
    53.     }
    54.  
    55.     public float getPrice() {
    56.         return price;
    57.     }
    58.  
    59.     public void setPrice(float price) {
    60.         this.price = price;
    61.     }
    62.  
    63. }

    ProductRepository.java

    1. package net.codejava;
    2.  
    3. import org.springframework.data.domain.Page;
    4. import org.springframework.data.domain.Pageable;
    5. import org.springframework.data.repository.PagingAndSortingRepository;
    6. import org.springframework.stereotype.Repository;
    7.  
    8. @Repository
    9.  
    10. public interface ProductRepository extends PagingAndSortingRepository, ProductRepositoryCustom {
    11.  
    12.     Page findAllByNameContaining(String name, Pageable pageable);
    13.  
    14.     Page findAllByNameLikeOrBrandLikeOrMadeinLike(String name, String brand, String madein, Pageable pageable);
    15. }

    ProductRepositoryCustom.java

    1. package net.codejava;
    2.  
    3. import org.springframework.data.domain.Page;
    4. import org.springframework.data.domain.Pageable;
    5.  
    6. public interface ProductRepositoryCustom {
    7.  
    8.     public Page findAllByContaining(String keyword, Pageable page);
    9. }

    ProductMapper.java

    1. package net.codejava;
    2.  
    3. import java.util.List;
    4. import org.apache.ibatis.annotations.Delete;
    5. import org.apache.ibatis.annotations.Insert;
    6. import org.apache.ibatis.annotations.Param;
    7. import org.apache.ibatis.annotations.Result;
    8. import org.apache.ibatis.annotations.Results;
    9. import org.apache.ibatis.annotations.Select;
    10. import org.apache.ibatis.annotations.SelectKey;
    11. import org.apache.ibatis.annotations.Update;
    12. import org.apache.ibatis.type.JdbcType;
    13.  
    14. public interface ProductMapper {
    15.  
    16.     @Select("select count(*) from product WHERE CONCAT(id, ' ', name, ' ' , brand, ' ' , madein, ' ' , price) LIKE CONCAT('%',#{keyword},'%')  ")
    17.     int listAllSortPageContainingCount(@Param("keyword") String keyword);
    18.  
    19.     @Select("select * from product WHERE CONCAT(id, ' ', name, ' ' , brand, ' ' , madein, ' ' , price) LIKE CONCAT('%',#{keyword},'%')  order by ${sortField}  ${sortDir} LIMIT ${pageSize} OFFSET ${pageOffset}")
    20.     List listAllSortPageContaining(@Param("keyword") String keyword, @Param("sortField") String sortField, @Param("sortDir") String sortDir, @Param("pageSize") Integer pageSize, @Param("pageOffset") Long pageOffset);
    21.  
    22.     /**
    23.      * This method was generated by MyBatis Generator. This method corresponds
    24.      * to the database table product
    25.      *
    26.      * @mbg.generated Mon Oct 31 06:50:01 CST 2022
    27.      */
    28.     @Delete({
    29.         "delete from product",
    30.         "where id = #{id,jdbcType=INTEGER}"
    31.     })
    32.     int deleteByPrimaryKey(Integer id);
    33.  
    34.     /**
    35.      * This method was generated by MyBatis Generator. This method corresponds
    36.      * to the database table product
    37.      *
    38.      * @mbg.generated Mon Oct 31 06:50:01 CST 2022
    39.      */
    40.     @Insert({
    41.         "insert into product (name, brand, ",
    42.         "madein, price)",
    43.         "values (#{name,jdbcType=VARCHAR}, #{brand,jdbcType=VARCHAR}, ",
    44.         "#{madein,jdbcType=VARCHAR}, #{price,jdbcType=REAL})"
    45.     })
    46.     @SelectKey(statement = "SELECT LAST_INSERT_ID()", keyProperty = "id", before = false, resultType = Integer.class)
    47.     int insert(Product row);
    48.  
    49.     /**
    50.      * This method was generated by MyBatis Generator. This method corresponds
    51.      * to the database table product
    52.      *
    53.      * @mbg.generated Mon Oct 31 06:50:01 CST 2022
    54.      */
    55.     @Select({
    56.         "select",
    57.         "id, name, brand, madein, price",
    58.         "from product",
    59.         "where id = #{id,jdbcType=INTEGER}"
    60.     })
    61.     @Results({
    62.         @Result(column = "id", property = "id", jdbcType = JdbcType.INTEGER, id = true),
    63.         @Result(column = "name", property = "name", jdbcType = JdbcType.VARCHAR),
    64.         @Result(column = "brand", property = "brand", jdbcType = JdbcType.VARCHAR),
    65.         @Result(column = "madein", property = "madein", jdbcType = JdbcType.VARCHAR),
    66.         @Result(column = "price", property = "price", jdbcType = JdbcType.REAL)
    67.     })
    68.     Product selectByPrimaryKey(Integer id);
    69.  
    70.     /**
    71.      * This method was generated by MyBatis Generator. This method corresponds
    72.      * to the database table product
    73.      *
    74.      * @mbg.generated Mon Oct 31 06:50:01 CST 2022
    75.      */
    76.     @Select({
    77.         "select",
    78.         "id, name, brand, madein, price",
    79.         "from product"
    80.     })
    81.     @Results({
    82.         @Result(column = "id", property = "id", jdbcType = JdbcType.INTEGER, id = true),
    83.         @Result(column = "name", property = "name", jdbcType = JdbcType.VARCHAR),
    84.         @Result(column = "brand", property = "brand", jdbcType = JdbcType.VARCHAR),
    85.         @Result(column = "madein", property = "madein", jdbcType = JdbcType.VARCHAR),
    86.         @Result(column = "price", property = "price", jdbcType = JdbcType.REAL)
    87.     })
    88.     List selectAll();
    89.  
    90.     /**
    91.      * This method was generated by MyBatis Generator. This method corresponds
    92.      * to the database table product
    93.      *
    94.      * @mbg.generated Mon Oct 31 06:50:01 CST 2022
    95.      */
    96.     @Update({
    97.         "update product",
    98.         "set name = #{name,jdbcType=VARCHAR},",
    99.         "brand = #{brand,jdbcType=VARCHAR},",
    100.         "madein = #{madein,jdbcType=VARCHAR},",
    101.         "price = #{price,jdbcType=REAL}",
    102.         "where id = #{id,jdbcType=INTEGER}"
    103.     })
    104.     int updateByPrimaryKey(Product row);
    105. }

    ProductRepositoryImpl.java

    1. package net.codejava;
    2.  
    3. import java.util.List;
    4. import org.springframework.beans.factory.annotation.Autowired;
    5. import org.springframework.data.domain.Page;
    6. import org.springframework.data.domain.PageImpl;
    7. import org.springframework.data.domain.Pageable;
    8. import org.springframework.data.domain.Sort;
    9.  
    10. public class ProductRepositoryImpl implements ProductRepositoryCustom {
    11.  
    12.     @Autowired
    13.     private ProductMapper productMapper;
    14.  
    15. //    public ProductRepositoryImpl(ProductMapper productMapper) {
    16. //        this.productMapper = productMapper;
    17. //    }
    18.     @Override
    19.     public Page findAllByContaining(String keyword, Pageable page) {
    20.  
    21. //        int count = jdbcTemplate.queryForObject("SELECT count(* ) FROM product WHERE CONCAT(id, ' ', name, ' ' , brand, ' ' , madein, ' ' , price) LIKE CONCAT('%',?,'%') ", Integer.class, keyword);
    22.         int count = productMapper.listAllSortPageContainingCount(keyword);
    23.         Sort.Order order = !page.getSort().isEmpty() ? page.getSort().toList().get(0) : Sort.Order.by("ID");
    24.  
    25. //        List products = jdbcTemplate.query("SELECT * FROM product WHERE CONCAT(id, ' ', name, ' ' , brand, ' ' , madein, ' ' , price) LIKE CONCAT('%',?,'%') ORDER BY " + order.getProperty() + " "
    26. //                + order.getDirection().name() + " LIMIT " + page.getPageSize() + " OFFSET " + page.getOffset(),
    27. //                (rs, rowNum) -> mapUserResult(rs), keyword
    28. //        );
    29.         List products = productMapper.listAllSortPageContaining(keyword, order.getProperty(), order.getDirection().name(), page.getPageSize(), page.getOffset());
    30.         return new PageImpl(products, page, count);
    31.     }
    32.  
    33. }

    ProductService.java

    1. package net.codejava;
    2.  
    3. import org.springframework.beans.factory.annotation.Autowired;
    4. import org.springframework.data.domain.Page;
    5. import org.springframework.data.domain.PageRequest;
    6. import org.springframework.data.domain.Pageable;
    7. import org.springframework.data.domain.Sort;
    8. import org.springframework.stereotype.Service;
    9.  
    10. @Service
    11. public class ProductService {
    12.  
    13.     @Autowired
    14.     private ProductRepository repo;
    15.  
    16.     public Page listAll(int pageNumber, String sortField, String sortDir, String keyword) {
    17.  
    18.         Sort sort = Sort.by(sortField);
    19.         sort = sortDir.equals("asc") ? sort.ascending() : sort.descending();
    20.  
    21.         Pageable pageable = PageRequest.of(pageNumber - 1, 7, sort); // 7 rows per page
    22.  
    23.         if (keyword != null) {
    24.             return repo.findAllByContaining(keyword, pageable);
    25.         }
    26.         return repo.findAll(pageable);
    27.     }
    28.  
    29.     public void save(Product product) {
    30.         repo.save(product);
    31.     }
    32.  
    33.     public Product get(Long id) {
    34.         return repo.findById(id).get();
    35.     }
    36.  
    37.     public void delete(Long id) {
    38.         repo.deleteById(id);
    39.     }
    40. }

    AppController.java

    1. package net.codejava;
    2.  
    3. import org.springframework.beans.factory.annotation.Autowired;
    4. import org.springframework.data.domain.Page;
    5. import org.springframework.data.repository.query.Param;
    6. import org.springframework.stereotype.Controller;
    7. import org.springframework.ui.Model;
    8. import org.springframework.web.bind.annotation.GetMapping;
    9. import org.springframework.web.bind.annotation.ModelAttribute;
    10. import org.springframework.web.bind.annotation.PathVariable;
    11. import org.springframework.web.bind.annotation.RequestMapping;
    12. import org.springframework.web.bind.annotation.RequestMethod;
    13. import org.springframework.web.servlet.ModelAndView;
    14.  
    15. import java.util.List;
    16.  
    17. @Controller
    18. public class AppController {
    19.  
    20. 	@Autowired
    21. 	private ProductService service;
    22.  
    23. 	@RequestMapping("/")
    24. 	public String viewHomePage(Model model) {
    25. 		// String keyword = "reebok";
    26. 		String keyword = null;
    27.  
    28. 		/*
    29. 		 * if (keyword != null) { return listByPage(model, 1, "name", "asc", keyword); }
    30. 		 */
    31. 		return listByPage(model, 1, "name", "asc", keyword);
    32.  
    33. 	}
    34.  
    35. 	@GetMapping("/page/{pageNumber}")
    36. 	public String listByPage(Model model, @PathVariable("pageNumber") int currentPage,
    37. 			@Param("sortField") String sortField, @Param("sortDir") String sortDir, @Param("keyword") String keyword) {
    38.  
    39. 		Page page = service.listAll(currentPage, sortField, sortDir, keyword);
    40.  
    41. 		long totalItems = page.getTotalElements();
    42. 		int totalPages = page.getTotalPages();
    43. 		// int currentPage = page.previousPageable().getPageNumber();
    44.  
    45. 		List listProducts = page.getContent();
    46.  
    47. 		model.addAttribute("totalItems", totalItems);
    48. 		model.addAttribute("totalPages", totalPages);
    49. 		model.addAttribute("currentPage", currentPage);
    50. 		model.addAttribute("listProducts", listProducts); // next bc of thymeleaf we make the index.html
    51.  
    52. 		model.addAttribute("sortField", sortField);
    53. 		model.addAttribute("sortDir", sortDir);
    54. 		model.addAttribute("keyword", keyword);
    55.  
    56. 		String reverseSortDir = sortDir.equals("asc") ? "desc" : "asc";
    57. 		model.addAttribute("reverseSortDir", reverseSortDir);
    58.  
    59. 		return "index";
    60. 	}
    61.  
    62. 	@RequestMapping("/new")
    63. 	public String showNewProductForm(Model model) {
    64. 		Product product = new Product();
    65. 		model.addAttribute("product", product);
    66.  
    67. 		return "new_product";
    68. 	}
    69.  
    70. 	@RequestMapping(value = "/save", method = RequestMethod.POST)
    71. 	public String saveProduct(@ModelAttribute("product") Product product) {
    72. 		service.save(product);
    73.  
    74. 		return "redirect:/";
    75. 	}
    76.  
    77. 	@RequestMapping("/edit/{id}")
    78. 	public ModelAndView showEditProductForm(@PathVariable(name = "id") Long id) {
    79. 		ModelAndView modelAndView = new ModelAndView("edit_product");
    80. 		Product product = service.get(id);
    81. 		modelAndView.addObject("product", product);
    82.  
    83. 		return modelAndView;
    84. 	}
    85.  
    86. 	@RequestMapping("/delete/{id}")
    87. 	public String deleteProduct(@PathVariable(name = "id") Long id) {
    88. 		service.delete(id);
    89.  
    90. 		return "redirect:/";
    91. 	}
    92.  
    93. }

    index.html

    2.  
    3. html>
    4. <html xmlns="http://www.w3.org/1999/xhtml"
    5.       xmlns:th="http://www.thymeleaf.org">
    6.     <head>
    7.         <meta charset="utf-8" />
    8.         <title>Product Managertitle>
    9.     head>
    10.  
    11.     <body>
    12.         <div align="center">
    13.             <div>
    14.                 <h1>Product Managerh1>
    15.                 <a href="/new">Create New Producta> <br />
    16.                 <br />
    17.             div>
    18.  
    19.             <div>
    20.                 <form th:action="@{/page/1}">
    21.                     <input type="hidden" name="sortField" th:value="${sortField}" /> <input
    22.                         type="hidden" name="sortDir" th:value="${sortDir}" /> Name Filter: <input
    23.                         type="text" name="keyword" size="50" th:value="${keyword}" required />
    24.                       <input type="submit" value="Search" />   <input
    25.                         type="button" value="Clear" id="btnClear" onclick="clearSearch()" />
    26.                 form>
    27.             div>
    28.  
    29.             <div> div>
    30.  
    31.             <div>
    32.                 <table border="1" cellpadding="10">
    33.                     <thead>
    34.                         <tr>
    35.                             <th><a
    36.                                     th:href="@{'/page/' + ${currentPage} + '?sortField=id&sortDir=' + ${reverseSortDir} + ${keyword != null ? '&keyword=' + keyword : ''}}">
    37.                                     Product IDa>
    38.                             th>
    39.                             <th><a
    40.                                     th:href="@{'/page/' + ${currentPage} + '?sortField=name&sortDir=' + ${reverseSortDir} + ${keyword != null ? '&keyword=' + keyword : ''}}">
    41.                                     Namea>
    42.                             th>
    43.                             <th><a
    44.                                     th:href="@{'/page/' + ${currentPage} + '?sortField=brand&sortDir=' + ${reverseSortDir} + ${keyword != null ? '&keyword=' + keyword : ''}}">
    45.                                     Branda>
    46.                             th>
    47.                             <th><a
    48.                                     th:href="@{'/page/' + ${currentPage} + '?sortField=madein&sortDir=' + ${reverseSortDir} + ${keyword != null ? '&keyword=' + keyword : ''}}">
    49.                                     Made Ina>
    50.                             th>
    51.                             <th><a
    52.                                     th:href="@{'/page/' + ${currentPage} + '?sortField=id&sortDir=' + ${reverseSortDir} + ${keyword != null ? '&keyword=' + keyword : ''}}">
    53.                                     Pricea>
    54.                             th>
    55.                             <th><a>Actionsa>th>
    56.                         tr>
    57.                     thead>
    58.                     <tbody>
    59.                         <tr th:each="product : ${listProducts}">
    60.                             <td th:text="${product.id}">Product IDtd>
    61.                             <td th:text="${product.name}">Nametd>
    62.                             <td th:text="${product.brand}">Brandtd>
    63.                             <td th:text="${product.madein}">Made intd>
    64.                             <td th:text="${product.price}">Pricetd>
    65.                             <td><a th:href="@{'/edit/' + ${product.id}}">Edita>
    66.                                     <a th:href="@{'/delete/' + ${product.id}}">Deletea>
    67.                             td>
    68.                         tr>
    69.                     tbody>
    70.                 table>
    71.             div>
    72.  
    73.             <div>   div>
    74.  
    75.             <div>
    76.                 Total items: [[${totalItems}]] - Page [[${currentPage}]] of
    77.                 [[${totalPages}]]     <a th:if="${currentPage > 1}"
    78.                                                    th:href="@{'/page/1?sortField=' + ${sortField} + '&sortDir=' + ${sortDir} + ${keyword != null ? '&keyword=' + keyword : ''}}">Firsta>
    79.                 <span th:unless="${currentPage > 1}">Firstspan>    <a
    80.                     th:if="${currentPage > 1}"
    81.                     th:href="@{'/page/' + ${currentPage - 1} + '?sortField=' + ${sortField} + '&sortDir=' + ${sortDir} + ${keyword != null ? '&keyword=' + keyword : ''}}">Previousa>
    82.                 <span th:unless="${currentPage > 1}">Previousspan>    <span
    83.                     th:each="i: ${#numbers.sequence(1, totalPages)}"> <a
    84.                         th:if="${i != currentPage}"
    85.                         th:href="@{'/page/' + ${i}} + '?sortField=' + ${sortField} + '&sortDir=' + ${sortDir} + ${keyword != null ? '&keyword=' + keyword : ''}">[[${i}]]a>
    86.                         <span th:unless="${i != currentPage}">[[${i}]]span>
    87.                        
    88.                 span> <a th:if="${currentPage < totalPages}"
    89.                            th:href="@{'/page/' + ${currentPage + 1} + '?sortField=' + ${sortField} + '&sortDir=' + ${sortDir} + ${keyword != null ? '&keyword=' + keyword : ''}}">Nexta>
    90.                 <span th:unless="${currentPage < totalPages}">Nextspan>
    91.                    <a th:if="${currentPage < totalPages}"
    92.                                 th:href="@{'/page/' + ${totalPages} + '?sortField=' + ${sortField} + '&sortDir=' + ${sortDir} + ${keyword != null ? '&keyword=' + keyword : ''}}">Lasta>
    93.                 <span th:unless="${currentPage < totalPages}">Lastspan>
    94.                   
    95.  
    96.             div>
    97.             <script type="text/javascript">
    98.                 function clearSearch() {
    99.                     window.location = "/";
    100.                 }
    101.             script>
    102.         div>
    103.     body>
    104. html>

    new_product.html

    1. html>
    2. <html xmlns="http://www.w3.org/1999/xhtml"
    3. 	xmlns:th="http://www.thymeleaf.org">
    4. <head>
    5. <meta charset="ISO-8859-1">
    6. <title>Create new producttitle>
    7. head>
    8. <body>
    9. 	<div align="center">
    10. 		<h1>Create new producth1>
    11. 		<br />
    12. 		<form action="#" th:action="@{/save}" th:object="${product}"
    13. 			method="post">
    14.  
    15. 			<table border="0" cellpadding="10">
    16. 				<tr>
    17. 					<td>Product Name:td>
    18. 					<td><input type="text" th:field="*{name}" />td>
    19. 				tr>
    20. 				<tr>
    21. 					<td>Brandtd>
    22. 					<td><input type="text" th:field="*{brand}" />td>
    23. 				tr>
    24. 				<tr>
    25. 					<td>Made in:td>
    26. 					<td><input type="text" th:field="*{madein}" />td>
    27. 				tr>
    28. 				<tr>
    29. 					<td>Price:td>
    30. 					<td><input type="text" th:field="*{price}" />td>
    31. 				tr>
    32. 				<tr>
    33. 					<td colspan="2"><button type="submit">Savebutton>td>
    34. 				tr>
    35.  
    36. 			table>
    37. 		form>
    38.  
    39. 	div>
    40. body>
    41. html>

    edit_product.html

    1. html>
    2. <html xmlns="http://www.w3.org/1999/xhtml"
    3. 	xmlns:th="http://www.thymeleaf.org">
    4. <head>
    5. <meta charset="ISO-8859-1">
    6. <title>Edit producttitle>
    7. head>
    8. <body>
    9. 	<div align="center">
    10. 		<h1>Edit producth1>
    11. 		<br />
    12. 		<form action="#" th:action="@{/save}" th:object="${product}"
    13. 			method="post">
    14. 			<table border="0" cellpadding="10">
    15. 				<tr>
    16. 					<td>Product ID:td>
    17. 					<td><input type="text" th:field="*{id}" readonly="readonly" />
    18. 					td>
    19. 				tr>
    20. 				<tr>
    21. 					<td>Product Name:td>
    22. 					<td><input type="text" th:field="*{name}" />td>
    23. 				tr>
    24. 				<tr>
    25. 					<td>Brandtd>
    26. 					<td><input type="text" th:field="*{brand}" />td>
    27. 				tr>
    28. 				<tr>
    29. 					<td>Made in:td>
    30. 					<td><input type="text" th:field="*{madein}" />td>
    31. 				tr>
    32. 				<tr>
    33. 					<td>Price:td>
    34. 					<td><input type="text" th:field="*{price}" />td>
    35. 				tr>
    36. 				<tr>
    37. 					<td colspan="2"><button type="submit">Savebutton>td>
    38. 				tr>
    39.  
    40. 			table>
    41. 		form>
    42.  
    43. 	div>
    44. body>
    45. html>

    下载：GitHub - allwaysoft/ProductManagerSpringDataJdbcMyBatis

    MyBatis同时使用注解和XML下载：GitHub - allwaysoft/ProductManagerSpringBootMyBatisAnnotationXml

  • 相关阅读:
    Web前端vueDemo—实现图片切换功能（二）
    中证1000期指上市带来的交易机会
    堆相关例子-排序最多移动k距离
    面试题 Android 如何实现自定义View 固定帧率绘制
    空间复杂度(Space Complexity)
    一个简单好用的localstorage组件store
    嵌入式C语言设计模式 --- 前言
    react合成事件——bind解决this指向——箭头函数解决this指向
    肖sir___面试就业课__非技术面试题
    33python数据分析numpy基础之union1d求数组并集
  • 原文地址：https://blog.csdn.net/allway2/article/details/127608291