Registration Form using JSP + Servlet + JDBC + MySQL Database Example

[@JavaGuides]

Recommended video tutorials: Login Form using JSP + Servlet + JDBC + MySQL Example at ua-cam.com/video/UBOZgNxsiwA/v-deo.html

[@manutyagi8019]

Good morning sir, I tried to follow your tutorial on registration page using jsp and mysql. Although the registration part is working successfully but in the database I am getting null values in the firstname,lastname and contactname columns. I tried to add latest version of jar dependency file of jsp-api and servlet-api but no change. I would be grateful if you resolve this issue

[@arcsounds4290]

@@manutyagi8019 8i88iiiiiiiiiiiiiiiiiiiiiiiiiiiijiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiilo9uii

[@manipalreddy3378]

@@manutyagi8019 bro i am dealing with the same problem right now , have u rseolved it??

[@javatechnology24]

Perfect example to begin with developing JSP and servlet web application. Audio is excellent and thanks for improving audio quality.

[@chilhoankwon9073]

If you are using mysql connector for My SQL 8.0 later, you should code like this. Class.forName("com.mysql.cj.jdbc.Driver"); If not, you will see class.forname error. Any how, This video is useful. Thank you for your contribution!

[@m77ast]

Dude this is the best Java video on the internet.
Ok I need to follow this guy because the way he did the initial explanation and then the follow up was perfect 10 out of 10 mate.
10 out of 10👏🏿👏🏿👏🏿👏🏿👏🏿

[@sameersingh6809]

mere bhai apne aaj maze maze mein poora sikha diya.....god bless you

[@MarcoQuintanaCastillo]

You´re a great teacher and person!!, finally i does work this program in JEE. Thank you very much.

[@mohanpuducheri6633]

Thanks for uploaded bro......most important and usefull information i suffered min 2 months..... i leared core java and advance java i did not connect to mysql server ..in servelet pages .... your video seen i learned so many information......and i jain the knowledge .....thank you bro............

[@Gaurav-cl8zx]

खरोखर उत्कृष्ट....tutorial ... Keep it up ...

[@rihasanatrofolo2472]

Notes for self:
5:25 - database
10:40 dao - user repo
12:30 13:38 - Servlet
17:20 error
18:23 JSP frontend

[@sowjansagar8026]

Dao implementation done in servlet ? Why not dao impl.? Can you pls let me know

[@loud9327]

Ty man i think Indians are on a different level

[@manohartimothy5825]

It was well explain and wondorful...its what i was looking for ... I wanted to do this kind of application with two severs .there is a lot to learn .... I will be looking forwards to see more of this kind...Thanks Manohar

[@CricFan333]

Thank you sir i completed my first ever servelt project,yes i did copy paste but I will learn end to end and build my own project❤

[@kelvinsankale]

I love it all, thank you very much for the lessons. Am so happy getting these concepts. Glory be to God Almighty.

[@andreme7326]

This tutorial is fantastic! I want to express my gratitude to you, mate!

[@Atulkumar-hi4tf]

worst tutorial

[@shubhamdarge2267]

@@Atulkumar-hi4tf Kyu bhai nahi samjh raha?

[@Atulkumar-hi4tf]

​@@shubhamdarge2267 for biginners its difficult to understand ur coding.
10 line :-
ENGINE=InnoDB..............
Line ka mtlb kya hai ?

[@shubhamdarge2267]

@@Atulkumar-hi4tf Google it, not that difficult to understand, didnt even need to write that ENGINE=.... statement.

[@Atulkumar-hi4tf]

CTt,ঐ,্ন@05871
,

[@ashishraghav5050]

Perfect way of learning and you are the only one who make it easy to understand the structure of working this which no was explaining and they just jump to the coding. Thanks

[@kirankhandade1387]

Hi
HTTP Status 404 - Not Found
Type Status Report
Message The requested resource [/registration-jsp-servlet-jdbc-example/] is not available
Description The origin server did not find a current representation for the target resource or is not willing to disclose that one exists.
Apache Tomcat/9.0.62 (getting this error help me)

[@TipsByJoanna]

