📄 listclass.java
字号:
if(OK)
{
/************** 类别新闻读取 **************/
sql= "select * from News where SpecialID=0 and SmallClassID=" + ID + " order by NewsID desc";
rs = stmt.executeQuery(sql);
/*读取新闻，并分页显示*/
sb.append("<div id=\"News\"><ul>\r\n");
//如果表中没有任何记录，则给出提示信息
if (!rs.next())
{
sb.append("<li><div id=\"F3\">暂无新闻</div></li>\r\n");
OK = false;
}
else
{
//取得待显示页码
intPage = Fun.StrToInt(strPage);
sPage = Fun.CheckReplace(sPage);
if (intPage==0) intPage=1;
//将记录指针定位到待显示页的第一条记录上
if(!rs.absolute((intPage-1) * intPageSize+1)) rs.absolute(1);
i = 1;
while(i<=intPageSize && !rs.isAfterLast())
{
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>");
sb.append(sTitle + "</a><span>[" + NewsTime + "]</span></li>\r\n");
if(i%5==0 && i>1) sb.append("<div id=\"Line\"><div id=\"L2\"></div></div>\r\n");
rs.next();
i++;
}
}
sb.append("</ul></div>\r\n");
if(OK) sb.append(Fun.Page(sPage,rs,intPage,intPageSize));
rs.close();
stmt.close();
Conn.close();
}
return sb.toString();
}catch(Exception e)
{
//e.printStackTrace();
//System.out.print(e.getMessage());
return " ";
}
}
/*********************************************************
* 函数名：ShowSpecial
* 作 用：显示专题列表
* 参 数：s0,专题Id,为0表示所有专题
* 页面地址，分页显示的页码
* 返回值：字符串
***********************************************************/
public String ShowSpecial(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(Fun.CheckReplace(s0));
int i;
int intPage = 1;
int intPageSize = 10;
boolean OK = true;
/************** 取得新闻显示参数 **************/
if (Fun.ReadConfig() && Fun.ListSpecNum>0) intPageSize = Fun.ListSpecNum;
/************** 专题读取 **************/
if(ID==0)
{
sql= "select * from Special order by SpecialID desc";
sb.append("<div id=\"Spec\"><ul>\r\n");
}
else
{
sql = "select * from News where SpecialID=" + ID + " order by NewsID desc";
sb.append("<div id=\"News\"><ul>\r\n");
}
/*读取新闻，并分页显示*/
rs = stmt.executeQuery(sql);
//如果表中没有任何记录，则给出提示信息
if (!rs.next())
{
sb.append("<li><div id=\"F3\">暂无数据</div></li>\r\n");
OK = false;
}
else
{
//取得待显示页码
intPage = Fun.StrToInt(strPage);
sPage = Fun.CheckReplace(sPage);
if (intPage==0) intPage=1;
//将记录指针定位到待显示页的第一条记录上
if(!rs.absolute((intPage-1) * intPageSize+1)) rs.absolute(1);
i = 1;
while(i<=intPageSize && !rs.isAfterLast())
{
if(ID==0)
{
String SpecTitle = rs.getString(2);
String SpecInfo = rs.getString(3);
String SpecTime = rs.getString(4);
sb.append("<li><img src=\"pic/spec.gif\" border=0> <a title=\"" + SpecInfo + "\" href=\"Special.jsp?SpecialID=" + rs.getInt(1) + "\" target=_blank>");
sb.append(SpecTitle + "</a><span>[" + SpecTime + "]</span></li>\r\n");
if(i%5==0 && i>1) sb.append("<div id=\"Line\"><div id=\"L2\"></div></div>\r\n");
rs.next();
i++;
}
else
{
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>");
sb.append(sTitle + "</a><span>[" + NewsTime + "]</span></li>\r\n");
if(i%5==0 && i>1) sb.append("<div id=\"Line\"><div id=\"L2\"></div></div>\r\n");
rs.next();
i++;
}
}
}
sb.append("</ul></div>\r\n");
if(OK) sb.append(Fun.Page(sPage,rs,intPage,intPageSize));
rs.close();
stmt.close();
Conn.close();
return sb.toString();
}catch(Exception e)
{
//e.printStackTrace();
//System.out.print(e.getMessage());
return " ";
}
}
/*********************************************************
* 函数名：ShowLeftNews
* 作 用：显示左边专题新闻
* 参 数：b:为true表示首页，否则表示二级页面
* 返回值：字符串
***********************************************************/
public String ShowLeftNews(boolean b)
{
String sql1 = "";
String sql2 = "";
try
{
Connection Conn = DBConn.getConn();
Statement stmt1 = Conn.createStatement(1004,1007);
Statement stmt2 = Conn.createStatement(1004,1007);
ResultSet rs1 = null;
ResultSet rs2 = null;
//String sql1 = "";
//String sql2 = "";
StringBuffer sb = new StringBuffer();
int iSpecNum = 10; //显示专题数
int iSpecNewsNum = 10; //每专题新闻数
int i=0;
/************** 取得专题参数 **************/
if (Fun.ReadConfig())
{
if(b && Fun.SpecNum>0 && Fun.SpecNewsNum>0)
{
iSpecNum = Fun.SpecNum;
iSpecNewsNum = Fun.SpecNewsNum;
}
else if(Fun.BSpecNum>0 && Fun.BSpecNewsNum>0)
{
iSpecNum = Fun.BSpecNum;
iSpecNewsNum = Fun.BSpecNewsNum;
}
}
/************** 首页专题新闻读取 **************/
sql1 = "select top " + iSpecNum + " * from [Special] order by SpecialID desc";
rs1 = stmt1.executeQuery(sql1);
rs1.last();
if(rs1.getRow()<iSpecNum) iSpecNum=rs1.getRow();
if(iSpecNum>0)
{
rs1.first();
for(i=1;i<=iSpecNum;i++)
{
/*读取专题标题*/
int SpecialID = rs1.getInt(1);
String SpecialInfo = rs1.getString(3);
String NewsTitle = rs1.getString(2);
String sTitle = NewsTitle;
if (NewsTitle.length()>12) sTitle = NewsTitle.substring(0,12);
sb.append("<div class=\"SpecTitle\"><div class=\"title\">\r\n");
sb.append("<img src=\"pic/spec.gif\" border=0> <a title=\"" + NewsTitle + "\" href=\"Special.jsp?SpecialID=" + SpecialID + "\">");
sb.append(sTitle + "</a></div>");
sb.append("<div class=\"more\"><img src=\"pic/more.gif\"><a title=\"" + SpecialInfo + "\" href=\"Special.jsp?SpecialID=");
sb.append(SpecialID + "\"> 详细</a></div></div>\r\n");
/*读取每个专题中最新发表的新闻*/
sql2 = "select top " + iSpecNewsNum + " * from News where SpecialID=" + SpecialID + " order by NewsID desc";
rs2 = stmt2.executeQuery(sql2);
sb.append("<div id=\"B2\"></div>\r\n");
sb.append("<div class=\"SpecContent\">\r\n");
rs2.last();
int iNum = iSpecNewsNum;
if(rs2.getRow()<iNum) iNum=rs2.getRow();
if(rs2.first())
{
for(int j=1;j<=iNum;j++)
{
NewsTitle = rs2.getString(2);
sTitle = NewsTitle;
String NewsPicture = rs2.getString(8);
String NewsInfo = rs2.getString(16);
String IsImg = rs2.getString(13);
if (NewsTitle.length()>20) sTitle = NewsTitle.substring(0,20);
if (NewsInfo.length()>40) NewsInfo = NewsInfo.substring(0,40);
sb.append("<h3><img src=\"pic/li.gif\"><a title=\"" + NewsTitle + "\" href=\"ShowNews.jsp?NewsID=" + rs2.getInt(1) + "\" target=_blank>\r\n");
sb.append(sTitle + "</a></h3>\r\n");
if(IsImg.equals("Yes"))
{
sb.append("<a title=\"" + NewsTitle + "\" href=\"ShowNews.jsp?NewsID=" + rs2.getInt(1) + "\" target=_blank>\r\n");
sb.append("<img src=\"" + NewsPicture + "\" alt=\"" + NewsTitle + "\" width=\"130\" height=\"80\" border=\"0\"></a>\r\n");
sb.append("<p>" + NewsInfo + "</p>\r\n");
}
if(j%5==0 && j>0 && j!=iNum) sb.append("<div id=\"L2\"></div>\r\n");
if(j==iNum) sb.append("<div id=\"B4\"></div>");
rs2.next();
}
}
sb.append("</div>\r\n");
rs2.close();
if(i>1 && i!=iSpecNum) sb.append("<div id=\"L1\"></div>\r\n");
rs1.next();
}
}
rs1.close();
stmt1.close();
Conn.close();
return sb.toString();
}catch(Exception e)
{
//e.printStackTrace();
//System.out.print(e.getMessage());
//System.out.print(" sql1=" +sql1 + " \n");
//System.out.print(" sql2=" +sql2);
return " ";
}
}
//测试
public static void main(String[] args)
{
ListClass LC = new ListClass();
//System.out.println(LC.TopClass());
//System.out.println(LC.ShowHotNews(null,true));
//System.out.println(LC.ShowTopNews(null,true));
//System.out.println(LC.ShowLeftNews(false));
//System.out.println(LC.ShowHeadNews(null,true));
//System.out.println(LC.ShowSClassNews("4","ShowSClass.jsp","1"));
//System.out.println(LC.ShowHeadPic(null,true));
//System.out.println(LC.ShowSpecial("1","special.jsp","1"));
//System.out.println(LC.ShowClassNews(null));
}
}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -