index.jsp <mce:script type="text/javascript"><!-- var xmlHttp; //用于保存XMLHttpRequest对象的全局变量 String.prototype.Trim=Trim; var categorycode=""; // 去左右空格 function Trim() { return this.replace(//s+$|^/s+/g,""); } //用于创建XMLHttpRequest对象 function XmlHttp() { //根据window.XMLHttpRequest对象是否存在使用不同的创建方式 if (window.XMLHttpRequest) { xmlHttp = new XMLHttpRequest(); //FireFox、Opera等浏览器支持的创建方式 } else { xmlHttp = new ActiveXObject("Microsoft.XMLHTTP");//IE浏览器支持的创建方式 } } //关闭所有DIV function closem() { for(var i=8;i<=19;i++) { try { if(i<10){ document.getElementById("show00"+i).style.display="none";} else{ document.getElementById("show0"+i).style.display="none";} }catch(e) {} } } function getObjectLeft(e) { var l=e.offsetLeft; while(e=e.offsetParent) l += e.offsetLeft; return l; } function getObjectTop(e) { var t=e.offsetTop; while(e=e.offsetParent) t += e.offsetTop; return t; } //显示DIV function showm(idx,l,t) { l=getObjectLeft(document.getElementById(idx)); t=getObjectTop(document.getElementById(idx))+25; categorycode=idx; closem(); if(document.getElementById("show"+idx)!=null) { //alert("show"); document.getElementById("show"+idx).style.display="" }else{ divstr='<div οnmοuseοut="closem()" id="show'+ idx +'" style="background-color:rgb(232,247,250); position: absolute; left: '+l +'px; top: '+ t+'px; color:#1B84C2; font-family: 宋体; font-size: 12px; " align="left"> <img src="images/loadingnew.gif" mce_src="images/loadingnew.gif" /> 正在加载...</div>' //读取数据--------------------------------------------------------------- XmlHttp(); xmlHttp.open("GET", "getweb0info.jsp?category="+idx, true); xmlHttp.onreadystatechange = getinfo; xmlHttp.send(null); //读取数据--------------------------------------------------------------- document.getElementById(idx).οnmοuseοut=closem; document.getElementById(idx).innerHTML=divstr; } } //回调函数 function getinfo() { //alert(xmlHttp.responseText.Trim()) //alert(xmlHttp.readyState) var tmptext=""; if (xmlHttp.readyState == 4) { tmptext=xmlHttp.responseText.Trim(); if(tmptext==""){ tmptext="<table ><tr><td width='230'> <IMG SRC="../images/idx_tu1.gif" mce_SRC="images/idx_tu1.gif"> 获取数据错误!</td></tr></table>" } } else { tmptext="<table ><tr><td width='230'> <IMG SRC="../images/idx_tu1.gif" mce_SRC="images/idx_tu1.gif"> 获取数据错误!</td></tr></table>" } //alert(tmptext) document.getElementById("show"+categorycode).innerHTML=tmptext; } // --></mce:script> getweb0info.jsp <%@ page contentType="text/html;charset=gbk" %> <%@ page import="java.util.*" %> <%@ page import="java.text.SimpleDateFormat" %> <%@ page import="com.censoft.common.base.Pub"%> <jsp:directive.page import="com.censoft.cengrp.dbpool.DBPool"/> <jsp:directive.page import="com.censoft.cengrp.dbpool.DBPoolFactory"/> <jsp:directive.page import="com.censoft.common.db.ConnectionFactory"/> <jsp:directive.page import="java.sql.Connection"/> <jsp:directive.page import="java.sql.PreparedStatement"/> <jsp:directive.page import="java.sql.ResultSet"/> <jsp:useBean id="userLogin" scope="session" class="com.censoft.lanting.pmi.user.loginuser.LoginUser" /> <% String appID = "00000000000000000028"; Pub pub = new Pub(); String category=pub.trimNull((String)request.getParameter("category")); String userID=userLogin.getUserID(); int c= Integer.parseInt(category)-7; String temp_c="0"+c; if(temp_c.length()<2) { temp_c=c+""; } ConnectionFactory c_dbclass=new ConnectionFactory(); DBPool c_dbPool = DBPoolFactory.getPool(); String[] c_new=new String[13]; %> <table width="100%" cellpadding="10" cellspacing="0"> <% String c_sql="SELECT distinct ltinfo.* FROM ltinfo,groupsubjectactrel,groupuserrel WHERE " + "ltinfo.category=groupsubjectactrel.CODE " + "AND ltinfo.DELETEFLAG<>'1' AND ltinfo.otherprimory<>'3' "+ "AND groupuserrel.groupCode=groupsubjectactrel.GROUP_ID " + "AND (groupuserrel.userId=? OR groupuserrel.userId='guest') "+ "AND groupsubjectactrel.CODE LIKE '"+category+"%' "+ "and ltinfo.APP_ID='"+appID+"' "+ "ORDER BY createtime DESC LIMIT 5 "; Vector c_tmpV = new Vector(); Connection c_conn=c_dbPool.getConnection(); if(c_conn==null) { System.out.println(c_dbclass.getMsg()); return; } try{ //System.out.println(c_sql); c_tmpV = c_dbclass.doQuery(c_conn,c_sql,null,new String[]{userID}); //c_tmpV=c_dbclass.doQuery(c_conn,c_sql); }catch(Exception e) {}finally{ if(c_conn!=null) { try{ c_conn.close(); }catch(Exception e){} } } if(c_tmpV == null){ System.out.println(c_dbclass.getMsg()); } SimpleDateFormat sDateFormat=new SimpleDateFormat("yyyy-MM-dd"); String today = sDateFormat.format(new Date());//今天 java.util.Date pre_date = new java.util.Date(System.currentTimeMillis()- 1*24*3600*1000); String pre_time = sDateFormat.format(pre_date);//昨天 for(int i=0;i<c_tmpV.size();i++){ Hashtable tmpH = (Hashtable)c_tmpV.elementAt(i); String title = pub.trimNull((String)tmpH.get("title")); String createtime = pub.trimNull((String)tmpH.get("createtime")).substring(0,10); String image=""; if(createtime.equals(today)) { image="<IMG width='35' height='12' SRC="images/new1.gif" mce_SRC="images/new1.gif">"; c_new[c]="new"; }else if(createtime.equals(pre_time)) { image="<IMG width='35' height='12' SRC="images/new2.gif" mce_SRC="images/new2.gif">"; c_new[c]="new"; } String miid = pub.trimNull((String)tmpH.get("id")); String categorycode = pub.trimNull((String)tmpH.get("category")); String titleall=title; title=title.length()>15?title.substring(0,13)+"...":title; %> <tr οnmοuseοver="this.style.backgroundColor='#C4E7FB'" οnmοuseοut="this.style.backgroundColor='rgb(232,247,250)'"> <td align="left" class="newtd"> <IMG SRC="../images/idx_tu1.gif" mce_SRC="images/idx_tu1.gif"> <a class="newhref" target="_blank" href="../../ltmetainfoadm/infoshow_new.jsp?miid=<%=miid%>&category=<%=categorycode%>" title='<%=titleall%>'><%=title%></a> <% for(int k=title.length();k<14;k++) { out.println(" "); } %> </td> <td align="right" class="newtd"> [<%=createtime%>] </td> <td align="right" class="newtd"> <%=image%> </td> </tr> <% } if(c_tmpV.size()<1) { %> <tr> <td> <table><tr><td width='230'> <IMG SRC="../images/idx_tu1.gif" mce_SRC="images/idx_tu1.gif"> 暂时没有数据!</td></tr></table> </td> </tr> <% } %> </table>