📄 updatecollege.jsp

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

<%
				//获取连接对象和语句对象
				        String CHECK0=request.getParameter("check0");
                        String yxbh=request.getParameter("YXBH");
						String zsrs=request.getParameter("ZSRS");
						String lqfsx=request.getParameter("LQFSX");
	                    if(yxbh==null||yxbh.trim().equals( "" )){
		%><jsp:forward page="ThirdPickFile.jsp"><jsp:param name="message" value="null"/>
		<jsp:param name="check" value="<%CHECK0%>"/>
		</jsp:forward><% }
	else if((zsrs==null||zsrs.trim().equals(""))&&(lqfsx==null||lqfsx.trim().equals(""))){
        %><jsp:forward page="ThirdPickFile.jsp"><jsp:param name="message" value="null"/>
		<jsp:param name="check" value="<%CHECK0%>"/>
		</jsp:forward><% }
        else{
						if(zsrs==null||zsrs.trim().equals("")){zsrs="0";}
						if(lqfsx==null||lqfsx.trim().equals("")){lqfsx="0";}
						Connection conn = null;
						Statement stmt = null;
						String sql="";
						int n=0;
						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 college where 院校编号= '"+yxbh+"'");
						rs.next();
						if( rs.getInt(1) == 0 ){
				%><jsp:forward page="ThirdPickFile.jsp"><jsp:param name="message" value="nocollege"/>
				<jsp:param name="check" value="<%CHECK0%>"/>
				</jsp:forward><%
						}
			   else{     sql="select 招生人数,录取分数线 from college where 院校编号= '"+yxbh+"'";
			              rs=stmt.executeQuery(sql);
                          rs.next();
						  int czsrs=rs.getInt(1);
						  int clqfsx=rs.getInt(2);
						  int ZSRS=Integer.parseInt(zsrs);
						  int LQFSX=Integer.parseInt(lqfsx);
						  if(ZSRS==0 && LQFSX<clqfsx){
						  sql="update college set 录取分数线='"+LQFSX+"' where 院校编号= '"+yxbh+"'";
                           n=stmt.executeUpdate(sql);
%><jsp:forward page="ThirdPickFile.jsp"><jsp:param name="message" value="success"/>
<jsp:param name="check" value="<%CHECK0%>"/>
</jsp:forward><%
						  }
						  else if(LQFSX==0 && ZSRS>czsrs){
						  sql="update college set 招生人数='"+ZSRS+"' where 院校编号= '"+yxbh+"'";
                           n=stmt.executeUpdate(sql);
%><jsp:forward page="ThirdPickFile.jsp"><jsp:param name="message" value="success"/>
<jsp:param name="check" value="<%CHECK0%>"/>
</jsp:forward><%
						  }
                          else if(LQFSX<clqfsx && ZSRS>czsrs){
							  sql="update college set 招生人数='"+ZSRS+"',录取分数线='"+LQFSX+"' where 院校编号= '"+yxbh+"'";
							    n=stmt.executeUpdate(sql);
%><jsp:forward page="ThirdPickFile.jsp"><jsp:param name="message" value="success"/>
<jsp:param name="check" value="<%CHECK0%>"/>
</jsp:forward><%
								}
						 else{%><jsp:forward page="ThirdPickFile.jsp"><jsp:param name="message" value="error"/>
						<jsp:param name="check" value="<%CHECK0%>"/>
						 </jsp:forward><%}
			         }   
		   }

%>
</html>
⌨️ 快捷键说明

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