A Simple Jsp Servlet Jdbc User Registration Example using Tomcat Mysql and Eclipse

A Simple Jsp Servlet Jdbc User Registration Example using mysql database, tomcat server and eclipse. Registration using jsp and mysql.
Step by Step User Registration tutorial using Jsp, servlets and database connectivity.
The control goes from the jsp registration page to a servlet on submiting the form. The servlet further talks with a dao class which contains jdbc code to insert data into the mysql database server.
For Source code with stpe by step instruction of this example check www.javatutoro...
For personal online java training please visit www.javatutoro...
A Simple Jsp Servlet Login Form Example • A Simple Jsp Servlet L...
ServletConfig & ServletContext Practical Example on a Project • ServletConfig & Servle...
A Simple Servlet example using Tomcat and Eclipse. • A Simple Servlet examp...
SendRedirect Vs RequestDispatcher • SendRedirect vs Reques...

[@nishantgholap5103]

Currently running 2022 and javax is replace to jakarta but your code is perfectly run without single error so special thanks to you... 🙏

[@JavaTution]

Thanks

[@anuraagsan6129]

The only video I watched in the past 1 month that gave clear explanation and is actually working!! Thanks a lot sir. Keep up your good work.

[@JavaTution]

Thanks

[@rewrose2838]

Thank you so much for the to-the-point explanation and walking through the coding process. This is the best video I've seen after learning about Servlets and JSP.

[@icethequeen6252]

i stuck in simple syntax of connecting jdbc..............after watching ur video its resolved tq so much

[@vaishnavipudari775]

Thanks a lot sir....your explanation is very cleared....this is the best RUclips video

[@Adventure581]

I had understand better than my class 👌👌 Thnx sir

[@Adventure581]

Keep going on

[@BhanuprakashArani]

No words ....Thanks a lot

[@CSENARRARAHULKUMAR]

Sir,Thank you soo much sir with help of this code i had connected mysql successfully with help of jdbc.

[@zyairekarson3334]

Instablaster.

[@saipranithsunny]

Bro can I get the code once....

[@abhilashreddy0072]

Bro PlZz can u tell me how did u do ??

[@rahulkumarnarra]

@@abhilashreddy0072 first connect the ecillipse idle to tomcat server and connect to MySQL server with help of JDBC then try to connect abhilash

[@lilaiyang5745]

You just saved me! Thanks. Please keep doing more videos.

[@ammar_anwar]

Thanks a lot sir 😇😇😇
I used Oracle instead of MySQL … it worked perfectly fine

[@JavaTution]

Thanks

[@arbaazfaruqui8318]

Thank you so much for the beautiful explanation

[@AbhijitRoy-tx5rz]

this works fine...thumbs up to Sir. Brilliant explanation..

[@saipranithsunny]

Will uh share me the code once...

[@codeKeshav]

NICE, EXPLANATION, THANKS

[@pradeepr760]

Super .....Pls make more vedios

[@cockybhai3638]

Awesome sir worked perfectly 👍

[@saipranithsunny]

Can you send the code...

[@likhitajain6799]

Your videos are really good...do start your tutorials..it will be a great help

[@developernilesh]

Awesome video🎥

[@GauravKumar-jc5um]

i got will be a great help... So Thank you so much

[@bilelmlawhia]

very good explaination thx

[@funmagic6362]

Thank you so much sir 🙏🙏🙏🙏🙏

[@sandeepnegi4240]

Thank you this video is really helpful

[@alexchan7642]

This is GOLD!!!

[@JavaTution]

Thanks

[@rukshandewage1892]

Thank you very helpfull

[@albertozanovello7140]

u are my hero

[@gauravbonde9304]

I got following error HTTP status 500- Internal server error (Cannot invoke "java.sql.Connection.prepareStatement(String)" because "con" is null) How to solve this? plz help me.

[@raogaru306]

Nice

[@vanshikabhujang2014]

