/**********************************************************
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
评论3
最新资源