📄 login_so.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 'login_so.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_deldel.jsp?ID="+id;
		}
	}
 </script>
  <BODY leftMargin=0 topMargin=0 BGCOLOR="#FFCCCC">
		<TABLE class=navi cellSpacing=1 align=center border=0>
			  <TBODY>
					  <TR>
					    <TH colSpan=2>当前位置：系统管理&gt;&gt;登录日志管理</TH>
					  </TR>	
					  <TR>
					  	<td>搜索结果如下:</td>	
						<td align=right>[<A href="come.jsp">所有日志</A>]&nbsp;&nbsp;[<A href="index.jsp">回首页</A>]</td>
					  </TR>				    
			  </TBODY>
		</TABLE><br>

		<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>
<%
 try{   
  	 	String name=request.getParameter("select");
  	 	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;
		
			String strSQL="select count(*) as RecCount from login where AdminName='"+name+"'";
			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  AdminName='"+name+"'  and  ID not in " +
			"(select top "+(CurPage-1)*PageSize+" ID from login  where AdminName='"+name+"') order by ID desc";
			rs1=DBlogin.executeQuery(strSQL);	
     	 //out.print(strSQL);
	      if(!rs1.next()){
	      	out.print("<TR align=center><td colspan=14 >对不起该管理员目前尚未登陆过!</td></tr>");
	      	}
	   	  else
	    	{
	     	 rs1.beforeFirst();
	     	 while(rs1.next()){
      		//String bookno=rs1.getString("BookNo");
%>
					<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:gotoPagesoulogin("+(CurPage+1)+")'>下一页</a> <a href='#' onclick='javascript:gotoPagesoulogin("+TotalPage+")'>尾页</a>");
    				}
    			}else{
    				if(CurPage==TotalPage){
    					out.println("<a href='#' onclick='javascript:gotoPagesoulogin(1)'>首页</a> <a href='#' onclick='javascript:gotoPagesoulogin("+(CurPage-1)+")'> 上一页</a> 下一页 尾页");
    				}else{
    					out.println("<a href='#' onclick='javascript:gotoPagesoulogin(1)'>首页</a> <a href='#' onclick='javascript:gotoPagesoulogin("+(CurPage-1)+")'> 上一页</a> <a href='#' onclick='javascript:gotoPagesoulogin("+(CurPage+1)+")'>下一页</a> <a href='#' onclick='javascript:gotoPagesoulogin("+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=\"gotoPagesoulogin(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>
    		<% }  }catch(Exception e){
  			out.println(e.toString());} %>
    	</TABLE>
  </body>
</html>
⌨️ 快捷键说明

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