Water Billing System
Full-stack Java web application for generating and viewing consumer water bills. Built using JSP, Servlets, JDBC, and MySQL on Apache Tomcat with a layered architecture (bean → DAO → service → controller → JSP). Key features: • Generate bills from meter readings (consumer number, month/year, start/current reading, connection type) • Slab-based tariff calculations (Domestic: 20 fixed + 0.004-0.025/L; Industrial: 150/200 fixed + 0.015-0.035/L) • Input validation (mandatory fields, current reading ≥ start reading, duplicate bill prevention) • Database-driven CRUD with MySQL • Clean UI with success/error handling Technologies: Java 8+, JSP, Servlets 4.0, MySQL 8, Apache Tomcat 9, Eclipse IDE, Git/GitHub