?? 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 " ";
}
}
/*********************************************************
* 函數(shù)名：ShowSpecial
* 作 用：顯示專題列表
* 參 數(shù)：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;
/************** 取得新聞顯示參數(shù) **************/
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\">暫無數(shù)據(jù)</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 " ";
}
}
/*********************************************************
* 函數(shù)名：ShowLeftNews
* 作 用：顯示左邊專題新聞
* 參 數(shù)：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; //顯示專題數(shù)
int iSpecNewsNum = 10; //每專題新聞數(shù)
int i=0;
/************** 取得專題參數(shù) **************/
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");
/*讀取每個專題中最新發(fā)表的新聞*/
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 + -