28,391
社区成员
发帖
与我相关
我的任务
分享
<%
Dim getSelectedIndex
Dim getSNO, getSCLASS, getSNAME, getCNO, getGRADE
'//从“iStuDisplay.asp”获取:学号、班级、课程号、成绩
getSelectedIndex = Request("selectedIndex")
getSNO = Request("txtSNO" &getSelectedIndex)
getSNAME = Request("txtSName" &getSelectedIndex)
getSCLASS = Request("txtSCLASS" &getSelectedIndex)
getCNO = Request("txtCNO" &getSelectedIndex)
getGRADE = Request("txtGRADE" &getSelectedIndex)
%>
<!--打印从“iStuDisplay.asp”获取的“学号、班级、课程号、成绩”信息-->
<b><font size = "2" color = "Maroon">您所需要修改的记录如下:</font></b><br>
<table width="40%" border="1" bordercolor="DarkSlateGray" cellspacing="1" cellpadding="3">
<tr bgcolor=DarkBlue >
<th><font size='2' color="White">学号</font></th>
<th><font size='2' color="White">姓名</font></th>
<th><font size='2' color="White">班级</font></th>
<th><font size='2' color="White">课程号</font></th>
<th><font size='2' color="White">成绩</font></th>
</tr>
<%
Response.Write("<tr bgcolor = white>")
Response.Write("<td><font size='2'>"&getSNO&"</font></td>")
Response.Write("<td><font size='2'>"&getSCLASS&"</font></td>")
Response.Write("<td><font size='2'>"&getSNAME&"</font></td>")
Response.Write("<td><font size='2'>"&getCNO&"</font></td>")
Response.Write("<td><font size='2'>"&getGRADE&"</font></td>")
Response.Write("</tr>")
%>
</table>
<html>
<body>
<body style="background-color:DarkSeaGreen;">
<form name = "updateForm">
<font size = "2">修改为:<input type = "text" name = "txtUpdateScore" size ="4" maxlength = "3"> 分 <input type = "Button" name = "btnUpdateScore" value = "点击修改" onclick = "btnUpdateScoreCheck()">
</form></font>
<script language = "Javascript">
function btnUpdateScoreCheck()
{
if (window.confirm("是否确定修改?") == true )
{
//如果选择“是”则执行修改操作
document.updateForm.action = "iStuUpdating.asp";
document.updateForm.target = "_self";
document.updateForm.method = "post";
document.updateForm.submit();
//执行以后这段代码就不见了,报错了!
<%
'//从“iStuUpdating.asp”(即本页面)获取输入的需要修改的分数值
Dim getTxtUpdateScore
getTxtUpdateScore = Request("txtUpdateScore")
Dim Conn, rs
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "provider=SQLOLEDB; Database=stumgr;data source=.;uid=sa;pwd=222222"
Set rs = Server.CreateObject("ADODB.Recordset")
SQL ="UPDATE STU_GRADE SET grade = "&getTxtUpdateScore&" WHERE sno = '"&getSNO&"' AND cno = '"&getCNO&"' AND grade = "&getGRADE
rs.open SQL,Conn,1,1
Conn.Close
Set Conn = Nothing
Response.Redirect "iStuDisplay.asp"
%>
}
}
</script>
</body>
</html>
<html>
<head>
<title>iStudentPlus</title>
</head>
<body>
<body style="background-color:DarkSeaGreen;">
<!--#include file="ButtonFile.inc"-->
<script language = "Javascript">
function UpdateRecord(idx)
{
document.dbForm.selectedIndex.value = idx;
document.dbForm.action = "iStuUpdating.asp";
document.dbForm.target = "_self";
document.dbForm.method = "post";
document.dbForm.submit();
}
function DeleteRecord(idx)
{
if(window.confirm("是否确定删除?") == true)
{
document.dbForm.selectedIndex.value = idx;
document.dbForm.action = "iStuDeleting.asp";
document.dbForm.target = "_self";
document.dbForm.method = "post";
document.dbForm.submit();
}
}
</script>
<%
Dim Conn, rs
Set Conn=Server.CreateObject("ADODB.Connection")
Conn.Open "provider=SQLOLEDB; Database=stumgr;data source=.;uid=sa;pwd=222222"
Set rs=Server.CreateObject("ADODB.Recordset")
SQL="SELECT STU_INFO.sno,STU_INFO.sname,STU_INFO.sclass,STU_GRADE.cno,STU_GRADE.grade "
SQL=SQL+"FROM STU_INFO INNER JOIN STU_GRADE ON STU_INFO.sno=STU_GRADE.sno ORDER BY STU_INFO.sno ASC"
rs.open SQL,Conn,1,1
Response.write("<b>成绩显示</b><br /><br />")
%>
<form name="dbForm">
<!--显示数据库查询结果,输出在页面上-->
<table width="40%" border="1" bordercolor="DarkSlateGray" cellspacing="1" cellpadding="3">
<tr bgcolor=DarkBlue >
<th><font size='2' color="White">学号</font></th>
<th><font size='2' color="White">姓名</font></th>
<th><font size='2' color="White">班级</font></th>
<th><font size='2' color="White">课程号</font></th>
<th><font size='2' color="White">成绩</font></th>
<th><font size='2' color="White">修改</font></th>
<th><font size='2' color="White">删除</font></th>
</tr>
<%
Dim idx
idx = 0
Do While Not rs.eof
idx = idx + 1
Response.Write("<td><font size='2'><input type='text' name='txtSNO"&idx&"' value='"&rs("sno")&"'/></font></td>")
Response.Write("<td><font size='2'><input type='text' name='txtSNAME"&idx&"' value='"&rs("sname")&"'/></font></td>")
Response.Write("<td><font size='2'><input type='text' name='txtSCLASS"&idx&"' value='"&rs("sclass")&"'/></font></td>")
Response.Write("<td><font size='2'><input type='text' name='txtCNO"&idx&"' value='"&rs("cno")&"'/></font></td>")
Response.Write("<td><font size='2'><input type='text' name='txtGRADE"&idx&"' value='"&rs("grade")&"'/></font></td>")
Response.write "<td><input type='button' name='btnUpdate"&idx&"' value='修改' onclick='UpdateRecord("&idx&")'></td>"
Response.write "<td><input type='button' name='btnDelete"&idx&"' value='删除' onclick='DeleteRecord("&idx&")'></td>"
Response.Write("</tr>")
rs.MoveNext
Loop
rs.close()
set rs=nothing
Conn.close()
set Conn=nothing
%>
</table>
<input type="hidden" name="selectedIndex"/>
</form>
</body>
</html>
<%
Dim getSelectedIndex
Dim getSNO, getSCLASS, getSNAME, getCNO, getGRADE
'//从“iStuDisplay.asp”获取:学号、班级、课程号、成绩
getSelectedIndex = Request("selectedIndex")
getSNO = Request("txtSNO" &getSelectedIndex)
getSNAME = Request("txtSName" &getSelectedIndex)
getSCLASS = Request("txtSCLASS" &getSelectedIndex)
getCNO = Request("txtCNO" &getSelectedIndex)
getGRADE = Request("txtGRADE" &getSelectedIndex)
%>
<!--打印从“iStuDisplay.asp”获取的“学号、班级、课程号、成绩”信息-->
<b><font size = "2" color = "Maroon">您所需要修改的记录如下:</font></b><br>
<table width="40%" border="1" bordercolor="DarkSlateGray" cellspacing="1" cellpadding="3">
<tr bgcolor=DarkBlue >
<th><font size='2' color="White">学号</font></th>
<th><font size='2' color="White">姓名</font></th>
<th><font size='2' color="White">班级</font></th>
<th><font size='2' color="White">课程号</font></th>
<th><font size='2' color="White">成绩</font></th>
</tr>
<%
Response.Write("<tr bgcolor = white>")
Response.Write("<td><font size='2'>"&getSNO&"</font></td>")
Response.Write("<td><font size='2'>"&getSCLASS&"</font></td>")
Response.Write("<td><font size='2'>"&getSNAME&"</font></td>")
Response.Write("<td><font size='2'>"&getCNO&"</font></td>")
Response.Write("<td><font size='2'>"&getGRADE&"</font></td>")
Response.Write("</tr>")
%>
</table>
<html>
<body>
<body style="background-color:DarkSeaGreen;">
<script language = "Javascript">
function btnUpdateScoreCheck()
{
document.updateForm.isUpdateDB.value = false;
if (window.confirm("是否确定修改?") == true )
{
alert("!");
document.updateForm.isUpdateDB.value = true;
document.updateForm.action = "iStuUpdating.asp";
document.updateForm.target = "_self";
document.updateForm.method = "post";
document.updateForm.submit();
}
}
</script>
<form name = "updateForm">
<font size = "2">修改为:<input type = "text" name = "txtUpdateScore" size ="4" maxlength = "3"> 分 <input type = "Button" name = "btnUpdateScore" value = "点击修改" onclick = "btnUpdateScoreCheck()">
<input type = "hidden" name = "isUpdateDB">
<input type = "hidden" name = "transferSNO">
<input type = "hidden" name = "transferCNO">
</form></font>
</body>
</html>
<%
Dim getTxtUpdateScore
Dim getIsUpdateDB
getTxtUpdateScore = Request("txtUpdateScore") '获取Text框中需要修改的分数
getIsUpdateDB = Request("isUpdateDB") '获取hidden的isUpdateDB值,用于判断是否进行数据库操作
If (getIsUpdateDB) Then
'//从“iStuUpdating.asp”(即本页面)获取输入的需要修改的分数值
Dim Conn, rs
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "provider=SQLOLEDB; Database=stumgr;data source=.;uid=sa;pwd=222222"
Set rs = Server.CreateObject("ADODB.Recordset")
SQL ="UPDATE STU_GRADE SET grade = "&getTxtUpdateScore&" WHERE sno='"&getSNO&"' AND cno='"&getCNO&"'"
rs.open SQL,Conn,1,1
Conn.Close
Set Conn = Nothing
Response.Redirect "iStuDisplay.asp"
End If
%>
<script language = "Javascript">
function btnUpdateScoreCheck()
{
document.updateForm.isUpdateDB.value = false;
if (window.confirm("是否确定修改?") == true )
{
alert("!");
document.updateForm.isUpdateDB.value = true;
document.updateForm.action = "iStuUpdating.asp";
document.updateForm.target = "_self";
document.updateForm.method = "post";
document.updateForm.submit();
}
}
</script>
<%
Dim getTxtUpdateScore
Dim getIsUpdateDB
getTxtUpdateScore = Request("txtUpdateScore") '获取Text框中需要修改的分数
getIsUpdateDB = Request("isUpdateDB") '获取hidden的isUpdateDB值,用于判断是否进行数据库操作
If (getIsUpdateDB) Then
'//从“iStuUpdating.asp”(即本页面)获取输入的需要修改的分数值
Dim Conn, rs
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "provider=SQLOLEDB; Database=stumgr;data source=.;uid=sa;pwd=222222"
Set rs = Server.CreateObject("ADODB.Recordset")
SQL ="UPDATE STU_GRADE SET grade = "&getTxtUpdateScore&" WHERE sno='"&getSNO&"' AND cno='"&getCNO&"'" '//SQL语句中的getSNO和getCNO都是空值,所以最后的Update操作失败
Conn.execute SQL, affect_row
Conn.Close
Set Conn = Nothing
Response.Redirect "iStuDisplay.asp"
End If
%>
<%
Dim getTxtUpdateScore
Dim getIsUpdateDB
getTxtUpdateScore = Request("txtUpdateScore") '获取Text框中需要修改的分数
getIsUpdateDB = Request("isUpdateDB") '获取hidden的isUpdateDB值,用于判断是否进行数据库操作
If (getIsUpdateDB) Then
'//从“iStuUpdating.asp”(即本页面)获取输入的需要修改的分数值
Dim Conn, rs
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "provider=SQLOLEDB; Database=stumgr;data source=.;uid=sa;pwd=222222"
Set rs = Server.CreateObject("ADODB.Recordset")
SQL ="UPDATE STU_GRADE SET grade = "&getTxtUpdateScore&" WHERE sno='"&getSNO&"' AND cno='"&getCNO&"'"
rs.open SQL,Conn,1,1
Conn.Close
Set Conn = Nothing
Response.Redirect "iStuDisplay.asp"
End If
%>
Conn.execute SQL, affect_row
<%
Dim getSelectedIndex
Dim getSNO, getSCLASS, getSNAME, getCNO, getGRADE
'//从“iStuDisplay.asp”获取:学号、班级、课程号、成绩
getSelectedIndex = Request("selectedIndex")
getSNO = Request("txtSNO" &getSelectedIndex)
getSNAME = Request("txtSName" &getSelectedIndex)
getSCLASS = Request("txtSCLASS" &getSelectedIndex)
getCNO = Request("txtCNO" &getSelectedIndex)
getGRADE = Request("txtGRADE" &getSelectedIndex)
%>
<!--打印从“iStuDisplay.asp”获取的“学号、班级、课程号、成绩”信息-->
<b><font size = "2" color = "Maroon">您所需要修改的记录如下:</font></b><br>
<table width="40%" border="1" bordercolor="DarkSlateGray" cellspacing="1" cellpadding="3">
<tr bgcolor=DarkBlue >
<th><font size='2' color="White">学号</font></th>
<th><font size='2' color="White">姓名</font></th>
<th><font size='2' color="White">班级</font></th>
<th><font size='2' color="White">课程号</font></th>
<th><font size='2' color="White">成绩</font></th>
</tr>
<%
Response.Write("<tr bgcolor = white>")
Response.Write("<td><font size='2'>"&getSNO&"</font></td>")
Response.Write("<td><font size='2'>"&getSCLASS&"</font></td>")
Response.Write("<td><font size='2'>"&getSNAME&"</font></td>")
Response.Write("<td><font size='2'>"&getCNO&"</font></td>")
Response.Write("<td><font size='2'>"&getGRADE&"</font></td>")
Response.Write("</tr>")
%>
</table>
<html>
<body>
<body style="background-color:DarkSeaGreen;">
<script language = "Javascript">
function btnUpdateScoreCheck()
{
document.updateForm.isUpdateDB.value = false;
if (window.confirm("是否确定修改?") == true )
{
alert("!");
document.updateForm.isUpdateDB.value = true;
document.updateForm.action = "iStuUpdating.asp";
document.updateForm.target = "_self";
document.updateForm.method = "post";
document.updateForm.submit();
}
}
</script>
<form name = "updateForm">
<font size = "2">修改为:<input type = "text" name = "txtUpdateScore" size ="4" maxlength = "3"> 分 <input type = "Button" name = "btnUpdateScore" value = "点击修改" onclick = "btnUpdateScoreCheck()">
<input type = "hidden" name = "isUpdateDB">
</form></font>
</body>
</html>
<%
Dim getTxtUpdateScore
Dim getIsUpdateDB
getTxtUpdateScore = Request("txtUpdateScore") '获取Text框中需要修改的分数
getIsUpdateDB = Request("isUpdateDB") '获取hidden的isUpdateDB值,用于判断是否进行数据库操作
If (getIsUpdateDB) Then
'//从“iStuUpdating.asp”(即本页面)获取输入的需要修改的分数值
Dim Conn, rs
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "provider=SQLOLEDB; Database=stumgr;data source=.;uid=sa;pwd=222222"
Set rs = Server.CreateObject("ADODB.Recordset")
SQL ="UPDATE STU_GRADE SET grade = "&getTxtUpdateScore&" WHERE sno='"&getSNO&"' AND cno='"&getCNO&"'"
rs.open SQL,Conn,1,1
Conn.Close
Set Conn = Nothing
Response.Redirect "iStuDisplay.asp"
End If
%>
<script language = "Javascript">
function btnUpdateScoreCheck()
{
document.updateForm.isUpdateDB = false;
if (window.confirm("是否确定修改?") == true )
{
document.updateForm.isUpdateDB.value = true;
document.updateForm.action = "iStuUpdating.asp";
document.updateForm.target = "_self";
document.updateForm.method = "post";
document.updateForm.submit();
}
}
</script>
if (window.confirm("是否确定修改?") == true )
{
document.updateForm.isUpdateDB = true;
document.updateForm.action = "iStuUpdating.asp";
document.updateForm.target = "_self";
document.updateForm.method = "post";
document.updateForm.submit();
}
<%
Dim getSelectedIndex
Dim getSNO, getSCLASS, getSNAME, getCNO, getGRADE
'//从“iStuDisplay.asp”获取:学号、班级、课程号、成绩
getSelectedIndex = Request("selectedIndex")
getSNO = Request("txtSNO" &getSelectedIndex)
getSNAME = Request("txtSName" &getSelectedIndex)
getSCLASS = Request("txtSCLASS" &getSelectedIndex)
getCNO = Request("txtCNO" &getSelectedIndex)
getGRADE = Request("txtGRADE" &getSelectedIndex)
%>
<!--打印从“iStuDisplay.asp”获取的“学号、班级、课程号、成绩”信息-->
<b><font size = "2" color = "Maroon">您所需要修改的记录如下:</font></b><br>
<table width="40%" border="1" bordercolor="DarkSlateGray" cellspacing="1" cellpadding="3">
<tr bgcolor=DarkBlue >
<th><font size='2' color="White">学号</font></th>
<th><font size='2' color="White">姓名</font></th>
<th><font size='2' color="White">班级</font></th>
<th><font size='2' color="White">课程号</font></th>
<th><font size='2' color="White">成绩</font></th>
</tr>
<%
Response.Write("<tr bgcolor = white>")
Response.Write("<td><font size='2'>"&getSNO&"</font></td>")
Response.Write("<td><font size='2'>"&getSCLASS&"</font></td>")
Response.Write("<td><font size='2'>"&getSNAME&"</font></td>")
Response.Write("<td><font size='2'>"&getCNO&"</font></td>")
Response.Write("<td><font size='2'>"&getGRADE&"</font></td>")
Response.Write("</tr>")
%>
</table>
<html>
<body>
<body style="background-color:DarkSeaGreen;">
<form name = "updateForm">
<font size = "2">修改为:<input type = "text" name = "txtUpdateScore" size ="4" maxlength = "3"> 分 <input type = "Button" name = "btnUpdateScore" value = "点击修改" onclick = "btnUpdateScoreCheck()">
<input type = "hidden" name = "isUpdateDB">
</form></font>
<script language = "Javascript">
function btnUpdateScoreCheck()
{
document.updateForm.isUpdateDB = false;
if (window.confirm("是否确定修改?") == true )
{
document.updateForm.isUpdateDB = true;
document.updateForm.action = "iStuUpdating.asp";
document.updateForm.target = "_self";
document.updateForm.method = "post";
document.updateForm.submit();
}
}
</script>
</body>
</html>
<%
If (isUpdateDB = true) Then
Dim getSelectedIndex
Dim getSNO, getSCLASS, getSNAME, getCNO, getGRADE
getSelectedIndex = Request("selectedIndex")
getSNO = Request("txtSNO" &getSelectedIndex)
getSCLASS = Request("txtSCLASS" &getSelectedIndex)
getCNO = Request("txtCNO" &getSelectedIndex)
getGRADE = Request("txtGRADE" &getSelectedIndex)
'//从“iStuUpdating.asp”(即本页面)获取输入的需要修改的分数值
Dim getTxtUpdateScore
getTxtUpdateScore = Request("txtUpdateScore")
Dim Conn, rs
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "provider=SQLOLEDB; Database=stumgr;data source=.;uid=sa;pwd=222222"
Set rs = Server.CreateObject("ADODB.Recordset")
SQL ="UPDATE STU_GRADE SET grade = "&getTxtUpdateScore&" WHERE sno = '"&getSNO&"' AND cno = '"&getCNO&"' AND grade = "&getGRADE
rs.open SQL,Conn,1,1
Conn.Close
Set Conn = Nothing
Response.Redirect "iStuDisplay.asp"
End If
%>