tq1a.jsp

来自「用JSP+SQL开发的在线考试系统..希望可以帮到一些人」· JSP 代码 · 共 54 行

JSP
54
字号
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<%@ page contentType="text/html; charset=gb2312"%>
<%@ page language="java" import="java.sql.*"%>
<jsp:useBean id="dep1" scope="page" class="exam.exam"/>

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>控制学生考试</title>
<SCRIPT LANGUAGE="JavaScript">
function isValid(){
if(document.form1.give.value=="")
	{
	 window.alert("请选择要 审批的系 !");
	 return false;
	}
}
</SCRIPT>
</head>
<body BGCOLOR=#0D85A6 BACKGROUND="images/bg.gif" text="#000000">
<%
String sql="select * from departmen";
ResultSet rs2=dep1.executeQuery(sql);
int num;
String depname;

%>
<center>
 <table width="744" height="45" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
	<td>
		<center>
			<form action ="tq2a.jsp" method="post" name="form1" target="mainFrame" onSubmit="return isValid();" >
			 <select name="give"> 
				<option value="">--请选择部门名--</option>
				<%
					while(rs2.next())
					{
						num=rs2.getInt("dep");
						depname=rs2.getString("depname"); %>
						<option value="<%=num%>"><%=depname%></option>
						<%
					}
					rs2.close();
				%>
			</select>
			<input type="submit"  value="确定" >
		</center>
	</td>
</tr>
</table>
</center>
</body>
</html>

⌨️ 快捷键说明

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