linknews.java

动态网站管理发布系统

			sdbo.Close();
		}
		return vector.iterator();
	}

	public boolean isNewsShow(int kindId) {
		boolean isNews = false;
		if (sdbo == null)
			sdbo = SQLDBOperator.getInstance("Connection");
		ResultSet rs = null;
		String strSql = "select newsId from news where kindId=?;";
		try {
			sdbo.prepareStatement(strSql);
			sdbo.setInt(1, kindId);
			rs = sdbo.executeQuery();
			try {
				rs.last();
				if (rs.getRow() > 0)
					isNews = true;
				rs.close();
			} catch (NullPointerException nullE) {
				System.out.print("NewsShow sumNews() " + nullE.getMessage());
				Debug.writeLog("NewsShow sumNews(), Exception Occured ! Info :"
						+ nullE.getLocalizedMessage());
			}
		} catch (SQLException sqlE) {
			System.out.print("NewsShow sumNews() " + sqlE.getMessage());
			Debug.writeLog("NewsShow sumNews(), Exception Occured ! Info :" + sqlE.getLocalizedMessage());
		} finally {
			sdbo.Close();
		}
		return isNews;
	}

	public Iterator newsShow(int kindId) {
		Vector vector = new Vector();
		if (sdbo == null)sdbo = SQLDBOperator.getInstance("Connection");
		ResultSet rs = null;
		String strSql = "select newsId,headTitle,newsTime from news where state=0 and classId=? order by newsTime desc;";
		try {
			sdbo.prepareStatement(strSql);
			sdbo.setInt(1, kindId);
			rs = sdbo.executeQuery();
			while (rs.next()) {
				NEWSTable tableNews = new NEWSTable();
				tableNews.setNewsId(rs.getInt("newsId"));
				tableNews.setHeadTitle(new String(rs.getString("headTitle").getBytes("ISO-8859-1"), "gbk"));

				tableNews.setNewsTime(rs.getString("newsTime"));
				vector.add(tableNews);
			}
			rs.close();
		} catch (SQLException sqlE) {
			System.out.print("NewsShow sumNews() " + sqlE.getMessage());
			Debug.writeLog("NewsShow sumNews(), Exception Occured ! Info :"
					+ sqlE.getLocalizedMessage());
		} catch (UnsupportedEncodingException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} finally {
			sdbo.Close();
		}
		return vector.iterator();
	}

	public Iterator hotNewsClass(int classId) {
		Vector vector = new Vector();
		if (sdbo == null)
			sdbo = SQLDBOperator.getInstance("Connection");
		ResultSet rs = null;
		String strSql = "select newsId,headTitle from news where state=1 and classId=? order by hits desc limit 0,8;";
		try {
			sdbo.prepareStatement(strSql);
			sdbo.setInt(1, classId);
			rs = sdbo.executeQuery();
			try {
				while (rs.next()) {
					NEWSTable tableNews = new NEWSTable();
					tableNews.setNewsId(rs.getInt("newsId"));
					tableNews.setHeadTitle(rs.getString("headTitle"));
					vector.add(tableNews);
				}
				rs.close();
			} catch (NullPointerException nullE) {
				System.out.print("NewsShow sumNews() " + nullE.getMessage());
				Debug.writeLog("NewsShow sumNews(), Exception Occured ! Info :"
						+ nullE.getLocalizedMessage());
			}
		} catch (SQLException sqlE) {
			System.out.print("NewsShow sumNews() " + sqlE.getMessage());
			Debug.writeLog("NewsShow sumNews(), Exception Occured ! Info :"
					+ sqlE.getLocalizedMessage());
		} finally {
			sdbo.Close();
		}
		return vector.iterator();
	}

	public int sumNews(int kindId) {
		int sum = 0;
		if (sdbo == null)
			sdbo = SQLDBOperator.getInstance("Connection");
		ResultSet rs = null;
		String strSql = "select count(newsId) as total from news where classId=?;";
		try {
			sdbo.prepareStatement(strSql);
			sdbo.setInt(1, kindId);
			rs = sdbo.executeQuery();
			rs.next();
			sum = rs.getInt("total");
			rs.close();
		} catch (SQLException sqlE) {
			System.out.print("NewsShow sumNews() " + sqlE.getMessage());
			Debug.writeLog("NewsShow sumNews(), Exception Occured ! Info :" + sqlE.getLocalizedMessage());
		} finally {
			sdbo.Close();
		}
		return sum;
	}

	public Iterator listNews(int kindId) {
		Vector vector = new Vector();
		if (sdbo == null)
			sdbo = SQLDBOperator.getInstance("Connection");
		ResultSet rs = null;
		String strSql = "select newsId,headTitle,DATE_FORMAT(newsTime,'%Y-%m-%d') as time from news where state=1 and kindId=? order by newsTime desc;";
		try {
			sdbo.prepareStatement(strSql);
			sdbo.setInt(1, kindId);
			rs = sdbo.executeQuery();
			try {
				while (rs.next()) {
					NEWSTable tableNews = new NEWSTable();
					tableNews.setNewsId(rs.getInt("newsId"));
					tableNews.setHeadTitle(rs.getString("headTitle"));
					tableNews.setNewsTime(rs.getString("time"));
					vector.add(tableNews);
				}
				rs.close();
			} catch (NullPointerException nullE) {
				System.out.print("NewsShow sumNews() " + nullE.getMessage());
				Debug.writeLog("NewsShow sumNews(), Exception Occured ! Info :"
						+ nullE.getLocalizedMessage());
			}
		} catch (SQLException sqlE) {
			System.out.print("NewsShow sumNews() " + sqlE.getMessage());
			Debug.writeLog("NewsShow sumNews(), Exception Occured ! Info :"
					+ sqlE.getLocalizedMessage());
		} finally {
			sdbo.Close();
		}
		return vector.iterator();
	}

	public Iterator hotNewsKind(int kindId) {
		Vector vector = new Vector();
		if (sdbo == null)
			sdbo = SQLDBOperator.getInstance("Connection");
		ResultSet rs = null;
		String strSql = "select newsId,headTitle from news where kindId=? order by hits desc limit 0,6;";
		try {
			sdbo.prepareStatement(strSql);
			sdbo.setInt(1, kindId);
			rs = sdbo.executeQuery();

			while (rs.next()) {
				NEWSTable tableNews = new NEWSTable();
				tableNews.setNewsId(rs.getInt("newsId"));
				tableNews.setHeadTitle(new String(rs.getString("headTitle")
						.getBytes("ISO-8859-1"), "gbk"));
				vector.add(tableNews);
			}
			rs.close();

		} catch (SQLException sqlE) {
			System.out.print("NewsShow sumNews() " + sqlE.getMessage());
			Debug.writeLog("NewsShow sumNews(), Exception Occured ! Info :"
					+ sqlE.getLocalizedMessage());
		} catch (UnsupportedEncodingException nullE) {
			System.out.print("Personal unNews() info :" + nullE.getMessage());
			Debug.writeLog("Personal unNews(), Exception Occured ! Info :"
					+ nullE.getLocalizedMessage());
		} finally {
			sdbo.Close();
		}
		return vector.iterator();
	}

	public String strKind(int kindId) {
		String strKind = null;
		if (sdbo == null)
			sdbo = SQLDBOperator.getInstance("Connection");
		ResultSet rs = null;
		String strSql = "select content from newskind where kindId=?;";
		try {
			sdbo.prepareStatement(strSql);
			sdbo.setInt(1, kindId);
			rs = sdbo.executeQuery();
			try {
				rs.next();
				strKind = rs.getString("content");
				rs.close();
			} catch (NullPointerException nullE) {
				System.out.print("NewsShow sumNews() " + nullE.getMessage());
				Debug.writeLog("NewsShow sumNews(), Exception Occured ! Info :"+ nullE.getLocalizedMessage());
			}
		} catch (SQLException sqlE) {
			System.out.print("NewsShow sumNews() " + sqlE.getMessage());
			Debug.writeLog("NewsShow sumNews(), Exception Occured ! Info :" + sqlE.getLocalizedMessage());
		} finally {
			sdbo.Close();
		}
		return strKind;
	}

	public String nearTime(int kindId) {
		String strTime = null;
		if (sdbo == null)
			sdbo = SQLDBOperator.getInstance("Connection");
		ResultSet rs = null;
		String strSql = "select DATE_FORMAT(newsTime,'%Y-%c-%e  %k:%i:%S') as time from news where kindId='"
				+ kindId + "' order by newsTime limit 0,1;";
		try {
			rs = sdbo.executeQuery(strSql);
			rs.next();
			strTime = rs.getString("time");
			rs.close();

		} catch (SQLException sqlE) {
			System.out.print("NewsShow sumNews() " + sqlE.getMessage());
			Debug.writeLog("NewsShow sumNews(), Exception Occured ! Info :"
					+ sqlE.getLocalizedMessage());
		} finally {
			sdbo.Close();
		}
		return strTime;
	}

}