Spring Data JPA按字段名查询实现方法（新手CRUD求助）

Hey there! Let's break this down step by step to get your Spring Data JPA setup working smoothly for your username query, and also straighten out the layer structure confusion you're facing.

First: Understand Spring's Core Layer Responsibilities #

Let's start with clarifying the roles of each layer—this will fix your structural confusion:

• Repository Layer: Directly interacts with the database, handles only data access operations. Spring Data JPA auto-implements these methods for you, no custom SQL needed for basic queries.
• Service Layer: Manages business logic, calls repositories to fetch data, and processes it before passing to the controller.
• Controller Layer: Handles HTTP requests, receives input parameters, calls the service layer, and sends responses back to clients (Postman/browser).

Step 1: Fix the Credentials Repository #

Spring Data JPA uses method naming conventions to auto-generate query logic. You don't need custom SQL for your username lookup—just follow the rule findBy[FieldName] (with the field name capitalized).

Create this repository interface in a repository package:

import org.springframework.data.jpa.repository.JpaRepository;
import java.util.List;

public interface CredentialsRepository extends JpaRepository<Credentials, Long> {
    // Spring auto-generates SQL: SELECT * FROM credentials WHERE username = ?
    List<Credentials> findByUsername(String username);

    // Optional: If usernames are unique in your DB, use this for cleaner single-result returns
    // Optional<Credentials> findByUsername(String username);
}

Step 2: Implement the Service Layer #

First define a service interface, then its implementation to encapsulate business logic.

Service Interface (CredentialsService.java in a service package)

import java.util.List;

public interface CredentialsService {
    List<Credentials> findCredentialsByUsername(String username);

    // Optional: Add a method to return boolean if the username exists
    boolean doesUsernameExist(String username);
}

Service Implementation (CredentialsServiceImpl.java)

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.util.List;

@Service
public class CredentialsServiceImpl implements CredentialsService {

    private final CredentialsRepository credentialsRepository;

    // Constructor injection (Spring's recommended approach over field injection)
    @Autowired
    public CredentialsServiceImpl(CredentialsRepository credentialsRepository) {
        this.credentialsRepository = credentialsRepository;
    }

    @Override
    public List<Credentials> findCredentialsByUsername(String username) {
        return credentialsRepository.findByUsername(username);
    }

    @Override
    public boolean doesUsernameExist(String username) {
        // For better performance, add `boolean existsByUsername(String username);` to your repository
        return !credentialsRepository.findByUsername(username).isEmpty();
    }
}

Step 3: Build the Controller Layer #

Create a REST controller to handle HTTP requests and return responses to Postman/browser.

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.http.HttpStatus;
import org.springframework.http.ResponseEntity;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.RestController;
import java.util.List;

@RestController
public class CredentialsController {

    private final CredentialsService credentialsService;

    @Autowired
    public CredentialsController(CredentialsService credentialsService) {
        this.credentialsService = credentialsService;
    }

    // Test with: http://localhost:8080/credentials?username=your-test-username
    @GetMapping("/credentials")
    public ResponseEntity<?> getCredentialsByUsername(@RequestParam String username) {
        List<Credentials> credentials = credentialsService.findCredentialsByUsername(username);
        
        if (credentials.isEmpty()) {
            return new ResponseEntity<>("No credentials found for username: " + username, HttpStatus.NOT_FOUND);
        } else {
            // Return detailed info (or swap to return `true` if preferred)
            return new ResponseEntity<>(credentials, HttpStatus.OK);
            // To return boolean instead: return new ResponseEntity<>(true, HttpStatus.OK);
        }
    }
}

Step 4: Test with Postman/Browser #

1. Start your Spring application.
2. Send a GET request to http://localhost:8080/credentials?username=your-username (replace with a username in your DB).
3. You'll get:
   • A 200 OK response with the Credentials details if found.
   • A 404 NOT FOUND response with a message if the username doesn't exist.

Quick Additional Tips #

• Entity Class Improvement: Set your Credentials fields to private (follow Java encapsulation best practices) — your existing getters/setters will still work.
• Unique Usernames: If usernames should be unique, add @Column(unique = true) to the username field in your Credentials entity. This enforces uniqueness at the database level.

内容的提问来源于stack exchange，提问作者iamjoshua