You are the best sirr!!!! This tutorial series is perfect , highly recommended. Your website also very important. Keep it up sir

[@jhonedwarmelocaceres8092]

🎯 Key Takeaways for quick navigation:
00:00 🌐 The video focuses on creating a web application with a registration form using JSP, Servlet, and MySQL technology stack.
01:32 🏗️ Model-View-Controller (MVC) design pattern separates application logic from the user interface, with layers for model, view, and controller.
03:46 🧰 Tools and technologies used include Eclipse IDE, JDK 1.8, Apache Tomcat, JSP, Servlets, and MySQL JDBC Connector.
06:05 🏗️ Development steps include creating an Eclipse dynamic web project, adding dependencies, setting up the MySQL database, creating Java classes (Employee, EmployeeDao, EmployeeServlet), and designing JSP pages.
13:46 ⚙️ Configuring Apache Tomcat server in Eclipseand handling HTTP POST requests in the Servlet.
20:17 📝 Designing JSP pages for user interaction and displaying success messages.
21:35 🔄 Handling HTTP GET requests in the Servlet, forwarding requests to corresponding JSP pages using RequestDispatcher.
24:48 🚀 Demonstrating the application by submitting the registration form, storing data in MySQL, and verifying the record in MySQL Workbench.
Made with HARPA AI

[@luongminh8274]

Thank you mate, this video is super helpful for me, literally saved me hours of learning how to build a similar function for my project!

[@JavaGuides]

Glad it helped

[@tthamil]

HI! Bro, clear explanations on how to register webpage in JSP with step by step.keep it up and post more videos on further

[@tejumokshasasapu7629]

Really sir thank youuu soo much....I tried a lot to understand what exactly the flow of those doget and dopost methods but I failed many times..but this tym I got some clarification...thank you so much and hope ur videos will give us more knowledge in different technical platforms.....

[@kirankhandade1387]

Hi dear
HTTP Status 404 - Not Found
Type Status Report
Message The requested resource [/registration-jsp-servlet-jdbc-example/] is not available
Description The origin server did not find a current representation for the target resource or is not willing to disclose that one exists.
Apache Tomcat/9.0.62 (getting this error help me)

[@aqusatabassumsyedsadiqueal5920]

@@kirankhandade1387 the path for jsp is not correct, click on jsp file , do a right click and select copy qualified name in eclipse and paste in on place of /registration-jsp-servlet-jdbc-example/. hope it helps

[@juliyas3811]

Thanks for this video.God bless you&your family.This is useful to improve my knowledge in this word

[@aditipatil8629]

thank u so much.. for such nice video and the source code

[@Sharma2918k]

Hlo
Aapne kon se IDE pe code kiya hai...???

[@nikhilsharma8350]

Awesome content i am starting jsp from now

[@nanabhau_udhan]

Thanks for helping us 🥰

[@delacriox4801]

Going to give an interview tomorrow, this has been like a crash course to me, thanks a lot haha

[@soniaputta1690]

Awesome teaching sir way of explaination is simply super sir

[@katheringarcia5151]

Excellent vídeo .... Congratulations

[@akash0damawale12d]

great video helped me to understand jsp,servlet,jdbc, mvc pattern and mysql database

[@chairocchi]

Thank you for this tutorial although I got stucked most of the time running the tomcat in eclipse. Still managed to finish and run the form. Thanks!

[@ConsulthinkProgrammer]

Try this for an alternative: Login form online without hosting with google apps script ua-cam.com/video/zbH-6r2QjP4/v-deo.html

[@joyramsarkar9212]

Very good job done...i will try and keep u posted

[@minh5532]

Thank you so much , this is the only thing I can say now :))) your videos are so helpful

[@sirichowdhary7118]

this video is very helpful my first task

[@Akash_bhai8477]

Thanks bhai great tutorial ❤

[@amishpapneja23jan]

Very good video. It helped me a lot during my Master's project.

[@MehdiJellali-i9u]

If u r refreshing the sql database and its not inserting any new rows make sure to :
-add the suffix ?useSSL=false&serverTimezone=UTC at the end of the database link which starts with localhost:3306...
-auto index the id in the creation of the database.
-in the database link use ur own database name meaning replace mysql_database with ur own database name in mysqlworkbench.

