thirdpickaction.jsp

来自「一个挺好的招生管理系统」· JSP 代码 · 共 53 行

JSP
53
字号
<%@ 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 + =
减小字号Ctrl + -
显示快捷键?