Tag: java

I am new to spring but I had it working with JPA to where it returns the results from a SQL Server table without any issues (List of Applications). That table is now 3 separate tables that need to be joined which I did through a stored procedure. The stored procedure does not take any parameters, simple returns all the results but the results are exactly the same as the dropped table was returning, same number of columns and same column names. I tried following some online examples without success. Please help!!
Below are all the objects that I believe are relevant, I am not adding the application.properties file because the it was already working before I switch to pulling from a stored procedure instead of a single table. The First GET on the ApplicationJpaRepository.java file is the one that I am trying to figure out. I will probably create a new stored procedure or enhance the current one to also do crud operations by taking parameters but if I can solve this, it might give me enough knowledge to understand how to do the rest.

Application.java

package com.perspecta.rest.application;

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

@Entity
@Table(name = "Application")
@NamedStoredProcedureQuery(name = "Application.getListOfApplications", 
  procedureName = "pr_retrieve_application_list")
public class Application {

    @Id
    @GeneratedValue
    private Long id;
    private String application_name;
    private String application_description;
    private String data_types;

    protected Application() {
        
    }

    public Application(Long id, String application_name, String application_description, String data_types) {
        this.id = id;
        this.application_name = application_name;
        this.application_description = application_description;
        this.data_types = data_types;
    }

    @Column
    public Long getId() {
        return id;
    }
    public void setId(Long id) {
        this.id = id;
    }

    @Column
    public String getApplication_name() {
        return application_name;
    }
    public void setApplication_name(String application_name) {
        this.application_name = application_name;
    }

    @Column
    public String getApplication_description() {
        return application_description;
    }
    public void setApplication_description(String application_description) {
        this.application_description = application_description;
    }

    @Column
    public String getData_types() {
        return data_types;
    }
    public void setData_types(String data_types) {
        this.data_types = data_types;
    }

    @Override
    public boolean equals(Object obj) {
        if (this == obj)
            return true;
        if (obj == null)
            return false;
        if (getClass() != obj.getClass())
            return false;
        Application other = (Application) obj;
        if (id != other.id)
            return false;
        return true;
    }
}

ApplicationJpaRepository.java

package com.perspecta.rest.application;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.query.Procedure;
import org.springframework.stereotype.Repository;

@Repository
public interface ApplicationJpaRepository extends JpaRepository<Application, Long> {
    @Procedure(value  = "pr_retrieve_application_list")
    void getListOfApplications(String model);    
}

ApplicationJpaResource.java

package com.perspecta.rest.application;

import java.net.URI;
import java.util.List;

import javax.validation.Valid;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.http.HttpStatus;
import org.springframework.http.ResponseEntity;
import org.springframework.web.bind.annotation.CrossOrigin;
import org.springframework.web.bind.annotation.DeleteMapping;
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.PutMapping;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RestController;
import org.springframework.web.servlet.support.ServletUriComponentsBuilder;

@CrossOrigin(origins = "http://localhost:4200")
@RestController
public class ApplicationJpaResource {

    @Autowired
    private ApplicationJpaRepository applicationJpaRepository;


    **@GetMapping("/jpa/users/{username}/applications")
    public List<Application> getAllApplications(@PathVariable String username){
        return applicationJpaRepository.findAll();
    }**

    @GetMapping("/jpa/users/{username}/applications/{id}")
    public Application getApplication(@PathVariable String username, @PathVariable long id){
        return applicationJpaRepository.findById(id).get();
    }

    //DELETE /users/{username}/applications/{id}
    @DeleteMapping("/jpa/users/{username}/applications/{id}")
    public ResponseEntity<Void> deleteApplication(@PathVariable String username, @PathVariable long id){
        
        applicationJpaRepository.deleteById(id);
        return ResponseEntity.noContent().build();
    }

    // Edit/Update an Application
    // PUT /users/{username}/applications/{id}
    @PutMapping("/jpa/users/{username}/applications/{id}")
    public ResponseEntity<Application> updateApplication(@PathVariable String username, @PathVariable long id, @RequestBody Application application){

        Application applicationUpdated = applicationJpaRepository.save(application);
        return new ResponseEntity<Application>(application, HttpStatus.OK);
    }

    // Create a new Application
    // POST /users/{username}/applications/
    @PostMapping("/jpa/users/{username}/applications")
    public ResponseEntity<Void> createApplication(@PathVariable String username, @RequestBody Application application){

        Application createdApplication = applicationJpaRepository.save(application);

        URI uri = ServletUriComponentsBuilder.fromCurrentRequest().path("/{id}").buildAndExpand(createdApplication.getId()).toUri();
        return ResponseEntity.created(uri).build();
    }

}