資源簡介
ye776t.rar

代碼片段和文件信息
/***************************************************
?*??
?*??源文件名:??AdminClass.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?AdminClass
{
????DBConnection?DBConn?=?new?DBConnection();
????Function?Fun?=?new?Function();?
????
????public?AdminClass()
????{
????
????}?
?????
??
???/*********************************************************
*?函數名:GetAllClass
*?作??用:讀取所有大類信息
*?參??數:布爾型b:True?表示大類,否則表示小類
* ???s1,指定大類的ID
*?返回值:字符串數二維組型。類別的各項信息
***********************************************************/
????public?String[][]?GetAllClass(boolean?bboolean?b1String?s1)
????{
???? try
???? {
???? Connection?Conn?=?DBConn.getConn();
????Statement?stmt?=?Conn.createStatement(10041007);
????String?sql?=?““;
????int?iMax?=?0;
????int?ID?=?Fun.StrToInt(s1);
if(!b1)
{
????if?(b) //讀取大類
????{
???? sql?=?“select?*?from?BigClass“;
????}
????else ????//讀取小類
????{
???? sql?=?“select?*?from?SmallClass“;
???? if?(ID>0)?
???? sql?=?“select?*?from?SmallClass?where?BigClassID=“?+?ID;
????}
}else?sql?=?“select?*?from?Special“; //讀取專題
????ResultSet?rs?=?stmt.executeQuery(sql);?
????rs.last();
????iMax?=?rs.getRow();?
????if(iMax==0)?return?null; ????
????else
????{
???? String?[][]?sArray?=?new?String[iMax][3];
????rs.first();
int?i=0;
do
{
???? sArray[i][0]?=?Integer.toString(rs.getInt(1));
???? sArray[i][1]?=?rs.getString(2);
???? if(!b)?
???? {
???? sArray[i][2]?=?Integer.toString(rs.getInt(4));
???? }
???? i++;
????}while(rs.next());
rs.close();
????stmt.close();
????Conn.close();
????return?sArray;
????}
????
?}catch(Exception?e){
? ////e.printStackTrace();
? return?null;
?}
}
??
????
????/*********************************************************
*?函數名:ReadBigClass
*?作??用:讀取類別信息
*?參??數:s:類別IDb:為true表示為大類,否則為小類
*?返回值:字符串數組型。類別的各項信息
***********************************************************/
????public?String[]?ReadBigClass(String?sboolean?b)
????{
???? try
???? {
???? Connection?Conn?=?DBConn.getConn();
????Statement?stmt?=?Conn.createStatement(10041007);
????ResultSet?rs?=?null;
????String?sql?=?null;
????String?[]?sa?=?new?String?[3];
????if?(b)?
????{
???? sql?=?“select?*?from?BigClass?where?BigClassID=“?+?Fun.StrToInt(s);
????rs?=?stmt.executeQuery(sql);
????rs.next();
????sa[0]?=?rs.getString(“BigClassName“);
????sa[1]?=?rs.getString(“BigClassInfo“);
?}
?else
?{
? sql?=?“select?*?from?SmallClass?where?SmallClassID=“?+?Fun.StrToInt(s);
?
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件???????8618??2006-03-23?15:00??新聞系統發布\downcode.com\news\admin\AddNews.jsp
?????文件??????13232??2006-03-22?19:06??新聞系統發布\downcode.com\news\admin\Admin_Class.jsp
?????文件???????9730??2006-03-22?19:05??新聞系統發布\downcode.com\news\admin\Admin_Config.jsp
?????文件???????2815??2006-03-22?19:05??新聞系統發布\downcode.com\news\admin\Admin_Info.jsp
?????文件???????9564??2006-03-22?19:17??新聞系統發布\downcode.com\news\admin\Admin_Left.jsp
?????文件???????2251??2006-03-22?19:05??新聞系統發布\downcode.com\news\admin\Admin_Log.jsp
?????文件????????544??2006-03-13?22:27??新聞系統發布\downcode.com\news\admin\Admin_Main.jsp
?????文件???????5862??2006-03-22?19:05??新聞系統發布\downcode.com\news\admin\Admin_Special.jsp
?????文件???????5458??2006-03-22?19:05??新聞系統發布\downcode.com\news\admin\Admin_User.jsp
?????文件???????2040??2006-03-19?12:26??新聞系統發布\downcode.com\news\admin\css\bodyst
?????文件???????1056??2006-03-13?22:27??新聞系統發布\downcode.com\news\admin\DelNews.jsp
?????文件???????8321??2006-04-12?10:02??新聞系統發布\downcode.com\news\admin\downcode.com.txt
?????文件???????1654??2006-03-22?19:14??新聞系統發布\downcode.com\news\admin\help\copyright.html
?????文件???????2560??2006-03-22?21:33??新聞系統發布\downcode.com\news\admin\help\index.html
?????文件????????759??2006-03-22?18:41??新聞系統發布\downcode.com\news\admin\help\intro.html
?????文件?????????85??2003-12-15?16:33??新聞系統發布\downcode.com\news\admin\images\+.gif
?????文件?????????82??2003-12-15?16:33??新聞系統發布\downcode.com\news\admin\images\-.gif
?????文件???????2130??2004-05-16?06:44??新聞系統發布\downcode.com\news\admin\images\admin_left_9.gif
?????文件????????282??2005-08-09?17:11??新聞系統發布\downcode.com\news\admin\images\bg.gif
?????文件????????139??2004-01-12?14:26??新聞系統發布\downcode.com\news\admin\images\collapsed.gif
?????文件????????135??2004-01-12?14:26??新聞系統發布\downcode.com\news\admin\images\expanded.gif
?????文件???????1211??2003-12-13?17:01??新聞系統發布\downcode.com\news\admin\images\help.gif
?????文件?????????41??2003-12-13?17:01??新聞系統發布\downcode.com\news\admin\images\li
?????文件?????????41??2003-12-13?17:01??新聞系統發布\downcode.com\news\admin\images\li
?????文件????????238??2004-02-02?19:13??新聞系統發布\downcode.com\news\admin\images\news.gif
?????文件???????2811??2004-05-16?06:47??新聞系統發布\downcode.com\news\admin\images\ti
?????文件???????1999??2002-11-07?02:53??新聞系統發布\downcode.com\news\admin\images\ti
?????文件???????1995??2002-11-07?02:53??新聞系統發布\downcode.com\news\admin\images\ti
?????文件???????2004??2002-11-07?02:53??新聞系統發布\downcode.com\news\admin\images\ti
?????文件???????2352??2003-12-13?17:01??新聞系統發布\downcode.com\news\admin\images\topbg.gif
............此處省略342個文件信息
評論
共有 條評論