?? viewinfo1.jsp
字號:
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*,javax.naming.*,javax.sql.DataSource" %>
<html>
<body bgcolor="#DCDADA">
當前位置：信息中心-->查看信息<br>
<%int pageSize=10;//每頁顯示的記錄條數
int allRecordCount=0;//記錄總條數
int pageRecordCount=0;//當前頁記錄條數
int pageCount=0;//總頁數
int diPage=1;//當前頁碼
//------接收請求參數------
try{
diPage=Integer.parseInt(request.getParameter("diPage"));
}catch(Exception e){
diPage=1;
}
%>
<%//------構造查詢的SQL語句------
//sqlStr1為查詢到當前頁數據的SQL語句
//sqlStr2為查詢到總記錄條數的SQL語句
String sqlStr1="select top "+diPage*pageSize+" * from info where "+
"infoId not in (select top "+(diPage-1)*pageSize+" infoId from"+
" info order by infoId desc) order by infoId desc";
String sqlStr2="select count(*) as allCount from info";
%>
<%//------得到數據庫連接------
Context initCtx = new InitialContext();
Context ctx = (Context) initCtx.lookup("java:comp/env");
Object obj = (Object) ctx.lookup("jdbc/sqlserver");
DataSource ds = (javax.sql.DataSource)obj;
Connection conn = ds.getConnection();
%>
<%//------得到總頁數、總記錄條數與當前頁記錄條數------
java.sql.Statement sql1=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
java.sql.ResultSet rs1=null;
rs1=sql1.executeQuery(sqlStr2);
if(rs1!=null){
//---得到總頁數、總記錄條數與當前頁記錄條數---
rs1.next();
allRecordCount=rs1.getInt("allCount");
if(allRecordCount%pageSize==0)
pageCount=allRecordCount/pageSize;
else
pageCount=(int)(allRecordCount/pageSize)+1;
if(diPage==pageCount||pageCount==0)//最后一頁或沒有數據
pageRecordCount=allRecordCount-(diPage-1)*pageSize;
else
pageRecordCount=pageSize;
}
%>
<table border="1" CELLSPACING=0 CELLPADDING=0>
<tr><td colspan="3" align="center">
查看信息（共<%=allRecordCount%>條，當前頁<%=pageRecordCount%>條）
<%if(diPage!=1){//不是第一頁
out.print("<a href='viewInfo1.jsp?diPage=1'>首頁</a> ");
out.print("<a href='viewInfo1.jsp?diPage="+(diPage-1)+"'>上一頁</a> ");
}
if(diPage!=pageCount&&pageCount!=0){//不是最后一頁
out.print("<a href='viewInfo1.jsp?diPage="+(diPage+1)+"'>下一頁</a> ");
out.print("<a href='viewInfo1.jsp?diPage="+pageCount+"'>尾頁</a> ");
}
%>
</td>
</tr>
<tr><td>信息標題</td><td>查看?</td>
<%if(session.getAttribute("departmentId")!=null){
if(Integer.parseInt(session.getAttribute("departmentId").toString())==1){%>
<td>刪除?</td>
<% }
}
%>
</tr>
<%//------得到當前面數據并顯示------
java.sql.ResultSet rs2=null;
java.sql.Statement sql2=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
rs2=sql2.executeQuery(sqlStr1);
if(rs2!=null){
while(rs2.next()){%>
<tr><td>[<%=rs2.getString("infoAddTime").substring(0,10)%>]<%=rs2.getString("infoTitle")%></td>
<td><a href="#" onclick="window.open('viewInfo2.jsp?infoId=<%=rs2.getLong("infoId")%>')">查看</a></td>
<%if(session.getAttribute("departmentId")!=null){
if(Integer.parseInt(session.getAttribute("departmentId").toString())==1){%>
<td><a href="delInfo.jsp?infoId=<%=rs2.getLong("infoId")%>">刪除</a></td>
<% }
}
%>
</tr>
<%
}
}%>
<%
if(conn!=null)
conn.close();
%>
</table>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -