adminloginaction.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 org.apache.struts.action.ActionMessage;
import org.apache.struts.action.ActionMessages;

import javax.servlet.ServletContext;
import javax.sql.DataSource;
import java.sql.Connection;
import javax.servlet.http.*;
import java.util.*;
import org.apache.struts.action.DynaActionForm;


public final class AdminLoginAction extends Action{  
	public ActionForward execute(
		ActionMapping mapping,
		ActionForm form,
		HttpServletRequest request,  
		HttpServletResponse response) throws Exception {
	
   		DynaActionForm userform = (DynaActionForm) form;         
		String username = (String)userform.get("username");
		String password = (String)userform.get("password");
		
   		ServletContext context = servlet.getServletContext();
		DataSource dataSource = (DataSource)context.getAttribute(Constants.DATASOURCE_KEY);
						
        DB db = new DB(dataSource);
        HttpSession session = request.getSession(true);
        
		String PageForward;
		Vector newsList = new Vector();
		ActionMessages errors = new ActionMessages();
        if (AdminUser.CheckUser(db,username,password,"news")){
			newsList = News.SearchNewsTitle(db);
			session.setAttribute(Constants.NEWS_LIST_KEY,newsList);
			session.setAttribute(Constants.LOGIN_USERNAME_KEY,username);
  			PageForward = "toAdminMain";
        }
        else {
            errors.add(ActionMessages.GLOBAL_MESSAGE,
                           new ActionMessage("errors.accessDeny"));
			if (!errors.isEmpty()) {
				saveErrors(request, errors);
			} 
 			PageForward="toWrong";  
        }	
		
        db.close();
 	  	return  mapping.findForward(PageForward);  
	}

}