getmajor.jsp

来自「课设做的工程分析」· JSP 代码 · 共 163 行

JSP
163
字号

<%@ page language="java" contentType="text/html; charset=gb2312"
	import="java.sql.*"%>
<jsp:useBean id="cla" class="jav.classp" scope="page" />
<html>
	<head>
		<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
		<style type="text/css">
<!--
body,td,th {
	font-size: 13px;
}
body {
	margin:0px; background-image: url('admin/images/lvbgcolor.gif');
	
}
.tabletitle {
	color: #990000;
	font-weight: bold;
}
-->
</style>
		<SCRIPT language=JavaScript>
<!--
function go(src,q)
{
var ret;
ret = confirm(q);
if(ret!=false)window.location=src;
}
-->
</script>
		<title>查看专业</title>
	</head>
	<body bgcolor="#CCCCFF">
		<div align="center">
			<table width="800" border="0" cellspacing="0" cellpadding="0">
				<tr>
					<td>
						&nbsp;
					</td>
				</tr>
				<tr>
					<td height="18" align="center">
						<font size=5>查看专业</font>
					</td>
				</tr>
				<tr>
					<td height="117" align="center" valign="middle">
						<div align="center">
							<table width="102%" border="2" cellpadding="2" cellspacing="1"
								bordercolor="#99CC33" bordercolorlight="#0000FF"
								bordercolordark="#0000FF" bgcolor="#FFFFFF"
								style="border-collapse: collapse">
								<tr bordercolor="#99FF33" bgcolor="#99FF33">
									<td width="11%" align="center" bordercolor="#0000FF"
										bgcolor="#0000FF">
										<span class="tabletitle"><font color="#FFFFFF">专业编号</font>
										</span>
									</td>
									<td width="20%" align="center" bordercolor="#0000FF"
										bgcolor="#0000FF">
										<strong class="tabletitle"><font color="#FFFFFF">专业名称</font>
										</strong>
									</td>
									<td width="20%" align="center" bgcolor="#0000FF"
										class="tabletitle" bordercolor="#0000FF">
										<font color="#FFFFFF">所属院系</font>
									</td>
									<td width="10%" align="center" bgcolor="#0000FF"
										class="tabletitle" bordercolor="#0000FF">
										<font color="#FFFFFF">院系编号</font>
									</td>
									<td width="17%" align="center" bgcolor="#0000FF"
										bordercolor="#0000FF">
										<strong><font color="#FFFFFF">包含班级数目</font> </strong>
									</td>
									<td width="22%" align="center" bgcolor="#0000FF"
										bordercolor="#0000FF">
										<strong class="tabletitle"><font color="#FFFFFF">操作</font>
										</strong>
									</td>
								</tr>
								<%  String sql=null;
								 if(request.getParameter("majNo")==null)
								  sql="select * from getmajor where acaNo='"
											+ request.getParameter("acaNo") + "'";
											else
											sql = "select * from getmajor where majNo='"
											+ request.getParameter("majNo") + "'";
									ResultSet rs = cla.QuerySelct(sql);
									while (rs.next()) {
										String majNo = rs.getString("majNo");
										String majName = rs.getString("majName");
										String acaName = rs.getString("acaName");
										String claNum = rs.getString("claNum");
										String acaNo=rs.getString("acaNo");
								%>
								<tr bordercolor="#99CC99" bgcolor="#99CC99">
									<td align="left" valign="top" bgcolor="#FFFFFF"
										bordercolor="#FFFFFF" bordercolorlight="#0000FF"
										bordercolordark="#0000FF">
										&nbsp;
										<%=majNo%>
									</td>
									<td align="left" valign="top" bgcolor="#FFFFFF"
										bordercolor="#FFFFFF" bordercolorlight="#0000FF"
										bordercolordark="#0000FF">
										&nbsp;
										<%=majName%>
									</td>
									<td align="left" valign="top" bgcolor="#FFFFFF"
										bordercolor="#FFFFFF" bordercolorlight="#0000FF"
										bordercolordark="#0000FF">
										&nbsp;
										<%=acaName%>
									</td>
									<td align="left" valign="top" bgcolor="#FFFFFF"
										bordercolor="#FFFFFF" bordercolorlight="#0000FF"
										bordercolordark="#0000FF">
										&nbsp;
										<%=acaNo%>
									</td>
									<td align="left" valign="top" bgcolor="#FFFFFF"
										bordercolor="#FFFFFF" bordercolorlight="#0000FF"
										bordercolordark="#0000FF">
										&nbsp;
										<%=claNum%>
									</td>
									<td align="center" valign="top" bgcolor="#FFFFFF"
										bordercolorlight="#0000FF" bordercolordark="#0000FF">
										<a href="getAllcla.jsp?majNo=<%=majNo%>">所含班级</a>
									</td>
								</tr>
								<%
								} rs.close();
								%>
								<tr bordercolor="#99CC99" bgcolor="#99CC99">
									<td bgcolor="#FFFFFF" bordercolor="#FFFFFF"
										bordercolorlight="#0000FF" bordercolordark="#0000FF">
										&nbsp;
									</td>
									<td colspan="3" bgcolor="#FFFFFF" bordercolor="#FFFFFF"
										bordercolorlight="#0000FF" bordercolordark="#0000FF">
										&nbsp;
										<input type="button" onClick="location.href=''" name="add0"
											value="返回上一级">
									</td>
									<td align="center" bgcolor="#FFFFFF" bordercolorlight="#0000FF"
										bordercolordark="#0000FF">
										&nbsp;
									</td>
								</tr>
							</table>
						</div>
					</td>
				</tr>
			</table>
		</div>
	
	</body>
</html>

⌨️ 快捷键说明

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