[@raghuvaran2018]

same issue

[@tanushree0106]

i have followed all the mentioned steps..but it is again not working

[@Balu..official..1199]

Really this video' is more useful to me

[@rafaelfreitas7080]

Thanks, I went straight into JSF + Hibernate from another language so this was all very informative.

[@kamilsolanki1321]

HTTP Status 404 - Not Found
Type Status Report
Message The requested resource [/jsp-servlet-jdbc-mysql-example/register] is not available
Description The origin server did not find a current representation for the target resource or is not willing to disclose that one exists.
Apache Tomcat/9.0.71

[@siddubasha8568]

Getting same error bro, have you resolved

[@yeshwanthkannegundla266]

Change dependency to Jakarta servlet api

[@yeshwanthkannegundla266]

It will work

[@superflyguy231]

idk if you're still checking comments but is there a reason you write your own servlet because I thought that JSP would automatically translate the Java code in the HTML to a servlet script

[@LiveToDanceWithSupriya]

It Helped me alot such a great vedio keep going 👍

[@harishreddy5688]

Thanks for wonderful video 🙂🙂🙂

[@pandiselviravi1857]

Tqq for clear explanation.....keep doing

[@rihasanatrofolo2472]

Thank you brother! Amazing work

[@ivanedsoncallisayalimachi9010]

You are very amazing, thanks for your nice tutorial.

[@TheDanielBarcellos]

For learning propouses it's ok however it's stuck in time so my advice is go learn spring and spring boot tho

[@egos_ua]

thank you for this video, it helped me to solve my problem. Like!

[@SwathiYogaTherapy]

Its very useful ..Thankyou

[@joend_036]

Great content and thanks for sharing.
Why do you thing might be the issue when data are not being stored in the db
coz I have this probleme. Thanks

[@asingh1595]

Thanks a ton! Your tutorial helped me a lot.. :)

[@TheDaniel123789]

Thank you so much it was so helpful sir

[@andraspoljak]

I am getting error
HTTP Status 404 - Not Found
Type Status Report
Message The requested resource [/registration-jsp-servlet-jdbc-example/register] is not available
Description The origin server did not find a current representation for the target resource or is not willing to disclose that one exists.
Apache Tomcat/9.0.50

[@trishaannbrown-santos472]

have you resolved it yet? I have the same problem

[@andraspoljak]

@@trishaannbrown-santos472 Yes, in project preferences project facets version have to be the same than in web.xml file and java compiler should be 1.8 version. Also, clean tomcat server, it keeps the wrong data.

[@aksilaoudia7166]

thanks for the video. please can you tell me how did you add the four dependencies to the lib file?

[@akadeadahot7067]

such a great work sir .Im following hard coded aspect using jsp but this is to easy than previous as i following it. feeling like i studied new thing using opps concept.

[@JavaGuides]

Great. Keep leaning 👍

[@nahassan2000]

Thank you for the VIDEO

[@aftabaliaries]

Very helpful tutorial. Thank you. As I am new to dynamic web development I have a query, I already have static HTML web pages and as I want to convert it into dynamic page so can I use servlet with my existing HTML pages or do I have to convert all my pages to PHP?

[@SanaKhan-hp1oh]

Have u got the answer can u share it?

[@wpatyune1631]

This is good explanation with the mapping where the puzzle put it together, thanks once again.

[@dewanshukumar3816]

Provide me link for downloading required jar files. Its urgent

[@omkarkale3502]

Tysm sir , well explained.

[@blasnunez5493]

is it me or you can just add one employee?
Your video helped me a lot, thaaaaanks!

[@robinkenway]

yah the id is duplicating with hard coded 1, dm me if you find a way to to this

[@lucylocket118]

where do I get the jar files from and how do I add them to the lib folder?

[@zakiinromania]

why you have 2 employeservlet? i don't know why you just skips the video.

[@endeavour8118]

HI Sir, can you also add one installation and setup guide for IDE setup and connecting to database and adding tomcat server in eclipse for development setup

[@maheshpatil7129]

Hi..,
I'm not getting that WebContent folder automatically when I create dynamic web project..?

[@birdofhermes6152]

Thanks for the tutorial

[@sanjanaparab4758]

Please make a video on SpringMVCCRUD example with mysql jdbc

[@haauc4758]

The details are not showing in the table at workbench.

[@vasanthakumare2791]

The data is stored on the database. The table should be created like this. AUTO_INCREMENT should be used for the id.
CREATE TABLE employee
(
id INT(11) AUTO_INCREMENT PRIMARY KEY,
first_name VARCHAR(250) NOT NULL,
last_name VARCHAR(250) NOT NULL,
username VARCHAR(250) NOT NULL,
PASSWORD VARCHAR(250) NOT NULL,
address VARCHAR(250) NOT NULL,
contact VARCHAR(250) NOT NULL
);
DAO class should be like this.
***********************
public class EmployeeDao {
public int registerEmployee(Employee employee) throws ClassNotFoundException
{
String INSERT_USERS_SQL = "INSERT INTO employee "
+ "(first_name, last_name, username, password, address, contact) values "
+ "(?, ?, ?, ?, ?, ?);";

int result = 0;

Class.forName("com.mysql.jdbc.Driver");


try(
Connection connection = DriverManager.
getConnection("jdbc:mysql://localhost:3306/java", "root", "");

PreparedStatement preparedStatement = connection.prepareStatement(INSERT_USERS_SQL);
)
{
preparedStatement.setString(1, employee.getFirstName());
preparedStatement.setString(2, employee.getLastName());
preparedStatement.setString(3, employee.getUsername());
preparedStatement.setString(4, employee.getPassword());
preparedStatement.setString(5, employee.getAddress());
preparedStatement.setString(6, employee.getContact());

System.out.println(preparedStatement);

result = preparedStatement.executeUpdate();

}
catch(SQLException e)
{
e.printStackTrace();
}
return result;
}
}

[@mohammedsaad0761]

why most of the java devs prefer Eclipse IDE. why not VSCode ?

[@shreelakshmi4416]

Because Eclipse is Mainly Designed only for Java developer so...this platform is very efficient

[@sudhakaransudhakaran2718]

​@@shreelakshmi4416 And What about intelliji idle

[@mohsinosmani3089]

Perfect example.

[@FoodLover1309]

I followed each and every step there is no error in code but I get 404 error.. please help me..

[@FoodLover1309]

I run thruogh other browser by putting 'register' name then also it fails.

[@krishna1.097]

You may have probably missed a / in your code before register.

[@Vincent9895]

Great content, thanks, helped a lot

[@martinthabang9621]

In the EmployeeDao, remove id from the Insert_User_SQL. Then remove one of the ? place holders so that there is one less and change your preparedStatement indexing so that getFirstName is at index 1 and not 2 as it is currently. Else, you'll be getting an error because id should be auto incrementing but we've hardcoded it as 1

[@Culer101]

Yes, The id in the table should be auto increment. Else we'll get an error stating duplicate entry as we declared id as primary.

[@supriyabharti664]

very nyc video thanks alot

[@praveenreddy5903]

nice good video for everyone

[@_ifly]

i am trying to create table in workbench but it's gives me errors i don't know why. this is the error
00:37:27 CREATE TABLE `employee` ( 'id'int(3) NOT NULL AUTO_INCREMENT, 'first_name' varchar(20) DEFAULT NULL, 'last_name' varchar(20) DEFAULT NULL, 'username' varchar(20) DEFAULT NULL, 'address' varchar(50) DEFAULT NULL, 'contact' varchar(40) DEFAULT NULL, PRIMARY KEY ('id') ), ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE-utf8mb4_0900_ai_ci Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''id'int(3) NOT NULL AUTO_INCREMENT, 'first_name' varchar(20) DEFAULT NULL, 'last' at line 2 0.000 sec

[@contactbestchoice7553]

