mynewsbean.java

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

/**********************************************************
Copyright (C),2003-10-17, Beijing  USTB.
All rights reserved.
Filename: MynewsBean.java
Author: 
Version 1.0
Date:2003-11-07
Description:个人办公首页
Other:
Variable List:
1.String uid = "-1";//人员编号

Function List:
1.public void setUID(String uid)//设置人员编号
//编号，标题
2.public Vector getLastNews(String lx)//取得相应类型的最新新闻
3.public Vector getLastGG()//取得代办公文
4.public Vector getLastMail()//取得新邮件
5.public Vector getLastThing()//取得待办事宜

6.public Vector getNewsInfo(String id)//取得部门新闻的详细信息
7.public Vector getGGInfo(String id)//取得代办公文的详细信息
8.public Vector getMailInfo()//取得新邮件的详细信息
9.public Vector getThingInfo()//取得待办事宜的详细信息


History:
***********************************************************/
package oa.bean;

import java.text.*;
import java.util.*;
import java.lang.*;
import java.io.*;
import java.sql.*;
import oa.main.*;

public class MynewsBean extends ParentBean
{
	String uid = "-1";//人员编号

	public void setUID(String uid)//设置人员编号
	{
		this.uid = uid.trim();
	}

	/**取得相应类型的最新新闻*/
	public Vector getLastNews(String lx,int cur)
	{
		lx = lx.trim();
		String bmbh = toName("ZZ_ZGB","ZGBH","BMBH",uid);
		if(bmbh!=null && bmbh.length()==20)
			bmbh = bmbh.substring(0,4);
		String sql = "select BH from ORGMENU where BMBH like '"+bmbh+"%' and MC='"+lx+"'";
		Vector vect = new Vector();
		Vector v = new Vector();
		Stack s = new Stack();
		String bh = "";
		Statement stmt = null;
		ResultSet rs = selectRecord(sql);
		try{
			while(rs.next())
			{
				bh = ds.toString(rs.getString("BH"));
				vect.add(bh);
				s.push(bh);
			}
		}catch(Exception e){System.out.println("运行时出错："+e);}
		finally{
			if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("关闭记录集rs时出错"+e);}
			if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("关闭声明时statement出错"+e);}		
		}
		while(!s.empty())
		{
			bh = (String)s.pop();
			sql = "select BH from ORGMENU where PBH ="+bh;
			rs = selectRecord(sql);
			try{
				while(rs.next())
				{
					bh = ds.toString(rs.getString("BH"));
					vect.add(bh);
					s.push(bh);
				}
			}catch(Exception e){System.out.println("运行时出错："+e);}
			finally{
				if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("关闭记录集rs时出错"+e);}
				if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("关闭声明时statement出错"+e);}		
			}
		}

		//检索所有的最新文章
		sql = "";
		for(int i=0;i<vect.size();i++)
		{
			bh = (String)vect.get(i);
			if(!sql.equals(""))sql += " union ";
			sql += "select id from article where ORGANID like '"+bmbh+"%' and WZLX="+bh;
		}
		if(vect.size()==0)sql = "-1";
		sql = "select id,title,addtime,hits,MC from article,ORGMENU where article.wzlx=ORGMENU.bh and article.id in ("+sql+") order by addtime desc";
		v = getOnePage(sql,cur,40);
		return v;
	}

	/**取得代办公文*/
	public Vector getLastGG()
	{
		Vector vect = new Vector();
		//String sql = "select g.gwbh as gwbh,g.gwbt as gwbt,g.GWLB as GWLB,f.bzmc as bzmc,f.bzxh as bzxh,g.JWSJ as JWSJ from gw_fwlzb f ,gw_gwb g  where g.gwbh=f.gwbh and g.cwzt=0 and f.lzzgbh='"+uid+"' and f.sfwb=0 order by JWSJ desc";
		String sql="select dbbt,dbcz,ljdz,dblb from zz_dbsyb where dblb in (1,2,5) and sftx=0 and zgbh='"+uid+"' ";
		vect = getOnePage(sql,1,40);
		return vect;
	}

	/**取得新邮件*/
	public Vector getLastMail()
	{
		Vector vect = new Vector();
		String sql = "select SJID,ZT,FSSJ,XM from ZZ_SYJB,ZZ_ZGB where ZGBH=FJRZGBH and SJRZGBH='"+uid+"' and yjzt='0' and READ='0' and success='0' order by FSSJ desc";
		vect = getOnePage(sql,1,40);
		return vect;
	}

	/**取得日程安排*/
	public Vector getLastThing()
	{
		Vector vect = new Vector();
		String sql = "select RCXH,BT,SJ from ZZ_GRRCB where ZGBH='"+uid+"' and sysdate between to_date(TXSJ,'YYYY-MM-DD HH24:MI:SS') and to_date(SJ,'YYYY-MM-DD HH24:MI:SS') order by SJ desc";
		vect = getOnePage(sql,1,40);
		return vect;
	}

	//取得部门新闻的详细信息6.public Vector getNewsInfo(String id)
	//取得代办公文的详细信息7.public Vector getGGInfo(String id)
	//取得新邮件的详细信息8.public Vector getMailInfo()
	//取得待办事宜的详细信息9.public Vector getThingInfo()

	

	
	
	

	public static void main(String args[]) 
	{
		MynewsBean mb = new MynewsBean();

		mb.setUID("1");//admin
		//System.out.println(mb.getLastGG());
		mb.setUID("85");//zdhbgly
		System.out.println(mb.getLastNews("公告",1));
		mb.setUID("10");//dingyi
		//System.out.println(mb.getLastMail());
		mb.setUID("22");
		//System.out.println(mb.getLastThing());
		
		
		

		System.out.println("\r\n\r\nend");
	}
}