<%
try{
a=request.getParameter("button1");
if(a.equals("ENTER"))
{
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 sq="select * from patient where patient_id="+str1+"";
ResultSet rs1=s.executeQuery(sq);
if(rs1.next())
{
out.println("PATIENT ID="+rs1.getString(1)); %>
<%
out.println("PATIENT NAME="+rs1.getString(2)); %>
<%
out.println("DATE OF BIRTH="+rs1.getString(3)); %>
<%
out.println("DOCTOR FEE ="+rs1.getString(4)); %>
<%
out.println("FATHER'S NAME ="+rs1.getString(5)); %>
<%
out.println("DEPARTMENT ID="+rs1.getString(6)); %>
<%
out.println("BLOOD GROUP ="+rs1.getString(7)); %>
<%
out.println("GENDER ="+rs1.getString(8)); %>
<%
%>
ARE YOU SURE YOU WANT TO DISCHARGE PATIENT
|
<%
}
else
{
%>
<%
}
}
else
{
%>
<%
}
}
}catch(Exception e){}
%>
<%
try
{
a=request.getParameter("button1");
if(a.equals("DISCHARGE"))
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection c=DriverManager.getConnection ("jdbc:odbc:abc", "root", "data");
Statement s= c.createStatement();
String sql="delete from rooms where patient_id="+str1+"";
//String sq2="update table patient set status='D' where patient_id="+str1+"";
//s.execute(sq2);
s.execute(sql);
%>
<%
session.setAttribute("abc",str1);
%>