Jsp/Servlet

开发平台：

VBScript

chengji.jsp：源码内容

							<%@ page contentType="text/html; charset=GBK" %>
<%@ page import="java.sql.*" %>
<%@ page language="java" %>
<%@ page import="java.util.*" %>
<%@ page import="proj112.*" %>
<jsp:useBean id="a" scope="page" class="proj112.dbconn"/>
<html>
<head>
<title>
chengji
</title>
</head>
<body bgcolor="#ffffff">
 <%
    String xuehao=(String)session.getAttribute("id");
    String sql="";
    sql="SELECT b.xqh,b.kch,b.kcm,b.xf,b.zjjs,a.成绩,a.重修成绩 FROM chengji b,成绩关联 a where b.kch=a.kch and a.stu_id='"+xuehao+"'";
    ResultSet rs=a.executeQuery(sql);
 %>
    &nbsp; &nbsp; &nbsp;姓名:&nbsp;<font color="#0033FF"><%=session.getAttribute("stu_name") %> </font>  &nbsp; &nbsp; &nbsp;学号:&nbsp;<font color="#0033FF"><%=session.getAttribute("id") %></font><br>
 <hr><br>
   <center><font color="red">成绩表如下：<br>
     <p align="center">
      <table  width="100%" cellspacing="0" cellpadding="4" rules="all" bordercolor="#CC9966" border="1" id="dg_rxkb" style="background-color:White;border-color:#CC9966;border-width:1px;border-style:None;width:100%;border-collapse:collapse;">
        <tr bgcolor="#9dcaf4">
          <td align="center"><font color="990000">学期号</font></td>
          <td align="center"><font color="990000">课程号</font></td>
          <td align="center"><font color="990000">课程名</font></td>
          <td align="center"><font color="990000">学分</font></td>
          <td align="center"><font color="990000">主讲教师</font></td>
          <td align="center"><font color="990000">成绩</font></td>
          <td align="center"><font color="990000">重修成绩</font></td>
      </tr>
       <% while(rs.next())
     { %>
     <tr>
       <td align="center"><%=rs.getString("xqh")%></td>
       <td align="center"><%=rs.getString("kch")%></td>
       <td align="center"><%=rs.getString("kcm")%></td>
       <td align="center"><%=rs.getString("xf")%></td>
       <td align="center"><%=rs.getString("zjjs")%></td>
       <td align="center"><%=rs.getString("成绩")%></td>
       <td align="center"><%=rs.getString("重修成绩")%></td>
     </tr>
    <%} %>
    </table>
</body>
</html>

						