loginaction.java

java 有关struts方面的一些入门操作。建立一个配置文件

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



import java.util.List;
import java.util.Map;

import javax.naming.*;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.sql.DataSource;

import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.MapListHandler;
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.first.struts.form.LoginForm;

public class LoginAction extends Action {
	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		try
		{
		LoginForm loginForm = (LoginForm) form;
		Context context=new InitialContext();
		DataSource ds=(DataSource)context.lookup("java:/comp/env/jdbc/mysql");
		QueryRunner qr=new QueryRunner(ds);		
	//System.out.println(loginForm.getPassword());
	//System.out.println(loginForm.getUsername());
		String username=loginForm.getUsername();
		String password=loginForm.getPassword();
		String sql2="Select * from user where username='"+username+"' and password='"+password+"'";
		List results=(List)qr.query(sql2, new MapListHandler());
		
		String sql=" SELECT * FROM T_FUNCS where funtp='1' and uflag='1' ORDER BY funtp,grpid" ;
		String sql1=" SELECT count(*), funtp,grpid FROM T_FUNCS where funtp='1' and uflag='1'  Group By funtp,grpid ORDER BY funtp,grpid ";
		List results1=(List)qr.query(sql, new MapListHandler());
		List results2=(List)qr.query(sql1, new MapListHandler());
		Map map=null;
		Map map1=null;
		for(int i=0;i<results1.size();i++)
		{
			map=(Map)results1.get(i);
			System.out.println(map.get("grpid"));
			if(i+1<results1.size())
			{
			map1=(Map)results1.get(i+1);
			System.out.println(map1.get("grpid"));
			}
			
			//System.out.println(results1.get(i));
		}
			
			//request.setAttribute("name", request.getParameter("username"));
			//System.out.println(request.getParameter("username"));
			//String p=mapping.findForward("insert").getPath();
			//System.out.println(p);
			//ActionForward forward= new ActionForward(p+"?pageId=1");
			 // forward.setRedirect(true);
			//实现传值
			//return forward;
			//实现action之间的传值
			 //return new ActionForward("/insert.jsp?tt="+loginForm.getUsername());
			
			return mapping.findForward("insert");	

		}
		catch(Exception ex)
		{
			ex.printStackTrace();
		}	
		return mapping.findForward("error");	
	}
}