studentinfofile.jsp

一个挺好的招生管理系统

<%@ page contentType="text/html; charset=gb2312" %>
<%@ page import="java.sql.*" %>
<%@ page import="com.sun.rowset.*" %>
<%@ page import="DataBaseConnection.OracleConnection" %>
										
				<%
				//获取连接对象和语句对象
						Connection conn = null;
						Statement stmt = null;
						String sql="";
						String a="";
						CachedRowSetImpl rowSet;
						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" ); }
						
String del=request.getParameter("delete");
		String message="";
		int q=0;
	if( del==null||del.trim().equals( "" ) ){ message="(注意！请慎重使用此功能！)";}
    else{
	sql="delete from student where 编号='"+del+"'";
	q = stmt.executeUpdate( sql );
	if(q==1){message="删除"+del+"号考生信息！";}
	else {message="删除信息失败！该考生不存在！";}
	
	}
						
						 sql = "select * from student order by 编号";
						ResultSet rs = stmt.executeQuery( sql );
						rowSet=new CachedRowSetImpl();
						rowSet.populate(rs);
						conn.close();
						rowSet.last();
						int m=rowSet.getRow();
						int n=15;
						int pageAllCount=((m%n)==0)?(m/n):(m/n+1);
                        
						 %>
						 <center>
						 <br> <font size=+3>考生信息</font>
		<table  border="1">
	<tr bgcolor="#FFCC99"> 
	<th  nowrap>编号</th>
	<th  nowrap>姓名</th>
   <th  nowrap>性别</th>
    <th  nowrap>出生年月日</th>
	<th  nowrap>总分</th>
    <th  nowrap>同意调剂</th>
    <th  nowrap>一志愿</th>
    <th  nowrap>二志愿</th>
    <th  nowrap>录取状态</th>
    <th  nowrap>录取志愿</th>
    <th  nowrap>录取院校</th>
	<th  nowrap>录取日期</th>
    <th  nowrap>操作人</th>
  </tr>
  <%  int pag=1;
     String str=request.getParameter("showPage");
	 if(str==null||str.trim().equals( "" )){pag=1;}
	 else{byte b[]=str.getBytes("ISO-8859-1");
	 str=new String(b);
	 pag=Integer.parseInt(str);
	 if (pag<=0){pag=pageAllCount;}
	 else if(pag>pageAllCount){pag=1;}
	 else{pag=Integer.parseInt(str);}
	 }
       rowSet.absolute((pag-1)*15+1);

						for(int i=1;i<=15;i++)
						{   if(rowSet.getString(3).equals("1")){a="男";}
							if(rowSet.getString(3).equals("2")){a="女";}
							out.print( "<tr> <td>"+rowSet.getString(1)+"</td><td>"+
							rowSet.getString(2)+"</td><td>"+a+"</td><td>"+rowSet.getString(4)+
							"</td><td>"+rowSet.getString(5)+"</td><td>"+rowSet.getString(6)+
							"</td><td>"+rowSet.getString(7)+"</td><td>"+rowSet.getString(8)+
							"</td><td>"+rowSet.getString(9)+"</td><td>"+rowSet.getString(10)+
                            "</td><td>"+rowSet.getString(11)+"</td><td>"+rowSet.getString(12)+
							"</td><td>"+rowSet.getString(13)+"</td></tr>" );
							if(rowSet.isLast()){break;}else{rowSet.next();}
						}
		
						


%>

</table>
<BR>共有<%=m%>条学生信息
<BR>当前显示第<Font color=blue><%=pag%></Font>页，
共有<Font color=blue><%=pageAllCount%></Font>页，
单击“前一页”或“下一页”按钮查看记录
<TABLE>
<TR><TD><FORM action="">
<Input type=hidden name="showPage" value="<%=pag-1%>">
<Input type=submit name="g" value="前一页">
</FORM>
</TD>
<TD><FORM action="">
<Input type=hidden name="showPage" value="<%=pag+1%>">
<Input type=submit name="g" value="后一页">
</FORM>
</TD>
<TD><FORM action="">
输入页码：<Input type=text name="showPage" size=5>
<Input type=submit name="g" value="提交">
</FORM>
</TD>
</TR>
</TABLE>
<form action="" >
<p>删除学生信息：
<input type="text" name="delete" size="8">
<input type="submit" value="删除"><font color=red><%=message%></font>
</form>
	</center>