?? news.java
字號:
/***************************************************
*
* 源文件名: News.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 News
{
DBConnection DBConn = new DBConnection();
Function Fun = new Function();
public News()
{
}
/*********************************************************
* 函數名：ReadNews
* 作 用：讀取類別信息
* 參 數：s0:新聞ID
* 返回值：字符串數組型。類別的各項信息
***********************************************************/
public String[] ReadNews(String s0)
{
try
{
Connection Conn = DBConn.getConn();
Statement stmt = Conn.createStatement(1004,1007);
ResultSet rs = null;
String sql = null;
int NewsID = Fun.StrToInt(s0);
String [] s = new String[16];
if (NewsID==0)
return null;
else
{
sql = "select * from News where NewsID=" + NewsID;
rs = stmt.executeQuery(sql);
rs.next();
for (int i=0;i<s.length;i++)
{
s[i] = rs.getString(i+2);
}
rs.close();
stmt.close();
Conn.close();
return s;
}
}catch(Exception e){
//e.printStackTrace();
return null;
}
}
/*********************************************************
* 函數名:ListNews
* 作 用:添加新聞
* 參 數：sPage,頁面地址; strPage,第幾頁
* 返回值:字符串型。返回操作結果的信息
***********************************************************/
public String ListNews(String sPage,String strPage)
{
try
{
boolean OK = true;
Connection Conn = DBConn.getConn();
Statement stmt = Conn.createStatement(1004,1007);
ResultSet rs = null;
StringBuffer sb = new StringBuffer();
String [] s1 = null;
int i;
int intPage = 1;
int intPageSize = 15;
if (Fun.ReadConfig() && Fun.AdminNewsListNum>0) intPageSize = Fun.AdminNewsListNum;
String sSql = "select * from News order by NewsID desc";
rs = stmt.executeQuery(sSql);
//輸出表單信息
sb.append("<br><br><table width=\"90%\" border=\"1\" align=\"center\" cellpadding=\"1\" cellspacing=\"0\">\r\n");
sb.append("<tr background=\"images/bg.gif\">\r\n");
sb.append("<td height=\"27\" colspan=\"4\" background=\"images/bg.gif\"><div align=\"center\">");
sb.append("<strong class=\"title\">新聞列表</strong></div></td></tr>\r\n");
sb.append("<tr class=\"chinese\" height=\"25\">\r\n");
sb.append("<td width=\"8%\" height=\"25\"><div align=\"center\" class=\"chinese\"><strong>ID</strong></div></td>\r\n");
sb.append("<td width=\"50%\"><div align=\"center\" class=\"chinese\"><strong>新聞標題</strong></div></td>\r\n");
sb.append("<td width=\"26%\"><div align=\"center\" class=\"chinese\"><strong>發布時間</strong></div></td>\r\n");
sb.append("<td width=\"16%\"><div align=\"center\" class=\"chinese\"><strong>操作</strong></div></td>\r\n");
sb.append("</tr>\r\n");
sb.append("<tr>\r\n");
sb.append("<td height=\"30\" colspan=\"4\" align=\"center\">");
sb.append("<form name=\"ListNews\" style=\"margin:0 2px 0 0; height:25px;width:500px;font-size:12px\">");
sb.append("<div align=\"center\"><font color=\"#ff6600\"><strong>新聞管理快速通道</strong> ");
sb.append("請輸入要操作新聞的ID: </font>");
sb.append("<input id=\"NewsID\" type=\"text\" size=\"10\" maxlength=\"8\" class=\"chinese\"> ");
sb.append("<input name=\"Submit\" type=\"button\" class=\"button\" value=\"修 改\" onClick=\"fastNews(false);\"> ");
sb.append("<input name=\"Submit2\" type=\"button\" class=\"button\" value=\"刪 除\" onClick=\"fastNews(true);\">");
sb.append("</form>");
sb.append("</td></tr>\r\n");
//如果表中沒有任何記錄，剛給出提示信息
if (!rs.next())
{
sb.append("<tr height=\"25\" bgcolor=\"#d6dff7\" class=\"info1\"><td colspan=\"4\">\r\n");
sb.append("<div align=\"center\"><b>暫時還沒有新聞!</b></div></td></tr>\r\n");
}
else
{
//取得待顯示頁碼
intPage = Fun.StrToInt(strPage);
sPage = Fun.CheckReplace(sPage);
if (intPage==0) intPage=1;
//將記錄指針定位到待顯示頁的第一條記錄上
rs.absolute((intPage-1) * intPageSize+1);
i = 0;
while(i < intPageSize && !rs.isAfterLast())
{
int NewsID = rs.getInt("NewsID");
String NewsTitle = rs.getString("NewsTitle");
String sTitle = NewsTitle;
String sImg = "news.gif";
String sImgTitle = "普通新聞";
if (NewsTitle.length()>20) sTitle = NewsTitle.substring(0,20) + "..";
if(rs.getString("IsImg").equals("Yes"))
{
sImg = "ImgNews.gif";
sImgTitle = "圖片新聞";
}
else if(rs.getString("IsImg").equals("Yes"))
{
sImg = "TopNews.gif";
sImgTitle = "頭條新聞";
}
sb.append("<tr bgcolor=\"#d6dff7\" height=\"22\">\r\n");
sb.append("<td bgcolor=\"#d6dff7\" height=\"22\"><div align=\"center\" class=\"chinese\">" + NewsID + "</div></td>\r\n");
sb.append("<td bgcolor=\"#d6dff7\"><div class=\"news\"> ");
sb.append("<img src=\"../pic/" + sImg + "\" alt=\"" + sImgTitle + "\"> ");
sb.append("<a href=\"../ShowNews.jsp?NewsID=" + NewsID + "\" Title=\"" + NewsTitle + "\">" + sTitle + "</div></td>\r\n");
sb.append("<td bgcolor=\"#d6dff7\"><div align=\"center\" class=\"chinese\">" + rs.getString("NewsTime") + "</div></td>\r\n");
sb.append("<td bgcolor=\"#d6dff7\"><div align=\"center\" class=\"chinese\">");
sb.append("<a href=\"ModifyNews.jsp?NewsID=" + NewsID + "\">[修改]</a>");
sb.append("<a href=\"DelNews.jsp?NewsID=" + NewsID + "\">[刪除]</a> </div></td>\r\n");
sb.append("</tr>\r\n");
rs.next();
i++;
}
sb.append("</table>\r\n");
sb.append(Fun.Page(sPage,rs,intPage,intPageSize));
}
rs.close();
stmt.close();
Conn.close();
return sb.toString();
}catch(Exception e)
{
//e.printStackTrace();
//System.out.print(e.getMessage());
return "No";
}
}
/*********************************************************
* 函數名:AddNews
* 作 用:添加新聞
* 參 數:s:字符串數組，添加新聞的各項參數
* s1:管理員;s2:IP地址
* 返回值:字符串型。返回操作結果的信息
***********************************************************/
public String AddNews(String [] s,String s1,String s2)
{
try
{
boolean OK = true;
Connection Conn = DBConn.getConn();
Statement stmt = Conn.createStatement(1004,1007);
ResultSet rs = null;
String sError = "";
for(int i=0;i<s.length;i++)
{
if(i!=1) s[i] = Fun.getStrCN(Fun.CheckReplace(s[i]));
else s[i] = Fun.getStrCN(s[i]);
}
String [] sa1 = new String [4];
String [] sa2 = new String [4];
sa1[0] = s[0];
sa1[1] = s[3];
sa1[2] = s[4];
sa1[3] = s[1];
sa2[0] = "新聞標題";
sa2[1] = "新聞發布人";
sa2[2] = "新聞出處";
sa2[3] = "新聞內容";
String sOK = Fun.CheckDate(sa1,sa2);
if (!sOK.equals("Yes"))
{
OK = false;
sError = sOK;
}
if(!s[13].equals(""))
{
s[7]="0";
s[8]="0";
}
else
{
if(s[7].equals("") || s[8].equals(""))
{
OK = false;
sError="新聞類別和專題不能同時為空";
}
}
if(s[14].length()>120) s[14]=s[14].substring(0,120);
if (s[2].equals("") || s[2].equals(""))
{
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -