package com.soubhagya;



import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.bind.annotation.RestController;

import com.soubhagya.Student;


@RestController
public class StudentController {
    @Autowired
    private StudentRepository studentRepo;

    // CREATE
    @RequestMapping("/students/create")
    @ResponseBody
    public String createStudent(long studentId,String firstName,String lastName,int age) {
        Student student = new Student(studentId, firstName, lastName,age);
        try {
            studentRepo.save(student);
        } catch (Exception e) {
            return e.getMessage();
        }
        return "creation successful: " + String.valueOf(student.getStudentId());
    }
    // READ
    @RequestMapping("/students/read")
    @ResponseBody
    public String readStudent(long studentId) {
        Student student;
        try {
            student = studentRepo.findOne(studentId);
        } catch (Exception e) {
            return e.getMessage();
        }
        if (student == null) {
            String errorMst = "no movie found for id " + studentId;
            return errorMst;
        } else {
            return student.getFirstname() + " : " +student.getLastname();
        }
    }
 // UPDATE
    @RequestMapping("/students/update")
    @ResponseBody
    public String updateStudent(long studentId,String firstName,String lastName,int age) {
        Student student;
        try {
            student = studentRepo.findOne(studentId);
            student.setFirstname(firstName);
            student.setLastname(lastName);
            student.setAge(age);
            studentRepo.save(student);
        } catch (Exception e) {
            return e.getMessage();
        }
        return student.getFirstname() + " : " +student.getLastname();
    }

    // DELETE
    @RequestMapping("/students/delete")
    @ResponseBody
    public String deleteStudent(long id) {
        try {
            studentRepo.delete(id);
        } catch (Exception e) {
            return e.getMessage();
        }
        return "deletion successful";
    }
}

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>

    <groupId>com.soubhagya</groupId>
    <artifactId>demo</artifactId>
    <version>0.0.1-SNAPSHOT</version>
    <packaging>jar</packaging>

    <name>SKPCRUDRestApp</name>
    <description>Spring Boot Rest Application</description>

    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>1.5.2.RELEASE</version>
        <relativePath/> <!-- lookup parent from repository -->
    </parent>

    <properties>
        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
        <project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
        <java.version>1.8</java.version>
    </properties>

    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-data-jpa</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web-services</artifactId>
        </dependency>
        <!-- Oracle-11g -->
    <dependency>
        <groupId>com.oracle</groupId>
        <artifactId>oracle</artifactId>
        <version>11.2</version>
    </dependency>

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>
    </dependencies>

    <build>
        <plugins>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
            </plugin>
        </plugins>
    </build>


</project>

spring.datasource.url = jdbc:oracle:thin:@localhost:1521:xe
spring.datasource.username = soubhagya
spring.datasource.password = soubhagya
spring.datasource.testWhileIdle = true
spring.datasource.validationQuery = SELECT 1
spring.jpa.show-sql = true
spring.jpa.hibernate.ddl-auto = create
spring.jpa.hibernate.naming-strategy = org.hibernate.cfg.ImprovedNamingStrategy
spring.jpa.properties.hibernate.dialect = org.hibernate.dialect.OracleDialect
server.port = 8083