springboot rest jpa mysql

A java SringBoot REST API application with Data JPA & MySql DB.

DB creation

    
      CREATE DATABASE springboot_rest_jpa;
      USE springboot_rest_jpa;
      CREATE TABLE blog (
        id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
        title VARCHAR(500) NOT NULL,
        content VARCHAR(5000) NOT NULL
      );
    
  

Get responses both in XML & Json format

1. Add Jackson Dataformat XML into pom.xml

    	
	<dependency>
            <groupId>com.fasterxml.jackson.dataformat</groupId>
            <artifactId>jackson-dataformat-xml</artifactId>
            <version>2.10.0</version>
        </dependency>
	
  	

2. Add produces property which specifies json & xml format

    	
	@GetMapping(path="/blog", produces = { "application/json", "application/xml" })
	
  	

3. Request can be made like this:

    	
	a) http://localhost:8085/blog.xml
	b) http://localhost:8085/blog.json
	c) http://localhost:8085/blog
	   providing a key-value pair into the request header like this:
	   Key = Accept, value = application/xml	
	
  

Technolgy Used

• JDK 1.8
• Spring Boot Starter Parent-1.5.9.RELEASE
• MySql 8.0.17

Preview

1. Get Request

2. Get Request with body parameter

3. Post Request

4. Put Request

5. Delete Request

6. Response in XML