JSP(Java Server Page):
how to retrieve data from database in using mysql
|
<html>
<head>
<meta http-equiv="Content-Type"
content="text/html; charset=ISO-8859-1">
<title>Patient Show...</title>
</head>
<body>
<%!
Connection
con; Statement st; ResultSet rs;
%>
<%
try
{
Class.forName("com.mysql.jdbc.Driver");
con=DriverManager.getConnection("jdbc:mysql://localhost:
3306/hospital","root","root");
st=con.createStatement();
rs=st.executeQuery("select
* from Patient");
%>
<form>
<center>
<h1>All
Details Are Here....</h1>
<table
border="1" width="80%">
<tr>
<td><center>Patient
Id</center></td>
<td><center>Patient
Name</center></td>
<td><center>Bed
Number</center></td>
<td><center>Ward
Number</center></td>
<td><center>Doctor
Name</center></td>
<td><center>Department</center></td>
</tr>
<%
while(rs.next())
{%>
<tr>
<td><center><%=rs.getString(1)%></center></td>
<td><center><%=rs.getString(2)%></center></td>
<td><center><%=rs.getString(3)%></center></td>
<td><center><%=rs.getString(4)%></center></td>
<td><center><%=rs.getString(5)%></center></td>
<td><center><%=rs.getString(6)%></center></td>
</tr>
<%}
}
catch(Exception e)
{
out.print(e.toString());
}
%>
</table>
</center>
</form>
</body>
</html>
|
No comments:
Post a Comment