stat.jsp

用jsp+javebean+access编写的 页面和阿江（ASP）写的记数器很象

<%
/*
                ╭═══════════════╮
                ║                              ║
  ╭══════┤      海量统计统计系统        ├══════╮
  ║            ║                              ║            ║
  ║            ╰═══════════════╯            ║
　║                                                          ║
　║　                      系统1.0版(JSP)                    ║
  ║                                                          ║
  ║                                                          ║
  ║      程序作者：小磊                                      ║
  ║                                                          ║
  ║      QQ:6404040                                          ║
　║      E-Mail:[e-mail]                              ║
  ║      网站:http://kkg365.cn.st                            ║
  ║                                                          ║
  ║    ╭───────────────────────╮    ║
  ╰══┤                小磊在线                      ├══╯
        ╰───────────────────────╯  
*/
%>
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*;" errorPage="" %>
<jsp:useBean id="cost" scope="page" class="sds.count"/>
<%! public int getaf(String str){
int af=Integer.parseInt(str);
return af;
} %>
<%//得到传过来的变量；

String outstr="";

String styles=null;

styles=request.getParameter("style");

//取得系统的时间；

int year=getaf(cost.getyear());

int month=getaf(cost.getmonth());

int day=getaf(cost.getday());

int yesday=day-1;

//设置查询语句；

String sql="select count(*) from vcount where day="+day,
       sql1="select count(*) from vcount",
	   sql2="select count(*) from vcount where day="+yesday;

//插入访问数据库

cost.update("insert into vcount (year,month,day)values("+year+","+month+","+day+")");

Connection con=cost.getconn();
Statement stmt=con.createStatement();
//今天的访问量
ResultSet rs=stmt.executeQuery(sql);
rs.next();
int todaycount=rs.getInt(1);
//总共的访问量
rs=stmt.executeQuery(sql1);
rs.next();
int acount=rs.getInt(1);
//昨天的访问量
rs=stmt.executeQuery(sql2);
rs.next();
int yescount=rs.getInt(1);
//条件输出
if(styles.equals("icon"))

outstr="<a href=http://127.0.0.1:8080/web/counts/index.jsp title=海量超统计==统计总量:"+acount+"，今日:"+todaycount+"，昨天:"+yescount+" target=_blank><img border=0 src=http://127.0.0.1:8080/web/counts/images/icon.gif></a>";

if(styles.equals("text"))
outstr=""+todaycount+"";
//关闭数据库
rs.close();
stmt.close();
con.close();
%>
<%="document.write('"+outstr+"')"%>