📄 listclass.java
字号:
iTopNum = Fun.TopNewsNum;
iImgNum = Fun.TopImgNum;
}
else if(Fun.BTopNewsNum>0 && Fun.BTopImgNum>0)
{
iTopNum = Fun.BTopNewsNum;
iImgNum = Fun.BTopImgNum;
}
}
/*读取最新发表的图片新闻*/
if(ID==0)
{
if(b) sql1 = "select top " + iImgNum + " * from News where SpecialID<>0 and IsImg='Yes' and NewsPicture<>'' order by NewsID desc";
else sql1 = "select top " + iImgNum + " * from News where SpecialID=0 and IsImg='Yes' and NewsPicture<>'' order by NewsID desc";
}
else sql1 = "select top " + iImgNum + " * from News where SpecialID=0 and IsImg='Yes' and NewsPicture<>'' and BigClassID=" + ID + " order by NewsID desc";
rs1 = stmt1.executeQuery(sql1);
rs1.last();
iNum = iImgNum;
if(rs1.getRow()<iNum) iNum=rs1.getRow();
if(iNum>0)
{
sb.append("<div id=\"B2\"></div>\r\n");
sb.append("<div id=\"Pic\"><table width=\"450\" border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">\r\n");
sb.append("<tr>\r\n");
rs1.first();
for(i=1;i<=iNum;i++)
{
String NewsTitle = rs1.getString(2);
String sTitle = NewsTitle;
String NewsPicture = rs1.getString(8);
if (NewsTitle.length()>10) sTitle = NewsTitle.substring(0,10) + "..";
sb.append("<td width=\"150\">\r\n");
sb.append("<table width=\"150\" border=\"0\" cellspacing=\"2\" cellpadding=\"2\">\r\n");
sb.append("<tr><td align=\"center\" height=\"80\">\r\n");
sb.append("<a href=\"ShowNews.jsp?NewsID=" + rs1.getInt(1) + "\" target=_blank>\r\n");
sb.append("<img src=\"" + NewsPicture + "\" width=\"130\" height=\"80\" alt=\"" + NewsTitle + "\"></a>\r\n");
sb.append("</td></tr>\r\n");
sb.append("<tr><td height=\"25\">\r\n");
sb.append("<a href=\"ShowNews.jsp?NewsID=" + rs1.getInt(1) + "\" target=_blank>\r\n");
sb.append(sTitle + "</td></tr>\r\n");
sb.append("</table>\r\n");
sb.append("</td>\r\n");
if(i%3==0) sb.append("</tr><tr>\r\n");
rs1.next();
}
rs1.close();
sb.append("</tr></table></div>\r\n");
sb.append("<div id=\"Line\"><div id=\"L2\"></div></div>\r\n");
}
/**************** 图片新闻读取结束 ****************/
/***************** 读取文本新闻 *****************/
if(ID==0)
{
if(b) sql = "select top " + iTopNum + " * from News where IsHot='No' and IsHead='No' and SpecialID<>0 order by NewsID desc";
else sql = "select top " + iTopNum + " * from News where IsHot='No' and IsHead='No' order by NewsID desc";
}
else sql = "select top " + iTopNum + " * from News where IsHot='No' and IsHead='No' and BigClassID=" + ID + " order by NewsID desc";
rs = stmt.executeQuery(sql);
sb.append("<div id=\"News\"><ul>\r\n");
rs.last();
if(rs.getRow()<iTopNum) iTopNum=rs.getRow();
if(iTopNum==0) sb.append("<li><div id=\"F3\"> 暂无新闻</div></li>\r\n");
else
{
rs.first();
for(i=1;i<=iTopNum;i++)
{
String NewsTitle = rs.getString(2);
String sTitle = NewsTitle;
String NewsTime = rs.getString(7);
if (NewsTitle.length()>25) sTitle = NewsTitle.substring(0,25) + "..";
if(rs.getString(13).equals("Yes")) sTitle += "(图)";
sb.append("<li><img src=\"pic/li.gif\"> <a title=\"" + NewsTitle + "\" href=\"ShowNews.jsp?NewsID=" + rs.getInt(1) + "\" target=_blank>\r\n");
sb.append(sTitle + "</a><span>[" + NewsTime + "]</span></li>\r\n");
if(i%5==0 && i>1 && i!=iTopNum) sb.append("<div id=\"Line\"><div id=\"L2\"></div></div>\r\n");
rs.next();
}
}
sb.append("</ul></div>\r\n");
/***************** 读取文本新闻结束*****************/
stmt1.close();
rs.close();
stmt.close();
Conn.close();
return sb.toString();
}catch(Exception e)
{
//e.printStackTrace();
//System.out.print(e.getMessage());
return " ";
}
}
/*********************************************************
* 函数名：ShowClassNews
* 作 用：显示类别新闻
* 参 数：大类ID，如果为空，则表示所有大类
* 返回值：字符串
***********************************************************/
public String ShowClassNews(String s0)
{
try
{
Connection Conn = DBConn.getConn();
Statement stmt1 = Conn.createStatement(1004,1007);
Statement stmt2 = Conn.createStatement(1004,1007);
Statement stmt3 = Conn.createStatement(1004,1007);
ResultSet rs1 = null;
ResultSet rs2 = null;
ResultSet rs3 = null;
String sql1 = "";
String sql2 = "";
String sql3 = "";
String sLink ="ReadSClass.jsp?SClassID=";
String sStyle="<div id=\"stArea\"><div id=\"sTitle2\"><div id=\"stFont\">";
StringBuffer sb = new StringBuffer();
int ID = Fun.StrToInt(Fun.CheckReplace(s0));
int iNewsNum = 10; //新闻数
int iImgNum=3; //图片数
int i=0;
int iNum=0;
/************** 取得大类参数 **************/
if (Fun.ReadConfig())
{
if(ID==0 && Fun.ClassImgNum>0 && Fun.ClassNewsNum>0)
{
iImgNum = Fun.ClassImgNum;
iNewsNum = Fun.ClassNewsNum;
}
else if(Fun.BClassImgNum>0 && Fun.BClassNewsNum>0)
{
iImgNum = Fun.BClassImgNum;
iNewsNum = Fun.BClassNewsNum;
}
}
/************** 类别新闻读取 **************/
if(ID==0)
{
sql1 = "select * from BigClass";
sLink = "ReadClass.jsp?BigClassID=";
sStyle = "<div id=\"tArea\"><div id=\"Title2\"><div id=\"tFont\">";
}
else sql1 = "select * from SmallClass where BigClassID=" + ID;
rs1 = stmt1.executeQuery(sql1);
while(rs1.next())
{
/*读取类别标题*/
int ClassID = rs1.getInt(1);
sb.append(sStyle + rs1.getString(2) + "</div></div>");
sb.append("<span>");
sb.append("<img src=\"pic/more.gif\"> <a title=\"" + rs1.getString(3) + "\" href=\"");
sb.append(sLink + ClassID + "\" target=_blank>更多..</a>");
sb.append("</span></div>\r\n");
/*读取每个类别中最新发表的图片新闻*/
if(ID==0) sql2 = "select top " + iImgNum + " * from News where SpecialID=0 and IsImg='Yes' and NewsPicture<>'' and BigClassID=" + ClassID + " order by NewsID desc";
else sql2 = "select top " + iImgNum + " * from News where SpecialID=0 and IsImg='Yes' and NewsPicture<>'' and SmallClassID=" + ClassID + " order by NewsID desc";
rs2 = stmt2.executeQuery(sql2);
rs2.last();
iNum = iImgNum;
if(rs2.getRow()<iNum) iNum=rs2.getRow();
if(iNum>0)
{
sb.append("<div id=\"B2\"></div>\r\n");
sb.append("<div id=\"Pic\"><table width=\"450\" border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">\r\n");
sb.append("<tr>\r\n");
rs2.first();
for(i=1;i<=iNum;i++)
{
String NewsTitle = rs2.getString(2);
String sTitle = NewsTitle;
String NewsPicture = rs2.getString(8);
if (NewsTitle.length()>10) sTitle = NewsTitle.substring(0,10) + "..";
sb.append("<td width=\"150\">\r\n");
sb.append("<table width=\"150\" border=\"0\" cellspacing=\"2\" cellpadding=\"2\">\r\n");
sb.append("<tr><td align=\"center\" height=\"80\">\r\n");
sb.append("<a href=\"ShowNews.jsp?NewsID=" + rs2.getInt(1) + "\" target=_blank>\r\n");
sb.append("<img src=\"" + NewsPicture + "\" width=\"130\" height=\"80\" alt=\"" + NewsTitle + "\"></a>\r\n");
sb.append("</td></tr>\r\n");
sb.append("<tr><td height=\"25\">\r\n");
sb.append("<a href=\"ShowNews.jsp?NewsID=" + rs2.getInt(1) + "\" target=_blank>\r\n");
sb.append(sTitle + "</td></tr>\r\n");
sb.append("</table>\r\n");
sb.append("</td>\r\n");
if(i%3==0) sb.append("</tr><tr>\r\n");
rs2.next();
}
rs2.close();
sb.append("</tr></table></div>\r\n");
sb.append("<div id=\"Line\"><div id=\"L2\"></div></div>\r\n");
}
/********** 读取每个类别中最新发表的文字新闻 ********/
if(ID==0)
{
sql3 = "select top " + iNewsNum + " * from News where SpecialID=0 and BigClassID=" + ClassID + " order by NewsID desc";
}
else
{
sql3 = "select top " + iNewsNum + " * from News where SpecialID=0 and SmallClassID=" + ClassID + " order by NewsID desc";
}
rs3 = stmt3.executeQuery(sql3);
sb.append("<div id=\"News\"><ul>\r\n");
rs3.last();
iNum = iNewsNum;
if(rs3.getRow()<iNewsNum) iNum=rs3.getRow();
if(iNum==0) sb.append("<li><div id=\"F3\">暂无文字新闻</div></li>\r\n");
else
{
rs3.first();
for(i=1;i<=iNum;i++)
{
String NewsTitle = rs3.getString(2);
String sTitle = NewsTitle;
String NewsTime = rs3.getString(7);
if (NewsTitle.length()>25) sTitle = NewsTitle.substring(0,25) + "..";
if(rs3.getString(13).equals("Yes")) sTitle += "(图)";
sb.append("<li><img src=\"pic/li.gif\"> <a title=\"" + NewsTitle + "\" href=\"ShowNews.jsp?NewsID=" + rs3.getInt(1) + "\" target=_blank>\r\n");
sb.append(sTitle + "</a><span>[" + NewsTime + "]</span></li>\r\n");
if(i%5==0 && i>1 && i!=iNum) sb.append("<div id=\"Line\"><div id=\"L2\"></div></div>\r\n");
rs3.next();
}
}
sb.append("</ul></div>\r\n");
rs3.close();
}
rs1.close();
stmt1.close();
Conn.close();
return sb.toString();
}catch(Exception e)
{
//e.printStackTrace();
//System.out.print(e.getMessage());
//System.out.print(sql1);
//System.out.print(sql2);
//System.out.print(sql3);
return " ";
}
}
/*********************************************************
* 函数名：ShowSClass
* 作 用：显示小类所有新闻
* 参 数：小类ID,页面地址，分页显示的页码
* 返回值：字符串
***********************************************************/
public String ShowSClassNews(String s0,String sPage,String strPage)
{
try
{
Connection Conn = DBConn.getConn();
Statement stmt = Conn.createStatement(1004,1007);
ResultSet rs = null;
String sql = "";
String sClassTitle="没有这个类别";
StringBuffer sb = new StringBuffer();
int ID = Fun.StrToInt(s0);
int i;
int intPage = 1;
int intPageSize = 10;
boolean OK = true;
/************** 取得新闻显示参数 **************/
if (Fun.ReadConfig() && Fun.ListNewsNum>0) intPageSize = Fun.ListNewsNum;
/*取得并输出标题信息*/
String sql1 = "select SmallClassName from SmallClass where SmallClassID=" + ID;
ResultSet rs1 = stmt.executeQuery(sql1);
if(rs1.first()) sClassTitle = rs1.getString(1);
else OK = false;
sb.append("<div id=\"sTitle1\"><div id=\"stFont\">");
sb.append(sClassTitle + "</div></div>\r\n");
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -