SpringBoot（四）：连接MySQL，JPA操作

拼搏现实的明天。 2022-03-25 16:10 157阅读 0赞

pom.xml:

<dependencies>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-data-jpa</artifactId>
            </dependency>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-web</artifactId>
            </dependency>
    
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <scope>runtime</scope>
            </dependency>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-test</artifactId>
                <scope>test</scope>
            </dependency>
        </dependencies>

application.properties

spring.datasource.url=jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=UTF-8
    spring.datasource.username=root
    spring.datasource.password=
    spring.datasource.driver-class-name=com.mysql.jdbc.Driver
    
    spring.jpa.hibernate.ddl-auto=update
    spring.jpa.show-sql=true

实体类：

@Entity  
    public class Person  {  
      
        @Id  
        @GeneratedValue  
        private Long id;  
          
        private String name;  
          
        private Integer age;  
          
        private String address;  
      
        public Person() {  
            super();  
        }  
      
        public Person(Long id, String name, Integer age, String address) {  
            super();  
            this.id = id;  
            this.name = name;  
            this.age = age;  
            this.address = address;  
        }  
      
        public Long getId() {  
            return id;  
        }  
      
        public void setId(Long id) {  
            this.id = id;  
        }  
      
        public String getName() {  
            return name;  
        }  
      
        public void setName(String name) {  
            this.name = name;  
        }  
      
        public Integer getAge() {  
            return age;  
        }  
      
        public void setAge(Integer age) {  
            this.age = age;  
        }  
      
        public String getAddress() {  
            return address;  
        }  
      
        public void setAddress(String address) {  
            this.address = address;  
        }  
          
    }

Dao类：

@Repository  
    public interface PersonRepository extends JpaRepository<Person,Long> {  
      
        List<Person> findByName(String name);  
          
        List<Person> findByAddress(String address);  
          
        List<Person> findByNameAndAddress(String name,String address);  
          
        @Query("select p from Person p where p.name=:name and p.address=:address")  
        List<Person> withNameAndAddressQuery(@Param("name")String Name,@Param("address")String address);  
    }

controller：

@RestController
    @SpringBootApplication
    public class SpringBootSampleMysqlApplication {
    
        @Autowired
        PersonRepository dao;
    
        @RequestMapping("/get")
        public Person getP(String name){
            Person person = dao.findByName(name).get(0);
            return person;
        }
    
        @RequestMapping("/getByAddress")
        public List<Person> getByAddress(String address){
            List<Person> list = dao.findByAddress(address);
            return list;
        }
    
        public static void main(String[] args) {
            SpringApplication.run(SpringBootSampleMysqlApplication.class, args);
        }
    }

测试：

![11636334-301b7616a7bfd079][]

image

[11636334-301b7616a7bfd079]: /images/20220325/e7dd38d80a4a4600b2b2017df9ba3682.png