적자생존

Maven Dependency Plugin을 사용하여 의존성만 복사하기

Maven Dependency Plugin을 사용하면 의존성 JAR 파일만을 특정 폴더로 복사할 수 있습니다.

<!--
			<plugin>
				<groupId>org.apache.maven.plugins</groupId>
				<artifactId>maven-shade-plugin</artifactId>
				<version>3.3.0</version>
				<executions>
					<execution>
						<phase>package</phase>
						<goals>
							<goal>shade</goal>
						</goals>
					</execution>
				</executions>
			</plugin>
			-->

			<!-- libs_export 경로에 의존성jar 별도 복사 -->
			<plugin>
		      <groupId>org.apache.maven.plugins</groupId>
		      <artifactId>maven-dependency-plugin</artifactId>
		      <version>3.3.0</version>
		      <executions>
		        <execution>
		          <id>copy-dependencies</id>
		          <phase>package</phase>
		          <goals>
		            <goal>copy-dependencies</goal>
		          </goals>
		          <configuration>
		            <outputDirectory>${project.build.directory}/libs_export</outputDirectory>
		          </configuration>
		        </execution>
		      </executions>
		    </plugin>

<!-- pom.xml -->
<dependency>
    <groupId>ch.qos.logback</groupId>
    <artifactId>logback-classic</artifactId>
    <version>1.3.14</version>
</dependency>

<dependency>
    <groupId>org.lazyluke</groupId>
    <artifactId>log4jdbc-remix</artifactId>
    <version>0.2.7</version>
</dependency>

<!--
<exclusions>
    <exclusion>
        <groupId>org.slf4j</groupId>
        <artifactId>slf4j-api</artifactId>
    </exclusion>
    <exclusion>
        <groupId>org.apache.logging.log4j</groupId>
        <artifactId>log4j-core</artifactId>
    </exclusion>
    <exclusion>
        <groupId>org.apache.logging.log4j</groupId>
        <artifactId>log4j-slf4j-impl</artifactId>
    </exclusion>
    <exclusion>
        <groupId>egovframework.rte</groupId>
        <artifactId>egovframework.rte.fdl.logging</artifactId>
    </exclusion>
</exclusions>
-->


<!-- logback.xml -->
<?xml version="1.0" encoding="UTF-8"?>
<configuration scan="false" scanPeriod="30 seconds">

	<appender name="console" class="ch.qos.logback.core.ConsoleAppender">
		<encoder class="ch.qos.logback.classic.encoder.PatternLayoutEncoder">
			<pattern>%d{yyyy-MM-dd HH:mm:ss} [%thread] %-5level %logger{36} - %msg\n</pattern>
		</encoder>
	</appender>

	<appender name="console" class="ch.qos.logback.classic.AsyncAppender">
		<discardingThreshold>0</discardingThreshold>
		<queueSize>65536</queueSize>
		<appender-ref ref="console" />
	</appender>
	
	
	<!-- SQL Logger -->
	<logger name="jdbc" 				level="OFF" 	additivity="false"> <appender-ref ref="console" /> </logger>
	<logger name="jdbc.sqlonly" 		level="INFO" 	additivity="false"> <appender-ref ref="console" /> </logger>
	<logger name="jdbc.sqltiming" 		level="INFO" 	additivity="false"> <appender-ref ref="console" /> </logger>
	<logger name="jdbc.audit" 			level="OFF" 	additivity="false"> <appender-ref ref="console" /> </logger>
	<logger name="jdbc.resultset" 		level="OFF" 	additivity="false"> <appender-ref ref="console" /> </logger>
	<logger name="jdbc.resultsettable" 	level="INFO" 	additivity="false"> <appender-ref ref="console" /> </logger>
	<logger name="jdbc.connection" 		level="OFF" 	additivity="false"> <appender-ref ref="console" /> </logger>

	<logger name="java.sql" 			level="INFO" 	additivity="false"> <appender-ref ref="console" /> </logger>
	<logger name="egovframework" 		level="DEBUG" 	additivity="false"> <appender-ref ref="console" /> </logger>
	<logger name="org.springframework" 	level="INFO" 	additivity="false"> <appender-ref ref="console" /> </logger>

	<root level="INFO">
		<appender-ref ref="console" />
	</root>
	

</configuration>



<!-- datasource -->
<!-- cubrid -->
<bean id="dataSource-cubrid-spied" class="org.apache.commons.dbcp2.BasicDataSource" destroy-method="close">
    <property name="driverClassName" value="${Globals.DriverClassName}"/>
    <property name="url" value="${Globals.Url}" />
    <property name="username" value="${Globals.UserName}"/>
    <property name="password" value="${Globals.Password}"/>
</bean>

<bean id="dataSource-cubrid" class="net.sf.log4jdbc.Log4jdbcProxyDataSource">
    <constructor-arg ref="dataSource-cubrid-spied" />
    <property name="logFormatter">
        <bean class="net.sf.log4jdbc.tools.Log4JdbcCustomFormatter">
            <property name="loggingType" value="MULTI_LINE" />
            <property name="sqlPrefix" value="SQL::::      " />
        </bean>
    </property>
</bean>

@GetMapping(value="/proxy.do")
    public void mapViewProxy(HttpServletRequest request, HttpServletResponse response, @RequestParam String p) {

        String queryString = request.getQueryString();
        String param = queryString.substring(2, queryString.length());

        response.setHeader("Pragma", "no-cache");
        response.setDateHeader("Expires", 0);
        response.setHeader("Cache-Control", "no-store");
        //request.setCharacterEncoding("utf-8");

        HttpClient client = new HttpClient();
        GetMethod method = new GetMethod(param);
        //PostMethod method = new PostMethod(param);
        String contentType = request.getContentType();
        //method.setRequestBody(xml);
        method.setRequestHeader("Content-type", contentType);
        //method.setRequestBody(request.getInputStream());

        String result = null;
        try {
            int statusCode = client.executeMethod(method);
            result = method.getResponseBodyAsString();
            System.out.println(result);
            System.out.println(statusCode);

            response.reset();
            response.setStatus(statusCode);

            response.setContentType("text/xml; charset=utf-8"); //외부 사이트의 결과를 프록시의 응답결과로 전송


            PrintWriter out = response.getWriter();
            response.setContentType("application/json");
            response.setCharacterEncoding("UTF-8");
            out.print(result);
            out.flush();


        } catch (IOException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
    }

package com.example.demo;

import java.util.regex.Matcher;
import java.util.regex.Pattern;

import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestParam;

@Controller
public class GreetingController {
	
	/**
	 * script 삭제 
	 * @param oldText
	 * @return
	 */
	private String removeScriptXSS(String oldText) {
		String regex = "<script(?:[^>]*src=['\"]([^'\"]*)['\"][^>]*>|[^>]*>([^<]*)</script>)";
	    Pattern pattern = Pattern.compile(regex, Pattern.CASE_INSENSITIVE | Pattern.DOTALL);
		StringBuffer sb = new StringBuffer();
		Matcher matcher = pattern.matcher(oldText);
        while (matcher.find()) {
        	matcher.appendReplacement(sb, "");
        }
        matcher.appendTail(sb);
        return sb.toString();
	}

	@GetMapping("/greeting.do")
	public String greeting(@RequestParam(name="name", required=false, defaultValue="World") String name, Model model) {
		
		String cont = "<div class=\"skin_view\">\n"
				+ "								<h2 id=\"dkBody\" class=\"screen_out\">티스토리 뷰</h2>\n"
				+ "								<div class=\"area_title\">\n"
				+ "									<strong class=\"tit_category\"><a href=\"/category/Programming/JSP\">Programming/JSP</a></strong>\n"
				+ "			<Script type=\"text/javaScript\">alert(1111111);</scripT>"
				+ "									<h3 class=\"tit_post\"><a href=\"/26\">[JSP]JSP 프로젝트 생성 및 설정</a></h3>\n"
				+ "									<span class=\"txt_detail my_post\">heyhyo\n"
				+ "			<Script type=\"application/javascript\">alert(444444);"
				+ "      alert('7777777777');"
				+ "                   </scripT>"
				+ "										<span class=\"txt_bar\"></span>2018. 8. 7. 15:32\n"
				+ "										\n"
				+ "			<Script>alert(222222);</scripT>"
				+ "									</span>\n"
				+ "								</div>\n"
				+ "								<div class=\"area_view\">"
				+ "</div></div>";
		
		model.addAttribute("name", removeScriptXSS(cont));
		
		return "greeting";
	}

}

<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi-ooxml</artifactId>
    <version>4.1.2</version>
</dependency>  

@RequestMapping("/excel")
public void excel(HttpServletRequest request, HttpServletResponse response) throws UnsupportedEncodingException {

	String fileName = "test_excel.xlsx";

	// 여기서부터는 각 브라우저에 따른 파일이름 인코딩작업
	String browser = request.getHeader("User-Agent");
	if (browser.indexOf("MSIE") > -1) {
		fileName = URLEncoder.encode(fileName, "UTF-8").replaceAll("\\+", "%20");
	} else if (browser.indexOf("Trident") > -1) { // IE11
		fileName = URLEncoder.encode(fileName, "UTF-8").replaceAll("\\+", "%20");
	} else if (browser.indexOf("Firefox") > -1) {
		fileName = "\"" + new String(fileName.getBytes("UTF-8"), "8859_1") + "\"";
	} else if (browser.indexOf("Opera") > -1) {
		fileName = "\"" + new String(fileName.getBytes("UTF-8"), "8859_1") + "\"";
	} else if (browser.indexOf("Chrome") > -1) {
		StringBuffer sb = new StringBuffer();
		for (int i = 0; i < fileName.length(); i++) {
			char c = fileName.charAt(i);
			if (c > '~') {
				sb.append(URLEncoder.encode("" + c, "UTF-8"));
			} else {
				sb.append(c);
			}
		}
		fileName = sb.toString();
	} else if (browser.indexOf("Safari") > -1) {
		fileName = "\"" + new String(fileName.getBytes("UTF-8"), "8859_1") + "\"";
	} else {
		fileName = "\"" + new String(fileName.getBytes("UTF-8"), "8859_1") + "\"";
	}

	response.setContentType("application/download;charset=utf-8");
	response.setHeader("Content-Disposition", "attachment; filename=\"" + fileName + "\";");
	response.setHeader("Content-Transfer-Encoding", "binary");

	OutputStream os = null;
	SXSSFWorkbook wb = null;
	Sheet sheet = null;

	try {
		wb = new SXSSFWorkbook();

		sheet = wb.createSheet("test");

		Row row = sheet.createRow(0);
		Cell cell = null;
		cell = row.createCell(0);
		cell.setCellValue("a");
		cell = row.createCell(1);
		cell.setCellValue("b");
		cell = row.createCell(2);
		cell.setCellValue("c");

		os = response.getOutputStream();

		// 파일생성
		wb.write(os);
	} catch (Exception e) {
		e.printStackTrace();
	} finally {
		if (wb != null) {
			try {
				wb.close();
			} catch (Exception e) {
				e.printStackTrace();
			}
		}

		if (os != null) {
			try {
				os.close();
			} catch (Exception e) {
				e.printStackTrace();
			}
		}
	}
}

JAVA File to byte[]

private static byte[] loadFile(File file) throws IOException {

    InputStream is = new FileInputStream(file);

    long length = file.length();

    if (length > Integer.MAX_VALUE) {

        // File is too large

    }

    byte[] bytes = new byte[(int)length];

    int offset = 0;

    int numRead = 0;

    while (offset < bytes.length

           && (numRead=is.read(bytes, offset, bytes.length-offset)) >= 0) {

        offset += numRead;

    }

    if (offset < bytes.length) {

        throw new IOException("Could not completely read file "+file.getName());

    }

    is.close();

    return bytes;

}