我無法使用JPAspringboot通過電子郵件搜索我的用戶-有解無憂

控制器

package com.bird.bird.Controllers;

import com.bird.bird.Entity.Manager;
import com.bird.bird.Repository.ManagerRepository;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

@RestController
@RequestMapping("/manager")
public class ManagerController {
    
    @Autowired
    private ManagerRepository managerRepository;


    @GetMapping("/teste")
    public Object teste() {
        return "teste";
    }

    @PostMapping("/save")
    public Manager save(@RequestBody Manager manager){
        return managerRepository.save(manager);
    };
    @GetMapping("/list")
    public Iterable<Manager> findAll(){
        return managerRepository.findAll();
    };

    @GetMapping("/findID/{id}")
    public Manager findById( @PathVariable int id){
        return managerRepository.findById(id);
    };

    @GetMapping("/findCPF/{CPF}")
    public Manager findByCPF( @PathVariable String CPF){
        return managerRepository.findByCPF(CPF);
    };
}

存盤庫

package com.bird.bird.Repository;

import java.util.List;

import com.bird.bird.Entity.Manager;

import org.springframework.data.jpa.repository.JpaRepository;

public interface ManagerRepository extends JpaRepository<Manager, Integer> {

    Manager findById(int id);
    Manager findByEmail(String email);
    Manager findByCPF(String CPF);
    //Manager findByPhone(String phone);

}

物體

package com.bird.bird.Entity;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.Table;

@Entity
@Table(name = "manager")
public class Manager implements java.io.Serializable {
    @Id
    @GeneratedValue
    private int IdManager;
    @Column(name = "name", length = 30, nullable = false)
    private String Name;
    @Column(name = "birth", length = 15, nullable = false)
    private String Birth;
    @Column(name = "email", length = 30, unique = true, nullable = false)
    private String Email;
    @Column(name = "CPF", length = 30, unique = true, nullable = false)
    private String CPF;
    @Column(name = "password", length = 30, nullable = false)
    private String Password;
    @Column(name = "phone", length = 30, nullable = false)
    private String Phone;
    @Column(name = "address", length = 30, nullable = false)
    private String Address;
    @Column(name = "city", length = 30, nullable = false)
    private String City;
    @Column(name = "state", length = 30, nullable = false)
    private String State;
    @Column(name = "zipcode", length = 30, nullable = false)
    private String ZipCode;
    @Column(name = "country", length = 30, nullable = false)
    private String Country;

    public Manager() {
    }
    public Manager(String name, String birth, String email, String CPF, String password, String phone, String address, String city, String state, String zipCode, String country) {
        this.Name = name;
        this.Birth = birth;
        this.Email = email;
        this.CPF = CPF;
        this.Password = password;
        this.Phone = phone;
        this.Address = address;
        this.City = city;
        this.State = state;
        this.ZipCode = zipCode;
        this.Country = country;
    }

    public int getIdManager() {
        return IdManager;
    }

    public void setIdManager(int idManager) {
        IdManager = idManager;
    }

    public String getName() {
        return Name;
    }

    public void setName(String name) {
        Name = name;
    }

    public String getBirth() {
        return Birth;
    }

    public void setBirth(String birth) {
        Birth = birth;
    }

    public String getEmail() {
        return Email;
    }

    public void setEmail(String email) {
        Email = email;
    }

    public String getCPF() {
        return CPF;
    }

    public void setCPF(String CPF) {
        this.CPF = CPF;
    }

    public String getPassword() {
        return Password;
    }

    public void setPassword(String password) {
        Password = password;
    }

    public String getPhone() {
        return Phone;
    }

    public void setPhone(String phone) {
        Phone = phone;
    }

    public String getAddress() {
        return Address;
    }

    public void setAddress(String address) {
        Address = address;
    }

    public String getCity() {
        return City;
    }

    public void setCity(String city) {
        City = city;
    }

    public String getState() {
        return State;
    }

    public void setState(String state) {
        State = state;
    }

    public String getZipCode() {
        return ZipCode;
    }

    public void setZipCode(String zipCode) {
        ZipCode = zipCode;
    }

    public String getCountry() {
        return Country;
    }

    public void setCountry(String country) {
        Country = country;
    }
}

