Web-Based Online Voting System (JSP + Servlets + JDBC + MySQL)
A secure and structured online voting system built using Java Servlets, JSP, JDBC, and MySQL, following the MVC architecture. The system allows voters to register, log in, cast their vote once, and view results. Admins can manage candidates, voters, and monitor results.
📌 Features 👤 Voter Module
Register and log in
Secure authentication
One-vote-per-user rule
Cast vote for available candidates
View voting confirmation
🛠️ Admin Module
Admin login
Add/manage candidates
View list of registered voters
View live election results
💾 Backend
MySQL database
JDBC connection layer (DAO Pattern)
MVC-based architecture
Form validation & Session management
📁 Project Structure OnlineVotingSystem/ │ ├── src/ │ ├── dao/ # Database access objects │ └── servlets/ # Java Servlets (Admin, Voter, Voting) │ ├── WebContent/ │ ├── css/ # Style files │ ├── WEB-INF/ │ │ ├── web.xml # Deployment descriptor │ │ └── lib/ # MySQL JDBC driver │ └── *.jsp # JSP UI pages │ ├── sql/ │ └── setup.sql # SQL script to create DB & tables │ └── README.md
⚙️ Technology Stack
Java (JDK 8–17 supported)
JSP / Servlets
MySQL (8.x)
JDBC
Tomcat 9 / 10
Eclipse IDE
📦 Database Setup
Install MySQL Server
Open MySQL Shell / Command Line:
mysql -u root -p
Run the database setup script:
SOURCE sql/setup.sql;
🔗 Configure Database in Project
Open:
src/dao/DBConnection.java
Update:
private static final String URL = "jdbc:mysql://localhost:3306/votingdb?useSSL=false"; private static final String USER = "root"; private static final String PASS = "YOUR_PASSWORD";
📥 Add MySQL JDBC Driver
Download:
➡️ mysql-connector-java-8.x.x.jar
Place it inside:
WebContent/WEB-INF/lib/
Or add to Eclipse Build Path.
🚀 Run the Project In Eclipse:
File → Import → Existing Project into Workspace
Select the project root folder
Right-click project → Properties → Target Runtime → Add Tomcat
Right-click project → Run As → Run on Server
Project will start at:
http://localhost:8080/OnlineVotingSystem/
🧪 Testing the System Voter:
Register a new voter
Login
Cast a vote
Check results
Admin:
Default admin credentials (if included in SQL):
username: admin password: admin123
Admin Functions:
Add candidate
Manage candidates
View voter list
View result dashboard
📤 Upload/Push to GitHub git init git add . git commit -m "Initial commit - Online Voting System" git remote add origin https://github.com/YOUR_USERNAME/OnlineVotingSystem.git git push -u origin master
Not recommended for real-world election environments.
Password hashing is minimal/basic.