Олег Макаров's questions

我收到以下错误：

获取请求：

{
    "timestamp": "2025-01-01T19:53:26.424+00:00",
    "status": 500,
    "error": "Internal Server Error",
    "trace": "org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [select id, name, description from roll_data]\r\n\tat",
    "message": "PreparedStatementCallback; bad SQL grammar [select id, name, description from roll_data]",
    "path": "/rolls/all"
}

请求本身：

public static final String GET_ALL_ROLLS = "select id, name, description from roll_data";

实体：

@Data
@NoArgsConstructor
@AllArgsConstructor
@Entity
@Table(name = "roll_data", schema = "rolls")
public class RollEntity {
    public Long getId() {
        return id;
    }

    public String getName() {
        return name;
    }

    public String getDescription() {
        return description;
    }

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;

    @Column(name = "name")
    private String name;

    @Column(name = "description")
    private String description;
}

映射器：

@Component
public class RollMapper implements RowMapper<RollDto> {

    @Override
    public RollDto mapRow(ResultSet rs, int rowNum) throws SQLException {
        return new RollDto(
                rs.getLong("id"),
                rs.getString("name"),
                rs.getString("description")
        );
    }
}

数据传输对象：

@Data
public class RollDto {

    private Long id;
    private String name;
    private String description;

    public RollDto(Long id, String name, String description) {
        this.id = id;
        this.name = name;
        this.description = description;
    }

    public RollDto() {
    }

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

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

    public void setDescription(String description) {
        this.description = description;
    }

    public Long id() {
        return id;
    }

    public String name() {
        return name;
    }

    public String description() {
        return description;
    }
}

存储库：

@Repository
public class RollRepositoryImpl implements RollRepository {

    private final NamedParameterJdbcTemplate jdbcTemplate;

    private RollMapper rollMapper;

    public RollRepositoryImpl(NamedParameterJdbcTemplate jdbcTemplate, RollMapper rollMapper) {
        this.jdbcTemplate = jdbcTemplate;
        this.rollMapper = rollMapper;
    }

    @Override
    public List<RollDto> allRolls() throws NullPointerException{
        MapSqlParameterSource mapSqlParameterSource = new MapSqlParameterSource();
        return new
                ArrayList<>
                (jdbcTemplate.query(Sql.GET_ALL_ROLLS, mapSqlParameterSource, rollMapper));
    }
}

相同的查询在数据库中也有效。

我正在尝试为 patch 方法制作一个通用的 DTO，但是背心 JSON 被写入关键字段

实体对象：

@Entity
@Table(name = "employee")
@AllArgsConstructor
@NoArgsConstructor
@Getter
@Setter
public class Employee {

    @Id
    @GeneratedValue(strategy=GenerationType.SEQUENCE,generator="employee_seq")
    @SequenceGenerator(name="employee_seq", sequenceName="employee_seq", allocationSize=1)
    private Integer id;

    @Nonnull
    private String name;

    @Nonnull
    private String position;

    @Nonnull
    private Integer department;

    @Nonnull
    private Long phone;


    private String address;

    @Nonnull
    private String employmentDate;

}

DTO：

@Data
@Setter
@Getter
@NoArgsConstructor
@AllArgsConstructor
public class PatchDTO <T> {

    private String key;
    private T value;
}

控制器：

@RestController
public class EmployeeController{

    @Autowired
    EmployeeServiceImpl employeeService;

    EmployeeMapper mapper;


    @PatchMapping("/employee/{id}/update/{parameter}")
    public <T> HttpStatus updateEmployee(@PathVariable(value = "id") Integer employeeId,
                                         @PathVariable(value = "parameter") String parameter,
                                         @RequestBody Map<String, T> jsonData) throws
            EmployeeNotFoundException, ParseException{
        return employeeService.updateEmployee(employeeId, jsonData);
    }


}

服务：

@Service
public class EmployeeServiceImpl implements EmployeeService {

    @Autowired
    private EmployeeRepository employeeRepository;

    @Autowired
    private DepartmentServiceImpl departmentService;

    @Autowired
    private PositionServiceImpl positionService;

    @Autowired
    private EmployeeMapperImpl employeeMapperImpl;

    public <T> HttpStatus updateEmployee(Integer employeeId, Map<String, T> jsonData) throws
            EmployeeNotFoundException, ParseException{

        Employee employee = (Employee) employeeRepository.findById(employeeId)
                .orElseThrow(() -> new EmployeeNotFoundException(employeeId));

        System.out.println(1234567890);

        PatchDTO patchDTO = employeeMapperImpl.toPatchDTO(jsonData);


        System.out.println("error is here");

        if (patchDTO.getKey().equals("name")) {
            employee.setName(patchDTO.getValue().toString());
        }

        employeeRepository.save(employee);
        return HttpStatus.OK;
    }
}

地图绘制者：

@Component
public interface EmployeeMapper {

    EmployeeDTO toEmployeeDTO(Employee employee);

    Employee toEmployee(EmployeeDTO employeeDTO);

    <T> PatchDTO toPatchDTO(Map<String, T> dataToUpdate);

}

@Component
public class EmployeeMapperImpl implements EmployeeMapper {

    @Override
    public EmployeeDTO toEmployeeDTO(Employee employee) {
        if ( employee == null ) {
            return null;
        }

        EmployeeDTO employeeDTO = new EmployeeDTO();

        employeeDTO.setId( employee.getId() );
        employeeDTO.setName( employee.getName() );
        employeeDTO.setPosition( employee.getPosition() );
        employeeDTO.setDepartment( employee.getDepartment() );
        employeeDTO.setPhone( employee.getPhone() );
        employeeDTO.setAddress( employee.getAddress() );
        employeeDTO.setEmploymentDate( employee.getEmploymentDate() );

        return employeeDTO;
    }

    @Override
    public Employee toEmployee(EmployeeDTO employeeDTO) {
        if ( employeeDTO == null ) {
            return null;
        }

        Employee employee = new Employee();

        employee.setId( employeeDTO.getId() );
        employee.setName( employeeDTO.getName() );
        employee.setPosition( employeeDTO.getPosition() );
        employee.setDepartment( employeeDTO.getDepartment() );
        employee.setPhone( employeeDTO.getPhone() );
        employee.setAddress( employeeDTO.getAddress() );
        employee.setEmploymentDate( employeeDTO.getEmploymentDate() );

        return employee;
    }

    @Override
    public <T> PatchDTO toPatchDTO(Map<String, T> dataToUpdate) {
        if ( dataToUpdate == null ) {
            return null;
        }

        PatchDTO patchDTO = new PatchDTO();
        patchDTO.setKey(new ArrayList<String>(dataToUpdate.keySet()).get(0));
        patchDTO.setValue(new ArrayList<T>(dataToUpdate.values()).get(0));

        return patchDTO;
    }
}

问题是最后一个映射器中的 setKey() 方法设置了传递的 json 本身，而不仅仅是它的键。

如果您能提供帮助，我将非常高兴。