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

[@BhanuprakashArani]

No words ....Thanks a lot

[@codeKeshav]

NICE, EXPLANATION, 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.

[@vaishnavipudari775]

Thanks a lot sir....your explanation is very cleared....this is the best TH-cam video

[@icethequeen6252]

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

[@Adventure581]

I had understand better than my class 👌👌 Thnx sir

[@Adventure581]

Keep going on

[@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

[@arbaazfaruqui8318]

Thank you so much for the beautiful explanation

[@ammar_anwar]

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

[@JavaTution]

Thanks

[@AbhijitRoy-tx5rz]

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

[@saipranithsunny]

Will uh share me the code once...

[@Er.MeetPatel]

Thank you so much sir

[@pradeepr760]

Super .....Pls make more vedios

[@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?

[@developernilesh]

Awesome video🎥

[@cockybhai3638]

Awesome sir worked perfectly 👍

[@saipranithsunny]

Can you send the code...

[@lilaiyang5745]

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

[@raogaru306]

Nice

[@likhitajain6799]

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

[@GauravKumar-jc5um]

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

[@funmagic6362]

Thank you so much sir 🙏🙏🙏🙏🙏

[@sandeepnegi4240]

Thank you this video is really helpful

[@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.

[@bilelmlawhia]

very good explaination thx

[@albertozanovello7140]

u are my hero

[@alexchan7642]

This is GOLD!!!

[@JavaTution]

Thanks

[@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

[@shinoyshaji]

Thanks alot!!!!!!

[@rukshandewage1892]

Thank you very helpfull

[@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!!!

[@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

[@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

[@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

[@liliyagoldman4580]

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

[@sj4876]

Thank you

[@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.

[@Official-dev0503]

Error .. resource Register is not available

[@anusritichoudhuri1268]

Register is not available. How to resolve it?

[@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????

[@joyramsarkar9212]

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

[@ECE-xp5ws]

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

[@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?

[@akhilagopinath5210]

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

[@vaishnavipatil8081]

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

[@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?

[@shubhamverma312]

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

[@abhilashreddy0072]

Can u keep unit testing also for these

[@tamilrockerz4377]

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

[@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

[@sanketbhole5876]

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

[@asharani5018]

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

[@yancoder20]

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

[@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 :(

[@abhilashreddy0072]

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

[@shwetaphougat]

Here is used my sql or not?

[@l.k.lavanya8789]

Sir, can u send the source code .

[@ihetihet7187]

thx sir,
please link to download MysqlWorkbench

[@vincMaCcmane]

It's good but why are doing it so fast

[@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

[@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.:-):-)

[@saiprasad1103]

Con is null showing error

[@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

[@sakshigupta6820]

Sir dynamic web project ka option hi nhi arha

[@JavaTution]

Use eclipse for EE developers

[@star-devil9157]

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

[@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

[@muzammil0420]

Sir source code mill skta???

[@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

[@chaitanyasadaphal1272]

Error while getting member.getuname

[@sakshimathur8526]

import member class

[@manishsharma-tw6hz]

user member instead of Member

[@manaspradhan9166]

Thank u so much sir