2014년 12월 2일 화요일

C#으로 구현한 하위 폴더에서 특정 확장자의 파일 갯수를 카운트하는 프로그램.

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.IO;
using System.Windows.Forms;

namespace FileCounter
{
    public partial class FileCounter : Form
    {
        private int counter = 0;

        public FileCounter()
        {
            InitializeComponent();
        }

        private void label1_Click(object sender, EventArgs e)
        {

        }

        private void txtFolderPath_TextChanged(object sender, EventArgs e)
        {

        }

        private void btnOpenFolderDlg_Click(object sender, EventArgs e)
        {
            FolderBrowserDialog folderBrowserDialog = new FolderBrowserDialog();
            folderBrowserDialog.SelectedPath = @"C\";

            if (folderBrowserDialog.ShowDialog() == DialogResult.OK)
            {
                txtFolderPath.Text = folderBrowserDialog.SelectedPath;
            }
        }

        private void btnFileCount_Click(object sender, EventArgs e)
        {
            //파일을 찾아야 폴더 선택 여부 확인
            if (txtFolderPath.Text == "" || txtFolderPath.Text.Length < 1)
            {
                MessageBox.Show("대상 폴더를 선택하세요. !!");
                return;
            }

            //찾아야 할 파일 확장자 입력 여부 확인
            if (txtFileExt.Text == "" || txtFileExt.Text.Length < 1)
            {
                MessageBox.Show("파일 확장자를 입력하세요. !!");
                return;
            }

            lbCount.Text = "";
            counter = 0;

            //Root폴더 아래의 파일 검색
            RootSearchFileExtCounter(txtFolderPath.Text, txtFileExt.Text);
            //하위 폴더 아래의 파일 검색
            DirSearchFileExtCounter(txtFolderPath.Text, txtFileExt.Text);
           
            lbCount.Text = "" + counter;          
        }

        private void btnCancel_Click(object sender, EventArgs e)
        {
            //종료
            this.Close();
        }

        //Root폴더 아래의 파일을 검색
        void RootSearchFileExtCounter(string sDir, string sExt)
        {
            //입력된 파일 확장자에서 순수한 확장자만 추출
            string strExt = sExt;
            if (sExt.IndexOf("*") > -1) strExt = strExt.Replace("*", "");
            if (sExt.IndexOf(".") > -1) strExt = strExt.Replace(".", "");

            //검색을 위한 패턴 생성
            string searchPattern = "*." + strExt;

            string[] rootFileEntries = Directory.GetFiles(sDir, searchPattern);
            foreach (string rootFileName in rootFileEntries)
            {
                //순수 확장자가 파일명의 끝에 있는지 체크해서 카운트.
                if (rootFileName.EndsWith(strExt))
                {
                    counter = counter + 1;
                }
            }
        }

        void DirSearchFileExtCounter(string sDir, string sExt)
        {
            string strExt = sExt;
            if (sExt.IndexOf("*") > -1) strExt = strExt.Replace("*", "");          
            if (sExt.IndexOf(".") > -1) strExt = strExt.Replace(".", "");          

            string searchPattern = "*." + strExt;

            try
            {              
                //Root폴더 아래의 하위 폴더 갯수 만큼 Looping
                foreach (string d in Directory.GetDirectories(sDir))
                {
                    //searchPattern에 맞는 파일 목록을 가져온다.
                    string[] searchFileEntries = Directory.GetFiles(d, searchPattern);
                    //가져온 파일 목록만큼 Looping
                    foreach (string sFileName in searchFileEntries)
                    {
                        //순수 확장자가 파일명의 끝에 있는지 체크해서 카운트.
                        if (sFileName.EndsWith(strExt))
                        {
                            counter = counter + 1;
                        }
                    }
                    //하위 폴더 검색을 위한 재귀호출
                    DirSearchFileExtCounter(d, searchPattern);
                }
            }
            catch (System.Exception excpt)
            {
                Console.WriteLine(excpt.Message);
            }          
        }
    }
}

2014년 9월 11일 목요일

Full Calendar 사용법 예시.
좀 더 기능을 추가해서 완성도 높은 소스를 제공할 예정이다.

<!DOCTYPE html>
<html>
<title>Full Calendar Example</title>
<head>
<meta charset='utf-8' />
<link rel="stylesheet" href="http://code.jquery.com/ui/1.11.1/themes/smoothness/jquery-ui.css">
<link href='../css/fullcalendar.css' rel='stylesheet' />
<link href='../css/fullcalendar.print.css' rel='stylesheet' media='print' />
<style>
    label, input { display:block; }
    input.text { margin-bottom:12px; width:95%; padding: .4em; }
    fieldset { padding:0; border:0; margin-top:10px; }
    textarea { width:95%; overflow:visible;}
    h1 { font-size: 1.2em; margin: .6em 0; }
    div#users-contain { width: 350px; margin: 20px 0; }
    div#users-contain table { margin: 1em 0; border-collapse: collapse; width: 100%; }
    div#users-contain table td, div#users-contain table th { border: 1px solid #eee; padding: .6em 10px; text-align: left; }
    .ui-dialog .ui-state-error { padding: .3em; }
    .validateTips { border: 1px solid transparent; padding: 0.3em; }
</style>
 
<script src='../js/moment.min.js'></script>
<script src='../js/jquery.min.js'></script>
<script src='http://code.jquery.com/ui/1.11.1/jquery-ui.js'></script>
<script src='../js/fullcalendar.min.js'></script>
<script src='../js/lang-all.js'></script>
<script>
var dialog, form;
var timeList = ["00:00", "00:30", "01:00", "01:30", "02:00", "02:30", "03:00", "03:30", "04:00", "04:30",
"05:00", "05:30", "06:00", "06:30", "07:00", "07:30", "08:00", "08:30", "09:00", "09:30",
"10:00", "10:30", "11:00", "11:30", "12:00", "12:30", "13:00", "13:30", "14:00", "14:30",
"15:00", "15:30", "16:00", "16:30", "17:00", "17:30", "18:00", "18:30", "19:00", "19:30",
"20:00", "20:30", "21:00", "21:30", "22:00", "22:30", "23:00", "23:30"];
var currentDate = moment().format('YYYY-MM-DD');
var currentTime = moment().format('HH:mm');

function setOptionsTimeList(selectName, endHourIndc) {
var checkMinute = currentTime.substring(3);
var checkHour = currentTime.substring(0,2);
var strHour = checkHour;
var strMinute = "00";

//현재 시간보다 30분 빠르게 시간을 설정.
if (checkMinute < 30) {
strMinute = "30";
} else {
strHour = Number(strHour) + 1;
if (strHour < 10) {
strHour = "0" + strHour;
}
}

//시작시간 보다 1시간 늦게 설정.
if (endHourIndc) {
strHour = Number(strHour) + 1;

if (strHour < 10) {
strHour = "0" + strHour;
}
}

//시간 선택 select 박스에서 트겆시간을 선택.
$.each(timeList, function(key, val) {
var str = "";
if (val == (strHour + ":" + strMinute)) {
str = "<option value=" + val + " selected='selected'>" + val + "</option>";
} else {
str = "<option value=" + val + ">" + val + "</option>";
}
$(selectName).append(str);
});
}

function saveSchedule() {
alert('saveSchedule Function');
dialog.dialog("close");
}

function setDatePicker(datepicker) {
$(datepicker).datepicker({
  dateFormat:'yy.mm.dd', //선택된 날짜 포맷(yyyy.mm.dd)
  monthNamesShort: ['1월','2월', '3월', '4월', '5월', '6월', '7월', '8월', '9월', '10월', '11월', '12월'],
  monthNames: ['1월','2월', '3월', '4월', '5월', '6월', '7월', '8월', '9월', '10월', '11월', '12월'],
  dayNamesMin: ['일', '월', '화', '수', '목', '금', '토'],  
  dayNamesShot: ['일', '월', '화', '수', '목', '금', '토'],
  dayNames: ['일요일', '월요일', '화요일', '수요일', '목요일', '금요일', '토요일'],
  firstDay: 1, //0: 일요일 부터 시작, 1:월요일 부터 시작
  autoSize: true, //default: false, input 사이즈를 자동으로 리사이즈.
  showAnim: "fold", //default: show
  showButtonPanel: true, //하단에 Today, Done 버튼 Display
  showWeek: true, //주차 보이기
  weekHeader: "주차", //default: Wk, 주차 헤드 부분의 명칭 설정
  changeMonth: true, //월 변경가능
  changeYear: true, //년 변경가능
  showMonthAfterYear: true, //년 뒤에 월 표시
  gotoCurrent: true //default: false, true일 경우에는 Today버튼 클릭 시 현재 일자로 이동하지 못함. false는 가능.
  });
}

//날짜와 시간 선택 부분을 초기화. 모두 선택 가능하도록...
function initialDateTime() {
$('#startDate').removeAttr('disabled');
    $('#endDate').removeAttr('disabled');
    $('#startTime').removeAttr('disabled');
    $('#endTime').removeAttr('disabled');
}

$(document).ready(function() {
var currentLangCode = 'ko';
var schedule = new Array();

// build the language selector's options
$.each($.fullCalendar.langs, function(langCode) {
$('#lang-selector').append(
$('<option/>')
.attr('value', langCode)
.prop('selected', langCode == currentLangCode)
.text(langCode)
);
});

// rerender the calendar when the selected option changes
$('#lang-selector').on('change', function() {
if (this.value) {
currentLangCode = this.value;
$('#calendar').fullCalendar('destroy');
renderCalendar();
}
});

dialog = $('#dialog-form').dialog({
autoOpen: false,
height: 400,
width: 450,
modal: true,
buttons: {
"Save": saveSchedule,
Cancel: function() {
dialog.dialog("close");
}
},
close: function() {
form[0].reset();
//allFields.removeClass("ui-state-error");
}
});

form = dialog.find( "form" ).on( "submit", function( event ) {
      event.preventDefault();
      saveSchedule();
    });
   
    //check box 클릭 이벤트  등록
    $('#allDay').click(function(){
    var chk = $(this).is(":checked");

    if (chk) {
    $('#startDate').attr('disabled', 'disabled');
    $('#endDate').attr('disabled', 'disabled');
    $('#startTime').attr('disabled', 'disabled');
    $('#endTime').attr('disabled', 'disabled');
    } else {
    $('#startDate').removeAttr('disabled');
    $('#endDate').removeAttr('disabled');
    $('#startTime').removeAttr('disabled');
    $('#endTime').removeAttr('disabled');
    }
    });
   
    setDatePicker('#startDate');
    setDatePicker('#endDate');
    setOptionsTimeList('#startTime', false);
    setOptionsTimeList('#endTime', true);
   
function renderCalendar() {
$('#calendar').fullCalendar({
header: {
//left: 'prevYear,prev,next,nextYear today',
left: 'prev,next today',
center: 'title',
right: 'month,agendaWeek,agendaDay'
},
defaultDate: currentDate,
lang: currentLangCode,
buttonIcons: false, // show the prev/next text
weekNumbers: true,
editable: true,
eventLimit: true, // allow 'more" link when too many events
dayClick: function(date, jsEvent, view) {
//alert('Clicked on: ' + date.format());
//alert('Coordinates: ' + jsEvent.pageX + ',' + jsEvent.pageY);
//alert('Current view: ' + view.name);
dialog.dialog("open");
initialDateTime();
}
});
}
   
renderCalendar();
});


</script>
<style>

body {
margin: 0;
padding: 0;
font-family: "Lucida Grande",Helvetica,Arial,Verdana,sans-serif;
font-size: 14px;
}

#top {
background: #eee;
border-bottom: 1px solid #ddd;
padding: 0 10px;
line-height: 40px;
font-size: 12px;
}

#calendar {
max-width: 900px;
margin: 40px auto;
padding: 0 10px;
}

</style>
</head>
<body>

<div id='top'>

Language:
<select id='lang-selector'> </select>

</div>
 
<div id="dialog-form" title="Create new schedule">
<form>
   <fieldset>
   <label for="title">Title</label>
   <input type="text" name="title" id="title" class="text ui-widget-content ui-corner-all">
   <label for="allDay">하루 종일</label>
   <input type="checkbox" id="allDay">
   <table>
    <tr>
    <td>  
    <label for="startDate">Start Date</label>
    </td>
    <td>
    <input type="text" name="startDate" id="startDate">
    </td>    
    <td>    
    <label for="startTime">Start Time</label>
    </td>
    <td>
<select id="startTime"></select>
</td>
</tr>
<tr>
<td>
   <label for="endDate">End Date</label>
</td>
<td>
   <input type="text" name="endDate" id="endDate">
</td>
<td>  
<label for="endDate">End Time</label>
</td>
<td>
<select id="endTime"></select>
</td>
</tr>
</table>
<label for="comments">Comments</label>
<textarea id="comments" name="comments"></textarea>
   <!-- Allow form submission with keyboard without duplicating the dialog button -->
   <input type="submit" tabindex="-1" style="position:absolute; top:-1000px">
   </fieldset>
  </form>
</div>

<div id='calendar'> </div>
</body>
</html>

2014년 8월 25일 월요일

jQuery의 datepicker를 이용해서 날짜를 선택할 수 있는 편리한 기능이다.
모양은 투박하지만 jQuery를 이용할 경우, 보다 편리하게 달력을 이용해서 일자를 선택할 수 있다.

<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8" />
<title>jQuery UI Datepicker - Default functionality</title>
<link rel="stylesheet" href="http://code.jquery.com/ui/1.11.1/themes/smoothness/jquery-ui.css" />
<style>
.ui-datepicker{ font-size: 12px; width: 200px; }
.ui-datepicker select.ui-datepicker-month{ width:30%; font-size: 11px; }
.ui-datepicker select.ui-datepicker-year{ width:40%; font-size: 11px; }
</style>
<script src="http://code.jquery.com/jquery-1.11.1.js"></script>
<script src="http://code.jquery.com/ui/1.11.1/jquery-ui.js"></script>
<link rel="stylesheet" href="/resources/demos/style.css" />
<script>
 $(function() {
  $("#datepicker").datepicker({
  dateFormat:'yy.mm.dd', //선택된 날짜 포맷(yyyy.mm.dd)
  monthNamesShort: ['1월','2월', '3월', '4월', '5월', '6월', '7월', '8월', '9월', '10월', '11월', '12월'],
  monthNames: ['1월','2월', '3월', '4월', '5월', '6월', '7월', '8월', '9월', '10월', '11월', '12월'],
  dayNamesMin: ['일', '월', '화', '수', '목', '금', '토'],  
  dayNamesShot: ['일', '월', '화', '수', '목', '금', '토'],
  dayNames: ['일요일', '월요일', '화요일', '수요일', '목요일', '금요일', '토요일'],
  firstDay: 1, //0: 일요일 부터 시작, 1:월요일 부터 시작
  autoSize: true, //default: false, input 사이즈를 자동으로 리사이즈.
  showAnim: "fold", //default: show
  showButtonPanel: true, //하단에 Today, Done 버튼 Display
  showWeek: false, //주차 보이기
  weekHeader: "주차", //default: Wk, 주차 헤드 부분의 명칭 설정
  changeMonth: true, //월 변경가능
  changeYear: true, //년 변경가능
  showMonthAfterYear: true, //년 뒤에 월 표시
  gotoCurrent: false //default: false, true일 경우에는 Today버튼 클릭 시 현재 일자로 이동하지 못함. false는 가능.
  });
 });

 function getDate() {
  alert($("#datepicker").datepicker("getDate"));
 }
</script>
</head>
<body>
 <p>
  Date: <input type="text" id="datepicker" /> <input type="button" id="btnDate" value="가져오기" onclick="getDate()" />
 </p>
</body>
</html>

2014년 7월 23일 수요일

Javascript에서 callback함수를 이용해서 form의 특정 Object에 대한 validation 확인 후 특정 메시지를 alert창으로 알려준 뒤에 해당 Object에 포커싱을 두는 예제.

<!DOCTYPE html>
<html lang="ko">
<head>
<meta charset="utf-8">

<!-- Always force latest IE rendering engine (even in intranet) & Chrome Frame
Remove this if you use the .htaccess -->
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">

<title>callback_sample_01</title>

<meta name="viewport" content="width=device-width; initial-scale=1.0">

<!-- Replace favicon.ico & apple-touch-icon.png in the root of your domain and delete these references -->
<link rel="shortcut icon" href="/favicon.ico">
<link rel="apple-touch-icon" href="/apple-touch-icon.png">
<script type="text/javascript">
var each = function(arr, callback) {
      for(i = 0; i < arr.length; i++) {
          callback.prototype = arr[i];
          new callback(i);
      }
     
      document.getElementById('txtName').focus();
};

onload=function() {
    var test = [ { name : 'a' }, { name : 'b' }, { name : 'c' } ];

      each(test, function(index) {
          alert(index + " = " + this.name);
      });
};
</script>
</head>

<body>
<div>
<header>
<h1>callback_sample_01</h1>
</header>
<nav>
<p>
<a href="/">Home</a>
</p>
<p>
<a href="/contact">Contact</a>
<input type="text" id="txtName" name="name"/>
</p>
</nav>

<div>

</div>

<footer>
<p>
&copy; Copyright  by
</p>
</footer>
</div>
</body>
</html>

2014년 7월 8일 화요일

Spring Framework & MyBatis 3 설정

applicationContext.xml
-------------------------------------------------------------
<?xml version="1.0" encoding="UTF-8"?>
<beans:beans xmlns="http://www.springframework.org/schema/mvc"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:beans="http://www.springframework.org/schema/beans"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:mvc="http://www.springframework.org/schema/mvc"
xsi:schemaLocation="http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc.xsd
http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd
http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc.xsd">

<!-- Handles HTTP GET requests for /resources/** by efficiently serving up static resources in the ${webappRoot}/resources directory -->
<resources mapping="/resources/**" location="/resources/" />

<!-- Resolves views selected for rendering by @Controllers to .jsp resources in the /WEB-INF/views directory -->
<beans:bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<beans:property name="prefix" value="/WEB-INF/views/" />
<beans:property name="suffix" value=".jsp" />
</beans:bean>

<beans:bean id="multipartResolver" class="org.springframework.web.multipart.commons.CommonsMultipartResolver">
    <beans:property name="maxUploadSize">
        <beans:value>20000000</beans:value>
    </beans:property>
    <beans:property name="uploadTempDir" ref="uploadDirResource" />
</beans:bean>

<beans:bean id="uploadDirResource" class="org.springframework.core.io.FileSystemResource">
    <beans:constructor-arg>
        <beans:value>D:/Temp/fileUpload/</beans:value>
    </beans:constructor-arg>
</beans:bean>
</beans:beans>


rootContext.xml
-------------------------------------------------------------
<beans:beans xmlns="http://www.springframework.org/schema/mvc"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:beans="http://www.springframework.org/schema/beans"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:mvc="http://www.springframework.org/schema/mvc"
xsi:schemaLocation="http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc.xsd
http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd
http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc.xsd">
<!-- Root Context: defines shared resources visible to all other web components -->
<!-- Enables the Spring MVC @Controller programming model -->
<mvc:annotation-driven />
<mvc:default-servlet-handler />
   
    <mvc:interceptors>
<mvc:interceptor>
<mvc:mapping path="/*"/> 
<beans:bean id="checkInterceptor" class="com.test.LogonInterceptor"/> 
</mvc:interceptor>
</mvc:interceptors>
<context:component-scan base-package="com.test" />
<beans:bean class="org.springframework.web.servlet.mvc.annotation.DefaultAnnotationHandlerMapping">
    <beans:property name="alwaysUseFullPath" value="true"/>
</beans:bean>
<beans:bean class="org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter">
   <beans:property name="alwaysUseFullPath" value="true"/>
</beans:bean>

</beans:beans>


commonContext.xml
-------------------------------------------------------------
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:p="http://www.springframework.org/schema/p"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://www.springframework.org/schema/beans
      http://www.springframework.org/schema/beans/spring-beans-3.1.xsd">
       
<!-- ========================= Properties DEFINITIONS =============================== -->
<bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
<property name="locations">
<list>
<value>classpath:/application.properties</value>
</list>
</property>
</bean>  
<!-- ========================= RESOURCE DEFINITIONS =============================== -->
<bean id="messageSource" class="org.springframework.context.support.ResourceBundleMessageSource">
<property name="basenames">
<list>
<value>messages</value>
</list>
</property>
</bean>

<bean id="messageSourceAccessor" class="org.springframework.context.support.MessageSourceAccessor">
<constructor-arg>
<ref local="messageSource" />
</constructor-arg>
</bean> 
</beans>


databaseContext.xml
---------------------------------------------------------------
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:p="http://www.springframework.org/schema/p"
xmlns:aop="http://www.springframework.org/schema/aop"
xmlns:tx="http://www.springframework.org/schema/tx"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.springframework.org/schema/beans   
       http://www.springframework.org/schema/beans/spring-beans.xsd
       http://www.springframework.org/schema/aop
       http://www.springframework.org/schema/aop/spring-aop.xsd
       http://www.springframework.org/schema/tx
       http://www.springframework.org/schema/tx/spring-tx.xsd
       http://www.springframework.org/schema/context 
       http://www.springframework.org/schema/context/spring-context.xsd">

<!-- bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean">
<property name="jndiName">
<value>jdbc.xxxPool</value>
</property>
</bean-->
<context:component-scan base-package="com.test.service">
<context:include-filter type="annotation" expression="org.springframework.stereotype.Service" />
<context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
</context:component-scan>
<bean id="dataSource"
class="org.apache.commons.dbcp.BasicDataSource"
p:driverClassName="${database.driver}"
p:url="${database.url}"
p:username="${database.username}" p:password="${database.password}" />

<!-- transaction manager, use JtaTransactionManager for global tx -->
<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource" />
</bean>
<!-- enable component scanning (beware that this does not enable mapper scanning!) -->    
    <context:component-scan base-package="com.test.service" /> 
<!-- enable autowire -->
    <context:annotation-config />
     
<!-- enable transaction demarcation with annotations -->
    <tx:annotation-driven transaction-manager="transactionManager" proxy-target-class="true" />
    <!-- define the SqlSessionFactory -->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource" />
<property name="typeAliasesPackage" value="com.test.domain" />
<!-- property name="configLocation" value="springbook/learningtest/spring/mybatis/mybatis-config.xml" /-->
<!-- property name="mapperLocations" value="classpath:sqlmap/*-sqlmap.xml" /-->
</bean>
<!-- scan for mappers and let them be autowired -->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="basePackage" value="com.test.persistence" />
    </bean>
<!--
<bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate">
<constructor-arg index="0" ref="sqlSessionFactory" />
</bean>
-->
</beans>

2014년 6월 24일 화요일

UNIX에서 하위 폴더의 JSP파일을 touch 하고자 할 경우,
find . -name '*.jsp' -exec touch {} \;

UNIX에서 하위 폴더 전부를 touch 하고자 할 경우,
find . -exec touch {} \;
또는
find . -print | xargs touch


2014년 6월 2일 월요일

파일 업로드를 위한 Spring 설정
<bean id="multipartResolver"
class="org.springframework.web.multipart.commons.CommonsMultipartResolver">
<property name="maxUploadSize"> <value>50000000</value> </property>
</bean>

<!-- file upload controller 셋팅 -->
<bean id="uploadControl" class="com.disc.gwp.control.FileUploadControl">
<property name="destinationDir" value="/groupware/attach/gwp/tempUpload" />
<property name="fileService" ref="fileService" />
<property name="boardService" ref="boardService" />
</bean>


파일 업로드 Controller 소스.

package com.linuxwan.control;

import jada.common.util.StringUtil;

import java.io.File;
import java.io.FileOutputStream;
import java.util.ArrayList;
import java.util.StringTokenizer;

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

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.springframework.util.FileCopyUtils;
import org.springframework.validation.BindException;
import org.springframework.web.bind.ServletRequestDataBinder;
import org.springframework.web.multipart.MultipartFile;
import org.springframework.web.multipart.MultipartHttpServletRequest;
import org.springframework.web.multipart.support.ByteArrayMultipartFileEditor;
import org.springframework.web.servlet.ModelAndView;
import org.springframework.web.servlet.mvc.AbstractCommandController;
import org.springframework.web.util.WebUtils;

import com.linuxwan.ibatis.domain.Ca002m;
import com.linuxwan.ibatis.domain.Ca002t;
import com.linuxwan.ibatis.domain.Ca002tExample;
import com.linuxwan.service.BoardService;
import com.linuxwan.service.FileService;
import com.linuxwan.session.UserSession;
import com.linuxwan.util.GenSequenceNo;

/**
 * @author
 */
public class FileUploadControl extends AbstractCommandController {
private static Log logger = LogFactory.getLog(FileUploadControl.class);
private FileService fileService = null;
private BoardService boardService = null;
private String destinationDir;

public FileUploadControl() {
setCommandClass(Ca002t.class);
}

/**
* 파일업로드를 위한 빈 설정의 property
* destinationDir setter injection
* @param destinationDir
*/
public void setDestinationDir(String destinationDir) {
this.destinationDir = destinationDir;
}

/**
* FileService setter Injection
* @param fileService
*/
public void setFileService(FileService fileService) {
this.fileService = fileService;
}

public FileService getFileService() {
return this.fileService;
}

public void setBoardService(BoardService boardService) {
this.boardService = boardService;
}

public BoardService getBoardService() {
return this.boardService;
}

protected void initBinder(HttpServletRequest request, ServletRequestDataBinder binder)
throws ServletException {
binder.registerCustomEditor(byte[].class, new ByteArrayMultipartFileEditor());
}

/* (non-Javadoc)
* @see org.springframework.web.servlet.mvc.AbstractCommandController#handle(javax.servlet.http.HttpServletRequest, javax.servlet.http.HttpServletResponse, java.lang.Object, org.springframework.validation.BindException)
*/
@Override
protected ModelAndView handle(HttpServletRequest request, HttpServletResponse response,
Object command, BindException errors)
throws Exception {
// TODO Auto-generated method stub
ModelAndView mav = new ModelAndView("common/file_search_popup_01");

String mode = StringUtil.null2void(request.getParameter("mode"));
String cntnId = StringUtil.null2void(request.getParameter("cntnId"));
String dcmtRgsrNo = StringUtil.null2void(request.getParameter("dcmtRgsrNo"));
String attachList = StringUtil.null2void(request.getParameter("attachList"));
UserSession userSession = (UserSession) WebUtils.getRequiredSessionAttribute(request, "userSession");

FileService fileService = (FileService) getFileService();
BoardService boardService = (BoardService) getBoardService();

ArrayList<Ca002t> attach = new ArrayList<Ca002t>();
Ca002t ts002t = null;

if (attachList != null && attachList != "") {
StringTokenizer files = new StringTokenizer(attachList, "^");

while (files.hasMoreTokens()) {
ts002t = new Ca002t();
StringTokenizer token = new StringTokenizer(files.nextToken(), "|");
while(token.hasMoreTokens()) {
ts002t.setSysFileName(token.nextToken());
ts002t.setOrgnFileName(token.nextToken());

attach.add(ts002t);
}
}
}

if (mode.equals("ADD")) {
MultipartHttpServletRequest multipartRequest = (MultipartHttpServletRequest) request;
MultipartFile file = multipartRequest.getFile("file");
String fileName = file.getOriginalFilename();
String sysFileName = GenSequenceNo.getFileRgsrNo(userSession.getEmpNo());

File destination = File.createTempFile(sysFileName, "", new File(destinationDir));

FileCopyUtils.copy(file.getInputStream(), new FileOutputStream(destination));

Ca002t fileVO = (Ca002t) command;
fileVO.setOrgnFileName(file.getOriginalFilename());
fileVO.setSysFileName(sysFileName);
fileVO.setFileSize(file.getSize());
fileVO.setFileData(file.getBytes());

fileService.addTempFileUpload(fileVO);

destination.delete();

attach.add(fileVO);

if (attachList.trim().equals("")) {
attachList = fileVO.getSysFileName() + "|" + fileVO.getOrgnFileName();
} else {
attachList = attachList + "^" + fileVO.getSysFileName() + "|" + fileVO.getOrgnFileName();
}

mav.addObject("mode", "ADD");
mav.addObject("attachFileList", attachList);
mav.addObject("attachList", attach);
} else if (mode.equals("DEL")) {
String delFile = StringUtil.null2void(request.getParameter("delFile"));
StringTokenizer token = new StringTokenizer(delFile, "|");

String orgnFileName = "";
String sysFileName = "";
while(token.hasMoreTokens()) {
sysFileName = token.nextToken();
orgnFileName = token.nextToken();
}

Ca002tExample example = new Ca002tExample();
Ca002tExample.Criteria c = example.createCriteria();
c.andSysFileNameEqualTo(sysFileName);
c.andOrgnFileNameEqualTo(orgnFileName);
fileService.removeTempFileUpload(example);

for (int i = 0; i < attach.size(); i++) {
Ca002t temp = (Ca002t) attach.get(i);
if (temp.getSysFileName().equals(sysFileName)) attach.remove(i);
}

attachList = "";
for (int i = 0; i < attach.size(); i++) {
Ca002t fileVO = (Ca002t) attach.get(i);

if (i == 0) {
attachList = fileVO.getSysFileName() + "|" + fileVO.getOrgnFileName();
} else {
attachList = attachList + "^" + fileVO.getSysFileName() + "|" + fileVO.getOrgnFileName();
}
}



mav.addObject("mode", "DEL");
mav.addObject("attachFileList", attachList);
mav.addObject("attachList", attach);
} else if (mode.equals("LIST")) {
// Temp 테이블에 첨부파일이 등록되어져 있는지 확인
int fileCnt = attach.size();
Ca002m attachFile = new Ca002m();
attachFile.setCntnId(cntnId);
attachFile.setDcmtRgsrNo(dcmtRgsrNo);
attachList = "";

for (int i = 0; i < fileCnt; i++) {
Ca002t tempFile = attach.get(i);
attachFile.setOrgnFileName(tempFile.getOrgnFileName());
attachFile.setSysFileName(tempFile.getSysFileName());

Ca002tExample example = new Ca002tExample();
Ca002tExample.Criteria criteria = example.createCriteria();
criteria.andSysFileNameEqualTo(tempFile.getSysFileName());
criteria.andOrgnFileNameEqualTo(tempFile.getOrgnFileName());

boolean check = fileService.findCheckTempFileUpload(example);

// Temp 테이블에 첨부파일이 없을 경우
if (!check) {
Ca002m result = boardService.findAttachFileInfo(attachFile);

Ca002t insTempFile = new Ca002t();
insTempFile.setOrgnFileName(result.getOrgnFileName());
insTempFile.setSysFileName(result.getSysFileName());
insTempFile.setFileSize(result.getFileSize());
insTempFile.setFileData(result.getFileData());
fileService.addTempFileUpload(insTempFile);
}

if (i == 0) {
attachList = tempFile.getSysFileName() + "|" + tempFile.getOrgnFileName();
} else {
attachList = attachList + "^" + tempFile.getSysFileName() + "|" + tempFile.getOrgnFileName();
}
}

mav.addObject("mode", "LIST");
mav.addObject("attachFileList", attachList);
mav.addObject("attachList", attach);
}

mav.addObject("cntnId", cntnId);
mav.addObject("dcmtRgsrNo", dcmtRgsrNo);

return mav;
}

}

2014년 4월 28일 월요일

팝업 창 중앙에 띄우기


브라우저의 팝업 창을 중앙으로 띄우기.

function windowOpenCenter(url, parm, width, height) {
var sw  = screen.availWidth ;
var sh  = screen.availHeight ;

px=(sw - width)/2 ;
py=(sh - height)/2 ;

var set  = 'top=' + py + ',left=' + px ;
set += ',width=' + width + ',height=' + height + ',toolbar=0,resizable=1,status=0,scrollbars=1' ;

   window.open (url + '?' + parm , '' , set) ;
}

2014년 4월 17일 목요일

Spring Framework에서 Interceptor 설정 방법

먼저 Interceptor 클래스를 생성

/**
 *
 */
package sample;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.web.servlet.HandlerInterceptor;
import org.springframework.web.servlet.ModelAndView;
import org.springframework.web.util.WebUtils;

import util.ApplicationConfigReader;
import util.UserSession;

/**
 * @author 9791714
 *
 */
public class LogonInterceptor implements HandlerInterceptor {
private static final Logger logger = LoggerFactory.getLogger(LogonInterceptor.class);

/**
     * Controller 가 수행되기 전에 호출됩니다.
     */
    @Override
    public boolean preHandle(HttpServletRequest request,
                             HttpServletResponse response,
                             Object handler) throws Exception {

    logger.debug("LogonInterceptor start");

//세션정보를 확인한다.
UserSession userSession =  (UserSession) WebUtils.getSessionAttribute(request, "userSession");

//세션정보를 확인해서 null일 경우, 로그인 페이지로 이동
if (userSession == null) {
String redirectUrl = ApplicationConfigReader.get("webAppRoot") + "/loginForm";
response.sendRedirect(redirectUrl);

return false;
}
logger.debug("LogonInterceptor end");
return true;
    }

    /**
     * Controller의 메소드가 수행이 완료되고, View 를 호출하기 전에 호출됩니다.
     */
    @Override
    public void postHandle(HttpServletRequest request,
                           HttpServletResponse response,
                           Object handler,
                           ModelAndView modelAndView) throws Exception {
        // Nothing to do
    }

    /**
     * View 작업까지 완료된 후 Client에 응답하기 바로 전에 호출됩니다.
     */
    @Override
    public void afterCompletion(HttpServletRequest request,
                                HttpServletResponse response,
                                Object handler,
                                Exception ex) throws Exception {

    if(logger.isDebugEnabled()) {
            logger.debug("logonInterceptor를 종료합니다.");
    }
    }
}

설정 파일에 Interceptor 설정
<mvc:interceptors>
    <bean class="sample.LogonInterceptor"/>
</mvc:interceptors>

2014년 4월 10일 목요일

maven pom 파일

Spring Framework 3.1.4 환경에 맞는 maven 설정 파일

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>com.dsme</groupId>
<artifactId>Test</artifactId>
<packaging>war</packaging>
<version>0.0.1-SNAPSHOT</version>
  <properties>
<java-version>1.6</java-version>
<org.springframework-version>3.1.4.RELEASE</org.springframework-version>
<org.aspectj-version>1.6.10</org.aspectj-version>
<org.slf4j-version>1.6.6</org.slf4j-version>
</properties>

<name>Test Maven Webapp</name>
<url>http://maven.apache.org</url>
<dependencies>
 <dependency>
   <groupId>junit</groupId>
   <artifactId>junit</artifactId>
   <version>4.8.2</version>
   <scope>test</scope>
 </dependency>
 <dependency>
  <groupId>org.springframework</groupId>
  <artifactId>spring-context</artifactId>
  <version>${org.springframework-version}</version>
 </dependency>
 <dependency>
  <groupId>org.springframework</groupId>
  <artifactId>spring-jdbc</artifactId>
  <version>${org.springframework-version}</version>
 </dependency>
 <dependency>
  <groupId>org.springframework</groupId>
  <artifactId>spring-web</artifactId>
  <version>${org.springframework-version}</version>
 </dependency>
 <dependency>
  <groupId>org.springframework</groupId>
  <artifactId>spring-webmvc</artifactId>
  <version>${org.springframework-version}</version>
 </dependency>
 <dependency>
  <groupId>org.springframework</groupId>
  <artifactId>spring-orm</artifactId>
  <version>${org.springframework-version}</version>
 </dependency>
 <dependency>
  <groupId>org.springframework</groupId>
  <artifactId>spring-oxm</artifactId>
  <version>${org.springframework-version}</version>
 </dependency>
 <dependency>
  <groupId>org.mybatis</groupId>
  <artifactId>mybatis-spring</artifactId>
  <version>1.2.2</version>
 </dependency>
 <dependency>
  <groupId>org.mybatis</groupId>
  <artifactId>mybatis</artifactId>
  <version>3.2.3</version>
 </dependency>
 <dependency>
  <groupId>ch.qos.logback</groupId>
  <artifactId>logback-classic</artifactId>
  <version>1.1.1</version>
 </dependency>
 <dependency>
  <groupId>ch.qos.logback</groupId>
  <artifactId>logback-core</artifactId>
  <version>1.1.1</version>
 </dependency>
 <dependency>
  <groupId>org.apache.geronimo.specs</groupId>
  <artifactId>geronimo-servlet_2.5_spec</artifactId>
  <version>1.2</version>
 </dependency>
 <dependency>
  <groupId>commons-dbcp</groupId>
  <artifactId>commons-dbcp</artifactId>
  <version>1.4</version>
 </dependency>
 <dependency>
  <groupId>org.springframework</groupId>
  <artifactId>spring-test</artifactId>
  <version>${org.springframework-version}</version>
 </dependency>
 <dependency>
  <groupId>org.aspectj</groupId>
  <artifactId>aspectjweaver</artifactId>
  <version>1.7.3</version>
 </dependency>
 <dependency>
  <groupId>org.aspectj</groupId>
  <artifactId>aspectjrt</artifactId>
  <version>1.7.3</version>
 </dependency>
 <dependency>
  <groupId>cglib</groupId>
  <artifactId>cglib</artifactId>
  <version>3.1</version>
 </dependency>
 <dependency>
  <groupId>commons-fileupload</groupId>
  <artifactId>commons-fileupload</artifactId>
  <version>1.3.1</version>
 </dependency>
</dependencies>
<build>
 <finalName>Test</finalName>
</build>
</project>