//Created by MyEclipse Struts// XSL source (default): platform:/plugin/com.genuitec.eclipse.cross.easystruts.eclipse_4.1.1/xslt/JavaClass.xslpackage 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;			}}