ADD NEW PATIENT
PATIENT DETAILS
<%
try
{ a=request.getParameter("button1");
if(a.equals("SEARCH PATIENT"))
{
String str1= request.getParameter("t1");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection c=DriverManager.getConnection ("jdbc:odbc:abc", "root", "data");
Statement s= c.createStatement();
if(str1!="")
{
String sql2="select * from patient where patient_id='"+str1+"'";
ResultSet r=s.executeQuery(sql2);
if(r.next())
{
j=r.getString(1);
b=r.getString(2);
d=r.getString(3);
e=r.getString(4);
f=r.getString(5);
g=r.getString(6);
h=r.getString(7);
i=r.getString(8);
}
else
{
%>
<%
}
}
else
{
%>
<%
}
}
}catch(Exception e) {}
%>
PATIENT ID >
PATIENT NAME >
DATE OF BIRTH >
DOCTOR FEE >
FATHER'S NAME >
DEPARTMENT ID >
BLOOD GROUP >
GENDER
|
<%
try
{ a=request.getParameter("button1");
if(a.equals("EDIT PATIENT DETAILS"))
{
String str1= request.getParameter("t1");
String str2= request.getParameter("t2");
String str3= request.getParameter("t3");
String str4= request.getParameter("t4");
String str5= request.getParameter("t5");
String str6= request.getParameter("t6");
String str7= request.getParameter("t7");
String str8= request.getParameter("t8");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection c=DriverManager.getConnection ("jdbc:odbc:abc", "root", "data");
Statement s= c.createStatement();
if(str1!="")
{
String sql2="select * from patient where patient_id='"+str1+"'";
ResultSet rs1=s.executeQuery(sql2);
if(rs1.next())
{
String sql1="select * from department where dept_id='"+str6+"'";
ResultSet rs=s.executeQuery(sql1);
if(rs.next())
{
String sq="delete from patient where patient_id='"+str1+"'";
s.execute(sq);
String sql="insert into patient values("+str1+",'"+str2+"','"+str3+"','"+str4+"','"+str5+"','"+str7+"','"+str6+"','"+str8+"')";
s.execute(sql);
%>
<%
}
else
{
%>
<%
}
}
else
{
%>
<%
}
}
else
{
%>
<%
}
}
}catch(Exception e) {}
%>
BED ALLOCATION DETAILS
PATIENT ID
BED NO
DATE OF ALLOCTN
CHARGES
ROOM TYPE
|
|
<%
try
{
a=request.getParameter("button1");
if(a.equals("ADMIT PATIENT AND ALLOT BED"))
{
String str1= request.getParameter("t1");
String str2= request.getParameter("t2");
String str3= request.getParameter("t3");
String str4= request.getParameter("t4");
String str5= request.getParameter("t5");
String str6= request.getParameter("t6");
String str7= request.getParameter("t7");
String str8= request.getParameter("t8");
String str11= request.getParameter("t9");
String str12= request.getParameter("t10");
String str13= request.getParameter("t11");
String str14= request.getParameter("t12");
String str15= request.getParameter("t13");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection c=DriverManager.getConnection ("jdbc:odbc:abc", "root", "data");
Statement s= c.createStatement();
if(str1!=""&&str2!=""&&str3!=""&&str4!=""&&str5!=""&&str6!=""&&str7!=""&&str8!=""&&str11!=""&&str12!=""&&str13!=""&&str14!=""&&str15!="")
{
String sq1="select * from department where dept_id="+str6+"";
ResultSet r4=s.executeQuery(sq1);
if(r4.next())
{
String sq2="select * from rooms where bed_no ="+str12+"";
ResultSet r5=s.executeQuery(sq2);
if(r5.next())
{
%>
<%
}
else
{
String sq4="insert into patient values("+str1+",'"+str2+"','"+str3+"','"+str4+"','"+str5+"','"+str7+"','"+str6+"','"+str8+"','A')";
out.println(sq4);
s.execute(sq4);
String sq3="insert into rooms values("+str11+","+str12+",'"+str15+"',"+str14+",'"+str13+"')";
out.println(sq3);
s.execute(sq3);
%>
<%
}
}
else
{
%>
<%
}
}
else
{
%>
<%
}
}
}catch(Exception e) {}
%>
PATIENTS ADMITTED IN HOSPITAL
| PATIENT ID |
PATIENT NAME |
DATE OF BIRTH |
DOCTOR'S FEE |
FATHER'S NAME |
BLOOD GROUP |
DEPARTMENT ID |
SEX |
<%
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection c= DriverManager.getConnection("jdbc:odbc:abc", "root", "data");
Statement s=c.createStatement();
String sql1="select * from patient";
ResultSet rs=s.executeQuery(sql1);
while(rs.next())
{%>
<%
for (int i=1; i<=8; i++)
{
out.println( "| " + rs.getString (i) );
}
}%> | <%
}catch(Exception e) { }
%>
BEDS OCCUPIED IN HOSPITAL ACCOMODATION
| PATIENT ID |
BED NO |
ROOM TYPE |
CHARGES |
ALLOCATION DATE |
<%
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection c= DriverManager.getConnection("jdbc:odbc:abc", "root", "data");
Statement s=c.createStatement();
String sql1="select * from rooms";
ResultSet rs=s.executeQuery(sql1);
while(rs.next())
{%>
<%
for (int i=1; i<=5; i++)
{
out.println( "| " + rs.getString (i) );
}
}%> | <%
}catch(Exception e) { }
%>
|