📄 thirdpickaction.jsp

📁 一个挺好的招生管理系统

💻 JSP

字号:

<%@ page contentType="text/html; charset=gb2312" %>
<%@ page import="java.sql.*" %>
<%@ page import="DataBaseConnection.OracleConnection" %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>投档录取</title>
</head>

<body bgcolor="#00FFFF">
<table width="93%" height="413" border="0">
  <tr> 
    <td height="83" colspan="2"><%@ include file="Top.jsp" %> </td>
  </tr>
  <tr> 
    <td width="18%"><%@ include file="Left.jsp" %></td>
    <td width="82%" align="center">
	<p><font color="#003366" size="+4">
		<% 
				String driver = "oracle.jdbc.driver.OracleDriver";
				String url = "jdbc:oracle:thin:@localhost:1521:oracle";
				String user = "sox";
				String password = "123";
				boolean isSuccess = true;
				Connection conn = null;
				CallableStatement cstmt = null;
				OracleConnection oc = new OracleConnection( user, password );
					conn = oc.getConnection();
                             cstmt = conn.prepareCall ( "select times from note" );
                                ResultSet rs=cstmt.executeQuery();
								rs.next();
                 
					try{
							
							cstmt = conn.prepareCall ( "call AUTOPROC(3)" );
							cstmt.execute();
							cstmt.close();
							conn.close();
						}
					catch( SQLException e ){ isSuccess = false; }
					if( isSuccess ){ 
						String omg="god";
						session.setAttribute("doublecheck",omg);
					out.print( "考生补录成功！" );}
				    else {out.print( "考生补录失败！" );}
                    
					%> 
					</font></p>
</td>
  </tr>
</table>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -