asp 问题:帮忙解释一下语句
<%
strStudentNum= Request("StudentNum")
strName=Request("Name")
strGrade=Request("Grade")
strClass=Request("ClassSelect")
set rsScore = Server.CreateObject("ADODB.Recordset")
rsScore.ActiveConnection = MM_StudentConn_STRING
strSQL = "Select " & strSheetName & ".StudentNum, StudentInfo.Name, " & strSubjects & " From " & strSheetName'引用变量表
strSQL = strSQL & " LEFT JOIN StudentInfo ON " & strSheetName & ".StudentNum = StudentInfo.StudentNum"
if (strStudentNum <> "") then
strSQL = strSQL & " Where " & strSheetName & ".StudentNum Like '%" & strStudentNum & "%'"
elseif (strName<>"") then
strSQL = strSQL & " Where StudentInfo.Name Like '%" & strName & "%'"
参考答案:strStudentNum= Request("StudentNum") //得到前一个网页传来的值
strName=Request("Name")
strGrade=Request("Grade")
strClass=Request("ClassSelect")
set rsScore = Server.CreateObject("ADODB.Recordset")//建立ado连接数据库的对象
rsScore.ActiveConnection = MM_StudentConn_STRING //当前连接为MM_StudentConn_STRING
strSQL = "Select " & strSheetName & ".StudentNum, StudentInfo.Name, " & strSubjects & " From " & strSheetName'引用变量表
strSQL = strSQL & " LEFT JOIN StudentInfo ON " & strSheetName & ".StudentNum = StudentInfo.StudentNum"
//设置sql语句
if (strStudentNum <> "") then //如果得到的值不为空
strSQL = strSQL & " Where " & strSheetName & ".StudentNum Like '%" & strStudentNum & "%'" //将条件加上
elseif (strName<>"") then
strSQL = strSQL & " Where StudentInfo.Name Like '%" & strName & "%'"