<%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1" import="java.sql.*"%> BILL WINDOW

FORTIS HOSPITAL

BILL RECEIPT

<%! String abc,a,b,d,e,g,h,i,j,k,z; int m1=0,f=0,l=0;%> <% String b=(String)session.getAttribute("abc"); %> <% try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection c=DriverManager.getConnection ("jdbc:odbc:abc", "root", "data"); Statement s= c.createStatement(); String sq="select * from patient where patient_id="+b; ResultSet rs=s.executeQuery(sq); if(rs.next()) { z=rs.getString(1); d=rs.getString(2); e=rs.getString(3); f=Integer.parseInt(rs.getString(4)); g=rs.getString(5); h=rs.getString(6); i=rs.getString(7); j=rs.getString(8);l=f+500+3000; m1=3000; } }catch(Exception e){ out.println(e);} %>

PATIENT DETAILS
PATIENT ID
<%=z%>		 PATIENT NAME
<%=d%>		 DATE OF BIRTH
<%=e %>		 FATHER's NAME
<%=g %>		 BLOOD GROUP
<%=h %>		 DEPARTMENT ID
<%=i %>		 SEX
<%=j %>

BILL DETAILS

DOCTOR FEE=<%=f%>


ACCOMODATION CHARGES=<%=m1%>


MAINTAINENCE FEE= Rs500


TOTAL FEES=<%=l%>      



ACCOUNTS MANAGER