How to create simple REST app using Spring Boot, AngularJS and MariaDB in Eclipse. Part 1

This post was inspired by http://g00glen00b.be/prototyping-spring-boot-angularjs/.

In Eclipse, File - New - Spring Starter Project. Enter Name, next, check Web. Next, Finish.

Open pom.xml and add:

<dependency>
   <groupId>org.springframework.boot</groupId>
   <artifactId>spring-boot-starter-data-jpa</artifactId>
  </dependency>
  <dependency>
   <groupId>org.mariadb.jdbc</groupId>
   <artifactId>mariadb-java-client</artifactId>
  </dependency>

Go to /src/main/resources/static/ create bower.json file:

{
  "name": "ng-spring-boot",
  "dependencies": {
    "angular": "~1.3.0",
    "angular-resource": "~1.3.0",
    "bootstrap-css-only": "~3.2.0"
  }
} 

Then, in this folder run:

$ bower install

It will create bower_components catalog with all necessary angular dependences.

Now create /src/main/resources/config/ folder with application.yml file:

# ===================================================================
# Spring Boot configuration.
#
# This configuration will be overriden by the Spring profile you use,
# for example application-dev.yml if you use the "dev" profile.
# ===================================================================

# ===================================================================
# Standard Spring Boot properties.
# Full reference is available at:
# http://docs.spring.io/spring-boot/docs/current/reference/html/common-application-properties.html
# ===================================================================

spring:
    datasource:
        url: jdbc:mariadb://localhost:3306/barfitter
        name: barfitter
        username: barfitter
        password: barfitter
    jpa:
        database-platform: org.hibernate.dialect.MySQL5InnoDBDialect
        database: MYSQL
        show-sql: true
        properties:
            hibernate.cache.use_second_level_cache: true
            hibernate.cache.use_query_cache: false
            hibernate.generate_statistics: true
    mvc:
        favicon:
            enabled: true

You must change your datasource credentials.

Now I create three entities in /src/main/java/finbarre/entities/:

package finbarre.entities;

import javax.persistence.Entity;

import java.math.BigDecimal;

import javax.persistence.*;
import javax.validation.constraints.*;
/**
 * A Vat.
 */
@Entity
@Table(name = "vat")
public class Vat  {


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

    @NotNull
    @Column(name = "description", nullable = false)
    private String description;

    @NotNull
    @Column(name = "rate", precision=10, scale=2, nullable = false)
    private BigDecimal rate;

    @Column(name = "active")
    private Boolean active;

    public Long getId() {
        return id;
    }

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

    public String getDescription() {
        return description;
    }

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

    public BigDecimal getRate() {
        return rate;
    }

    public void setRate(BigDecimal rate) {
        this.rate = rate;
    }

    public Boolean isActive() {
        return active;
    }

    public void setActive(Boolean active) {
        this.active = active;
    }



    @Override
    public String toString() {
        return "Vat{" +
            "id=" + id +
            ", description='" + description + "'" +
            ", rate='" + rate + "'" +
            ", active='" + active + "'" +
            '}';
    }
}

package finbarre.entities;

import javax.persistence.Entity;
import javax.persistence.*;
import javax.validation.constraints.*;

/**
 * A Category.
 */
@Entity
@Table(name = "category")
public class Category  {


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

    @NotNull
    @Column(name = "name", nullable = false)
    private String name;

    @Column(name = "parent_id")
    private Integer parentId;

    public Long getId() {
        return id;
    }

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

    public String getName() {
        return name;
    }

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

    public Integer getParentId() {
        return parentId;
    }

    public void setParentId(Integer parentId) {
        this.parentId = parentId;
    }


    @Override
    public String toString() {
        return "Category{" +
            "id=" + id +
            ", name='" + name + "'" +
            ", parentId='" + parentId + "'" +
            '}';
    }
}

package finbarre.entities;

import javax.persistence.Entity;

import java.math.BigDecimal;

import javax.persistence.*;
import javax.validation.constraints.*;



/**
 * A Product.
 */