I am having the error "registration/Register not found" can anybody tell me why the memberRegister.jsp page is not able to find the servlet page?

[@abhisprincess]

Anyone help i have error in con. Is null
Cannot invoke "Java.sql.Connection.prepareStatement(String) because con is null
Please tell me wt to do to solve this error

[@manaspradhan9166]

Thank u so much sir

[@taykeiths]

Thanks alot!!!!!!

[@BabaBabaji]

superb sir

[@JavaTution]

Thanks

[@ankitdagar7573]

Thank you so much sir, :))

[@programming3078]

hi sir why do we get served at: / register error? Looking forward for a reply, Thank YOU!!!

[@sj4876]

Thank you

[@notyourtype8596]

All is good, And Also after registering it also shows the data entered successfully message but the details are not able to save in my sql....
Pls reply

[@riadosani9437]

i have created dynamic web project but java resource folder is not available there plz if anyone know what to do then plz tell me

[@askmehowtodoit]

I have a small doubt, After Successfully entering the data in to a my SQL , if I come back , my form data is as it is , so the form should be clear .
For that what can I do????

[@varnikajain6003]

In member class when u created constructor using field
And deselected all
How the getUname and further set method are automatically generated?
While in my code only super(); is created after the procedure.
Can u help me with that.?

[@sidheshbhambid4023]

Right click, Go to Source>>Generate Getters and Setters

[@anusritichoudhuri1268]

Register is not available. How to resolve it?

[@Official-dev0503]

Error .. resource Register is not available

[@liliyagoldman4580]

prepareStatement(sql) undifined?how i fix?thank you . this will work/(java.sql.Connection) con)

[@akhilagopinath5210]

sir can you please tell me, which eclipse you are used

[@shubhamverma312]

Sir i got an error after entering data in web page that "requested resources is not available"

[@niteeshvishwanathponnuru530]

It shows like served at:/ registrationform

[@vaishnavipatil8081]

While running the final project, I am getting internal server error. What should I do?

[@ECE-xp5ws]

Nice explanation but you didn't explain about web.xml file ,which is one that maps the servlet with jsp

[@vikassingh-yr8fn]

I am getting an error:
SEVERE: Servlet.service() for servlet [Register] in context with path [/Registration] threw exception
java.lang.NullPointerException
at RegisterDao.insert(RegisterDao.java:40)

[@rajshekar1922]

same for me.. did you resolve?

[@kavyakolli4100]

@@rajshekar1922 I am getting the same error, did anyone resolve this error?

[@sayan1193]

I think this error is due to request.getParameter() throwing a null pointer exception, if you handle the null pointer exception by checking if the value is null or not it should work

[@DWEthiopia]

@@sayan1193 How do you handle the null pointer exception? Can you provide the code?

[@shahzalal8147]

How to solve this problem:
Cannot invoke "java.sql.Connection.prepareStatement(String)" because "con" is null

[@manishgowdans136]

Same??

[@shahzalal8147]

​@@manishgowdans136 yeah boy!

[@manishgowdans136]

U got the solution??

[@shahzalal8147]

@@manishgowdans136 yes.

[@manishgowdans136]

Can you share it please

[@joyramsarkar9212]

Thanks a lot..just a request- could you please share source code please?

[@abhilashreddy0072]

Can u keep unit testing also for these

[@tamilrockerz4377]

it displaying data not entered i tried every possible way i hope so

[@chganesh4010]

hi sir ur explanation is wonderful sir. i want to practice this example can u please share this code if possible in any of ur github or anything.

[@shwetaphougat]

Here is used my sql or not?

[@karthikvelumani1561]

The method prepareStatement(String) is undefined for the type Connection
I'm getting this error
some one hlep me

[@manishsharma-tw6hz]

you have to add a libraby for that, click on 'x' and it will suggest you the required library

[@thegreekdeal4747]

Very good video and explanation and i follow what you did but i get message data not entered.Error "Column count doesn't match value count at row 1". Can you help me please?

[@sanketbhole5876]

Sir could you please help us to deploy this code on online platform so that it can be accessible using the link.

[@abhilashreddy0072]

Hlo sir could u PlZz tell how it's going and storing in MySQL database it's urgent sir

[@vincMaCcmane]

It's good but why are doing it so fast

[@amtraveldiaries]

even though java connectors jar file is in classpath, i am getting this exception - java.lang.ClassNotFoundException: com.mysql.jdbc.driver
Any suggestion to resolve that?

[@sakshimathur8526]

Change the sql statement as follows and try:
String sql = "insert into table_name(column1,column2,column3,column4,column5) values(?,?,?,?,?)"
It works for me

[@theuser7288]

Same happens with me

[@manishsharma-tw6hz]

"com.mysql.cj.jdbc.Driver" try this

[@asharani5018]

How an Http request coming at port 80 is forwarded to port 8080 of tomcat

[@ushavarma5670]

Hlo sir I have a small dout

[@ManuelPerez1406]

I don't really understand why you created the member class :(

[@0324055289]

just to use OOPs concepts and send a single object instead of calling the insert function with 4 parameters. Both methods are valid.

[@aishuuppal5129]

Sir m facing 404 error in server ....I have checked evry possibility of solving it I did also but also it's showing...
Please give any suggestions

[@kumariradhika881]

Type the name of your jsp file at the end of url tom cat server. Hope it helps.:-):-)

[@l.k.lavanya8789]

Sir, can u send the source code .

[@yancoder20]

How to use xampp's tomcat as server on eclipse?

[@saiprasad1103]

Con is null showing error

[@batuhans.5120]

java.lang.NullPointerException: Cannot invoke "java.sql.Connection.prepareStatement(String)" because "con" is null how can i fix this error?

[@sujeevanvengat7914]

r u clear this error bro

[@sujeevanvengat7914]

please help me :
Message Cannot invoke "java.sql.Connection.prepareStatement(String)" because "con" is null

[@batuhans.5120]

@@sujeevanvengat7914 I fixed 5 months ago but I didn't remember :(

[@ihetihet7187]

thx sir,
please link to download MysqlWorkbench

[@sakshigupta6820]

Sir dynamic web project ka option hi nhi arha

[@JavaTution]

Use eclipse for EE developers

[@veeramsettikadali8816]

I have 404 errorwhile run these code

[@garvSensei999]

can you do it without using java file.. use jsp files only

[@JavaTution]

Yes can be done

[@garvSensei999]

@@JavaTution i did but i couldn't able to use mysql properly.. i created a table in mysql and inserted some random entry like user name and password and I tried to login using that data but it was showing me the class file name only on a web page maybe something wrong in coding or mysql connection

[@muzammil0420]

Sir source code mill skta???

[@star-devil9157]

sir i need this program please give me sir 🧡🧡🧡🧡🧡

[@ShahrukhKhan-tu9wo]

import com.sun.java.util.jar.pack.Package.Class.Member;
this file is not getting imported , so Member class isn't working, I tried to find this jar file but couldn't.

[@chaitanyasadaphal1272]

Import java.lang.reflect.Member

[@karthikvelumani1561]

public String insert(Member member)
{
loadDriver(dbdriver);
Connection con=getConnection();
String result="Data Entered successfully";
String sql="insert into userdb.member values(?,?,?,?) ";
try {
PreparedStatement ps = con.prepareStatement(sql);
ps.setString(1,member.getUname());
ps.setString(2, member.getPassword());
ps.setString(3, member.getEmail());
ps.setString(4, member.getPhone());
ps.executeUpdate();
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
result="Data not entered";
}
return result;
I used the same code...
but still getting this error

[@chaitanyasadaphal1272]

Error while getting member.getuname

[@sakshimathur8526]

import member class

[@manishsharma-tw6hz]

user member instead of Member

[@Er.MeetPatel]

Thank you so much sir