📘 Premium Read: Access my best content on Medium member-only articles — deep dives into Java, Spring Boot, Microservices, backend architecture, interview preparation, career advice, and industry-standard best practices.
✅ Some premium posts are free to read — no account needed. Follow me on Medium to stay updated and support my writing.
🎓 Top 10 Udemy Courses (Huge Discount): Explore My Udemy Courses — Learn through real-time, project-based development.
▶️ Subscribe to My YouTube Channel (172K+ subscribers): Java Guides on YouTube
You can download the source code of this tutorial from my Github repository, the link given at the end of this tutorial.
Build Todo App using JSP, Servlet, JDBC, and MySQL - Part 3 Series
- Model Layer - Todo.java
- DAO Layer - TodoDao.java and TodoDaoImpl.java
- Controller Layer - TodoController.java
- View Layer - todo-form.jsp and todo-list.jsp
- Creating an error page
In part 3, I will cover the below topics:
Video Tutorial
Features Implementation
- Develop User registration module implementation
- Develop a Login module implementation
- Develop a Todo CRUD operations implementation
What we will build?
User Registration Page
Login Page
Add New Todo Page
Update Todo Page
List Todo Page
Delete Todo Page
Tools and technologies used
- JSP - 2.2 +
- IDE - STS/Eclipse Neon.3
- JDK - 1.8 or later
- Apache Tomcat - 8.5
- JSTL - 1.2.1
- Servlet API - 2.5
- MySQL - mysql-connector-java-8.0.13.jar
MySQL Database Setup
CREATE TABLE `users` (
`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,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `todos` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`description` varchar(255) DEFAULT NULL,
`is_done` bit(1) NOT NULL,
`target_date` datetime(6) DEFAULT NULL,
`username` varchar(255) DEFAULT NULL,
`title` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
Comments
Post a Comment
Leave Comment