newseditsubmitaction.java

新闻中心系统源代码 (struts+sqlserver) 里面附有数据库文件

package StudyNews;

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 javax.servlet.ServletContext;
import javax.sql.DataSource;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.SQLException;

import java.util.*;
import javax.servlet.http.*;
import org.apache.struts.validator.DynaValidatorForm;
import org.apache.struts.action.ActionMessage;
import org.apache.struts.action.ActionMessages;

public final class NewsEditSubmitAction extends Action{  
	public ActionForward execute(
		ActionMapping mapping,
		ActionForm form,
		HttpServletRequest request,  
		HttpServletResponse response) throws Exception {
			
   		DynaValidatorForm newsForm = (DynaValidatorForm) form;         
		Integer newsId = (Integer)newsForm.get("newsId");
		String title = (String)newsForm.get("title");
		String content = (String)newsForm.get("content");
		String author = (String)newsForm.get("author");
		String keyword = (String)newsForm.get("keyword");
		Integer newsType = (Integer)newsForm.get("type");
		
        HttpSession session = request.getSession();
		Vector newsList = new Vector();
		
   		ServletContext context = servlet.getServletContext();
		DataSource dataSource = 
			(DataSource)context.getAttribute(Constants.DATASOURCE_KEY);
						
        DB db = new DB(dataSource);
		String PageForward;
        
		News news=new News();
		news.setId(newsId.intValue());
		news.setTitle(title);
		news.setContent(content);
		news.setAuthor(author);
		news.setKeyword(keyword);
		news.setType(newsType.intValue());
		
		ActionMessages errors = new ActionMessages();
		if (news.Edit(db)){
			newsList = News.SearchNewsTitle(db);
			session.setAttribute(Constants.NEWS_LIST_KEY,newsList);
			PageForward="toAdminMain";					
		}
		else{
            errors.add(ActionMessages.GLOBAL_MESSAGE,
                           new ActionMessage("errors.updateFail"));
			if (!errors.isEmpty()) {
				saveErrors(request, errors);
			} 
 			PageForward="toWrong";  
		}
   		
		db.close();
	   	return (mapping.findForward(PageForward));					
 	}	
}