Insert data into table using PreparedStatement - JDBC#6

Sdílet
Vložit
  • čas přidán 14. 07. 2019
  • Insert data into table usiing PreparedStatement .
    In this video i will explain how to insert data into table using preparedstatement.
    How to execute dynamic query .
    how to execute parameterized query.
    Steps to connect with database: • Steps to Connect with ...

Komentáře • 41

  • @aryanchaurasia8192
    @aryanchaurasia8192 Před 4 lety +6

    Bhuut bhuut Dhanyewaad bhaiya kaafi acha explanation kiye hai
    Jdbc ka itna acha explanation pure youtube. Pr nahi dikhaa

  • @titanesqueman
    @titanesqueman Před 2 lety +20

    Didn't understand a word but the code was clean and self explained, thank you kind sir!

    • @srschool4298
      @srschool4298 Před 2 lety +1

      haha its hindi language!

    • @semlon5266
      @semlon5266 Před 9 měsíci +1

      @@srschool4298it’s English 💀💀💀

  • @ankurchakraborty3999
    @ankurchakraborty3999 Před rokem +8

    At 4.28 reminds me of evening prayer my mom does 😅

  • @adityakesarwani3121
    @adityakesarwani3121 Před rokem +1

    Thanks a lot!😭. For past 1 month I was searching the internet on how to pass a variable data to query but at last I found your and my problem was solved.
    Again thanks a a lot.

  • @sounaksaha1455
    @sounaksaha1455 Před 2 měsíci

    Kya badiya samjhaate ho yaar.

  • @RohitSingh-rj5pd
    @RohitSingh-rj5pd Před měsícem

    Bahut babut thanks

  • @vyavahareaditya5936
    @vyavahareaditya5936 Před rokem +4

    But how to insert the values taken from the user using Scanner object????

  • @RAHULKUMAR-fn1fj
    @RAHULKUMAR-fn1fj Před 4 lety +3

    Ekdm acha pdate ho aap ....😍😍 helped me alot

  • @harsh.jain22
    @harsh.jain22 Před 3 lety

    thanks a lot sir....you helped me a lot

  • @punammhaiske7609
    @punammhaiske7609 Před 3 lety +2

    I really love the way you teach..thank you sir .

  • @virusehwag9562
    @virusehwag9562 Před 4 lety +4

    Bhai very nice explanation👌👌
    Ur #JDBC videos has helped me a lot .....
    Keep it up 🔥🔥🔥

  • @srschool4298
    @srschool4298 Před 2 lety

    its so calming to just listen your voice !

  • @RK-Sonide4vr
    @RK-Sonide4vr Před 4 měsíci

    ❤‍🔥❤‍🔥❤‍🔥❤‍🔥

  • @roushnikumari2977
    @roushnikumari2977 Před rokem

    Sir please make a video of the difference between statement and prepared statement! Because I understand very well from your videos.

  • @vinitraut4088
    @vinitraut4088 Před rokem +2

    I'm getting error as: java.sql.SQLException: No value specified for parameter 2

  • @subhu143
    @subhu143 Před 2 lety

    Kya explain karte ho sir maja agaya🥰😍

  • @romainegandhi5737
    @romainegandhi5737 Před rokem

    Nice and crisp ❤️

  • @bloom6874
    @bloom6874 Před rokem

    great explanation

  • @RahulBambale
    @RahulBambale Před rokem

    nice bro

  • @sanjushekhawat6446
    @sanjushekhawat6446 Před 3 lety

    When am executed program exception show invalid host/ bind variable name how resolve??

  • @shubhamkaneri1191
    @shubhamkaneri1191 Před 3 lety

    Insert into select statement can you use in jdbc

  • @divyagangaposhakkendra6055

    Hie Durgesh Sir , For me it throwing this error..can you please tell how to resolve it
    PrepardStatement.java:16: error: incompatible types: java.sql.PreparedStatement cannot be converted to PreparedStatement
    PreparedStatement pstmt=con.prepareStatement(q);

    • @sunnygoswami2248
      @sunnygoswami2248 Před 2 lety

      Just check if you are using correct import statement for sql, it should be
      import java.sql.*;
      After this if it still doesn't work, check if you have created the connection correctly - It should be --
      Connection con = DriverManager.getConnection(url, uname, pswd);

  • @flyingbomber
    @flyingbomber Před 2 lety +1

    jai mata di

  • @shakilahamad2611
    @shakilahamad2611 Před rokem

    sir we getting error during runtime mysql syntex error for parameterized statement

  • @vaishnavibangar2561
    @vaishnavibangar2561 Před 3 lety

    Thank you sir !!!

  • @silkysaurabh7478
    @silkysaurabh7478 Před 7 měsíci +1

    sir..meri run nhi ho rhi command prompt m...error aa rha h..please help me sir..

  • @anilkumaryadav106
    @anilkumaryadav106 Před rokem

    how to avoid duplicate insertion?

  • @Codestry
    @Codestry Před 4 lety

    I'm getting error as: java.sql.SQLException: No value specified for parameter 2
    if I'm deliberately giving no value for second parameter.

    • @Codestry
      @Codestry Před 4 lety

      Passing both the parameter is compulsory .. what to do if I want to make second parameter not compulsory.

    • @vinitraut4088
      @vinitraut4088 Před rokem

      I'm getting error as: java.sql.SQLException: No value specified for parameter 2
      is there any so;ution for that

  • @StayAware9
    @StayAware9 Před 11 měsíci +1

    Mummy piche puja kar rahi 4:17

  • @mahakgarg3152
    @mahakgarg3152 Před rokem

    Bhuut bhuut Dhanyewaad bhaiya kaafi acha explanation kiye hai
    Jdbc ka itna acha explanation pure youtube. Pr nahi dikhaa

  • @RAHULKUMAR-fn1fj
    @RAHULKUMAR-fn1fj Před 4 lety

    Ekdm acha pdate ho aap ....😍😍 helped me alot

  • @RAHULKUMAR-fn1fj
    @RAHULKUMAR-fn1fj Před 4 lety

    Ekdm acha pdate ho aap ....😍😍 helped me alot