📄 select.jsp
字号:
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ page import="java.sql.*,bbs.DBConnect,bean.Chengji" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%
String paths = request.getContextPath();
String basePaths = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+paths+"/";
String id=(String)session.getAttribute("id");
DBConnect db=new DBConnect("select * from chengji where id=?");
db.setString(1,id);
ResultSet rs=db.executeQuery();
Vector v=new Vector();
while(rs.next()){
Chengji c=new Chengji();
c.setKecheng(rs.getString("kecheng"));
c.setCj(rs.getString("cj"));
c.setXueqi(rs.getString("xueqi"));
v.add(c);
}
pageContext.setAttribute("list",v);
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3c.org/TR/1999/REC-html401-19991224/loose.dtd">
<HTML xmlns="http://www.w3.org/1999/xhtml">
<HEAD><TITLE>成绩信息</TITLE>
<META http-equiv=Content-Type content="text/html; charset=utf-8">
<LINK media=all href="<%=paths %>/css/public.css" type=text/css rel=stylesheet>
<style type="text/css">
.button {
BORDER-RIGHT: #1065ac 1px solid; BORDER-TOP: #1065ac 1px solid; BACKGROUND: #1065ac; FONT: bold 12px Verdana; BORDER-LEFT: #1065ac 1px solid; CURSOR: pointer; COLOR: #ffffff; BORDER-BOTTOM: #1065ac 1px solid
}
.itemValue{
FONT: bold 12px Verdana; COLOR: #ff0000
}
</style>
<SCRIPT type=text/javascript>
//**************************************************<![CDATA[
window.onload=function(){
typeof menuItem=="undefined"?alert("当前页面所属菜单项目未定义！"):parent.selectMenu(menuItem);
if(typeof helpMsg=="undefined")helpMsg="无";
parent.writeHelpMsg(helpMsg);
parent.loaded(document.body.scrollHeight);
//document.getElementById("e_focus").focus();
if(typeof init=="function")init();
// gony_rollover();
// gony_preload();
};
window.onunload=parent.loading;
//**************************************************]]>
</SCRIPT>
</HEAD>
<BODY>
<DIV id=body>
<DIV class=l_title>成绩信息</DIV>
<DIV class=l_content>
<DIV style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 10px; PADDING-TOP: 0px; TEXT-ALIGN: left">
<TABLE class=table cellSpacing=0 cellPadding=0 border=0>
<THEAD><TR><TD>课程名称</TD><TD>成绩</TD><TD>学期</TD><TR></THEAD>
<TBODY>
<c:forEach var="ob" items="${pageScope.list}">
<TR>
<TD>${ob.kecheng }</TD>
<TD>${ob.cj }</TD>
<TD>${ob.xueqi}</TD>
</TR>
</c:forEach>
</TBODY></TABLE> <FONT class=page_list></FONT> </DIV></DIV>
<SCRIPT type=text/javascript>
var menuItem="用户功能.成绩信息";
var helpMsg="该页面你可以查询自己的每个学期的每门课程的成绩";
</SCRIPT>
</DIV>
<DIV></DIV></BODY></HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -