package  emptyprj;

import emptyprj.registrationDAO;

import java.lang.reflect.InvocationTargetException;
import java.util.Locale;
import javax.servlet.ServletException;
import javax.servlet.http.HttpSession;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.commons.beanutils.PropertyUtils;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.apache.struts.action.Action;
import org.apache.struts.action.ActionError;
import org.apache.struts.action.ActionErrors;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.action.ActionServlet;
import org.apache.struts.util.ModuleException;
import org.apache.struts.util.MessageResources;
import javawebstudio.struts_db.DbAction;
//import javawebstudio.struts_db.DbMySQLAction;  //如果是MySQL，請(qǐng)用這一句。

import java.io.IOException;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.Collection;
import java.util.Map;
import java.util.HashMap;

//Struts.net支持類
import javawebstudio.struts_db.NetAction;
import javawebstudio.struts_db.NetForm;

//public final class registrationAction extends DbMySQLAction  //如果是MySQL，請(qǐng)用這一句。
public final class registrationAction extends DbAction
{
    // 變量定義：
    private Log log = LogFactory.getLog("org.apache.struts.webapp.Example");
        
    //定義方法find,查找數(shù)據(jù)：
    public ActionForward find(ActionMapping mapping,
				 ActionForm form,
				 HttpServletRequest request,
				 HttpServletResponse response)
	throws Exception 
    {
         // 首先定義屬性和變量以及設(shè)置初值    	
    	  NetForm m_registrationForm = (NetForm) form;
         registrationDAO m_registrationDAO = new registrationDAO();  //定義DAO對(duì)象，用于實(shí)現(xiàn)數(shù)據(jù)庫(kù)的各種操作

      	  String action=request.getParameter("action");  //動(dòng)作類型    		
      	  String search=request.getParameter("search");  //數(shù)據(jù)庫(kù)查找方式
      	  String expression=request.getParameter("expression");    //參數(shù)，這里用于保存記錄（行）的ID數(shù)據(jù)
      		
      	  if(action==null)action="find";
         if(search==null)search="UNsearch";
         if(expression==null)expression="";
         //action=toChinese(action);  //處理中文問(wèn)題,實(shí)現(xiàn)編碼轉(zhuǎn)換，如果是用于MySQL，請(qǐng)加上這之一句
         expression=toChinese(expression);  //處理中文問(wèn)題,實(shí)現(xiàn)編碼轉(zhuǎn)換，如果是用于MySQL，請(qǐng)去掉之一句
      	          	    
      	  ///////////////查找數(shù)據(jù)庫(kù)
      	  //<sqlstr>
      		String sql="SELECT * FROM users";
      		//</sqlstr>

         ////SQL字符處理
      	  if("search".equals(search))
      	  {
      		    //<search>
      		       sql+=" where ID='";
                     if("NULL".equals(expression)||"".equals(expression)) sql+=m_registrationForm .getInt("ID");
      		           else   sql+=expression;      		     
      		       sql+="'";
      		    //</search>
      	  }

         //<分頁(yè)>
     	  m_registrationDAO.setLength(20);//設(shè)置每頁(yè)顯示記錄數(shù)
     	  int ipage;//當(dāng)前頁(yè)
     	  try 
     	  {
     	      String page=request.getParameter("page");//分頁(yè)參數(shù),讀取請(qǐng)求的當(dāng)前頁(yè)
     	      ipage=java.lang.Integer.parseInt(page,10);
     	  }
     	  catch (Exception e) 
         {
             ipage=m_registrationForm.getPage();
         } 
         if(ipage<1)ipage=1;
         Collection col = m_registrationDAO.findSQL(sql,ipage);//通過(guò)DAO對(duì)象查詢數(shù)據(jù)
     	  request.setAttribute("registration",col);  //保存數(shù)據(jù)	
     	 	
     	  String pagestr=m_registrationDAO.getPagestr(ipage);//分頁(yè)字符串，分頁(yè)內(nèi)容
         if(!"search".equals(search))    //查找和全部顯示兩個(gè)不同的操作，其分頁(yè)字符串不同，在此進(jìn)行處理。如果是全部顯示則去掉"search=search&"
      	  {
              pagestr=pagestr.replaceAll("search=search&","");
      	  }
     	  m_registrationForm.set("pagestr",pagestr);   
         m_registrationForm.set("action",action);	 	
     	  request.setAttribute("registrationForm",m_registrationForm);
         //</分頁(yè)>

         m_registrationDAO.Close();
         //轉(zhuǎn)發(fā)到輸出頁(yè)面,return mapping.findForward("success");
         return new ActionForward(mapping.getInput());
   }
    
     //定義方法remove,刪除記錄：
    public ActionForward remove(ActionMapping mapping,
				 ActionForm form,
				 HttpServletRequest request,
				 HttpServletResponse response)
	throws Exception 
    {
	  // 首先定義屬性和變量以及設(shè)置初值
	  NetForm m_registrationForm = (NetForm) form;	
      	  registrationDAO m_registrationDAO = new registrationDAO();  //定義DAO對(duì)象，用于實(shí)現(xiàn)數(shù)據(jù)庫(kù)的各種操作

         String expression=request.getParameter("expression");    //參數(shù)，這里用于保存記錄（行）的ID數(shù)據(jù)
         if(expression==null)expression="";
         expression=toChinese(expression);  //處理中文問(wèn)題,實(shí)現(xiàn)編碼轉(zhuǎn)換
      	
         m_registrationDAO.removeID(expression);      
         m_registrationDAO.Close();	
         ///////////////查找數(shù)據(jù)庫(kù)
         return find( mapping,form,request,response);
   }
    
     //定義方法update,更新記錄：
    public ActionForward update(ActionMapping mapping,
				 ActionForm form,
				 HttpServletRequest request,
				 HttpServletResponse response)
	throws Exception 
    {
    	  // 首先定義屬性和變量以及設(shè)置初值
    	  NetForm m_registrationForm = (NetForm) form;	
         registrationDAO m_registrationDAO = new registrationDAO();  //定義DAO對(duì)象，用于實(shí)現(xiàn)數(shù)據(jù)庫(kù)的各種操作

         String expression=request.getParameter("expression");    //參數(shù)，這里用于保存記錄（行）的ID數(shù)據(jù)
         if(expression==null)expression="";
         expression=toChinese(expression);  //處理中文問(wèn)題,實(shí)現(xiàn)編碼轉(zhuǎn)換
      	 
      	 m_registrationForm.setString("password",MD5.getMD5(m_registrationForm.getString("password")));
      	 
         m_registrationDAO.update(m_registrationForm ,expression);      	     
         m_registrationDAO.Close();	
        ///////////////查找數(shù)據(jù)庫(kù)
        return find( mapping,form,request,response);
   }
    
     //定義方法insert,添加新記錄：
    public ActionForward insert(ActionMapping mapping,
				 ActionForm form,
				 HttpServletRequest request,
				 HttpServletResponse response)
	throws Exception 
    {
         // 首先定義屬性和變量以及設(shè)置初值
    	  NetForm m_registrationForm = (NetForm) form;	
      	  registrationDAO m_registrationDAO = new registrationDAO();  //定義DAO對(duì)象，用于實(shí)現(xiàn)數(shù)據(jù)庫(kù)的各種操作
          m_registrationForm.setString("password",MD5.getMD5(m_registrationForm.getString("password")));
         
         m_registrationForm.setString("role","guest");
         m_registrationDAO.create(m_registrationForm );      	     
         m_registrationDAO.Close(); 	
        ///////////////
        return (mapping.findForward("success"));
   }
}