WebRoot/ck.jsp

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

<%@ page language="java" import="java.util.*,com.util.*"  contentType="text/html;charset=gb2312"%>
 
<%@ include file="iframe/head.jsp" %>

<script type="text/javascript">
<!--
function sub()
{
	form1.submit();
}
//-->
</script>
<%
String message = (String)request.getAttribute("message");
	if(message == null){
		message = "";
	}
	if (!message.trim().equals("")){
		out.println("<script language='javascript'>");
		out.println("alert('"+message+"');");
		out.println("</script>");
	}
	request.removeAttribute("message");
%>
<%
	String username2=(String)session.getAttribute("id");
	if(username2==null){
		response.sendRedirect(path+"/error.jsp");
	}
	else{
		String sql="";
		
			String xq=request.getParameter("xq");
			xq=Common.toChineseAndTrim(xq);
			 //String xh=request.getParameter("xh");
			 
			sql="select * from cj where xq='"+xq+"' and stu='"+username2+"'  order by cj desc";
			int c=cb.getCount("select count(*) from cj where  xq='"+xq+"' and stu='"+username2+"' ");
			float ff=0;
%>
<BODY>
<TABLE  cellSpacing=0 cellPadding=0 width="100%" border=0>
  <TBODY>
  <TR>
    <TD align="left" vAlign=top > 
<table width='100%' cellspacing='1' cellpadding='3' bgcolor='#CCCCCC' class="tablewidth">
     <tr class="head"> 
      <td width="5%" align="center">ID </td>
      <td  align="center">学号</td>
      <td  align="center">课程名</td> 
      <td  align="center">学期</td> 
      <td  align="center">成绩</td>
      <td  align="center">录入教师</td>
    </tr>
    <%
			List pagelist3=cb.getCom(sql,6);	
				if(!pagelist3.isEmpty()){
				for(int i=0;i<pagelist3.size();i++){
					List pagelist2 =(ArrayList)pagelist3.get(i); 
					ff+=Float.parseFloat(pagelist2.get(3).toString());