3. How to Insert Data into Database using PreparedStatement in JDBC.
Vložit
- čas přidán 25. 02. 2021
- Let's understand, How to insert data [Entered by the User] into database using JDBC and PreparedStatement in java. In this session, we will see how to use PreparedStatement interface in JDBC and how to set dynamic data to PreparedStatement insert query.
In this session, I have discussed following points.
1. What is prepared statement in JDBCin java?
2. How to insert values into table using JDBC and PreparedStatement?
3. How to set dynamic values to PreparedStatement query which are entered by the user?
Disclaimer - The music/audio used(if any) in this video is not a property of "Learn Programming Yourself". All credit goes to owners of respective music/audio. This music/audio is not prone to any "Copyright Strikes".
--------- Links to my other FREE courses. ---------
▶ Java 8 Full Course - • Java 8
▶ JDBC Full Course - • 1. Introduction to JDB...
▶ Microsoft Cognitive Services Course - • Computer Vision + Angu...
▶ JWT in Spring Boot and Angular - • How to download and in...
▶ CRUD Operations in Spring Boot and Angular (Full Stack) - • 1. Angular 16 and Spri...
▶ Console Based Banking Application Using Java - • Developing Console Bas...
▶ E-Commerce Application Development Using Angular and Spring Boot (Full Stack) - • 1. Developing E-Commer...
Successfully inserted Values into the table!
Thank you! so much sir!
Glad it helped!
Very Nicely Explained ......
एकदम भारी 👍👍
थँक्स भावा व्हिडिओ बघितल्या बदद्ल. मराठी मधून कंमेन्ट बघून एकदम भारी वाटल बघ
You explained well and easy to understand the concept...
thanks a lot🙂
Great explanation good job.
Thank you
Thank you for the excellent explanation.
Thanks a lot 🙂
You really explained very well bro... Thanks for your Support...🤝🤝
Thanks a lot.
Dear Sir,
I Thank you for your valuable guidance.
Thanks a lot
Thanks a lot🙂
Thank you! Very Much Sir!, Such a wonderful Explanation
Thanks and welcome
Awesome explanation !!
Thanks a lot!!!
Very nice thanku sir🙏🙏
Thanks a lot
Outstanding
Thanks Atharva
Thankyou bhaiya ..❤️❤️
Thanks a lot Nikhil.
bhaiya could you please help me.. i am getting error : - Exception in thread "main" java.lang.RuntimeException: Something went wrong
at com.jdbc.student.StudentDatabase.main(StudentDatabase.java:36)
my database name is correct , everything is done according to your concept.. then why this errors are coming. please help asap. thanks
I need to take a look to code in order to help you
@@LearnProgrammingYourself Thanks bhaiya..but the problem got resolved... Actually i was giving wrong password that's why i faced this issue. But anyway..your course was too much helpful. Thanks.
Ohh great
❤❤
Thanks a lot.
I have error in private static Connection connection=null;
Sir, you explained very well but eclipse is not allowing me to add external jar files, I followed exact steps as you said, please help!
Not sure. Need to check
Instead of only raj how can we add multiple names, percentage address...at a time?
where will we get the driver name that you have added in the start?
It is fixed. You can use same that I have used.
mere me to java.lang.null pointer exception how to resolve that
just check the connection
why to add IntegerparseInt when we are entering direct Integer datatype??
Yes your question is correct. Actually this is one of important concept that we need to understand. I will try to create one session on this.
Someone please help on how to connect to Oracle database and call a stored procedure?
Yes I will try to help you on this
If I watch this whole series , is it sufficient for whole jdbc , have you covered all the concepts.
Yes. From practical perspective JDBC is nothing more than what I have covered in this series. If we talk about interview then most of the questions will be around these concepts only.
@@LearnProgrammingYourself ok I really appreciate you .. because this is one of the best series nowadays I did not find like this kinda videos on youtube I searched a lot but in vain but at last I end up with this serie .
If there is any more concept related to jdbc so make it full. It l really going to good in future 👍👍
Thanks a lot @Nikhil. Glad to hear this. Your few words will really motivate me towards my work.
Thanks a lot again.
Sir, I request you to upload playlist on servlet, Javascript and MVC as well because no channels are there which explains like you
Thanks Atharv. Surely i will try to upload it soon
Bro have you added this code on github or somewhere?
I am really sorry. I haven't added this code to git but if I find this code now then I will add and share a link.
sir, for me the issue is "java.sql package is not available",please help me
That should be because you are missing required driver.
Sir I have a doubt in jdbc connectivity sir could you please resolve this .....
Hlo sir I am waiting for your reply sir ....
What is the exact issue??
Can we consider this as a project or not?
Yes you can consider this as project
You have goofed up one of your mistake in the video. Whatever reason you mentioned for error, it was not correct.😂 Anyway, everyone makes mistakes and have doubts and confusion while writing codes. Good job. Keep it up.
Thanks Sandip for letting me know on it. I will take care from now itself.🙂
Class. ForName is a exception one
What is the exception?
@@LearnProgrammingYourself recoverable error
need to check the code.
how to set date format in prepared statement
you can use date formatter in java
Exception in thread "main" java.lang.RuntimeException: something went wrong
at jdbc/com.jdbc.student.StudentDatabase.main(StudentDatabase.java:36)
its showing this . can you please help
Can you check your mysql database url?
I don't know how to get the url..
Means I have copied urs.and changed the name at last
jdbc:mysql://localhost:3306/test
The exception is at line 36 in StudentaDatabase.java.
Can you send that line here? I will check what is wrong exactly
And what is in try block?
I am getting java.lang.Runtime Exception see MySQL line 1coming...
Can you please see if the data is getting sent in the required format?
Or put the whole exception message here.
Data base connection done in Driver small d has given
Sounds cool👍👍
I have error in Exception thread main java.lang.RuntimeException please help me please
if you share me some details like where exactly you are getting exception then I can help.
Can you give me your e-mail id
Where i can share the details tell me it's urgent please
If possible you can share me github repository link so that i can look. Or you can directly share me zip file of your project via email. Email id is mentioned in about section of channel
Email id not found in your about
How to dynamically enter the table name also?
We can give. but we should not use this approach.
sir plz help me in this one.
Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
enter choice
1. Insert data
1
inside insert record()
Exception in thread "main" java.lang.NullPointerException: Cannot invoke "java.sql.Connection.prepareStatement(String)" because "com.jdbc.student.StudentDatabase.connection" is null
at com.jdbc.student.StudentDatabase.insertRecord(StudentDatabase.java:42)
at com.jdbc.student.StudentDatabase.main(StudentDatabase.java:29)
I think you are not assigning value to the connection and that’s why it is giving null on connection object. Make sure you are assigning value to the connection
null values are inserted instead of actual values
plz help
Hi Disha, There are couple of ways to handle this case.
1. Can you please try to print the values before inserting? So that you can make sure you are getting input correctly.
2. First of all try to insert hard coded values?
I hope it will help. Please let me know if any help is required.
@@LearnProgrammingYourself thnx .. turns out it was a silly mistake... Name of variables in java and database were not same
That sounds really cool. Thanks Disha
it says StudentDatabase cannot be resolved to a type
If you share me that code line then I can try to fix it
can you pls share the src
I lost that code😅
Sir need to contact you urgently, whats the best method?
You can connect me over email.
varadraj.vinod.kulkarni @gmail.com
jdbc connection in Java EE
Sir Please help me
What's the issue?
Sir facing error since last 3 days can u please help !!!
Are allow issues resolved Aditya? will check your recent email.
PLease help me
I have a error
Please let me know, what is error?
Can you please help me
Sure.
why are you declaring Scanner as private.
Because I don't want to use it outside of this class.
sir please source code comment kardo
The fact that you gave 78% to Sonali, proves that she's your Sister🤣. Am I right?
😂😂😂
Hii
Please let me know, what is error?
Exception in thread “main” Java.Lang.runtime exception:some went wrong at com.jdbc.student.studentdatabase. Main (StudentDatabase.Java:27)
Plz reply and help me
Can you send me the code where your are inserting values?
This exception must be because url of database or column and value mapping.
@@LearnProgrammingYourself
package com.jdbc.student;
import java.sql.Connection;
import java.sql.DriverManager;
import java.util.Scanner;
public class StudentDatabase {
private static Connection connection = null;
private static Scanner scanner=new Scanner(System.in);
public static void main(String[] args) {
StudentDatabase studentdatabase=new StudentDatabase();
try {
Class.forName(" com.mysql.cj.jdbc.Driver");
String dbURL="jdbc:mysql://localhost:3306/jdbcdb";
String username="root";
String password="Lipan@1234";
connection=DriverManager.getConnection(dbURL, username, password);
System.out.println("enter choice");
System.out.println("1. insert record");
int choice=Integer.parseInt(scanner.nextLine());
switch(choice) {
case 1:
studentdatabase.insertRecord();
break;
default:
break;
}
}catch(Exception e) {
throw new RuntimeException("some went wrong");
}
}
private void insertRecord() {
System.out.println("inside insert record()");
}
}
Sir this is my code plz go through it
I send you plz check and reply
I’m waiting for the replyw
@@LearnProgrammingYourself
Sir please reply....
Are you sending the link?
getting this sir Exception in thread "main" java.lang.RuntimeException: Something went wrong
at com.jdbc.student.StudentDatabase.main(StudentDatabase.java:38)
Please check your connection references
@@LearnProgrammingYourself can you connect in a meet and help me out sir
Yes we can connect. Please ping me your details on my email id so that I will schedule a call.