1. Search the patient form:(srp.jsp)
2. search the patient jdbc program
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%><%@ page import="java.io.*"%>
<%@ page import ="java.sql.*" %>
<% Class.forName("com.mysql.jdbc.Driver"); %>
<%
Connection connection = DriverManager.getConnection(
"jdbc:mysql://localhost:3306/db", "root", "root");
Statement statement = connection.createStatement();
String PatientName = request.getParameter("pnm");
ResultSet rs =
//statement.executeQuery("select * from prg s,HealthRecords t where s.name=t.pnmt") ;
statement.executeQuery("select * from prg,healthRecords") ;
if(!rs.next()) {
out.println("Sorry, could not find that patient. ");
} else {
%>
| Category | <%= rs.getString("ctgy") %> |
|---|---|
| Name | <%= rs.getString("name") %> |
| Age | <%= rs.getString("age") %> |
| Gender | <%= rs.getString("gender") %> |
| Profession | <%= rs.getString("profs") %> |
| Select File | <%= rs.getString("photo") %> |
| Phone | <%= rs.getString("mobile") %> |
| <%= rs.getString("email") %> | |
| HeartBeat | <%= rs.getString("HeartBeat") %> |
| Select Prescription | <%= rs.getString("prescription") %> |
| BloodPressure | <%= rs.getString("BP") %> |
| PastDiseases | <%= rs.getString("pastdiseases") %> |
<%
}
%>
Go
3. tables for patient registration using mysql(table name is prg and healthRecords table) :
desc healthRecords;(patient healthRecords table)
+--------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------+-------------+------+-----+---------+-------+
| prescription | varchar(30) | YES | | NULL | |
| BP | varchar(30) | YES | | NULL | |
| HeartBeat | varchar(30) | YES | | NULL | |
| pastdiseases | varchar(30) | YES | | NULL | |
| pnmt | varchar(30) | YES | | NULL | |
+--------------+-------------+------+-----+---------+-------+
+--------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------+-------------+------+-----+---------+-------+
| prescription | varchar(30) | YES | | NULL | |
| BP | varchar(30) | YES | | NULL | |
| HeartBeat | varchar(30) | YES | | NULL | |
| pastdiseases | varchar(30) | YES | | NULL | |
| pnmt | varchar(30) | YES | | NULL | |
+--------------+-------------+------+-----+---------+-------+
where pnmt means patient name for healthRecords table
desc prg;(patient registration table)
+--------+---------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------+---------------+------+-----+---------+----------------+
| ID | mediumint(9) | NO | PRI | NULL | auto_increment |
| ctgy | varchar(30) | YES | | NULL | |
| name | varchar(30) | YES | | NULL | |
| age | varchar(35) | YES | | NULL | |
| gender | varchar(4) | YES | | NULL | |
| profs | varchar(30) | YES | | NULL | |
| photo | varchar(4000) | YES | | NULL | |
| mobile | varchar(30) | YES | | NULL | |
| email | varchar(30) | YES | | NULL | |
+--------+---------------+------+-----+---------+----------------+
+--------+---------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------+---------------+------+-----+---------+----------------+
| ID | mediumint(9) | NO | PRI | NULL | auto_increment |
| ctgy | varchar(30) | YES | | NULL | |
| name | varchar(30) | YES | | NULL | |
| age | varchar(35) | YES | | NULL | |
| gender | varchar(4) | YES | | NULL | |
| profs | varchar(30) | YES | | NULL | |
| photo | varchar(4000) | YES | | NULL | |
| mobile | varchar(30) | YES | | NULL | |
| email | varchar(30) | YES | | NULL | |
+--------+---------------+------+-----+---------+----------------+
Skvamsi AkellaPosted Oct 23, 2017, 7:55 AM
Sundaram SubramanianPosted Oct 23, 2017, 7:27 AM