【JSP开源代码栏目提醒】:以下是网学会员为您推荐的JSP开源代码-first1.jsp,希望本篇文章对您学习有所帮助。
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<jsp:useBean id='db' scope='request' class='Base.DataBean.DefaultDataBean' />
<jsp:useBean id='notice' scope='request' class='common.flyhigh.noticeBean' />
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" type="text/css" href="index.css">
<title>无标题文档</title>
</head>
<%@ page contentType="text/html;charset=gb2312"%>
<%@page import="java.util.*,java.text.*"%>
<%
DateFormat df = DateFormat.getDateInstance();
notice.Init(db);
int allcount=db.getCount("weeks");
java.util.Date today=new Date();
java.util.Date start=new Date();
java.util.Date end=new Date();
int weeknum=0;
for(int i=0;i<db.getCount("weeks");i++){
start=df.parse(db.getAttributeStr("weeks.start",i));
end = df.parse(db.getAttributeStr("weeks.end",i));
if(today.compareTo(start)>=0&&today.compareTo(end)<0){
weeknum=Integer.parseInt(db.getAttributeStr("weeks.weeknum",i));
}
}
%>
<%
com.util.DealString ds = new com.util.DealString();
com.db.CommonBean myBean = new com.db.CommonBean();
//发送给我的
String sql1 = " select a.*,b.name,c.id as backid,c.ifread,c.backs"
+" from kjc_publish a,kjc_people b,kjc_back c "
+" where a.model='1' "
+" and a.froms=b.id "
+" and a.id=c.objectid "
+" and c.backer="+(String)session.getAttribute("ID") + " "
+" order by a.endtime desc,c.ifread,c.backs desc";
Vector vect1 = myBean.getDataBySql(sql1);
%>
<body leftmargin="0" topmargin="0">
<table width="100%" height="20" border="0" cellpadding="0" cellspacing="0">
<tr>
<td> </td>
</tr>
</table>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="10"> </td>
<td width="*"><table width="100%" height="20" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="20" class="title_s"> 您已登陆: <%=ds.toString((String)session.getAttribute("NAME"))%> </td><td align=right class="title_s">[<a href="../user/show.cgi?id=<%=(String)session.getAttribute("ID")%>">个人信息</a>|<a href="../user/modify.cgi?id=<%=(String)session.getAttribute("ID")%>">修改</a>]</td>
</tr>
<tr>
<td height="5" bgcolor="#A3BED9" colspan=2></td>
</tr>
<tr>
<td height="1" bgcolor="#0A1870" colspan=2></td>
</tr>
</table></td>
<td width="30"> </td>
</tr>
</table>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="10"> </td>
<td width="*">
<table class="main_w" width="100%" border="1" cellpadding="4" cellspacing="0" bordercolor="FFFFFF" bgcolor="E7F2FF">
<tr bgcolor="#FFFFFF" class="title_s">
<td height="20" colspan="7"><div align="center">我的新消息
</div> <div align="center"></div></td>
</tr>
<tr>
<td width="44" align=center>序号</td>
<td width="266" height="20" align=center>通知标题</td>
<td width="70" height="20" align=center>发布人</td>
<td width="70" height="20" align=center>发布日期</td>
<td width="70" height="20" align=center>有效日期</td>
<td width="50" height="20" align=center>附件数</td>
<td width="50" height="20" align=center ><div align="center">操作</div></td>
</tr>
<%
int t = 0 ;
String uid = ds.toString((String)session.getAttribute("ID"));
for(int i=0;i<vect1.size();i++){
Hashtable hash = (Hashtable)vect1.get(i);
String id = (String)hash.get("id");
String title = (String)hash.get("title") ;
String froms = (String)hash.get("froms");
String backid = (String)hash.get("backid");
String name = (String)hash.get("name");
String addtime = (String)hash.get("addtime");
String endtime = (String)hash.get("endtime");
String ifread = ds.toString((String)hash.get("ifread"));
String backs = ds.toString((String)hash.get("backs"));
//状态
String status = "";
if(!backs.equals(""))status = "<font color=#FF9933>已回</font>" ;
else if(ifread.equals("1"))status = "<font color=#669933>已读</font>" ;
else status = "<font color=red>未读</font>" ;
if(!status.equals("<font color=red>未读</font>"))continue;
//统计附件数
String sql = "select count(id) as count from kjc_file where objectid="+id ;
String count_file = ds.toString((String)(((Hashtable)(((Vector)myBean.getDataBySql(sql)).get(0))).get("count")));
//显示为空
if(title.equals(""))title = " ";
if(froms.equals(""))froms = " ";
if(name.equals(""))name = " ";
if(addtime.equals(""))addtime = " ";
if(endtime.equals(""))endtime = " ";
t++;
%>
<tr>
<td height="20" align=center><%=(i+1)%></td>
<td height="20"><a href="../notice1/show.jsp?id=<%=id%>&backid=<%=backid%>"><%=title%></a></td>
<td height="20" align=center><%=name%></td>
<td height="20" align=center><%=addtime%></td>
<td height="20" align=center><%=endtime%></td>
<td height="20" align=center><%=count_file%></td>
<td height="20" align=center><a href="../notice1/newback.jsp?id=<%=id%>&backid=<%=backid%>&title=<%=title%>">回复</a></td>
</tr>
<%
}
%>
<%if(t==0)out.println("<tr><td colspan=7 align=center>没有新消息!</td></tr>");%>
</table>
</td>
<td width="30"> </td>
</tr>
</table>
</body>
</html>
<% myBean.closeConn ( ) ;%>
上一篇:
first.jsp
下一篇:
扛起年轻化大旗,哈弗F系玩转行业新风潮