📄 come.jsp

📁 java + sqlserver2000编写的一个网上购书系统,实现了一些基本的功能,但对于初学者来说这个系统已经足以起到帮助作用
💻 JSP
字号:
<%@ page language="java"  pageEncoding="GB2312"%>
<%@ page import="java.sql.*" %>
<jsp:useBean id="DBlogin"  scope="page" class="ConnBean.conn"/>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>  
    <title>My JSP 'come.jsp' starting page</title>
	<script language=javascript src="../function/admin.js"></script>
    <link rel="stylesheet" type="text/css" href="../css/admin.css">
  </head>
  <script language="javascript">
	function dellogin(id)
	{
		var a=confirm("你确实要删除该登录日志吗?");
		if(a==true)
		{
		window.location.href="login_del.jsp?ID="+id;
		}
	}
 </script>
 <BODY leftMargin=0 topMargin=0 BGCOLOR="#FFCCCC">
		<FORM name=selForm method=post action=login_so.jsp>
		<TABLE class=navi cellSpacing=1 align=center border=0>
			  <TBODY>
					  <TR>
					    <TH colSpan=2>当前位置：系统管理&gt;&gt;登录日志管理</TH>
					  </TR>
					  
					  <TR>
					    <TD>选择管理员：
						    <SELECT  name=select>
							    <OPTION selected>选择管理员</OPTION>							 
							    <OPTION value=liuxiaoyong>liuxiaoyong</OPTION>
							    <OPTION value=J_Star>J_Star</OPTION>
							    <OPTION value=管理员>管理员</OPTION>
							    <OPTION value=刘小勇>刘小勇</OPTION>
						    </SELECT>&nbsp;&nbsp;
						    <input type=submit name=submit value=半岛搜索  onclick="return souren();">
						</TD>
						<td align=right>[所有日志]&nbsp;&nbsp;[<A href="index.jsp">回首页</A>]</td>
					  </TR>				    
			  </TBODY>
		</TABLE>
		</FORM>
		<% 
		int PageSize=20;
  		int CurPage=1;
  		int TotalPage=0;
  		int RecCount=0;
  		if(request.getParameter("page")!=null){
  			CurPage=Integer.parseInt(request.getParameter("page"));}
  			ResultSet rs1=null;
		try{
			String strSQL="select count(*) as RecCount from login";
			rs1=DBlogin.executeQuery(strSQL);
			if(rs1.next()){
				RecCount=rs1.getInt("RecCount");
			}
			rs1=null;
			TotalPage=RecCount/PageSize+(RecCount%PageSize==0?0:1);
			strSQL="select top "+PageSize+" * from login where ID not in " +
			"(select top "+(CurPage-1)*PageSize+" ID  from login) order by ID desc";
			rs1=DBlogin.executeQuery(strSQL);
			//rs.next();
			//out.print(rs.getString("ID"));
  		}
  		catch(Exception e){
  			out.println(e.toString());
  		}
	%>  
		
		<FORM name=delform action  method=post>
		<TABLE class=list cellSpacing=1 align=center>
			  <TBODY>
					<TR>
					    <TH width="7%">ID</TH>
					    <TH>管理员</TH>
					    <TH>登陆时间</TH>
					    <TH>登陆IP</TH>
					    <TH>登陆累计(次)</TH>					 
					    <TH>操作</TH></TR>
		<%
	   		while(rs1.next()){
	   		//String id=rs1.getString("ID");	
    	%>	
					<TR>
					    <TD align=center><%=rs1.getInt("ID") %></TD>
					    <TD><%=rs1.getString("AdminName") %></TD>
					    <TD><%=rs1.getString("LoginTime") %></TD>
					    <TD><%=rs1.getString("LoginIP") %></TD>
					    <TD align=center><%=rs1.getString("Logincishu") %></TD>
					    <TD align=center><A href="javascript:dellogin(<%=rs1.getInt("ID") %>)">删除</A></TD></TR>	<% } %>			
			  </TBODY>
		 </TABLE>
		 <br>
    
  <TABLE align=center style="width:700px;">
    	   
    		<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:gotoPagelogin("+(CurPage+1)+")'>下一页</a> <a href='#' onclick='javascript:gotoPagelogin("+TotalPage+")'>尾页</a>");
    				}
    			}else{
    				if(CurPage==TotalPage){
    					out.println("<a href='#' onclick='javascript:gotoPagelogin(1)'>首页</a> <a href='#' onclick='javascript:gotoPagelogin("+(CurPage-1)+")'> 上一页</a> 下一页 尾页");
    				}else{
    					out.println("<a href='#' onclick='javascript:gotoPagelogin(1)'>首页</a> <a href='#' onclick='javascript:gotoPagelogin("+(CurPage-1)+")'> 上一页</a> <a href='#' onclick='javascript:gotoPagelogin("+(CurPage+1)+")'>下一页</a> <a href='#' onclick='javascript:gotoPagelogin("+TotalPage+")'>尾页</a>");		
    				}
    			}
    			
    		%></TD>
	    	 <td align=left style="margin-top:10px; text-align:center; font-size=14px">
	    	 <%   
	    		out.print("跳转到第");
				out.println("<select size=1 name=\"page\" onChange=\"gotoPagelogin(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>
    		</TR>
    	</TABLE>
		 </FORM>
  </body>
</html>
⌨️ 快捷键说明

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