Spring Data JPA学习笔记

港控/mmm° 2022-11-26 07:51 172阅读 0赞

# 1.接口方法解析 #

## 1.1CureRepository接口 ##

save(entity):添加一条数据
    save(entities)：添加多条数据entities为集合
    findOne(id)：根据id查询一条数据
    exists(id)：判断id是否存在
    findAll()：查询全部数据
    delete(id)：根据id删除数据
    delete(entity)：根据一条数据的信息删除数据
    delete(entities)：根据多条数据的信息删除数据
    deleteAll()：删除全部信息

## 1.2PagingAndSortingRpository接口 ##

Iterable findAll()  //排序
     Page findAll(Pageable pageable)  //分页查询，包含排序

# 2.测试自定义以及接口方法 #

## 2.1创建userDao接口 ##

import org.springframework.data.jpa.repository.Query;
    import org.springframework.data.repository.PagingAndSortingRepository;
    import test.supcon.entity.infor;
    import java.util.ArrayList;
    
    public interface userDao extends PagingAndSortingRepository<infor, Integer> { 
        @Query(value = "select * from infor where name like %?1% limit 1",nativeQuery = true)
        public ArrayList<infor> findUserByName(String name);
    }

## 2.2创建infor实体类映射数据库infor数据表 ##

package test.supcon.entity;
    
    import javax.persistence.Column;
    import javax.persistence.Entity;
    import javax.persistence.GeneratedValue;
    import javax.persistence.Id;
    
    @Entity
    public class infor{ 
        @Column
        String name;
        @Column
        String ower;
        @Column
        String href;
        @Id
        @GeneratedValue
        @Column
        String key1;
        @Column
        String disable;
        @Column
        String avatar;
        @Column
        String desc;
        @Column
        String callNo;
        @Column
        String status;
        @Column
        String updatedAt;
        @Column
        String createAt;
        @Column
        String progress;
    
        @Override
        public String toString() { 
            return "user{" +
                    "name='" + name + '\'' +
                    ", ower='" + ower + '\'' +
                    ", href='" + href + '\'' +
                    ", key='" + key1 + '\'' +
                    ", disable='" + disable + '\'' +
                    ", avatar='" + avatar + '\'' +
                    ", desc='" + desc + '\'' +
                    ", callNo='" + callNo + '\'' +
                    ", status='" + status + '\'' +
                    ", updatedAt='" + updatedAt + '\'' +
                    ", createAt='" + createAt + '\'' +
                    ", progress='" + progress + '\'' +
                    '}';
        }
    
        public String getName() { 
            return name;
        }
    
        public void setName(String name) { 
            this.name = name;
        }
    
        public String getOwer() { 
            return ower;
        }
    
        public void setOwer(String ower) { 
            this.ower = ower;
        }
    
        public String getHref() { 
            return href;
        }
    
        public void setHref(String href) { 
            this.href = href;
        }
    
        public String getKey() { 
            return key1;
        }
    
        public void setKey(String key) { 
            this.key1 = key;
        }
    
        public String getDisable() { 
            return disable;
        }
    
        public void setDisable(String disable) { 
            this.disable = disable;
        }
    
        public String getAvatar() { 
            return avatar;
        }
    
        public void setAvatar(String avatar) { 
            this.avatar = avatar;
        }
    
        public String getDesc() { 
            return desc;
        }
    
        public void setDesc(String desc) { 
            this.desc = desc;
        }
    
        public String getCallNo() { 
            return callNo;
        }
    
        public void setCallNo(String callNo) { 
            this.callNo = callNo;
        }
    
        public String getStatus() { 
            return status;
        }
    
        public void setStatus(String status) { 
            this.status = status;
        }
    
        public String getUpdateAt() { 
            return updatedAt;
        }
    
        public void setUpdateAt(String updateAt) { 
            this.updatedAt = updateAt;
        }
    
        public String getCreateAt() { 
            return createAt;
        }
    
        public void setCreateAt(String createAt) { 
            this.createAt = createAt;
        }
    
        public String getProgress() { 
            return progress;
        }
    
        public void setProgress(String progress) { 
            this.progress = progress;
        }
    }

## 2.3Controller中测试使用 ##

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.Controller;
    import org.springframework.web.bind.annotation.RequestMapping;
    import org.springframework.web.bind.annotation.ResponseBody;
    import test.supcon.Dao.userDao;
    import test.supcon.entity.infor;
    
    import java.util.ArrayList;
    
    @Controller
    public class testController { 
        @Autowired
        private userDao userdao;
        @RequestMapping("findall")
        @ResponseBody
        public String findall() { 
            ArrayList<infor> userByName = userdao.findUserByName("");//使用自定义方法测试
            System.out.println(userByName);
            int pagenum=0; //当前页
            int pagesize=2;//每页显示条数
            Sort sort = new Sort(Sort.Direction.DESC,"key1");
            Pageable pageable = new PageRequest(pagenum,pagesize,sort);
            Page<infor> all = userdao.findAll(pageable);//使用PagingAndSortingRepository提供的方法中的分页进行测试
            for(infor a:all){ 
                System.out.println(a.toString());
            }
            System.out.println(all.toString());
            return userByName.toString();
        }
    }

## 2.4 application.yml配置文件 ##

server:
      port: 8889
    
    spring:
      application:
        name: provider-service
      datasource:
        url: jdbc:mysql://localhost:3306/test1?serverTimezone=UTC&useUnicode=true&characterEncoding=utf8&useSSL=false
        username: root
        password: 123456
        driver-class-name: com.mysql.jdbc.Driver
      jpa:
        hibernate:
          ddl-auto: update
        database-platform: org.hibernate.dialect.MySQLDialect
        show-sql: true
    
    eureka:
      client:
        service-url:
          defaultZone: http://localhost:8888/eureka/
      instance:
        hostname: localhost
        prefer-ip-addrss: false  #使用ip地址注册

# 3.结果如下，测试成功： #

![在这里插入图片描述][20200811143022491.png]

[20200811143022491.png]: /images/20221124/47a7da00d1f14cdeb5fa023dfa9532f5.png