问题描述
Connectionconn=null;PreparedStatementpStat=null;ResultSetrs=null;try{conn=DBC.getConnection();pStat=conn.prepareStatement("selectNCPM,CPMfromClassTwhereCNO='"+Class.getCNO()+"'");rs=pStat.executeQuery();if(rs.next()){out.print(rs.getString(1));out.print(rs.getString(2));Class.setNCPM(rs.getString(1));Class.setCPM(rs.getString(2));if(rs.getString(1).compareTo(rs.getString(2))==0)response.sendRedirect("jsp3.jsp");elseresponse.sendRedirect("jsp4.jsp");}}catch(Exceptionex){ex.printStackTrace();}finally{if(rs!=null)rs.close();if(pStat!=null)pStat.close();if(conn!=null)conn.close();}jsp4代码inti;Connectionconn=null;PreparedStatementpStat=null;ResultSetrs=null;try{conn=DBC.getConnection();pStat=conn.prepareStatement("selectCOUNT(*)fromSClassTwhereSNO='"+Users.getUserName()+"'ANDCTR='"+Class.getCTR()+"'");rs=pStat.executeQuery();if(rs.next()){i=Integer.parseInt(rs.getString(1));if(i==2){response.sendRedirect("jsp5.jsp");}elseresponse.sendRedirect("sclassinsert.jsp");}}catch(Exceptionex){ex.printStackTrace();}finally{if(rs!=null)rs.close();if(pStat!=null)pStat.close();if(conn!=null)conn.close();}以上是关于选课系统中选课门数的代码,我设置的是限制每人只能选2门,可是运行时却没起作用,麻烦哪位帮我看看
解决方案
解决方案二:
看得蛋疼啊,jsp中写代码.....