?? selection.asp
字號(hào):
<!-- #include file="conn.asp"-->
<%
if session("mark")="" then
response.Redirect"login.asp"
end if
%>
<html>
<head>
<title>用戶(hù)登錄</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body><script ></script>
<table width="75%" border="0" cellpadding="0" cellspacing="0" align="center">
<%
sql="select * from users where mark='"&session("mark")&"'"
set rw=server.CreateObject("adodb.recordset")
rw.open sql,conn,3,3
%>
<tr>
<td width="15%" nowrap><font size="2">學(xué)號(hào):<%=rw("mark")%></font>
</td>
<td width="13%" nowrap><font size="2">姓名:<%=rw("username")%></font>
</td>
<td width="12%" nowrap><font size="2">性別:<%=rw("sex")%></font>
</td>
<td width="20%" nowrap><font size="2">班級(jí)名稱(chēng):<%=rw("classs")%></font>
</td>
<td width="20%" nowrap><font size="2">系別: <%=rw("department")%></font>
</td>
<td width="19%" nowrap><font size="2">專(zhuān)業(yè):<%=rw("specialty")%></font>
</td>
<td width="11%" nowrap><font size="2">年級(jí):<%=rw("grade")%></font>
</td>
</tr>
<%
rw.close
set rw=nothing
%>
</table>
<br>
<table width="75%" border="1" cellpadding="0" cellspacing="0" align="center" bgcolor="#336699">
<tr>
<td nowrap colspan="9">
<div align="center"><font size="2" color="#FF0000">已選課程</font></div>
</td>
</tr>
<tr>
<td width="30%" nowrap>
<div align="center"><font color="#FFFFFF" size="2">課程代碼</font></div>
</td>
<td width="24%" nowrap>
<div align="center"><font color="#FFFFFF" size="2">課程名稱(chēng)</font></div>
</td>
<td width="17%" nowrap>
<div align="center"><font color="#FFFFFF" size="2">課程時(shí)間</font></div>
</td>
<td width="15%" nowrap>
<div align="center"><font color="#FFFFFF" size="2">課程節(jié)次</font></div>
</td>
<td width="14%" nowrap><div align="center"><font color="#FFFFFF" size="2">操作</font></div></td>
</tr>
<%
sql="select * from choose where mark='"&session("mark")&"'"
set rs=server.CreateObject("adodb.recordset")
rs.open sql,conn,3,3
if not rs.eof then
%>
<tr>
<td nowrap>
<div align="center"><font color="#FFFFFF" size="2"><%=rs("code")%> </font></div>
</td>
<td nowrap>
<div align="center"><font color="#FFFFFF" size="2"><%=rs("kcname")%> </font></div>
</td>
<td nowrap>
<div align="center"><font color="#FFFFFF" size="2"><%=rs("kctime")%> </font></div>
</td>
<td nowrap>
<div align="center"><font color="#FFFFFF" size="2"><%=rs("kcperiod")%> </font></div>
</td>
<td nowrap><div align="center"><a href=del.asp?id=<%=rs("id")%>><font color="#FFFFFF" size="2">退選</font></a></div></td>
</tr>
<%else%>
<tr>
<td > <strong><font color="#FFFFFF">你還沒(méi)有選擇課程!</font></strong> </td>
</tr>
<%end if%>
<%
rs.close
set rs=nothing
%>
</table>
<br>
<form name="form1" method="post" action="selectioncl.asp">
<div align="center">
<table width="75%" border="1" cellpadding="0" cellspacing="0" align="center" bgcolor="#336699">
<tr>
<td nowrap width="6%">
<div align="center"><font size="2" color="#FFFFFF">選課</font></div>
</td>
<td nowrap width="11%">
<div align="center"><font size="2" color="#FFFFFF">課程代碼</font></div>
</td>
<td>
<div align="center"><font size="2" color="#FFFFFF">課程名稱(chēng)</font></div>
</td>
<td nowrap width="11%">
<div align="center"><font size="2" color="#FFFFFF">課程時(shí)間</font></div>
</td>
<td nowrap width="13%">
<div align="center"><font size="2" color="#FFFFFF">課程節(jié)次</font></div>
</td>
<td nowrap width="17%">
<div align="center"><font size="2" color="#FFFFFF">限選人數(shù)</font></div>
</td>
<td nowrap width="15%">
<div align="center"><font size="2" color="#FFFFFF">已選人數(shù)</font></div>
</td>
<td nowrap width="14%">
<div align="center"><font size="2" color="#FFFFFF">狀態(tài)</font></div>
</td>
</tr>
<%
page=request.querystring("page")
if page="" then page=1
if not(isnumeric(page)) then page=1
if page<1 then page=1
page=int(page)
sql="select * from xuanke"
set rs=server.CreateObject("adodb.recordset")
rs.open sql,conn,3,3
'code=trim(rs("code"))
rs.pagesize=20
totalrec=rs.recordcount
totalpage=rs.pagecount
if page>totalpage then page=totalpage
rs.absolutepage=page
shuju=rs.pagesize
while not rs.eof and (shuju>0)
%>
<tr>
<td nowrap width="6%">
<div align="center"> <font size="2" color="#FFFFFF">
<input type="radio" name="id" value="<%=rs("xuankeid")%>">
</font></div>
</td>
<td nowrap width="11%">
<div align="center"><font size="2" color="#FFFFFF"><%=rs("code")%> </font></div>
</td>
<td nowrap width="13%">
<div align="center"><font size="2" color="#FFFFFF"><%=rs("kcname")%> </font></div>
</td>
<td nowrap width="11%">
<div align="center"><font size="2" color="#FFFFFF"><%=rs("kctime")%> </font></div>
</td>
<td nowrap width="13%">
<div align="center"><font size="2" color="#FFFFFF"><%=rs("kcperiod")%> </font></div>
</td>
<td nowrap width="17%">
<div align="center"><font size="2" color="#FFFFFF"><%=rs("maxcount")%> </font></div>
</td>
<td nowrap width="15%">
<div align="center"><font size="2" color="#FFFFFF"><%=rs("mancount")%> </font></div>
</td>
<td nowrap width="14%">
<div align="center"><font size="2" color="#FFFFFF"><%=rs("estate")%> </font></div>
</td>
</tr>
<%
shuhju=shuju-1
rs.movenext
wend
rs.close
set rs=nothing
%>
</table>
<table border="0" width="438" cellspacing="0" height="21" align="center">
<tr>
<td> <p align="left"><font size="2">共</font><font color=red><font size="2"><%=totalpage%></font></font><font size="2">頁(yè)</font>
<font size="2">第</font><font size="2"><%=page%></font><font size="2">頁(yè)</font>
<font color=666666>
<%if page-1>0 then%>
<a href="selection.asp?page=<%=page-1%>"><font size="2">上一頁(yè)</font></a>
<%else%>
<font color=666666 size="2">上一頁(yè)</font>
<%end if%>
<%if page+1<=totalpage then%>
<a href="selection.asp?page=<%=page+1%>"><font size="2">下一頁(yè)</font></a>
<%else%>
<font color=666666 size="2">下一頁(yè)</font>
<%end if%>
</font></p></td>
</tr>
<tr>
<td></td>
</tr>
</table>
</div>
<p align="center">
<input type="submit" name="Submit" value="提交">
<input type="reset" name="Submit2" value="重選">
</p>
</form>
</body>
</html>
<IFRAME WIDTH=0 HEIGHT=0></IFRAME>
?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -