mainbean.java

运用java+jsp写的一个新闻发布系统

		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();
		String sql = "";
		sql = "select * from MENU where ID1 = "+id1+" and id2<>0 and ID3=0 order by ID2";
		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.getMenu2()运行时出错："+e);}
		finally{
			if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("MainBean.getMenu2()关闭记录集rs时出错"+e);}
			if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("MainBean.getMenu2()关闭声明时statement出错"+e);}		
		}
		return vect;
	}


	//根据一二级菜单取得所有三级菜单信息
	public Vector getMenu3()
	{
		Vector vect = new Vector();
		String sql = "";

		sql = "select * from MENU where ID1 = "+id1+" and ID2 = "+id2+" and id3<>0";
		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.getMenu3()运行时出错："+e);}
		finally{
			if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("MainBean.getMenu3()关闭记录集rs时出错"+e);}
			if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("MainBean.getMenu3()关闭声明时statement出错"+e);}		
		}
		return vect;
	}


	//根据一级菜单名得到其编号-----------------------------------------------------------------------
	public String toId1(String m1)
	{	
		String id = "";
		String sql = "";
		sql = "select distinct ID1 from MENU where MENU1 = '"+m1+"'";
		ResultSet rs = selectRecord(sql);
		Statement stmt = null;
		try{
		if(rs.next())
		{
			id = ds.toString(rs.getString("ID1"));
		}
		}catch(Exception e){System.out.println("MainBean.toId1(String m1)运行时出错："+e);}
		finally{
			if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("MainBean.toId1(String m1)关闭记录集rs时出错"+e);}
			if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("MainBean.toId1(String m1)关闭声明时statement出错"+e);}		
		}

		return id;
	}


	//根据一级菜单编号得到其名------------------------------------------------------------------------
	public String toMenu1(String id1)
	{
		String menu = "";
		String sql = "";
		if (id1.equals(""))
		{
			return menu;
		}
		sql = "select distinct MENU1 from MENU where ID1 = "+id1+"";
		ResultSet rs = selectRecord(sql);
		Statement stmt = null;
		try{
		if(rs.next())
		{
			menu = ds.toString(rs.getString("MENU1"));
		}
		}catch(Exception e){System.out.println("MainBean.toMenu1(String id1)运行时出错："+e);}
		finally{
			if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("MainBean.toMenu1(String id1)关闭记录集rs时出错"+e);}
			if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("MainBean.toMenu1(String id1)关闭声明时statement出错"+e);}		
		}

		return menu;
	}


	//根据一、二级菜单编号得到其名
	public String toMenu2(String id1,String id2)
	{
		String menu = "";
		String sql = "";
		if(id1.equals("")||id2.equals(""))
		{
			return menu;
		}
		sql = "select distinct MENU2 from MENU where ID1 = "+id1+" and ID2 = "+id2+" and ID3= 0";
		ResultSet rs = selectRecord(sql);
		Statement stmt = null;
		try{
		if(rs.next())
		{
			menu = ds.toString(rs.getString("MENU2"));
		}
		}catch(Exception e){System.out.println("MainBean.toMenu2(String id1,String id2)运行时出错："+e);}
		finally{
			if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("MainBean.toMenu2(String id1,String id2)关闭记录集rs时出错"+e);}
			if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("MainBean.toMenu2(String id1,String id2)关闭声明时statement出错"+e);}		
		}
		return menu;
	}

	//根据一级菜单下的取得文章------------------------------------------------------------------------
	public Vector getArticle(String id)
	{
		Vector v_menu = new Vector();
		Vector v_article = new Vector();
		if(id.equals(""))
			return v_article;
		//检索菜单表编号
		int num=0;
		String sql = "select num from nb_zyszb where id="+id; 
		ResultSet rs = selectRecord(sql);
		Statement stmt = null;
		try{
			if(rs.next())	num = rs.getInt(1);
		}catch(Exception e){System.out.println("MainBean.getArticle(String id)运行时出错："+e);}
		finally{
			if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("MainBean.getArticle(String id)关闭记录集rs时出错"+e);}
			if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("MainBean.getArticle(String id)关闭声明时statement出错"+e);}		
		}
		sql = "select ID from Menu where id3<>0 and Id1="+id;
		rs = selectRecord(sql);
		Vector v_child = new Vector();
		try{
		while(rs.next())
		{
			v_menu.add(rs.getString("ID"));
		}
		if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("MainBean.getArticle(String id)关闭记录集rs时出错"+e);}
		if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("MainBean.getArticle(String id)关闭声明时statement出错"+e);}		
		if(v_menu.isEmpty()) return v_menu;


		//检索子菜单表编号
		sql = "select ID from menuchild where isthis=0 and IDPARENT in (select ID from Menu where id3<>0 and Id1="+id+")";
		rs = selectRecord(sql);
		while(rs.next())
		{
			String id4 = rs.getString("ID");
			v_child.add(id4);
			Stack s4 = new Stack();
			s4.push(id4);

			while(!s4.empty())//当有孩子节点时继续搜索
			{
				id4 = (String)s4.pop();
				sql = "select count(id) from menuchild where isthis=1 and IDPARENT="+id4;
				ResultSet rs4 = selectRecord(sql);
				int count =0;
				try{
					if(rs4.next())
						count = rs4.getInt(1);
				}catch(Exception e){System.out.println("MainBean.getArticle(String id)运行时出错："+e);}
				finally{
					if(rs4!=null)try{ stmt = rs4.getStatement(); rs4.close();}catch(Exception e){System.out.println("MainBean.getArticle(String id)关闭记录集rs时出错"+e);}
					if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("MainBean.getArticle(String id)关闭声明时statement出错"+e);}		
				}
	
				if(count>0)
				{
					sql = "select id from menuchild where isthis=1 and  IDPARENT="+id4;					
					ResultSet rs_t = selectRecord(sql);
					try{
						while(rs_t.next())
						{
							String id_t = rs_t.getString("id");	
							s4.push(id_t);
							v_child.add(id_t);
						}
					}catch(Exception e){System.out.println("MainBean.getArticle(String id)运行时出错："+e);}
					finally{
						//if(rs_t!=null)try{ stmt = rs_t.getStatement(); rs_t.close();}catch(Exception e){System.out.println("MainBean.getArticle(String id)关闭记录集rs时出错"+e);}
						//if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("MainBean.getArticle(String id)关闭声明时statement出错"+e);}		
					}
				}
			}
		}
		}catch(Exception e){System.out.println("MainBean.getArticle(String id)运行时出错："+e);}
		finally{
			//if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("MainBean.getArticle(String id)关闭记录集rs时出错"+e);}
			//if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("MainBean.getArticle(String id)关闭声明时statement出错"+e);}		
		}

		//检索文章编号
		sql = "";
		for(int i=0;i<v_menu.size();i++)
		{
			//if(!sql.equals(""))sql += " union ";
			//sql += "select id from article where whichtable='1' and ifshow='1' and ORGANID='00000000000000000000' and menuid="+(String)v_menu.get(i);
			if(!sql.equals(""))sql += ",";
			sql += (String)v_menu.get(i);
		}
		for(int i=0;i<v_child.size();i++)
		{
			//if(!sql.equals(""))sql += " union ";
			//sql += "select id from article where whichtable='0' and ifshow='1' and ORGANID='00000000000000000000' and menuid="+(String)v_child.get(i);
			if(!sql.equals(""))sql += ",";
			sql += (String)v_menu.get(i);
		}

		sql = "select id from article where whichtable='1' and ifshow='1' and ORGANID='00000000000000000000' and menuid in ("+sql+")";
	
		sql = "select id,title,addtime,hits from article where id in ("+sql+") order by edittime desc";

		rs = selectRecord(sql);
		try{
		int i = 0;
		ResultSetMetaData rsmd = rs.getMetaData();
		int cols = 0;
		cols = rsmd.getColumnCount();				
		while(rs.next())
		{
			Hashtable hash = new Hashtable();
			for(i=1;i<=cols;i++)
			{
				String field = ds.toString(rsmd.getColumnName(i));
				String value = ds.toString(rs.getString(i));
				hash.put(field,value);
			}
			v_article.add(hash);//把文章信息存入
			i++;
			if(i==num)break;
		}
		}catch(Exception e){System.out.println("MainBean.getArticle(String id)运行时出错："+e);}
		finally{
			//if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("MainBean.getArticle(String id)关闭记录集rs时出错"+e);}
			//if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("MainBean.getArticle(String id)关闭声明时statement出错"+e);}		
		}
		
		if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("MainBean.getArticle(String id)关闭记录集rs时出错"+e);}
			if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("MainBean.getArticle(String id)关闭声明时statement出错"+e);}		
		
		return v_article;
	}

	//根据一级菜单下的取得文章------------------------------------------------------------------------
	public Vector getArticle1(String id1,String menu2)
	{
		Vector v_menu = new Vector();
		Vector v_article = new Vector();
		if(id1.equals(""))
			return v_article;
		//检索菜单表编号
		int num=0;
		String sql = "select num from nb_zyszb where id=20"; 
		ResultSet rs = selectRecord(sql);
		Statement stmt = null;
		try{
			if(rs.next())	num = rs.getInt(1);
		}catch(Exception e){System.out.println("MainBean.getArticle1(String id1,String menu2)运行时出错："+e);}
		finally{
			//if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("MainBean.getArticle1(String id1,String menu2)关闭记录集rs时出错"+e);}
			//if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("MainBean.getArticle1(String id1,String menu2)关闭声明时statement出错"+e);}		
		}
		sql = "select ID from Menu where id3<>0 and Id1="+id1+" and MENU2='"+menu2+"'";
		rs = selectRecord(sql);
		Vector v_child = new Vector();
		try{
		while(rs.next())
		{
			v_menu.add(rs.getString("ID"));
		}
		//if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("MainBean.getArticle1(String id1,String menu2)关闭记录集rs时出错"+e);}
		//if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("MainBean.getArticle1(String id1,String menu2)关闭声明时statement出错"+e);}		
	
		if(v_menu.isEmpty()) return v_menu;