WebRoot/xueshengkaoqin_updt.jsp

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

<%@ page language="java"  pageEncoding="gb2312"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<%@ page language="java" import="java.sql.*" %>

<jsp:useBean id="connDbBean" scope="page" class="db.db"/>
<html>
  <head>
    <base href="<%=basePath%>">
    
    <title>学生考勤</title><script language="javascript" src="js/Calendar.js"></script>
    

  </head>
<script language="javascript">
function check()
{
	if(document.form1.xuehao.value==""){alert("请输入学号");document.form1.xuehao.focus();return false;}if(document.form1.xingming.value==""){alert("请输入姓名");document.form1.xingming.focus();return false;}if(document.form1.kecheng.value==""){alert("请输入课程");document.form1.kecheng.focus();return false;}if(document.form1.riqi.value==""){alert("请输入日期");document.form1.riqi.focus();return false;}if(document.form1.jieshu.value==""){alert("请输入节数");document.form1.jieshu.focus();return false;}if(document.form1.kaoqin.value==""){alert("请输入考勤");document.form1.kaoqin.focus();return false;}
}
</script>
  <body >
  <%
  String id=request.getParameter("id");
   %>
  <form name="form1" id="form1" method="post" action="xueshengkaoqin_updt_post.jsp?id=<%=id %>">
  修改学生考勤:
  <br><br>
  <%
  String sql="select * from xueshengkaoqin where id="+id;
  String xuehao="";String xingming="";String kecheng="";String riqi="";String jieshu="";String kaoqin="";String beizhu="";
  ResultSet RS_result=connDbBean.executeQuery(sql);
  while(RS_result.next()){
  xuehao=RS_result.getString("xuehao");xingming=RS_result.getString("xingming");kecheng=RS_result.getString("kecheng");riqi=RS_result.getString("riqi");jieshu=RS_result.getString("jieshu");kaoqin=RS_result.getString("kaoqin");beizhu=RS_result.getString("beizhu");
  }
   %>
   <table width="100%" border="1" align="center" cellpadding="3" cellspacing="1" bordercolor="#00FFFF" style="border-collapse:collapse">  
     <tr><td>学号：</td><td><input name='xuehao' type='text' id='xuehao' value='<%= xuehao%>' /></td></tr><tr><td>姓名：</td><td><input name='xingming' type='text' id='xingming' value='<%= xingming%>' /></td></tr><tr><td>课程：</td><td><select name='kecheng' id='kecheng'><%sql="select mingcheng from kecheng order by id desc";RS_result=connDbBean.executeQuery(sql);while(RS_result.next()){%><option value="<%= RS_result.getString("mingcheng")%>" ><%=RS_result.getString("mingcheng")%></option><%}%></select></td></tr><script language="javascript">document.form1.kecheng.value='<%=kecheng%>';</script><tr><td>日期：</td><td><input name='riqi' type='text' id='riqi' value='<%= riqi%>' onClick="getDate(form1.riqi,'2')" need="1" readonly='readonly' /></td></tr><tr><td>节数：</td><td><select name='jieshu' id='jieshu'>
       <%
   int i=0;
   for(i=1;i<8;i++)
   {
   	%>
       <option value="<%=i%>"><%=i%></option>
       <%
   }
   %>
     </select></td></tr><script language="javascript">document.form1.jieshu.value='<%=jieshu%>';</script><tr><td>考勤：</td><td><select name='kaoqin' id='kaoqin'>
       <option value="正常">正常</option>
       <option value="迟到">迟到</option>
       <option value="早退">早退</option>
       <option value="缺勤">缺勤</option>
     </select></td></tr><script language="javascript">document.form1.kaoqin.value='<%=kaoqin%>';</script><tr><td>备注：</td><td><textarea name='beizhu' cols='50' rows='5' id='beizhu'><%=beizhu%></textarea></td></tr>
    <tr>
      <td>&nbsp;</td>
      <td><input type="submit" name="Submit" value="提交" onClick="return check();" />
      <input type="reset" name="Submit2" value="重置" /></td>
    </tr>