mainbean.java

这是一个很好用的软件

		if (which.equals("0"))
			sql = "select MENUCHILD as MENUNAME from news.menuchild where id = "
					+ menuid + "";
		else
			sql = "select MENU3 as MENUNAME from news.menu where id = "
					+ menuid + "";
		ResultSet rs = selectRecord(sql);
		return getStrByResultSet(rs, "MENUNAME");
	}

	//取得所有栏目精选------------------------------------------------------------------------
	public Vector getGood() {
		String sql = " select * from news.ARTICLE where IFGOOD='1' and IFSHOW='1' order by edittime desc";
		ResultSet rs = selectRecord(sql);
		return getResultSetData(rs);
	}

	//取得某一级版面下的焦点------------------------------------------------------------------------
	public Vector getGood(String id) {
		//检索菜单表编号

		String sql = "select num from news.nb_zyszb where id=" + id;
		ResultSet rs = selectRecord(sql);
		Statement stmt = null;
		Vector v_article = new Vector();
		int num = 0;
		try {
			if (rs.next())
				num = rs.getInt(1);
			sql = "select ID from news.Menu where Id3!=0 and Id1=" + id;
			rs = selectRecord(sql);
			Vector v_menu = new Vector();
			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="
					+ id + ")";
			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.getGood(String id)运行时出错："
												+ e);
							} finally {
								if (rs_t != null)
									try {
										stmt = rs_t.getStatement();
										rs_t.close();
									} catch (Exception e) {
										System.out
												.println("MainBean.getGood(String id)关闭记录集rs时出错"
														+ e);
									}
								if (stmt != null)
									try {
										stmt.close();
									} catch (Exception e) {
										System.out
												.println("MainBean.getGood(String id)关闭声明时statement出错"
														+ e);
									}
							}
						}
					} catch (Exception e) {
						System.out.println("MainBean.getGood(String id)运行时出错："
								+ e);
					} finally {
						if (rs4 != null)
							try {
								stmt = rs4.getStatement();
								rs4.close();
							} catch (Exception e) {
								System.out
										.println("MainBean.getGood(String id)关闭记录集rs时出错"
												+ e);
							}
						if (stmt != null)
							try {
								stmt.close();
							} catch (Exception e) {
								System.out
										.println("MainBean.getGood(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 ifgood ='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 ifgood ='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.getGood(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);
			}

		return v_article;
	}

	//取得某一级版面下的焦点------------------------------------------------------------------------
	public Vector getGood(String id, String type) {
		//检索菜单表编号
		//type=21焦点导读
		//type=22栏目精选
		String sql = "select num from news.nb_zyszb where id=" + type;
		ResultSet rs = selectRecord(sql);
		Vector v_article = new Vector();
		Statement stmt = null;
		int num = 0;
		try {
			if (rs.next())
				num = rs.getInt(1);
			sql = "select ID from news.Menu where Id3!=0 and Id1=" + id;
			rs = selectRecord(sql);
			Vector v_menu = new Vector();
			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="
					+ id + ")";
			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);
					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("运行时出错：" + e);
							} finally {
								if (rs_t != null)
									try {
										stmt = rs_t.getStatement();
										rs_t.close();
									} catch (Exception e) {
										System.out.println("关闭记录集rs时出错" + e);
									}
								if (stmt != null)
									try {
										stmt.close();
									} catch (Exception e) {
										System.out.println("关闭声明时statement出错"
												+ e);
									}
							}
						}
					} catch (Exception e) {
						System.out.println("运行时出错：" + e);
					} finally {
						if (rs4 != null)
							try {
								stmt = rs4.getStatement();
								rs4.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 < v_menu.size(); i++) {
				if (!sql.equals(""))
					sql += " union ";
				sql += "select id from news.article where whichtable='1' and ifshow='1' and ifgood ='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 ifgood ='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 (int j = 1; j <= cols; j++) {
					String field = ds.toString(rsmd.getColumnName(j));
					String value = ds.toString(rs.getString(j));
					hash.put(field, value);
				}
				v_article.add(hash);//把焦点文章信息存入
				i++;
				if (i == num)
					break;
			}
		} catch (Exception e) {
			System.out.println("运行时出错：" + 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 getGood(String id, String type, int cur, int records) {
		//检索菜单表编号
		//type=21焦点导读
		//type=22栏目精选

		String sql = "select num from news.nb_zyszb where id=" + type;
		ResultSet rs = null;
		Vector v_article = new Vector();
		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.getGood(String id,String type,int
			// cur,int records)关闭记录集rs时出错"+e);}
			//if(stmt!=null) try{stmt.close();}catch(Exception
			// e){System.out.println("MainBean.getGood(String id,String type,int
			// cur,int records)关闭声明时statement出错"+e);}

			sql = "select ID from news.Menu where Id3!=0 and Id1=" + id;
			rs = selectRecord(sql);
			Vector v_menu = new Vector();
			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.getGood(String id,String type,int
			// cur,int records)关闭记录集rs时出错"+e);}
			//if(stmt!=null) try{stmt.close();}catch(Exception
			// e){System.out.println("MainBean.getGood(String id,String type,int
			// cur,int records)关闭声明时statement出错"+e);}
			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="
					+ id + ")";
			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);
					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("运行时出错：" + e);
							} finally {
								if (rs_t != null)
									try {
										stmt = rs_t.getStatement();
										rs_t.close();
									} catch (Exception e) {
										System.out.println("关闭记录集rs时出错" + e);
									}
								if (stmt != null)
									try {
										stmt.close();
									} catch (Exception e) {
										System.out.println("关闭声明时statement出错"
												+ e);
									}
							}
						}