CREATE TABLE `employee` (
`id` int(3) NOT NULL AUTO_INCREMENT,
`first_name` varchar(20) DEFAULT NULL,
`last_name` varchar(20) DEFAULT NULL,
`username` varchar(250) DEFAULT NULL,
`password` varchar(20) DEFAULT NULL,
`address` varchar(50) DEFAULT NULL,
`contact` varchar(40) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

[@oliviazhai1831]

thanks so much for the video

[@marcocacciapuoti7264]

davvero utile grazie mille!

[@sandhiyam1713]

Thanks for this video sir

[@apamibrahim1736]

Please sir what of one field does not contain value.will it still load to the database or it throws an exception

[@shambhugautam4146]

i am thankfull to this tutorial

[@vineethkumarbuddi6130]

nice explanation

[@Shadow67947]

Why are you using setters instead of using the contractor? A contractor is used to create objects while the setters are used to update an object. Right?

[@Asifkhan-qt6dy]

This tutorial is fantastic! Thank you for this tutorial
but sir i m not download from github whole code so plz tel me how to download

[@JavaGuides]

There is option to clone or download the GitHub project

[@swetankkumar70]

@@JavaGuides Hi, I don't see any data in the table in SQL workbench after running the project in Eclipse.

[@rickmorty9057]

Hi Ramesh ,
Getting below error , my tomcat server running fine but this path is not accessible via tomcat server Error: HTTP Status 404 - Not Found/[/employeeregister.jsp] not found

[@akshaypendyala]

that page might not be present!

[@rickmorty9057]

@@akshaypendyala Page exist on path bro but still not able to access on server

[@akshaypendyala]

@@rickmorty9057 if you are using servlet, make sure that the annotation or the path you gave in xml are proper!
Yea page might be there but see in which folder is the page present exactly!

[@FoodLover1309]

@@akshaypendyala where is XML in video??

[@akshaypendyala]

@@FoodLover1309 Actually you need to provide the redirect in an XML file! Otherwise, you cannot go from one page to another!

[@NikitaBhagat-zy7ho]

Sir please make a video big new java project using jdbc ,java ,servlet mysql, jsp.

[@vishaldhanokar8138]

do you know in eclipse dynamic project how to enable option of view source & design same time

[@snehalzope1542]

I like it. But where is link to download the project?

[@JavaGuides]

Check video description for GitHub link.

[@vasanthakumare2791]

Thanks for your project.

[@TharaRaman]

Thank you so much Sir.

[@carlosbelludo265]

may I ask why does my sql workbench not update when I register? It says that I registered successfully but when I checked my workbench the user data is still not there.

[@loveshkumar2079]

Sir jsp servet se koi web application banate hn then is ko host krni parti ha ya automatically host ho jate h through tomcat server?

[@dhawantripatil2192]

This tutorial is really good for beginners.. but i am not able to insert into my database though it's not showing any error... pl guide

[@karthikagogineni9073]

same

[@aindrilasaha1592]

same

[@aastha4708]

its not working its showing error

[@sandeepkumar-ks8ys]

This video is very helpful to learn how JSP, Servlet orJDBC work...Sir i have tried same example but I'm unable to insert the data into Mysql DB or redirect it on successful page. I have replicate same code as it is as you have done in this video. Sir ,can you please help me to resolve my issue :how to redirect the page after successfully insert the data into db.

[@tanushree0106]

same issue...did it resolved for you?

[@mahigupta1983]

same issue plz help i m a beginner

[@brijeshmishra1744]

How do we read from database and display the same on JSP

[@aqusatabassumsyedsadiqueal5920]

my mysql database is not getting updated like yours? what could i be doing wrong

[@ChaitanyasWorlds]

very helpful tutorial....Thank you sir ........sir can you make crime record management system project using mysql databse and STS/Eclipse ..like this project step by step...please sir

[@imwallet3272]

Sir, .jsp portal secured or .net portal secured (For Transactional purpose) please suggest..

[@krishanpalsingh1587]

How to add jar files in lib folder

[@PS00011]

C: Apache : lib: servelet.jar copy path and paste in lib of webapp

[@surajmohanty2135]

Sir the form is also made and while entering data also it is showing Employee successfully registered but in MySql the date is not showing

[@luckynbeautygurl]

Then how to make the appearance of the web have CSS ? can u tll us?

[@mnaveen369]

why we should we add register in the last at the browser