📄 first1.jsp

📁 运用jdk
💻 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>&nbsp;</td>  </tr></table><table width="100%"  border="0" cellpadding="0" cellspacing="0">  <tr>    <td width="10">&nbsp;</td>    <td width="*"><table width="100%" height="20"  border="0" cellpadding="0" cellspacing="0">        <tr>          <td height="20" class="title_s">&nbsp;您已登陆: <%=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">&nbsp;</td>  </tr></table><table width="100%"  border="0" cellpadding="0" cellspacing="0">  <tr>    <td width="10">&nbsp;</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 = "&nbsp;";			if(froms.equals(""))froms = "&nbsp;";			if(name.equals(""))name = "&nbsp;";			if(addtime.equals(""))addtime = "&nbsp;";			if(endtime.equals(""))endtime = "&nbsp;";		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">&nbsp;</td>  </tr></table></body></html><%	myBean.closeConn ( ) ;%>
⌨️ 快捷键说明

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