mainbean.java

“JSP数据库项目案例导航”一书从第一章到第十一章各章实例的源程序文件以及数据库文件。 注意： 1. 本书中的案例提供的数据库环境不同

/**********************************************************
Copyright (C),2003-11-2, Beijing  USTB.
All rights reserved.
Filename: MainBean.java
Author: 
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";//记录唯一编号
	Vector vet_menutable = new Vector();//菜单表记录
	Vector vet_maintable = new Vector();//主页设置表记录

	public void setId(String d)//设置菜单
	{

	}

	//设置一级菜单号码
	public void setId1(String d1)
	{
		id1 = d1;
	}

	//设置二级菜单号码
	public void setId2(String d2)
	{
		id2 = d2;
	}

	public void setMain(Vector v)
	{
		vet_maintable = v ;
	}

	public void setMenu(Vector v)
	{
		vet_menutable = v ;
	}

	//搜索文章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 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 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 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)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 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 MENU where ZT='0' and ID2=0 order by ID1";
		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.getMenu()运行时出错："+e);}
		finally{
			if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("MainBean.getMenu()关闭记录集rs时出错"+e);}
			if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("MainBean.getMenu()关闭声明时statement出错"+e);}		
		}
		return vect;
	}


	//根据一级菜单取得所有二级菜单------------------------------------------------------------------
	public Vector getMenu2()
	{
		Vector vect = new Vector();