班级管理的内容:
班级代码: <input name="b1" type="text" id="b1" size="15">
班级名称: <input name="b2" type="text" id="b2" size="15">
数据库文件为: !@#bbsxp.asa 所属表文件名为: bjgl
班级搜索代码与学员搜索代码类似学员管理的内容:
班级代码: <input type="text" id="t27" size="40">
班级名称: <input name="t28" type="text" id="t28" size="23" readonly="true">
数据库文件为: !@#bbsxp.asa 所属表文件名为: xygl 学员搜索的代码为:
<form method="post" action="sousuo1.asp?act=search"><table width="97%" border="0" align="center" class="a2">
<tr>
<td align="center">
搜索学员管理关键字:<input type="Text" name="x4"><input name="Submit" type="Submit" value="Submit"></td>
</tr>
</table></form>
<table width="97%" border="0" align="center" class="a2">
<tr>
<td class="a3">
<%
dim act
act=request("act")
if(act="search") then
x4 = Request.form( "x4" )
QueryWords = Split( x4 )
strIndent = " "
' 如果搜索为空则返回
If x4 = "" Then
Response.Redirect( "xylb.asp" )
End If
Session.timeout = 2
If IsObject(Session("sitesearch_conn")) Then
Set conn = Session("sitesearch_conn")
Else
Set conn = Server.CreateObject("ADODB.Connection")
conn.open "driver={Microsoft Access Driver (*.mdb)};dbq=" & Server.MapPath("database/!@#bbsxp.asa"),"",""
Set Session("sitesearch_conn") = conn
End If
' 查询语句
sql = "SELECT * FROM [xygl] WHERE"
'搜索t27字段
sql = sql & " ( [t1] LIKE '%" & QueryWords( 0 ) & "%'" ' First
For i = LBound( QueryWords ) + 1 to UBound( QueryWords )
If QueryWords( i ) <> "" and UCase( QueryWords(i) ) <> "OR" and UCase( QueryWords(i) ) <> "AND" Then
If uCase( QueryWords( i-1 ) ) = "OR" Then
sql = sql & " OR [t1] LIKE '%" & QueryWords( i ) & "%'"
Else
sql = sql & " AND [t1] LIKE '%" & QueryWords( i ) & "%'"
End If
End If
Next
' 搜索t28字段
sql = sql & " ) OR ( [t2] LIKE '%" & QueryWords( 0 ) & "%'"
For i = LBound( QueryWords ) + 1 to UBound( QueryWords )
If QueryWords( i ) <> "" and UCase( QueryWords(i) ) <> "OR" and UCase( QueryWords(i) ) <> "AND" Then
If uCase( QueryWords( i-1 ) ) = "OR" Then
sql = sql & " OR [t2] LIKE '%" & QueryWords( i ) & "%'"
Else
sql = sql & " AND [t2] LIKE '%" & QueryWords( i ) & "%'"
End If
End If
Next
sql = sql & " )"
'
Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open sql, conn, 3, 3
Response.Write "<BR><B> 你搜索的是: </B> " & x4
Response.Write "<BR><B> 搜索的关键字: </B> "
For i = LBound( QueryWords ) to UBound( QueryWords )
Response.Write "<BR>" & strIndent & i & ": " & QueryWords( i )
Next
' Print the SQL String
Response.Write "<BR><B> sql 语句 : </B> " & sql
' Print the Results
Response.Write "<BR><B> 结果: </B> <UL>"
On Error Resume Next
rs.MoveFirst
Do While Not rs.eof
Response.Write "<BR>" & "<A HREF='xygl5.asp?Indexid=" & rs.Fields("id").Value & "'>" & rs.Fields("t1") & "</A> - "
Response.Write rs.Fields("t1") & "<BR>"
Response.Write " <FONT SIZE=2>id: " & rs.Fields("id") & "</FONT>"
Response.Write "<HR SIZE=1 WIDTH=890 ALIGN=LEFT>"
rs.MoveNext
Loop
Response.Write "</UL>"
end if
%>
请问:如何在学员管理里输入班级代码(与班级管理里的班级代码一致)后,学员管理里的班级名称自动显示出来(自动显示出来的也与班级管理里的班级名称一致) 请高手帮忙把代码写一下,感谢万分!!
班级代码: <input name="b1" type="text" id="b1" size="15">
班级名称: <input name="b2" type="text" id="b2" size="15">
数据库文件为: !@#bbsxp.asa 所属表文件名为: bjgl
班级搜索代码与学员搜索代码类似学员管理的内容:
班级代码: <input type="text" id="t27" size="40">
班级名称: <input name="t28" type="text" id="t28" size="23" readonly="true">
数据库文件为: !@#bbsxp.asa 所属表文件名为: xygl 学员搜索的代码为:
<form method="post" action="sousuo1.asp?act=search"><table width="97%" border="0" align="center" class="a2">
<tr>
<td align="center">
搜索学员管理关键字:<input type="Text" name="x4"><input name="Submit" type="Submit" value="Submit"></td>
</tr>
</table></form>
<table width="97%" border="0" align="center" class="a2">
<tr>
<td class="a3">
<%
dim act
act=request("act")
if(act="search") then
x4 = Request.form( "x4" )
QueryWords = Split( x4 )
strIndent = " "
' 如果搜索为空则返回
If x4 = "" Then
Response.Redirect( "xylb.asp" )
End If
Session.timeout = 2
If IsObject(Session("sitesearch_conn")) Then
Set conn = Session("sitesearch_conn")
Else
Set conn = Server.CreateObject("ADODB.Connection")
conn.open "driver={Microsoft Access Driver (*.mdb)};dbq=" & Server.MapPath("database/!@#bbsxp.asa"),"",""
Set Session("sitesearch_conn") = conn
End If
' 查询语句
sql = "SELECT * FROM [xygl] WHERE"
'搜索t27字段
sql = sql & " ( [t1] LIKE '%" & QueryWords( 0 ) & "%'" ' First
For i = LBound( QueryWords ) + 1 to UBound( QueryWords )
If QueryWords( i ) <> "" and UCase( QueryWords(i) ) <> "OR" and UCase( QueryWords(i) ) <> "AND" Then
If uCase( QueryWords( i-1 ) ) = "OR" Then
sql = sql & " OR [t1] LIKE '%" & QueryWords( i ) & "%'"
Else
sql = sql & " AND [t1] LIKE '%" & QueryWords( i ) & "%'"
End If
End If
Next
' 搜索t28字段
sql = sql & " ) OR ( [t2] LIKE '%" & QueryWords( 0 ) & "%'"
For i = LBound( QueryWords ) + 1 to UBound( QueryWords )
If QueryWords( i ) <> "" and UCase( QueryWords(i) ) <> "OR" and UCase( QueryWords(i) ) <> "AND" Then
If uCase( QueryWords( i-1 ) ) = "OR" Then
sql = sql & " OR [t2] LIKE '%" & QueryWords( i ) & "%'"
Else
sql = sql & " AND [t2] LIKE '%" & QueryWords( i ) & "%'"
End If
End If
Next
sql = sql & " )"
'
Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open sql, conn, 3, 3
Response.Write "<BR><B> 你搜索的是: </B> " & x4
Response.Write "<BR><B> 搜索的关键字: </B> "
For i = LBound( QueryWords ) to UBound( QueryWords )
Response.Write "<BR>" & strIndent & i & ": " & QueryWords( i )
Next
' Print the SQL String
Response.Write "<BR><B> sql 语句 : </B> " & sql
' Print the Results
Response.Write "<BR><B> 结果: </B> <UL>"
On Error Resume Next
rs.MoveFirst
Do While Not rs.eof
Response.Write "<BR>" & "<A HREF='xygl5.asp?Indexid=" & rs.Fields("id").Value & "'>" & rs.Fields("t1") & "</A> - "
Response.Write rs.Fields("t1") & "<BR>"
Response.Write " <FONT SIZE=2>id: " & rs.Fields("id") & "</FONT>"
Response.Write "<HR SIZE=1 WIDTH=890 ALIGN=LEFT>"
rs.MoveNext
Loop
Response.Write "</UL>"
end if
%>
请问:如何在学员管理里输入班级代码(与班级管理里的班级代码一致)后,学员管理里的班级名称自动显示出来(自动显示出来的也与班级管理里的班级名称一致) 请高手帮忙把代码写一下,感谢万分!!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货