tag:blogger.com,1999:blog-22074996326035106372024-03-06T04:40:53.210+09:00BS Blog쥬르http://www.blogger.com/profile/10647295127284034724noreply@blogger.comBlogger315125truetag:blogger.com,1999:blog-2207499632603510637.post-6351138374463534532021-03-25T20:35:00.002+09:002021-03-25T20:35:58.449+09:00windows 10 환경에서 ReactJS 개발환경 설정 - markdown 형식 문서<p> <span style="font-family: Arial; font-size: 11pt; white-space: pre-wrap;">#ReactJS </span></p><span id="docs-internal-guid-5de9f889-7fff-d72f-6b61-285e389a6c5c"><br /><p dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;"><span style="font-family: Arial; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">## 개발환경 설정 </span></p><br /><p dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;"><span style="font-family: Arial; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">### nodejs 설치 </span></p><br /><br /><p dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;"><span style="font-family: Arial; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">공식사이트에 들어가서 nodejs 를 아래 사이에서 다운 받아 설치</span></p><br /><p dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;"><span style="font-family: Arial; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">- nodejs 공식사이트 접속 : [NodeJS org](https://nodejs.org/ko/download/) </span></p><br /><p dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;"><span style="font-family: Arial; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">- [zip] 파일 받아서 설치시 </span></p><p dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;"><span style="font-family: Arial; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;"><span class="Apple-tab-span" style="white-space: pre;"> </span></span><span style="font-family: Arial; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">- 임의의 폴더에 압축 해제. </span></p><p dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;"><span style="font-family: Arial; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;"><span class="Apple-tab-span" style="white-space: pre;"> </span></span><span style="font-family: Arial; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">- cmd 창에서 해당 경로로 이동. </span></p><p dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;"><span style="font-family: Arial; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;"><span class="Apple-tab-span" style="white-space: pre;"> </span></span><span style="font-family: Arial; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">- 이동된 디렉토리에서 아래 명령어 실행 </span></p><p dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;"><span style="font-family: Arial; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;"> </span></p><p dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;"><span style="font-family: Arial; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;"><span class="Apple-tab-span" style="white-space: pre;"> </span></span><span style="font-family: Arial; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">```linux </span></p><p dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;"><span style="font-family: Arial; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;"><span class="Apple-tab-span" style="white-space: pre;"> </span></span><span style="font-family: Arial; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;"> # npm -v </span></p><p dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;"><span style="font-family: Arial; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;"><span class="Apple-tab-span" style="white-space: pre;"> </span></span><span style="font-family: Arial; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;"> # node -v</span></p><p dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;"><span style="font-family: Arial; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;"><span class="Apple-tab-span" style="white-space: pre;"> </span></span><span style="font-family: Arial; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;"> ```</span></p><br /><p dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;"><span style="font-family: Arial; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;"><span class="Apple-tab-span" style="white-space: pre;"> </span></span><span style="font-family: Arial; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">- 정상 작동 확인시 환경변수 등록하여 어느 디렉토리에서 실행해도 작동하도록 설정. </span></p><br /><p dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;"><span style="font-family: Arial; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">- npm을 이용하여 create-react-app 설치 </span></p><p dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;"><span style="font-family: Arial; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;"><span class="Apple-tab-span" style="white-space: pre;"> </span></span><span style="font-family: Arial; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">아래 명령어를 이용하여 create-react-app 을 로컬에 설치 </span></p><p dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;"><span style="font-family: Arial; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;"> </span></p><br /><p dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;"><span style="font-family: Arial; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;"><span class="Apple-tab-span" style="white-space: pre;"> </span></span><span style="font-family: Arial; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">```linux</span></p><p dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;"><span style="font-family: Arial; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;"><span class="Apple-tab-span" style="white-space: pre;"> </span></span><span style="font-family: Arial; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;"># npm install -g create-react-app</span></p><p dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;"><span style="font-family: Arial; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;"><span class="Apple-tab-span" style="white-space: pre;"> </span></span><span style="font-family: Arial; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">```</span></p><p dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;"><span style="font-family: Arial; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;"><span class="Apple-tab-span" style="white-space: pre;"> </span></span></p><p dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;"><span style="font-family: Arial; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">- 개발 디렉토리 지정 </span></p><p dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;"><span style="font-family: Arial; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;"><span class="Apple-tab-span" style="white-space: pre;"> </span></span><span style="font-family: Arial; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">아래 명령어를 이용하여 create-react-app 을 이용하여 로컬에 개발디렉토리 지정 </span></p><p dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;"><span style="font-family: Arial; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;"><span class="Apple-tab-span" style="white-space: pre;"> </span></span><span style="font-family: Arial; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">설정하고자 하는 디렉토리로 이동 (ex : d:\dev\workspace\react-app\ ) 후에 아래 명령어를 입력하여 실행. </span></p><p dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;"><span style="font-family: Arial; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;"><span class="Apple-tab-span" style="white-space: pre;"> </span></span></p><p dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;"><span style="font-family: Arial; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;"><span class="Apple-tab-span" style="white-space: pre;"> </span></span></p><p dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;"><span style="font-family: Arial; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;"><span class="Apple-tab-span" style="white-space: pre;"> </span></span><span style="font-family: Arial; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">```linux</span></p><p dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;"><span style="font-family: Arial; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;"><span class="Apple-tab-span" style="white-space: pre;"> </span></span><span style="font-family: Arial; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;"># create-react-app .</span></p><p dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;"><span style="font-family: Arial; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;"><span class="Apple-tab-span" style="white-space: pre;"> </span></span><span style="font-family: Arial; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">```</span></p><br /><br /><p dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;"><span style="font-family: Arial; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">### visual sourcecode 설치 </span></p><br /><p dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;"><span style="font-family: Arial; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">공식사이트에 들어가서 visual sourcecode 를 아래 사이에서 다운 받아 설치</span></p><br /><p dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;"><span style="font-family: Arial; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">- visual source code 공식사이트 접속 : [code.visualstudio.com](https://code.visualstudio.com/) </span></p><br /><p dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;"><span style="font-family: Arial; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">- [zip] 파일 받아서 설치시 </span></p><p dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;"><span style="font-family: Arial; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;"><span class="Apple-tab-span" style="white-space: pre;"> </span></span><span style="font-family: Arial; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">- 임의의 폴더에 압축 해제. </span></p><p dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;"><span style="font-family: Arial; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;"><span class="Apple-tab-span" style="white-space: pre;"> </span></span><span style="font-family: Arial; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">- cmd 창에서 해당 경로로 이동. </span></p><p dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;"><span style="font-family: Arial; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;"><span class="Apple-tab-span" style="white-space: pre;"> </span></span><span style="font-family: Arial; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">- 이동된 디렉토리에서 아래 명령어 실행 </span></p><br /><p dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;"><span style="font-family: Arial; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">### react build </span></p><br /><p dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;"><span style="font-family: Arial; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">```linux</span></p><p dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;"><span style="font-family: Arial; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;"><span class="Apple-tab-span" style="white-space: pre;"> </span></span><span style="font-family: Arial; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;"># npm run build </span></p><p dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;"><span style="font-family: Arial; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">```</span></p><p dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;"><span style="font-family: Arial; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;"><span class="Apple-tab-span" style="white-space: pre;"> </span></span></p><br /><p dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;"><span style="font-family: Arial; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">### react 배포 </span></p><br /><p dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;"><span style="font-family: Arial; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">- react 실행하기 위한 서버 install </span></p><br /><p dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;"><span style="font-family: Arial; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;"><span class="Apple-tab-span" style="white-space: pre;"> </span></span><span style="font-family: Arial; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">```linux</span></p><p dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;"><span style="font-family: Arial; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;"><span class="Apple-tab-span" style="white-space: pre;"> </span></span><span style="font-family: Arial; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;"># npm install -g serve</span></p><p dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;"><span style="font-family: Arial; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;"><span class="Apple-tab-span" style="white-space: pre;"> </span></span><span style="font-family: Arial; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">```</span></p><br /><p dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;"><span style="font-family: Arial; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">### react app 실행 </span></p><br /><p dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;"><span style="font-family: Arial; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">```linux </span></p><p dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;"><span style="font-family: Arial; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;"> # npx serve -s build => build 로 생성한 것을 docRoot 으로 설정. </span></p><p dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;"><span style="font-family: Arial; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">```</span></p><br /><p dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;"><span style="font-family: Arial; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;"> </span></p><br /></span>쥬르http://www.blogger.com/profile/10647295127284034724noreply@blogger.com0tag:blogger.com,1999:blog-2207499632603510637.post-3853071594874502472021-03-12T10:54:00.000+09:002021-03-12T10:54:06.539+09:00Mysql/MariaDB 대용량 데이터 import 하기 1. command 명령 프롬프트에서 mysql/mariadb 로그인<br />
<br />
D:\eGov_3.6_DEV\bin\mariadb-10.2.6-winx64>bin\mysql -u root -p<br />
Enter password: **********<br />
Welcome to the MariaDB monitor. Commands end with ; or \g.<br />
Your MariaDB connection id is 23<br />
Server version: 10.2.6-MariaDB-log mariadb.org binary distribution<br />
<br />
Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.<br />
<br />
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.<br />
<br />
MariaDB [(none)]> help load<br />
Many help items for your request exist.<br />
To make a more specific request, please type 'help <item>',<br />
where <item> is one of the following<br />
topics:<br />
LOAD DATA<br />
LOAD INDEX<br />
<br />
<br />
2. import 하고자 하는 DB로 변경<br />
<br />
MariaDB [(none)]> use skb_mss; <== 해당 db로 이동<br />
Database changed<br />
<br />
3. *.csv/*.log 파일의 내용을 읽어서 로딩<br />
// 파일에서 데이터 읽어서 로딩하기.<br />
// 아래 문장의 내용<br />
// input 파일명 : d:\aapl2.csv 입력 테이블명 : aapl<br />
// 컬럼 구분은 ',' <br />
// 줄 끝은 '\n'<br />
// 첫줄은 header 이므로 무시<br />
MariaDB [skb_mss]> load data local infile 'd:\\aapl2.csv' into table aapl columns terminated by ',' lines terminated by '\n' ignore 1 lines;<br />
Query OK, 1243 rows affected, 2471 warnings (0.04 sec)<br />
Records: 1243 Deleted: 0 Skipped: 0 Warnings: 2471<br />
<div>
<br /></div>
쥬르http://www.blogger.com/profile/10647295127284034724noreply@blogger.com0tag:blogger.com,1999:blog-2207499632603510637.post-50422359632748376442021-03-12T10:53:00.000+09:002021-03-12T10:53:44.550+09:00mysql startup, stop 파일 생성 <br />
startup_mysqld.bat 내용<br />
.\bin\mysqld --character-set-server=utf8 --explicit-defaults-for-timestamp &<br />
<br />
<br />
stop_mysqld.bat 내용<br />
.\bin\mysqladmin -u root -p shutdown쥬르http://www.blogger.com/profile/10647295127284034724noreply@blogger.com0tag:blogger.com,1999:blog-2207499632603510637.post-16536513860888570942021-03-12T10:52:00.001+09:002021-03-12T10:52:33.671+09:00Notepad++ 에서 Camel case 변환 <p> <span style="background-color: white; color: #3c4043; font-family: Roboto, Arial, sans-serif; font-size: 14px; letter-spacing: 0.2px; white-space: pre-wrap;">Notepad++ Camel case 변환하기 </span></p><p><span style="background-color: white; color: #3c4043; font-family: Roboto, Arial, sans-serif; font-size: 14px; letter-spacing: 0.2px; white-space: pre-wrap;"><br /></span></p><p><span style="background-color: white; color: #3c4043; font-family: Roboto, Arial, sans-serif; font-size: 14px; letter-spacing: 0.2px; white-space: pre-wrap;">1.. 변환하고자 하는 문자열을 소문자 변환 </span></p><p><span style="background-color: white; color: #3c4043; font-family: Roboto, Arial, sans-serif; font-size: 14px; letter-spacing: 0.2px; white-space: pre-wrap;">2. 찾기 팝업에서 아래 명령어로 변환. (하단에 정규표현식 체크 설정)
<br /></span></p><p><span style="background-color: white; color: #3c4043; font-family: Roboto, Arial, sans-serif; font-size: 14px; letter-spacing: 0.2px; white-space: pre-wrap;"> Find => [_]{1,1}([a-z])</span></p><p><span style="background-color: white; color: #3c4043; font-family: Roboto, Arial, sans-serif; font-size: 14px; letter-spacing: 0.2px; white-space: pre-wrap;"> Replace => \U$1</span></p>쥬르http://www.blogger.com/profile/10647295127284034724noreply@blogger.com0tag:blogger.com,1999:blog-2207499632603510637.post-13610622497564175432018-09-16T19:07:00.000+09:002018-09-16T19:07:31.116+09:00[JAVA]Base64 Encode => Base64 Decode 하여 파일생성하기(inputstream, byte[]를 통한 파일 전달에 사용가능)<span style="background-color: white; color: #212121; font-family: Roboto, "Noto Sans KR", Helvetica, Arial, sans-serif; font-size: 14px; white-space: pre-wrap;">* Base64 Encode => Base64 Decode 하여 파일생성하기
Apache commons codec 에서 제공하는 Base64 En Decoding 사용했습니다.
-----------------------------------------------------------------------------
package com.test;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import org.apache.commons.codec.binary.Base64;
public class ImgTest {
public ImgTest(){
try {
File imgFile = new File("D:\\test.jpg");
// 이미지 파일을 byte[] 로 읽어온다.
FileInputStream fis = new FileInputStream(imgFile);
byte[] b = new byte[fis.available()];
fis.read(b);
// 읽어온 이미지 파일의 바이너리 데이터를 base64로 인코딩한다.
byte[] encoded = Base64.encodeBase64(b);
// byte[] 형태의 base64 데이터를 String으로 변환.
String base64Str = new String(encoded);
System.out.println(base64Str);
// 디코딩 작업.
byte[] decoded = Base64.decodeBase64(encoded);
File base64ToImgFile = new File("D:\\test2.jpg");
FileOutputStream fos = new FileOutputStream(base64ToImgFile);
fos.write(decoded);
} catch (FileNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally{
}
}
public static void main(String[] args) {
new ImgTest();
}
}
</span><br />
<span style="color: #212121; font-family: Roboto, Noto Sans KR, Helvetica, Arial, sans-serif;"><span style="background-color: white; font-size: 14px; white-space: pre-wrap;">************************************</span></span><br />
<span style="color: #212121; font-family: Roboto, Noto Sans KR, Helvetica, Arial, sans-serif;"><span style="background-color: white; font-size: 14px; white-space: pre-wrap;"><br /></span></span>
<span style="color: #212121; font-family: Roboto, Noto Sans KR, Helvetica, Arial, sans-serif;"><span style="background-color: white; font-size: 14px; white-space: pre-wrap;"><br /></span></span>
<span style="background-color: white; font-size: 14px; white-space: pre-wrap;"><span style="color: #212121; font-family: Roboto, Noto Sans KR, Helvetica, Arial, sans-serif;">https://stackoverflow.com/questions/17506428/convert-base64-string-to-image-in-java</span></span><br />
<span style="background-color: white; font-size: 14px; white-space: pre-wrap;"><span style="color: #212121; font-family: Roboto, Noto Sans KR, Helvetica, Arial, sans-serif;"><br /></span></span>쥬르http://www.blogger.com/profile/10647295127284034724noreply@blogger.com0tag:blogger.com,1999:blog-2207499632603510637.post-74441736443717315412018-09-16T19:01:00.004+09:002018-09-16T19:01:50.948+09:00[JAVA] String to byte[] convert (String <-> byte[] 변환)<span style="background-color: white; color: #212121; font-family: Roboto, "Noto Sans KR", Helvetica, Arial, sans-serif; font-size: 14px; white-space: pre-wrap;">java 에서 String 과 byte[] 간 변환방법 </span><br />
<span style="background-color: white; color: #212121; font-family: Roboto, "Noto Sans KR", Helvetica, Arial, sans-serif; font-size: 14px; white-space: pre-wrap;"><br /></span>
<span style="background-color: white; color: #212121; font-family: Roboto, "Noto Sans KR", Helvetica, Arial, sans-serif; font-size: 14px; white-space: pre-wrap;"><br /></span>
<span style="background-color: white; color: #212121; font-family: Roboto, "Noto Sans KR", Helvetica, Arial, sans-serif; font-size: 14px; white-space: pre-wrap;"><br /></span>
<span style="background-color: white; color: #212121; font-family: Roboto, "Noto Sans KR", Helvetica, Arial, sans-serif; font-size: 14px; white-space: pre-wrap;">String test = "this is example";
byte[] strbytes = test.getBytes(); // byte[] 로 변환
String s = new String(</span><span style="background-color: white; color: #212121; font-family: Roboto, "Noto Sans KR", Helvetica, Arial, sans-serif; font-size: 14px; white-space: pre-wrap;">strbytes</span><span style="background-color: white; color: #212121; font-family: Roboto, "Noto Sans KR", Helvetica, Arial, sans-serif; font-size: 14px; white-space: pre-wrap;">); // byte[] => String 으로 변환</span>쥬르http://www.blogger.com/profile/10647295127284034724noreply@blogger.com0tag:blogger.com,1999:blog-2207499632603510637.post-18510589075291076592018-07-10T13:40:00.000+09:002018-07-10T13:40:25.216+09:00[pom.xml]org.apache.maven.archiver.MavenArchiver.getManifest(org.apache.maven.project.MavenProject, org.apache.maven.archiver.MavenArchiveConfiguration)<div style="background-color: white; line-height: 28px; margin-bottom: 28px; margin-left: auto; margin-right: auto; outline: none; padding-bottom: 0px !important; padding-left: 0px; padding-right: 0px; padding-top: 0px !important;">
<span style="color: #666666; font-family: Noto Sans, sans-serif;">출처]http://lime-it.tistory.com/36</span></div>
<div style="background-color: white; color: #666666; font-family: "Noto Sans", sans-serif; font-size: 16px; line-height: 28px; margin-bottom: 28px; margin-left: auto; margin-right: auto; outline: none; padding-bottom: 0px !important; padding-left: 0px; padding-right: 0px; padding-top: 0px !important;">
<br /></div>
<div style="background-color: white; color: #666666; font-family: "Noto Sans", sans-serif; font-size: 16px; line-height: 28px; margin-bottom: 28px; margin-left: auto; margin-right: auto; outline: none; padding-bottom: 0px !important; padding-left: 0px; padding-right: 0px; padding-top: 0px !important;">
STS 설치 이후 처음으로 스프링 부트 프로젝트를 생성하였는데 생성하자마자 오류가 등장하였다.</div>
<div style="background-color: white; color: #666666; font-family: "Noto Sans", sans-serif; font-size: 16px; line-height: 28px; margin-bottom: 28px; margin-left: auto; margin-right: auto; outline: none; padding-bottom: 0px !important; padding-left: 0px; padding-right: 0px; padding-top: 0px !important;">
<br /></div>
<div class="txc-textbox" style="background-color: #dbe8fb; border-color: rgb(219, 232, 251); border-style: solid; border-width: 1px; color: #666666; font-family: "Noto Sans", sans-serif; font-size: 14px; margin: 0px; outline: none; padding: 10px;">
<div style="font-size: 16px; line-height: 28px; margin-bottom: 28px; margin-left: auto; margin-right: auto; outline: none; padding-bottom: 0px !important; padding-left: 0px; padding-right: 0px; padding-top: 0px !important;">
<span style="background-color: #d9e5ff; color: black; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; font-size: 13px; white-space: pre-wrap;">org.apache.maven.archiver.MavenArchiver.getManifest(org.apache.maven.project.MavenProject, org.apache.maven.archiver.MavenArchiveConfiguration)</span></div>
</div>
<div style="background-color: white; color: #666666; font-family: "Noto Sans", sans-serif; font-size: 16px; line-height: 28px; margin-bottom: 28px; margin-left: auto; margin-right: auto; outline: none; padding-bottom: 0px !important; padding-left: 0px; padding-right: 0px; padding-top: 0px !important;">
<br /></div>
<div style="background-color: white; color: #666666; font-family: "Noto Sans", sans-serif; font-size: 16px; line-height: 28px; margin-bottom: 28px; margin-left: auto; margin-right: auto; outline: none; padding-bottom: 0px !important; padding-left: 0px; padding-right: 0px; padding-top: 0px !important;">
검색해도 한글로 된 답변도 없고 이것저것 도전해보다가 돌고 돌아 쓸만한 답변 하나 찾아서 해결했다.</div>
<div style="background-color: white; color: #666666; font-family: "Noto Sans", sans-serif; font-size: 16px; line-height: 28px; margin-bottom: 28px; margin-left: auto; margin-right: auto; outline: none; padding-bottom: 0px !important; padding-left: 0px; padding-right: 0px; padding-top: 0px !important;">
<br /></div>
<div style="background-color: white; color: #666666; font-family: "Noto Sans", sans-serif; font-size: 16px; line-height: 28px; margin-bottom: 28px; margin-left: auto; margin-right: auto; outline: none; padding-bottom: 0px !important; padding-left: 0px; padding-right: 0px; padding-top: 0px !important;">
위 오류는 Maven에 update project를 해도 해결이 되지 않는데</div>
<div style="background-color: white; color: #666666; font-family: "Noto Sans", sans-serif; font-size: 16px; line-height: 28px; margin-bottom: 28px; margin-left: auto; margin-right: auto; outline: none; padding-bottom: 0px !important; padding-left: 0px; padding-right: 0px; padding-top: 0px !important;">
<br /></div>
<div style="background-color: white; color: #666666; font-family: "Noto Sans", sans-serif; font-size: 16px; line-height: 28px; margin-bottom: 28px; margin-left: auto; margin-right: auto; outline: none; padding-bottom: 0px !important; padding-left: 0px; padding-right: 0px; padding-top: 0px !important;">
해결책으로는 두가지 방법이 있다.</div>
<div style="background-color: white; color: #666666; font-family: "Noto Sans", sans-serif; font-size: 16px; line-height: 28px; margin-bottom: 28px; margin-left: auto; margin-right: auto; outline: none; padding-bottom: 0px !important; padding-left: 0px; padding-right: 0px; padding-top: 0px !important;">
<br /></div>
<div style="background-color: white; color: #666666; font-family: "Noto Sans", sans-serif; font-size: 16px; line-height: 28px; margin-bottom: 28px; margin-left: auto; margin-right: auto; outline: none; padding-bottom: 0px !important; padding-left: 0px; padding-right: 0px; padding-top: 0px !important;">
1. 버전 다운그레이드</div>
<div style="background-color: white; color: #666666; font-family: "Noto Sans", sans-serif; font-size: 16px; line-height: 28px; margin-bottom: 28px; margin-left: 2em; margin-right: auto; outline: none; padding-bottom: 0px !important; padding-left: 0px; padding-right: 0px; padding-top: 0px !important;">
버전을 다운그레이드 할 경우 오류는 사라지지만 권장하지 않는 방법</div>
<div style="background-color: white; color: #666666; font-family: "Noto Sans", sans-serif; font-size: 16px; line-height: 28px; margin-bottom: 28px; margin-left: auto; margin-right: auto; outline: none; padding-bottom: 0px !important; padding-left: 0px; padding-right: 0px; padding-top: 0px !important;">
<br /></div>
<div style="background-color: white; color: #666666; font-family: "Noto Sans", sans-serif; font-size: 16px; line-height: 28px; margin-bottom: 28px; margin-left: auto; margin-right: auto; outline: none; padding-bottom: 0px !important; padding-left: 0px; padding-right: 0px; padding-top: 0px !important;">
<br /></div>
<div style="background-color: white; color: #666666; font-family: "Noto Sans", sans-serif; font-size: 16px; line-height: 28px; margin-bottom: 28px; margin-left: auto; margin-right: auto; outline: none; padding-bottom: 0px !important; padding-left: 0px; padding-right: 0px; padding-top: 0px !important;">
2. 이클립스에서 m2e 확장 기능을 설치하는 것</div>
<div style="background-color: white; color: #666666; font-family: "Noto Sans", sans-serif; font-size: 16px; line-height: 28px; margin-bottom: 28px; margin-left: 2em; margin-right: auto; outline: none; padding-bottom: 0px !important; padding-left: 0px; padding-right: 0px; padding-top: 0px !important;">
Help -> install New Software 에서</div>
<div class="txc-textbox" style="background-color: #e7fdb5; border-color: rgb(231, 253, 181); border-style: solid; border-width: 1px; color: #666666; font-family: "Noto Sans", sans-serif; font-size: 14px; margin: 0px; outline: none; padding: 10px;">
<div style="font-size: 16px; line-height: 28px; margin-bottom: 28px; margin-left: 2em; margin-right: auto; outline: none; padding-bottom: 0px !important; padding-left: 0px; padding-right: 0px; padding-top: 0px !important;">
<span style="background-color: #e4f7ba; color: black; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; font-size: 13px; white-space: pre-wrap;">https://otto.takari.io/content/sites/m2e.extras/m2eclipse-mavenarchiver/0.17.2/N/LATEST/ </span></div>
<div style="font-size: 16px; line-height: 28px; margin-bottom: 28px; margin-left: 2em; margin-right: auto; outline: none; padding-bottom: 0px !important; padding-left: 0px; padding-right: 0px; padding-top: 0px !important;">
<span style="background-color: #e4f7ba; color: black;">or</span></div>
<div style="font-size: 16px; line-height: 28px; margin-bottom: 28px; margin-left: 2em; margin-right: auto; outline: none; padding-bottom: 0px !important; padding-left: 0px; padding-right: 0px; padding-top: 0px !important;">
<span style="background-color: #e4f7ba; color: black;"></span><span style="background-color: #e4f7ba; color: black; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; font-size: 13px; white-space: pre-wrap;">http://repo1.maven.org/maven2/.m2e/connectors/m2eclipse-mavenarchiver/0.17.2/N/LATEST/</span></div>
</div>
<div style="background-color: white; color: #666666; font-family: "Noto Sans", sans-serif; font-size: 16px; line-height: 28px; margin-bottom: 28px; margin-left: 2em; margin-right: auto; outline: none; padding-bottom: 0px !important; padding-left: 0px; padding-right: 0px; padding-top: 0px !important;">
둘 중 선택해서 검색하여 m2e 확장기능을 설치후 재 시작하게 되면 오류는 해결된다.</div>
<div style="background-color: white; color: #666666; font-family: "Noto Sans", sans-serif; font-size: 16px; line-height: 28px; margin-bottom: 28px; margin-left: 2em; margin-right: auto; outline: none; padding-bottom: 0px !important; padding-left: 0px; padding-right: 0px; padding-top: 0px !important;">
<br /></div>
<div style="background-color: white; color: #666666; font-family: "Noto Sans", sans-serif; font-size: 16px; line-height: 28px; margin-bottom: 28px; margin-left: 2em; margin-right: auto; outline: none; padding-bottom: 0px !important; padding-left: 0px; padding-right: 0px; padding-top: 0px !important;">
<br /></div>
<div style="background-color: white; color: #666666; font-family: "Noto Sans", sans-serif; font-size: 16px; line-height: 28px; margin-bottom: 28px; margin-left: auto; margin-right: auto; outline: none; padding-bottom: 0px !important; padding-left: 0px; padding-right: 0px; padding-top: 0px !important;">
참고한 자료 출처 : https://stackoverflow.com/questions/37555557/m2e-error-in-mavenarchiver-getmanifest</div>
쥬르http://www.blogger.com/profile/10647295127284034724noreply@blogger.com0tag:blogger.com,1999:blog-2207499632603510637.post-2890838593281998522018-07-03T15:57:00.000+09:002018-07-03T15:57:12.401+09:00MySQL/MariaDB/SQL] MariaDB 10.2.16 zip 으로 설치 및 설정하기(서비스 등록 제외)mariadb 설치 및 설정 하기.<br />
<br />
1. https://downloads.mariadb.org/mariadb/+releases/ 에서 mariadb 10.2.16 다운로드 (x64버전, zip 파일)<br />
2. D:\DB\mariadb-10.2.16-winx64 로 압축 파일 해제<br />
3. 도스 명령창 실행<br />
4. D:\DB\mariadb-10.2.16-winx64\bin 디렉토리로 이동<br />
5. mysqld 실행<br />
5.1 localhost 에서 접속 가능하게 설정 작업 및 비번 설정 작업<br />
<span style="white-space: pre;"> </span>### mysql에 root 사용자로 접속<br />
<span style="white-space: pre;"> </span>### 최초 실행이라 비번이 설정되어 있지 않음<br />
<span style="white-space: pre;"> </span>D:\DB\mariadb-10.2.16-winx64\bin> mysql -u root<br />
<span style="white-space: pre;"> </span><br />
<span style="white-space: pre;"> </span>### mysql db 사용<br />
<span style="white-space: pre;"> </span>MariaDB [(none)]> use mysql<br />
<span style="white-space: pre;"> </span>Database changed<br />
<span style="white-space: pre;"> </span>MariaDB [mysql]> show databases;<br />
<span style="white-space: pre;"> </span>+--------------------+<br />
<span style="white-space: pre;"> </span>| Database |<br />
<span style="white-space: pre;"> </span>+--------------------+<br />
<span style="white-space: pre;"> </span>| information_schema |<br />
<span style="white-space: pre;"> </span>| mysql |<br />
<span style="white-space: pre;"> </span>| performance_schema |<br />
<span style="white-space: pre;"> </span>| test |<br />
<span style="white-space: pre;"> </span>+--------------------+<br />
<span style="white-space: pre;"> </span>4 rows in set (0.00 sec)<br />
<span style="white-space: pre;"> </span><br />
<span style="white-space: pre;"> </span><br />
<span style="white-space: pre;"> </span>### mysql db 의 user 테이블에 등록된 host, user 정보 확인<br />
<span style="white-space: pre;"> </span>MariaDB [mysql]> select host, user from user;<br />
<span style="white-space: pre;"> </span>+-----------+------+<br />
<span style="white-space: pre;"> </span>| host | user |<br />
<span style="white-space: pre;"> </span>+-----------+------+<br />
<span style="white-space: pre;"> </span>| 127.0.0.1 | root |<br />
<span style="white-space: pre;"> </span>| ::1 | root |<br />
<span style="white-space: pre;"> </span>| localhost | |<br />
<span style="white-space: pre;"> </span>| localhost | root |<br />
<span style="white-space: pre;"> </span>+-----------+------+<br />
<span style="white-space: pre;"> </span>4 rows in set (0.00 sec)<span style="white-space: pre;"> </span><br />
<span style="white-space: pre;"> </span><br />
<span style="white-space: pre;"> </span><br />
<span style="white-space: pre;"> </span>### root 사용자에게 모든 ip 로 부터 접속할 권한 부여 및 접속 비번 설정<br />
<span style="white-space: pre;"> </span>MariaDB [mysql]> grant all privileges on mysql.* to 'root'@'%' identified by '사용할비밀번호';<br />
<span style="white-space: pre;"> </span>Query OK, 0 rows affected (0.00 sec)<br />
<br />
<span style="white-space: pre;"> </span>MariaDB [mysql]> select host, user from user;<br />
<span style="white-space: pre;"> </span>+-----------+------+<br />
<span style="white-space: pre;"> </span>| host | user |<br />
<span style="white-space: pre;"> </span>+-----------+------+<br />
<span style="white-space: pre;"> </span>| % | root |<br />
<span style="white-space: pre;"> </span>| 127.0.0.1 | root |<br />
<span style="white-space: pre;"> </span>| ::1 | root |<br />
<span style="white-space: pre;"> </span>| localhost | |<br />
<span style="white-space: pre;"> </span>| localhost | root |<br />
<span style="white-space: pre;"> </span>+-----------+------+<br />
<span style="white-space: pre;"> </span>5 rows in set (0.00 sec)<span style="white-space: pre;"> </span><br />
<span style="white-space: pre;"> </span><br />
<br />
<span style="white-space: pre;"> </span>### user 테이블에 등록된 사용자 정보 확인 : root 사용자의 비번이 설정되어 있지 않음<br />
<span style="white-space: pre;"> </span>MariaDB [mysql]> select host, user, password from user;<br />
<span style="white-space: pre;"> </span>+-----------+------+-------------------------------------------+<br />
<span style="white-space: pre;"> </span>| host | user | password |<br />
<span style="white-space: pre;"> </span>+-----------+------+-------------------------------------------+<br />
<span style="white-space: pre;"> </span>| localhost | root | |<br />
<span style="white-space: pre;"> </span>| 127.0.0.1 | root | |<br />
<span style="white-space: pre;"> </span>| ::1 | root | |<br />
<span style="white-space: pre;"> </span>| localhost | | |<br />
<span style="white-space: pre;"> </span>| % | root | 인코딩된 비밀번호 |<br />
<span style="white-space: pre;"> </span>+-----------+------+-------------------------------------------+<br />
<span style="white-space: pre;"> </span>5 rows in set (0.00 sec)<br />
<br />
<span style="white-space: pre;"> </span>### user 테이블의 초기 등록된 사용자에 대한 비번 설정<br />
<span style="white-space: pre;"> </span>MariaDB [mysql]> update user set password = PASSWORD('사용할비밀번호');<br />
<span style="white-space: pre;"> </span>Query OK, 4 rows affected (0.02 sec)<br />
<span style="white-space: pre;"> </span>Rows matched: 5 Changed: 4 Warnings: 0<br />
<br />
<span style="white-space: pre;"> </span><br />
<span style="white-space: pre;"> </span>### user 테이블의 초기 등록된 사용자에 정보 확인<br />
<span style="white-space: pre;"> </span>MariaDB [mysql]> select host, user, password from user;<br />
<span style="white-space: pre;"> </span>+-----------+------+-------------------------------------------+<br />
<span style="white-space: pre;"> </span>| host | user | password |<br />
<span style="white-space: pre;"> </span>+-----------+------+-------------------------------------------+<br />
<span style="white-space: pre;"> </span>| localhost | root | 인코딩된 비밀번호 |<br />
<span style="white-space: pre;"> </span>| 127.0.0.1 | root | 인코딩된 비밀번호 |<br />
<span style="white-space: pre;"> </span>| ::1 | root | 인코딩된 비밀번호 |<br />
<span style="white-space: pre;"> </span>| localhost | | 인코딩된 비밀번호 |<br />
<span style="white-space: pre;"> </span>| % | root | 인코딩된 비밀번호 |<br />
<span style="white-space: pre;"> </span>+-----------+------+-------------------------------------------+<br />
<span style="white-space: pre;"> </span>5 rows in set (0.00 sec)<br />
<br />
<span style="white-space: pre;"> </span>### 권한 적용.<br />
<span style="white-space: pre;"> </span>MariaDB [mysql]> flush privileges;<br />
<span style="white-space: pre;"> </span>Query OK, 0 rows affected (0.00 sec)<br />
<br />
<span style="white-space: pre;"> </span><br />
<span style="white-space: pre;"> </span>### mysql 빠져 나가기<br />
<span style="white-space: pre;"> </span>MariaDB [mysql]> \q<br />
<span style="white-space: pre;"> </span>Bye<span style="white-space: pre;"> </span><br />
<span style="white-space: pre;"> </span><br />
<span style="white-space: pre;"> </span>### mysql 접속확인 : 비번 적용된 버전으로...<br />
<span style="white-space: pre;"> </span>D:\DB\mariadb-10.2.16-winx64\bin>mysql -u root -p<br />
<span style="white-space: pre;"> </span>Enter password: **********<br />
<span style="white-space: pre;"> </span>Welcome to the MariaDB monitor. Commands end with ; or \g.<br />
<span style="white-space: pre;"> </span>Your MariaDB connection id is 12<br />
<span style="white-space: pre;"> </span>Server version: 10.2.16-MariaDB mariadb.org binary distribution<br />
<br />
<span style="white-space: pre;"> </span>Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.<br />
<br />
<span style="white-space: pre;"> </span>Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.<br />
<br />
<span style="white-space: pre;"> </span>MariaDB [(none)]> \q<br />
<span style="white-space: pre;"> </span>Bye<br />
<span style="white-space: pre;"> </span><br />
6. mysql 수동으로 실행 스크립트 생성<br />
<span style="white-space: pre;"> </span>D:\DB\mariadb-10.2.16-winx64\ 경로에 mysqld_start.bat 파일 생성 후 아래의 명령어를 적용 후 저장 한다.<br />
<span style="white-space: pre;"> </span><br />
<span style="white-space: pre;"> </span>#----------------<br />
<span style="white-space: pre;"> </span>bin\mysqld --defaults-file=my.ini --console --explicit_defaults_for_timestamp &<span style="white-space: pre;"> </span><br />
<span style="white-space: pre;"> </span>#----------------<br />
<span style="white-space: pre;"> </span><br />
7. <span style="white-space: pre;"> </span>my.ini 파일 생성<br />
<span style="white-space: pre;"> </span>### D:\DB\mariadb-10.2.16-winx64\my-large.ini 파일을 my.ini 로 복사<br />
<span style="white-space: pre;"> </span>D:\DB\mariadb-10.2.16-winx64> copy my-large.ini my.ini<br />
<span style="white-space: pre;"> </span><br />
<span style="white-space: pre;"> </span><br />
8. <span style="white-space: pre;"> </span>my.ini 파일 내용 수정 <span style="white-space: pre;"> </span><br />
<span style="white-space: pre;"> </span>########<br />
<span style="white-space: pre;"> </span>아래의 내용을 각 항목별로 추가한다. (character-set을 utf8로 설정 작업)<br />
<span style="white-space: pre;"> </span>[client]<br />
<span style="white-space: pre;"> </span>default-character-set=utf8<span style="white-space: pre;"> </span><br />
<span style="white-space: pre;"> </span><br />
<span style="white-space: pre;"> </span>[mysqld]<br />
<span style="white-space: pre;"> </span>character-set-server=utf8<br />
<span style="white-space: pre;"> </span>collation-server=utf8_general_ci<br />
<span style="white-space: pre;"> </span>init_connect=SET collation_connection=utf8_general_ci<br />
<span style="white-space: pre;"> </span>init_connect=SET NAMES utf8<span style="white-space: pre;"> </span><br />
<span style="white-space: pre;"> </span><br />
<span style="white-space: pre;"> </span>[mysql]<br />
<span style="white-space: pre;"> </span>default-character-set=utf8<br />
<br />
9. 6에서 생성한 .bat 파일을 실행시켜 mysql DB server 를 실행시킨다.<br />
<br />
10. character-set 적용과 data db 저장 디렉토리 확인<br />
<br />
<span style="white-space: pre;"> </span>### mysql 접속<br />
<span style="white-space: pre;"> </span>D:\DB\mariadb-10.2.16-winx64\bin>mysql -u root -p<br />
<span style="white-space: pre;"> </span>Enter password: **********<br />
<span style="white-space: pre;"> </span>Welcome to the MariaDB monitor. Commands end with ; or \g.<br />
<span style="white-space: pre;"> </span>Your MariaDB connection id is 9<br />
<span style="white-space: pre;"> </span>Server version: 10.2.16-MariaDB-log mariadb.org binary distribution<br />
<br />
<span style="white-space: pre;"> </span>Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.<br />
<br />
<span style="white-space: pre;"> </span>Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.<br />
<br />
<span style="white-space: pre;"> </span>### mysql character-set 정보 확인<br />
<span style="white-space: pre;"> </span>MariaDB [(none)]> show variables like 'c%';<br />
<span style="white-space: pre;"> </span>+--------------------------+----------------------------------------------+<br />
<span style="white-space: pre;"> </span>| Variable_name | Value |<br />
<span style="white-space: pre;"> </span>+--------------------------+----------------------------------------------+<br />
<span style="white-space: pre;"> </span>| character_set_client | utf8 |<br />
<span style="white-space: pre;"> </span>| character_set_connection | utf8 |<br />
<span style="white-space: pre;"> </span>| character_set_database | utf8 |<br />
<span style="white-space: pre;"> </span>| character_set_filesystem | binary |<br />
<span style="white-space: pre;"> </span>| character_set_results | utf8 |<br />
<span style="white-space: pre;"> </span>| character_set_server | utf8 |<br />
<span style="white-space: pre;"> </span>| character_set_system | utf8 |<br />
<span style="white-space: pre;"> </span>| character_sets_dir | D:\DB\mariadb-10.2.16-winx64\share\charsets\ |<br />
<span style="white-space: pre;"> </span>| check_constraint_checks | ON |<br />
<span style="white-space: pre;"> </span>| collation_connection | utf8_general_ci |<br />
<span style="white-space: pre;"> </span>| collation_database | utf8_general_ci |<br />
<span style="white-space: pre;"> </span>| collation_server | utf8_general_ci |<br />
<span style="white-space: pre;"> </span>| completion_type | NO_CHAIN |<br />
<span style="white-space: pre;"> </span>| concurrent_insert | AUTO |<br />
<span style="white-space: pre;"> </span>| connect_timeout | 10 |<br />
<span style="white-space: pre;"> </span>+--------------------------+----------------------------------------------+<br />
<span style="white-space: pre;"> </span>15 rows in set (0.00 sec)<br />
<br />
<span style="white-space: pre;"> </span>### mysql data 관련 정보 확인<br />
<span style="white-space: pre;"> </span>MariaDB [(none)]> show variables like 'd%';<br />
<span style="white-space: pre;"> </span>+-----------------------------+------------------------------------+<br />
<span style="white-space: pre;"> </span>| Variable_name | Value |<br />
<span style="white-space: pre;"> </span>+-----------------------------+------------------------------------+<br />
<span style="white-space: pre;"> </span>| datadir | D:\DB\mariadb-10.2.16-winx64\data\ |<br />
<span style="white-space: pre;"> </span>| date_format | %Y-%m-%d |<br />
<span style="white-space: pre;"> </span>| datetime_format | %Y-%m-%d %H:%i:%s |<br />
<span style="white-space: pre;"> </span>| deadlock_search_depth_long | 15 |<br />
<span style="white-space: pre;"> </span>| deadlock_search_depth_short | 4 |<br />
<span style="white-space: pre;"> </span>| deadlock_timeout_long | 50000000 |<br />
<span style="white-space: pre;"> </span>| deadlock_timeout_short | 10000 |<br />
<span style="white-space: pre;"> </span>| debug_no_thread_alarm | OFF |<br />
<span style="white-space: pre;"> </span>| default_master_connection | |<br />
<span style="white-space: pre;"> </span>| default_regex_flags | |<br />
<span style="white-space: pre;"> </span>| default_storage_engine | InnoDB |<br />
<span style="white-space: pre;"> </span>| default_tmp_storage_engine | |<br />
<span style="white-space: pre;"> </span>| default_week_format | 0 |<br />
<span style="white-space: pre;"> </span>| delay_key_write | ON |<br />
<span style="white-space: pre;"> </span>| delayed_insert_limit | 100 |<br />
<span style="white-space: pre;"> </span>| delayed_insert_timeout | 300 |<br />
<span style="white-space: pre;"> </span>| delayed_queue_size | 1000 |<br />
<span style="white-space: pre;"> </span>| div_precision_increment | 4 |<br />
<span style="white-space: pre;"> </span>+-----------------------------+------------------------------------+<br />
<span style="white-space: pre;"> </span>18 rows in set (0.00 sec)<br />
<br />
<span style="white-space: pre;"> </span><br />
11. mysql client 툴 다운로드 (HeidiSQL)<br />
<span style="white-space: pre;"> </span>mysql client 툴인 HeidiSQL 을 아래 경로에서 다운로드 한다. (x64버전, portable 버전)<br />
<span style="white-space: pre;"> </span><br />
<span style="white-space: pre;"> </span>https://www.heidisql.com/download.php?download=portable-64<br />
<span style="white-space: pre;"> </span><br />
12. 다운로드 받은 HeidiSQL 을 압축 해제 및 실행<br />
압축 해제된 경로에서 heidisql.exe 파일을 실행 후 접속 정보 입력 후, 사용하면 된다.<br />
<span style="white-space: pre;"> </span>쥬르http://www.blogger.com/profile/10647295127284034724noreply@blogger.com0tag:blogger.com,1999:blog-2207499632603510637.post-37055496907350669982018-05-16T08:43:00.001+09:002018-05-16T08:43:39.607+09:00d3 - 시각화 자바스크립트 라이브러리D3(Data-Driven Documents 를 표방해서 D3라 한다고 하는 듯)은<br />
강력한 시각화 자바스크립트 라이브러리 이다.<br />
<br />
<br />
이는 https://d3js.org/ 에서 확인 가능하고<br />
<br />
d3를 wrapping 하여 좀더 정형화 한 것 중에 하나가 C3(http://c3js.org/) 라고 하는 것도 있다.<br />
<br />
<br />
<br />쥬르http://www.blogger.com/profile/10647295127284034724noreply@blogger.com0tag:blogger.com,1999:blog-2207499632603510637.post-57168409231742028312016-03-25T11:17:00.001+09:002016-03-25T11:17:31.681+09:00한글[HWP] 메뉴바와 도구모음 사라지는 경우 대처법<div>
<br /></div>
<div>
<div>
<br /></div>
<div>
1. HWP가 설치된 폴더에 HNC / Hwp60 / HncSetup.exe 를 실행합니다.</div>
<div>
2. 한글 2004 기본 설정이 실행됩니다.</div>
<div>
3. 한글 2004를 처음 실행 상태로 되돌림 을 클릭합니다</div>
<div>
4. 완료를 클립합니다.</div>
<div>
5. 정상 작동된 한글 2004를 확인</div>
</div>
<div>
<br /></div>
<div>
<br /></div>
<div>
참조 URL :: http://happyjung.com/bbs/board.php?bo_table=lecture&wr_id=660</div>
쥬르http://www.blogger.com/profile/10647295127284034724noreply@blogger.com0tag:blogger.com,1999:blog-2207499632603510637.post-34449158709947678352015-09-22T09:16:00.000+09:002015-09-22T09:16:20.295+09:00DataBase] Oracle 테이블에 대한 정보 조회 쿼리-- 테이블에 대한 컬럼명, 컬럼 타입, 컬럼 길이, 코멘트 보는 쿼리.<br />
SELECT T.TABLE_NAME, T.COLUMN_NAME, T.DATA_TYPE, T.DATA_LENGTH, C.COMMENTS<br />
FROM ALL_TAB_COLUMNS T JOIN ALL_COL_COMMENTS C<br />
ON T.TABLE_NAME = C.TABLE_NAME<br />
AND T.COLUMN_NAME = C.COLUMN_NAME<br />
WHERE T.TABLE_NAME = 'TABLE_NAME'<br />
;쥬르http://www.blogger.com/profile/10647295127284034724noreply@blogger.com0tag:blogger.com,1999:blog-2207499632603510637.post-72666017103754413012015-06-15T16:26:00.002+09:002015-06-15T16:26:30.638+09:00Javascript ] 1000단위 comma(",") 관련 함수 및 숫자 판별 함수<br />
참조 URL :: http://blog.munilive.com/javascript-comma-uncomma/<br />
<br />
<br />
//콤마찍기<br />
function comma(str) {<br />
str = String(str);<br />
return str.replace(/(\d)(?=(?:\d{3})+(?!\d))/g, '$1,');<br />
}<br />
<br />
//콤마풀기<br />
function uncomma(str) {<br />
str = String(str);<br />
return str.replace(/[^\d]+/g, '');<br />
}<br />
<br />
//input box에서 사용자 입력시 바로 콤마를 찍어주기 위한 함수<br />
function inputNumberFormat(obj) {<br />
obj.value = comma(uncomma(obj.value));<br />
}<br />
<br />
<br />
========================================================================<br />
<br />
참조 URL :: http://mwultong.blogspot.com/2007/01/isnum-isnumeric-isnumber-javascript.html<br />
<br />
// 입력 문자가 숫자인지 판별하는 함수<br />
function isNumber(s) {<br />
s += ''; // 문자열로 변환<br />
s = s.replace(/^\s*|\s*$/g, ''); // 좌우 공백 제거<br />
if (s == '' || isNaN(s)) return false;<br />
return true;<br />
}<br />
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
위 comma 함수를 사용하여 input box 에 1000단위 콤마표시를 사용하면서 입력문자가 숫자인지 validation 을 하거나 숫자 연산이 필요한 경우 uncomma 함수를 사용하여 미리 "," 를 제거하고 연산작업을 수행해야 된다. </div>
<div class="line number5 index4 alt2" style="background: none white !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-sizing: content-box !important; color: #373737; float: none !important; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace; font-size: 15px; height: auto !important; left: auto !important; line-height: 16.5px; margin: 0px !important; min-height: inherit !important; outline: 0px !important; overflow: visible !important; padding: 0px 1em !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; white-space: pre !important; width: auto !important;">
<code class="js plain" style="background: none !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-sizing: content-box !important; color: black !important; float: none !important; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important; font-size: 1em !important; font-stretch: normal; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; min-height: inherit !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;"><div class="line number5 index4 alt2" style="background-attachment: initial !important; background-clip: initial !important; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-sizing: content-box !important; color: #373737; float: none !important; height: auto !important; left: auto !important; margin: 0px !important; min-height: inherit !important; outline: 0px !important; overflow: visible !important; padding: 0px 1em !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;">
<br /></div>
</code></div>
쥬르http://www.blogger.com/profile/10647295127284034724noreply@blogger.com0tag:blogger.com,1999:blog-2207499632603510637.post-5135216785642594382015-06-11T13:00:00.001+09:002015-06-11T13:00:08.067+09:00Java / Mybatis ] Mapped Statements collection does not contain value for XXX <span style="font-family: inherit; font-size: x-small;">Mapped Statements collection does not contain value for XXX 라는 오류가 뜨는 경우 <span style="background-color: white; line-height: 18.4799995422363px;">원인은 다음과 같다.</span></span><br />
<span style="font-family: inherit; font-size: x-small;"><br style="background-color: white; line-height: 18.4799995422363px;" /><span style="background-color: white; line-height: 18.4799995422363px;">1. MyBatis Config에 Mapper가 정의되어있지 않거나 철자를 틀리게 적은 경우</span><br style="background-color: white; line-height: 18.4799995422363px;" /><span style="background-color: white; line-height: 18.4799995422363px;">2. 같은 이름의 Namespace가 존재하는 경우</span><br style="background-color: white; line-height: 18.4799995422363px;" /><span style="background-color: white; line-height: 18.4799995422363px;">3. MyBatis Config에는 자신이 원하는대로 제대로 적었으나 해당 Mapper의 NameSpace에 다르게 적은 경우</span></span><div>
<span style="font-family: inherit; font-size: x-small;"><span style="background-color: white; line-height: 18.4799995422363px;"><br /></span></span></div>
<div>
<span style="font-size: x-small;"><span style="background-color: white; line-height: 18.4799995422363px;">위의 사항을 확인하기 바랍니다. </span></span></div>
쥬르http://www.blogger.com/profile/10647295127284034724noreply@blogger.com0tag:blogger.com,1999:blog-2207499632603510637.post-10119533896408232152014-08-23T07:18:00.004+09:002014-08-23T07:18:54.032+09:00MiPlatform 동영상강좌 리스트(youtube 게재 리스트)MiPlatform 동영상강좌 리스트입니다. (Youtube)<br />
<br />
<br />
[MiPlatform] <a href="http://www.youtube.com/watch?v=VilRxH9UgMg" target="_blank">Chapter1. RIA, X-Internet 및 MiPlatform 개요-1</a><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>http://www.youtube.com/watch?v=VilRxH9UgMg<br />
<br />
[MiPlatform] C<a href="http://www.youtube.com/watch?v=2X4P_13AVk0" target="_blank">hapter2. 기본환경설정 </a><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>http://www.youtube.com/watch?v=2X4P_13AVk0<br />
<br />
[MiPlatform] C<a href="http://www.youtube.com/watch?v=JrYbsgCYey8" target="_blank">hapter3. 기본화면 개발_base_hello </a><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>http://www.youtube.com/watch?v=JrYbsgCYey8<br />
<br />
[MiPlatform] <a href="http://www.youtube.com/watch?v=dQTEONETEP4" target="_blank">Chapter3. 기본 화면개발-base_menu</a><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>http://www.youtube.com/watch?v=dQTEONETEP4<br />
<br />
[MiPlatform] <a href="http://www.youtube.com/watch?v=EBRBG-lItAE" target="_blank">Chapter3. 기본 화면개발-base_sawon 1</a><span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>http://www.youtube.com/watch?v=EBRBG-lItAE<br />
<br />
[MiPlatform] <a href="http://www.youtube.com/watch?v=T4sy_Vul64o" target="_blank">Chapter3. 기본 화면개발-base_sawon 2</a><span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>http://www.youtube.com/watch?v=T4sy_Vul64o<br />
<br />
[MiPlatform] <a href="http://www.youtube.com/watch?v=Ea9gDhjmUiM" target="_blank">Chapter3. 기본 화면개발-base_sawon 3</a><span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>http://www.youtube.com/watch?v=Ea9gDhjmUiM<br />
<br />
[MiPlatform] <a href="http://www.youtube.com/watch?v=OcrgAv4SLRs" target="_blank">Chapter3. 기본 화면개발-base_sawon 4</a><span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>http://www.youtube.com/watch?v=OcrgAv4SLRs<br />
<br />
[MiPlatform] <a href="http://www.youtube.com/watch?v=5bZcqfTEsXM" target="_blank">Chapter3. 기본 화면개발-base_sawon 5</a><span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>http://www.youtube.com/watch?v=5bZcqfTEsXM<br />
<br />
[MiPlatform] <a href="http://www.youtube.com/watch?v=0ks2_P4VsbM" target="_blank">Chapter3. 기본 화면개발-base_sawon 6</a><span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>http://www.youtube.com/watch?v=0ks2_P4VsbM<br />
<br />
[MiPlatform] <a href="http://www.youtube.com/watch?v=00wcK7AnqGk" target="_blank">Chapter3. 기본 화면개발-base_sawon 7</a><span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>http://www.youtube.com/watch?v=00wcK7AnqGk<br />
<br />
[MiPlatform] <a href="http://www.youtube.com/watch?v=m1LJQUK6W5M" target="_blank">Chapter4. Service개발 및 화면연계(JSP,ASP) 1</a><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>http://www.youtube.com/watch?v=m1LJQUK6W5M<br />
<br />
[MiPlatform] <a href="http://www.youtube.com/watch?v=j84a9gXNc5U" target="_blank">Chapter4. Service개발 및 화면연계(JSP,ASP) 2</a><span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>http://www.youtube.com/watch?v=j84a9gXNc5U<br />
<br />
[MiPlatform] <a href="http://www.youtube.com/watch?v=K5nbv-DblbU" target="_blank">Chapter4. Service개발 및 화면연계(JSP,ASP) 3</a><span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>http://www.youtube.com/watch?v=K5nbv-DblbU<br />
<br />
[MiPlatform] <a href="http://www.youtube.com/watch?v=doil0t9SLNE" target="_blank">Chapter4. Service개발 및 화면연계(JSP,ASP) 4</a><span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>http://www.youtube.com/watch?v=doil0t9SLNE<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<br />
[MiPlatform] <a href="http://www.youtube.com/watch?v=h3EdUWZ-Irc" target="_blank">Chapter4. Service개발 및 화면연계(JSP,ASP) 5</a><span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>http://www.youtube.com/watch?v=h3EdUWZ-Irc<br />
<br />
[MiPlatform] <a href="http://www.youtube.com/watch?v=RtIzhn-ZNfg" target="_blank">Chapter5. 상세환경설정</a><span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>http://www.youtube.com/watch?v=RtIzhn-ZNfg<br />
<br />
[MiPlatform] <a href="http://www.youtube.com/watch?v=b4RbuIWsR3c" target="_blank">Chapter6. Component별 주요기능(list)</a><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>http://www.youtube.com/watch?v=b4RbuIWsR3c<br />
<br />
[MiPlatform] <a href="http://youtube.com/watch?v=88jSIlYdwPc" target="_blank">Chapter6. Component별 주요기능(image)</a><span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>http://youtube.com/watch?v=88jSIlYdwPc<br />
<br />
[MiPlatform] <a href="http://youtube.com/watch?v=XtVmzr7zQw8" target="_blank">Chapter6. Component별 주요기능(division)</a> <span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>http://youtube.com/watch?v=XtVmzr7zQw8<br />
<br />
[MiPlatform] <a href="http://youtube.com/watch?v=mf_A4OrmZ9k" target="_blank">Chapter6. Component별 주요기능(button)</a><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>http://youtube.com/watch?v=mf_A4OrmZ9k<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<br />
[MiPlatform] <a href="http://www.youtube.com/watch?v=JycH1tTT1TQ" target="_blank">Chapter6. Component별 주요기능(go)</a><span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>http://www.youtube.com/watch?v=JycH1tTT1TQ<br />
<br />
[MiPlatform] <a href="http://www.youtube.com/watch?v=Szr1cYy1RbU" target="_blank">Chapter6. Component별 주요기능(maskedit)</a><span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>http://www.youtube.com/watch?v=Szr1cYy1RbU<br />
<br />
[MiPlatform] <a href="http://www.youtube.com/watch?v=5vWH99zDXwQ" target="_blank">Chapter6. Component별 주요기능(edit)</a> <span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>http://www.youtube.com/watch?v=5vWH99zDXwQ<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<br />
[MiPlatform] <a href="http://www.youtube.com/watch?v=NC7cglBY1jQ" target="_blank">Chapter6. Component별 주요기능(check)</a><span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>http://www.youtube.com/watch?v=NC7cglBY1jQ<br />
<br />
[MiPlatform] <a href="http://www.youtube.com/watch?v=S-3WTZPJZDo" target="_blank">Chapter6. Component별 주요기능(combo)</a> <span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>http://www.youtube.com/watch?v=S-3WTZPJZDo<br />
<br />
[MiPlatform] <a href="http://www.youtube.com/watch?v=-Rv3Rcie-4A" target="_blank">Chapter6. Component별 주요기능(calendar)</a> <span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>http://www.youtube.com/watch?v=-Rv3Rcie-4A<br />
<br />
[MiPlatform] <a href="http://www.youtube.com/watch?v=sD1OXJpKB2A" target="_blank">Chapter7. 고급기능 및 Tip-1</a><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>http://www.youtube.com/watch?v=sD1OXJpKB2A<br />
<br />
[MiPlatform] <a href="http://www.youtube.com/watch?v=lhUmfDUKN7w" target="_blank">Chapter7. 고급기능 및 Tip-2</a><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>http://www.youtube.com/watch?v=lhUmfDUKN7w<br />
<br />
[MiPlatform] <a href="http://www.youtube.com/watch?v=P40NncCVHP4" target="_blank">Chapter7. 고급기능 및 Tip-3</a><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>http://www.youtube.com/watch?v=P40NncCVHP4<br />
<br />
[MiPlatform] <a href="http://www.youtube.com/watch?v=U9NoxA0WbN4" target="_blank">Chapter8. 운영</a><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>http://www.youtube.com/watch?v=U9NoxA0WbN4<br />
<br />
[MiPlatform] <a href="http://www.youtube.com/watch?v=nedEQsLVHbI" target="_blank">Chapter9. Local DB연계</a><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>http://www.youtube.com/watch?v=nedEQsLVHbI<br />
<br />
[MiPlatform] <a href="http://www.youtube.com/watch?v=Ih1hTOo2RpA" target="_blank">Dataset_처리</a><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>http://www.youtube.com/watch?v=Ih1hTOo2RpA<br />
<br />
[MiPlatform] <a href="http://www.youtube.com/watch?v=zpkaXBb_iUk" target="_blank">Dataset1</a><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span> http://www.youtube.com/watch?v=zpkaXBb_iUk<br />
<br />
[MiPlatform] <a href="http://www.youtube.com/watch?v=ubuHWfjEyVg" target="_blank">Dataset2</a><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>http://www.youtube.com/watch?v=ubuHWfjEyVg<br />
<br />
[MiPlatform] <a href="http://www.youtube.com/watch?v=2aoz0YaWsfc" target="_blank">Dataset3</a><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>http://www.youtube.com/watch?v=2aoz0YaWsfc<br />
<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>쥬르http://www.blogger.com/profile/10647295127284034724noreply@blogger.com4tag:blogger.com,1999:blog-2207499632603510637.post-10049358425026831442014-03-14T09:46:00.000+09:002014-03-14T09:46:17.334+09:00[DB2]SQL0803N One or more ...SQLSTATE=23505 오류메시지 확인하기참조URL : http://www.dbforums.com/db2/997011-sql0803n-one-more-sqlstate-23505-a.html<br />
<br />
<br />
<b>IBM DB2 사용시 아래와 같은 오류메시지를 만나는 경우 오류내용 확인하기</b><br />
=================<br />
unique constraint or unique index identified by "1" constrains table "schema.table_name" from having duplicate values for the index key..<br />
<br />
SQLCODE=-803, SQLSTATE=23505<br />
<br />
---<br />
상단과 같은 메시지를 맞닥트리게 되는 경우 아래의 쿼리로 해당 내용을 확인하기 바람.<br />
<br />
SELECT *<br />
FROM SYSCAT.INDEXES<br />
WHERE IID = 1<br />
AND TABSCHEMA = 'schema'<br />
AND TABNAME = 'table_name'<br />
;<br />
<br />
위의 쿼리결과의 COLNAMES, UNIQUERULE 컬럼의 내용을 확인한 뒤, 인덱스가 중복되는지 확인하는 쿼리를 사용하여 점검한다.<br />
<br />
SELECT table_name의 컬럼들, count(*) as qty<br />
from table_name<br />
group by table_name의 컬럼들<br />
having count(*) > 1<br />
order by qty<br />
;<br />
<br />
위의 쿼리 결과에서 나오는 값은 중복된 인덱스를 가진 결과값이므로 해당 데이터를 보정해야 된다.<br />
<div>
<br /></div>
쥬르http://www.blogger.com/profile/10647295127284034724noreply@blogger.com0tag:blogger.com,1999:blog-2207499632603510637.post-23550150090569458552014-03-07T10:36:00.001+09:002014-03-10T08:58:24.254+09:00Spring MVC/ Tomcat] SpringFramework MVC 사용시 view -> controller 로 파라미터 전달시 한글이 깨지는 경우에 해결책.<b>문서작성 참고 : http://springmvc.egloos.com/513986</b><br />
<br />
SpringFramework MVC 사용시 view -> controller 로 파라미터 전달시 한글이 깨지는 경우에 해결책.<br />
<br />
1. HTTP - POST<br />
web.xml 에 CharacterEncodingFilter 를 추가한다.<br />
<filter><br />
<filter-name>encodingFilter</filter-name><br />
<filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class><br />
<init-param><br />
<param-name>encoding</param-name><br />
<param-value>UTF-8</param-value><br />
</init-param><br />
</filter><br />
<filter-mapping><br />
<filter-name>encodingFilter</filter-name><br />
<url-pattern>/*</url-pattern><br />
</filter-mapping><br />
<br />
2. HTTP - GET<br />
Eclipse-tomcat 개발환경에서 한글이 깨지는 경우 tomcat의 server.xml 에 아래 항목에 URIEncoding="UTF-8" 를 추가한다.<br />
*** 아래는 Tomcat 7.x 의 server.xml 기준.<br />
<br />
<!-- Define an AJP 1.3 Connector on port 8009 --><br />
<Connector port="8009" protocol="AJP/1.3" redirectPort="8443" URIEncoding="UTF-8"/><br />
<div>
<br /></div>
<br />
<Connector connectionTimeout="20000" port="8080" protocol="HTTP/1.1" redirectPort="8443" URIEncoding="UTF-8"/>쥬르http://www.blogger.com/profile/10647295127284034724noreply@blogger.com0tag:blogger.com,1999:blog-2207499632603510637.post-79990364936512015342014-01-13T13:36:00.001+09:002014-01-28T09:47:21.338+09:00DB2] DB2에서 특정 컬럼명을 가지고 있는 테이블 리스트 찾기.IBM DB2 에서 특정 컬럼명을 가진 테이블 리스트를 구하는 방법.<br />
<br />
<b>1.</b><br />
<b><i>select * </i></b><br />
<b><i>from syscat.columns </i></b><br />
<b><i>where colname = '확인할컬럼명' -- 컬럼명은 대문자</i></b><br />
<b><i>;</i></b><br />
<div style="-webkit-text-stroke-width: 0px; color: black; font-family: Gulim; font-size: medium; font-style: normal; font-variant: normal; letter-spacing: normal; line-height: normal; margin: 0px; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
<b><i><br /></i></b></div>
<b>2.</b><br />
<b><i>select * </i></b><br />
<b><i>from syscat.columns </i></b><br />
<b><i>where remarks like 'comment한 이름' -- 컬럼명은 대문자</i></b><br />
<b><i>;</i></b><br />
<b><i><br /></i></b>
1. 은 컬럼명을 알 때 사용 가능하고, 2. 는 테이블 생성시 remarks 에 코멘트를 달아 놓은 경우에 해당 작업으로 확인이 가능하다.<br />
<br />
** 해당 스키마를 알면 해당 스키마에서만 찾고자 하는 컬럼명을 사용하는 테이블을 조회가 가능하다.쥬르http://www.blogger.com/profile/10647295127284034724noreply@blogger.com0tag:blogger.com,1999:blog-2207499632603510637.post-26800763231337987652013-12-18T17:53:00.000+09:002017-06-21T17:31:32.184+09:00Mysql/Mariadb] MariaDB 5.5.34 zip 파일 설치하기.mysql 과 쌍둥이 Database 인 MariaDB 설치하기.<br />
<br />
1. mariadb download<br />
https://downloads.mariadb.org 에 접속해서 해당하는 버전을 다운로드(zip 파일)<br />
** 현재 안정화 버전은 5.5.34(mysql 5.5에 대응) , 베타버전은 10.6 beta(mysql 5.6에 대응)를 테스트 중.<br />
<br />
2. download 된 zip 파일을 압축해제 한다.<br />
<br />
3. 압축이 풀린 디렉토리를 설치하고자 하는 곳으로 옮긴다.<br />
ex) c:\maraidb-5.5.34<br />
<br />
4. my-innodb-heavy-4G.ini 을 my.ini로 복사<br />
<br />
5. my.ini 파일 편집<br />
<br />
[client]<br />
<br />
default-character-set = utf8<br />
<br />
[mysqld]<br />
init_connect = SET collation_connection = utf8_general_ci<br />
init_connect = SET NAMES utf8<br />
character-set-server = utf8<br />
collation-server = utf8_general_ci<br />
<br />
<br />
<br />
# innodb<br />
<br />
innodb_data_home_dir = "c:/maraidb-5.5.34/data/"<br />
<br />
<br />
[mysqldump]<br />
default-character-set = utf8<br />
<br />
<br />
<br />
<br />
[mysql]<br />
default-character-set = utf8<br />
<br />
5. mysql 실행<br />
c:/maraidb-5.5.34/bin/mysqld<br />
<br />
<br />
** mysql을 윈도우 서비스로 등록<br />
<br />
mysqld --install 서비스명.<br />
<br />
<br />
6. mysql 에 root user로 접속<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>c:/maraidb-5.5.34/bin>mysql -u root -p<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>Enter password: <== 엔터키 입력하고 넘어간다<br />
<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.<br />
<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>MariaDB [(none)]> use mysql<span class="Apple-tab-span" style="white-space: pre;"> </span><== db 변경<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>Database changed<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
7.<span class="Apple-tab-span" style="white-space: pre;"> </span>mysql DB의 user 테이블의 내용 확인<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>MariaDB [mysql]> desc user;<span class="Apple-tab-span" style="white-space: pre;"> </span><== user 테이블의 구조 확인<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
8. <span class="Apple-tab-span" style="white-space: pre;"> </span>root user의 비밀번호 변경 및 적용<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>MariaDB [mysql]> update user set password=password('변경할비밀번호') where user='root'; <== 비번 변경<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>Query OK, 3 rows affected (0.00 sec)<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>Rows matched: 3 Changed: 3 Warnings: 0<br />
<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>MariaDB [mysql]> flush privileges;<span class="Apple-tab-span" style="white-space: pre;"> </span><== 적용<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>Query OK, 0 rows affected (0.00 sec)<br />
<div>
<br /></div>
쥬르http://www.blogger.com/profile/10647295127284034724noreply@blogger.com0tag:blogger.com,1999:blog-2207499632603510637.post-3771726158226881822013-12-03T17:12:00.000+09:002013-12-03T17:12:53.759+09:00javascript/SmartClient] RichTextEditor 사용하기.RichTextEditor를 사용하기 위해서는 아래와 같은 선언문을 포함한 뒤.<br />
<br />
<SCRIPT SRC=isomorphic/system/modules/ISC_RichTextEditor.js></SCRIPT><SCRIPT>isc._lastModule='RichTextEditor';</SCRIPT><br />
<br />
------------<br />
<br />
isc.VLayout.create({<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span> membersMargin:5,<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span> members:[<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span> isc.RichTextEditor.create({<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span> autoDraw:false,<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span> ID:"contentEditor",<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span> height:155,<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span> <br />
<span class="Apple-tab-span" style="white-space: pre;"> </span> overflow:"hidden",<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span> canDragResize:true, showEdges:true,<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span> // Standard control group options include<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span> // "fontControls", "formatControls", "styleControls" and "colorControls"<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span> controlGroups:["fontControls", "formatControls", "styleControls", "colorControls"],<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span> value:''<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span> })<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span> ]<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>});<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
와 같이 선언을 하여 사용한다.<br />
<br />
(참조 URL : <a href="http://www.smartclient.com/docs/9.0/a/system/reference/SmartClient_Explorer.html#RichTextEditor">http://www.smartclient.com/docs/9.0/a/system/reference/SmartClient_Explorer.html#RichTextEditor</a><br />
)<br />
<br />
위의 RichTextEditor 를 DynamicForm 에 붙여서 사용하기 위해서는<br />
DynamicForm에서 사용하고자 하는 field의 타입을 'canvas'로 선언해서 사용하면 된다.<br />
<br />
추가적으로 해당 RichTextEditor 에서 사용하고자 하는 font를 더 추가하고자 하는 경우,<br />
<br />
isomorphic/system/modules/ISC_RichTextEditor.js 파일의 82 line부근의 fontControls이 정의된 곳에 추가하고자 하는 Font 를 추가하면 된다.<br />
추가하는 형식은 "font":"font 라벨(콤보에 표시되는 값)" 으로 "," 로 구분하여 추가하면 된다.쥬르http://www.blogger.com/profile/10647295127284034724noreply@blogger.com0tag:blogger.com,1999:blog-2207499632603510637.post-54755949502576772082013-10-27T22:09:00.001+09:002013-10-27T22:09:14.561+09:00재부도 전경<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg6SpUjN095V9EMHAVc2SVS9VSY97Ya6n5wxW1jpXlkfeYy2ZiScwoX_1b1R_D40qhlrv_C-jiJzPv_iBPB53uqkvsTw3sr6GGSjWRtMn7jZ688ebo7uc80Zpges6MpNLIjBykoSSm_xXs/s1600/CAM00285.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg6SpUjN095V9EMHAVc2SVS9VSY97Ya6n5wxW1jpXlkfeYy2ZiScwoX_1b1R_D40qhlrv_C-jiJzPv_iBPB53uqkvsTw3sr6GGSjWRtMn7jZ688ebo7uc80Zpges6MpNLIjBykoSSm_xXs/s1600/CAM00285.jpg" height="78" width="320" /></a></div>
<br />
주말에 간 제부도전경. (파노라마 사진).<br />
시원하고 좋은 날...<br />
좋았다..쥬르http://www.blogger.com/profile/10647295127284034724noreply@blogger.com0tag:blogger.com,1999:blog-2207499632603510637.post-65066624890812705622013-10-25T10:09:00.003+09:002014-01-06T14:22:29.845+09:00DB2] DB2 에서 Assignment of a NULL value to a NOT NULL column 의 오류 발생시DB2 로 프로그램 개발시 ,<br />
Assignment of a NULL value to a NOT NULL column 메시지와 함께<br />
"TBSPACEID=XX, TABLEID=XX, COLNO=XX" 라는 오류 메시지를 받게 되는 경우 아래의 방법으로 확인가능.<br />
<br />
1.<br />
<b><i>select * from syscat.tables </i></b><br />
<b><i>where tableid = xx </i></b><br />
<b><i>;</i></b><br />
<br />
로 해당 테이블 명을 확인.<br />
<br />
2.<br />
<b><i>select * </i></b><br />
<b><i>from syscat.columns </i></b><br />
<b><i>where tabname = '확인한 테이블명'</i></b><br />
<b><i>and colno = xx;</i></b><br />
<div>
<br /></div>
<div>
로 해당 컬럼을 확인하여 조치를 취할 수 있다. </div>
<div>
<br /></div>
<div>
** 참조 사이트 : <a href="http://www.dbforums.com/db2/1658501-ql0407n-assignment-null-value-not-null-column-tbspaceid-8-tableid-2580-a.html">http://www.dbforums.com/db2/1658501-ql0407n-assignment-null-value-not-null-column-tbspaceid-8-tableid-2580-a.html</a></div>
쥬르http://www.blogger.com/profile/10647295127284034724noreply@blogger.com0tag:blogger.com,1999:blog-2207499632603510637.post-15405310640687411152013-09-25T13:27:00.000+09:002013-09-25T13:27:06.736+09:00excel export 시에 chr(10)으로 line break 삽입시 cell wrap이 먹게 하는 방법.excel export 시에 chr(10)으로 line break 삽입시 다운로드 된 excel 파일을 열면 라인이 안 바뀌어 보이는 현상이 발생할 수 있다.<br />
<br />
그럴때 cell 내에서 라인이 바뀌어 보이게 처리하기 위해서는 아래의 방법으로 처리하면 된다.<br />
<br />
HSSFWorkbook wb = new HSSFWorkbook();<br />
<br />
<b>CellStyle cs = wb.createCellStyle();</b><br />
<b>cs.setWrapText( true );</b><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
cell.setCellStyle( cs );<br />
<div>
<br />
즉, cellStyle의 wrapText 속성을 true로 설정하여 대입하면 된다는 얘기.</div>
쥬르http://www.blogger.com/profile/10647295127284034724noreply@blogger.com0tag:blogger.com,1999:blog-2207499632603510637.post-29423625759784960442013-09-05T10:54:00.005+09:002013-12-04T10:04:22.910+09:00DB2] Alter table ... drop column보통 DB에서 alter table 작업은 다음과 같이 한다.<br />
<div>
<br /></div>
<div>
<b><i>alter table table_name </i></b></div>
<div>
<b><i>drop column column </i></b></div>
<div>
<b><i>;</i></b></div>
<div>
<br /></div>
<div>
위의 문장은 table_name 의 column 컬럼을 제거하겠다는 명령이다. </div>
<div>
<br /></div>
<div>
하지만 db2에서 위 명령을 실행한 후, </div>
<div>
<br /></div>
<div>
<b><i>select * from table_name; </i></b></div>
<div>
<br /></div>
<div>
명령을 실행하면 </div>
<div>
<br /></div>
<div>
SQL0668N Operation not allowed for reason code "7"</div>
<div>
<br /></div>
<div>
과 같은 오류를 발생시키면서 select 쿼리를 실행하지 못한다. </div>
<div>
<br /></div>
<div>
<br /></div>
<div>
이런 경우, </div>
<div>
<br /></div>
<div>
<b><i>reorg table table_name ;</i></b></div>
<div>
<br /></div>
<div>
을 실행하면 위의 오류가 해결 된다.<br />
<br />
***<br />
column 추가<br />
==><br />
alter table table_name<br />
add column column_name data_type ;<br />
<br />
<br />
column 명 변경<br />
==><br />
alter table table_name<br />
alter column column_name_org<br />
set default 'modified_column_name' ;<br />
<br />
pk 삭제<br />
==><br />
alter table table_name<br />
drop primary key<br />
<br />
pk 추가<br />
==><br />
alter table table_name<br />
add primary key field_name<br />
<br />
column 의 data type 변경<br />
==><br />
alter table table_name<br />
alter column column_name<br />
set data type 변경할 데이터 타입.<br />
<br />
<br />
=========================================<br />
<br />
pk 변경하기 위한 작업절차<br />
<br />
<br />
-- pk 에 추가할 컬럼 생성. (pk 이기 때문에 not null 로 생성해야 됨)<br />
alter table <테이블명><br />
add column <컬럼명> <데이터타입> not null default 1<br />
;<br />
<br />
-- 테이블 데이터 확인.<br />
select *<br />
from <테이블명><br />
;<br />
<br />
commit;<br />
<br />
-- reorg 작업.<br />
reorg table <테이블명> ;<br />
<br />
-- pk 제거<br />
ALTER TABLE <테이블명><br />
drop PRIMARY KEY<br />
; <br />
<br />
-- pk 재생성<br />
ALTER TABLE <테이블명><br />
ADD PRIMARY KEY<br />
(pk 컬럼1, pk 컬럼2, ... , pk 컬럼N )<br />
;<br />
<br />
<br />
<br />
CREATE SEQUENCE <Sequence명><br />
AS INTEGER<br />
START WITH 1<br />
CACHE 20<br />
ORDER<br />
;</div>
<div>
<br /></div>
<div>
<br /></div>
<div>
---- </div>
<div>
sequence 삭제</div>
<div>
drop SEQUENCE <Sequence명></div>
<div>
<br /></div>
쥬르http://www.blogger.com/profile/10647295127284034724noreply@blogger.com1tag:blogger.com,1999:blog-2207499632603510637.post-8959224031158268292013-08-08T15:27:00.001+09:002013-08-08T15:27:10.026+09:00javascript/eclipse] eclipse 에서 'Requesting JavaScript AST from selection' has encountered a problem' 오류 발생시 해결방법.<span class="f" style="background-color: white; color: #666666; font-family: dotum, arial, sans-serif; font-size: 12px; line-height: 14px;">eclipse로 작업중에 </span><span style="background-color: white; color: #444444; font-family: dotum, arial, sans-serif; font-size: 12px; line-height: 14px;">'</span><span style="background-color: white; color: #444444; font-family: dotum, arial, sans-serif; font-size: 12px; font-weight: bold; line-height: 14px;">Requesting JavaScript AST from selection</span><span style="background-color: white; color: #444444; font-family: dotum, arial, sans-serif; font-size: 12px; line-height: 14px;">' </span><span style="background-color: white; color: #444444; font-family: dotum, arial, sans-serif; font-size: 12px; font-weight: bold; line-height: 14px;">has encountered a problem</span><span style="background-color: white; color: #444444; font-family: dotum, arial, sans-serif; font-size: 12px; line-height: 14px;">.' 발생하면 다음과 같이 하면 문제가 해결 될 것이다.</span><br />
<span style="background-color: white; color: #444444; font-family: dotum, arial, sans-serif; font-size: 12px; line-height: 14px;">(Eclipse JSDT 의 버그가 원인)</span><br />
<span style="background-color: white; color: #444444; font-family: dotum, arial, sans-serif; font-size: 12px; line-height: 14px;"><br /></span>
<span style="background-color: white; color: #444444; font-family: dotum, arial, sans-serif; font-size: 12px; line-height: 14px;">- eclipse 메뉴 :: Window -> Preference -> Javascript -> Editor -> Mark Occurences -> Mark occurences of the selected element in the current file 항목의 체크 해지</span><br />
<span style="background-color: white; color: #444444; font-family: dotum, arial, sans-serif; font-size: 12px; line-height: 14px;"><br /></span>쥬르http://www.blogger.com/profile/10647295127284034724noreply@blogger.com0tag:blogger.com,1999:blog-2207499632603510637.post-61962118129104978682013-07-31T08:44:00.001+09:002013-07-31T08:49:51.332+09:00춘천의 한 펜션에서 아침에 바라본 물안개가 드리운 북한강변<div dir="ltr">
춘천의 한 펜션에서 아침에 바라본 물안개가 드리운 북한강변.</div>
<div dir="ltr">
<br /></div>
<div dir="ltr">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgoZWHzgf3uHrF0PxOKpUWfaJ34600CtKZqM8Hk-xSaSJwVtHf_uG0srTVE2N1yLE6HkrYpEORjN0IPFHZZDDNCGhtlMQoH2c9wCanG24Vg8m6OXnoflCDvxaa-jgGGPXV6_0jqF9seQiQ/s1600/CAM00142.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"> <img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgoZWHzgf3uHrF0PxOKpUWfaJ34600CtKZqM8Hk-xSaSJwVtHf_uG0srTVE2N1yLE6HkrYpEORjN0IPFHZZDDNCGhtlMQoH2c9wCanG24Vg8m6OXnoflCDvxaa-jgGGPXV6_0jqF9seQiQ/s640/CAM00142.jpg" /> </a> </div>
쥬르http://www.blogger.com/profile/10647295127284034724noreply@blogger.com0