Insert data into SQL server using java Part -2

Insert Data into SQL Database with Netbeans | Insert data in SQL from TextField, RadioButton, CheckBox, ComboBox using Netbeans | insert data java
For Part 1 : • Insert data into SQL s...
Channel Subscription : goo.gl/FZrbXg
Affilate: amzn.to/2DPwG8d
Find all the videos in the playlist: • Java programming train...

[@indrasubedi]

Hello My Brothers and Sisters. My humble request to you, *Please* *Don't* *Forget* *To* *Subscribe*
If you have any problem, Comment down. I will provide you solution as soon as possible.

[@hamza_Travel]

provide the source code of insert data

[@computerbolter4079]

Thanks Bro!!! Really Helped.

[@kaderadam7543]

Indra ... Thanks a lot. Mr INDRA, you are really so genuine person. You are one of the most understandable lectures in the world... or educators. Again so thanks. Apart from that, I was creating Mini-system softwarwe , I decided to flow your way of developing systems. During building of my system .... Form's Table is not running or compiling, when I put the name of table under IniComponent, but your it fantastically InitComponent working. INDRA , please help me as to solve that problem.

[@-indeed8285]

thank you very much... you are amazing. it help me a lot to start my project.

[@indrasubedi]

Thanks for your feedback

[@varshaps6010]

tnks a lot sir..its worked fr me..

[@antoniovela2498]

MANY THANKS, U SAVED MY DAY!

[@gnaneditz]

Ok thanks

[@indrasubedi]

Thanks for your feedback

[@alexismontales7731]

You're the BEST!

[@indrasubedi]

Glad to hear your feedback

[@rorymcdonnell3490]

Hi Indra,
Love your videos. Followed your tutorial here, but when i click save I get the following error message in the console:
"Exception in thread "AWT-EventQueue-0" java.lang.UnsupportedClassVersionError: com/microsoft/sqlserver/jdbc/SQLServerDriver has been compiled by a more recent version of the Java Runtime (class file version 53.0), this version of the Java Runtime only recognizes class file versions up to 52.0"
I'm using jre9.jar. Any idea why this would be happening.

[@kesselokinga9554]

Thank you so much.

[@indrasubedi]

Thanks for your feedback

[@zeezze9852]

I use mysql 3306 from web site not the program u use and i have error in sql syntax what should i doo

[@ainasyazwani9271]

Hi, I do the same like you for the check box, but it only save the last box i tick. May i know why it happens? Thank you

[@sagarbogati5907]

Nice videos.

[@kevintenorio4847]

THANKS YOU BRO REALLY!!!!

[@MohitSharma-gu1iy]

I am trying to connect my java application with database to insert data with my application but it shows Run-time error of "Package Import Java SQL doesn't exists". I already defined at the top....

[@mu6corner595]

Thankyou so much

[@indrasubedi]

Thanks for the feedback

[@buivanthinh4167]

Thank you bro

[@sayuogiwara632]

Thank you:33

[@wooanghwee4255]

thank you for the sharing. it help me alot. so how can i retrieve it back to the form as checkbox is check from DB thank you

[@Surekhasrinivas144]

thank you so much
h bro

[@indrasubedi]

Thanks for the feedback

[@superviper341]

it worked ty :P

[@indrasubedi]

+Waqar Wahid Thanks for your feedback

[@himanshibohare5387]

thank u Bhai

[@indrasubedi]

Thanks for your feedback

[@rayhanulislam1675]

thanks bro

[@joelkaseya4388]

thanks man

[@smrutirupasahu9251]

Thank you soo much

[@indrasubedi]

Glad it helped!

[@user-oj4xf1rw8x]

شكرآ

[@tasnimhasan8780]

I am always getting an error for using combobox. It says that the value is not set for parameter 4. In parameter 4 I have used jcombobox.
Please kindly help me.

[@syfulislam2543]

i am having a problem please reply. when i pressed gender option which is male or female it inserted data even if i not put data on other boxes. why is that.please help

[@namratakataria2785]

if we open netbeans again will same functions work again?

[@gnaneditz]

Can you give us tutorial how to add images to SQL server from netbeans

[@indrasubedi]

You will have that video soon.

[@jags532]

Please make it with jsp, servlet with mssql for CRUD

[@shalomoludapo7679]

Tnx bro
my desktop application is not still connecting to the database even after creating admin console and pinging
what should i do

[@indrasubedi]

Which authentication mode are you using in sql server?

[@shalomoludapo7679]

Administrator
tnx so much ...It is working well now
how do you deploy desktop application

[@akshaykumbhar1905]

Hey bro i did the same u did ...but the code is not working yet...plzz help

[@pournimakota1495]

hello,
i want to know the logincheck.java code also can you provide me.

[@rupertacuesta]

Where did u get the try catch code? And you didnt show when you made the LoginCheck.java

