WebRoot/student/kecheng2.jsp

（完整代码） 1KB 

<%@ 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>
kecheng3
</title>
</head>
<body bgcolor="#ffffff">

<%
 request.setCharacterEncoding("GBK");
 String kechenghao=request.getParameter("id2");
 String xuehao=(String)session.getAttribute("id");
 String sql="";
 String sql2="";
 String sql3="";
 int totalrecord = 0;
   sql3= "SELECT count(*) as recordcount FROM xuanke where stu_id='"+xuehao+"'";
   ResultSet rs = a.executeQuery(sql3);
   if (rs.next()) totalrecord = rs.getInt("recordcount");
  if(totalrecord<3)
 {
   sql="SELECT * FROM xuanke  where stu_id='"+xuehao+"' and kch='"+kechenghao+"'";
   ResultSet rs1=a.executeQuery(sql);
   if(rs1.next())
   {%>
   <script language="javascript">
   alert("你已经选了这门课，请重新选择");
   </script>
   <%}
   else
   {
     sql2=" INSERT INTO xuanke(stu_id,kch) values('"+xuehao+"','"+kechenghao+"')";
     a.executeUpdate(sql2);
     %>
     <script language="javascript">
     alert("选课成功，请继续选课");
     </script>
     <% }
 }
 else
 {%>
    <script language="javascript">
     alert("你只能选3门课程，请确认后在选");
     </script>
 <%}
%>
  <script language="javascript">
  history.go(-1) ;
  </script>



</body>
</html>

24 小时内免费解锁 3 个项目，之后 1 算力/个。 规则说明

AI 解读 AI

登录后可用，每次 10 算力，解读结果公开显示在下面。

还没有人解读过这个文件。