In this project, We will show how Spring boot and spring data jpa can be used to integrate with postgresql.

git clone https://github.com/RajeshBhojwani/springboot-postgresql.git

gradlew clean build

java -jar java -jar build/libs/springposgres-0.0.1-SNAPSHOT.jar

1. Bulk upload of the customers using below api. No need to pass any data.

http://localhost:9090/bulkcreate

2. POST call to insert one customer based on the JSON data passed.

http://localhost:9090/create

{
	"firstName": "Sumit",
	"lastName": "Khan"
}

2. GET call to retrive all customers.

http://localhost:9090/findall

3. GET call to search customer by id. http://localhost:9090/search/{id}

4. GET call to search customer by first name. http://localhost:9090/searchbyfirstname/{firstname}

For detail explanation of this project check this blog -https://www.rajeshbhojwani.co.in/2019/01/spring-boot-and-postgresql.html