代码如下
<%@ page language="java" contentType="text/html; charset=gb2312"
pageEncoding="gb2312"%>
<%@ page import="java.sql.*"%> //此处红XX提示the import java.sql cannot be resolved
<%// 禁止浏览器缓冲保留数据
response.setHeader("Cache-Control","no-store");
response.setHeader("Pragma","no-cache");
response.setDateHeader("Expores",0);
%>
<jsp:useBean id="DBconn" scope="page" class="sams.beans.DBconnect"/>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>社团首页</title>
<script type="text/javascript">
function check(form){
if(form.id.value==""||form.id.value==null){
alert("请输入您的会员号");
return false;
}
if(form.pswd.value==""||form.pswd.value==null){
alert("您还未输入密码");
return false;
}
return true;
}
</script>
<style type="text/css">
<!--
.样式1 {
color: #6600FF;
font-weight: bold;
font-size: 18px;
}
.样式2 {font-size: 14px}
body,td,th {
font-size: 14px;
}
.STYLE1 {color: #7A7DAB}
.STYLE2 {color: #FFFFFF; font-weight: bold; font-size: 18px; }
.STYLE5 {color: #0000FF; }
.STYLE6 {color: #000000}
-->
</style>
</head>
<body >
<%@include file="head.html"%>
<table width="820" border="1" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="181" height="36" bordercolor="#6985CD" bgcolor="#2174C7"><div align="center" class="STYLE2" type="样式1">公告栏</div></td>
<td width="450" bordercolor="#6985CD" bgcolor="#2174C7"><div align="center" class="STYLE2">社团最近活动</div></td>
<td width="181" bordercolor="#6985CD" bgcolor="#2174C7"><div align="center" class="STYLE2" type="样式1">赞助商</div></td>
</tr>
<tr bordercolor="#829FBB">
<td width="181" height="109" rowspan="2" bordercolor="#6985CD">
<table width="181" height="120" border="0" align="center">
<tr>
<td height="41" align="center"> <div align="left" class="STYLE1">
<div align="center" class="STYLE6">
<div align="justify">
<%String sql = "select Gcontent,Gtime from notice";
ResultSet rs = DBconn.executeQuery(sql);
%>
</div>
</div>
<MARQUEE
BEHAVIOR="SCROLL"
ALIGN="LEFT"
direction="up"
width="120" height=100
loop=-1
SCROLLAMOUNT="3"
SCROLLDELAY="100" class="样式2"
onmouseover=this.stop()
onmouseout=this.start()
><div align="center" class="STYLE6">
<div align="justify">
<%while(rs.next()){%>
<%=rs.getString("Gcontent") %>
<br>
<%=rs.getDate("Gtime")%> </div>
</div>
<p align="justify" class="STYLE6"></p>
<div align="justify" class="STYLE6">
<%}%>
</div>
</MARQUEE>
</div></td>
</tr>
</table> </td>
<td height="56" rowspan="3" align="center" valign="top">
<!-- 数据库获取 -->
<table width="100%" height="163" border="0" align="center" cellspacing="0">
<% sql="select Hno,Htopic,Htime from event order by Htime DESC"; // DB is SAMS
ResultSet events=DBconn.executeQuery(sql);
int sum=1;
String bgcolor = "#ddccdd";
while(events.next() && sum++<10){
if(sum%2==0) bgcolor = "#FFFFFF";
else bgcolor = "#FFFFFF";
%>
<tr bgcolor=<%=bgcolor %>>
<td width="76" align="center" valign="middle" bgcolor="<%=bgcolor %>"><img src="login.gif" width="32" height="32">
<td width="168" height="40" bordercolor="#FFFFFF"><a href="eventContent.jsp?num=<%=events.getString(1)%>" title="点击查看详情"><%=events.getString(2)%></a></td>
<td width="149" align=center><%=events.getDate(3)%>
<%}%>
<td width="49" align=right bordercolor="#6985CD"> </tr>
</table></td>
<td height="55" align="center" valign="top"><img src="/ad6.jpg" width="180" height="56"></td>
<!-- 数据库获取end -->
</tr>
<tr bordercolor="#829FBB">
<td height="56" align="center" valign="top"><img src="ad5.jpg" width="180" height="58"></td>
</tr>
<tr>
<td width="181" height="96" align="center" valign="top" bordercolor="#6985CD" bgcolor="#93DEEC">
<!-- 登录表单 -->
<form name="form1" onSubmit="return check(this)" action="../member" method="post" scope="session">
<p><span class="样式2">用户名：</span>
<input name="id" type="text" size="10">
</p>
<p><span class="样式2">密 码：</span>
<input name="pwd" type="password" size="10">
</p>
<p align="center">
<input name="Submit" type="submit" class="STYLE1" value="登录">
<input name="Submit2" type="button" class="STYLE1" onClick="window.open('regist.htm','_blank')" value="注册">
</p>
</form></td>
<td height="56" align="center" valign="top"><img src="ad5.jpg" width="180" height="56"></td>
</tr>
<tr bgcolor="#829FBB">
<td height="40" bordercolor="#6985CD" bgcolor="#2174C7"><div align="center" class="STYLE2">友情链接</div></td>
<td bgcolor="#2174C7"><div align="center" class="STYLE2">社团简介</div></td>
<td bgcolor="#2174C7"><div align="center" class="STYLE2">优秀会员</div></td>
</tr>
<tr>
<td height="130" valign="top" bordercolor="#6985CD" bgcolor="#93DEEC"><div align="center">
<p><a href=http://sl.nwsuaf.edu.cn>友情链接</a></p>
<p>友情链接</p>
<p>友情链接</p>
<p>友情链接</p>
</div></td>
<td valign="top" bordercolor="#6985CD">
笛箫口琴协会直属与社团联合会，以丰富大学生课余
文化生活而成立的社团机构， 该协会成立于2002年，经过三年的发展，会员
现以达到450多人，成为我校具有极强实力及生命力的协会之一。协会现设有
组织部、宣传部、外联部、会员部、笛箫部及口琴部，各部协调发展为协会的
进一步发展起了很好的作用。<br>
协会宗旨：笛箫口琴协会以培训会员的笛、箫、口琴
的基本演奏技能为主， 并开展多种文艺活动。在社团联合会及其他社团的帮助与
合作中，协会常联合其他社团一起组织大型的文艺活动，在学生中引起了很大的
反响。 </td>
<td valign="top" bordercolor="#6985CD"> </td>
</tr>
</table>
<p> </p>
<p>
<%@include file="tail.html"%>
</p>
</body>
</html>
