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

📄 aandp.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>
      <jsp:useBean id="aandp" class="Beans.AandpBean">
</jsp:useBean>
    <table width="100%" height="100%">
		<tr>
			<td width="25%"> </td>
			<td width="75%">
						<%
						  
  	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");
	}

				ResultSet rs=null;
			  	try
				{
					String id=(String)session.getValue("id");	
					rs=aandp.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>");
			
			while(rs.next())
			{
				String Str;

				//out.print("<tr class=datagrid1212><td><input type=radio name=delete value="+rs.getString("Users_ID")+">");
				out.print("<tr class=datagrid1212><td>"+rs.getString("RrdPsh_Date")+"</td>");
				
				if (rs.getString("RrdPsh_Type").equals("1")) Str="奖励"; else Str="处分";
				out.print("<td>"+Str+"</td>");
				out.print("<td>"+rs.getString("RrdPsh_Name")+"</td></tr>");
								
			}
			out.print("</table>");
			
		 %>
		  </td>
		</tr>
	</table>
    <br>
  </body>
</html>

⌨️ 快捷键说明

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