?? listclass.java
字號:
/***************************************************
*
* 源文件名: ListClass.java
* 功 能： 夢想年華新聞系統 - 新聞類別顯示類
* 作者：夢想年華 [DreamTime]
* Email:fanwsp@126.com
* QQ:122142023
* CopyRight(c)2005-2006 by DreamTime
*
****************************************************
*/
package dreamtime.dreamnews; //指定類所在的包
import java.sql.*;
import dreamtime.dreamnews.Function;
import dreamtime.dreamnews.DBConnection;
public class ListClass
{
DBConnection DBConn = new DBConnection();
Function Fun = new Function();
public ListClass()
{
}
/*********************************************************
* 函數名：TopClass
* 作 用：大類菜單導航
* 參 數：無
* 返回值：字符串
***********************************************************/
public String TopClass()
{
try
{
Connection Conn = DBConn.getConn();
Statement stmt = Conn.createStatement(1004,1007);
String sql = "select * from BigClass order by BigClassID";
ResultSet rs = stmt.executeQuery(sql);
int i = 0;
rs.last();
int iMax = rs.getRow();
String [][] s = new String[iMax][2];
StringBuffer sb = new StringBuffer();
if(iMax==0) sb.append("<div id=\"F1\" align=\"center\"><strong>暫時還沒有任何大類信息！</strong></div>\r\n");
else
{
sb.append("<table width=100% height=22 align=\"center\" cellpadding=\"0\" cellspacing=\"0\">\r\n");
sb.append("<tr>\r\n");
sb.append("<td align=\"center\" width=\"" + 100/(iMax+2) + "%\" valign=\"bottom\">");
sb.append("<div id=\"menu\"><a href=\"index.jsp\" title=\"返回新聞首頁\">首頁</a></div></td>\r\n");
rs.first();
for(i=0;i<iMax;i++)
{
sb.append("<td align=\"center\" valign=\"bottom\" width=\"" + 100/(iMax+2) + "%\">");
sb.append("<div id=\"menu\"><a href=\"ReadClass.jsp?BigClassID=" + rs.getInt(1) + "\"");
sb.append("title=\"" + rs.getString(3) + "\">" + rs.getString(2) + "</a></div>\r\n");
sb.append("</td>\r\n");
rs.next();
}
sb.append("<td align=\"center\" width=\"" + 100/(iMax+2) + "%\" valign=\"bottom\">");
sb.append("<div id=\"menu\"><a href=\"Special.jsp\" title=\"專題列表\">專題</a></div></td>\r\n");
rs.close();
stmt.close();
Conn.close();
sb.append("</tr></table>\r\n");
}
return sb.toString();
}catch(Exception e)
{
//e.printStackTrace();
//System.out.print(e.getMessage());
return "<div id=\"F1\" align=\"center\"><strong>操作出錯！</strong></div>";
}
}
/*********************************************************
* 函數名：ShowHotNews
* 作 用：顯示滾動新聞
* 參 數：大類ID，如果為空，則表示所有大類
* b:是否專題
* 返回值：字符串
***********************************************************/
public String ShowHotNews(String s0,boolean b)
{
try
{
Connection Conn = DBConn.getConn();
Statement stmt = Conn.createStatement(1004,1007);
String sql = "";
int ID = Fun.StrToInt(s0);
int iHotNum = 5;
if (Fun.ReadConfig())
{
if(ID==0 && Fun.HotNewsNum>0) iHotNum = Fun.HotNewsNum;
else if(Fun.BHotNewsNum>0) iHotNum = Fun.BHotNewsNum;
}
if(ID==0)
{
if(b) sql = "select top " + iHotNum + " * from News where IsHot='Yes' and IsHead='No' and IsImg='No' and SpecialID<>0 order by NewsID desc";
else sql = "select top " + iHotNum + " * from News where IsHot='Yes' and IsHead='No' and IsImg='No' order by NewsID desc";
}
else sql = "select top " + iHotNum + " * from News where IsHot='Yes' and IsHead='No' and IsImg='No' and BigClassID=" + ID + " order by NewsID desc";
ResultSet rs = stmt.executeQuery(sql);
StringBuffer sb = new StringBuffer();
rs.last();
if(rs.getRow()<iHotNum) iHotNum=rs.getRow();
if(iHotNum==0) sb.append("<div id=\"F3\">暫無快訊</div>\r\n");
else
{
sb.append("<marquee onMouseOver='this.stop()' onMouseOut='this.start()' scrolldelay=200 width=\"460\">\r\n");
sb.append("[快訊] ");
rs.first();
for(int i=0;i<iHotNum;i++)
{
String NewsTitle = rs.getString(2);
String sTitle = NewsTitle;
String NewsTime = rs.getString(7);
if (NewsTitle.length()>15) sTitle = NewsTitle.substring(0,15) + "..";
sb.append(" <img src=\"pic/li.gif\" border=0> <a title=\"" + NewsTitle + "\" href=\"ShowNews.jsp?NewsID=" + rs.getInt(1) + "\" target=_blank>\r\n");
sb.append(sTitle + "</a> [" + NewsTime + "]");
rs.next();
}
sb.append("</marquee>\r\n");
rs.close();
stmt.close();
Conn.close();
}
return sb.toString();
}catch(Exception e)
{
//e.printStackTrace();
//System.out.print(e.getMessage());
return "";
}
}
/*********************************************************
* 函數名：ShowHeadNews
* 作 用：顯示最新頭條新聞
* 參 數：s0:大類ID，如果為空，則表示所有大類
* b:是否專題新聞
* 返回值：字符串
***********************************************************/
public String ShowHeadNews(String s0,boolean b)
{
try
{
Connection Conn = DBConn.getConn();
Statement stmt = Conn.createStatement(1004,1007);
String sql = "";
int ID = Fun.StrToInt(s0);
int iHeadNum = 2;
if (Fun.ReadConfig())
{
if(ID==0 && Fun.HeadNewsNum>0) iHeadNum = Fun.HeadNewsNum;
else if(Fun.BHeadNewsNum>0) iHeadNum = Fun.BHeadNewsNum;
}
if(ID==0)
{
if(b) sql = "select top " + iHeadNum + " * from News where IsHead='Yes' and HeadPicture='' and IsImg='No' and IsHot='No' and SpecialID<>0 order by NewsID desc";
else sql = "select top " + iHeadNum + " * from News where IsHead='Yes' and HeadPicture='' and IsImg='No' and IsHot='No' order by NewsID desc";
}
else sql = "select top " + iHeadNum + " * from News where IsHead='Yes' and HeadPicture='' and IsImg='No' and IsHot='No' and BigClassID=" + ID + " order by NewsID desc";
ResultSet rs = stmt.executeQuery(sql);
StringBuffer sb = new StringBuffer();
rs.last();
if(rs.getRow()<iHeadNum) iHeadNum=rs.getRow();
if(iHeadNum==0) sb.append("<div id=\"F3\"><br> 暫無頭條</div><br>");
else
{
rs.first();
for(int i=0;i<iHeadNum;i++)
{
String NewsTitle = rs.getString(2);
String sTitle = NewsTitle;
String NewsInfo = rs.getString(16);
if (NewsTitle.length()>20) sTitle = NewsTitle.substring(0,20) + "..";
sb.append("<div id=\"HeadNews\"><h2><a title=\"" + NewsTitle + "\" href=\"ShowNews.jsp?NewsID=" + rs.getInt(1) + "\" target=_blank>\r\n");
sb.append(sTitle + "</a></h2></div>\r\n");
sb.append("<div id=\"HeadNews\"><div id=\"Content\"> ");
sb.append(NewsInfo);
sb.append("</div></div>\r\n");
sb.append("<div id=\"more\" align=\"right\">\r\n");
sb.append("<a title=\"" + NewsInfo + "\" href=\"ShowNews.jsp?NewsID=" + rs.getInt(1) + "\" target=_blank>\r\n");
sb.append("<img src=\"pic/more.gif\"> 詳細</a></div><div id=\"B1\"></div>\r\n");
if(i>1 && i!=iHeadNum) sb.append("<div id=\"Line\"><div id=\"L2\"></div></div>\r\n");
rs.next();
}
}
rs.close();
stmt.close();
Conn.close();
return sb.toString();
}catch(Exception e)
{
//e.printStackTrace();
//System.out.print(sql);
return " ";
}
}
/*********************************************************
* 函數名：ShowHeadPic
* 作 用：顯示頭條圖片新聞
* 參 數：大類ID，如果為空，則表示所有大類
* 返回值：字符串
***********************************************************/
public String ShowHeadPic(String s0,boolean b)
{
try
{
Connection Conn = DBConn.getConn();
Statement stmt = Conn.createStatement(1004,1007);
String sql = "";
int ID = Fun.StrToInt(Fun.CheckReplace(s0));
if(ID==0)
{
if(b) sql = "select top 1 * from News where IsHead='Yes' and HeadPicture<>'' and IsImg='No' and IsHot='No' and SpecialID<>0 order by NewsID desc";
else sql = "select top 1 * from News where IsHead='Yes' and HeadPicture<>'' and IsImg='No' and IsHot='No' order by NewsID desc";
}
else sql = "select top 1 * from News where IsHead='Yes' and HeadPicture<>'' and IsImg='No' and IsHot='No' and BigClassID=" + ID + " order by NewsID desc";
ResultSet rs = stmt.executeQuery(sql);
StringBuffer sb = new StringBuffer();
if(rs.next())
{
rs.first();
int NewsID = rs.getInt(1);
String NewsTitle = rs.getString(2);
String sTitle = NewsTitle;
String NewsInfo = rs.getString(16);
String HeadPicture = rs.getString(12);
if (NewsTitle.length()>15) sTitle = NewsTitle.substring(0,15);
sb.append("<div id=\"pArea\">\r\n");
sb.append("<div id=\"Pic\"><a href=\"ShowNews.jsp?NewsID=" + NewsID + "\" target=_blank>\r\n");
sb.append("<img alt=\"" + NewsTitle + "\" src=\"" + HeadPicture + "\" width=\"240\" height=\"180\"></a></div>\r\n");
sb.append("<h2><a title=\"" + NewsTitle + "\" href=\"ShowNews.jsp?NewsID=" + NewsID + "\" target=_blank>" + sTitle + "</a>\r\n");
sb.append("<div id=\"Content\"> " + NewsInfo);
sb.append("<div id=\"B1\" align=\"right\"><img alt=\"詳細\" src=\"pic/more.gif\"> <a href=\"ShowNews.jsp?NewsID=" + NewsID + "\" target=_blank>詳細</a></div>\r\n");
sb.append("</div></h2>\r\n");
sb.append("</div>");
sb.append("<div id=\"B3\"></div>\r\n");
}
rs.close();
stmt.close();
Conn.close();
return sb.toString();
}catch(Exception e)
{
//e.printStackTrace();
//System.out.print(e.getMessage());
return " ";
}
}
/*********************************************************
* 函數名：ShowTopNews
* 作 用：顯示最新新聞
* 參 數：大類ID，如果為空，則表示所有大類
* 返回值：字符串
***********************************************************/
public String ShowTopNews(String s0,boolean b)
{
try
{
Connection Conn = DBConn.getConn();
Statement stmt = Conn.createStatement(1004,1007);
Statement stmt1 = Conn.createStatement(1004,1007);
ResultSet rs=null;
ResultSet rs1=null;
String sql = "";
String sql1= "";
StringBuffer sb = new StringBuffer();
int ID = Fun.StrToInt(s0);
int iTopNum = 10;
int iImgNum = 6;
int iNum = 0;
int i=0;
if (Fun.ReadConfig())
{
if(ID==0 && Fun.TopNewsNum>0 && Fun.TopImgNum>0)
{
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -