📄 scoresubmitlist.jsp

📁 学生管理系统对学生成绩的操作
💻 JSP
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>

<body>
  <%
if(session.getAttribute("userID")== null || session.getAttribute("userID").equals(""))
{
  response.sendRedirect("index.jsp");
}
%>
<jsp:include flush="true" page="head.jsp"/><br />
<%
String driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver"; //驱动程序
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=stuManager";//数据库连接语句
String userID="sa",pwd="sa",sql="";
String studId="",studName="",courseName="";
try{
Class.forName(driver);//调入JDBC-ODBC桥的驱动程序
Connection conn = DriverManager.getConnection(url,userID,pwd);//建立与数据的连接
//request对象
sql = "select * from course where courseId="+request.getParameter("courseId");
Statement stmt = conn.createStatement();//建立Statement的实例，相当于创建一个查询分析器的运行环境
ResultSet rs  = stmt.executeQuery(sql); //把查询结果放入ResultSet对象
rs.next();
courseName = rs.getString("courseName");
%>
<form name="form1" method="post" action="scoreSave.jsp" onSubmit="return check();">
<p align="center"><strong><font size="4" color="#FFFF00""><%=courseName%>课程成绩登记</font></strong></p>
<table width="500" height="150" border="1" align="center" cellpadding="3" cellspacing="1">

    <tr><td><div align="center">学生编号</div></td>
   	<td><div align="center"><input type="text" name="studId" id="studId"></div></td></tr>
    <tr><td><div align="center">登记分数</div></td>
   <td><div align="center"><input type="text" name="score" id="score"></div></td></tr>
  <%
  }catch(Exception e){
    System.out.println(e.getMessage());
  }
   %>
    </table>
    <div align="center">
        <input type="submit" name="Submit" value="  保  存   ">
      </div>
 		<input type ="hidden" name = "courseId" id = "courseId" value="<%=request.getParameter("courseId")%>">
</form>
<br />
<jsp:include flush="true" page="bottom.jsp"/>
</body>
</html>
<script language = "javascript">
function check()
{
	if(form1.studId.value==""){
		alert("请输入学号!")
		form1.studId.focus();
		return false;
	}
	if(form1.score.value==""){
		alert("请输入成绩!")
		form1.studId.focus();
		return false;
	}
	return true;
}
</script>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -