📄 addcourses_pre.asp
字号:
<!--#include file="../database/opendb.asp"-->
<%
'定义一个查询数据库值的函数
function defaultvalue(name)
sql="select content from info where english_name=" & "'" & name & "'"
rst.Open sql,my_conn,1,1
defaultvalue=rst("content")
rst.close
end function
%>
<html>
<head>
<script language = "javascript">
var iNowRowIndex = -1 //全局变量行数
var var_rowindex = 0 //全局变量行号
<!---^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^-->
function AddRow(obj)
{
if(iNowRowIndex != -1) iNowRowIndex ++ //修改全局变量行数
if(listtable.rows.length <= 2) iNowRowIndex = -1
//--------------
var TheNewRow = listtable.insertRow(iNowRowIndex) //插入行
var_rowindex = TheNewRow.rowIndex //修改全局变量行号
totalrecords=var_rowindex-1 //记录编号
//---------------
//下面的命名中又带入了行号,这样我们就可以对这个表中的变量进行分别标记了
//----------------
var inputbox = TheNewRow.insertCell() //插入第1个格
inputbox.bgColor ="#99ff66"
inputbox.align = "center"
inputbox.innerText = listtable.rows.length - 2 //输出行编号
//---------------
var inputbox = TheNewRow.insertCell()//插入第2个格
inputbox.innerHTML = "<input type = 'text' name = select_year" + totalrecords+ " size='20' value='<%=defaultvalue("default_year")%> 'style='width: 100%; height: 99%; font-size: 10pt'>"
//---------------
var inputbox = TheNewRow.insertCell()//插入第3个格
inputbox.innerHTML = "<input type = 'text' name = select_semester" + totalrecords+ " size='20' value='<%=defaultvalue("default_semester")%>' style='text-align: right;width: 100%; height: 99%; font-size: 10pt'>"
//---------------
var inputbox = TheNewRow.insertCell()//插入第4个格
inputbox.innerHTML = "<input type = 'text' name = select_institute" + totalrecords+ " size='20' value='<%=defaultvalue("default_institute")%>' style='text-align: right;width: 100%; height: 99%; font-size: 10pt'>"
//---------------
var inputbox = TheNewRow.insertCell()//插入第5个格
inputbox.innerHTML = "<input type = 'text' name = select_grade" + totalrecords+ " size='20' value='<%=defaultvalue("default_grade")%>' style='text-align: right;width: 100%; height: 99%; font-size: 10pt'>"
//---------------
var inputbox = TheNewRow.insertCell()//插入第6个格
inputbox.innerHTML = "<input type = 'text' name = select_major"+ totalrecords+ " size='20' value='<%=defaultvalue("default_major")%>' style='text-align: right;width: 100%; height: 99%; font-size: 10pt'>"
//---------------
//插入第7个格,是班级,已经删除
//---------------
var inputbox= TheNewRow.insertCell()//插入第8个格
inputbox.innerHTML = "<input type = 'text' name =name"+ totalrecords+ " size='20' value = '' style='text-align: right;width: 100%; height: 99%; font-size: 10pt'>"
//---------------
var inputbox = TheNewRow.insertCell()//插入第9个格
inputbox.align = "center"
inputbox.innerHTML = "<select name=select_begin_week" + totalrecords+ "> <option value='1' >1<option value='2' selected>2 <option value='3' >3<option value='4' >4<option value='5' >5<option value='6' >6<option value='7' >7<option value='8' >8<option value='9' >9<option value='10' >10<option value='11' >11<option value='12' >12<option value='13' >13 <option value='14 '>14<option value='15 '>15<option value='16 '>16<option value='17 '>17<option value='18 '>18<option value='19 '>19<option value='20 '>20</select>"
//---------------
var inputbox = TheNewRow.insertCell()//插入第10个格
inputbox.align = "center"
inputbox.innerHTML = "<select name=select_end_week"+ totalrecords+ "> <option value='1' >1<option value='2' selected>2 <option value='3' >3<option value='4' >4<option value='5' >5<option value='6' >6<option value='7' >7<option value='8' >8<option value='9' >9<option value='10' >10<option value='11' >11<option value='12' >12<option value='13' >13 <option value='14 '>14<option value='15 '>15<option value='16 '>16<option value='17 '>17<option value='18 '>18<option value='19 '>19<option value='20 '>20</select>"
//---------------
var inputbox = TheNewRow.insertCell()//插入第11个格
inputbox.align = "center"
inputbox.innerHTML = "<select name=select_week" + totalrecords+ "> <option value='1' >周一<option value='2' selected>周二 <option value='3' >周三<option value='4' >周四<option value='5' >周五</select>"
//---------------
var inputbox= TheNewRow.insertCell()//插入第12个格
inputbox.align = "center"
inputbox.innerHTML = "<select name=select_begin_time" + totalrecords+ "> <option value='1' >1<option value='2' selected>2 <option value='3' >3<option value='4' >4<option value='5' >5<option value='6' >6<option value='7' >7<option value='8' >8<option value='9' >9<option value='10' >10<option value='11' >11<option value='12' >12<option value='13' >13 <option value='14 '>14</select>"
//---------------
var inputbox = TheNewRow.insertCell()//插入第13个格
inputbox.align = "center"
inputbox.innerHTML = "<select name=select_end_time" + totalrecords+ "> <option value='1' >1<option value='2' selected>2 <option value='3' >3<option value='4' >4<option value='5' >5<option value='6' >6<option value='7' >7<option value='8' >8<option value='9' >9<option value='10' >10<option value='11' >11<option value='12' >12<option value='13' >13 <option value='14 '>14</select>"
//---------------
var inputbox = TheNewRow.insertCell()//插入第14个格
inputbox.innerHTML = "<input type = 'text' name = select_where" + totalrecords+ " size='20' value = '' style='text-align: right;width: 100%; height: 99%; font-size: 10pt'>"
//---------------
var inputbox= TheNewRow.insertCell()//插入第15个格
inputbox.innerHTML = "<textarea name = postscript" + totalrecords+ " rows='4'> </textarea>"
}
<!---^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^-->
function DelRow(obj)
{
if(listtable.rows.length > 2 && listtable.rows.length > iNowRowIndex) {
listtable.deleteRow(iNowRowIndex);//删除最后的一个行
listtable.totalrecords=listtable.rows.length-2 ; //这里其实相当于给listtable对象建立一个变量属性
}
if(listtable.rows.lenght <=2) obj.disabled = true
}
</script>
</head>
<body topmargin="0" leftmargin="0">
<!----------------------------------------------------------------------->
<form name = 'myform' action = 'add.asp' method = 'post' >
<!-----------------style1没定义,留给include此文件的文件定义--------------------------->
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#bbbbbb" width="100%" id="listtable">
<tr bgcolor="#FFFF66">
<td height="30" colspan="15" align="center">
<input type = "button" value = "添加一行" name = "addbut" onclick = "AddRow(delbut)">
<input type = "button" value = "删除一行" name = "delbut" onclick = "DelRow(this)">
<input type="submit" value="提交表单">
</td>
</tr>
<tr align = "center" bgcolor="#6699FF">
<td width = "10"height="25"><span class="style1">编号</span></td>
<td><span class="style1">学年</span></td>
<td><span class="style1">学期</span></td>
<td><span class="style1">学院</span></td>
<td><span class="style1">年级</span></td>
<td><span class="style1">专业</span></td>
<td><span class="style1">课程名称</span></td>
<td><span class="style1">开始周</span></td>
<td><span class="style1">结束周</span></td>
<td><span class="style1">周几</span></td>
<td><span class="style1">开始节</span></td>
<td><span class="style1">结束节</span></td>
<td><span class="style1">上课地点</span></td>
<td><span class="style1">备注</span></td>
</tr>
</table>
</form>
<!----------------------------------------------------------------------->
</body>
</html>
<html>
<!--#include file="../database/closedb.asp"-->⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -