addnewsaction.java

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

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

import java.sql.ResultSet;
import java.util.Date;
import java.text.SimpleDateFormat;

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.form.AddNewsForm;

import com.hao2007.struts.db.DataStore;
import java.io.PrintWriter;

/**
 * MyEclipse Struts Creation date: 03-30-2007
 * 
 * XDoclet definition:
 * 
 * @struts.action path="/addNews" name="addNewsForm" input="/admin/addNews.jsp"
 *                scope="request" validate="true"
 * @struts.action-forward name="addNewsFail" path="/admin/addNewsFail.jsp"
 * @struts.action-forward name="addNewsSuccess" path="/admin/addNewsSuccess.jsp"
 */
public class AddNewsAction 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 {

		AddNewsForm addNewsForm = (AddNewsForm) form;// TODO Auto-generated
														// method stub
		String title = (String) addNewsForm.getTitle();
		String key_words = (String) addNewsForm.getKey_words();
		int sort_id = Integer.parseInt(addNewsForm.getSort_id());
		String content = (String) addNewsForm.getContent();
		String source = (String) addNewsForm.getSource();
		String author = (String) addNewsForm.getAuthor();

		if (title == null || title.equals("null")) {
			title = "";
		}
		if (key_words == null || key_words.equals("null")) {
			key_words = "";
		}
		if (content == null || content.equals("null")) {
			content = "";
		}
		if (source == null || source.equals("null")) {
			source = "";
		}
		if (author == null || author.equals("null")) {
			author = "";
		}

		Date date = new Date();
		SimpleDateFormat dateFormat = new SimpleDateFormat(
				"yyyy-MM-dd HH:mm:ss");

		DataStore ds = DataStore.getInstance();

		// ȡ��sort_path
		String sort_path = "";
		ResultSet rs = null;
		String sql0 = "select sort_path from class where id='" + sort_id + "'";
		ds.beginTransaction();
		try {
			rs = ds.read(sql0);
		} catch (Exception e) {
			e.printStackTrace();
		}
		if (rs != null && rs.next()) {
			sort_path = rs.getString("sort_path");
			rs.close();
			rs = null;
		}
		ds.commitTransaction();

		// //////��ݿ���
		String sql = "insert into news(title,key_words,sort_id,sort_path,content,source,author,add_time) values('"
				+ title
				+ "','"
				+ key_words
				+ "','"
				+ sort_id
				+ "','"
				+ sort_path
				+ "','"
				+ content
				+ "','"
				+ source
				+ "','"
				+ author
				+ "','" + dateFormat.format(date) + "')";
		ds.beginTransaction(); // ��ʼ����
		try {
			ds.execute(sql);
		} catch (Exception e) {
			ds.ErrorOccur();
			ds.commitTransaction();
			return (mapping.findForward("addNewsFail"));

		}
		ds.commitTransaction(); // ��������

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