📄 delete.jsp
字号:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<!--
Design by Free CSS Templates
http://www.freecsstemplates.org
Released for free under a Creative Commons Attribution 2.5 License
-->
<%@ page contentType="text/html; charset=utf-8" language="java"%>
<%@ page import = "java.sql.*" %>
<%@ page import = "java.util.*"%>
<%@ page import = "JavaBean.Facility"%>
<%@ page import = "JavaBean.FacilityManage"%>
<jsp:useBean id="db" class="JavaBean.FacilityManage" scope="page"></jsp:useBean>
<jsp:useBean id="dish" class="JavaBean.Facility" scope="page"/>
<%
String sql = "select * from facilityinformation,memberfacility where facilityinformation.FacilityID = memberfacility.FacilityID and OrderState = '1' and Date = '"+session.getAttribute("DeleteDate")+"' and UserName = '"+session.getAttribute("UserName")+"'";
ArrayList result = db.select(sql);
%>
<HTML>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<title>Delete.jsp</title>
<meta name="keywords" content="" />
<meta name="description" content="" />
<link href="default.css" rel="stylesheet" type="text/css" />
<style type="text/css">
<!--
.STYLE2 {color: #A03D3D}
-->
</style>
</HEAD>
<BODY>
<FORM method="post" action="Delete"><TABLE border="1">
<TBODY>
<TR>
<td width="170" height="58">FacilityID</td>
<td width="170" height="58">Kind</td>
<td width="170" height="58">Expense</td>
<td width="170" height="58">FacilityState</td>
<td width="170" height="58">RecordID</td>
</TR>
<TR>
<%
for(int i = 0;i<result.size();i++)
{
dish = (Facility)result.get(i);
%>
<TD width="170" height="58"><%=dish.getFacilityID()%></TD>
<TD width="170" height="58"><%=dish.getKind()%></TD>
<TD width="170" height="58"><%=dish.getExpense()%></TD>
<TD width="170" height="58"><%=dish.getFacilityState()%></TD>
<TD width="170" height="58"><%=dish.getRecordID()%></TD>
</TR>
<%}%>
<tr>
<td width="100" style="height: 1px; width: 147px"><input type="text"
name="RecordID" size="7"></input></td>
<td width="100" style="height: 1px; width: 55px"><input
type="submit" value="鍒犻櫎"></td>
</tr>
</TBODY>
</TABLE>
</FORM>
<FORM method="post" action="index.html"><TABLE border="1">
<td width="100" style="height: 1px; width: 55px"><input
type="submit" value="杩斿洖"></td>
</FORM>
</BODY>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -