16.4 Java Database Connectivity Practical Part 3 | insert

INSERT is used to adds new rows to a table. INSERT is used to populate a newly created table or to add a new row (or rows) to an already-existing table. In this case you must insert your fields in the order in which your table is defined.To insert more records, We can just re-use the 'Statement' object with our new values.

Follow on Facebook:

Subscribe to our other channel:
Telusko Hindi :

Subscribe to the channel and learn Programming in easy way.

[yogeshbhatt]

wow... i love PreparedStatement way of insertion.... thanx sir for teaching....

[karanshah]

Thank you sir i was getting the same error and i had made the same mistake i too had pass my query in execute statement and finally you solved it thanks to you.

[health.upgradedbyscience.]

Thanx a million.. your tutorials are helpful!!

[letsgodevs]

I am very new to the java
and you are the best teacher ever for the java

[Arjunganiga]

Hi Sir do you have any tutorial theory on importing CSV file data to MYSQL data base

[sushiltiwari]

Hello sir,
What if I want to save the resultset in Excel or CSV format could you please help here?

[konetivamshi]

Hello sir. How can we insert data from a simple web application using jdbc connection?
can you make a video for insertion of data into database from web application. I have searched for many of videos in youtube, but I didnt find a proper result. Thank you.

[BhatRoma]

Please make a video on "How to execute a database transaction". Thanks.

[nitishjames]

please do make a video on apache poi connection with excel sheet for java selenium

[chiragsharma]

Thank
From Mars
.
.
.
.
.
.
.
.
.
.
-->>Aliens

[dipenbhuva]

proper syntax to use string between query ' "+ String Name +" '

[DharmendraKrGupta-tslj]

Sir, I am using Oracle SQL and IntelliJ,
sir, I also do like you done these videos for inserting data using (?, ?, ?, ?); like this.
only
class.forName change and Connection line URL
please tell me sir please, please...

[ashishpageni]

Hi Navin, how can we do combined add, update and print the result at once?

[jeandamourndatira]

@5:12 Why did you have to put username in single quotes since it is variable name and not a String literal?

[dhamodharan]

sir i need explain about callable statements

[sanjeevchaurasia]

Hello sir. i think the definition of TCL which you told was not correct. Please check and confirm. Thank you

[sumitranjan]

This is easy to connect to database using String url but there are projects where url is not used. Sometimes we have to login to sql server using Windows Authentication. So in that case how can a personwrite the code to run the sql script. In entire youtube and coder community there is no details present related to this concept.

[wwouhft]

im getting errors ..can u please make a video for errors solving

[subhasishhansda]

It's DCL which have grant and revoke commands

[deveshmore]

Exception in thread "main" com.mysql.jdbc.Drivers
at
at
at
at
at Method)
at
at Dbdemo.main(Dbdemo.java:15)




these all are the run time errors