基于jsp的企业信息发布系统

/********************************************************** 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