📄 index.jsp
字号:
<%@ page contentType="text/html; charset=GB2312" language="java" import="java.sql.*" errorPage="" %>
<%@ include file="Connections/ch6.jsp" %>
<%
if (session.isNew()){
Driver DriverPrepared1 = (Driver)Class.forName(MM_ch6_DRIVER).newInstance();
Connection ConnPrepared1 = DriverManager.getConnection(MM_ch6_STRING,MM_ch6_USERNAME,MM_ch6_PASSWORD);
PreparedStatement Prepared1 = ConnPrepared1.prepareStatement("INSERT INTO webcount(source_ip ) VALUES ('"+request.getRemoteAddr()+"') ");
Prepared1.executeUpdate();
//关闭插入新增的存储过程
ConnPrepared1.close();
}
%>
<%
Driver DriverRecordset1 = (Driver)Class.forName(MM_ch6_DRIVER).newInstance();
Connection ConnRecordset1 = DriverManager.getConnection(MM_ch6_STRING,MM_ch6_USERNAME,MM_ch6_PASSWORD);
PreparedStatement StatementRecordset1 = ConnRecordset1.prepareStatement("SELECT * FROM webcount ORDER BY count DESC");
ResultSet Recordset1 = StatementRecordset1.executeQuery();
boolean Recordset1_isEmpty = !Recordset1.next();
boolean Recordset1_hasData = !Recordset1_isEmpty;
Object Recordset1_data;
int Recordset1_numRows = 0;
String username="KEVIN";
session.setAttribute("username",username);
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<!-- Copyright 2005 Macromedia, Inc. All rights reserved. -->
<title>Kevin Lin 旅游纪事</title>
<meta http-equiv="Content-Type" content="text/html; charset=GB2312" />
<link rel="stylesheet" href="mm_travel2.css" type="text/css" />
<script language="JavaScript" type="text/javascript">
//--------------- LOCALIZEABLE GLOBALS ---------------
var d=new Date();
var monthname=new Array("January","February","March","April","May","June","July","August","September","October","November","December");
//Ensure correct for language. English is "January 1, 2004"
var TODAY = monthname[d.getMonth()] + " " + d.getDate() + ", " + d.getFullYear();
//--------------- END LOCALIZEABLE ---------------
</script>
<style type="text/css">
<!--
.style1 {font-size: 14px}
.style2 {font-size: 12px}
-->
</style>
</head>
<body bgcolor="#C0DFFD">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr bgcolor="#3366CC">
<td width="382" colspan="3" rowspan="2"><img src="images/mm_travel_photo.jpg" alt="Header image" width="382" height="127" border="0" /></td>
<td width="378" height="63" colspan="3" id="logo" valign="bottom" align="center" nowrap="nowrap">Kevin Lin 旅游记事 </td>
<td width="100%"> </td>
</tr>
<tr bgcolor="#3366CC">
<td height="64" colspan="3" id="tagline" valign="top" align="center">只要心情愉快,全年都是旅游的好天情</td>
<td width="100%"> </td>
</tr>
<tr>
<td colspan="7" bgcolor="#003366"><img src="images/mm_spacer.gif" alt="" width="1" height="1" border="0" /></td>
</tr>
<tr bgcolor="#CCFF99">
<td colspan="7" id="dateformat" height="25">今天日期是：
<script language="JavaScript" type="text/javascript">
document.write(TODAY); </script>
访客次数：<%=(((Recordset1_data = Recordset1.getObject("count"))==null || Recordset1.wasNull())?"":Recordset1_data)%></td>
</tr>
<tr>
<td colspan="7" bgcolor="#003366"><img src="images/mm_spacer.gif" alt="" width="1" height="1" border="0" /></td>
</tr>
<tr>
<td width="165" valign="top" bgcolor="#E6F3FF">
<table border="0" cellspacing="0" cellpadding="0" width="165" id="navigation">
<tr>
<td width="165"> <br />
<br /></td>
</tr>
<tr>
<td width="165"><a href="javascript:;" class="navText style1">近期行程</a></td>
</tr>
<tr>
<td width="165"><a href="javascript:;" class="navText style1">好玩的事物</a></td>
</tr>
<tr>
<td width="165"><a href="javascript:;" class="navText style1">我的小白</a></td>
</tr>
<tr>
<td width="165"><a href="javascript:;" class="navText style1">精彩照片</a></td>
</tr>
<tr>
<td width="165"><a href="javascript:;" class="navText style1">分享您的心得</a></td>
</tr>
</table>
<br />
<br />
<br />
<br /> </td>
<td width="50"> </td>
<td width="305" colspan="2" valign="top"><img src="images/mm_spacer.gif" alt="" width="305" height="1" border="0" /><br />
<br />
<br />
<table border="0" cellspacing="0" cellpadding="0" width="305">
<tr>
<td class="pageName">Welcome Kevin Lin's Blog </td>
</tr>
<tr>
<td class="bodyText"><p class="style1"> 访客计数器可以用来作为访问网站的人次数。访客计数器的功能通常是放在首页，当访客来网站时就将数据库中用来记录访客人次的字段值自动加1就可以了。不过设计一个访客计数器的关键是session对象,使用session对象可以防止参访者利用浏览器上的“刷新”按钮重复计算次数,详细的课程内容请参照我们在这一章节中的内容</p>
<p class="style1"> Have fun and make a great website!<br />
Kevin Lin</p></td>
</tr>
</table>
<br /> </td>
<td width="50"> </td>
<td width="190" valign="top"><br />
<br />
<table border="0" cellspacing="0" cellpadding="0" width="190">
<tr>
<td colspan="3" class="subHeader" align="center">NEW DESTINATIONS</td>
</tr>
<tr>
<td width="40"><img src="images/mm_spacer.gif" alt="" width="40" height="1" border="0" /></td>
<td width="110" id="sidebar" class="smallText"><br />
<p><img src="images/imagesDSC024191.jpg" alt="蝴蝶" width="157" height="117" /><br />
<span class="style2">从黑黑的幼虫到绿油油肥嘟嘟的成虫,最后变成了美丽的美蝴蝶都被我用sony W1记录下来了</span></p>
<p><img src="images/imagesPICT0077.jpg" alt="小白" width="157" height="117" /><br />
<span class="style2">小白象是华丽的贵妇,最喜欢有人帮她整理毛发,她是最懂得享受的超级贵夫人</span></p>
<p><img src="images/mm_spacer.gif" alt="" width="50" height="1" border="0" /><img src="images/imagesDSC02348.jpg" alt="参加java 10周年技术研讨会" width="157" height="117" /><br />
<span class="style2">今年刚好是java 十岁生日,祝java生日快乐,这次参加java 一年一度的大型Conference 让我收获良多,这收获不单单只是收藏到了许多原厂赠品而已哦..</span></p>
<p><br />
<a href="javascript:;"></a></p>
<br />
<br />
<br /> </td>
<td width="40"> </td>
</tr>
</table> </td>
<td width="100%"> </td>
</tr>
<tr>
<td width="165"> </td>
<td width="50"> </td>
<td width="167"> </td>
<td width="138"> </td>
<td width="50"> </td>
<td width="190"> </td>
<td width="100%"> </td>
</tr>
</table>
</body>
</html>
<%
Recordset1.close();
StatementRecordset1.close();
ConnRecordset1.close();
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -