?? 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 + -