📄 selfaction.jsp

📁 一个挺好的招生管理系统
💻 JSP
字号:
<%@ page contentType="text/html; charset=gb2312" %>
<%@ page import="java.sql.*" %>
<%@ page import="DataBaseConnection.OracleConnection" %>


<html>
<body>
<%
String HM1=request.getParameter("hm1");
String HM2=request.getParameter("hm2");
String LQYX=request.getParameter("lqyx");
if(HM1==null||HM2==null)
{%><jsp:forward page="SelfPick.jsp"><jsp:param name="error" value="fail0"/><jsp:param name="BH" value="<%=LQYX%>"/></jsp:forward><%}
else if(HM1.trim().equals("")&&HM2.trim().equals(""))
{%><jsp:forward page="SelfPick.jsp"><jsp:param name="error" value="fail0"/><jsp:param name="BH" value="<%=LQYX%>"/></jsp:forward><%}

else if(HM1.equals(HM2)==false){
%><jsp:forward page="SelfPick.jsp"><jsp:param name="error" value="fail0"/><jsp:param name="BH" value="<%=LQYX%>"/></jsp:forward><%}
else{
	                   
                         boolean check=true;
                        Connection conn = null;
						Statement stmt = null;
						String user = "sox";
						String password = "123";
						OracleConnection oc = new OracleConnection( user, password );
						try{
							conn = oc.getConnection();
							stmt = conn.createStatement();
						}
						catch( SQLException e ){ System.out.println( e.getMessage()+"374" ); }
 ResultSet rs = stmt.executeQuery( "select count(*) from student where 编号= '"+HM1+"' and (一志愿='"+LQYX+"' or 二志愿='"+LQYX+"') and 录取状态=0" );
						rs.next();
               if(rs.getInt(1)==0)
		{%><jsp:forward page="SelfPick.jsp"><jsp:param name="error" value="fail1"/><jsp:param name="BH" value="<%=LQYX%>"/></jsp:forward><%}

			else{

				rs=stmt.executeQuery( "select 一志愿 二志愿 from student where 编号= '"+HM1+"' " );
               rs.next();
				if(rs.getString(1).equals(LQYX)){
   int n=stmt.executeUpdate( "UPDATE STUDENT SET 录取志愿='4',录取状态='1',录取院校='"+LQYX+"',录取日期=SYSDATE,操作人=USER WHERE 编号= '"+HM1+"'");
   int m=stmt.executeUpdate( "UPDATE COLLEGE SET 录取人数=录取人数+1 WHERE 院校编号='"+LQYX+"'");
%><jsp:forward page="SelfPick.jsp"><jsp:param name="error" value="success"/><jsp:param name="BH" value="<%=LQYX%>"/></jsp:forward><%
                            }
                    if(rs.getString(2).equals(LQYX)){
	int n=stmt.executeUpdate( "UPDATE STUDENT SET 录取志愿='4',录取状态='1',录取院校='"+LQYX+"',录取日期=SYSDATE,操作人=USER WHERE 编号= '"+HM1+"'");
   int m=stmt.executeUpdate( "UPDATE COLLEGE SET 录取人数=录取人数+1 WHERE 院校编号='"+LQYX+"'");
%><jsp:forward page="SelfPick.jsp"><jsp:param name="error" value="success"/><jsp:param name="BH" value="<%=LQYX%>"/></jsp:forward><%
				   }
				  
			        } 
			    
  }
%>
</body>
</html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -