📄 scoreinfo.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">
<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="scoreInfoSubmit.jsp" ">
  <table width="100" height="104" border="1" align="center" cellpadding="3" cellspacing="1">
  <tr><td><div align="center">课程名称</div></td></tr>
  <tr><td><div align="center"><select name="courseId" id="courseId">
  <%!String courseId="";
  String courseName="";%>
  <%
  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 course";
    Statement stmt = conn.createStatement();//建立Statement的实例，相当于创建一个查询分析器的运行环境
    ResultSet rs  = stmt.executeQuery(sql); //把查询结果放入ResultSet对象
    while(rs.next()){
    	courseId = rs.getString("courseId");
    	courseName = rs.getString("courseName");
    	%>
    <option value="<%=courseId%>"><%=courseName%></option>
    <%
    }
  	%>
  </select>
  </div></td></tr>
  <tr><td><input type="submit" name="submit" value=" 查询该课程学生成绩 "></td></tr>
  </table>
  </form>
  <%
  }catch(Exception e){
  	System.out.println(e.getMessage());
  }
  %>
  <br />
<jsp:include flush="true" page="bottom.jsp"/>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -