insert.jsp

来自「这是一个社区活动中心的管理系统,包括前台和后台的源码」· JSP 代码 · 共 97 行

JSP
97
字号
</HTML><!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 
language="java"
contentType="text/html; charset=utf-8"
%>
<%@ page import = "java.sql.*" %>
<%@ page import = "java.util.*"%>
<%@ page import = "JavaBean.Facility"%>
<%@ page import = "JavaBean.FacilityManage"%>
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<title>Insert</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>
<jsp:useBean id="db" class="JavaBean.FacilityManage" scope="page"></jsp:useBean>
<jsp:useBean id="dish" class="JavaBean.Facility" scope="page"/>
<%
		String sql = "select * from memberfacility where UserName = '"+session.getAttribute("UserName")+"' and Date = '"+session.getAttribute("Query")+"'";  
		ArrayList result = db.orderquery(sql);
%>
</head>
<body>
<FORM method="post" action="Insert">
<table border="1">
	<tbody>
		<tr>
		<td width="100" height="58" style="height: 75px; width: 147px">FacilityID</td>
		<td width="170" height="58">Date</td>
		<td width="170" height="58">StartTime</td>
		<td width="170" height="58">EndTime</td>
		</tr>
		<tr>
		<td width="100" style="height: 1px; width: 147px"><input type="text"
			name="FacilityID" size="7"></input></td>
		<td width="100" style="height: 1px; width: 163px"></td>
		<td width="100" style="height: 1px; width: 163px"><select name="StartTime">
							<option value="8">8</option>
							<option value="9">9</option>
							<option value="10">10</option>
							<option value="11">11</option>
							<option value="12">12</option>
							<option value="13">13</option>
							<option value="14">14</option>
							<option value="15">15</option>
							<option value="16">16</option>
							<option value="17">17</option>
	 						</select>时</td>
		<td width="100" style="height: 1px; width: 163px"><select name="EndTime">
							<option value="8">8</option>
							<option value="9">9</option>
							<option value="10">10</option>
							<option value="11">11</option>
							<option value="12">12</option>
							<option value="13">13</option>
							<option value="14">14</option>
							<option value="15">15</option>
							<option value="16">16</option>
							<option value="17">17</option>
	 						</select>时</td>
		<td width="100" style="height: 1px; width: 55px"><input
					type="submit" value="插入"></input></td>
		</tr>
		<tr>
		<%
			for(int i = 0;i<result.size();i++)
			{
				dish = (Facility)result.get(i);
        %>
           	<TD style="width: 100px" ><%=dish.getFacilityID()%></TD>
			<TD width="170" height="58"><%=dish.getDate()%></TD>
			<TD width="170" height="58"><%=dish.getStartTime()%></TD>
			<TD width="170" height="58"><%=dish.getEndTime()%></TD>
		</tr>
         <%}%>
	</tbody>
</table>
</FORM>

<FORM name = "table2" method="post" action="index.html">
  <input type = submit value = "返回">
</FORM>
</body>
</html>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?