dealaction.java

笔者试图用最简单易懂的数据库增删改等操作将Struts和ibatis综合使用呈现给初学者。

package com.ligx;
import java.io.Reader;

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 com.ibatis.common.resources.Resources;
import com.ibatis.sample.User;
import com.ibatis.sqlmap.client.SqlMapClient;
import com.ibatis.sqlmap.client.SqlMapClientBuilder;
//import java.sql.*;

public class DealAction extends Action{
	//public static void main(String[] args){
		
		public ActionForward execute(ActionMapping mapping,ActionForm form,HttpServletRequest request,HttpServletResponse respose){
			ActionForward forward = new ActionForward();
			DealForm tForm = (DealForm)form;
			Integer strID = tForm.getId();
			String strName = tForm.getName();
			Integer strSex = tForm.getSex();
			try{
			String resource ="com/ibatis/sample/SqlMapConfig.xml";
			Reader reader;		
			reader = Resources.getResourceAsReader(resource);
			SqlMapClient sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader);
			System.out.println("to be run in DealAction");
			User user = new User();
			
			user.setId(strID);
			user.setName(strName);
			user.setSex(strSex);
			
			//user.setId(new Integer(1));
			//user.setName("ligx");
			//user.setSex(new Integer(1));
			System.out.println("id["+strID + "]:name["+strName+"]:sex[" +strSex+"]");
			System.out.println("front of update");
		
			sqlMap.update("updateUser",user);
			
			System.out.println("after of update");
			forward = mapping.findForward("success");
			}
			catch(Exception e){
				System.out.println(e.toString());
			}
			return forward;
			}
		//}
}