[@indrasubedi]

Watch my previous video

[@sunnyaahil166]

when we use the DataType int than what use in query where we use " ? " in the query?

[@indrasubedi]

Find help form here:
stackoverflow.com/questions/14742246/inserting-numeric-data-type-using-sql-statement-in-java

[@AsadKhan-it4mu]

when i press ok java.lang class not found com.microsoft.sqlserver.jdbc.SQLServerDriver

[@indrasubedi]

Have you download and use java ans sql server connector?

[@AsadKhan-it4mu]

yes its 4.0 jdbc
n im using netbeans 7.2

[@AsadKhan-it4mu]

connection test was succesful

[@mohammadrahil6417]

how u did auto increment of sno.?

[@indrasubedi]

Its done from the database. When user enters data to database the value increments automatically while saving new record. You can do this by making identity specification to yes.

[@mohammedusmaneghani531]

Thanks for the video, can you please help me with a few things? whats the best way to contact you? thanks

[@jenifferjenni7131]

Why does" sno doesn't have default value" error mean

[@akhileshkumarmishra3617]

Jpassfiled ke liye kya java SQL code likhu bro

[@darksideofthemoon3185]

after I click save button it shows a message which says "The index 1 is out of range"
what should I do?

[@indrasubedi]

Be sure to check what size of data value you are going to insert in database. If the error continue mail me your code at [e-mail]

[@darksideofthemoon3185]

I fixed it, thanks for replying

[@darksideofthemoon3185]

I forgot to add placeholders :))

[@alvarobasilys]

can u help me, I have same trouble..

[@ajith_hegde]

if we give null values also it will get stored in database

[@indrasubedi]

You need to validate all the textfield and related field. For the concept to validate watch this:
czcams.com/video/wZQc1Nct0-s/video.html

[@ajith_hegde]

@@indrasubedi tanq bro

[@sunnyaahil166]

how we reset check button....when click on reset automatically uncheck the all check button...

[@indrasubedi]

For Checkbox use:
coreJava.setSelected(false);
python.setSelected(false)

[@sunnyaahil166]

ok thnkx

[@mohitbaghel6054]

where is the event handling of save????

[@isiahcharles6804]

Mr. Indra, how do i solve the " invalid column name 'name' " ??

[@indrasubedi]

It means that the COLUMN Name mentioned in the sql is not matching with the table ( Tables that are mentioned after FROM clause ) columns.
Try:
Check your sql , you might have mis spelled the column name.
You might have wrongly tagged the table alias with the column.
Or you have written a wrong column name that doesn't corresponds to the table.

[@isiahcharles6804]

Thankyou Mr Indra!!
but how about the incorrect syntax near the keyword 'user'.
I promise i did your step in the video from the login to the part 2 and there is still an error in my program.

[@indrasubedi]

@@isiahcharles6804 send me your code on [e-mail]

[@isiahcharles6804]

@@indrasubedi Okay mr indra

[@AsadKhan-it4mu]

canot find symbol gender what to do ?

[@indrasubedi]

Watch from 4:20 . you havent declare String variable gender

[@AsadKhan-it4mu]

Thanks Alot

[@grumpyplays5886]

Laptop keyboard ASMR

[@computerbolter4079]

Is there any way to remove any wrong entry form the database?

[@indrasubedi]

Yes there is. You need to update the data or delete the data. For update and delete you can find the video in my playlist.

[@lakshmisheshadri6263]

What is syntax for int value
Like pst.setString(1,name.getText());

[@indrasubedi]

pst.setInt(2, Integer.valueOf(price.getText()));

[@KunalKumarSingh-wr1kg]

its not working

[@pradhumanarya5039]

in radio button code it show "male is not resolved as a variable" help me plz

[@indrasubedi]

Did you declare string variable for gender? Also the radio button name should be male and female.

[@pradhumanarya5039]

Indra Subedi yes i declare

[@indrasubedi]

Send me your code on [e-mail]

[@pradhumanarya5039]

Indra Subedi i was send my code plz give me solution

[@indrasubedi]

Check your mail

[@judy-annpena3317]

There is no error but there is no output on the SQL server. help?

[@dullknife01]

Hello, have you find a solution to this?

[@dullknife01]

pst.executeUpdate(); was missing

[@computerbolter4079]

Which Screen Recorder Do You ????

[@indrasubedi]

Its camtasia

[@computerbolter4079]

Thanks...

[@apjtv3887]

@@indrasubedi i need this please share link of full vervion with me in google drive

[@princephilipmabesa213]

first one! ^^

[@indrasubedi]

+Prince Philip Go to my videos, you can find there

[@nita5307]

សង្សាអ្នកណាសង្សាសំខាន់ខ្ញំុស្រលាញ់នាង

[@02_sayali_aundhkar22]

Thank you so much.

[@indrasubedi]

Glad to hear your feedback