newsoptionaction.java

自己写的新闻发布模块

//Created by MyEclipse Struts
// XSL source (default): platform:/plugin/com.genuitec.eclipse.cross.easystruts.eclipse_4.1.1/xslt/JavaClass.xsl

package cn.lingqi.struts.action;

import java.io.IOException;
import java.io.PrintWriter;
import java.util.ArrayList;

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

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 cn.lingqi.dao.NewsFormDAO;
import cn.lingqi.struts.form.NewsForm;

/** 
 * MyEclipse Struts
 * Creation date: 12-25-2006
 * 
 * XDoclet definition:
 * @struts.action path="/newsOption" name="newsForm" scope="request" validate="true"
 * @struts.action-forward name="addSuccess" path="newsOption.do?method=list"
 * @struts.action-forward name="addFailure" path="aaaa"
 */
public class NewsOptionAction extends Action {

	// --------------------------------------------------------- Instance Variables

	// --------------------------------------------------------- Methods

	/** 
	 * Method execute
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 */
	public ActionForward execute(
		ActionMapping mapping,
		ActionForm form,
		HttpServletRequest request,
		HttpServletResponse response) {
		String method = request.getParameter("method");
		if (method.equals("add")){return addNews(mapping,form,request,response);}
		if (method.equals("list")){listNews(form,request,response);}
		if (method.equals("typeme")){return typeNews(mapping,form,request,response);}
		if (method.equals("modify")){return modifyNews(mapping,form,request,response);}
		if (method.equals("typenews")){return typeNews(mapping,form,request,response);}
		return null;
	}
	
	public ActionForward addNews(
			ActionMapping mapping,
			ActionForm form,
			HttpServletRequest request,
			HttpServletResponse response) {
			NewsForm newsForm = (NewsForm) form;
			//System.out.println(newsForm.getTitle());
			NewsFormDAO ndao = new NewsFormDAO();
			if (ndao.insertNews(newsForm)!=0){
				return mapping.findForward("addSuccess");
			}else{
				return mapping.findForward("addFailure");
			}
		}

	public void listNews(
			ActionForm form,
			HttpServletRequest request,
			HttpServletResponse response) {
			try {
				response.setContentType("text/html;charset=GBK");
				PrintWriter out = response.getWriter();
				HttpSession session = request.getSession();
				//System.out.println(newsForm.getTitle());
				NewsFormDAO ndao = new NewsFormDAO();
				ArrayList listNews = (ArrayList) ndao.queryAll();
				session.setAttribute("listNews", listNews);
				out.print("<script>alert('插入成功');window.opener.location.reload();window.close();</script>");
			} catch (IOException e) {
				e.printStackTrace();
			}
		}
	
	public ActionForward typeNews(
			ActionMapping mapping,
			ActionForm form,
			HttpServletRequest request,
			HttpServletResponse response) {
		String method = request.getParameter("method");
		HttpSession session = request.getSession();
		int newsid = Integer.parseInt(request.getParameter("newsid"));
		NewsForm modifyNews = new NewsFormDAO().selectNews(newsid);
		session.setAttribute("modifyNews", modifyNews);
		if (method.equals("typeme")){
		return mapping.findForward("modifyMe");}
		if (method.equals("typenews")){
			return mapping.findForward("typeNews");}
		return null;
	}
	
	public ActionForward modifyNews(
			ActionMapping mapping,
			ActionForm form,
			HttpServletRequest request,
			HttpServletResponse response) {
				response.setContentType("text/html;charset=GBK");
				try {
					PrintWriter out = response.getWriter();
//				} catch (IOException e) {
//					e.printStackTrace();
//				}
//				javax.sql.DataSource ds = this.getDataSource(request,"org.apache.struts.action.DATA_SOURCE"); 
////				getDataSource(request, "myPool");
//			   Connection con;
//			try {
//				con = ds.getConnection();
//				Statement stmt = con.createStatement();
//				   String sql = "select * from news where newsid=1";
//				   ResultSet rs = stmt.executeQuery(sql);
//				   rs.next();
//				   System.out.println(rs.getString("title"));
//			} catch (SQLException e) {
//				// TODO Auto-generated catch block
//				e.printStackTrace();
//			}
			   
				NewsForm newsForm = (NewsForm) form;
				//System.out.println(newsForm.getTitle());
				newsForm.setNewsId(request.getParameter("newsid"));
				NewsFormDAO ndao = new NewsFormDAO();
				if (ndao.modifyNews(newsForm)!=0){
					return mapping.findForward("addSuccess");
				}else{
					out.print("<script>alert('修改失败');history.go(-1);</script>");
				}
			} catch (IOException e) {
				e.printStackTrace();
			}
			return null;
			}
}