这两条语句。。有没有办法。合成在一起。
想把select count(*) as num,max(addtime) as nowtime from liu_bbs where isguest=1
并入到select * from liu_bbs where isguest=false order by id desc
反回结果。 如果select count(*) as num,max(addtime) as nowtime from liu_bbs where isguest=1
找不着记录。则并入结果返回当前时间,页num执返回0
================================================================
想把select count(*) as num,max(addtime) as nowtime from liu_bbs where isguest=1
并入到select * from liu_bbs where isguest=false order by id desc
反回结果。 如果select count(*) as num,max(addtime) as nowtime from liu_bbs where isguest=1
找不着记录。则并入结果返回当前时间,页num执返回0
================================================================
主题标题 留言人 最新回应时间 回复 点击
但是现在留言与回复在同一个表中.
isguest 为1则为留言主题.如果isguest为0则为回复合成在一起。
想把select count(*) as num,max(addtime) as nowtime from liu_bbs where isguest=1
并入到select id,main_subject,main_name,hot from liu_bbs where isguest=0 order by id desc 反回结果。 如果没有回复,也要返回结果
select count(*) as num,max(addtime) as nowtime from liu_bbs where isguest=1
即nowtime 返回当前时间,num返回0
================================================================
public String returnStr(int iswhomainid) throws SQLException {
ResultSet Srs=null; //结果集对
String sql="select count(*) as num,max(addtime) as nowtime from liu_bbs where isguest=1 and iswhomain="+iswhomainid+"";//执行sql
Srs = stmta.executeQuery(sql);
String retStr="";
if (Srs.next()) {
int num=Srs.getInt("num");//个数
String nowtime=Srs.getString("nowtime");//时间
if(nowtime==null || nowtime.equals("") || nowtime.equals(" "))
nowtime=" ";
retStr=" <td><div align=\"left\">"+nowtime+"</div></td><td width=\"8%\"><div align=\"left\">"+num+"</div></td>";
}else
{
retStr=" <td><div align=\"left\">无回应</div></td><td width=\"8%\"><div align=\"left\">0</div></td>";
}
Srs.close();
return retStr;
}
%>
上面的是返回的结果
<% int s_id=rs.getInt("id");//留言id
String s_title=rs.getString("main_subject");//留言主题
if(s_title.length()>40){
s_title=s_title.substring(0,40)+"…";
}
String s_name=rs.getString("main_name");//留言昵称
int hot=rs.getInt("hot");//留言被点击数
out.print("<tr bgcolor=\"#FFB62F\">");
out.print(" <td><div align=\"left\">");
out.print(" <a href=view.jsp?id="+s_id+">"+s_title+"</a></div></td>");
out.print(" <td><div align=\"left\">"+s_name+"</div></td>");
out.print(returnStr(s_id));//这里返回的就是 最新回应时间 回复
out.print(" <td><div align=\"left\">"+hot+"</div></td>");
out.print("</tr>");
%>