📄 studentcjcx.jsp
字号:
<%@ page language = "java" contentType = "text/html;charset=gb2312"%>
<%@ page import = "java.sql.*, java.io.*" %>
<jsp:useBean id="subject" scope="page" class="wsxk.ConDB"/>
<%
String titlelist[];
titlelist = new String[99999];
String strSQL = "select couid ,couname from course ";
ResultSet rs = subject.executeQuery(strSQL);
int length = 0;
while(rs.next())
{
String id = rs.getString("couid");
String title = rs.getString("couname").trim();
titlelist[length] = title;
length++;
}
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="_notes/aaa.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
@import url("_notes/ccc");
body,td,th {
font-size: 12px;
color: #FFFFFF;
font-weight: bold;
}
a:link {
color: #FFFFFF;
}
a:visited {
color: #FFFFFF;
}
.style1 {font-size: 14px}
-->
</style>
</HEAD>
<BODY BGCOLOR=#0D85A6 BACKGROUND="images/bg.gif" >
<br>
<br>
<TABLE WIDTH=750 height="494" BORDER=0 align="center" CELLPADDING=0 CELLSPACING=0>
<TR>
<TD> <IMG SRC="images/spacer.gif" WIDTH=231 HEIGHT=1></TD>
<TD> <IMG SRC="images/spacer.gif" WIDTH=4 HEIGHT=1></TD>
<TD> <IMG SRC="images/spacer.gif" WIDTH=75 HEIGHT=1></TD>
<TD> <IMG SRC="images/spacer.gif" WIDTH=110 HEIGHT=1></TD>
<TD> <IMG SRC="images/spacer.gif" WIDTH=110 HEIGHT=1></TD>
<TD> <IMG SRC="images/spacer.gif" WIDTH=110 HEIGHT=1></TD>
<TD> <IMG SRC="images/spacer.gif" WIDTH=105 HEIGHT=1></TD>
<TD> <IMG SRC="images/spacer.gif" WIDTH=5 HEIGHT=1></TD>
</TR>
<TR>
<TD COLSPAN=4> <IMG SRC="images/temp_01.jpg" WIDTH=420 HEIGHT=15></TD>
<TD COLSPAN=4> <IMG SRC="images/temp_02.jpg" WIDTH=330 HEIGHT=15></TD>
</TR>
<TR>
<TD COLSPAN=8> <IMG SRC="images/temp_03.jpg" WIDTH=750 HEIGHT=5></TD>
</TR>
<TR>
<TD>
<table width="231" border="0" cellspacing="0" cellpadding="0" height="225" background="images/left_top.jpg">
<tr>
<td width="231" height="225" valign="bottom">
<div align="center">
<p> </p>
<p>成绩查询</p>
<p>在这里您可以对成绩<br>
以及课表进行查询
</p>
<p> <font color="#2DFFFF" size="5"><strong> </strong></font></p>
<table width="200" border="1">
<tr>
<td><div align="center"><a href="studentwsxk.jsp">【网上选课】</a></div></td>
</tr>
<tr>
<td><div align="center">【成绩查询】</div></td>
</tr>
<tr>
<td><div align="center">【书籍购买】</div></td>
</tr>
</table>
<p> <strong><font color="#2DFFFF" size="5"> </font></strong></p>
</div> </td>
</tr>
</table>
</TD>
<TD ROWSPAN=2> <IMG SRC="images/temp_05.jpg" WIDTH=4 HEIGHT=455></TD>
<TD COLSPAN=5 ROWSPAN=2>
<table width="510" border="0" cellspacing="0" cellpadding="0" height="455" background="images/main_bg.jpg">
<tr>
<td width="510" valign="top"><table width="510" border="0" cellspacing="0" cellpadding="0" height="391">
<tr>
<td width="510" height="78">
<div align="center"><img src="images/blank_banner.gif" width="468" height="60"></div></td>
</tr>
<tr>
<td height="12" valign="top"> <div align="left"><a href="index1.htm">首页</a>><a href="index1.jsp">学生</a>>成绩查询</div></td>
</tr>
<tr>
<td height="301" valign="middle"><div align="center">
<form name="form1" method="post" action="studentcjcx2.jsp">
<table width="350" border="0">
<tr>
<td colspan="2"><div align="center">按课程查询
<select name="select">
<option value="0" selected>选择要查询的课程</option>
<% for (int i = 0; i < length; i++)
out.print("<option>" + titlelist[i].trim() + "</option>");
%>
</select>
</div></td>
</tr>
<tr>
<td width="264"><div align="right">
<input type="submit" name="Submit" value="点击查询">
</div></td>
<td width="76"> </td>
</tr>
</table>
</form>
<form name="form4" method="post" action="studentcjcx3.jsp">
<table width="350" border="0">
<tr>
<td colspan="2"><div align="center">按学期查询
<select name="select2">
<option value="0" selected>选择要查询的学期</option>
<option value="1">第一学年</option>
<option value="2">第二学年</option>
<option value="3">第三学年</option>
<option value="4">第四学年</option>
</select>
</div></td>
</tr>
<tr>
<td width="267"><div align="right">
<input type="submit" name="Submit2" value="点击查询">
</div></td>
<td width="73"> </td>
</tr>
</table>
<div align="center"></div>
</form>
<form name="form2" method="post" action="">
<table width="350" border="0">
<tr>
<td width="145"><div align="right"></div>
<div align="right"><a href="studentqbkb.jsp">总成绩单</a></div></td>
<td width="121">
<div align="right"><a href="studentxkd.jsp">总选课单</a></div></td>
<td width="70"> </td>
</tr>
</table>
</form>
</div></td>
</tr>
</table></td>
</tr>
</table>
</TD>
<TD ROWSPAN=2> <IMG SRC="images/temp_07.jpg" WIDTH=5 HEIGHT=455></TD>
</TR>
<TR>
<TD>
<table width="231" border="0" cellspacing="0" cellpadding="0" height="229" background="images/left_bottom.jpg">
<tr>
<td width="231" height="222">
<div align="center">
<table width="200" border="1">
<tr>
<td><div align="center"><a href="lyb.jsp">【留言板】</a></div></td>
</tr>
</table>
<p> </p>
<p> <strong><font color="#2DFFFF" size="5"> </font></strong></p>
<p class="aaa"><a href="index1.htm" class="style1">[退出系统]</a></p>
</div>
</td>
</tr>
</table>
</TD>
</TR>
<TR>
<TD COLSPAN=8> <IMG SRC="images/temp_09.jpg" WIDTH=750 HEIGHT=5></TD>
</TR>
<TR>
<TD COLSPAN=8> <img src="images/temp_10.jpg" width=752 height=20></TD>
</TR>
</TABLE>
</BODY>
</HTML>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -