Spring Boot CRUD Operations with MySQL using IntelliJ IDEA | CRUD Operation using REST API in Java

Поделиться
HTML-код
  • Опубликовано: 1 фев 2025

Комментарии • 102

  • @vamsikrishnaodela2639
    @vamsikrishnaodela2639 3 месяца назад

    🎯 Key points for quick navigation:
    00:00:00 *🚀 Introduction to Spring Boot CRUD Project with IntelliJ IDEA*
    - Overview of creating a Spring Boot CRUD application,
    - Using IntelliJ IDEA, MySQL, and Postman for development and testing,
    - Utilizing Spring Data JPA and Hibernate for the repository layer.
    00:01:24 *🛠️ Setting up Project with Spring Initializr*
    - Using Spring Initializr to create a Spring Boot project,
    - Selecting Maven project, Java language, and Spring Boot version 2.5.5,
    - Adding necessary dependencies: Spring Web, Spring Data JPA, MySQL JDBC driver, and Lombok.
    00:05:05 *⚙️ Importing and Configuring the Project in IntelliJ IDEA*
    - Importing the project into IntelliJ IDEA,
    - Setting up package structure: model, controller, repository, and exception packages,
    - Configuring MySQL database connection in `application.properties`.
    00:07:01 *🗃️ Database Setup and Entity Creation*
    - Creating a database in MySQL server,
    - Configuring database connection properties,
    - Creating a JPA entity for the `Employee` table with Lombok annotations and entity mappings.
    00:16:06 *📊 Employee Repository and Custom Exception*
    - Creating Spring Data JPA repository for CRUD operations,
    - Implementing a `ResourceNotFoundException` for handling non-existent records,
    - Using `@ResponseStatus` to manage HTTP response status.
    00:19:56 *🧩 Developing REST Controller for CRUD Operations*
    - Building REST endpoints for `Employee` operations,
    - Implementing GET endpoint to retrieve all employees,
    - Testing GET request using Postman and outlining request mappings.
    00:25:08 *✨ Creating and Testing Add Employee API*
    - Developing POST request handler to add a new employee,
    - Setting up and using Postman to send POST requests with JSON payload,
    - Validating functionality by adding records to the database.
    00:30:22 *📦 Fetching Objects from Database*
    - Discusses the procedure to retrieve an employee object using the `findById` method,
    - Explains handling a scenario where a record with a specific ID doesn't exist using a custom exception,
    - Demonstrates how to return a response entity upon successful data retrieval.
    00:33:27 *🛠️ Testing Get Employee API*
    - Shows how to use Postman to test the GET API endpoint,
    - Explains passing an employee ID in the URL to fetch data,
    - Validates the response to confirm API functionality.
    00:34:25 *🔄 Building Update Employee API*
    - Details the creation of an update method using response entity,
    - Describes fetching, updating, and saving employee data,
    - Introduces the PUT mapping annotation for updating resources.
    00:40:38 *🧪 Testing Update Employee API*
    - Demonstrates using Postman for testing the update employee API,
    - Illustrates updating employee details and validating the response,
    - Shows how to ensure data consistency post-update with a GET call.
    00:43:23 *🗑️ Building Delete Employee API*
    - Explains the process of creating a delete employee method,
    - Provides a check for employee existence before deletion,
    - Discusses returning no content status upon successful deletion.
    00:46:12 *🧹 Testing Delete Employee API*
    - Describes testing the DELETE API using Postman,
    - Highlights verifying deletion through a GET request check,
    - Confirms successful deletion with HTTP status code 204.
    Made with HARPA AI

  • @JavaGuides
    @JavaGuides  3 года назад +13

    Guys, Intellij idea is great IDE so go ahead and use free community addition for building spring boot projects. If you are new Intellij idea then check out intellij idea playlist on this channel.

    • @funcoding1797
      @funcoding1797 3 года назад

      IntellijIDEA Ultimate Edition is much more attractive and better, especially in the field of completing the codes .. with a lot of plugins e.g Codota as well SST or eclipse and is free for one year...😍 Tnx a lot bro... you're the best...

    • @jagadeesh8751
      @jagadeesh8751 3 года назад +1

      bro, In my code , compiler complains ResourceNotFoundException is not handled. you didnot used "throws" keyword in getById method. how it is working for you bro ??

  • @nml4546
    @nml4546 2 года назад +3

    Very good was I got past the database problem. For some reason, building the project from the downloaded Springboot zip file, I could not get past a database problem. I spent a couple of days researching and trying things to no avail. I finally decided tp build the project in the traditional manner, i,e, from scratch (but including SpringInitializer) and the needed dependencies. Then I just followed the view and everything worked as expected.

  • @neeraj91mathur
    @neeraj91mathur 8 месяцев назад

    Very crisp and to the point tutorial. Great job brother, this was helpful 👍

    • @pkmkb-69
      @pkmkb-69 8 месяцев назад

      How to update this in XAMPP any idea? I mean how to update tables in XAMPP after fetching APIs

  • @shamsularefinsajib7778
    @shamsularefinsajib7778 Год назад

    Thanks so much, I am new to java spring boot, i found it useful

  • @BKYADAV-zm7yv
    @BKYADAV-zm7yv 2 года назад

    Huge respect from my side sir ❤️

  • @paulovinicius9940
    @paulovinicius9940 3 года назад +1

    Very good as always!

  • @fsoldierdeth
    @fsoldierdeth Год назад

    love u man, thank u for that it really helped me a lot believe me

  • @karunakarverma
    @karunakarverma 3 года назад +1

    You are awesome 😎 you created lifetime reference.

  • @Lboards130
    @Lboards130 Год назад +1

    Thanks for the clip, it was very helpful.

  • @dadasajad8741
    @dadasajad8741 2 года назад

    amazing work brother. thank you very much!

  • @pylypiukantonio2215
    @pylypiukantonio2215 Год назад

    Thank you.Helped me a lot

  • @jagadeesh8751
    @jagadeesh8751 3 года назад +1

    very clear. thanks broooooooo

  • @Malarselvi.M
    @Malarselvi.M Год назад +1

    Jii this is amazing learning video.. I expect you to do project in intellij idea and postman and the outputs in excel..Hope you see back in the next video with what I expect before 😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊

  • @kushek3208
    @kushek3208 11 месяцев назад

    Very useful video thanks a lot🙏

  • @dgonx017_
    @dgonx017_ 2 года назад +1

    Best tutorial, new sub

  • @brayannkouam9097
    @brayannkouam9097 Год назад

    than you master .well explained tutorial your are a boss

  • @tanmay.k8525
    @tanmay.k8525 Год назад

    Wow, thanks dude.

  • @feminaazmi3753
    @feminaazmi3753 2 года назад

    Really helpful. Thank You :)

  • @gariktadevosyan764
    @gariktadevosyan764 2 года назад

    Thank you bro, very helpful.

  • @samuelquentacarvajal9910
    @samuelquentacarvajal9910 3 года назад

    very good :)
    "saludos desde bolivia "

  • @karthikravikumar-cq6df
    @karthikravikumar-cq6df Год назад

    the best of all

  • @sachkosachbolnagalathhaiky9938

    thank you brother amazing

  • @mistermiaumiau2134
    @mistermiaumiau2134 10 месяцев назад

    very good video!

  • @thaminduKavinda
    @thaminduKavinda Год назад

    Thanks for the video

  • @Musfimurshadi
    @Musfimurshadi Год назад

    very good

  • @janithsahasra3971
    @janithsahasra3971 2 года назад

    thanks a log it's really helpfull

  • @makarikevin
    @makarikevin 2 года назад

    Great tutorial

  • @dineshsv4186
    @dineshsv4186 3 года назад

    Thank you its working

  • @Azure-d8d
    @Azure-d8d 11 месяцев назад

    Thankyou bro❤

  • @ammaraziz5734
    @ammaraziz5734 5 месяцев назад

    Thank you.

  • @abinayaelangovan8585
    @abinayaelangovan8585 2 года назад +1

    ResourceNotFoundException is not working.. even in the demo shown in video, the customised error message is not getting printed

  • @subamsarkar_
    @subamsarkar_ 2 года назад +2

    Hi @Java Guides. I am not able to create the table. I did same coding as shown. And I am not getting any error in the build console. But the table is not getting created. I also changed the mysql dialect to my local MySQL version.

    • @little-by-little-one-trave1770
      @little-by-little-one-trave1770 2 года назад

      Hi any solution I am also facing the same issue. I am using mysql 8.

    • @little-by-little-one-trave1770
      @little-by-little-one-trave1770 2 года назад +2

      I used this it worked
      spring.jpa.hibernate.ddl-auto=update
      spring.datasource.url=jdbc:mysql://${MYSQL_HOST:localhost}:3306/ems
      spring.datasource.username=root
      spring.datasource.password=password
      spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
      spring.jpa.show-sql: true

    • @malfunkshungo
      @malfunkshungo 2 года назад

      @@little-by-little-one-trave1770 Thanks for the update. Mine also worked with this.

    • @adityacr7407
      @adityacr7407 7 месяцев назад

      ​@@malfunkshungo mine is not working. Please help

    • @adityacr7407
      @adityacr7407 7 месяцев назад

      Done . thanks a lot

  • @dilaragoral106
    @dilaragoral106 2 года назад

    best!!

  • @utkarshguruji8894
    @utkarshguruji8894 10 месяцев назад

    33:16 --> at line number 33 when I used Long instead of long , it is giving 404 error . Can anyone explain why ?

  • @rahuldubey1724
    @rahuldubey1724 2 года назад

    24:58 bro mera sara values that is first name, last name and email id sb null show kr rha hai..please help

  • @soundharn8257
    @soundharn8257 Год назад

    While inserting data inro table employee 'Column name set 'is not listing the column names not listing in suggestions😢

  • @anantpratapsingh9067
    @anantpratapsingh9067 2 года назад

    at 8:29 you printed spring.datasource.url , from where we can get this link and all other syntax ?

    • @subamsarkar_
      @subamsarkar_ 2 года назад +1

      You can find that in his Github Repo

    • @anantpratapsingh9067
      @anantpratapsingh9067 2 года назад

      @@subamsarkar_ धन्यवाद भाई ।

    • @subamsarkar_
      @subamsarkar_ 2 года назад

      @@anantpratapsingh9067 Bhai are you able to build the project ? I am half way through the video. Did everything same. No error in the console but table is not getting created.

    • @anantpratapsingh9067
      @anantpratapsingh9067 2 года назад

      @@subamsarkar_ आपने jpa dependency add किया था

    • @anantpratapsingh9067
      @anantpratapsingh9067 2 года назад

      किया ही होगा नहीं तो error आ जाता

  • @Musfimurshadi
    @Musfimurshadi Год назад

    Can you please share 3 or 4 small project using OOPS concept, Springboot, Java legacy idea ? With explaination in your video please ? If you already have, can you leave the link as a reply here please?

  • @rickhunter8216
    @rickhunter8216 Год назад

    IF YOU ARE USING MYSQL DATABASE, SO YOU DON'T NEED HARDCODE WITH COMMAND RUNNER. IT CAN GENERATE CONFUSION.

    • @aniketdey8449
      @aniketdey8449 Год назад

      Didn't get you bro, can you explain. And are you able to create the table from the code?

    • @prajwalnakure
      @prajwalnakure Год назад

      Yes, once you create the createEmployee() method ...u don't need the Command Runner interface. You can safely delete that , or else it will generate those two employees whenever we run the main class.

  • @UddhikaIshara
    @UddhikaIshara Год назад

    Thank you very much

  • @TechnicalYarana
    @TechnicalYarana 5 месяцев назад

    can i use this project in android studio

  • @mohamedamaan133
    @mohamedamaan133 7 месяцев назад

    Authentication required showing when testing via Postman. but i did correctly. can you give a solution. how to test it

  • @karthikk5278
    @karthikk5278 3 года назад

    Thank you

  • @remiimartinnn
    @remiimartinnn 2 года назад

    Thanks

  • @AJEETKUMAR-dk2kv
    @AJEETKUMAR-dk2kv 2 года назад

    Hello sir, I'm using eclipse IDE for project....

    • @AJEETKUMAR-dk2kv
      @AJEETKUMAR-dk2kv 2 года назад

      I'm not able to run it on postman it's always showing error not found...

    • @AJEETKUMAR-dk2kv
      @AJEETKUMAR-dk2kv 2 года назад

      Do I need to link on MySQL before postman? Coz I haven't done yet...

    • @rickhunter8216
      @rickhunter8216 Год назад

      @@AJEETKUMAR-dk2kv YOU NEED CONFIGURE THE APPLICATION. PROPERTIES FILE AND TYPE THE MYSQL CONNECTION.

  • @thabtiguenidi2960
    @thabtiguenidi2960 Год назад +1

    👍

  • @karthiksundaram544
    @karthiksundaram544 2 дня назад

    🎉

  • @little-by-little-one-trave1770
    @little-by-little-one-trave1770 2 года назад

    Good video thanks. According to mysql convention table name should be singular.

  • @sajithsukumaran99
    @sajithsukumaran99 3 года назад +1

    The first two IDs are always repeating...do u know what might be the problem..? Pls suggest

    • @paulovinicius9940
      @paulovinicius9940 3 года назад +1

      You copied and forgot to change the values in the commandLine method.

    • @rickhunter8216
      @rickhunter8216 Год назад

      @@paulovinicius9940 CORRECT.

  • @fookoboy9623
    @fookoboy9623 2 года назад

    if its showing web service is not started 8080 is busy then in application change the port number
    server.port=9090

  • @andrejpetnuch2125
    @andrejpetnuch2125 3 года назад +1

    when i use @Entity in sringboot, table is not created. Where is the problem?

    • @maxime045
      @maxime045 2 года назад

      You configured the application.properties ?

    • @rickhunter8216
      @rickhunter8216 Год назад

      @@maxime045 THAT IS CORRECT.

  • @yawamoako7811
    @yawamoako7811 3 года назад

    Great

  • @cdlijia
    @cdlijia 2 года назад

    学习了。

  • @adityacr7407
    @adityacr7407 7 месяцев назад

    Can anyone help? Table is not created in my ems database

  • @vinayakhorambali5463
    @vinayakhorambali5463 2 года назад

    hello i need a code for postmaping where if i have to save a data in my data base and if any of the field say "xyz" already exist in it then it should return me "field "xyz" already exists"... please help

  • @sahilsharma8691
    @sahilsharma8691 2 года назад

    I am not getting the .set in list in employee.setFirstName();
    What can I do?

    • @N7000nn
      @N7000nn 2 года назад

      You need to add lombock configuration in your Employee class. Above the class type @Setter and that works like setMethod of any field you have. The same goes for @Getter, @ToString etc..

  • @reverseflash2800
    @reverseflash2800 3 года назад

    IntelliJ idea free version se kam chal jaayega yaa pro version required hai

    • @JavaGuides
      @JavaGuides  3 года назад +1

      free community edition version se kam chal jayega.

  • @mariocs23
    @mariocs23 2 года назад

    King

  • @arunpitchaimani7713
    @arunpitchaimani7713 3 года назад

    Please create spring boot and graphql playlist videos

  • @delightful730
    @delightful730 2 года назад

    please do with postgreseSql

  • @josephmctigue4494
    @josephmctigue4494 Год назад

    where is link to your finished code?

  • @ravindrakawale5161
    @ravindrakawale5161 3 года назад

    can we create springboot project in intellij like eclipse

    • @rickhunter8216
      @rickhunter8216 Год назад

      SPRING TOOLS SUITE (STS) IS A ECLIPSE IDE FOR SPRING.

  • @rishimohan1408
    @rishimohan1408 2 года назад

    What does @crosaorigin annotation do?

    • @rickhunter8216
      @rickhunter8216 Год назад

      IT ALLOWS THAT GOOGLE CHROME OR MOZILLA OR EDGE DON'S BLOCK YOU WHEN YOU USE POSTMAN.

  • @chandrasekar3992
    @chandrasekar3992 Год назад

    Text is very small, Can't see properly , It's wasting my time

  • @BinKonChuot
    @BinKonChuot 10 месяцев назад

    omg, dont write code that, A project need full have controller, service, repo and model, you not have service?

    • @JavaGuides
      @JavaGuides  10 месяцев назад

      OMG, you want controller, service, repository then watch another video: ruclips.net/video/yybOzbOLegE/видео.htmlsi=JrR5T1VmaKIkEM32

  • @yarik83men51
    @yarik83men51 3 года назад

    +++

  • @subratmishra91
    @subratmishra91 2 года назад

    java.lang.ClassCastException: class net.javaguides.springboot.model.Employee cannot be cast to class org.springframework.boot.context.properties.bind.BindResult (net.javaguides.springboot.model.Employee and org.springframework.boot.context.properties.bind.BindResult are in unnamed module of loader 'app')

  • @raja90rocks
    @raja90rocks 2 года назад

    Hi JavaGuides,
    employee.setFirstName , LastName , email - can't be added facing issues . how to solve ?
    import model.Employee;
    import repository.EmployeeRepository;
    @SpringBootApplication
    public class SpringbootBackendApplication implements CommandLineRunner{
    public static void main(String[] args) {
    SpringApplication.run(SpringbootBackendApplication.class, args);
    }
    @Autowired
    private EmployeeRepository employeeRepository;

    @Override
    public void run(String... args) throws Exception {
    Employee employee=new Employee();
    employee.setFirstName -----------------------------> faced issues can't set the value


    }
    }

    • @N7000nn
      @N7000nn 2 года назад

      You need to add lombock configuration in your Employee class. Above the class type @Setter and that works like setMethod of any field you have. The same goes for @Getter, @ToString etc..

  • @omkarkumbhar2001
    @omkarkumbhar2001 Год назад

    Thank You