⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 score.jsp

📁 学生档案管理系统 eclipse开发 数据库用的是SQL Sever 详细见里面的说明
💻 JSP
字号:
<%@ page language="java" import="java.sql.*" pageEncoding="gb2312"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="<%=basePath%>">
    
    <title>学生成绩</title>
    
	<meta http-equiv="pragma" content="no-cache">
	<meta http-equiv="cache-control" content="no-cache">
	<meta http-equiv="expires" content="0">    
	<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
	<meta http-equiv="description" content="This is my page">
	<!--
	<link rel="stylesheet" type="text/css" href="styles.css">
	-->
<link rel="stylesheet" type="text/css" href="styles.css">
  </head>
    <jsp:include page="inc/head.html"/>
  <body>
    <%
  	try
	{
		String type1=(String)session.getValue("type");
		int t=Integer.parseInt(type1);
		if (t<1) response.sendRedirect("Login.jsp");
	}
	catch(Exception e)
	{
			response.sendRedirect("Login.jsp");
	}
%>
  <jsp:useBean id="score" class="Beans.ScoreBean">
</jsp:useBean>
    <table width="100%" height="100%">
		<tr>
			<td width="25%"> </td>
			<td width="75%"> 
			<%
				ResultSet rs=null;
			  	try
				{
					String id=(String)session.getValue("id");	
					rs=score.getrs(id);	
				}
				catch(Exception e)
				{
					response.sendRedirect("Login.jsp");
				}	
		
			out.print("<TABLE class=datagridstyle id=DataGrid1 style='WIDTH: 100%; BORDER-COLLAPSE: collapse' cellSpacing=0 cellPadding=3 border=0><tr><td><b>课程名称</b><td><b>学分</b><td><b>成绩</b><td><b>课程简介</b>");
			
			while(rs.next())
			{
			   String num=rs.getString("Course_Grade");
				//out.print("<tr class=datagrid1212><td><input type=radio name=delete value="+rs.getString("Users_ID")+">");
				out.print("<tr class=datagrid1212><td>"+rs.getString("Coures_Name")+"</td>");
				out.print("<td>"+rs.getString("Course_Credit")+"</td>");
				out.print("<td>"+num+"</td>");
				out.print("<td>"+rs.getString("Course_Provider")+"</td></tr>");
								
			}
			out.print("</table>");
			
		 %>
		 </td>
		</tr>
	</table>
    <br>
  </body>
</html>

⌨️ 快捷键说明

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