📄 1.asp

📁 职业培训学校学生档案成绩费用管理系统V1.0免费版.rar

💻 ASP

字号:

<!--#include file="conn.asp"-->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
</head>

<body>
<%
set rs=server.createobject("adodb.recordset")

sql="select top 10 * from st_info  where in_time between  date() and date()+10 order by id desc"
rs.open sql,conn,1,1	
%>
<table border="1" width="350" bordercolorlight="#000000" cellspacing="0" cellpadding="5" bordercolordark="#FFFFFF">
		<tr>
		<td width="23%">学号</td>
		<td width="25%">姓名</td>
		<td width="25%">类型</td>
		<td width="33%">毕业日期</td>
		</tr>	
		<%
		if not rs.eof then
			do while not rs.eof
		%>
		<tr>
		<td width="23%"><%=rs("user_number")%></td>
		<td width="25%"><a href=xuefeiQuery.asp?id=<%=rs("id")%>&user_type=1><%=rs("user_name")%></a></td>
		<td width="25%"><%=rs("user_type")%></td>
		<td width="33%"><%if isnull(rs("out_time")) then%>未交费 <% else %> <%=rs("out_time")%> <%end if%></td>
		</tr>			
		<%
			rs.movenext
			loop
		else
		%>
		<tr>
		<td width="50%" colspan="4"><marquee>暂无情况</marquee></td>
		</tr>
		<%end if%>
		<tr>
		<td width="23%"  colspan="4" align="right"><a href="student1.asp">更多信息</a></td>
		</tr>	
</table>
<form name="form1" method="post" action="2.asp">
  <input type="text" name="user_state">
   <input type="text" name="id">
  <input type="text" name="user_sex">
  <input type="submit" name="Submit" value="提交">
</form>
<a href=javascript:if(confirm('确实要删除吗?'))location='2.asp'>删除</a> 
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -