public int getTotalNewsCount(){
		
		PreparedStatement stmt = null;
		ResultSet rs = null;
		int count=0;
		
		try {

			stmt = conn
					.prepareStatement("select count(1) from NewsInfo");

			rs = stmt.executeQuery();

			if (rs.next()) {

				count=rs.getInt(1);
			}

			if (stmt != null)
				stmt.close();
			if (rs != null)
				rs.close();

		} catch (Exception e) {
			// TODO: handle exception
			
			logger.debug(e.getMessage());
		}
		
		return count;
	}