<%@page import="com.conn.DbConnect"%> <%@page import="java.sql.*"%> <%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1"%> Admin : Dashboard <%@include file="allCss.jsp"%> <%@include file="nav.jsp"%>
<% try { int count = 0; Connection con = DbConnect.getConn(); Statement st = con.createStatement(); ResultSet rs = st.executeQuery("select * from customer "); while (rs.next()) { count++; } %>

<%out.println(count);%>

Total Customers

<% %>
<% int count1 = 0; ResultSet rs1 = st.executeQuery("select * from connection "); while (rs1.next()) { count1++; } %>

<%out.println(count1);%>

Total Connection

<% int count2 = 0; ResultSet rs2 = st.executeQuery("select * from bill"); while (rs2.next()) { count2++; } %>

<%out.println(count2);%>

Total Bill

<% } catch (Exception e) { System.out.println(e); } %>