{"id":1929,"date":"2019-06-12T12:00:00","date_gmt":"2019-06-12T10:00:00","guid":{"rendered":"https:\/\/kindsonthegenius.com\/blog\/spring-with-jpa-repository-and-mysql-database\/"},"modified":"2026-07-05T03:23:46","modified_gmt":"2026-07-05T01:23:46","slug":"spring-with-jpa-repository-and-mysql-database","status":"publish","type":"post","link":"https:\/\/kindsonthegenius.com\/blog\/spring-with-jpa-repository-and-mysql-database\/","title":{"rendered":"Spring with JPA Repository and MySQL Database"},"content":{"rendered":"

Spring Data JPA (Stop hardcoding!)<\/strong><\/p>\n

    \n
  1. Create a new Spring Project called mvcdemo-data. Choose web, jpa and Apache Derby dependencies<\/li>\n
  2. Examine the pom.xml<\/li>\n
  3. Copy the models and resources package to the new project<\/li>\n
  4. Test the new application<\/li>\n
  5. Add the @Entity annotation to the Student class<\/li>\n
  6. Annotate the Id with @Id annotation<\/li>\n
  7. Create a new class called StudentRepository in the resources package<\/li>\n
  8. Make the repository an interface that extends the CrudRepository (this would enable you to use the methods in CrudRepository interface)<\/li>\n
  9. Add the Student and String as types to the repository<\/li>\n
  10. Autowire the StudentRepository into the StudentService<\/li>\n
  11. Modify the getAllStudents of the StudentService to call the findAll() method of the StudentRepository.(create new ArrayList, loop through using .foreach and used method reference students::add)<\/li>\n
  12. Modify the addStudent to use the save method of the StudentRepository<\/li>\n
  13. Add this line to the application.propeties file jpa.hibernate.ddl-auto=update<\/li>\n
  14. Test the service<\/li>\n
  15. Modify the getStudentById to use StudentRepository. Change the return type to Student<Optional>. Take Student parameter.<\/li>\n
  16. Modify the update to use the StudentRepository save method. Takes Student as parameter.<\/li>\n
  17. Modify the delete method to use Repository deleteById method. Takes the id<\/li>\n<\/ol>\n

     <\/p>\n

    Spring Boot with MySQL Database<\/strong><\/p>\n

      \n
    1. Create a Spring Project. Add Jpa, MySql and web dependencies<\/li>\n
    2. Create a model called Students in the models package<\/li>\n
    3. Annotate the class with @Entity annotation and @Table(name=\u201dStudents)<\/li>\n
    4. Annotate the Id field with the @Id annotation and @GeneratedValue<\/li>\n
    5. Create a StudentController file in the resources package. Annotate with @RestController<\/li>\n
    6. Annotate the class with a root url of \/springmysql<\/li>\n
    7. Create the StudentRepository in the resources package. This repository is an interface that extends CrudRepository.<\/li>\n
    8. Autowire StudentRepository into StudentController<\/li>\n
    9. Write a method getStudents in the StudentConroller to return List<Student>. Use findAll()<\/li>\n
    10. Annotate the getStudents method with @GetMapping of \/students. Cast to List<Student><\/li>\n
    11. Write a method addStudents to insert a Student and return a string saying how many records were saved. Use CrudRepository save() method.<\/li>\n
    12. Annotate the Student parameter with @RequestBody<\/li>\n
    13. Annotate the addStudents() method with @PostMapping of \/students<\/li>\n
    14. Write the database configuration in the application.properties file (driver class, url, username, password)<\/li>\n
    15. Create a database in MySQL workbench create database student;<\/li>\n
    16. use student;<\/li>\n<\/ol>\n

      The mysql configuration is shown below. This code would be placed in the application.properties file<\/p>\n

      datasource.driver-class-name=com.mysql.cj.jdbc.Driver\ndatasource.password=root\ndatasource.username=root\ndatasource.url=jdbc:mysql:\/\/localhost:3307\/student\njpa.hibernate.ddl-auto=update\n<\/pre>\n
      Test the application. Remember the Id is GeneratedValue, you need to only pass the name and the department parameters<\/p>\n
      Updates StudentService Class Using CrudRepository<\/h5>\n
      @Service<\/span>\npublic<\/span> class<\/span> StudentService<\/span> {<\/span>\n\t\n\t@Autowired<\/span>\n\tprivate<\/span> StudentRepository studentRepository;<\/span>\n\t\n\tList<<\/span>Student><\/span> students =<\/span> new<\/span> ArrayList<>(<\/span>Arrays.<\/span>asList<\/span>(<\/span>\n\t\tnew<\/span> Student<\/span>(<\/span>\"S2\"<\/span>,<\/span> \"Kindson\"<\/span>,<\/span> \"Software\"<\/span>),<\/span>\n\t\tnew<\/span> Student<\/span>(<\/span>\"S2\"<\/span>,<\/span> \"Saffron\"<\/span>,<\/span> \"Accounting\"<\/span>),<\/span>\n\t\tnew<\/span> Student<\/span>(<\/span>\"S3\"<\/span>,<\/span> \"Emeka\"<\/span>,<\/span> \"Management\"<\/span>)<\/span>\n\t));<\/span>\n\n\tpublic<\/span> List<<\/span>Student><\/span> getAllStudents<\/span>()<\/span> {<\/span>\n\t\t\/\/return students;<\/span>\n\t\tList<<\/span>Student><\/span> students =<\/span> new<\/span> ArrayList<>();<\/span>\n\t\tstudentRepository.<\/span>findAll<\/span>()<\/span>\n\t\t.<\/span>forEach<\/span>(<\/span>students:<\/span>:<\/span>add);<\/span>\n\t\treturn<\/span> students;<\/span>\n\t}<\/span>\n\t\n\tpublic<\/span> Optional<<\/span>Student><\/span> getStudentById<\/span>(<\/span>String Id)<\/span> {<\/span>\n\t\treturn<\/span>  studentRepository.<\/span>findById<\/span>(<\/span>Id);<\/span>\n\t}<\/span>\n\n\tpublic<\/span> void<\/span> addStudent<\/span>(<\/span>Student student)<\/span> {<\/span>\t\t\n\t\tstudentRepository.<\/span>save<\/span>(<\/span>student);<\/span>\t\t\n\t}<\/span>\n\n\tpublic<\/span> void<\/span> updateStudent<\/span>(<\/span>String Id,<\/span> Student student)<\/span> {<\/span>\n\t\tstudentRepository.<\/span>save<\/span>(<\/span>student);<\/span>\n\t}<\/span>\n\n\tpublic<\/span> void<\/span> deleteStudent<\/span>(<\/span>String Id)<\/span> {<\/span>\n\t\tstudentRepository.<\/span>deleteById<\/span>(<\/span>Id);;<\/span>\n\t}<\/span>\t\t\n}<\/span>\n<\/pre>\n","protected":false},"excerpt":{"rendered":"
      Spring Data JPA (Stop hardcoding!) Create a new Spring Project called mvcdemo-data. Choose web, jpa and Apache Derby dependencies Examine the pom.xml Copy the models … <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"pagelayer_contact_templates":[],"_pagelayer_content":"","footnotes":""},"categories":[311],"tags":[],"class_list":["post-1929","post","type-post","status-publish","format-standard","hentry","category-sql"],"_links":{"self":[{"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/posts\/1929","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/comments?post=1929"}],"version-history":[{"count":1,"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/posts\/1929\/revisions"}],"predecessor-version":[{"id":2097,"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/posts\/1929\/revisions\/2097"}],"wp:attachment":[{"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/media?parent=1929"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/categories?post=1929"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/tags?post=1929"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}