listupfile.jsp

某高校的门户网站源码

<%@ page language="java" contentType="text/html; charset=gbk" %>

<%@ page import="java.util.*,com.jspsmart.upload.*,com.zzx.updown.*,com.zzx.util.*,net.ijsp.news.util.*,net.ijsp.news.news.*,java.text.*,java.sql.*"%>

<%!final String URL = "uploadfile.jsp";%>

<%
    request.setCharacterEncoding("gbk"); 
	int lineSize = 10;
	int currentPage = 1;
	int allRecorders = 0;
	int pageSize = 0;
	
%>
<%

UpDownOper updownoper = new UpDownOper();

allRecorders = updownoper.queryCount();

pageSize = (allRecorders + lineSize - 1) / lineSize;

	try {
		currentPage = Integer.parseInt(request.getParameter("cp"));
	} catch (Exception e) {

	}

%>
<%
	Connection conn = new DataConn().getConn();
	String sql = "SELECT * FROM updown order by id desc limit "
			+ (currentPage - 1) * lineSize + "," + lineSize;
	
	PreparedStatement pst = null;

	//创建一个 PreparedStatement 对象来将参数化的 SQL 语句发送到数据库。
	pst = conn.prepareStatement(sql);

	//在此 PreparedStatement 对象中执行 SQL 查询，并返回该查询生成的 ResultSet 对象。
	ResultSet rs = null;
	rs = pst.executeQuery();
%>

		<table border="1" align="center"  width="600" >
			<tr>
				<td width="67"  align="center">
					序号				</td>
				<td width="405"  align="center">
					文件描述				</td>
				<td width="106"  align="center">
					文件名称				</td>
			   <td width="106"  align="center">
					操作			</td>

			</tr>

			<%  
			
		    List all = updownoper.queryAll(currentPage,lineSize);
			
			Iterator itor = all.iterator();
			
			    int i =0;
				while (itor.hasNext()) {
					UpPic uppic = (UpPic)itor.next();
					i++;
					int udid = uppic.getId();
					String filename = uppic.getFilename();
					String filecontent = uppic.getFilecontent();
			%>
			<tr>
				<td  align="center"><%=i%></td>
				<td  align="center"><%=filecontent%></td>
				<td  align="center"><%=filename%></td>
				<td align="center"><a href="deleteupfile.jsp?id=<%=udid%>" onclick="javascript:return confirm('确认删除吗');">删除</a></td>

			</tr>


			<%
				}
			%>
			
	
			
		</table>

<table align="center" >
<tr><td height="50"></td></tr>		
	
	<tr><td align="center" colspan="3">
		<!--使用隐藏域提交	-->	
		<form action="<%=URL%>" name="spage">
			<input type="button" value="首页" onClick="openPage(1)"
				<%=currentPage == 1 ? "disabled" : ""%>>

		
			<input type="button" value="前一页"
				onClick="openPage(<%=(currentPage - 1)%>)"
				<%=currentPage == 1 ? "disabled" : ""%>>
			<input type="button" value="下一页"
				onClick="openPage(<%=currentPage + 1%>)"
				<%=currentPage == pageSize ? "disabled" : ""%>>
			<input type="button" value="尾页" onClick="openPage(<%=pageSize%>)"
				<%=currentPage == pageSize ? "disabled" : ""%>>

			<input type="hidden" name="cp" value="" />

			分页：<font color="red" size="5"><%=currentPage%></font> /
			<font color="red" size="5"><%=pageSize%></font>

		</form>
			
		</td></tr>	

</table>


	<script type="text/javascript">
	   function openPage(curPage){
	   this.spage.cp.value=curPage;
	   this.spage.submit();
	   } 
   </script>