clwjaction.java

这是一个简单的办公管理系统

//Created by MyEclipse Struts
// XSL source (default): platform:/plugin/com.genuitec.eclipse.cross.easystruts.eclipse_4.1.1/xslt/JavaClass.xsl

package com.yourcompany.struts.action;

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

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

import admin.DataControl;

public class ClwjAction extends Action {

	public ActionForward execute(
		ActionMapping mapping,
		ActionForm form,
		HttpServletRequest request,
		HttpServletResponse response) {
		ActionErrors err = new ActionErrors(); 
		HttpSession session = request.getSession();
		try{
			request.setCharacterEncoding("GBK");
			System.out.println("");
			System.out.println("开始clwjaction");
			String C1 = request.getParameter("C1");
			String id = request.getParameter("id");
			String dept = request.getParameter("dept");
			String time = request.getParameter("time");
			String chuliid = request.getParameter("chuliid");
			String FCKeditor1s[] = request.getParameterValues("FCKeditor1");
			String C2 = request.getParameter("C2");
			String qianzi = request.getParameter("qianzi1");
			System.out.println(qianzi);
			System.out.println(C1);
			System.out.println(C2);
			if(C2 == null){
				C2 = "0";
			}
			if(C2.equals("2")){
				DataControl data = new DataControl();
				String sql = "insert into chuliqianzi(fabuid,dept,timea,qianzi) values("+id+",'"+dept+"','"+time+"','"+qianzi+"')";
				int i = data.getInsert(sql);
				System.out.println(i);
				System.out.println(sql);
				
				DataControl data1 = new DataControl();
				String sql1 = "update fabudept set completed=2 where fabuid="+id+" and dept='"+dept+"'";
				int i1 = data1.getUpdate(sql1);
				System.out.println(i1);
				System.out.println(sql1);
				data.close();
				data1.close();
			}else if(C1.equals("1")){
				System.out.println("0");
				String FCKeditor1 = "";
				for (int x = 0; x < FCKeditor1s.length; x++) {
					FCKeditor1 = FCKeditor1+FCKeditor1s[x];
				}
				System.out.println(FCKeditor1.length());
				if(FCKeditor1.length()>8000){
		   			err.add("err",new ActionMessage("chuli.insert.error","处理内容不得大于8000字"));
					this.saveErrors(request,err);
					return mapping.getInputForward();
				}
				FCKeditor1 = FCKeditor1.replace("'","''");
				System.out.println("titles.length: "+FCKeditor1s.length);
				System.out.println(FCKeditor1);	
				
				DataControl data = new DataControl();		
				String sql = "insert into shenpichuli(content,timea,fabuid,dept,chuliid) values('"+FCKeditor1+"','"+time+"',"+id+",'"+dept+"',"+chuliid+")";
				System.out.println(sql);
				int i = data.getInsert(sql);
				System.out.println(i);
				data.close();
				
				DataControl data1 = new DataControl();
				String sql1 = "update fabudept set completed=0 where fabuid="+id+" and dept='"+dept+"'";
				int i1 = data1.getUpdate(sql1);
				System.out.println(i1);
				System.out.println(sql1);
				data1.close();
			}
			
		}catch(Exception e){
			System.out.println("处理文件失败"+e.getStackTrace());
   			err.add("err",new ActionMessage("chuli.insert.error",e.getStackTrace()));
			this.saveErrors(request,err);
			return mapping.getInputForward();
		}
		session.setAttribute("ok","处理文件成功");
		return mapping.findForward("ok");
	}

}