錯誤：eption：創建名稱為“managerController”的 bean 時出錯：通過欄位“managerRepository”表示的依賴關系不滿足；嵌套例外是 org.springframework.beans.factory.BeanCreationException：在 JpaRepositoriesRegistrar.EnableJpaRepositoriesConfiguration 上宣告的 @EnableJpaRepositories 中定義的 com.bird.bird.Repository.ManagerRepository 中創建名稱為“managerRepository”的 bean 時出錯：呼叫 init 方法失敗

簡歷：我想進行電子郵件搜索以進行測驗，然后再次登錄以比較電子郵件和密碼

uj5u.com熱心網友回復：

對于您的經理類，您已經定義了所有以大寫字母開頭的欄位（按照慣例這是錯誤的），因此您需要用小寫字母更新它們，然后我們才能使用 jpa 介面資料派生查詢（findByFieldName）所以更新經理類中的電子郵件欄位到此：

private String email ;    
// standard  getters and setters

除此之外，

 @GetMapping("/findByEmail/{email}")
public Manager findByEmail(@PathVariable String email){
    return managerRepository.findByEmail(email);
};

您需要更新它以獲取映射。從資料庫中檢索物件時，我們使用 @GetMapping 而不是 Post。此外，我們在 url 中而不是在請求正文中傳遞變數。

uj5u.com熱心網友回復：

將@Repositroy注釋添加到 ManagerRepository 并更改您的類，例如

public class Manager {
    @Id
    @GeneratedValue
    private int idManager;
    @Column(name = "name", length = 30, nullable = false)
    private String name;
    @Column(name = "birth", length = 15, nullable = false)
    private String birth;
    @Column(name = "email", length = 30, unique = true, nullable = false)
    private String email;
    @Column(name = "CPF", length = 30, unique = true, nullable = false)
    private String cpf;
    @Column(name = "password", length = 30, nullable = false)
    private String password;
    @Column(name = "phone", length = 30, nullable = false)
    private String phone;
    @Column(name = "address", length = 30, nullable = false)
    private String address;
    @Column(name = "city", length = 30, nullable = false)
    private String city;
    @Column(name = "state", length = 30, nullable = false)
    private String state;
    @Column(name = "zipcode", length = 30, nullable = false)
    private String zipCode;
    @Column(name = "country", length = 30, nullable = false)
    private String country;

    public ManagerDao(int idManager, String name, String birth, String email, String cpf, String password, String phone, String address, String city, String state, String zipCode, String country) {
        this.idManager = idManager;
        this.name = name;
        this.birth = birth;
        this.email = email;
        this.cpf = cpf;
        this.password = password;
        this.phone = phone;
        this.address = address;
        this.city = city;
        this.state = state;
        this.zipCode = zipCode;
        this.country = country;
    }

    public int getIdManager() {
        return idManager;
    }

    public void setIdManager(int idManager) {
        this.idManager = idManager;
    }

    public String getName() {
        return name;
    }

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

    public String getBirth() {
        return birth;
    }

    public void setBirth(String birth) {
        this.birth = birth;
    }

    public String getEmail() {
        return email;
    }

    public void setEmail(String email) {
        this.email = email;
    }

    public String getCpf() {
        return cpf;
    }

    public void setCpf(String cpf) {
        this.cpf = cpf;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }

    public String getPhone() {
        return phone;
    }

    public void setPhone(String phone) {
        this.phone = phone;
    }

    public String getAddress() {
        return address;
    }

    public void setAddress(String address) {
        this.address = address;
    }

    public String getCity() {
        return city;
    }

    public void setCity(String city) {
        this.city = city;
    }

    public String getState() {
        return state;
    }

    public void setState(String state) {
        this.state = state;
    }

    public String getZipCode() {
        return zipCode;
    }

    public void setZipCode(String zipCode) {
        this.zipCode = zipCode;
    }

    public String getCountry() {
        return country;
    }

    public void setCountry(String country) {
        this.country = country;
    }
}

然后洗掉“；” 不需要“}”之后的控制器中的方法。

Gurkirat Singh Guliani 回答正確

轉載請註明出處，本文鏈接：https://www.uj5u.com/qiye/408032.html

標籤：

上一篇：EFCore使用類別庫專案和資料庫腳手架從用戶密鑰中讀取連接字串

下一篇：使用SQL查詢創建索引和在JPA中使用@Index之間的區別