doaction.java

笔者试图用最简单易懂的增删改查功能将Struts、ibatis和FastM的综合使用呈现给初学者。

package src.com.ligx.ibatis;
import java.io.Reader;
import java.util.*;
import java.util.Enumeration;

import com.ibatis.common.resources.*;
import com.ibatis.sqlmap.client.*;


import src.com.ligx.config.User;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.Action;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.action.ActionForm;

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

public class DoAction extends Action{
	public ActionForward execute(ActionMapping mapping,ActionForm form,
			HttpServletRequest request,HttpServletResponse response)
	{
		System.out.println("Be run in DoAction");
		ActionForward forward = new ActionForward();
		
		DoForm tForm = (DoForm)form;
		Integer id = tForm.getId();
		String idStr = id.toString();
		String name= tForm.getName();
		Integer sex = tForm.getSex();
		
		System.out.println("in form"+id);
		System.out.println("in form"+name);
		System.out.println("in form"+sex);
	
		User user = new User();
		user.setId(id);
		user.setName(name);
		user.setSex(sex);
		
		/*
		if(id != new Integer(0))
		{
			user.setId(id);
		}
		if(name != null && !name.equalsIgnoreCase(""))
		{
			user.setName(name);
		}
		if(sex != new Integer(0))
		{
			user.setSex(sex);
		}
		*/
		
		Map map = new HashMap();
		if(id != new Integer(0))
		{
			map.put("id",id);
		}
		if(name != null && !name.equalsIgnoreCase(""))
		{
			map.put("name",name);
		}
		if(sex != new Integer(0))
		{
			map.put("sex",sex);
		}
		
		try
		{
			String resource = "src/com/ligx/config/sql-map-config.xml";
			Reader reader = Resources.getResourceAsReader(resource);
			SqlMapClient sqlmap = SqlMapClientBuilder.buildSqlMapClient(reader);

			Enumeration  a = request.getParameterNames();
			for(;a.hasMoreElements();)
			{	
				String temp = a.nextElement().toString();
				if(temp.equalsIgnoreCase("addForm"))
				{
					sqlmap.insert("insertUser",map);
					forward = mapping.findForward("success");
				}else if(temp.equalsIgnoreCase("deleteForm"))
				{
					sqlmap.delete("deleteUser",idStr);
					forward = mapping.findForward("success");
				}else if(temp.equalsIgnoreCase("updateForm"))
				{
					sqlmap.update("updateUser",user);
					forward = mapping.findForward("success");
				}else if(temp.equalsIgnoreCase("selectForm"))
				{	
					try{
					//List list = new ArrayList();
					//list = sqlmap.queryForList("selectUser",user);
					//request.setAttribute("result",list);
					map  = sqlmap.queryForMap("selectUser",map,"id","name");
					request.setAttribute("resultMap",map);
					Object obj = request.getAttribute("resultMap");
					map = (Map)obj;
					System.out.println("in map"+map.get("id"));
					System.out.println("in map"+map.get("name"));
					System.out.println("in map"+map.get("sex"));
					
					/*
					for(int i = 0;i<list.size();i++)
					{
						user1 = (User)list.get(i);
						System.out.println("sc = "+user1.getId());
						System.out.println("sc = "+user1.getName());
						System.out.println("sc = "+user1.getSex());
					}
					*/
					
					}catch(Exception e)
					{
						System.out.println(e.toString());
					}
				
					forward = mapping.findForward("success");
				}
			
			}
			
		}
		catch(Exception e)
		{
			System.out.println("In Action failed reasion : :["+e.toString()+"]");
			forward = mapping.findForward("failed");
		}
		
	return forward;
	}

}