Java Spring MVC and JDBC CRUD Tutorial (Web App using Eclipse, Tomcat, MySQL and JUnit)

Learn how to develop a Java web application to manage information in a relational database using Spring MVC and Spring JDBC. You will see how Spring simplifies writing code with JDBC.

- Sofware programs used: Java Development Kit, MySQL Community server, Apache Tomcat server, Eclipse IDE.

- Technologies used: Spring framework, Spring MVC, Spring JDBC, Java Servlet, JSP, JSTL, JUnit, Maven.

[ankitpanwar]

I followed you're tutorial from 0 to last and completed my webAppl with no errors.... great job sir

[환이-fw]

Hello
I am a college student in computer science in Korea.
This is the best tutorial. Thank you.

[billhabbil]

- The type RowMapper is not generic; it cannot be parameterized with arguments
<Contact>


why is this

[trinhquycong.]

I wish to do a more complicated thing. Let's say I have Product and Image tables relevant to each other through foreign key(one product could have one or more images). So when I want delete a product, I need to delete its images first. This process involves more than one table. So, how can I do that while keeping CRUD project directory structure like you did? Thank you in advance.

[pratikkunthe]

Hi 404 error did not resolve even though all the pages is correct

[peivandp]

Hi, great Video. How can we handle NULL values? I´ve read that you should use : setNull(column_index, datatype), but in a form, sometimes you don´t know which field will be null. How can you dynamically say something like: If a field is null in the form, when goes to Java use setNull.

Thank you!

[hamidsiddiqui]

Sir really very awesome explaination with practical thnks Sir

[runak]

Great tutorial!! Could learn a lot from this single video!!

[makigero]

hey man... you're amazing... long play, good work... wonderful thanks again ...

[yaoichan]

Excelent tutorial! And works with websphere, thanks

[Sk-gbhx]

hi, I have some problems with spring sql config .
The spring can't find the DriverManagerdDataSource . Does enyone help me?

[khacbinhbui]

Hi, one of the best tutorial of spring mvc in the world! Can you explain why do we choose java based annotation configuration over xml configuration?

[fuzzzyBit]

iam getting a lot error trying unitTest, getting could not load JDBC driver class [ com.mysql.jdbc.Driver], ive have maven specified <dependency> for mysql as u did, also tried to look on stackoverflow but no luck so far

[kevin]

Thanks a lot for this very informative video!! Really helped me a lot!!😊

[TheZeqbal]

When trying to run the ContactManger from tomcat(As shown in video time- 1.18.33 ). My tomcat was not configured, so then i added tomcat 8.5, Next page it displays SNAPSHOT) and i cant choose to move it from Available to configure, it says "Tomcat version 8.5 only supports J2EE 1.2, 1.3, 1.4, and Java EE 5, 6, and 7 Web modules"

[pradeepakannan]

I have some error sir...I can't save edit contact... address column will be not null error insert query

[ramosespann]

Hi nam do you have a video of Spring Boot CRUD + JDBC ?

[passagepassage]

I follow the foot step but the edit n delete doesn't work for me. I m using jdk 17 though

[niveshsharma]

Hello sir. I made the program exactly like u. But is showing output ${message}.please tell how could I solve it

[aashima]

I'm getting an error at dao = new contactDaoImpl(dataSource); in contactDaoTest class (36:10) that The constructor is undefined. How can I fix it? Please help