📄 scoreinfosubmit.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">
<style type="text/css">
<!--
.style1 {
font-family: "宋体";
font-size: 24px;
font-weight: bold;
}
-->
</style>
</head>
<body>
<%
if(session.getAttribute("userID")== null || session.getAttribute("userID").equals(""))
{
response.sendRedirect("index.jsp");
}
%>
<jsp:include flush="true" page="head.jsp"/><br /><br /><br /><br />
<form name="form1" method="post" action="StudAddSave.jsp" onSubmit="return check();">
<table width="500" border="1" align="center" cellpadding="3" cellspacing="1">
<caption>
<span class="style1"> 成绩统计</span>
</caption>
<tr><td>班级</td>
<td>学号</td>
<td>姓名</td>
<td>成绩</td>
</tr>
<%!
String score="";
String courseName="";
String studId="";
String studName="";
String className="";
%>
<%
String driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver"; //驱动程序
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=stuManager";//数据库连接语句
String userID="sa",pwd="sa",sql="";
try{
Class.forName(driver);//调入JDBC-ODBC桥的驱动程序
Connection conn = DriverManager.getConnection(url,userID,pwd);//建立与数据的连接
//request对象
sql = "select * from studChoiceView where courseId="+request.getParameter("courseId");
Statement stmt = conn.createStatement();//建立Statement的实例，相当于创建一个查询分析器的运行环境
ResultSet rs = stmt.executeQuery(sql); //把查询结果放入ResultSet对象
while(rs.next()){
className= rs.getString("className");
studId= rs.getString("studId");
studName= rs.getString("studName");
score= String.valueOf(rs.getInt("score"));
%>
<tr>
<td><%=className%></td>
<td><%=studId%></td>
<td><%=studName%></td>
<td><%=score%></td>
</tr>
<%
}
}catch(Exception e){
System.out.println(e.getMessage());
}
%>
</table>
<div align="center"><a href="scoreInfo.jsp"><span class ="style1"> 返 回</span></a></div>
<br />
<jsp:include flush="true" page="bottom.jsp"/>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -