Java

• 동적 Jar loading 프로그램
• 폴더의 파일 열어 작업하기

동적 Jar loading 프로그램

동적 jar 로딩 및 동적 method 호출 

•    1 package com.exec;
     2 
     3 import java.io.File;
     4 import java.io.FileFilter;
     5 import java.io.FilenameFilter;
     6 import java.lang.reflect.InvocationTargetException;
     7 import java.lang.reflect.Method;
     8 import java.net.URL;
     9 import java.net.URLClassLoader;
    10 import java.util.Arrays;
    11 
    12 public class ExecTest {
    13 
    14         public static void main(String[] args) throws NoSuchMethodException, SecurityException, ClassNotFoundException, InstantiationException, IllegalAccessException, IllegalArgumentException, InvocationTargetException {
    15                 
    16                 // 코리안리 EAI customer function 위치 (고정 값)
    17                 String dir = "C:\\eclipse-workspace\\com.exec\\src\\main\\resources\\deployFilder";
    18                 // 코리안리 EAI customer function prefix (고정 값) 
    19                 String jarName = "kr.co.koreanre.eai";
    20                 // 코리안리 EAI customer function Class 명 분류 할 수도 있다. 
    21                 String className = "kr.co.koreanre.eai.execEaiFunctionClass";
    22                 // 코리안리 EAI customer function method 명은 고정 예정 
    23                 String methodName = "execMathod";
    24                 // 코리안리 EAI customer function method에 전달되는 문자열 전달 
    25                 String param = "Call method ,"; 
    26                 
    27                 ExecTest ex = new ExecTest();
    28                 
    29                 
    30                 // kr.co.koreanre.eai-202110280920.jar의 include 여부를 확인, include되어도 최신 버전이 아닌 경우는 false로 return  
    31                 if(!ex.checkLoadedJarList(dir,jarName))
    32                 {
    33                         System.out.println(" > Do not include : " + jarName );
    34                         // 최신 버전으로 include 
    35                         ex.loadJar(dir);
    36                 }               
    37                 
    38                 String returnString = ex.execMethod(className, methodName, param);
    39                 System.out.println(" > Return Value : " + returnString);
    40                 ex.checkLoadedJarList(dir, jarName);
    41         }
    42         
    43         
    44         
    45         
    46         /* =================================================================================== */
    47         
    48         
    49         
    50         
    51         
    52         /**
    53          * kr.co.koreanre.eai-202110280920.jar의 로드 여부를 확인 
    54          * 
    55          * @param jarName
    56          * @return boolean
    57          */
    58         private boolean checkLoadedJarList(String dir, String jarName) {
    59                 System.out.println("\n>> Start Check loaded Jar list " ); 
    60                 boolean includJar = false;
    61                 
    62                 ClassLoader classLoader = ClassLoader.getSystemClassLoader();
    63                 URL[] urls = ((URLClassLoader)classLoader).getURLs();
    64                   
    65         for(URL url: urls){
    66             if( url.getFile().toLowerCase().contains(".jar") ) {
    67                 System.out.println(" > Included Jar : " + url.getFile());
    68                     if(url.getFile().toLowerCase().contains(jarName))
    69                     {
    70                         if(isLoadNewVersionJar(dir, url.getFile()))
    71                         {
    72                                 includJar = true;
    73                         }else {
    74                                 includJar = false;
    75                         }
    76                     }else {
    77                         includJar = false;
    78                     }
    79             }
    80         }
    81         return includJar;
    82         }
    83         
    84         /**
    85          * 디렉토리 안에서 파라메터로 전달한 jar 파일이 최신인지 여부를 판단 
    86          * @param dir 검토 폴더 
    87          * @param jarName 비교 jar 
    88          * @return boolean
    89          */
    90         private boolean isLoadNewVersionJar(String dir, String jarName) {
    91                 boolean isNweVersion = false;
    92 
    93                 File file = new File(dir);
    94                 File[] fileNameList = file.listFiles(new FilenameFilter() {
    95                         public boolean accept(File dir, String name) {
    96                                 return name.endsWith("jar");
    97                         }
    98                 });
    99                  
   100                 if(fileNameList.length==0) {
   101                         throw new NoClassDefFoundError("Koreanre EAI jar not exist ! ");
   102                 }else {
   103                         Arrays.sort(fileNameList);
   104                         String oldVersion = jarName.replace("\\", "/").substring(jarName.replace("\\", "/").lastIndexOf('/') + 1);
   105                         String newVersion = fileNameList[fileNameList.length-1].getPath().replace("\\", "/");
   106                         System.out.println(" > OLD : " + oldVersion );
   107                         System.out.println(" > NEW : " + newVersion.substring(newVersion.lastIndexOf('/') + 1));
   108                         if(oldVersion.equals(newVersion.substring(newVersion.lastIndexOf('/') + 1)))
   109                         {
   110                                 System.out.println(" > is New Version");
   111                                 isNweVersion = true;
   112                         }else {
   113                                 System.out.println(" > is Not New Version");
   114                                 isNweVersion = false;
   115                         }
   116                 }
   117 
   118                 return isNweVersion;
   119         }
   120 
   121         /**
   122          * Method를 실행 
   123          * @param className
   124          * @param methodName
   125          * @param param
   126          * @return
   127          * @throws ClassNotFoundException
   128          * @throws NoSuchMethodException
   129          * @throws SecurityException
   130          * @throws InstantiationException
   131          * @throws IllegalAccessException
   132          * @throws IllegalArgumentException
   133          * @throws InvocationTargetException
   134          */
   135         private String execMethod(String className, String methodName, String param) throws ClassNotFoundException, NoSuchMethodException, SecurityException, InstantiationException, IllegalAccessException, IllegalArgumentException, InvocationTargetException {
   136                 System.out.println("\n>> Start exec method ! " ); 
   137                 
   138                 ClassLoader cl = Thread.currentThread().getContextClassLoader();
   139                 Class<?> clazz = cl.loadClass(className);
   140                 
   141                 Method m = clazz.getMethod(methodName, param.getClass() );
   142             m.setAccessible(true);
   143             
   144             System.out.println(" > Classd Name : " + className);
   145             System.out.println(" > Method Name : " + methodName);
   146             System.out.println(" > Params Value : " + param);
   147             System.out.println(" > Return Type : " + m.getReturnType());
   148             
   149             if (m.getReturnType() != String.class) {
   150                 System.out.println(" > Return type Stirng only : " + m.getReturnType() );
   151                 throw new NoSuchMethodException(methodName);
   152             }
   153 
   154             if (m.getModifiers() == 9) {
   155                 System.out.println(" > Not allowed Static method : " + m.getModifiers() );
   156                 throw new NoSuchMethodException(methodName);
   157             }
   158 
   159             if (m.getModifiers() != 1) {
   160                 System.out.println(" > Public method only : " + m.getModifiers() );
   161                 throw new NoSuchMethodException(methodName);
   162             }
   163            
   164            Object bbb = clazz.newInstance();
   165             String returnMsg = "";
   166         returnMsg = (String)m.invoke(bbb , new Object[] { param });
   167         
   168             return returnMsg;
   169 
   170         }
   171 
   172 
   173         /**
   174          *  해당 디렉토리의 최신 버전의 jar를 적용한다. 
   175          * @param dir
   176          * @throws NoSuchMethodException
   177          * @throws SecurityException
   178          */
   179         private void loadJar(final String dir) throws NoSuchMethodException, SecurityException {
   180                 System.out.println("\n>> LoadJar ");
   181                 final URLClassLoader loader = (URLClassLoader)Thread.currentThread().getContextClassLoader();
   182                 final Method method = URLClassLoader.class.getDeclaredMethod("addURL", new Class[]{URL.class});
   183                 method.setAccessible(true);
   184                 
   185                 new File(dir).listFiles(new FileFilter() {
   186             public boolean accept(File jar) {
   187                 if( jar.toString().toLowerCase().contains(".jar") ){
   188                     try{
   189                         if(isLoadNewVersionJar(dir, jar.toString())) {
   190                                 method.invoke(loader, new Object[]{jar.toURI().toURL()});
   191                                 System.out.println(" > " + jar.toURI() + " is loaded.");
   192                         }
   193                         
   194                     }catch(Exception e){
   195                         System.out.println(jar.toURI() + " can't load.");
   196                     }
   197                 }
   198                                 return false;
   199             }
   200         });
   201         }
   202 
   203 }
  

• 호출을 받는 소스
  줄 번호 보이기/숨기기

     1 package kr.co.koreanre.eai;
     2 
     3 public class execEaiFunctionClass {
     4 
     5         public execEaiFunctionClass() {
     6                 System.out.println(" > Init #1" );
     7         }
     8 
     9         public String execMathod( String obj ) {
    10                 
    11                 String reString = new String();
    12         
    13                 return reString + "= called test1";
    14                 
    15         }
    16 
    17 }
  

• 호출을 받는 곳 pom.xml
  
  

     1 <project xmlns="http://maven.apache.org/POM/4.0.0"
     2         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
     3         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
     4         <modelVersion>4.0.0</modelVersion>
     5         <groupId>kr.co.koreanre.eai</groupId>
     6         <artifactId>kr.co.koreanre.eai</artifactId>
     7         <version>202110280920</version>
     8         <name>Test1</name>
     9 
    10         <build>
    11                 <pluginManagement>
    12                         <plugins>
    13                                 <plugin>
    14                                         <groupId>org.apache.maven.plugins</groupId>
    15                                         <artifactId>maven-resources-plugin</artifactId>
    16                                         <version>2.3</version>
    17                                 </plugin>
    18                                 <plugin>
    19                                         <artifactId>maven-resources-plugin</artifactId>
    20                                         <version>3.0.2</version>
    21                                         <executions>
    22                                                 <execution>
    23                                                         <id>copy-resource-one</id>
    24                                                         <phase>install</phase>
    25                                                         <goals>
    26                                                                 <goal>copy-resources</goal>
    27                                                         </goals>
    28                                                         <configuration>
    29                                                                 <outputDirectory>${basedir}/../com.exec/src/main/resources/deployFilder</outputDirectory>
    30                                                                 <resources>
    31                                                                         <resource>
    32                                                                                 <directory>${basedir}/target</directory>
    33                                                                                 <includes>
    34                                                                                         <include>*.jar</include>
    35                                                                                 </includes>
    36                                                                         </resource>
    37                                                                 </resources>
    38                                                         </configuration>
    39                                                 </execution>
    40                                         </executions>
    41                                 </plugin>
    42                         </plugins>
    43                 </pluginManagement>
    44         </build>
    45 
    46 </project>

폴더의 파일 열어 작업하기

요건 : 

특정 폴더의 파일을 모두 열러서 SQL에 있는 특정 문구로 시작하는 테이블명을 찾는다 

쿼리당 하나 이상일 때는 하나로 카운트한다. 

즉 쿼리하나에 하나의 API를 생성하여 타 도메인에서 현재 도메인의 테이블을 조회하는 것을 배제하여 DBMS를 분리할 수 있도록 한다. 

 Main 프로그램 

package com.det;

import java.io.BufferedReader;
import java.io.File;
import java.io.FileReader;
import java.io.IOException;
import java.nio.file.Files;
import java.nio.file.Paths;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

public class SocParsingWorker {
	
	public static String[] annotation_line = {"--", "//"};
	public static String[][] annotation_range = {
											{	"/*", "*/", "/\\*", "\\*/"		}
											,{	"<!--", "-->", "<!--", "-->"	}
										};
	public static String[][] searchKeyCategoryArry = {
								{ "<select", "</select>" }
								, { "<insert", "</insert>" }
								, { "<update", "</update>" }
								, { "<delete", "</delete>" }
	};
	// 찾는 문자 
	public static String findkeyString = "TB_FILEMANAGER_META";

	public static void main(String[] args) throws IOException {
		// TODO Auto-generated method stub
		System.out.println(" START ");
		String fileName = "";
		List<String> docRemoveAnn = new ArrayList<String>();
		StringRemovAnno stringRemovAnno = new StringRemovAnno();
		SearchString ss = new SearchString();
		Map<String, Integer> resultMapg = new HashMap<String, Integer>();  // SocParsingWorker.searchKeyArry.length
		Map<String, Integer> totalResultMapg = new HashMap<String, Integer>();

		/* 파일 경로에 있는 파일 가져오기 */
		File rw = new File(args[0]);

		/* 파일 경로에 있는 파일 리스트 fileList[] 에 넣기 */
		File[] fileList = rw.listFiles();

		/* fileList에 있는거 for 문 돌려서 출력 */
		for (File file : fileList) {
			if (file.isFile()) {
				fileName = file.getName();
				System.out.println(":::::::::::: PROC FILE NAME : " + fileName + "::::::::::::");
				
				// Remove Annotation 
				// annotation_range
				// annotation_line
				docRemoveAnn = stringRemovAnno.getStringRemovAnno(fileName, file.getPath());
				
				// 주석 제거된 문서 docRemoveAnn를 활용 
				// searchKeyCategoryArry
				resultMapg = ss.getSearchCnt(docRemoveAnn);
				System.out.println(":::::::::::: File="+ fileName +" , Result=" + resultMapg + "::::::::::::\n");
				
				// Total add count by searchKeyCategoryArry
				for (int i = 0; i < SocParsingWorker.searchKeyCategoryArry.length; i++) {
					totalResultMapg.put(SocParsingWorker.searchKeyCategoryArry[i][0].toUpperCase(), 
							toNlltoZero(totalResultMapg.get(SocParsingWorker.searchKeyCategoryArry[i][0].toUpperCase()))
							+toNlltoZero(resultMapg.get(SocParsingWorker.searchKeyCategoryArry[i][0].toUpperCase()))
							);
				}
				
			}
		}
		System.out.println("\n\n\n>>>>>>>>>> All File Find [\""+ findkeyString +"\"] Result=" + totalResultMapg);
	}

	private static int toNlltoZero(Integer integer) {
		if(integer==null) {
			return 0;
		}
		return integer;
	}


}

주석 제거 클래스 

범위 주석과 라인 주석을 제거 

정규표현식으로 작성하다가 루프처리가 어려울 것 같고, /*, */는 했는데 <!-- -->는 안되어서 포기하고 

정규표현식으로는 이하 생략과 이상 생략으로 정규 표현식으로 개발하고 나머지는 조건문으로 처리 

태그가 불완전하면 많이 지워질 듯 함 

package com.det;

import java.io.IOException;
import java.nio.file.Files;
import java.nio.file.Paths;
import java.util.ArrayList;
import java.util.List;

public class StringRemovAnno {

	public List<String> getStringRemovAnno(String filename, String filepath) throws IOException {
		System.out.println(" > fileName Path : " + filepath);
		List<String> fileLineArry = Files.readAllLines(Paths.get(filepath));
		List<String> removedAnnoRangeByte = fileLineArry;

		// 파일을 읽어서 범위의 주석을 삭제
		for (int i = 0; i < SocParsingWorker.annotation_range.length; i++) {
			removedAnnoRangeByte = removedAnnoRangeByte(filename, removedAnnoRangeByte, SocParsingWorker.annotation_range[i]);
		}
		// 라인을 읽어서 라인 주석을 삭제 
		for (int i = 0; i < SocParsingWorker.annotation_line.length; i++) {
			removedAnnoRangeByte = removedAnnoLineByte(filename, removedAnnoRangeByte, SocParsingWorker.annotation_line[i]);
		}
		
		return removedAnnoRangeByte;
	}
	

	/**
	 * 영역 주석 제거 
	 * @param filename
	 * @param fileByte
	 * @return
	 */
	private List<String> removedAnnoRangeByte(String filename, List<String> fileLineArry, String[] annRange) {
		System.out.println("  > Remove Anno Range : " + filename + " [" + annRange[0] + " , " + annRange[1] + "]");
		List<String> removedAnnoRangeByte = new ArrayList<String>();
		
//		System.out.println("   > ORG One Line : " + fileLineArry);
		
		//for ann
		boolean annFlag = false;
	
		for (String oneLine : fileLineArry) {
			int startAnnRag = oneLine.indexOf(annRange[0]);
			int endAnnRag = oneLine.indexOf(annRange[1]);
			
//			System.out.println("   > RED One Line : " + oneLine + " ---------->" + startAnnRag);
			
			// 한줄에 모두 있을 때 
			if(startAnnRag >= 0 && endAnnRag >= 0){
				if(!annFlag) {
					// 사이를 넣어라 
					String ffoneLine = oneLine.substring(0,startAnnRag);
					removedAnnoRangeByte.add(ffoneLine);
					oneLine = oneLine.substring(endAnnRag+annRange[1].length(),oneLine.length());
					removedAnnoRangeByte.add(oneLine);
				}

			// 시작이 있을 때 
			}else if(startAnnRag >= 0) {
				if(oneLine.trim().equals(annRange[0])) {
					// skip ... 이상하네 정규 표현식에서 /* 만 있을 때 /*가 표시됨  
				}else {
					oneLine = oneLine.replaceAll(""+annRange[2]+".*([^*]|[\\r\\n])", "");
					removedAnnoRangeByte.add(oneLine);
//					System.out.println("   > line : " + oneLine + " [" + annRange[0] + " , " + annRange[1] + "] =========> START:" + startAnnRag );
				}
				annFlag = true;
			
			// 끝이 있을 때 
			}else if(endAnnRag >= 0) {
				oneLine = oneLine.replaceAll(".*"+annRange[3]+"*([^*]|[\\r\\n])", "");
				removedAnnoRangeByte.add(oneLine);
//				System.out.println("   > line : " + oneLine + " [" + annRange[0] + " , " + annRange[1] + "] =========> START:" + startAnnRag );
				annFlag = false;
			}
			
			// 둘다 없고 시작이 안되었을 때 
			if(startAnnRag < 0 && endAnnRag < 0){
				if(!annFlag) {
					removedAnnoRangeByte.add(oneLine);
				}
			}
		}
//		System.out.println("   > FLT One Line : " + removedAnnoRangeByte);
		
		//for ann
		return removedAnnoRangeByte;
	}

	/**
	 * LIne 주석 제거 
	 * @param filename
	 * @param removedAnnoRangeByte
	 * @param string
	 * @return
	 */
	private List<String> removedAnnoLineByte(String filename, List<String> fileLineArry, String ann) {
		System.out.println("  > Remove Anno Line : " + filename + " [" + ann + "]");
		List<String> removedAnnoLineByte = new ArrayList<String>();
		for (String oneLine : fileLineArry) {
			int startAnnLine = oneLine.indexOf(ann);
			//System.out.println("..........>>>>>" + oneLine + " , " + startAnnLine);
			if( startAnnLine >= 0 ) {
				oneLine = oneLine.substring(0,startAnnLine);
				removedAnnoLineByte.add(oneLine);
				//System.out.println("   > RED One Line : " + oneLine);
			}else {
				removedAnnoLineByte.add(oneLine);
			}
		}
		return removedAnnoLineByte;
	}

}

문구 찾기 

파일을 하나의 긴 문자열로 만들고, 카타고리로 split 배열로 나누고 , 각 배열 문자열에 카테고리를 닫는 문구까지 잘라서 문자열을 만든다. 

즉 <select로 자르면 다음 <select까지 나누어지기 때문에 </select>가 나오는 곳까지 잘라낸다. 

그리고 검색 문구를 찾는다. 하나이상 나오면 카운트 

package com.det;

import java.util.HashMap;
import java.util.List;
import java.util.Map;

public class SearchString {

	public Map<String, Integer> getSearchCnt(List<String> docRemoveAnn) {
		StringBuffer fileToOneLine = new StringBuffer();
		Map<String, Integer> resultMapg = new HashMap<String, Integer>();
		
		for (String onLineNoAnno : docRemoveAnn) {			
			fileToOneLine.append(onLineNoAnno);
		}
//		System.out.println(fileToOneLine);
		
		// searchKeyArry 로 구분하여 배열로 정의 
		for (int i = 0; i < SocParsingWorker.searchKeyCategoryArry.length; i++) {
//			System.out.println("  >> SEARCH STAR ! key=\"" + SocParsingWorker.searchKeyArry[i][0] +"\" ... \"" + SocParsingWorker.searchKeyArry[i][1] + "\"");
			int searchCnt = 0;
			String[] searchArry = fileToOneLine.toString().toUpperCase().split(SocParsingWorker.searchKeyCategoryArry[i][0].toUpperCase());
			for (int j = 0; j < searchArry.length; j++) {
				String s = searchArry[j];
//	        	System.out.println("   > search : " + s);
	            if(s.indexOf(SocParsingWorker.searchKeyCategoryArry[i][1].toUpperCase()) >= 0) {
	            	System.out.println("  >> Find! (" + j + ")" + SocParsingWorker.searchKeyCategoryArry[i][0].toUpperCase() + "-" + SocParsingWorker.searchKeyCategoryArry[i][1].toUpperCase()
	            			+" " + s.indexOf(SocParsingWorker.searchKeyCategoryArry[i][1].toUpperCase()) + " Col");
	            	s = s.substring(0, s.indexOf(SocParsingWorker.searchKeyCategoryArry[i][1].toUpperCase()));
	            	System.out.println("       \\_ TEXT = \"" + s.substring(0,50) + " ... \"");
	            	if(s.indexOf(SocParsingWorker.findkeyString) >= 0) {
//		            	System.out.println("   >> target String : " + s);
	            		searchCnt++;
	            	}
	            }
	        }
			System.out.println("   >> ::::::::: key=\"" + SocParsingWorker.searchKeyCategoryArry[i][0] +"-" + SocParsingWorker.searchKeyCategoryArry[i][1] + "\" , FIND(\""+SocParsingWorker.findkeyString+"\") Total Cnt = " + searchCnt);  
			resultMapg.put(SocParsingWorker.searchKeyCategoryArry[i][0].toUpperCase(), searchCnt);
		}
			
		return resultMapg;
	}

}

처리 파일 

개발한 프로그램의 metaMapper.xml 파일과 임의 테스트용 파일을 처리함 

metaMapper.xml

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<mapper namespace="com.joang.filemanager.meta.metaMapper">

<!-- ########## ============================================= COMMON START 

============================================= ########## -->

<!-- ### For Paging ### -->

<sql id="pagingHeader">

SELECT A.* FROM (

SELECT row_number() over() AS rownumber, A.* FROM (

</sql>

<sql id="pagingFooter">

) A

) A WHERE A.rownumber BETWEEN #{start} AND #{last}

</sql>

<!-- ### For Paging ### -->

<!-- ########## ============================================= COMMON END 

============================================= ########## -->

<!-- ########## ============================================= Meta List 

Select ============================================= ########## -->

<select id="selectMetaListCnt"

parameterType="com.joang.filemanager.vo.MetaVO" resultType="int">

        <![CDATA[

SELECT COUNT( DISTINCT A.META ) AS total_pages  

FROM TB_FILEMANAGER_META A, TB_FILEMANAGER_META_MAPPING B, TB_FILEMANAGER_META_FILE C, TB_USERS_MAPPING D

WHERE 1=1

            AND A.IDX = B.META_IDX

            AND B.FILE_IDX = C.IDX

            AND C.IDX = D.FILE_IDX

    ]]>

AND D.USERNAME = #{userId}

AND A.DEL_GB = 'N'

AND C.DEL_GB = 'N'

<!-- 전체 -->

<if

test="positiveSearchKey != null and positiveSearchKey.size != 0 ">

<foreach collection="positiveSearchKey" item="item"

open="AND (" close=")" separator="AND">

A.META LIKE CONCAT('%',#{item},'%')

</foreach>

</if>

<if

test="negativeSearchKey != null and negativeSearchKey.size != 0 ">

AND C.IDX NOT IN (

SELECT DISTINCT B.FILE_IDX

FROM TB_FILEMANAGER_META_MAPPING B, TB_FILEMANAGER_META C

WHERE C.IDX = B.META_IDX

<foreach collection="negativeSearchKey" item="item"

open="AND (" close=")" separator="OR">

C.META LIKE CONCAT('%',#{item},'%')

</foreach>

)

</if>

<if

test="andSearchKey != null and andSearchKey.size != 0 ">

AND C.IDX IN (

SELECT DISTINCT B.FILE_IDX

FROM TB_FILEMANAGER_META_MAPPING B, TB_FILEMANAGER_META C

WHERE C.IDX = B.META_IDX

<foreach collection="andSearchKey" item="item"

open="AND (" close=")" separator="OR">

C.META LIKE CONCAT('%',#{item},'%')

</foreach>

)

</if>

</select>

<select id="selectMetaList"

parameterType="com.joang.filemanager.vo.MetaVO"

resultType="com.joang.filemanager.vo.MetaVO">

<include refid="pagingHeader"></include>

        <![CDATA[

            /* com.joang.filemanager.meta.metaMapper.selectMetaList */

            SELECT

A.IDX,

A.META,

A.CREA_DTM,

A.CREA_ID,

COUNT( A.META ) AS COUNT_META

FROM

                TB_FILEMANAGER_META A, TB_FILEMANAGER_META_MAPPING B, TB_FILEMANAGER_META_FILE C, TB_USERS_MAPPING D

            WHERE

                A.DEL_GB = 'N'

                AND C.DEL_GB = 'N'

            AND A.IDX = B.META_IDX

            AND B.FILE_IDX = C.IDX

            AND C.IDX = D.FILE_IDX

]]>

AND D.USERNAME = #{userId}

<!-- 전체 -->

<if

test="positiveSearchKey != null and positiveSearchKey.size != 0 ">

<foreach collection="positiveSearchKey" item="item"

open="AND (" close=")" separator="AND">

A.META LIKE CONCAT('%',#{item},'%')

</foreach>

</if>

<if

test="negativeSearchKey != null and negativeSearchKey.size != 0 ">

AND C.IDX NOT IN (

SELECT DISTINCT B.FILE_IDX

FROM TB_FILEMANAGER_META_MAPPING B, TB_FILEMANAGER_META C

WHERE C.IDX = B.META_IDX

<foreach collection="negativeSearchKey" item="item"

open="AND (" close=")" separator="OR">

C.META LIKE CONCAT('%',#{item},'%')

</foreach>

)

</if>  

    <if

test="andSearchKey != null and andSearchKey.size != 0 ">

AND C.IDX IN (

SELECT DISTINCT B.FILE_IDX

FROM TB_FILEMANAGER_META_MAPPING B, TB_FILEMANAGER_META C

WHERE C.IDX = B.META_IDX

<foreach collection="andSearchKey" item="item"

open="AND (" close=")" separator="OR">

C.META LIKE CONCAT('%',#{item},'%')

</foreach>

)

</if>

        <![CDATA[

            GROUP BY A.IDX,

A.META,

A.CREA_DTM,

A.CREA_ID

            ORDER BY A.IDX DESC

        ]]>

<include refid="pagingFooter"></include>

</select>

<select id="selectMetaAutocomplete"

parameterType="com.joang.filemanager.vo.MetaVO" resultType="map">

        <![CDATA[

            /* com.joang.filemanager.meta.metaMapper.selectMetaAutocomplete */

SELECT 

A.IDX,

A.META,

A.FILE_CNT,

A.TO_CNT,

COUNT(E.FROM_IDX) AS FROM_CNT

FROM(

  SELECT A.IDX,

A.META,

A.FILE_CNT,

COUNT(E.FROM_IDX) AS TO_CNT

  FROM (

            SELECT

A.IDX,

A.META,

COUNT( A.META ) AS FILE_CNT

FROM

                TB_FILEMANAGER_META A, TB_FILEMANAGER_META_MAPPING B, TB_FILEMANAGER_META_FILE C, TB_USERS_MAPPING D

            WHERE

                A.DEL_GB = 'N'

                AND C.DEL_GB = 'N'

            AND A.IDX = B.META_IDX

            AND B.FILE_IDX = C.IDX

            AND C.IDX = D.FILE_IDX

]]>

AND D.USERNAME = #{userId}

AND A.META LIKE '%'|| #{searchKey} || '%'

        <![CDATA[

        GROUP BY A.IDX, A.META

) A

left join TB_FILEMANAGER_META_REF E on  A.IDX = E.FROM_IDX

GROUP BY A.IDX, A.META, A.FILE_CNT, E.FROM_IDX

) A

left join TB_FILEMANAGER_META_REF E on  A.IDX = E.TO_IDX

GROUP BY A.IDX, A.META, A.FILE_CNT, A.TO_CNT, E.TO_IDX

             ORDER BY A.IDX DESC

        ]]>

</select>

<select id="selectUserAutocomplete"

parameterType="com.joang.common.vo.UserVO" resultType="map">

        <![CDATA[

            /* com.joang.filemanager.meta.metaMapper.selectUserAutocomplete */

            SELECT 

tu.username  

, tu.name

FROM tb_users tu 

WHERE 1=1

AND ( tu.name LIKE '%'|| #{username} || '%' OR tu.username  LIKE '%'|| #{username} || '%' )

AND tu.del_gb = 'N'

        ]]>

</select>

<select id="selectRefMetaList"

parameterType="com.joang.filemanager.vo.MetaVO"

resultType="com.joang.filemanager.vo.RefMetaVO">

        <![CDATA[

/* com.joang.filemanager.meta.metaMapper.selectFromRefMetaList */

SELECT A.IDX, A.META, B.FROM_IDX, B.TO_IDX, B.META_REF

FROM TB_FILEMANAGER_META A,

(

SELECT TO_IDX AS IDX, FROM_IDX, B.TO_IDX, B.META_REF

FROM TB_FILEMANAGER_META A, TB_FILEMANAGER_META_REF B, TB_FILEMANAGER_META_FILE C

WHERE

A.DEL_GB = 'N'

AND A.IDX = C.IDX

AND C.DEL_GB = 'N'

]]>

<!-- 전체 -->

<if

test="positiveSearchKey != null and positiveSearchKey.size != 0 ">

<foreach collection="positiveSearchKey" item="item"

open="AND (" close=")" separator="OR">

A.META LIKE CONCAT('%',#{item},'%')

</foreach>

</if>

<if

test="negativeSearchKey != null and negativeSearchKey.size != 0 ">

AND C.IDX NOT IN (

SELECT DISTINCT B.FILE_IDX

FROM TB_FILEMANAGER_META_MAPPING B, TB_FILEMANAGER_META C

WHERE C.IDX = B.META_IDX

<foreach collection="negativeSearchKey" item="item"

open="AND (" close=")" separator="OR">

C.META LIKE CONCAT('%',#{item},'%')

</foreach>

)

</if>

<if

test="andSearchKey != null and andSearchKey.size != 0 ">

AND C.IDX IN (

SELECT DISTINCT B.FILE_IDX

FROM TB_FILEMANAGER_META_MAPPING B, TB_FILEMANAGER_META C

WHERE C.IDX = B.META_IDX

<foreach collection="andSearchKey" item="item"

open="AND (" close=")" separator="OR">

C.META LIKE CONCAT('%',#{item},'%')

</foreach>

)

</if>         

        <![CDATA[

AND A.IDX = B.FROM_IDX

UNION

SELECT FROM_IDX AS IDX, FROM_IDX, B.TO_IDX, B.META_REF

FROM TB_FILEMANAGER_META A, TB_FILEMANAGER_META_REF B, TB_FILEMANAGER_META_FILE C

WHERE

A.DEL_GB = 'N'

AND A.IDX = C.IDX

AND C.DEL_GB = 'N'

]]>

<!-- 전체 -->

<if

test="positiveSearchKey != null and positiveSearchKey.size != 0 ">

<foreach collection="positiveSearchKey" item="item"

open="AND (" close=")" separator="OR">

A.META LIKE CONCAT('%',#{item},'%')

</foreach>

</if>

<if

test="negativeSearchKey != null and negativeSearchKey.size != 0 ">

AND C.IDX NOT IN (

SELECT DISTINCT B.FILE_IDX

FROM TB_FILEMANAGER_META_MAPPING B, TB_FILEMANAGER_META C

WHERE C.IDX = B.META_IDX

<foreach collection="negativeSearchKey" item="item"

open="AND (" close=")" separator="OR">

C.META LIKE CONCAT('%',#{item},'%')

</foreach>

)

</if>

<if

test="andSearchKey != null and andSearchKey.size != 0 ">

AND C.IDX IN (

SELECT DISTINCT B.FILE_IDX

FROM TB_FILEMANAGER_META_MAPPING B, TB_FILEMANAGER_META C

WHERE C.IDX = B.META_IDX

<foreach collection="andSearchKey" item="item"

open="AND (" close=")" separator="OR">

C.META LIKE CONCAT('%',#{item},'%')

</foreach>

)

</if>         

        <![CDATA[

AND A.IDX = B.TO_IDX

) B

WHERE A.IDX = B.IDX

        ]]>

</select>

<select id="selectMetaValueByMetaIdx" parameterType="int"

resultType="string">

SELECT META FROM TB_FILEMANAGER_META

WHERE IDX = #{meta_idx}

</select>

<!-- ########## ============================================= Meta List 

Select ============================================= ########## -->

<!-- ########## ============================================= File List/Detail 

Select ============================================= ########## -->

<select id="selectFileListCnt"

parameterType="com.joang.filemanager.vo.FileVO" resultType="int">

        <![CDATA[

SELECT COUNT( DISTINCT A.IDX ) AS TOTAL_PAGES

]]>

<choose>

<when test="searchKey != null and searchKey != '' ">

FROM TB_FILEMANAGER_META_FILE A, TB_FILEMANAGER_META_MAPPING B,

TB_FILEMANAGER_META C, TB_USERS_MAPPING D

</when>

<otherwise>

FROM

TB_FILEMANAGER_META_FILE A, TB_USERS_MAPPING D

</otherwise>

</choose>

WHERE

A.DEL_GB ='N'

AND A.IDX = D.FILE_IDX

AND D.USERNAME = #{creaId}

<choose>

<when test="searchKey != null and searchKey != '' ">

AND B.FILE_IDX = A.IDX

AND C.IDX = B.META_IDX

</when>

</choose>

<!-- 전체 -->

<if

test="positiveSearchKey != null and positiveSearchKey.size != 0 ">

<foreach collection="positiveSearchKey" item="item"

open="AND (" close=")" separator="OR">

C.META LIKE CONCAT('%',#{item},'%')

</foreach>

</if>

<if

test="negativeSearchKey != null and negativeSearchKey.size != 0 ">

AND A.IDX NOT IN (

SELECT DISTINCT B.FILE_IDX

FROM TB_FILEMANAGER_META_MAPPING B, TB_FILEMANAGER_META C

WHERE C.IDX = B.META_IDX

<foreach collection="negativeSearchKey" item="item"

open="AND (" close=")" separator="OR">

C.META LIKE CONCAT('%',#{item},'%')

</foreach>

)

</if>

<if

test="andSearchKey != null and andSearchKey.size != 0 ">

AND A.IDX IN (

SELECT DISTINCT B.FILE_IDX

FROM TB_FILEMANAGER_META_MAPPING B, TB_FILEMANAGER_META C

WHERE C.IDX = B.META_IDX

<foreach collection="andSearchKey" item="item"

open="AND (" close=")" separator="OR">

C.META LIKE CONCAT('%',#{item},'%')

</foreach>

)

</if>

</select>

<select id="selectFileList"

parameterType="com.joang.filemanager.vo.FileVO"

resultType="com.joang.filemanager.vo.FileVO">

<include refid="pagingHeader"></include>

        <![CDATA[

        /* com.joang.filemanager.meta.metaMapper.selectFileList */

            SELECT

A.IDX, 

E.OPN_CNT,

A.FILE_TITLE, 

A.FILE_TYPE,

SUBSTRING(A.FILE_DETAIL::varchar,0,100) || '...' AS FILE_DETAIL,

A.ORIGINAL_FILE_NAME, 

A.STORED_FILE_NAME, 

A.FILE_SIZE,

A.CREA_DTM, 

A.CREA_ID, 

A.DEL_GB,

A.DOWN_YN,

A.STAR_LEVEL

        ]]>

<choose>

<when test="searchKey != null and searchKey != '' ">

, C.META AS SEARCH_KEY

FROM

TB_FILEMANAGER_META_FILE A, TB_FILEMANAGER_META_MAPPING B, TB_FILEMANAGER_META C, TB_USERS_MAPPING D

</when>

<otherwise>

FROM

TB_FILEMANAGER_META_FILE A, TB_USERS_MAPPING D

</otherwise>

</choose>

, (SELECT COUNT(IDX) AS OPN_CNT, FILE_IDX  FROM TB_USERS_MAPPING TUM GROUP BY FILE_IDX ) E

        <![CDATA[

            WHERE

                A.DEL_GB ='N'

                AND A.IDX = D.FILE_IDX

                AND A.IDX = E.FILE_IDX

        ]]>

AND D.USERNAME = #{creaId}

<choose>

<when test="searchKey != null and searchKey != '' ">

AND B.FILE_IDX = A.IDX

AND C.IDX = B.META_IDX

</when>

</choose>

<!-- 전체 -->

<if

test="positiveSearchKey != null and positiveSearchKey.size != 0 ">

<foreach collection="positiveSearchKey" item="item"

open="AND (" close=")" separator="OR">

C.META LIKE CONCAT('%',#{item},'%')

</foreach>

</if>

<if

test="negativeSearchKey != null and negativeSearchKey.size != 0 ">

AND A.IDX NOT IN (

SELECT DISTINCT B.FILE_IDX

FROM TB_FILEMANAGER_META_MAPPING B, TB_FILEMANAGER_META C

WHERE C.IDX = B.META_IDX

<foreach collection="negativeSearchKey" item="item"

open="AND (" close=")" separator="OR">

C.META LIKE CONCAT('%',#{item},'%')

</foreach>

)

</if>

<if

test="andSearchKey != null and andSearchKey.size != 0 ">

AND A.IDX IN (

SELECT DISTINCT B.FILE_IDX

FROM TB_FILEMANAGER_META_MAPPING B, TB_FILEMANAGER_META C

WHERE C.IDX = B.META_IDX

<foreach collection="andSearchKey" item="item"

open="AND (" close=")" separator="OR">

C.META LIKE CONCAT('%',#{item},'%')

</foreach>

)

</if>

<choose>

<when test="searchKey != null and searchKey != '' ">

<![CDATA[

ORDER BY CONCAT(A.STAR_LEVEL, A.IDX)

]]>

</when>

<otherwise>

        <![CDATA[

ORDER BY A.IDX

        ]]>

</otherwise>

</choose>

<choose>

<when test="orderBy == 'ASC'">

        <![CDATA[

ASC

        ]]>

</when>

<otherwise>

        <![CDATA[

DESC

        ]]>

</otherwise>

</choose>

<include refid="pagingFooter"></include>

</select>

<!-- file detail -->

<select id="selectFileDetail" parameterType="int"

resultType="com.joang.filemanager.vo.FileVO">

        <![CDATA[

        /* com.joang.filemanager.meta.metaMapper.selectFileDetail */

            SELECT 

IDX,

E.OPN_CNT,

FILE_TITLE,

FILE_TYPE,

FILE_DETAIL,

ORIGINAL_FILE_NAME,

STORED_FILE_NAME,

FILE_SIZE,

CREA_DTM,

CREA_ID,

DEL_GB,

DOWN_YN,

ERROR,

STAR_LEVEL

FROM TB_FILEMANAGER_META_FILE, (SELECT COUNT(IDX) AS OPN_CNT, FILE_IDX  FROM TB_USERS_MAPPING TUM GROUP BY FILE_IDX ) E 

WHERE IDX = #{idx}

AND E.FILE_IDX = #{idx}

AND DEL_GB = 'N'

        ]]>

</select>

<select id="selectFileShareUserListByFile" parameterType="int"

resultType="com.joang.filemanager.vo.FileShareUserVO">

        <![CDATA[

            SELECT 

B.USERNAME,

C.NAME,

B.FILE_IDX,

B.CREA_DTM,

B.CREA_ID

FROM TB_FILEMANAGER_META_FILE A, TB_USERS_MAPPING B, TB_USERS C 

WHERE 1=1 

AND A.IDX = #{idx}

AND A.IDX = B.FILE_IDX

AND C.USERNAME = B.USERNAME

        ]]>

</select>

<select id="getTargetMetaIdx" resultType="string">

SELECT COALESCE(MAX(

IDX ), 0) FROM TB_FILEMANAGER_META_FILE

</select>

<!-- ########## ============================================= File List/Detail 

Select ============================================= ########## -->

<!-- ########## ============================================= Meta INSERT/UPDATE 

Select ============================================= ########## -->

<select id="checkMeta" parameterType="String"

resultType="hashmap">

<![CDATA[

            SELECT

idx

FROM

                TB_FILEMANAGER_META

            WHERE

                DEL_GB ='N'

AND TRIM(META) = TRIM(#{meta})

        ]]>

</select>

<insert id="insertMeta" parameterType="hashmap">

    <![CDATA[

        INSERT INTO TB_FILEMANAGER_META

        (

            USER_ID, META, CREA_DTM, CREA_ID, DEL_GB

        )

        VALUES

        (

            #{userId},

            #{meta},

            NOW(),

            #{userId},

            'N'

        )

    ]]>

<selectKey keyProperty="meta_idx" resultType="int"

order="AFTER">

SELECT COALESCE(MAX( IDX ), 0) AS META_IDX FROM TB_FILEMANAGER_META

</selectKey>

</insert>

<insert id="insertMetaMapping" parameterType="hashmap">

<selectKey keyProperty="idx" resultType="int" order="BEFORE">

SELECT COALESCE(MAX( IDX ), 0) FROM TB_FILEMANAGER_META_FILE

</selectKey>

    <![CDATA[

        INSERT INTO TB_FILEMANAGER_META_MAPPING

        (

            USER_ID, META_IDX, FILE_IDX, CREA_DTM, CREA_ID, DEL_GB

        )

        VALUES

        (

            #{userId},

            #{meta_idx}::INTEGER,

    ]]>

<choose>

<when test="file_idx != null">

<!-- 변경되어야할 파일의 file_idx -->

#{file_idx}::INTEGER,

</when>

<otherwise>

<!-- 새 파일 업로드인 경우 idx -->

#{idx}::INTEGER,

</otherwise>

</choose>

    <![CDATA[

            NOW(),

            #{userId},

            'N'

        )

    ]]>

</insert>

<insert id="insertMetaExistMapping" parameterType="hashmap">

    <![CDATA[

        INSERT INTO TB_FILEMANAGER_META_MAPPING

        (

            USER_ID, META_IDX, FILE_IDX, CREA_DTM, CREA_ID, DEL_GB

        )

        VALUES

        (

            #{userId},

            #{meta_idx}::INTEGER,

            #{idx}::INTEGER,

            NOW(),

            #{userId},

            'N'

        )

    ]]>

</insert>

<insert id="insertShareUser" parameterType="com.joang.filemanager.vo.FileShareUserVO">

    <![CDATA[

        INSERT INTO TB_USERS_MAPPING

        (

            USERNAME, FILE_IDX, CREA_DTM, CREA_ID

        )

        VALUES

        (

            #{username},

            #{file_idx}::INTEGER,

            NOW(),

            #{crea_id}

        )

    ]]>

</insert>

<!-- Meta Merge -->

<insert id="updateMergeMetaMapping" parameterType="hashmap">

/*

updateMergeMetaMapping */

UPDATE TB_FILEMANAGER_META_MAPPING SET

META_IDX = #{targetMeta}::INTEGER WHERE META_IDX =

#{sourceMeta}::INTEGER;

</insert>

<insert id="updateMergeMeta" parameterType="hashmap">

UPDATE

TB_FILEMANAGER_META SET

DEL_GB = 'Y' WHERE IDX = #{sourceMeta}::INTEGER;

</insert>

<!-- Delete Meta Detail -->

<insert id="deleteMetaDetail" parameterType="int">

DELETE FROM

TB_FILEMANAGER_META

WHERE IDX = #{meta_idx};

</insert>

<!-- ########## ============================================= Meta INSERT/UPDATE 

Select ============================================= ########## -->

<!-- ########## ============================================= File INSERT/UPDATE 

Select ============================================= ########## -->

<insert id="insertFile" parameterType="hashmap">

     <![CDATA[

        INSERT INTO TB_FILEMANAGER_META_FILE

        (

            FILE_TITLE, 

            FILE_DETAIL,

            ORIGINAL_FILE_NAME,

            STORED_FILE_NAME,

            FILE_SIZE,

            FILE_TYPE,

            CREA_DTM,

            CREA_ID,

            DOWN_YN,

            STAR_LEVEL

        )

        VALUES

        (

            #{file_title},

            #{file_detail},

            #{original_file_name},

            #{stored_file_name},

            #{file_size},

            #{file_type},

            NOW(),

            #{crea_id},

            #{down_yn},

            #{star_level}::INTEGER

        )

    ]]>

</insert>

<insert id="updateFile" parameterType="hashmap">

     <![CDATA[

UPDATE  TB_FILEMANAGER_META_FILE SET  

        ]]>

<if test="file_title != null and file_title != ''">

FILE_TITLE = #{file_title} ,

</if>

<if test="file_type != null and file_type != ''">

FILE_TYPE = #{file_type} ,

</if>

<if test="file_detail != null and file_detail != ''">

FILE_DETAIL = #{file_detail} ,

</if>

<if test="crea_id != null and crea_id != ''">

CREA_ID = #{crea_id} ,

</if>

<if test="star_level != null and star_level != ''">

STAR_LEVEL = #{star_level}::INTEGER ,

</if>

        <![CDATA[

    CREA_DTM = NOW()

WHERE IDX = #{idx}::INTEGER;

    ]]>

</insert>

<delete id="deleteShareUsers" parameterType="int">

     <![CDATA[

DELETE FROM TB_USERS_MAPPING

WHERE FILE_IDX = #{file_idx}

]]>

</delete>

<select id="selectMetaListByFile" parameterType="int"

resultType="com.joang.filemanager.vo.MetaVO">

        <![CDATA[

            SELECT 

A.IDX,

A.USER_ID,

A.META,

A.CREA_DTM,

A.CREA_ID,

A.DEL_GB

FROM TB_FILEMANAGER_META A, TB_FILEMANAGER_META_MAPPING B, TB_FILEMANAGER_META_FILE C

WHERE A.IDX = B.META_IDX

AND B.FILE_IDX = C.IDX

AND C.DEL_GB = 'N'

AND C.IDX = #{idx}

        ]]>

</select>

<!-- update File Detail -->

<insert id="updateFileDetail" parameterType="hashmap">

UPDATE

TB_FILEMANAGER_META_FILE SET

DEL_GB = 'Y' WHERE IDX = #{idx}::INTEGER;

</insert>

<!-- File Mapping update -->

<insert id="updateFileMetaMapping" parameterType="hashmap">

UPDATE

TB_FILEMANAGER_META_MAPPING SET

FILE_IDX = #{targetMeta}::INTEGER WHERE FILE_IDX = #{sourceMeta}::INTEGER;

</insert>

<!-- Delete File detail -->

<delete id="deleteFileDetail" parameterType="int">

<![CDATA[

            DELETE

FROM

                TB_FILEMANAGER_META_FILE

            WHERE

                IDX = #{file_idx}::INTEGER;

        ]]>

</delete>

<update id="updateYouTuBeDownloadYn" parameterType="int">

/*

updateYouTuBeDownloadYn */

UPDATE TB_FILEMANAGER_META_FILE SET

DOWN_YN = 'N'

WHERE

IDX = #{file_idx};

</update>

<!-- ########## ============================================= File INSERT/UPDATE 

Select ============================================= ########## -->

<!-- ########## ============================================= MApping Management 

============================================= ########## -->

<!-- ########## Meta Ref ########## -->

<select id="selectMetaRefList"

parameterType="com.joang.filemanager.vo.MetaRefVO"

resultType="com.joang.filemanager.vo.MetaRefVO">

        <![CDATA[

            SELECT 

A.FROM_IDX,

A.TO_IDX,

A.META_REF,

A.CREA_DTM,

A.CREA_ID

FROM TB_FILEMANAGER_META_REF A, TB_FILEMANAGER_META_MAPPING B, TB_FILEMANAGER_META_FILE C, TB_USERS_MAPPING D

WHERE 1=1

        ]]>

<if test="fromIdx != null and fromIdx != '' and fromIdx != 0">

<![CDATA[

AND A.FROM_IDX = #{fromIdx}

]]>

</if>

<if test="toIdx != null and toIdx != '' and toIdx != 0">

<![CDATA[

AND A.TO_IDX = #{toIdx}

]]>

</if>

        <![CDATA[

            AND A.FROM_IDX = B.META_IDX 

            AND B.FILE_IDX = C.IDX            

AND A.DEL_GB = 'N'

AND C.IDX = D.FILE_IDX

AND D.USERNAME = #{crea_id}

UNION

            SELECT 

A.FROM_IDX,

A.TO_IDX,

A.META_REF,

A.CREA_DTM,

A.CREA_ID

FROM TB_FILEMANAGER_META_REF A, TB_FILEMANAGER_META_MAPPING B, TB_FILEMANAGER_META_FILE C, TB_USERS_MAPPING D

WHERE 1=1

        ]]>

<if test="fromIdx != null and fromIdx != '' and fromIdx != 0">

<![CDATA[

AND A.FROM_IDX = #{fromIdx}

]]>

</if>

<if test="toIdx != null and toIdx != '' and toIdx != 0">

<![CDATA[

AND A.TO_IDX = #{toIdx}

]]>

</if>

        <![CDATA[

            AND A.TO_IDX = B.META_IDX 

            AND B.FILE_IDX = C.IDX            

AND A.DEL_GB = 'N'

AND C.IDX = D.FILE_IDX

AND D.USERNAME = #{crea_id}

        ]]>

</select>

<!-- Check mapping -->

<select id="checkMetaMapping" parameterType="hashmap"

resultType="hashmap">

<![CDATA[

            SELECT

meta_idx

FROM

                TB_FILEMANAGER_META_MAPPING

            WHERE

                DEL_GB ='N'

                AND META_IDX = #{meta_idx}::INTEGER

AND FILE_IDX = #{file_idx}::INTEGER

        ]]>

</select>

<!-- Delete meta mapping -->

<delete id="deleteMetaMapping" parameterType="hashmap">

<![CDATA[

            DELETE

FROM

                TB_FILEMANAGER_META_MAPPING

            WHERE

                META_IDX =#{meta_idx}::INTEGER

AND FILE_IDX = #{file_idx}::INTEGER

        ]]>

</delete>

<select id="selectMappingListByMetaIdx" parameterType="int"

resultType="com.joang.filemanager.vo.MetaVO">

        <![CDATA[

            SELECT 

IDX,

META_IDX,

FILE_IDX

FROM TB_FILEMANAGER_META_MAPPING

WHERE META_IDX = #{idx}

        ]]>

</select>

<!-- Delete Mapping -->

<delete id="deleteMetaMappingByFileIdx" parameterType="int">

<![CDATA[

            DELETE

FROM

                TB_FILEMANAGER_META_MAPPING

            WHERE

                FILE_IDX = #{file_idx}

        ]]>

</delete>

<insert id="insertMetaRef"

parameterType="com.joang.filemanager.vo.MetaRefVO">

<![CDATA[

INSERT INTO TB_FILEMANAGER_META_REF (FROM_IDX, TO_IDX, META_REF, CREA_DTM, CREA_ID, UPDT_DTM, DEL_GB) VALUES

( 

#{fromIdx}, #{toIdx}, #{metaRef}, NOW(), #{creaId}, NOW(), 'N'

)

]]>

</insert>

<insert id="updateMetaRef"

parameterType="com.joang.filemanager.vo.MetaRefVO">

<![CDATA[

UPDATE  TB_FILEMANAGER_META_REF SET  

META_REF =  #{metaRef},

UPDT_DTM = NOW()

WHERE 

FROM_IDX = #{fromIdx}

AND TO_IDX = #{toIdx}

AND CREA_ID = #{crea_id} 

]]>

</insert>

<insert id="deleteMetaRef"

parameterType="com.joang.filemanager.vo.MetaRefVO">

<![CDATA[

DELETE FROM TB_FILEMANAGER_META_REF 

WHERE 

FROM_IDX = #{fromIdx}

AND TO_IDX = #{toIdx}

AND CREA_ID = #{crea_id} 

]]>

</insert>

<update id="updateMergeMetaFromRef" parameterType="hashmap">

/*

updateMergeMetaRef */

UPDATE TB_FILEMANAGER_META_REF SET

FROM_IDX = #{targetFromMeta}::INTEGER

WHERE

FROM_IDX = #{sourceFromMeta}::INTEGER AND TO_IDX = #{sourceToMeta}::INTEGER

AND CREA_ID = #{crea_id}

</update>

<update id="updateMergeMetaToRef" parameterType="hashmap">

/*

updateMergeMetaRef */

UPDATE TB_FILEMANAGER_META_REF SET

TO_IDX = #{targetToMeta}::INTEGER

WHERE

TO_IDX = #{sourceToMeta}::INTEGER AND FROM_IDX = #{sourceFromMeta}::INTEGER

AND CREA_ID = #{crea_id}

</update>

<delete id="daleteMergeMetaRef" parameterType="hashmap">

/*

daleteMergeMetaFromRef */

DELETE

FROM

TB_FILEMANAGER_META_REF

WHERE

FROM_IDX = #{sourceFromMeta}::INTEGER AND TO_IDX = #{sourceToMeta}::INTEGER

AND CREA_ID = #{crea_id}

</delete>

<delete id="deleteMetaMappingFROMRef" parameterType="int">

/*

deleteMetaMappingFROMRef */

DELETE

FROM

TB_FILEMANAGER_META_REF

WHERE

FROM_IDX = #{deleteMeta}

</delete>

<delete id="deleteMetaMappingTORef" parameterType="int">

/*

deleteMetaMappingTORef */

DELETE

FROM

TB_FILEMANAGER_META_REF

WHERE

TO_IDX = #{deleteMeta}

</delete>

<!-- ########## ============================================= Mapping Management 

============================================= ########## -->

</mapper>

test.txt

test1
test2 // hyunsu
hhhh /* hello 0

hello   

mmmm */ lllll

/*
여기 
*/

123456 <!-- test 
    hdewhfd
    wehfiuheri  
   --> dfjrwevniearlivsefh

1234 <!-- hhyubn --> 555555555555
hhhh -- nfejeewfhlwjka

test /* hahahah */
<!-- 
fwef -->
우리 대한민구 만세 // 류재환 
FINE

처리 결과 

처리결과

START

:::::::::::: PROC FILE NAME : metaMapper.xml::::::::::::

> fileName Path : C:\HYUNSU\eclipse-showcase-workspace\SocParsing\parsing\metaMapper.xml

> Remove Anno Range : metaMapper.xml [/* , */]

> Remove Anno Range : metaMapper.xml [<!-- , -->]

> Remove Anno Line : metaMapper.xml [--]

> Remove Anno Line : metaMapper.xml [//]

>> Find! (1)<SELECT-</SELECT> 1415 Col

\_ TEXT = " ID="SELECTMETALISTCNT" PARAMETERTYPE="COM.JOANG. ... "

>> Find! (2)<SELECT-</SELECT> 1760 Col

\_ TEXT = " ID="SELECTMETALIST" PARAMETERTYPE="COM.JOANG.FIL ... "

>> Find! (3)<SELECT-</SELECT> 1199 Col

\_ TEXT = " ID="SELECTMETAAUTOCOMPLETE" PARAMETERTYPE="COM.J ... "

>> Find! (4)<SELECT-</SELECT> 331 Col

\_ TEXT = " ID="SELECTUSERAUTOCOMPLETE" PARAMETERTYPE="COM.J ... "

>> Find! (5)<SELECT-</SELECT> 2723 Col

\_ TEXT = " ID="SELECTREFMETALIST" PARAMETERTYPE="COM.JOANG. ... "

>> Find! (6)<SELECT-</SELECT> 136 Col

\_ TEXT = " ID="SELECTMETAVALUEBYMETAIDX" PARAMETERTYPE="INT" ... "

>> Find! (7)<SELECT-</SELECT> 1610 Col

\_ TEXT = " ID="SELECTFILELISTCNT" PARAMETERTYPE="COM.JOANG. ... "

>> Find! (8)<SELECT-</SELECT> 2618 Col

\_ TEXT = " ID="SELECTFILELIST" PARAMETERTYPE="COM.JOANG.FIL ... "

>> Find! (9)<SELECT-</SELECT> 536 Col

\_ TEXT = " ID="SELECTFILEDETAIL" PARAMETERTYPE="INT" RESULT ... "

>> Find! (10)<SELECT-</SELECT> 384 Col

\_ TEXT = " ID="SELECTFILESHAREUSERLISTBYFILE" PARAMETERTYPE= ... "

>> Find! (11)<SELECT-</SELECT> 107 Col

\_ TEXT = " ID="GETTARGETMETAIDX" RESULTTYPE="STRING"> SELEC ... "

>> Find! (12)<SELECT-</SELECT> 228 Col

\_ TEXT = " ID="CHECKMETA" PARAMETERTYPE="STRING" RESULTTYPE ... "

>> Find! (15)<SELECT-</SELECT> 399 Col

\_ TEXT = " ID="SELECTMETALISTBYFILE" PARAMETERTYPE="INT" RE ... "

>> Find! (16)<SELECT-</SELECT> 1426 Col

\_ TEXT = " ID="SELECTMETAREFLIST" PARAMETERTYPE="COM.JOANG. ... "

>> Find! (17)<SELECT-</SELECT> 305 Col

\_ TEXT = " ID="CHECKMETAMAPPING" PARAMETERTYPE="HASHMAP" RE ... "

>> Find! (18)<SELECT-</SELECT> 241 Col

\_ TEXT = " ID="SELECTMAPPINGLISTBYMETAIDX" PARAMETERTYPE="IN ... "

>> ::::::::: key="<select-</select>" , FIND("TB_FILEMANAGER_META") Total Cnt = 15

>> Find! (1)<INSERT-</INSERT> 453 Col

\_ TEXT = " ID="INSERTMETA" PARAMETERTYPE="HASHMAP"> <![CD ... "

>> Find! (2)<INSERT-</INSERT> 648 Col

\_ TEXT = " ID="INSERTMETAMAPPING" PARAMETERTYPE="HASHMAP"> ... "

>> Find! (3)<INSERT-</INSERT> 375 Col

\_ TEXT = " ID="INSERTMETAEXISTMAPPING" PARAMETERTYPE="HASHMA ... "

>> Find! (4)<INSERT-</INSERT> 332 Col

\_ TEXT = " ID="INSERTSHAREUSER" PARAMETERTYPE="COM.JOANG.FIL ... "

>> Find! (5)<INSERT-</INSERT> 171 Col

\_ TEXT = " ID="UPDATEMERGEMETAMAPPING" PARAMETERTYPE="HASHMA ... "

>> Find! (6)<INSERT-</INSERT> 130 Col

\_ TEXT = " ID="UPDATEMERGEMETA" PARAMETERTYPE="HASHMAP"> UP ... "

>> Find! (7)<INSERT-</INSERT> 104 Col

\_ TEXT = " ID="DELETEMETADETAIL" PARAMETERTYPE="INT"> DELET ... "

>> Find! (8)<INSERT-</INSERT> 659 Col

\_ TEXT = " ID="INSERTFILE" PARAMETERTYPE="HASHMAP"> <![C ... "

>> Find! (9)<INSERT-</INSERT> 635 Col

\_ TEXT = " ID="UPDATEFILE" PARAMETERTYPE="HASHMAP"> <![C ... "

>> Find! (10)<INSERT-</INSERT> 129 Col

\_ TEXT = " ID="UPDATEFILEDETAIL" PARAMETERTYPE="HASHMAP"> U ... "

>> Find! (11)<INSERT-</INSERT> 170 Col

\_ TEXT = " ID="UPDATEFILEMETAMAPPING" PARAMETERTYPE="HASHMAP ... "

>> Find! (12)<INSERT-</INSERT> 270 Col

\_ TEXT = " ID="INSERTMETAREF" PARAMETERTYPE="COM.JOANG.FILE ... "

>> Find! (13)<INSERT-</INSERT> 256 Col

\_ TEXT = " ID="UPDATEMETAREF" PARAMETERTYPE="COM.JOANG.FILE ... "

>> Find! (14)<INSERT-</INSERT> 210 Col

\_ TEXT = " ID="DELETEMETAREF" PARAMETERTYPE="COM.JOANG.FILE ... "

>> ::::::::: key="<insert-</insert>" , FIND("TB_FILEMANAGER_META") Total Cnt = 13

>> Find! (1)<UPDATE-</UPDATE> 130 Col

\_ TEXT = " ID="UPDATEYOUTUBEDOWNLOADYN" PARAMETERTYPE="INT"> ... "

>> Find! (2)<UPDATE-</UPDATE> 239 Col

\_ TEXT = " ID="UPDATEMERGEMETAFROMREF" PARAMETERTYPE="HASHMA ... "

>> Find! (3)<UPDATE-</UPDATE> 233 Col

\_ TEXT = " ID="UPDATEMERGEMETATOREF" PARAMETERTYPE="HASHMAP" ... "

>> ::::::::: key="<update-</update>" , FIND("TB_FILEMANAGER_META") Total Cnt = 3

>> Find! (1)<DELETE-</DELETE> 122 Col

\_ TEXT = " ID="DELETESHAREUSERS" PARAMETERTYPE="INT"> <! ... "

>> Find! (2)<DELETE-</DELETE> 190 Col

\_ TEXT = " ID="DELETEFILEDETAIL" PARAMETERTYPE="INT"> <![CDA ... "

>> Find! (3)<DELETE-</DELETE> 240 Col

\_ TEXT = " ID="DELETEMETAMAPPING" PARAMETERTYPE="HASHMAP"> < ... "

>> Find! (4)<DELETE-</DELETE> 198 Col

\_ TEXT = " ID="DELETEMETAMAPPINGBYFILEIDX" PARAMETERTYPE="IN ... "

>> Find! (5)<DELETE-</DELETE> 199 Col

\_ TEXT = " ID="DALETEMERGEMETAREF" PARAMETERTYPE="HASHMAP"> ... "

>> Find! (6)<DELETE-</DELETE> 124 Col

\_ TEXT = " ID="DELETEMETAMAPPINGFROMREF" PARAMETERTYPE="INT" ... "

>> Find! (7)<DELETE-</DELETE> 120 Col

\_ TEXT = " ID="DELETEMETAMAPPINGTOREF" PARAMETERTYPE="INT"> ... "

>> ::::::::: key="<delete-</delete>" , FIND("TB_FILEMANAGER_META") Total Cnt = 6

:::::::::::: File=metaMapper.xml , Result={<SELECT=15, <DELETE=6, <INSERT=13, <UPDATE=3}::::::::::::

:::::::::::: PROC FILE NAME : test.txt::::::::::::

> fileName Path : C:\HYUNSU\eclipse-showcase-workspace\SocParsing\parsing\test.txt

> Remove Anno Range : test.txt [/* , */]

> Remove Anno Range : test.txt [<!-- , -->]

> Remove Anno Line : test.txt [--]

> Remove Anno Line : test.txt [//]

>> ::::::::: key="<select-</select>" , FIND("TB_FILEMANAGER_META") Total Cnt = 0

>> ::::::::: key="<insert-</insert>" , FIND("TB_FILEMANAGER_META") Total Cnt = 0

>> ::::::::: key="<update-</update>" , FIND("TB_FILEMANAGER_META") Total Cnt = 0

>> ::::::::: key="<delete-</delete>" , FIND("TB_FILEMANAGER_META") Total Cnt = 0

:::::::::::: File=test.txt , Result={<SELECT=0, <DELETE=0, <INSERT=0, <UPDATE=0}::::::::::::

>>>>>>>>>> All File Find ["TB_FILEMANAGER_META"] Result={<SELECT=15, <DELETE=6, <INSERT=13, <UPDATE=3}