单元格双击后可编辑，并无刷新提交，更新数据库。

最新推荐文章于 2019-01-18 17:40:34 发布

xuStanly

最新推荐文章于 2019-01-18 17:40:34 发布

阅读量1.8k

点赞数

文章标签：数据库 input function button stylesheet border

本文链接：https://blog.csdn.net/xuStanly/article/details/1412453

版权

一、数据库结构。

create table lessons(
    schoolId int,--学校ID
    classid int,--班级ID
    lessonId int,--课程ID，表示本课程是这一天的第几节课
    profession int,--课业ID，课程名称，语文、数学等
    teacher int,--任课老师ID
    dayOfWeek int,--星期，表示本课程处于星期几，1-7，星期一-星期日
    timeScale varchar(50)--课程时间段
)

二、数据提取存储过程

CREATE proc getLessonSchedule --取得课程表数据集
@school int,
@class int
as
declare @tmp int,@sql varchar(4000)
set @tmp=1
set @sql='select distinct lessonid'
while @tmp<8
begin
select @sql=@sql+',cast(sum(case dayofweek when '+cast(@tmp as char(1))+' then profession else 0 end) as varchar(10))+''|''+cast(sum(case dayofweek when '+cast(@tmp as char(1))+' then teacher else 0 end) as varchar(10))+''|''+cast(sum(case dayofweek when '+cast(@tmp as char(1))+' then dayofweek else 0 end) as varchar(10))+''|''+isnull(min(case dayofweek when '+cast(@tmp as char(1))+' then timescale end),'''')'
select @tmp=@tmp+1
end
select @sql=@sql+' from lessons where schoolid='+cast(@school as varchar(10))+' and classid='+cast(@class as varchar(10))+' group by lessonid order by lessonid asc'
execute(@sql)
GO

三、页面代码

<%数据库连接代码略%>
<%
set cmd = server.createobject("adodb.command")
with cmd
.activeconnection = conn
.commandtype = 4
.commandtext = "getLessonSchedule"
.prepared = true
.parameters.append .createparameter("@school",3,1,4,cint(session("SCHOOLID")))
.parameters.append .createparameter("@class",3,1,4,cint(session("CLASSID")))
set gridRs = .execute
end with
set cmd = nothing
dim grid
if not gridRs.EOF then
grid = gridRs.getrows()
else
grid = ""
end if
set gridRs = nothing

set tl = new selectitem'此为本人核心代码，生成<select>……</select>控件。下同
with tl '任课老师列表
.settransobject(conn)
.selectitemsql = "select teacherid,teachername from teachers where schoolid=" & session("SCHOOLID")
.selectitemname = "teach"
.selectitemlabel = "teachername"
.selectitemdata = "teacherid"
.selectitemextra = ""
.selectitemstyle = "width:78px"
.selectitemshowextra = true
end with

set ll = new selectitem
with ll '课业列表
.settransobject(conn)
.selectitemsql = "select profid,profname from professions where schoolid=" & session("SCHOOLID")
.selectitemname = "prof"
.selectitemlabel = "profname"
.selectitemdata = "profid"
.selectitemextra = ""
.selectitemstyle = "width:78px"
.selectitemshowextra = true
end with
%>
<html>
<head>
<title>课程表</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="../images/cs_1.css" rel="stylesheet" type="text/css">
<script language="jscript">
var p = "<%=ll.fillselectitem%>/n"; //课程
var t = "<%=tl.fillselectitem%>/n"; //老师
var d = "<input type='text' name='scale' size='11' maxlength='50'>" //时间段
var http = new ActiveXObject("Msxml2.XMLHTTP.3.0");
function doInsert(o){
var oTr = schd.rows(schd.rows.length - 1);
var nTr = schd.insertRow();
nTr.style.backgroundColor = "#ffffff";
var nTd;
nTd = nTr.insertCell();
nTd.style.textAlign = "center";
nTd.innerText = "第"+nTr.rowIndex+"节";
for(i=1;i<8;i++){
 nTd = nTr.insertCell();
 nTd.style.textAlign = "left";
 nTd.style.cursor = "hand";
 nTd.ondblclick = function(){doEdit(this);};
 nTd.innerHTML = p+t+d+
 "<input type='hidden' name='lessonid' value='"+nTr.rowIndex+"'>"+
 "<input type='hidden' name='dayofweek' value='"+i+"'>"
}
o.disabled = true;
btnDel.disabled = true;
}
function doEdit(srcObj){
var prof = "",teach = "",period = "";
for(i=0;i<srcObj.childNodes.length;i++){
 if(srcObj.childNodes[i].tagName == "SPAN"){
 var obj = srcObj.childNodes[i];
 switch(obj.name.toLowerCase()){
 case "profv" :
 prof = obj.innerText;
 break;
 case "teachv" :
 teach = obj.innerText;
 break;
 case "scalev" :
 period = obj.innerText;
 break;
 }
 }
}
srcObj.style.paddingLeft = "";
srcObj.innerHTML = p+t+d+
 "<input type='hidden' name='lessonid' value='"+srcObj.parentNode.rowIndex+"'>"+
 "<input type='hidden' name='dayofweek' value='"+srcObj.cellIndex+"'>"
for(i=0;i<srcObj.childNodes.length;i++){
 if(srcObj.childNodes[i].tagName == "SELECT" || srcObj.childNodes[i].tagName == "INPUT"){
 var obj = srcObj.childNodes[i];
 if(obj.name.toLowerCase() == "prof"){
 getSelectOption(obj,prof);
 }else if(obj.name.toLowerCase() == "teach"){
 getSelectOption(obj,teach);
 }else if(obj.name.toLowerCase() == "scale"){
 obj.value = period;
 }
 }
}
btnInsert.disabled = true;
btnDel.disabled = true;
}
function doDel(){
if(schd.rows.length > 1){ //标题栏不能删除
 if(confirm("删除后将无法恢复，是否确定删除？")){
 url = "delSchedule.asp?lessonid="+schd.rows(schd.rows.length - 1).rowIndex+"&tmp="+Math.random();
 http.open("GET",url,false);
 http.send();
 var xml = http.responseXML;
 if(xml.readyState == 4){
 schd.deleteRow();
 alert(xml.selectSingleNode("root/source").childNodes[0].nodeValue);
 }
 }
}
}
function doSave(){
var p = document.getElementsByName("prof"); //课程
var t = document.getElementsByName("teach"); //老师
var d = document.getElementsByName("scale"); //时间
var l = document.getElementsByName("lessonid"); //课程ID
var w = document.getElementsByName("dayofweek");//星期
var url = "";
var nn = 0
while(p.length > 0){
 url = "saveSchedule.asp?lessonid="+l[nn].value+"&prof="+p[nn].value+
 "&teach="+t[nn].value+"&dayofweek="+w[nn].value+"&scale="+d[nn].value+"&tmp="+Math.random();
 http.open("GET",url,false);
 http.send();
 var xml = http.responseXML;
 if(xml.readyState == 4){
 var code = xml.selectSingleNode("root/code").childNodes[0].nodeValue;
 if(code != "0"){
 alert(xml.selectSingleNode("root/source").childNodes[0].nodeValue);
 }
 var oTd = p[nn].parentNode;
 oTd.style.paddingLeft = "2px";
 oTd.innerHTML = ""+p[nn].options[p[nn].selectedIndex].text+" "+
 ""+t[nn].options[t[nn].selectedIndex].text+" "+
 ""+d[nn].value+" "
 }
}
btnInsert.disabled = false;
btnDel.disabled = false;
}
function getSelectOption(o,v){
for(n=0;n<o.options.length;n++){
 if(o.options[n].text == v){
 o.selectedIndex = n;
 }
}
}
function doCancel(){
var p = document.getElementsByName("prof"); //课程
if(p.length > 0) document.location.reload();
}
</script>
</head>
<body>
<table width="100%" cellpadding="0" cellspacing="1" border="0" bgcolor="#FFCC66" id="schd">
<tr>
 <td width="9%" bgcolor="#ffffff"></td>
 <td width="13%" bgcolor="#ffffff" align="center">星期一</td>
 <td width="13%" bgcolor="#ffffff" align="center">星期二</td>
 <td width="13%" bgcolor="#ffffff" align="center">星期三</td>
 <td width="13%" bgcolor="#ffffff" align="center">星期四</td>
 <td width="13%" bgcolor="#ffffff" align="center">星期五</td>
 <td width="13%" bgcolor="#ffffff" align="center">星期六</td>
 <td width="13%" bgcolor="#ffffff" align="center">星期日</td>
</tr>
<%if not isarray(grid) then '尚无课程表%>
<%
else '有课程表
dim lessonStr
for i = 0 to ubound(grid,2) '行
 response.write "<tr>"
 for j = 0 to ubound(grid) '列
 if j = 0 then
 response.write "<td align=center bgcolor=#ffffff>第" & grid(j,i) & "节</td>"
 else
'此处数据结构，请参看表结构及存储过程
'getSchlProfessionName、getSchlTeacherName此二function为根据课业或老师ID，取得相应的名称
 if not isnull(grid(j,i)) then
 lessonStr = split(grid(j,i),"|")
 response.write "<td οndblclick='doEdit(this)' align=left valign=top style='padding-left:2px;cursor:hand;word-break:break-all' bgcolor=#ffffff>"
 response.write "" & getSchlProfessionName(cint(lessonStr(0))) & " "
 response.write "" & getSchlTeacherName(cint(lessonStr(1))) & " "
 response.write "" & lessonStr(3) & " </td>"
 else
 response.write "<td align=left valign=top οndblclick='doEdit(this)' style='padding-left:2px;cursor:hand' bgcolor=#ffffff>"
 response.write " "
 response.write " "
 response.write " </td>"
 end if
 end if
 next
 response.write "</tr>"
next
end if
%>
</table>
<table width="100%" cellpadding="0" cellspacing="0" border="0">
<tr height="30"><td colspan="6" align="right">
 双击课程表，直接编辑。
 <input type="button" value="新增一行" id="btnInsert" οnclick="doInsert(this)">
 <input type="button" value="删除一行" id="btnDel" οnclick="doDel()">
 <input type="button" value="保　　存" id="btnSave" οnclick="doSave()">
 <input type="button" value="取　　消" id="btnCancel" οnclick="doCancel()">
</td></tr>
</table>
</body>
</html>

四、服务器端处理脚本

更新数据库，脚本略。

五、客户端源码

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>课程表</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="../images/cs_1.css" _fcksavedurl=""../images/cs_1.css"" rel="stylesheet" type="text/css">
<script language="jscript">
var p = "<select name='prof' size='1' style='width:78px' ><option value=''></option><option value='1'>语文</option><option value='2'>数学</option><option value='3'>英语</option><option value='4'>历史</option><option value='5'>地理</option><option value='6'>化学</option><option value='7'>物理</option><option value='9'>计算机</option></select>/n"; //课程
var t = "<select name='teach' size='1' style='width:78px' ><option value=''></option><option value='1'>贾宝玉</option><option value='2'>林黛玉</option></select>/n"; //老师
var d = "<input type='text' name='scale' size='11' maxlength='50'>" //时间段
var http = new ActiveXObject("Msxml2.XMLHTTP.3.0");
function doInsert(o){
var oTr = schd.rows(schd.rows.length - 1);
var nTr = schd.insertRow();
nTr.style.backgroundColor = "#ffffff";
var nTd;
nTd = nTr.insertCell();
nTd.style.textAlign = "center";
nTd.innerText = "第"+nTr.rowIndex+"节";
for(i=1;i<8;i++){
 nTd = nTr.insertCell();
 nTd.style.textAlign = "left";
 nTd.style.cursor = "hand";
 nTd.ondblclick = function(){doEdit(this);};
 nTd.innerHTML = p+t+d+
 "<input type='hidden' name='lessonid' value='"+nTr.rowIndex+"'>"+
 "<input type='hidden' name='dayofweek' value='"+i+"'>"
}
o.disabled = true;
btnDel.disabled = true;
}
function doEdit(srcObj){
var prof = "",teach = "",period = "";
for(i=0;i<srcObj.childNodes.length;i++){
 if(srcObj.childNodes[i].tagName == "SPAN"){
 var obj = srcObj.childNodes[i];
 switch(obj.name.toLowerCase()){
 case "profv" :
 prof = obj.innerText;
 break;
 case "teachv" :
 teach = obj.innerText;
 break;
 case "scalev" :
 period = obj.innerText;
 break;
 }
 }
}
srcObj.style.paddingLeft = "";
srcObj.innerHTML = p+t+d+
 "<input type='hidden' name='lessonid' value='"+srcObj.parentNode.rowIndex+"'>"+
 "<input type='hidden' name='dayofweek' value='"+srcObj.cellIndex+"'>"
for(i=0;i<srcObj.childNodes.length;i++){
 if(srcObj.childNodes[i].tagName == "SELECT" || srcObj.childNodes[i].tagName == "INPUT"){
 var obj = srcObj.childNodes[i];
 if(obj.name.toLowerCase() == "prof"){
 getSelectOption(obj,prof);
 }else if(obj.name.toLowerCase() == "teach"){
 getSelectOption(obj,teach);
 }else if(obj.name.toLowerCase() == "scale"){
 obj.value = period;
 }
 }
}
btnInsert.disabled = true;
btnDel.disabled = true;
}
function doDel(){
if(schd.rows.length > 1){ //标题栏不能删除
 if(confirm("删除后将无法恢复，是否确定删除？")){
 url = "delSchedule.asp?lessonid="+schd.rows(schd.rows.length - 1).rowIndex+"&tmp="+Math.random();
 http.open("GET",url,false);
 http.send();
 var xml = http.responseXML;
 if(xml.readyState == 4){
 schd.deleteRow();
 alert(xml.selectSingleNode("root/source").childNodes[0].nodeValue);
 }
 }
}
}
function doSave(){
var p = document.getElementsByName("prof"); //课程
var t = document.getElementsByName("teach"); //老师
var d = document.getElementsByName("scale"); //时间
var l = document.getElementsByName("lessonid"); //课程ID
var w = document.getElementsByName("dayofweek");//星期
var url = "";
var nn = 0
while(p.length > 0){
 url = "saveSchedule.asp?lessonid="+l[nn].value+"&prof="+p[nn].value+
 "&teach="+t[nn].value+"&dayofweek="+w[nn].value+"&scale="+d[nn].value+"&tmp="+Math.random();
 http.open("GET",url,false);
 http.send();
 var xml = http.responseXML;
 if(xml.readyState == 4){
 var code = xml.selectSingleNode("root/code").childNodes[0].nodeValue;
 if(code != "0"){
 alert(xml.selectSingleNode("root/source").childNodes[0].nodeValue);
 }
 var oTd = p[nn].parentNode;
 oTd.style.paddingLeft = "2px";
 oTd.innerHTML = ""+p[nn].options[p[nn].selectedIndex].text+" "+
 ""+t[nn].options[t[nn].selectedIndex].text+" "+
 ""+d[nn].value+" "
 }
}
btnInsert.disabled = false;
btnDel.disabled = false;
}
function getSelectOption(o,v){
for(n=0;n<o.options.length;n++){
 if(o.options[n].text == v){
 o.selectedIndex = n;
 }
}
}
function doCancel(){
var p = document.getElementsByName("prof"); //课程
if(p.length > 0) document.location.reload();
}
</script>
</head>
<body>
<table width="100%" cellpadding="0" cellspacing="1" border="0" bgcolor="#FFCC66" id="schd">
<tr>
 <td width="9%" bgcolor="#ffffff"></td>
 <td width="13%" bgcolor="#ffffff" align="center">星期一</td>
 <td width="13%" bgcolor="#ffffff" align="center">星期二</td>
 <td width="13%" bgcolor="#ffffff" align="center">星期三</td>
 <td width="13%" bgcolor="#ffffff" align="center">星期四</td>
 <td width="13%" bgcolor="#ffffff" align="center">星期五</td>
 <td width="13%" bgcolor="#ffffff" align="center">星期六</td>
 <td width="13%" bgcolor="#ffffff" align="center">星期日</td>
</tr>
<tr><td align=center bgcolor=#ffffff>第1节</td><td οndblclick='doEdit(this)' align=left valign=top style='padding-left:2px;cursor:hand;word-break:break-all' bgcolor=#ffffff>数学 林黛玉 7:50-8:35 </td><td οndblclick='doEdit(this)' align=left valign=top style='padding-left:2px;cursor:hand;word-break:break-all' bgcolor=#ffffff>地理 贾宝玉 7:50-8:35 </td><td οndblclick='doEdit(this)' align=left valign=top style='padding-left:2px;cursor:hand;word-break:break-all' bgcolor=#ffffff>数学 林黛玉 7:50-8:35 </td><td οndblclick='doEdit(this)' align=left valign=top style='padding-left:2px;cursor:hand;word-break:break-all' bgcolor=#ffffff>地理 林黛玉 7:50-8:35 </td><td οndblclick='doEdit(this)' align=left valign=top style='padding-left:2px;cursor:hand;word-break:break-all' bgcolor=#ffffff>化学 林黛玉 7:50-8:35 </td><td οndblclick='doEdit(this)' align=left valign=top style='padding-left:2px;cursor:hand;word-break:break-all' bgcolor=#ffffff> </td><td οndblclick='doEdit(this)' align=left valign=top style='padding-left:2px;cursor:hand;word-break:break-all' bgcolor=#ffffff> </td></tr><tr><td align=center bgcolor=#ffffff>第2节</td><td οndblclick='doEdit(this)' align=left valign=top style='padding-left:2px;cursor:hand;word-break:break-all' bgcolor=#ffffff>英语 贾宝玉 8:45-9:30 </td><td οndblclick='doEdit(this)' align=left valign=top style='padding-left:2px;cursor:hand;word-break:break-all' bgcolor=#ffffff>地理 林黛玉 8:45-9:30 </td><td οndblclick='doEdit(this)' align=left valign=top style='padding-left:2px;cursor:hand;word-break:break-all' bgcolor=#ffffff>数学 贾宝玉 8:45-9:30 </td><td οndblclick='doEdit(this)' align=left valign=top style='padding-left:2px;cursor:hand;word-break:break-all' bgcolor=#ffffff>化学 贾宝玉 8:45-9:30 </td><td οndblclick='doEdit(this)' align=left valign=top style='padding-left:2px;cursor:hand;word-break:break-all' bgcolor=#ffffff>地理 贾宝玉 8:45-9:30 </td><td οndblclick='doEdit(this)' align=left valign=top style='padding-left:2px;cursor:hand;word-break:break-all' bgcolor=#ffffff> </td><td οndblclick='doEdit(this)' align=left valign=top style='padding-left:2px;cursor:hand;word-break:break-all' bgcolor=#ffffff> </td></tr><tr><td align=center bgcolor=#ffffff>第3节</td><td οndblclick='doEdit(this)' align=left valign=top style='padding-left:2px;cursor:hand;word-break:break-all' bgcolor=#ffffff>地理 贾宝玉 9:50-10:35 </td><td οndblclick='doEdit(this)' align=left valign=top style='padding-left:2px;cursor:hand;word-break:break-all' bgcolor=#ffffff>物理 林黛玉 9:50-10:35 </td><td οndblclick='doEdit(this)' align=left valign=top style='padding-left:2px;cursor:hand;word-break:break-all' bgcolor=#ffffff>英语 贾宝玉 9:50-10:35 </td><td οndblclick='doEdit(this)' align=left valign=top style='padding-left:2px;cursor:hand;word-break:break-all' bgcolor=#ffffff>计算机 林黛玉 9:50-10:35 </td><td οndblclick='doEdit(this)' align=left valign=top style='padding-left:2px;cursor:hand;word-break:break-all' bgcolor=#ffffff>英语 贾宝玉 9:50-10:35 </td><td οndblclick='doEdit(this)' align=left valign=top style='padding-left:2px;cursor:hand;word-break:break-all' bgcolor=#ffffff> </td><td οndblclick='doEdit(this)' align=left valign=top style='padding-left:2px;cursor:hand;word-break:break-all' bgcolor=#ffffff> </td></tr><tr><td align=center bgcolor=#ffffff>第4节</td><td οndblclick='doEdit(this)' align=left valign=top style='padding-left:2px;cursor:hand;word-break:break-all' bgcolor=#ffffff>物理 贾宝玉 10:45-11:30 </td><td οndblclick='doEdit(this)' align=left valign=top style='padding-left:2px;cursor:hand;word-break:break-all' bgcolor=#ffffff>计算机 林黛玉 10:45-11:30 </td><td οndblclick='doEdit(this)' align=left valign=top style='padding-left:2px;cursor:hand;word-break:break-all' bgcolor=#ffffff>物理 贾宝玉 10:45-11:30 </td><td οndblclick='doEdit(this)' align=left valign=top style='padding-left:2px;cursor:hand;word-break:break-all' bgcolor=#ffffff>英语 贾宝玉 10:45-11:30 </td><td οndblclick='doEdit(this)' align=left valign=top style='padding-left:2px;cursor:hand;word-break:break-all' bgcolor=#ffffff>数学 林黛玉 10:45-11:30 </td><td οndblclick='doEdit(this)' align=left valign=top style='padding-left:2px;cursor:hand;word-break:break-all' bgcolor=#ffffff> </td><td οndblclick='doEdit(this)' align=left valign=top style='padding-left:2px;cursor:hand;word-break:break-all' bgcolor=#ffffff> </td></tr><tr><td align=center bgcolor=#ffffff>第5节</td><td οndblclick='doEdit(this)' align=left valign=top style='padding-left:2px;cursor:hand;word-break:break-all' bgcolor=#ffffff>地理 林黛玉 14:00-14:45 </td><td οndblclick='doEdit(this)' align=left valign=top style='padding-left:2px;cursor:hand;word-break:break-all' bgcolor=#ffffff>历史 林黛玉 14:00-14:45 </td><td οndblclick='doEdit(this)' align=left valign=top style='padding-left:2px;cursor:hand;word-break:break-all' bgcolor=#ffffff>历史 贾宝玉 14:00-14:45 </td><td οndblclick='doEdit(this)' align=left valign=top style='padding-left:2px;cursor:hand;word-break:break-all' bgcolor=#ffffff>历史 林黛玉 14:00-14:45 </td><td οndblclick='doEdit(this)' align=left valign=top style='padding-left:2px;cursor:hand;word-break:break-all' bgcolor=#ffffff>计算机 贾宝玉 14:00-14:45 </td><td οndblclick='doEdit(this)' align=left valign=top style='padding-left:2px;cursor:hand;word-break:break-all' bgcolor=#ffffff> </td><td οndblclick='doEdit(this)' align=left valign=top style='padding-left:2px;cursor:hand;word-break:break-all' bgcolor=#ffffff> </td></tr><tr><td align=center bgcolor=#ffffff>第6节</td><td οndblclick='doEdit(this)' align=left valign=top style='padding-left:2px;cursor:hand;word-break:break-all' bgcolor=#ffffff>地理 林黛玉 15:00-15:45 </td><td οndblclick='doEdit(this)' align=left valign=top style='padding-left:2px;cursor:hand;word-break:break-all' bgcolor=#ffffff>地理 贾宝玉 15:00-15:50 </td><td οndblclick='doEdit(this)' align=left valign=top style='padding-left:2px;cursor:hand;word-break:break-all' bgcolor=#ffffff>地理 林黛玉 15:00-15:45 </td><td οndblclick='doEdit(this)' align=left valign=top style='padding-left:2px;cursor:hand;word-break:break-all' bgcolor=#ffffff>地理 林黛玉 15:00-15:45 </td><td οndblclick='doEdit(this)' align=left valign=top style='padding-left:2px;cursor:hand;word-break:break-all' bgcolor=#ffffff>地理 林黛玉 15:00-15:45 </td><td οndblclick='doEdit(this)' align=left valign=top style='padding-left:2px;cursor:hand;word-break:break-all' bgcolor=#ffffff> </td><td οndblclick='doEdit(this)' align=left valign=top style='padding-left:2px;cursor:hand;word-break:break-all' bgcolor=#ffffff> </td></tr><tr><td align=center bgcolor=#ffffff>第7节</td><td οndblclick='doEdit(this)' align=left valign=top style='padding-left:2px;cursor:hand;word-break:break-all' bgcolor=#ffffff>语文 贾宝玉 16:00-16:45 </td><td οndblclick='doEdit(this)' align=left valign=top style='padding-left:2px;cursor:hand;word-break:break-all' bgcolor=#ffffff>英语 林黛玉 16:00-16:45 </td><td οndblclick='doEdit(this)' align=left valign=top style='padding-left:2px;cursor:hand;word-break:break-all' bgcolor=#ffffff>数学 贾宝玉 16:00-16:45 </td><td οndblclick='doEdit(this)' align=left valign=top style='padding-left:2px;cursor:hand;word-break:break-all' bgcolor=#ffffff>化学 贾宝玉 16:00-16:45 </td><td οndblclick='doEdit(this)' align=left valign=top style='padding-left:2px;cursor:hand;word-break:break-all' bgcolor=#ffffff>物理 林黛玉 16:00-16:45 </td><td οndblclick='doEdit(this)' align=left valign=top style='padding-left:2px;cursor:hand;word-break:break-all' bgcolor=#ffffff> </td><td οndblclick='doEdit(this)' align=left valign=top style='padding-left:2px;cursor:hand;word-break:break-all' bgcolor=#ffffff> </td></tr>
</table>
<table width="100%" cellpadding="0" cellspacing="0" border="0">
<tr height="30"><td colspan="6" align="right">
 双击课程表，直接编辑。
 <input type="button" value="新增一行" id="btnInsert" οnclick="doInsert(this)">
 <input type="button" value="删除一行" id="btnDel" οnclick="doDel()">
 <input type="button" value="保　　存" id="btnSave" οnclick="doSave()">
 <input type="button" value="取　　消" id="btnCancel" οnclick="doCancel()">
</td></tr>
</table>
</body>
</html>

xuStanly

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
单元格双击后可编辑，并无刷新提交，更新数据库。

一、数据库结构。create table lessons( schoolId int,--学校ID classid int,--班级ID lessonId int,--课程ID，表示本课程是这一天的第几节课 profession int,--课业ID，课程名称，语文、数学等 teacher int,--任课老师ID dayOfWeek int,--星期，表示
复制链接

扫一扫