📄 cjquery.asp

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

💻 ASP

字号:

<!--#include file="conn.asp"-->
<%
if session("user")="" then
	response.write "您无此权限"
	response.end
end if

dim user_name,user_number,sql
id=request("id")
if id=1 then
	user_name=trim(request("user_name1"))
	if user_name="" then
		response.write "输入不能为空"
		response.end
	end if
	sql="user_name like'%"&user_name&"%'"
end if
if id=2 then
	user_number=trim(request("user_number1"))
	if user_number="" then
		response.write "输入不能为空"
		response.end
	end if
	sql="user_number ='"&user_number&"'"
end if
set rs=server.createobject("adodb.recordset")
sql="select * from ach where "&sql
rs.open sql,conn,1,1
%>

<html>

<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>查询结果</title>
<link rel="stylesheet" href="style.css">
</head>

<body>
<!--#include file="top.asp"-->
<p>&nbsp;</p>
<div align="center"> 
  <table border="1" width="700" bordercolorlight="#000000" cellspacing="0" cellpadding="4" bordercolordark="#FFFFFF">
    <tr>
	  <td width="100" align="center">学号</td>
      <td width="50" align="center">姓名</td>
      <td width="70" align="center">考试时间</td>
      <td width="200" align="center">考试科目</td>
      <td width="50" align="center">考试成绩</td>
      <td width="50" align="center">修改</td>
      <td width="50" align="center">删除</td>
    </tr>
    <%if not rs.eof then%>
    <%do while not rs.eof
   %>
    <tr>
	  <td width="100" align="center"><%=rs("user_number")%></td>
      <td width="50" align="center"><%=rs("user_name")%></td>
      <td width="70" align="center"><%=rs("test_data")%></td>
      <td width="200" align="center"><%=rs("subject")%></td>
      <td width="50" align="center"><%=rs("ach")%></td>
      <td width="50" align="center"><a href="mod_chengji.asp?id=<%=rs("id")%>">修改</a></td>
      <td width="50" align="center"><a href=javascript:if(confirm('确实要删除吗?'))location='del_chengji.asp?id=<%=rs("id")%>'>删除</a>
	  </td>
    </tr>
    <%
	rs.movenext
	loop
	else%>
    <tr>
      <td colspan="7"><marquee>
        暂无情况添加
      </marquee></td>
    </tr>
  </table>
  
  <%
end if
rs.close
set rs=nothing
%>
</div>
<!--#include file="down.asp"-->
</body>

</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -