managenewsaction.java

系统特色: 1,栏目无限级分类,形成树型结构

/*
 * Generated by MyEclipse Struts
 * Template path: templates/java/JavaClass.vtl
 */
package com.hao2007.struts.action;

import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;

import java.util.Hashtable;
import java.util.List;
import java.util.ArrayList;
import java.util.Vector;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;

import com.hao2007.struts.db.DataStore;
import com.hao2007.struts.form.NewsList;
import com.hao2007.struts.bean.PageBean;

/**
 * MyEclipse Struts Creation date: 04-12-2007
 * 
 * XDoclet definition:
 * 
 * @struts.action validate="true"
 * @struts.action-forward name="manageNews" path="/admin/manageNews.jsp"
 */
public class ManageNewsAction extends Action {

	PageBean pb;

	/**
	 * Method execute
	 * 
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 */
	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response)
			throws SQLException {
		// TODO Auto-generated method stub
		String sort_id = request.getParameter("sort_id");
		ArrayList newsList = this.findList(sort_id); // 取得指定的记录数
		if (newsList != null) {

			String action;
			action = request.getParameter("action");
			if (action == null || action.equals("null")) { // 第一次读取数据

				pb = new PageBean(newsList, sort_id); // 传递参数sort_id到PageBean
				NewsList[] news_list = pb.getNsList();
				pb.description();
				request.setAttribute("result", news_list);
				request.setAttribute("page", pb);

			} else {
				if (action == "nextPage" || action.equals("nextPage")) {
					NewsList[] news_list = pb.getNextPage();
					request.setAttribute("page", pb);
					request.setAttribute("result", news_list);
				}
				if (action == "previousPage" || action.equals("previousPage")) {
					NewsList[] news_list = pb.getPreviouspage();
					request.setAttribute("page", pb);
					request.setAttribute("result", news_list);
				}
			}
		}

		else {

		}

		return (mapping.findForward("manageNews"));
	}

	// 取得指定的记录数
	public ArrayList findList(String sort_id) throws SQLException {
		int countRows = 0;
		ArrayList list = null;
		ResultSet rs = null;
		try {
			DataStore ds = DataStore.getInstance();
			String sql = "";
			if (sort_id != null) {
				sql = "select * from news where sort_path like '%," + sort_id
						+ ",%' order by add_time desc";
			} else {
				sql = "select * from news order by add_time desc";
			}

			rs = ds.read(sql);
			if (rs != null && rs.next()) {
				list = new ArrayList();
				do {
					countRows++;
					list.add(rsSet(rs));
				} while (rs.next());
			} else {

			}

		} catch (SQLException e) {

			e.printStackTrace();
		}
		return list;
	}

	private NewsList rsSet(ResultSet rs) {
		try {
			NewsList newsList = new NewsList();
			newsList.setId(rs.getInt("id"));
			newsList.setTitle(rs.getString("title"));
			newsList.setKey_words(rs.getString("key_words"));
			newsList.setSort_id(rs.getInt("sort_id"));
			newsList.setSort_path(rs.getString("sort_path"));
			newsList.setContent(rs.getString("content"));
			newsList.setAdd_time(rs.getDate("add_time"));
			newsList.setSource(rs.getString("source"));
			newsList.setAuthor(rs.getString("author"));
			return newsList;
		} catch (Exception ex) {
			ex.printStackTrace();
			return null;
		}
	}

}