Spring Boot With MySQL Database connection with Examples | MySQl Database Configuration with Spring Boot Projects

 😃 MySQL Database Configuration with Spring Boot Projects 

In this article, we are going to introduce How to connect MySQL Database with the Spring Boot project.

pom.xml

  <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-devtools</artifactId> <scope>runtime</scope> <optional>true</optional> </dependency> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <scope>runtime</scope> </dependency> <dependency> <groupId>org.projectlombok</groupId> <artifactId>lombok</artifactId> <optional>true</optional> </dependency>  

 application. properties

  server.port=8025 spring.datasource.url=jdbc:mysql://localhost:3306/princedb spring.datasource.username=root spring.datasource.password=root spring.jpa.hibernate.ddl-auto=create-drop

MySqlWithSpringBootApplication.java

  package com.app; import org.springframework.boot.SpringApplication; import org.springframework.boot.autoconfigure.SpringBootApplication; @SpringBootApplication public class MySqlWithSpringBootApplication { public static void main(String[] args) { SpringApplication.run(MySqlWithSpringBootApplication.class, args); } }  

 

Student.java

  package com.app.model; import javax.persistence.Entity; import javax.persistence.GeneratedValue; import javax.persistence.GenerationType; import javax.persistence.Id; import lombok.AllArgsConstructor; import lombok.Data; import lombok.NoArgsConstructor; @Data @Entity @NoArgsConstructor @AllArgsConstructor public class Student { @Id @GeneratedValue(strategy = GenerationType.AUTO) private int sid; private String name; private double fee; }  

 

StudentRepositery.java

  package com.app.repositery; import org.springframework.data.jpa.repository.JpaRepository; import com.app.model.Student; public interface StudentRepositery extends JpaRepository<Student, Integer>{ }

StudentController.java

package com.app.controller; import java.util.List; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.GetMapping; import org.springframework.web.bind.annotation.PostMapping; import org.springframework.web.bind.annotation.RequestBody; import org.springframework.web.bind.annotation.RestController; import com.app.model.Student; import com.app.repositery.StudentRepositery; @RestController public class StudentController { @Autowired private StudentRepositery studentRepositery; @PostMapping("/save") public Student saveStudent(@RequestBody Student s) { return studentRepositery.save(s); } @GetMapping("/get") public List<Student> get(){ return studentRepositery.findAll(); } }

If you want to test this application:

you have to open Postman Screen and hit the URL in this postman like that: