1
 2
 3
 4
 5
 6
 7
 8
 9
10
11

<!-- AOP 관련 -->
<dependency>
	<groupid>org.aspectj</groupid>
	<artifactid>aspectjweaver</artifactid>
	<version>1.7.4</version>
</dependency>
<dependency>
	<groupid>cglib</groupid>
	<artifactid>cglib</artifactid>
	<version>2.2.2</version>
</dependency>

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49

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

import org.aspectj.lang.ProceedingJoinPoint;
import org.aspectj.lang.annotation.Around;
import org.aspectj.lang.annotation.Aspect;
import org.aspectj.lang.annotation.Pointcut;
import org.springframework.web.servlet.ModelAndView;

@Aspect
public class AdminAspect {	
	@Pointcut("bean(adminController) || bean(adminStudentController)")
	public void adminOperation(){}	

	@Around("adminOperation()")
	public Object aroundAnyAdminOperation(ProceedingJoinPoint joinPoint) throws Throwable {
		HttpServletRequest req = null;
		for (Object obj : joinPoint.getArgs()) {
			if (obj instanceof HttpServletRequest) {
				req = (HttpServletRequest) obj;
			}
		}
		
		String connUri = req.getRequestURI();
		System.out.println(connUri);
		
		boolean isPass = false;
		boolean isLogined = false;
		HttpSession session = req.getSession();		
		String adminLogined = (String)session.getAttribute("adminLogined");
		
		if(adminLogined != null || !adminLogined.equals("")){			
			isLogined = true;		
		}else if(connUri.startsWith("/login")){
			isPass = true;
		}
		
		if(!isLogined || !isPass){
			ModelAndView mav = new ModelAndView("/admin_login");
			session.setAttribute("error", "관리자 로그인 후 이용 가능합니다.");
			
			return mav;
		}else{
			Object result = joinPoint.proceed();
			
			return result;
		}		
	}
}

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13

<!-- ppt -->
<dependency>
	<groupid>org.apache.poi</groupid>
	<artifactid>poi-scratchpad</artifactid>
	<version>3.10-FINAL</version>
</dependency>

<!-- iText pdf -->
<dependency>
	<groupid>com.itextpdf</groupid>
	<artifactid>itextpdf</artifactid>
	<version>5.5.2</version>
</dependency>

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99

import java.awt.Color;
import java.awt.Dimension;
import java.awt.Graphics2D;
import java.awt.geom.Rectangle2D;
import java.awt.image.BufferedImage;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.IOException;
import java.util.UUID;

import javax.imageio.ImageIO;

import org.apache.poi.hslf.model.Slide;
import org.apache.poi.hslf.usermodel.SlideShow;

import com.itextpdf.text.Document;
import com.itextpdf.text.DocumentException;
import com.itextpdf.text.Image;
import com.itextpdf.text.pdf.PdfWriter;

public class PPTtoPDFConverter {
	String realFolder = FileManager.realFolder;
	private String pdfFileName;
	
	public PPTtoPDFConverter(){
	}
	
	public PPTtoPDFConverter(String fileName){
		try {
			setPdfFileName(this.convert(fileName));
		} catch (IOException | DocumentException e) {
			e.printStackTrace();
		}
	}
	
	private void setPdfFileName(String pdfFileName) {
		this.pdfFileName = pdfFileName;		
	}
	
	public String getPdfFileName() {
		return pdfFileName;
	}

	private String convert(String fileName) throws IOException, DocumentException{
		//1.Read PPT file
		FileInputStream fis = new FileInputStream(realFolder + fileName);
		SlideShow ppt = new SlideShow(fis);
		
		fis.close();
		
		//2.Draw Image
		Dimension pageSize = ppt.getPageSize();
		Slide[] slide = ppt.getSlides();

		for(int i=0; i<slide.length; i++){
			BufferedImage image = new BufferedImage(pageSize.width, pageSize.height, BufferedImage.TYPE_INT_RGB);
			
			Graphics2D graphics = image.createGraphics();
			graphics.setPaint(Color.white); //이미지 영역을 클리어
			graphics.fill(new Rectangle2D.Float(0, 0, pageSize.width, pageSize.height));
			
			slide[i].draw(graphics);
			
			File dir = new File(realFolder + "tempImg/");
		    if (!dir.isDirectory()) {
		      dir.mkdirs();
		    }
		    
		    FileOutputStream fos = new FileOutputStream(dir + "temp" + (i+1) + ".png");
		    ImageIO.write(image, "png", fos);
		}
		
		//3.Image To PDF
		Document document = new Document();
		File dir = new File(realFolder + "portfolioPDF/");
		if (!dir.isDirectory()) {
			dir.mkdirs();
		}
	    
		String pdfFileName = "portfolioPDF/" + UUID.randomUUID().toString();
		PdfWriter.getInstance(document, new FileOutputStream(realFolder + pdfFileName));
		document.open();
		
		for(int i=1; i&lt;=slide.length; i++){
			String imagePath = realFolder + "tempImg/temp" + i + ".png";
			Image image = Image.getInstance(imagePath);
			document.add(image);
			
			//4.Delete Image
		    File file = new File(imagePath);
		    file.delete();
		}
		
		document.close();
		
		return pdfFileName;
	}	
}

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44

import java.security.MessageDigest;
import java.security.NoSuchAlgorithmException;

public class CEncrypt {
	MessageDigest md;
	String strSRCData = "";
	String strENCData = "";

	public CEncrypt() {
	}

	public CEncrypt(String EncMthd, String strData) {
		this.encrypt(EncMthd, strData);
	}

	public void encrypt(String EncMthd, String strData) {
		try {
			MessageDigest md = MessageDigest.getInstance(EncMthd); // "MD5" or "SHA1"
			byte[] bytData = strData.getBytes();
			md.update(bytData);
			byte[] digest = md.digest();
			for (int i = 0; i < digest.length; i++) {
				strENCData = strENCData	+ Integer.toHexString(digest[i] & 0xFF).toUpperCase();
			}
		} catch (NoSuchAlgorithmException e) {
		};

		strSRCData = strData;
	}

	public String getEncryptData() {
		return strENCData;
	}

	public String getSourceData() {
		return strSRCData;
	}

	public boolean equal(String strData) {
			if (strData == strENCData)
			return true;
		return false;
	}
}

1
2

CEncrypt enc = new CEncrypt("SHA1", adminPass);
String PW = enc.getEncryptData();

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11

<!--MyBatis -->
<dependency>
	<groupid>org.mybatis</groupid>
	<artifactid>mybatis</artifactid>
	<version>3.2.5</version>
</dependency>
<dependency>
	<groupid>org.mybatis</groupid>
	<artifactid>mybatis-spring</artifactid>
	<version>1.2.2</version>
</dependency>

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25

<!--?xml version="1.0" encoding="UTF-8"?-->
<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd">

<configuration>
	<settings>
		<setting name="cacheEnabled" value="true"></setting>
		<setting name="lazyLoadingEnabled" value="false"></setting>
		<setting name="multipleResultSetsEnabled" value="true"></setting>
		<setting name="useColumnLabel" value="true"></setting>
		<setting name="useGeneratedKeys" value="false"></setting>
		<setting name="defaultExecutorType" value="SIMPLE"></setting>
		<setting name="defaultStatementTimeout" value="25000"></setting>
		<!-- 전통적인 데이터베이스 컬럼명 형태인 A_COLUMN을 CamelCase형태의 자바 프로퍼티명 형태인 aColumn으로 자동으로 매핑하도록 함 -->
		<setting name="mapUnderscoreToCamelCase" value="false"></setting>
		<setting value="VARCHAR" name="jdbcTypeForNull"></setting>
	</settings>

	<typealiases>		
		<typealias alias="resumeComment" type="com.miram.portal1.client.vo.ResumeCommentVO"></typealias>	
	</typealiases>

	<mappers>		
		<mapper resource="mybatis/home.xml"></mapper>
	</mappers>
</configuration>

 1
 2
 3
 4
 5
 6
 7
 8
 9
10

<!--?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.miram.portal1.admin.dao.AdminDAO">
	<select id="getAdmin" parametertype="String" resulttype="admin">
		SELECT *
		FROM MEM_ADMIN
		WHERE ADMIN_ID = #{admin_id}
	</select>
</mapper>

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14

<bean id="HomeDAO" class="org.mybatis.spring.mapper.MapperFactoryBean">
	<property name="mapperInterface" value="com.miram.portal1.client.dao.HomeDAO"/>
	<property name="sqlSessionFactory" ref="sqlSessionFactory"/>
	<property name="sqlSessionTemplate" ref="sqlSessionTemplate"/>
</bean>

<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
	<property name="dataSource" ref="dataSource"/>
	<property name="configLocation" value="classpath:/mybatis/MapperConfig.xml"/>
</bean>

<bean id="sqlSessionTemplate" class="org.mybatis.spring.SqlSessionTemplate">
	<constructor-arg ref="sqlSessionFactory"/>
</bean>