rplook.jsp

来自「一个学生课绩管理系统」· JSP 代码 · 共 69 行

JSP
69
字号
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="errorpgae.jsp"%>
<html>
	<head>
		<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
		<title>您的奖惩信息</title>
	</head>

	<body bgcolor="#0099FF" text="#FFFFFF" link="#00FF00">
		<%String id = (String) session.getAttribute("id");

			%>
		<div align="center">
			<p>
				<font color="#00FF00" size="+3" face="方正舒体">您的奖惩信息</font>
			</p>
			<p>&nbsp;
				
			</p>
			<table width="75%" border="1">
				<tr>
					<td>
						奖励
					</td>
				</tr>
				<%sqlBean db = new sqlBean();
			String sql = "select reward from reward where id='" + id + "'";
			ResultSet rs = db.executeUpdate(sql);
			while (rs.next()) {

				%>
				<tr>
					<td>
						<input type="text" value=<%=rs.getString("reward")%> size="50">
					</td>
				</tr>
				<%}

			%>
			</table>

			<table width="75%" border="1">
				<tr>
					<td>
						惩罚
					</td>
				</tr>
				<%sqlBean db = new sqlBean();
			String sql = "select punish from punish where id='" + id + "'";
			ResultSet rs = db.executeUpdate(sql);
			while (rs.next()) {

				%>
				<tr>
					<td>
						<input type="text" value=<%=rs.getString("punish")%> size="50">
					</td>
				</tr>
				<%}

		%>
			</table>

			<p align="left">
				<a href="admin.jsp">&lt;&lt;Back</a>
			</p>
		</div>
	</body>
</html>

⌨️ 快捷键说明

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