@Entity
@Table(name = "product")
public class Product {


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

    @NotNull
    @Column(name = "name", nullable = false)
    private String name;

    @Column(name = "purch_price_net", precision=10, scale=2)
    private BigDecimal purchPriceNet;

    @NotNull
    @Column(name = "sell_price_gross", precision=10, scale=2, nullable = false)
    private BigDecimal sellPriceGross;

    @Column(name = "active")
    private Boolean active;

    @Column(name = "self_made")
    private Boolean selfMade;

    @Column(name = "purch_price_gross", precision=10, scale=2)
    private BigDecimal purchPriceGross;

    @Column(name = "purch_vat_value", precision=10, scale=2)
    private BigDecimal purchVatValue;

    @Column(name = "sell_price_net", precision=10, scale=2)
    private BigDecimal sellPriceNet;

    @Column(name = "sell_vat_value", precision=10, scale=2)
    private BigDecimal sellVatValue;

    @ManyToOne
    private Vat productPurchPriceRate;

    @ManyToOne
    private Vat productSellPriceRate;

    @ManyToOne
    private Category category;

    public Long getId() {
        return id;
    }

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

    public String getName() {
        return name;
    }

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

    public BigDecimal getPurchPriceNet() {
        return purchPriceNet;
    }

    public void setPurchPriceNet(BigDecimal purchPriceNet) {
        this.purchPriceNet = purchPriceNet;
    }

    public BigDecimal getSellPriceGross() {
        return sellPriceGross;
    }

    public void setSellPriceGross(BigDecimal sellPriceGross) {
        this.sellPriceGross = sellPriceGross;
    }

    public Boolean isActive() {
        return active;
    }

    public void setActive(Boolean active) {
        this.active = active;
    }

    public Boolean isSelfMade() {
        return selfMade;
    }

    public void setSelfMade(Boolean selfMade) {
        this.selfMade = selfMade;
    }

    public BigDecimal getPurchPriceGross() {
        return purchPriceGross;
    }

    public void setPurchPriceGross(BigDecimal purchPriceGross) {
        this.purchPriceGross = purchPriceGross;
    }

    public BigDecimal getPurchVatValue() {
        return purchVatValue;
    }

    public void setPurchVatValue(BigDecimal purchVatValue) {
        this.purchVatValue = purchVatValue;
    }

    public BigDecimal getSellPriceNet() {
        return sellPriceNet;
    }

    public void setSellPriceNet(BigDecimal sellPriceNet) {
        this.sellPriceNet = sellPriceNet;
    }

    public BigDecimal getSellVatValue() {
        return sellVatValue;
    }

    public void setSellVatValue(BigDecimal sellVatValue) {
        this.sellVatValue = sellVatValue;
    }

    public Vat getProductPurchPriceRate() {
        return productPurchPriceRate;
    }

    public void setProductPurchPriceRate(Vat vat) {
        this.productPurchPriceRate = vat;
    }

    public Vat getProductSellPriceRate() {
        return productSellPriceRate;
    }

    public void setProductSellPriceRate(Vat vat) {
        this.productSellPriceRate = vat;
    }

    public Category getCategory() {
        return category;
    }

    public void setCategory(Category category) {
        this.category = category;
    }



    @Override
    public String toString() {
        return "Product{" +
            "id=" + id +
            ", name='" + name + "'" +
            ", purchPriceNet='" + purchPriceNet + "'" +
            ", sellPriceGross='" + sellPriceGross + "'" +
            ", active='" + active + "'" +
            ", selfMade='" + selfMade + "'" +
            ", purchPriceGross='" + purchPriceGross + "'" +
            ", purchVatValue='" + purchVatValue + "'" +
            ", sellPriceNet='" + sellPriceNet + "'" +
            ", sellVatValue='" + sellVatValue + "'" +
            '}';
    }
}

And in /src/main/java/finbarre/repository/ we need three repositories:

package finbarre.repository;

import finbarre.entities.Vat;

import org.springframework.data.jpa.repository.*;

import java.util.List;

/**
 * Spring Data JPA repository for the Vat entity.
 */
@SuppressWarnings("unused")
public interface VatRepository extends JpaRepository<Vat,Long> {

}

package finbarre.repository;

import finbarre.entities.Category;

import org.springframework.data.jpa.repository.*;

import java.util.List;

/**
 * Spring Data JPA repository for the Category entity.
 */
@SuppressWarnings("unused")
public interface CategoryRepository extends JpaRepository<Category,Long> {

}

package finbarre.repository;

import finbarre.entities.Product;

import org.springframework.data.jpa.repository.*;

import java.util.List;

/**
 * Spring Data JPA repository for the Product entity.
 */
@SuppressWarnings("unused")
public interface ProductRepository extends JpaRepository<Product,Long> {

}

Note: we don’t need to declare new folders. We can change filenames and folders where are they placed only changing their location in headings like packages or imports.

Now we create some simple CRUD controllers for these entities:

package finbarre.controllers;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;

import finbarre.entities.Vat;
import finbarre.repository.VatRepository;

@RestController
@RequestMapping("/vat")
public class VatController {
  @Autowired
   private VatRepository repo;
   
   @RequestMapping(method = RequestMethod.GET)
   public List<Vat> findItems() {
     return repo.findAll();
   }
   
   @RequestMapping(method = RequestMethod.POST)
   public Vat addVat(@RequestBody Vat vat) {
    vat.setId(null);
     return repo.saveAndFlush(vat);
   }
   
   @RequestMapping(value = "/{id}", method = RequestMethod.PUT)
   public Vat updatedVat(@RequestBody Vat updatedVat, @PathVariable Long id) {
    updatedVat.setId(id);
     return repo.saveAndFlush(updatedVat);
   }
   
   @RequestMapping(value = "/{id}", method = RequestMethod.DELETE)
   public void deleteVat(@PathVariable Long id) {
     repo.delete(id);
   }
}

package finbarre.controllers;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;

import finbarre.entities.Category;
import finbarre.repository.CategoryRepository;

@RestController
@RequestMapping("/category")
public class CategoryController {
  @Autowired
   private CategoryRepository repo;
   
   @RequestMapping(method = RequestMethod.GET)
   public List<Category> findItems() {
     return repo.findAll();
   }
   
   @RequestMapping(method = RequestMethod.POST)
   public Category addCategory(@RequestBody Category category) {
    category.setId(null);
     return repo.saveAndFlush(category);
   }
   
   @RequestMapping(value = "/{id}", method = RequestMethod.PUT)
   public Category updatedCategory(@RequestBody Category updatedCategory, @PathVariable Long id) {
    updatedCategory.setId(id);
     return repo.saveAndFlush(updatedCategory);
   }
   
   @RequestMapping(value = "/{id}", method = RequestMethod.DELETE)
   public void deleteCategory(@PathVariable Long id) {
     repo.delete(id);
   }
}

package finbarre.controllers;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;

import finbarre.entities.Product;
import finbarre.repository.ProductRepository;

@RestController
@RequestMapping("/product")
public class ProductController {
  @Autowired
   private ProductRepository repo;
   
   @RequestMapping(method = RequestMethod.GET)
   public List<Product> findItems() {
     return repo.findAll();
   }
   
   @RequestMapping(method = RequestMethod.POST)
   public Product addProduct(@RequestBody Product product) {
    product.setId(null);
     return repo.saveAndFlush(product);
   }
   
   @RequestMapping(value = "/{id}", method = RequestMethod.PUT)
   public Product updatedProduct(@RequestBody Product updatedProduct, @PathVariable Long id) {
    updatedProduct.setId(id);
     return repo.saveAndFlush(updatedProduct);
   }
   
   @RequestMapping(value = "/{id}", method = RequestMethod.DELETE)
   public void deleteProduct(@PathVariable Long id) {
     repo.delete(id);
   }
}

Now you can in i.e Advanced REST Client [Chrome extension] enter http://localhost:8080/product and see products from database.