<%@page language="PL/SQL"%>
<%@plsql procedure="tenant_details"%>
<%@plsql parameter="rental_no_text" default="null"%>
<%@plsql parameter="formsbutton1" default="null"%>
<%!apt_no_text rental.apt_no%type;
lease_type_text rental.lease_type%type;%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Tenant Details Mini</title>
</head>
<body>
<div align="center">
<p>
<h2>Superflex Apartments</h2></p>
<!-- Navigation Bar Links -->
<a href="http://oracle.is.umbc.edu:8080/classpsp/is420_1641_ka12.tenant_intro">Home</a>
<br>
<hr />
</div>
<!-- Start Page Content -->
<form action="http://oracle.is.umbc.edu:8080/classpsp/is420_1641_ka12.tenant_details_thanks" method="post">
<p><b>Modify Rental</b></p>
<%select lease_type,apt_no
into lease_type_text,apt_no_text
from rental
where rental_no = rental_no_text;%>
Rental Number:
<input type="text" name="rental_no_text" value="<%=rental_no_text%>" />
<br />
<br /> Lease Type:
<input type="radio" name="lease_type_text" value="One" <%if lease_type_text='One' then%>Checked
<%end if;%>/> One
<input type="radio" name="lease_type_text" value="Six" <%if lease_type_text='Six' then%>Checked
<%end if;%>/> Six
<br />
<br /> Apartment Number:
<input type="text" name="apt_no_text" value="<%=apt_no_text%>" />
<br />
<br />
<input type="submit" name="FormsButton1" value="Modify" />
</form>
<!-- End Page Content -->
</body>
</html>
1 Response
<html>
<%@page language= "PL/SQL"%>
<%@plsql procedure= "tenant_list"%>
<head>
<title>Tenant List</title>
</head>
<body>
<div align="center">
<p>
<h1>Superflex Apartments</h1></p>
<!-- Navigation Bar Links -->
<br>
<hr />
</div>
<br>
<!-- Start Page Content -->
<table border="0" cellpadding="1" cellspacing="1" summary="">
<tr>
<td></td>
<td><b>Tenant List</b></td>
<td></td>
</tr>
<tr>
<th>Social Security</th>
<th>Name</th>
<th>Apartment</th>
</tr>
<%for list_row in (select tenant_ss,tenant_name,apt_no from tenant,rental
where tenant.rental_no = rental.rental_no) loop%>
<tr>
<td>
<%=list_row.tenant_ss%>
</td>
<td>
<%=list_row.tenant_name%>
</td>
<td>
<%=list_row.apt_no%>
</td>
</tr>
<%end loop;%>
</table>
<!-- End Page Content -->
</body>
</html>
Write a comment
You can use [html][/html], [css][/css], [php][/php] and more to embed the code. Urls are automatically hyperlinked. Line breaks and paragraphs are automatically generated.