Inserting data to database using Spring JDBC | Best Practice | Spring Jdbc Tutorial
ฝัง
- เผยแพร่เมื่อ 19 มิ.ย. 2020
- In this video we are going to learn how to insert data to database using Spring JDBC
We will follow two approaches of doing do.
Inserting data to database using Spring JDBC | Best Practice | Spring Jdbc Tutorial
Download Source Code : learncodewithdurgesh.com/cour...
Full Spring Framework Series: • Spring Framework Tutor...
Telegram Link for Doubt: t.me/learncodewithdurgesh
Important Videos:
➡️React JS with Project : • 🔥 🔥 Complete React Js ...
➡️Learn JDBC in one video: • JDBC Crash Course in 1...
➡️Learn Python in One Video: • Learn Python in One Vi...
➡️Learn HTML in one video: • Jquery in one video in...
➡️Learn HTML form in one video: • Jquery in one video in...
➡️Learn JavaScript in one videos: • Learn JavaScript in O...
➡️Learn Form Validation using javascript and jquery: • Form Validation using ...
➡️Learn CSS in one video: • Jquery in one video in...
➡️Jquery in one video: • Jquery in one video in...
➡️Kotlin is one video: • Kotlin | Learn Kotlin ...
➡️Complete Python Project - TH-cam downloader in one video: • Jquery in one video in...
Important Playlist:
➡️Spring Boot Tutorial with Project : • Spring Boot Tutorial i...
➡️Spring MVC Tutorial: • Spring MVC Tutorial St...
➡️Complete Spring Framework Tutorial: • Spring Framework Tutor...
➡️Hibernate Tutorials: • Hibernate Tutorial for...
➡️E-Commerce Project using Java: • E-Commerce Project usi...
➡️AWS Free Java Hosting Playlist: • AWS Hosting Tutorial |...
➡️Hibernate Tutorial Playlist: • Hibernate Tutorial for...
➡️Learn Technology in One Vides: • Learn in one video : C...
➡️Programming Tips for Programmers: • Coding Tips and Discus...
➡️Complete Python for Beginners: • Complete Python Tutori...
➡️Important Python Projects: • Python Projects in Hindi
➡️Complete Servlet & JSP : • Servlet and Jsp (Serve...
➡️Complete JDBC ( Java Database Connectivity) : • JDBC(Java Database Con...
➡️Complete Java Project : TechBlog: • Full Java Advance Pro...
➡️Java Swing Projects: • Java Projects for begi...
➡️Java Core Concepts: • Java Core Tutorial
➡️Kya aap Jante hai Series: • kya app jante hai : s...
Important Links:
👉Official Website (Source Code): learncodewithdurgesh.com/
👉Telegram Discussion Group: t.me/learncodewithdurgesh
👉Follow me on Instagram: / durgesh_k_t
👉Follow on Facebook / learncodewithdurgesh
Gear that I use:
Gears that I Use:
Lenovo Ideapad S145 AMD Ryzen 5 15.6
amzn.to/33Vvxu2
Mic for Recording
amzn.to/305hgtr
amzn.to/2EyFMfa
Topic Covered:
spring jdbc module in hindi
spring module in hindi
spring jdbc
what is spring jdbc
spring jdbc tutorial in hindi
why to use spring jdbc in hindi
why to use spring jdbc
how to use spring jdbc
spring jdbc in hindi
learn spring spring jdbc
lear spring jdbc in hindi
jdbctemplate class spring jdbc
datasource spring module
inserting data using jdbcTemplate
inserting data using jdbcTemplate in hindi
Disclaimer:
All videos are for educational purposes and use them wisely. Any video may have a slight mistake, please take decisions based on your research. This video is not forcing anything on you.
Following this playlist from the beginning ..also watched all previous playlists of servlet jsp and hibernate orm ...thanks sir for this amazing content it is very helpful
Hello Sir.. Ye design pattern confuse kr raha hai... Plz use diagram before impliment.
Thanks for teaching us the best industry practices!
Very easy to understand and very helpful video. Thanks Durgesh.
Superb sir, Loved it. Appreciate your hard work for us.
Great video sir....fully industry based... thanks alot....
Thanks for sharing knowledge with us Sir 😍
Very easy to understand and helpful video. Thanks Durgesh Sirr🤩
thankyou very much sir ... ab jaake samjha
If anyone is facing database connection issue then change sql connector version "8.0.28" in pom.xml and change the driver path
Thanks !! It worked 🎈
bhai driver path kise change karni hai batadona pls
@@pathankhadeer9921 jaha tune woh mysql ka uername password likha hai waha driver path hai waha new drivername dalde ... waise woh nahi kiya toh bhi chaljayega
Thankyou so much it helped a lot
thank you @mdsarfarazansari3844
Thank you Sir!!😄
Thanks for the video
thodi complex video h
Ha yar
good Explanation Durgesh Brother
Great Thanks sir...
Thank you sir
Thank you sir 😁😁😁
thanks for to the content videoes.
thanks durgesh bhai
Thanks .
informative.
Thank you so muchh sir ji.............
thanks sir
thanks
श्री राधे राधे राधे बरसाने वाली राधे 🕉️🌹🇮🇳🕉️🙏🚩🛕🌞⛳💯🎯🙏
Best Bhaiya 🙏 👸 🕉️🙏🚩🌹🙏🕉️🕉️माँ
Nice wallpaper!
Please reply sir, so that I can continue the course.
damn bro, u nailed it
Perfect hai😁😁😂
Hey I had used @Autowired but it is not working for JdbcTemplate varialble...... showing error null value
for JdbcTemplate variable..... But same process worked fine in my another test classes.
it helped me. Thank you bro
We can even pass the object directly through constructor object of jdbctemp
Sir ye kaunsa design pattern use kiya hai?
if there is showing error of "DataAccessException cannot be resolved. It is indirectly referenced from required .class files" then add spring-tx dependency
i am getting message
Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
💥💥😘
Its showing error in context classPathXMl line
how to resolve it?
Finally 4 din lage but sare ke sare concept aache se samhj gya ki kese kaam ho raha hai .. datasource manger se keke data soucrce gar ek chiz deep padh liya jitna aapne nh batya uss se bhi aage chala gaya but 4 din lage aur muhhe har ek chiz samhj aagai
plsss help me
I am getting a compilation error on this line
int r = this.jdbcTemplate.update(query, st.getId(),st.getName(),st.getCity());
is anyone facing the same issue ?
I am not able to create connection please help
Hi all,
I am facing issue with mysqlconnecter of 5.1.33 version but when I updated it to 8.1.23 everything is working fine. Anyone else also facing the same kind of issue?
Thanks bro
How there interface studentDAO object is used but interface does not initialize object
sir acces denied for user 'root@localhost' using password('YES') isko kese resolve kre
Hi i am not able to load the microsoft sql server database in this project "Could not load JDBC driver class [com.microsoft.sqlserver.jdbc.SQLServerDriver]"
Hi Durgesh , loved your content,,
I have one question,,,,
While making this insert project you created studentdao interface and studentdaoimpl java class and it work fine,,, but when i made same project but without interface and it also worked fine.
Q) So what is the difference in between them ? Which is better and why?🙂
Its because of industry standards, And
It make code clutter free and
It helps in not making mistakes while revising the code
Because you made interface so you need to implement and follow the rules of interface(basically you need to define all the abstract method)
@@riturajshukla5897 yes
both are right but by using interface it shows that for what purpose we are making that class because when we implements it become necessary to implement that method...
however you can do it just by making class
good day
Awesome sir....or dhak dhak dil hoga😂😂😂
The more I am learning Spring, the more I think it makes 0 sense over traditional Java as it was started by saying it is used reduce complexity and decoupling. I have gone through 32 lectures of Spring and it creates more coupling over any other Java technique i have learned so far. Let's hope in coming lectures it starts to make sense.
sir i get a exception like "can't open C:\Users\swoyam\AppData\Local\Temp\Rar$EXa17880.5556\eclipse\plugins\org.eclipse.justj.openjdk.hotspot.jre.full.win32.x86_64_15.0.2.v20210201-0955\jre\lib\tzmappings................"
I have also got the same exception when creating standalone collection and auto-wired section.
I had searched about this exception on google many times but not get the answer.
plz, sir help me to debug this.
GOOGLE
Sir u r awesome "dil dhak dhak hoga"😂😂😂
You prolly dont care but if you are bored like me during the covid times you can stream all the latest movies and series on instaflixxer. I've been binge watching with my girlfriend for the last few months xD
@Ahmed Mack Yea, been watching on instaflixxer for since november myself =)
@@ahmedmack5960 Shut up bot
sir i found two error one is cannot find the config file>>>I put it in src/main/resources and its solved.....second conncection error for that i had to change the url property
ok
What is the purpose of creating StudentDao interface and then implementing it with StudentDaoImpl and overriding insert method? while we can directly create StudentDaoImpl class and write insert method
This is for loose coupling purpose
@@badrinarayanpanda921 Ohk but he didn't explain in detail about this. Just loose coupling doesn't clear anything to me
This is an standard which are using by the industries
hello sir , bean not find error,
Hi Sir hope you will fine Sir I have query Sir when you implementing the insert dao at that time you are getting value why Please Sir Please tell me
That insert method simply returns the number of rows affected along with performing insertion operation...!!
@@urbantech28 Correct Answer
Thora dikkat ho raha h but aap se baat ho pata to shayed clear ho jata
How to insert multiple rows into one insert method
is it necessary to make interface?
we can also do it just by using class
It's uses the concept of Runtime Polymorphism as the implementation of the method can change at runtime with different implementation classes
And yes it provides the concept of abstraction and encapsulation
@ 15:33 to resolve right click on project explorer and refresh it. All will be done nicely.
Sir ye student.java class move hi nai ho raha... I tried many times😣
Durgesh sir apneh joh spring par videos woh enough hai ka freshers koh interview crack keh liyeh?
Yes I am adding more content
@@LearnCodeWithDurgesh thanks sir ...
@@LearnCodeWithDurgesh sir hum fresher s wu expecr tu ni karaing k hamain speing wagera ati hu
Wu tu hamsa expect karaing java jsp servlet wagera aur mcs degree
@@LearnCodeWithDurgesh sir i am facing an issues from past 5 days
WARNING: Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'ds' defined in URL [file:src/main/resources/StudentConfig.xml]: Error setting property values; nested exception is org.springframework.beans.PropertyBatchUpdateException; nested PropertyAccessExceptions (1) are:
PropertyAccessException 1: org.springframework.beans.MethodInvocationException: Property 'driverClassName' threw exception; nested exception is java.lang.IllegalStateException: Could not load JDBC driver class [com.mysql.jdbc.Driver]
Exception in thread "main" org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'ds' defined in URL
and was not able to solve please help me out
can anyone plz tell me the name of this design pattern
template.update() nhi aa rha hai
Kya program file mil sakti hai is video ki #please
sir 1 dought hai studentDao me jdbcTemplate ke getter setter kyu banaye humne
is it necessary
plz reply
Haa woh jaroori hai kyuki hamene database mai values insert karne ke liye code studentDaoImpl mai likha hai...aur woh code run hone ke liye usse database ke parameters jaise ki DriveClass, Url, Password aur Username chahiye...aur yeh parameters hamane Spring Core ki help se .xml file mai jdbcTemplate bean mai daal liye hai using ref tag. Aur .xml file mai hamane jdbcTemplate class mai property tag use kiya hai...matlab studentDaoImpl class mai property injection use kiya hai. Aur property injection use kiya hai toh getter setter bhi chahiye hoge.
@@nehapatil2495 ap job kaha krti I also need job
Sir go wo copy paste krne baad refresh krne se kaam ho jata. Mere sath bhi aisa hota hai, multiple times dikhne lgte h, but refresh krne baad thk ho jata h
Acha mere sath bhi hota kabhi kabhi ...
@@LearnCodeWithDurgesh Sir...bahut baut shukriya sir...aap mere Java ke adhure knowledge ko pura kr rhe h..
Sir maine udemy pr kafi courses ki h but itna effective trike se ni sikh paya tha.
Bean de de bajane ke liye lol
Bhai last packages sent successfully error coming
Idhar pe to ioc container me object manual create kerna pad raha hai.
If anyone facing Loading class `com.mysql.jdbc.Driver'. This is deprecated. error just change "com.mysql.cj.jdbc.Driver" in jdbcConfig.
and if anyone facing database connection issue in intellij in pom.xml change mysql-connector-java version to 8.0.17
Sir why did we used new operator to create student object. We should have used bean instead.
I think because it is not dependency... that's why..and student is a data that would come from client
Why interface use directly use class is it possible?
To make it loosely coupled we used interface here.
I 'm getting this error Cannot invoke "java.util.Map.get(Object)" because "this.serverVariables" is null can anyone help me to fix this.
trying using latest version of mysql connector
sir maine app k channel se hibernate kiya koi dikkat nai hua but yaha Insert data using Spring JDBC bahut dikkat ho raha hai
why
jay bam bole is work while coding 7:45 😄
some guys would have written "datasource" instead of "dataSource" thats why the are getting errors.
Sir improve your naming convention its raises confusion
Sir, I have tried both ways same error, please help me I couldn't find the error.
digiart passion
1 second ago
if you try this today please change driver to com.mysql.cj.jdbc.Driver and mysql-connector-java version com.mysql.cj.jdbc.Driver 8.0.11...or else it will not work
@@digiartpassion8513 brother can u pls tell me how to change the driver
can i know what is the reason for making interface and then implementing with class???
Did you get the answer ?
I also want to know this
There are multiple reasons, some of them are code reusability, multiple inheritance
Why do we create an Interface for DAO, why can't we create the class directly.
Anyway, we are using the DAO interface only once.
Please can someone explain.
@hvbairagi Did you get the answer ?
I also want to know this
Hello sir, I got an error Failed to obtain JDBC Connection, sir please help me
Try to use below dependency for mysql connector in pom.xml
mysql
mysql-connector-java
8.0.18
And also make change in Config.xml for "driverClassName" -
I HOPE, IT SHOULD WORK
sab uppar se gya yrr\
Sir I am getting this error" Caused by: java.lang.NullPointerException: Cannot invoke "java.util.Map.get(Object)" because "this.serverVariables" is null" and I have been trying to fix this error for last 5 hrs .I request to you Sir to help me out to this problem.Or anyone If u have an idea about that please help me out.
Please use the latest MySQL connector maven dependency. I used 8.0.18, it resolved the exception.
@@programminginfo3403 thanks, it's working
Simply right click karenge aur bhagwan ka naam lenge hahahah that's hilarious lolll
Boss please make react and flask video ke liye me aap ko payment Kara doga please 🙏🙏🙏🙏🙏 request
Message me on Instagram
durgesh_k_t
sir 11 minute k baad thoda acche se samjha do, nhi pta chal rha kiska object banke kis me ja rha hai
HI sir, I got an error Failed to obtain JDBC Connection, please help me to correct it.
Update to mysql-connector-java : version - 8.0.11
I am getting same error
@@harshmanola563 which version of my sql connector u r using.?
Getting the same error
@@nitinbisht8575 thank you sir
Sir this is no update option is comes in jdbtemplate. please sir give me solution. I also send you message on telegram plz help me
String updateQuery = "update Student set age = ? where id = ?";
jdbcTemplateObject.update(updateQuery, age, id);
check last 10 roj phle hi maine aapko fb pr kiya hai msz please check sir
sir this problem is created when i run springjdbc please sir i request give me solution
Error creating bean with name 'jdbcTemplate' defined in class path resource [com/spring/jdbc/config.xml]: Error setting property values; nested exception is org.springframework.beans.NotWritablePropertyException: Invalid property 'dataSoucre' of bean class [org.springframework.jdbc.core.JdbcTemplate]: Bean property 'dataSoucre' is not writable or has an invalid setter method. Did you mean 'dataSource'?
same please help me also if you found the answer
bahot confuse kar diYA SIR,NHI SAMJH AAYA
Bhai Itna complex se toh accha hai ke normal jdbc use Karo
4 class se toh accha 4 line hai😅
Confuse krdiya apne
Pattern spelling is incorrect!
Yeh Dao and entities kyon banaya?
For code separation i.e to separate GUI, business logic and data access layer. It is DAO design pattern. You can search about it for more information.
Boht confusing hai..
why do we create different package com.spring.jdbc.dao
how the studentDao is the parent of studentdaoimpl
because studentDaoImpl implements studentDao
JdbcTemplate template=context.getBean("jdbcTemplate", JdbcTemplate.class);
hello sir why i am not able to import JdbcTemplate.please help me
Because maven sometimes dont import specific class automatically ........... hence it is better to use intellij ultimate in order get rid of this issue
same here please help me
Try to update project. Right click on the project name->Maven->Update Project. It worked for me. Hope this helps.
bro u sovled this issue acttualy i also get this issue if you sovled this please ping me
es lecture mein bahut confuse kar diya
Sir aap kabhi reply mh karte
Bean property 'driverClasssName' is not writable or has an invalid setter method. Did you mean 'driverClassName'?
I am not able to solve this error plz help me sir.
same
spelling issue
Try changing the name="jdbcTemplate" to name="template". Since you have given name as jdbcTemplate spring will search for a setter method with name setJdbcTemplate() in EmployeeDao class, but the acutal method you have is setTemplate()
I'm getting error while creating the bean. I did same thing but still getting error. Any help to resolve it.