?? adminclass.java
字號:
/***************************************************
*
* 源文件名: AdminClass.java
* 功 能： 夢想年華新聞系統(tǒng) - 新聞類別管理類
* 作者：夢想年華 [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()
{
}
/*********************************************************
* 函數(shù)名：GetAllClass
* 作 用：讀取所有大類信息
* 參 數(shù)：布爾型b：True 表示大類，否則表示小類
* s1，指定大類的ID
* 返回值：字符串?dāng)?shù)二維組型。類別的各項信息
***********************************************************/
public String[][] GetAllClass(boolean b,boolean b1,String s1)
{
try
{
Connection Conn = DBConn.getConn();
Statement stmt = Conn.createStatement(1004,1007);
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;
}
}
/*********************************************************
* 函數(shù)名：ReadBigClass
* 作 用：讀取類別信息
* 參 數(shù)：s:類別ID,b:為true表示為大類，否則為小類
* 返回值：字符串?dāng)?shù)組型。類別的各項信息
***********************************************************/
public String[] ReadBigClass(String s,boolean b)
{
try
{
Connection Conn = DBConn.getConn();
Statement stmt = Conn.createStatement(1004,1007);
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);
rs = stmt.executeQuery(sql);
rs.next();
sa[0] = rs.getString("SmallClassName");
sa[1] = rs.getString("SmallClassInfo");
sa[2] = rs.getString("BigClassID");
}
rs.close();
stmt.close();
Conn.close();
return sa;
}catch(Exception e){
////e.printStackTrace();
return null;
}
}
/*********************************************************
* 函數(shù)名：ReadClassNews()
* 作 用：讀類別中的新聞數(shù)
* 參 數(shù)：s:大類ID,b:為true表示為大類，否則為小類
* b1:是否為專題
* 返回值：整型數(shù)組
***********************************************************/
public int [] ReadClassNews(int ID,boolean b,boolean b1)
{
try
{
Connection Conn1 = DBConn.getConn();
Statement stmt1 = Conn1.createStatement(1004,1007);
ResultSet rsNum = null;
String sql = null;
int [] iArray = new int[2];
if(!b1)
{
if (b)
{
sql = "select count(*) from News where BigClassID=" + ID;
rsNum = stmt1.executeQuery(sql);
if(rsNum.next()) iArray[0] = rsNum.getInt(1);
else iArray[0]=0;
sql = "select count(*) from SmallClass where BigClassID=" + ID;
rsNum = stmt1.executeQuery(sql);
if(rsNum.next()) iArray[1] = rsNum.getInt(1);
else iArray[1]=0;
}
else
{
sql = "select count(*) from News where SmallClassID=" + ID;
rsNum = stmt1.executeQuery(sql);
if(rsNum.next()) iArray[0] = rsNum.getInt(1);
else iArray[0]=0;
}
}
else
{
sql = "select count(*) from News where SpecialID=" + ID;
rsNum = stmt1.executeQuery(sql);
if(rsNum.next()) iArray[0] = rsNum.getInt(1);
else iArray[0]=0;
}
rsNum.close();
stmt1.close();
Conn1.close();
return iArray;
}catch(Exception e){
//e.printStackTrace();
return null;
}
}
/*********************************************************
* 函數(shù)名：ReadClass
* 作 用：讀取所有類別
* 參 數(shù)：無
* 返回值：字符串
***********************************************************/
public String ReadClass()
{
try
{
Connection Conn = DBConn.getConn();
Statement stmt = Conn.createStatement(1004,1007);
Statement stmt1 = Conn.createStatement(1004,1007);
String sql = "select * from BigClass order by BigClassID";
ResultSet rs = stmt.executeQuery(sql);
StringBuffer sb = new StringBuffer();
sb.append("<br><br><table width=\"90%\" border=\"1\" align=\"center\" cellpadding=\"2\" cellspacing=\"0\">\r\n");
sb.append("<tr><td height=\"27\" colspan=\"3\" background=\"images/bg.gif\">");
sb.append("<div align=\"center\" class=\"title\"><strong>新聞類別管理</strong></div></td>");
sb.append("</tr>\r\n");
sb.append("<tr>\r\n");
sb.append("<td height=\"25\" colspan=\"4\"><strong> <a href=\"Admin_Class.jsp?Action=AddBigClass\">");
sb.append("<font color=\"#ff6600\">[增加大類]</font></a></strong></td>\r\n");
sb.append("</tr>\r\n");
sb.append("<tr>\r\n");
sb.append("<td height=\"25\"><div align=\"center\" class=\"chinese\"><b>類別名稱</b></div></td>\r\n");
sb.append("<td><div align=\"center\" class=\"chinese\"><b>添加時間</b></div></td>\r\n");
sb.append("<td><div align=\"center\" class=\"chinese\"><b>操作</b></div></td>\r\n");
sb.append("</tr>\r\n");
//如果表中沒有任何記錄，剛給出提示信息
if (!rs.next())
{
sb.append("<tr height=\"25\" bgcolor=\"#d6dff7\" class=\"info1\"><td colspan=\"3\">\r\n");
sb.append("<div align=\"center\"><b>暫時沒有任何大類!</b></div></td></tr>\r\n");
}
else
{
while(!rs.isAfterLast())
{
int BigClassID = rs.getInt("BigClassID");
String BigClassName = rs.getString("BigClassName");
String BigClassInfo = rs.getString("BigClassInfo");
int [] iBNum = ReadClassNews(BigClassID,true,false);
sb.append("<tr class=\"chinese\">\r\n");
sb.append("<td width=\"40%\" height='22' title=\"");
sb.append(BigClassInfo);
sb.append("\"><div align=\"left\"> <img src='images/+.gif'><b>");
sb.append(BigClassName + "</b> [" + BigClassID + "]");
sb.append(" [" + iBNum[0] + "/" + iBNum[1] + "]</div></td>\r\n");
sb.append("<td width=\"30%\"><div align=\"center\">");
sb.append(rs.getString("AddTime"));
sb.append("</div></td>\r\n");
sb.append("<td width=\"30%\" class=\"chinese\"><div align=\"right\">[<a href=\"Admin_Class.jsp?Action=AddSClass&BigClassID=");
sb.append(BigClassID);
sb.append("\">增加子類</a>][<a href=\"Admin_Class.jsp?Action=EditBigClass&BigClassID=");
sb.append(BigClassID);
sb.append("\">修改</a>][<a href=\"Admin_Class.jsp?Action=DelBig&BigClassID=");
sb.append(BigClassID);
sb.append("\">刪除</a>]</div></td>\r\n");
sb.append("</tr>\r\n");
String sql1 = "select * from SmallClass where BigClassID=" + BigClassID;
ResultSet rs1= stmt1.executeQuery(sql1);
while(rs1.next())
{
int SClassID = rs1.getInt("SmallClassID");
int [] iSNum = ReadClassNews(SClassID,false,false);
sb.append("<tr bgcolor=\"#d6dff7\">\r\n");
sb.append("<td class=\"chinese\" height=\"20\" Title=\"" + rs1.getString("SmallClassInfo") + "\"><div align=\"left\" class=\"chines\">");
sb.append(" <img src='images/-.gif'>");
sb.append(rs1.getString("SmallClassName") + " [" + SClassID + "] [" + iSNum[0] + "]</div></td>\r\n");
sb.append("<td class=\"chinese\"><div align=\"center\" class=\"chines\">");
sb.append(rs1.getString("AddTime") + "</div></td>\r\n");
sb.append("<td><div align=\"right\" class=\"chinese\">[<a href=\"Admin_Class.jsp?Action=EditSClass&SClassID=");
sb.append(SClassID);
sb.append("\">修改</a>] [<a href=\"Admin_Class.jsp?Action=DelSmall&SClassID=");
sb.append(SClassID);
sb.append("\">刪除</a>]</div></td>\r\n");
sb.append("</tr>\r\n");
}
rs.next();
}
}
sb.append("</table>");
sb.append("<br><br>");
rs.close();
stmt.close();
Conn.close();
return sb.toString();
}catch(Exception e)
{
//e.printStackTrace();
//System.out.print(e.getMessage());
return "No";
}
}
/*********************************************************
* 函數(shù)名：ReadSpecial
* 作 用：讀取專題列表
* 參 數(shù)：無
* 返回值：字符串
***********************************************************/
public String ReadSpecial()
{
try
{
Connection Conn = DBConn.getConn();
Statement stmt = Conn.createStatement(1004,1007);
String sql = "select * from Special";
ResultSet rs = stmt.executeQuery(sql);
StringBuffer sb = new StringBuffer();
sb.append("<br><br><table width=\"90%\" border=\"1\" align=\"center\" cellpadding=\"2\" cellspacing=\"0\">\r\n");
sb.append("<tr><td height=\"27\" colspan=\"3\" background=\"images/bg.gif\">");
sb.append("<div align=\"center\" class=\"title\"><strong>專題管理</strong></div></td>");
sb.append("</tr>\r\n");
sb.append("<tr>\r\n");
sb.append("<td height=\"25\" colspan=\"4\"><strong> <a href=\"Admin_Special.jsp?Action=Add\">");
sb.append("<font color=\"#ff6600\">[增加專題]</font></a></strong></td>\r\n");
sb.append("</tr>\r\n");
sb.append("<tr>\r\n");
sb.append("<td height=\"25\"><div align=\"center\" class=\"chinese\"><b>專題名稱 專題ID/新聞數(shù)</b></div></td>\r\n");
sb.append("<td><div align=\"center\" class=\"chinese\"><b>添加時間</b></div></td>\r\n");
sb.append("<td><div align=\"center\" class=\"chinese\"><b>操作</b></div></td>\r\n");
sb.append("</tr>\r\n");
//如果表中沒有任何記錄，剛給出提示信息
if (!rs.next())
{
sb.append("<tr height=\"25\" bgcolor=\"#d6dff7\" class=\"info1\"><td colspan=\"3\">\r\n");
sb.append("<div align=\"center\"><b>暫時沒有任何專題!</b></div></td></tr>\r\n");
}
else
{
while(!rs.isAfterLast())
{
int SpecialID = rs.getInt("SpecialID");
String SpecialName = rs.getString("SpecialName");
String SpecialInfo = rs.getString("SpecialInfo");
int [] iSpNum = ReadClassNews(SpecialID,false,true);
sb.append("<tr class=\"chinese\" bgcolor=\"#d6dff7\">\r\n");
sb.append("<td width=\"50%\" height='22' title=\"");
sb.append(SpecialInfo);
sb.append("\"><div align=\"left\"> <img src='images/+.gif'><b>");
sb.append(SpecialName + "</b> [" + SpecialID + "]/");
sb.append("[" + iSpNum[0] + "]</div></td>\r\n");
sb.append("<td width=\"30%\"><div align=\"center\">");
sb.append(rs.getString("SpecialTime"));
sb.append("</div></td>\r\n");
sb.append("<td width=\"20%\" class=\"chinese\"><div align=\"right\">");
sb.append("[<a href=\"Admin_Special.jsp?Action=Edit&SpecialID=");
sb.append(SpecialID);
sb.append("\">修改</a>][<a href=\"Admin_Special.jsp?Action=Del&SpecialID=");
sb.append(SpecialID);
sb.append("\">刪除</a>]</div></td>\r\n");
sb.append("</tr>\r\n");
rs.next();
}
}
sb.append("</table>");
sb.append("<br><br>");
rs.close();
stmt.close();
Conn.close();
return sb.toString();
}catch(Exception e)
{
//e.printStackTrace();
//System.out.print(e.getMessage());
return "No";
}
}
/*********************************************************
* 函數(shù)名：ReadSpecial()
* 作 用：讀取某一專題的信息
* 參 數(shù)：s:專題ID
* 返回值：字符串?dāng)?shù)組型。類別的各項信息
***********************************************************/
public String[] ReadSpecial(String s)
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -