📄 message.jsp

📁 java + sqlserver2000编写的一个网上购书系统,实现了一些基本的功能,但对于初学者来说这个系统已经足以起到帮助作用
💻 JSP
字号:
<%@ page language="java" pageEncoding="GB2312"%>
<%@ page import="java.sql.*" %>
<%@ page import="java.util.*"%>
<%@ page import="java.text.*"%>

<jsp:useBean id="DB2" scope="page" class="ConnBean.conn"/>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<HTML>
<head>
	<script language=javascript src="../function/admin.js"></script>
	<link rel="stylesheet" type="text/css" href="../css/admin.css">
</head>
<BODY leftMargin=0 topMargin=0 BGCOLOR="#FFCCCC">
<br>
<TABLE class=navi cellSpacing=1 align=center border=0>
  		<TBODY>
		  <TR>
		    <TH colSpan=2>当前位置:系统管理&gt;&gt;新闻管理&gt;&gt;所有新闻</TH></TR>
		  <TR>
		    <TD align=right>[所有新闻]&nbsp;&nbsp;[<A href="addmess.jsp">新增新闻</A>]&nbsp;&nbsp;[<A href="index.jsp">回首页</A>]</TD></TR>
		</TBODY>
</TABLE>
<% 
		int PageSize=8;
  		int CurPage=1;
  		int TotalPage=0;
  		int RecCount=0;
  		if(request.getParameter("page")!=null){
  			CurPage=Integer.parseInt(request.getParameter("page"));}
  			ResultSet rss=null;
		try{
			String strSQL="select count(*) as RecCount from message";
			rss=DB2.executeQuery(strSQL);
			if(rss.next()){
				RecCount=rss.getInt("RecCount");
			}
			rss=null;
			TotalPage=RecCount/PageSize+(RecCount%PageSize==0?0:1);
			strSQL="select top "+PageSize+" * from message where ID not in " +
			"(select top "+(CurPage-1)*PageSize+" ID from message)";
			rss=DB2.executeQuery(strSQL);
			//rs.next();
			//out.print(rs.getString("ID"));
  		}
  		catch(Exception e){
  			out.println(e.toString());
  		}
	%>
<FORM name=checkform action= method=post>
	<TABLE class=list cellSpacing=1 align=center border=0>
	<TBODY>
			<TR>
				 <TH width="7%">ID</TH>
				 <TH width="10%">发布人ID</TH>
				 <TH width="20%">发布时间</TH>
				 <TH width="30%">内容</TH>
				 <TH width="25%">标题</TH>
				 <TH width="8%">操作</TH>
			</TR>
	<%
    while(rss.next()){
      Integer idnew=rss.getInt("ID");
      //String title=rss.getString("ContextTitle");
      //String cont=rss.getString("Context");
      Integer adid=rss.getInt("AdminID");
      java.util.Date sendtime=rss.getDate("SendTime");
      SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd");
      String dateString = formatter.format(sendtime);
    //out.println(idname);
    %>
			<TR align=center>
				 <TD><%=idnew %></TD>
				 <TD><%=adid%></TD>
				 <TD><%=dateString %></TD>
				 <TD><TEXTAREA name=bookcon cols=30><%=rss.getString("Context")%></TEXTAREA></TD>
				 <TD><%=rss.getString("ContextTitle") %></TD>
				 <td><input type=checkbox  name="check<%=idnew%>"  value=<%=idnew%>></td>
			</TR><% } %>
			
	</TBODY>
   </TABLE><br>
   <TABLE align=center style="width:700px;">
    	    <tr><td>&nbsp;&nbsp;</td></tr>
    		<TR>
    			<TD  style="margin-top:30px; text-align:center;  font-size:14px; ">
    		<%
    			if(CurPage==1){
    				if(CurPage==TotalPage){
    					out.println("首页 上一页 下一页 尾页");
    				}else{
    					out.println("首页 上一页 <a href='#' onclick='javascript:gotoPagemess("+(CurPage+1)+")'>下一页</a> <a href='#' onclick='javascript:gotoPagemess("+TotalPage+")'>尾页</a>");
    				}
    			}else{
    				if(CurPage==TotalPage){
    					out.println("<a href='#' onclick='javascript:gotoPagemess(1)'>首页</a> <a href='#' onclick='javascript:gotoPagemess("+(CurPage-1)+")'> 上一页</a> 下一页 尾页");
    				}else{
    					out.println("<a href='#' onclick='javascript:gotoPagemess(1)'>首页</a> <a href='#' onclick='javascript:gotoPagemess("+(CurPage-1)+")'> 上一页</a> <a href='#' onclick='javascript:gotoPagemess("+(CurPage+1)+")'>下一页</a> <a href='#' onclick='javascript:gotoPagemess("+TotalPage+")'>尾页</a>");		
    				}
    			}
    			
    		%></TD>
	    	 <td style="margin-top:10px; text-align:center; font-size=14px">
	    	 <%   
	    		out.print("跳转到第");
				out.println("<select size=1 name=\"page\" onChange=\"gotoPagemess(this.value)\">");
				for(int i=1;i<=TotalPage;i++)
				{
					String selectAdd=(i==CurPage)?" selected":"";
					out.println("<option value='"+i+"' "+selectAdd+"> "+i+" </option>");
				}
				out.println("</select>");
				out.print("页");
			%></td>
    			
    			<td>&nbsp;&nbsp;&nbsp;&nbsp;</td>
    			<td style="margin-top:10px text-align:center ">   <input type="button" name="Submit" value="全选" onclick="check()" /> <input type="button" name="Submit" value="反选" onclick="check2()" /> </td>
    			<td >&nbsp;&nbsp;
    			<input type="button" name="delete" value="删除选中项" style="margin-top:0px" onClick="return messdele();">
    			
    			</td>
    		</TR>
    	</TABLE>
</FORM>
</BODY>
</HTML>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -