editnewsaction.java

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

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

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 java.sql.ResultSet;
import com.hao2007.struts.form.EditNews;

/**
 * MyEclipse Struts Creation date: 08-29-2007
 * 
 * XDoclet definition:
 * 
 * @struts.action validate="true"
 * @struts.action-forward name="editNewsSuccess" path="/admin/editNews.jsp"
 */
public class EditNewsAction extends Action {
	/*
	 * Generated Methods
	 */

	/**
	 * Method execute
	 * 
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 */
	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response)
			throws Exception {
		// TODO Auto-generated method stub
		int id;
		id = Integer.parseInt(request.getParameter("id"));
		EditNews editNews=new EditNews();

		DataStore ds = DataStore.getInstance();

		ds.beginTransaction();
		ResultSet rs = null;
		try {
			String sql = "select * from news where id='" + id + "'";
			rs=ds.read(sql);
 
			while(rs.next()){
				editNews.setId(rs.getInt("id"));
				editNews.setTitle(rs.getString("title"));
				editNews.setKey_words(rs.getString("key_words"));
				editNews.setSort_id(rs.getInt("sort_id"));
				editNews.setContent(rs.getString("content"));
				editNews.setSource(rs.getString("source"));
				editNews.setAuthor(rs.getString("author"));
				editNews.setAdd_time(rs.getDate("add_time"));
				
			}
		} catch (Exception e) {
			e.printStackTrace();
		}

		ds.commitTransaction();
		request.setAttribute("EN", editNews);
		return (mapping.findForward("editNewsSuccess"));
	}
}