mainbean.java

这是一个很好用的软件

						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 news.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 news.article where whichtable='1' and ifshow='1' and ORGANID='00000000000000000000' and menuid="
					+ (String) v_menu.get(i);
		}
		for (int i = 0; i < v_child.size(); i++) {
			if (!sql.equals(""))
				sql += " union ";
			sql += "select id from news.article where whichtable='0' and ifshow='1' and ORGANID='00000000000000000000' and menuid="
					+ (String) v_child.get(i);
		}

		sql = "select id,title,addtime,hits from news.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 news.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 {
			
		}
		sql = "select ID from news.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 (v_menu.isEmpty())
				return v_menu;

			//检索子菜单表编号
			sql = "select ID from news.menuchild where isthis=0 and IDPARENT in (select ID from news.Menu where Id3!=0 and Id1="
					+ id1 + " and MENU2='" + menu2 + "')";
			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 news.menuchild where isthis=1 and IDPARENT="
							+ id4;
					ResultSet rs4 = selectRecord(sql);
					try {
						int count = 0;
						if (rs4.next())
							count = rs4.getInt(1);
						if (count > 0) {
							sql = "select id from news.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.getArticle1(String id1,String menu2)运行时出错："
												+ e);
							} finally {
								if (rs_t != null)
									try {
										stmt = rs_t.getStatement();
										rs_t.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);
									}
							}
						}
					} catch (Exception e) {
						System.out
								.println("MainBean.getArticle1(String id1,String menu2)运行时出错："
										+ e);
					} finally {
						if (rs4 != null)
							try {
								stmt = rs4.getStatement();
								rs4.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 = "";
			for (int i = 0; i < v_menu.size(); i++) {
				if (!sql.equals(""))
					sql += " union ";
				sql += "select id from news.article where whichtable='1' and ifshow='1' and ORGANID='00000000000000000000' and menuid="
						+ (String) v_menu.get(i);
			}
			for (int i = 0; i < v_child.size(); i++) {
				if (!sql.equals(""))
					sql += " union ";
				sql += "select id from news.article where whichtable='0' and ifshow='1' and ORGANID='00000000000000000000' and menuid="
						+ (String) v_child.get(i);
			}

			sql = "select id,title,addtime,hits from news.article where id in ("
					+ sql + ") order by edittime desc";
			rs = selectRecord(sql);
			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.getArticle1(String id1,String menu2)运行时出错："
							+ 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);
			}

		return v_article;
	}

	//根据一级菜单下的取得文章------------------------------------------------------------------------
	public Vector getArticle(String id1, String menu2, int cur, int records) {
		Vector v_menu = new Vector();
		Vector v_article = new Vector();
		if (id1.equals(""))
			return v_article;

		//检索菜单表编号
		String sql = "select num from news.nb_zyszb where id=20";
		ResultSet rs = null;
		Statement stmt = null;
		try {
			int num = records;
			if (num == 0) {
				rs = selectRecord(sql);
				if (rs.next())
					num = rs.getInt(1);
			}
			//if(rs!=null)try{ stmt = rs.getStatement();
			// rs.close();}catch(Exception
			// e){System.out.println("MainBean.getArticle(String id1,String
			// menu2,int cur,int records)关闭记录集rs时出错"+e);}
			//if(stmt!=null) try{stmt.close();}catch(Exception
			// e){System.out.println("MainBean.getArticle(String id1,String
			// menu2,int cur,int records)关闭声明时statement出错"+e);}

			sql = "select ID from news.Menu where Id3!=0 and Id1=" + id1
					+ " and MENU2='" + menu2 + "'";
			rs = selectRecord(sql);
			while (rs.next()) {
				v_menu.add(rs.getString("ID"));
			}
			if (v_menu.isEmpty())
				return v_menu;

			//if(rs!=null)try{ stmt = rs.getStatement();
			// rs.close();}catch(Exception
			// e){System.out.println("MainBean.getArticle(String id1,String
			// menu2,int cur,int records)关闭记录集rs时出错"+e);}
			//if(stmt!=null) try{stmt.close();}catch(Exception
			// e){System.out.println("MainBean.getArticle(String id1,String
			// menu2,int cur,int records)关闭声明时statement出错"+e);}

			//检索子菜单表编号
			sql = "select ID from news.menuchild where isthis=0 and IDPARENT in (select ID from news.Menu where Id3!=0 and Id1="
					+ id1 + " and MENU2='" + menu2 + "')";
			rs = selectRecord(sql);
			Vector v_child = new Vector();
			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 news.menuchild where isthis=1 and IDPARENT="
							+ id4;
					ResultSet rs4 = selectRecord(sql);
					int count = 0;
					try {
						if (rs4.next())
							count = rs4.getInt(1);
						if (count > 0) {
							sql = "select id from news.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 id1,String menu2,int cur,int records)运行时出错："
												+ e);
							} finally {
								if (rs_t != null)
									try {
										stmt = rs_t.getStatement();
										rs_t.close();
									} catch (Exception e) {
										System.out
												.println("MainBean.getArticle(String id1,String menu2,int cur,int records)关闭记录集rs时出错"
														+ e);
									}
								if (stmt != null)
									try {
										stmt.close();
									} catch (Exception e) {
										System.out
												.println("MainBean.getArticle(String id1,String menu2,int cur,int records)关闭声明时statement出错"
														+ e);
									}
							}
						}
					} catch (Exception e) {
						System.out
								.println("MainBean.getArticle(String id1,String menu2,int cur,int records)运行时出错："
										+ e);
					} finally {
						if (rs4 != null)
							try {
								stmt = rs4.getStatement();
								rs4.close();
							} catch (Exception e) {
								System.out
										.println("MainBean.getArticle(String id1,String menu2,int cur,int records)关闭记录集rs时出错"