?? mainbean.java
字號:
/**********************************************************
Version 1.0
Date:2003-11-2
Description:
Other:
Variable List:
1.int type = 0;//系統設置的類型
2.String id1 = "-1"//記錄唯一編號
3.String id2 = "-1"//記錄唯一編號
Function List:
1.public void setId(String d)//設置菜單
1.public void setId1(String d1)//設置一級菜單號碼
2.public void setId2(String d2)//設置二級菜單號碼
3.public Vector getCss()//取得所定義的Css風格
4.public Vector getMenu()//取得所有一級菜單
5.public Vector getMenu2()//根據一級菜單取得所有二級菜單
6.public Vector getMenu3()//根據一二級菜單取得所有三級菜單
7.public String toId1(String m1)//根據一級菜單名得到其編號
8.public String toMenu1(String id1)//根據一級菜單編號得到其名
8.public String toMenu2(String id1,String id2)//根據一、二級菜單編號得到其名
9.public Vector getArticle(String id)//根據某一級菜單下的取得文章
10.public Vector getPicNew()//取得圖片新聞
11.public void setMrCss()//設置默認Css格式時，修改數據表
12.public int getPicNum()//取得顯示圖片新聞的數目
12.public int getPicHeight()//取得顯示圖片新聞的高度
12.public int getPicWidth()//取得顯示圖片新聞的寬度
13.public String getId1(int i)// 根據模塊編號取得菜單編號
14.public Vector getTopic()//取得所有公開的專題
15.public int getNewsNum(String i)//取得某模塊的設置顯示的新聞條數
16.public boolean isShowTime(String i)//取得某模塊的新聞后面是否顯示時間
17.public Vector getMain()//取得主頁設置中的所有信息
18.public Hashtable getOneNews(String id)//根據某文章ID取得文章信息
19.public Hashtable getOneContent(String id)//根據某文章ID取得文章正文
20.public Vector getCondition(String title,String kewords)//根據條件搜索文章
21.public Vector getRelateCom()//取得某文章的相關評論
22.public Vector getArc();//取得某一個菜單下的文章
23.public Vector getOneTopic(String id)//取得某專題下的所有文章
24.public int addCom(Hashtable hash)//增加新聞評論表數據記錄
25.public String styleToname (String style)//把風格轉化為文件名
26.public String getComCon(String id);//得到某文章的內容
27.public int addTime(string id)//增加訪問次數
28.public String getftpsite()//得到ftp地址
29.public String getTopicName(String topicid)//根據專題編號返回專題名稱
30.public boolean ifCanCom();//是否可以發表評論
31.public Vector getOneMenuConf(String id)//取得某版面的設置情況
32.public String getArcPath(String id)//根據文章id取得文章的版面全路經
33.public String getStyle(String id)//根據版面編號取得所選擇版面的模式
33.public String getRoll(String name)//取出字典中滾動消息的內容
History:
***********************************************************/
package oa.bean;
import java.text.*;
import java.util.*;
import java.util.Date;
import java.lang.*;
import java.io.*;
import java.sql.*;
import oa.main.*;
import javax.swing.tree.DefaultMutableTreeNode;
public class MainBean extends ParentBean
{
String id1 = "-1";//記錄唯一編號
String id2 = "-1";//記錄唯一編號
public void setId(String d)//設置菜單
{
}
//設置一級菜單號碼
public void setId1(String d1)
{
id1 = d1;
}
//設置二級菜單號碼
public void setId2(String d2)
{
id2 = d2;
}
//搜索文章keyword:關鍵字,s1:標題或關鍵字,s2:時間
public Vector search(String keyword,String s1,String s2)
{
String sql = "";
Vector vt = new Vector();
String temp[] = ds.splitStr(keyword,' ');
String sql1 = "";
for(int i = 0;i<temp.length;i++)
{
if(temp[i].trim().length()==0)continue;
if(!sql1.equals(""))sql1 += " or ";
if(s1.equals("1")||s1.equals(""))sql1 += " TITLE like '%"+temp[i]+"%' ";
if(s1.equals("2"))sql1 += " KEYWORD like '%"+temp[i]+"%' ";
}
sql = "select ID,MENUID,TITLE,TOPICID,FROMSITE,WRITER,ADDTIME,KEYWORD,IFHEAD,IFGOOD,IFSHOW,IMG,HITS,ORGID,AUTHOR from news.article where ";
sql = sql + "ORGANID='00000000000000000000' and ifshow='1' and "+sql1;
if(s2.equals("all")||s2.equals(""))
sql = sql + "order by edittime desc ";
else
{
long i = Long.parseLong(s2)*86400000;
Date now = new Date();
Date from = new Date(now.getTime()-i);
java.text.SimpleDateFormat f = new java.text.SimpleDateFormat("yyyy-MM-dd");
String fromday = f.format(from);
sql = sql + " and '"+fromday+"'<=addtime order by edittime desc ";
}
ResultSet rs = selectRecord(sql);
Statement stmt = null;
try{
//取得列數和列名
ResultSetMetaData rsmd = rs.getMetaData();
int cols = rsmd.getColumnCount();
while(rs.next())
{
Hashtable hash = new Hashtable();
for(int i=1;i<=cols;i++)
{
String field = ds.toString(rsmd.getColumnName(i));
String value = ds.toString(rs.getString(i));
hash.put(field,value);
}
vt.add(hash);
}
}catch(Exception e){System.out.println("MainBean.search(String keyword,String s1,String s2)運行時出錯："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("MainBean.search(String keyword,String s1,String s2)關閉記錄集rs時出錯"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("MainBean.search(String keyword,String s1,String s2)關閉聲明時statement出錯"+e);}
}
return vt;
}
//搜索文章keyword:關鍵字,s1:標題或關鍵字,s2:時間,id:顯示第幾頁
public Vector search(String keyword,String s1,String s2,String id)
{
String sql = "";
int recnum = 0;
Vector vt = new Vector();
sql = "select ID,MENUID,TITLE,TOPICID,FROMSITE,WRITER,ADDTIME,KEYWORD,IFHEAD,IFGOOD,IFSHOW,IMG,HITS,ORGID,AUTHOR from news.article where ";
if(s1.equals("1")||s1.equals(""))
sql = sql + "ORGANID='00000000000000000000' and ifshow='1' and TITLE like '%"+ds.toString(keyword)+"%' ";
if(s1.equals("2"))
sql = sql + "ORGANID='00000000000000000000' and ifshow='1' and KEYWORD like '%"+ds.toString(keyword)+"%' ";
if(s2.equals("all")||s2.equals(""))
sql = sql + "order by edittime desc ";
else
{
long i = Long.parseLong(s2)*86400000;
Date now = new Date();
Date from = new Date(now.getTime()-i);
java.text.SimpleDateFormat f = new java.text.SimpleDateFormat("yyyy-MM-dd");
String fromday = f.format(from);
sql = sql + " and '"+fromday+"'<=addtime order by edittime desc ";
}
ResultSet rs = selectRecord(sql);
Statement stmt = null;
try{
while(rs.next())
{
recnum++;
}
vt.add(String.valueOf(recnum));
}catch(Exception e){System.out.println("MainBean.search(String keyword,String s1,String s2,String id)運行時出錯："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("MainBean.search(String keyword,String s1,String s2,String id)關閉記錄集rs時出錯"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("MainBean.search(String keyword,String s1,String s2,String id)關閉聲明時statement出錯"+e);}
}
if(recnum==0)
{
vt.add(String.valueOf(recnum));
return vt;
}
else
{
int page = 0;
if(id.equals(""))
page=1;
else
page=Integer.parseInt(id);
Vector vt1 = (Vector)getOnePage(sql,page,10);
for(int j=0;j<vt1.size();j++)
{
vt.add(vt1.get(j));
}
return vt;
}
}
//搜索文章keyword:關鍵字,s1:標題或關鍵字,s2:時間,id:顯示第幾頁
public Vector search1(String keyword,String s1,String s2,String id)//搜索文章
{
String sql = "";
int recnum = 0;
Vector vt = new Vector();
keyword = ds.toString(keyword);
String str[] = ds.splitStr(ds.toString(keyword),' ');
String field = "TITLE";
if(s1.equals("2"))field = "KEYWORD";
String sql1 = "";
for(int i=0;i<str.length;i++)
{
if(str[i].length()==0)continue;
if(!sql1.equals(""))sql1 += " or ";
sql1 = sql1 + "lower(" + field + ") like '%"+str[i].toLowerCase()+"%' ";
}
sql = "select ID,MENUID,TITLE,TOPICID,FROMSITE,WRITER,ADDTIME,KEYWORD,IFHEAD,IFGOOD,IFSHOW,IMG,HITS,ORGID,AUTHOR from news.article where ";
sql = sql + "ORGANID='00000000000000000000' and ifshow='1' ";
if(!sql1.equals(""))sql = sql + " and " + sql1;
if(s2.equals("all")||s2.equals(""))
sql = sql + "order by edittime desc ";
else
{
long i = Long.parseLong(s2)*86400000;
Date now = new Date();
Date from = new Date(now.getTime()-i);
java.text.SimpleDateFormat f = new java.text.SimpleDateFormat("yyyy-MM-dd");
String fromday = f.format(from);
sql = sql + " and '"+fromday+"'<=addtime order by edittime desc ";
}
ResultSet rs = selectRecord(sql);
Statement stmt = null;
try{
while(rs.next())
{
recnum++;
}
vt.add(String.valueOf(recnum));
}catch(Exception e){System.out.println("MainBean.search1(String keyword,String s1,String s2,String id)運行時出錯："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("MainBean.search1(String keyword,String s1,String s2,String id)關閉記錄集rs時出錯"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("MainBean.search1(String keyword,String s1,String s2,String id)關閉聲明時statement出錯"+e);}
}
if(recnum==0)
{
vt.add(String.valueOf(recnum));
return vt;
}
else
{
int page = 0;
if(id.equals(""))
page=1;
else
page=Integer.parseInt(id);
Vector vt1 = (Vector)getOnePage1(sql,page,10,true);//getOnePage(sql,page,10);
for(int j=0;j<vt1.size();j++)
{
vt.add(vt1.get(j));
}
return vt;
}
}
//取得所有定義的Css風格--------------------------------------------------------------------------
public Vector getCss()
{
Vector vect = new Vector();
String sql = "";
sql = "select * from news.NB_YSB order by ID";
ResultSet rs = selectRecord(sql);
Statement stmt = null;
try{
//取得列數和列名
ResultSetMetaData rsmd = rs.getMetaData();
int cols = rsmd.getColumnCount();
while(rs.next())
{
Hashtable hash = new Hashtable();
for(int i=1;i<=cols;i++)
{
String field = ds.toString(rsmd.getColumnName(i));
String value = ds.toString(rs.getString(i));
hash.put(field,value);
}
vect.add(hash);
}
}catch(Exception e){System.out.println("MainBean.getCss()運行時出錯："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("MainBean.getCss()關閉記錄集rs時出錯"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("MainBean.getCss()關閉聲明時statement出錯"+e);}
}
return vect;
}
//取得所有一級菜單--------------------------------------------------------------------------------
public Vector getMenu()
{
Vector vect = new Vector();
String sql = "";
sql = "select * from news.MENU where ZT='0' and ID2=0 order by ID1";
ResultSet rs = selectRecord(sql);
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -