4.6 基于Spring-Boot的Mysql+jpa的增删改查学习记录 > 我的程序猿之路：第三十六章

 

 

1.项目结构

      -JDK  1.8

      -SpringBoot  2.0.6

      -Thymeleaf

      -Hot Start

    

   1.1 后台（5个）

      javacomexampledemoeansuser.java                               （创建实体）

      javacomexampledemo epositoryuserRepository.java        （数据持久）

      javacomexampledemouserServiceuserService.java          （业务接口）

      javacomexampledemouserServiceuserServiceImpl.java    （接口实现）

      javacomexampledemowebHeController.java                      （表现）

  1.2  web（4个）

     resources emplatesadd.html                                                  （增加页面）

    
     以及   配置文件  目录（代码在最后面）

     resources emplatesedit.html                                                  （修改页面）

     resources emplatesindex.html                                               （首页页面）

 

 

     resources emplateslogin.html                                                （列表页面）

       数据库

    2  .代码

   1.user.java

package com.example.demo.beans;

import org.apache.catalina.User;

import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import java.io.Serializable;

@Entity
public class user implements Serializable {

    @Id
    @GeneratedValue
    private int id;
   private String name;
   private String falg;

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getFalg() {
        return falg;
    }

    public void setFalg(String falg) {
        this.falg = falg;
    }
    public user(){

    }
    public user(String name,String falg){
        super();
        this.name=name;
        this.falg=falg;
    }
}

2.userRepository.java

package com.example.demo.repository;
import com.example.demo.beans.user;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Modifying;
import org.springframework.data.jpa.repository.Query;
import org.springframework.transaction.annotation.Transactional;

import java.util.List;

public interface userRepository extends JpaRepository<user, Long> {

      public user findAllBy();
      public List<user> findAllById(Integer id);
       @Transactional
       @Modifying
       @Query("delete from user where id = ?1")
       public void deleteByCustomerId(Integer id);

}

3.userService.java

package com.example.demo.userService;

import org.springframework.beans.factory.annotation.Autowired;
import com.example.demo.beans.user;
import java.util.List;

public interface userService {

    public List<user> getUserList();
    public List<user> findUserById(Integer id);
    public void edit(user user);
    public void del(Integer id);
    public void saveUser(user user);


}

4.userServiceImpl.java

package com.example.demo.userService;

import com.example.demo.repository.userRepository;
import com.example.demo.beans.user;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import com.example.demo.userService.userService;
import java.util.List;
@Service
public class userServiceImpl implements userService {
    @Autowired
    private userRepository ur;
    @Override
    public List<user> getUserList() {
        return ur.findAll();
    }
    public List<user> findUserById(Integer id){
     //   long iss= (int)id;
        return ur.findAllById(id);
    }
    public void edit(user user){
        ur.save(user);
    }
    public void del(Integer id){
        System.out.println("This is userServiceImpl");
        ur.deleteByCustomerId(id);
    }
    public void saveUser(user user){
        ur.save(user);

    }
}

5.HeController.java

package com.example.demo.web;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestMapping;
import com.example.demo.userService.userService;
import com.example.demo.beans.user;
import org.springframework.web.bind.annotation.RequestParam;

import javax.annotation.Resource;
import javax.servlet.http.HttpServletRequest;
import java.util.List;

@Controller
@RequestMapping("index.do")
public class HeController {

   @Resource
    private userService userService;

    @RequestMapping("/index")
    public String aaa(){
        return "index";
    }
    @RequestMapping("info/login")
    public String bbb(HttpServletRequest r,Model model){
        String name_ = r.getParameter("name");
        String falg_ = r.getParameter("falg");
         List<user> users =userService.getUserList();
         for(user u:users){
             System.out.println(u.getName());
             System.out.println(u.getFalg());
         }
         model.addAttribute("users",users);
        return "login";
    }
    @RequestMapping("/toEdit/{id}")
    public String edit(Model model,@PathVariable Integer id){
        System.out.println("__"+id);
       List<user> u = userService.findUserById(id);
       user uu = new user();
       String a ="";
       String b ="";
       for(int i=0;i<u.size();i++){
           a = u.get(i).getName();
           b =  u.get(i).getFalg();
       }
       uu.setId(id);
       uu.setName(a);
       uu.setFalg(b);
       model.addAttribute("user",uu);
        return "edit";
    }
    @RequestMapping("/info/saveEd")
    public String saveEd(HttpServletRequest request){
        String id = request.getParameter("id");
        String name = request.getParameter("name");
        String falg = request.getParameter("falg");

        System.out.println("saveEd"+name+"--"+falg);
        user u = new user();
        u.setId(Integer.parseInt(id));
        u.setName(name);
        u.setFalg(falg);
        userService.edit(u);
        return "redirect:/index.do/info/login";
    }
    @RequestMapping("/toDel/{id}")
    public String del(@PathVariable("id") Integer id){
        System.out.println(id+"--id");
        userService.del(id);
        return "redirect:/index.do/info/login";
    }
    @RequestMapping("info/insert")
    public String insert(){
        System.out.println("insert");
        return "add";
    }
    @RequestMapping("/toAdd")
    public String add(HttpServletRequest request){
        System.out.println("--add");
        String name = request.getParameter("name");
        String falg = request.getParameter("falg");
        user u = new user();
        u.setName(name);
        u.setFalg(falg);
        userService.saveUser(u);
        return "redirect:/index.do/info/login";
    }
}

6.add.html

<!DOCTYPE html>
<html xmlns:th="http://www.thymeleaf.org">
<head>
    <meta charset="UTF-8">
    <title>Spring-boot-add</title>
</head>
<body>
<form action="/index.do/toAdd" method="post">
    <table>
        <tr>
            <td>name:<input type="text"  name="name"></td>
        </tr>
        <tr>
            <td>falg:<input type="text" name="falg"></td>
        </tr>
        <tr>
            <td><input type="submit" value="submit"></td>
        </tr>
    </table>
</form>
</body>
</html>

7.edit.html

<!DOCTYPE html>
<html xmlns:th="http://www.thymeleaf.org">
<head>
    <meta charset="UTF-8">
    <title>Spring-boot-edit</title>
</head>
<body>
<form th:action="@{/index.do/info/saveEd}" method="post">
    <table>
        <tr >

            <td><input type="text" th:value="${user.name }" th:name="name"><input type="hidden" th:value="${user.id}" th:name="id"> </td>
        </tr>
        <tr>
            <td><input type="text" th:value="${user.falg }" th:name="falg"></td>
        </tr>
        <tr>
            <td><input  value="修改" type="submit"/></td>
        </tr>
    </table>

</form>
</body>
</html>

8.index.html

<!DOCTYPE html>
<html xmlns:th="http://www.thymeleaf.org">
<head>
    <meta charset="UTF-8">
    <title>Spring-Boot-Web-index</title>
</head>
<body>
<a href="/index.do/info/login">进入</a>
</body>
</html>

9.login.html

<!DOCTYPE html>
<html xmlns:th="http://www.thymeleaf.org">
<head>
    <meta charset="UTF-8">
    <title>Spring-boot-login</title>
    <link rel="stylesheet" th:href="@{/css/bootstrap.css}"></link>
</head>
<script>

</script>
<body>
<div class="with:80%">
    <table class="table table-hover">
        <tr><td><a href="/index.do/info/insert" >add</a></td></tr>
        <tr>
            <th>id</th>
            <th>User Name</th>
            <th>Password</th>
            <th>edit</th>
            <th>delete</th>
        </tr>

        <tbody>
        <tr th:each="u : ${users}">
             <td th:text="${u.id}"></td>
            <td th:text="${u.name }"></td>
            <td th:text="${u.falg }">u.falg</td>
           <td><a th:href="@{'/index.do/toEdit/'+${u.id}}">edit</a></td>
            <td><a th:href="@{'/index.do/toDel/'+${u.id}}">delete</a></td>
        </tr>
        </tbody>
    </table>
</div>
</body>
</html>

10.pom.xml

<?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>demo</artifactId>
    <version>0.0.1-SNAPSHOT</version>
    <packaging>jar</packaging>

    <name>demo</name>
    <description>Demo project for Spring Boot</description>

    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>2.0.6.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>
        <!-- set thymeleaf version -->
        <thymeleaf.version>3.0.9.RELEASE</thymeleaf.version>
        <thymeleaf-layout-dialect.version>2.2.2</thymeleaf-layout-dialect.version>
    </properties>


    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter</artifactId>
        </dependency>
      <!--  添加支持web的模块 -->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <!--spring boot tomcat（默认可以不用配置，但当需要把当前web应用布置到外部servlet容器时就需要配置，并将scope配置为provided）-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-tomcat</artifactId>
            <scope>provided</scope>
        </dependency>
        <!--  pom.xml文件中默认有两个模块： -->
        <!--  spring-boot-starter：核心模块，包括自动配置支持、日志和YAML； -->
        <!--  spring-boot-starter-test：测试模块，包括JUnit、Hamcrest、Mockito。 -->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>
        <!--   SpringBoot中使用Thymeleaf模板   -->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-thymeleaf</artifactId>
        </dependency>
        <!--   启动项目热部署  -->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-devtools</artifactId>
            <optional>true</optional>
        </dependency>
        <!-- Hibername 的 spring data jpa -->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-data-jpa</artifactId>
        </dependency>
        <!-- mysql数据库 -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>
    </dependencies>

    <build>
        <plugins>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
                <configuration><fork>true</fork></configuration>
            </plugin>
        </plugins>
    </build>


</project>

11.application.properties

#缓存关闭
spring.thymeleaf.cache=false
#识别templates/下的文件
spring.thymeleaf.prefix=classpath:/templates/
# 热部署开关，false即不启用热部署
spring.devtools.restart.enabled: true
#   Mysql 数据库配置   bigen
spring.datasource.url=jdbc:mysql://localhost:3306/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.jdbc.Driver
#  Mysql 数据库配置   end
#  hibernate 的jpa  bigen
spring.jpa.properties.hibernate.hbm2ddl.auto=update
spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect
spring.jpa.show-sql= true
#  hibernate 的jpa  end

                                                                           

                                                                                                             能力有限，有许多不足，以上内容仅供参考  

  参考大神网站（纯洁的微笑）：http://www.ityouknow.com/springboot/2016/08/20/spring-boo-jpa.html

                                                   http://www.ityouknow.com/springboot/2016/02/03/spring-boot-web.html

                                                   http://www.ityouknow.com/springboot/2016/05/01/spring-boot-thymeleaf.html