📄 adminclass.java
字号:
/***************************************************
*
* 源文件名: 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 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;
}
}
/*********************************************************
* 函数名：ReadBigClass
* 作 用：读取类别信息
* 参 数：s:类别ID,b:为true表示为大类，否则为小类
* 返回值：字符串数组型。类别的各项信息
***********************************************************/
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;
}
}
/*********************************************************
* 函数名：ReadClassNews()
* 作 用：读类别中的新闻数
* 参 数：s:大类ID,b:为true表示为大类，否则为小类
* b1:是否为专题
* 返回值：整型数组
***********************************************************/
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;
}
}
/*********************************************************
* 函数名：ReadClass
* 作 用：读取所有类别
* 参 数：无
* 返回值：字符串
***********************************************************/
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";
}
}
/*********************************************************
* 函数名：ReadSpecial
* 作 用：读取专题列表
* 参 数：无
* 返回值：字符串
***********************************************************/
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/新闻数</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";
}
}
/*********************************************************
* 函数名：ReadSpecial()
* 作 用：读取某一专题的信息
* 参 数：s:专题ID
* 返回值：字符串数组型。类别的各项信息
***********************************************************/
public String[] ReadSpecial(String s)
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -