<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%> <%@ page import="java.util.*"%> <%@ page import="java.io.*"%> <%@ page import="com.oreilly.servlet.MultipartRequest" %> <%@ page import="com.oreilly.servlet.multipart.DefaultFileRenamePolicy" %> <%@ include file="/field_manager/include/manager_head.jsp"%> <%request.setCharacterEncoding("utf-8");%> <% String fileName = ""; String realFolder = ""; String saveFolder = "/upload/board"; String encType = "utf-8"; int maxSize = 10 * 1024 * 1024; ServletContext scontext = getServletContext(); ArrayList saveFiles = new ArrayList(); ArrayList orgFiles = new ArrayList(); realFolder = scontext.getRealPath(saveFolder); realFolder = "/home/apply/upload/yangsik"; MultipartRequest multi = new MultipartRequest( request , realFolder , maxSize , encType , new DefaultFileRenamePolicy() ); Enumeration files = multi.getFileNames(); int t1 = 0; String[] a_file = new String[50]; int olp = 31; while( files.hasMoreElements() ){ olp = olp - 1; String name = (String)files.nextElement(); int rtp = Integer.parseInt(name.replaceAll("f_","").replaceAll("_4_2","")); String fName = multi.getFilesystemName( name ); String oName = multi.getOriginalFileName( name ); String type = multi.getContentType( name ); File f = multi.getFile( name ); if(fName != null && !fName.equals("")){ t1 = t1 + 1; if(t1 > 1){ fileName = fileName + "|"; } fileName = fileName + fName; a_file[rtp] = fName; }else{ a_file[rtp] = ""; } } if(fileName == null){ fileName = ""; } String c_home = r_call(multi.getParameter("c_home")); String c_maker = r_call(multi.getParameter("c_maker")); String c_project_no = r_call(multi.getParameter("c_project_no")); int fix_field_no = Integer.parseInt(r_call(multi.getParameter("fix_field_no"))); int field_no = Integer.parseInt(r_call(multi.getParameter("field_no"))); String sql_ok = "delete from tbl_apply_field where c_home = " + c_home + " and c_maker = " + c_maker + " and c_project_no = " + c_project_no; stmt2.execute(sql_ok); int c_order = 0; for (int i = 1; i < field_no + 1 ; i++){ if( r_call(multi.getParameter("f_" + i + "_1")).equals("0")){ c_order = c_order + 1; sql_ok = "insert into tbl_apply_field (c_home,c_maker,c_project_no,c_relation,c_use_field,c_name,c_type,c_content,c_order,c_use,c_date) values("; sql_ok = sql_ok + c_home + "," + c_maker + "," + c_project_no + "," + i; sql_ok = sql_ok + ", '" + r_call(multi.getParameter("f_"+i+"_5")) + "' "; sql_ok = sql_ok + ", '" + r_call(multi.getParameter("f_"+i+"_2")) + "' "; sql_ok = sql_ok + ", " + r_call(multi.getParameter("f_"+i+"_3")) + " "; if(r_call(multi.getParameter("f_"+i+"_3")).equals("2")){ sql_ok = sql_ok + ", '" + r_call(multi.getParameter("f_"+i+"_4")) + "' "; } if(r_call(multi.getParameter("f_"+i+"_3")).equals("1") || r_call(multi.getParameter("f_"+i+"_3")).equals("3")){ sql_ok = sql_ok + ", '' "; } if(r_call(multi.getParameter("f_"+i+"_3")).equals("4")){ if(!a_file[i].equals("")){ sql_ok = sql_ok + ", '" + a_file[i] + "' "; }else{ sql_ok = sql_ok + ", '" + r_call(multi.getParameter("o_"+i+"_4_2")) + "' "; } } sql_ok = sql_ok + ", " + c_order + ",0,now())"; stmt2.execute(sql_ok); %> <% } } %> <%@ include file="/field_manager/include/manager_bottom.jsp"%>