집착남의 이야기

http://www.chiark.greenend.org.uk/~sgtatham/putty/download.html 에서

1. A Windows installer for everything except PuTTYtel 다운

2. Putty 설치 경로 가서 puttyge.exe 실행

3. Generate 

4. Save private key

5. Putty 실행 후 Connection - SSH - Auth - Private Key file for authentication에 4번에서 생성한 키 입력

6. Session에 접속 정보 입력

필요한 권한을 AndroidManifest.xml에 추가해서 사용

Permission for all apps

<uses-permission android:name="android.permission.ACCESS_COARSE_LOCATION" />
<uses-permission android:name="android.permission.ACCESS_FINE_LOCATION" />
<uses-permission android:name="android.permission.ACCESS_LOCATION_EXTRA_COMMANDS" />
<uses-permission android:name="android.permission.ACCESS_MOCK_LOCATION" />
<uses-permission android:name="android.permission.ACCESS_NETWORK_STATE" />
<uses-permission android:name="android.permission.ACCESS_WIFI_STATE" />
<uses-permission android:name="android.permission.ADD_VOICEMAIL" />
<uses-permission android:name="android.permission.AUTHENTICATE_ACCOUNTS" />
<uses-permission android:name="android.permission.BATTERY_STATS" />
<uses-permission android:name="android.permission.BIND_ACCESSIBILITY_SERVICE" />
<uses-permission android:name="android.permission.BIND_NOTIFICATION_LISTENER_SERVICE" />
<uses-permission android:name="android.permission.BLUETOOTH" />
<uses-permission android:name="android.permission.BLUETOOTH_ADMIN" />
<uses-permission android:name="android.permission.BROADCAST_STICKY" />
<uses-permission android:name="android.permission.CALL_PHONE" />
<uses-permission android:name="android.permission.CAMERA" />
<uses-permission android:name="android.permission.CHANGE_CONFIGURATION" />
<uses-permission android:name="android.permission.CHANGE_NETWORK_STATE" />
<uses-permission android:name="android.permission.CHANGE_WIFI_MULTICAST_STATE" />
<uses-permission android:name="android.permission.CHANGE_WIFI_STATE" />
<uses-permission android:name="android.permission.CLEAR_APP_CACHE" />
<uses-permission android:name="android.permission.DISABLE_KEYGUARD" />
<uses-permission android:name="android.permission.EXPAND_STATUS_BAR" />
<uses-permission android:name="android.permission.FLASHLIGHT" />
<uses-permission android:name="android.permission.GET_ACCOUNTS" />
<uses-permission android:name="android.permission.GET_PACKAGE_SIZE" />
<uses-permission android:name="android.permission.GET_TASKS" />
<uses-permission android:name="android.permission.GET_TOP_ACTIVITY_INFO" />
<uses-permission android:name="android.permission.INTERNET" />
<uses-permission android:name="android.permission.KILL_BACKGROUND_PROCESSES" />
<uses-permission android:name="android.permission.LOCATION_HARDWARE" />
<uses-permission android:name="android.permission.MANAGE_ACCOUNTS" />
<uses-permission android:name="android.permission.MODIFY_AUDIO_SETTINGS" />
<uses-permission android:name="android.permission.MOUNT_FORMAT_FILESYSTEMS" />
<uses-permission android:name="android.permission.MOUNT_UNMOUNT_FILESYSTEMS" />
<uses-permission android:name="android.permission.NFC" />
<uses-permission android:name="android.permission.PERSISTENT_ACTIVITY" />
<uses-permission android:name="android.permission.PROCESS_OUTGOING_CALLS" />
<uses-permission android:name="android.permission.READ_CALENDAR" />
<uses-permission android:name="android.permission.READ_CALL_LOG" />
<uses-permission android:name="android.permission.READ_CONTACTS" />
<uses-permission android:name="android.permission.READ_EXTERNAL_STORAGE" />
<uses-permission android:name="android.permission.READ_HISTORY_BOOKMARKS" />
<uses-permission android:name="android.permission.READ_LOGS" />
<uses-permission android:name="android.permission.READ_PHONE_STATE" />
<uses-permission android:name="android.permission.READ_PROFILE" />
<uses-permission android:name="android.permission.READ_SMS" />
<uses-permission android:name="android.permission.READ_SOCIAL_STREAM" />
<uses-permission android:name="android.permission.READ_SYNC_SETTINGS" />
<uses-permission android:name="android.permission.READ_SYNC_STATS" />
<uses-permission android:name="android.permission.READ_USER_DICTIONARY" />
<uses-permission android:name="android.permission.RECEIVE_BOOT_COMPLETED" />
<uses-permission android:name="android.permission.RECEIVE_MMS" />
<uses-permission android:name="android.permission.RECEIVE_SMS" />
<uses-permission android:name="android.permission.RECEIVE_WAP_PUSH" />
<uses-permission android:name="android.permission.RECORD_AUDIO" />
<uses-permission android:name="android.permission.REORDER_TASKS" />
<uses-permission android:name="android.permission.RESTART_PACKAGES" />
<uses-permission android:name="android.permission.SEND_RESPOND_VIA_MESSAGE" />
<uses-permission android:name="android.permission.SEND_SMS" />
<uses-permission android:name="android.permission.SET_ALARM" />
<uses-permission android:name="android.permission.SET_ALWAYS_FINISH" />
<uses-permission android:name="android.permission.SET_ANIMATION_SCALE" />
<uses-permission android:name="android.permission.SET_DEBUG_APP" />
<uses-permission android:name="android.permission.SET_PROCESS_LIMIT" />
<uses-permission android:name="android.permission.SET_TIME_ZONE" />
<uses-permission android:name="android.permission.SET_WALLPAPER" />
<uses-permission android:name="android.permission.SET_WALLPAPER_HINTS" />
<uses-permission android:name="android.permission.SIGNAL_PERSISTENT_PROCESSES" />
<uses-permission android:name="android.permission.SUBSCRIBED_FEEDS_READ" />
<uses-permission android:name="android.permission.SUBSCRIBED_FEEDS_WRITE" />
<uses-permission android:name="android.permission.SYSTEM_ALERT_WINDOW" />
<uses-permission android:name="android.permission.USE_CREDENTIALS" />
<uses-permission android:name="android.permission.USE_SIP" />
<uses-permission android:name="android.permission.VIBRATE" />
<uses-permission android:name="android.permission.WAKE_LOCK" />
<uses-permission android:name="android.permission.WRITE_CALENDAR" />
<uses-permission android:name="android.permission.WRITE_CALL_LOG" />
<uses-permission android:name="android.permission.WRITE_CONTACTS" />
<uses-permission android:name="android.permission.WRITE_EXTERNAL_STORAGE" />
<uses-permission android:name="android.permission.WRITE_HISTORY_BOOKMARKS" />
<uses-permission android:name="android.permission.WRITE_PROFILE" />
<uses-permission android:name="android.permission.WRITE_SETTINGS" />
<uses-permission android:name="android.permission.WRITE_SMS" />
<uses-permission android:name="android.permission.WRITE_SOCIAL_STREAM" />
<uses-permission android:name="android.permission.WRITE_SYNC_SETTINGS" />
<uses-permission android:name="android.permission.WRITE_USER_DICTIONARY" />

Permission is only granted to system apps

<uses-permission android:name="android.permission.ACCESS_CHECKIN_PROPERTIES" />
<uses-permission android:name="android.permission.ACCESS_SURFACE_FLINGER" />
<uses-permission android:name="android.permission.ACCOUNT_MANAGER" />
<uses-permission android:name="android.permission.BIND_APPWIDGET" />
<uses-permission android:name="android.permission.BIND_DEVICE_ADMIN" />
<uses-permission android:name="android.permission.BIND_INPUT_METHOD" />
<uses-permission android:name="android.permission.BIND_REMOTEVIEWS" />
<uses-permission android:name="android.permission.BIND_TEXT_SERVICE" />
<uses-permission android:name="android.permission.BIND_VPN_SERVICE" />
<uses-permission android:name="android.permission.BIND_WALLPAPER" />
<uses-permission android:name="android.permission.BRICK" />
<uses-permission android:name="android.permission.BROADCAST_PACKAGE_REMOVED" />
<uses-permission android:name="android.permission.BROADCAST_SMS" />
<uses-permission android:name="android.permission.BROADCAST_WAP_PUSH" />
<uses-permission android:name="android.permission.CALL_PRIVILEGED" />
<uses-permission android:name="android.permission.CHANGE_COMPONENT_ENABLED_STATE" />
<uses-permission android:name="android.permission.CLEAR_APP_USER_DATA" />
<uses-permission android:name="android.permission.CONTROL_LOCATION_UPDATES" />
<uses-permission android:name="android.permission.DELETE_CACHE_FILES" />
<uses-permission android:name="android.permission.DELETE_PACKAGES" />
<uses-permission android:name="android.permission.DEVICE_POWER" />
<uses-permission android:name="android.permission.DIAGNOSTIC" />
<uses-permission android:name="android.permission.DUMP" />
<uses-permission android:name="android.permission.FACTORY_TEST" />
<uses-permission android:name="android.permission.FORCE_BACK" />
<uses-permission android:name="android.permission.GLOBAL_SEARCH" />
<uses-permission android:name="android.permission.HARDWARE_TEST" />
<uses-permission android:name="android.permission.INJECT_EVENTS" />
<uses-permission android:name="android.permission.INSTALL_LOCATION_PROVIDER" />
<uses-permission android:name="android.permission.INSTALL_PACKAGES" />
<uses-permission android:name="android.permission.INTERNAL_SYSTEM_WINDOW" />
<uses-permission android:name="android.permission.MANAGE_APP_TOKENS" />
<uses-permission android:name="android.permission.MASTER_CLEAR" />
<uses-permission android:name="android.permission.MODIFY_PHONE_STATE" />
<uses-permission android:name="android.permission.READ_FRAME_BUFFER" />
<uses-permission android:name="android.permission.READ_INPUT_STATE" />
<uses-permission android:name="android.permission.REBOOT" />
<uses-permission android:name="android.permission.SET_ACTIVITY_WATCHER" />
<uses-permission android:name="android.permission.SET_ORIENTATION" />
<uses-permission android:name="android.permission.SET_POINTER_SPEED" />
<uses-permission android:name="android.permission.SET_PREFERRED_APPLICATIONS" />
<uses-permission android:name="android.permission.SET_TIME" />
<uses-permission android:name="android.permission.STATUS_BAR" />
<uses-permission android:name="android.permission.UPDATE_DEVICE_STATS" />
<uses-permission android:name="android.permission.WRITE_APN_SETTINGS" />
<uses-permission android:name="android.permission.WRITE_GSERVICES" />
<uses-permission android:name="android.permission.WRITE_SECURE_SETTINGS" />

커맨드창에서 C:\Program Files\Java\jdk1.8.0_45\bin까지 이동 후

keytool -list -v -keystore c:\users\사용자명\.android\debug.keystore -alias androiddebugkey -storepass android -keypass android

입력.

예를들어

C:\Program Files\Java\jdk1.8.0_45\bin>keytool -list -v -keystore c:\users\JBY\.android\debug.keystore -alias androiddebugkey -storepass android -keypass android

그러면 SHA1 : 부분에 키값이 나오고 이걸 복사해서 등록 

1. 현재 날짜,시간과 미래 날짜, 시간

 
SELECT
                SYSDATE "현재 날짜"
                --TRUNC(SYSDATE) : 시/분/초 를 제외한 연,월,일만 나타냄
                ,TRUNC(SYSDATE) "TRUNC()_현재날짜"
                ,(SYSDATE + 1 / 1440 * 10) "10분 후"
                ,(SYSDATE + 1 / 1440 * 60) "60분 후"
                ,(SYSDATE + 7) "7일후 같은시간"                
                ,TRUNC(SYSDATE + 7) "TRUNC()_7일후"
                ,(SYSDATE + 1) + 6 / 24 "1일 6시간 후"
                ,(SYSDATE + 1) + 18 / 24 "1일 18시간 후"
                ,TRUNC(SYSDATE + 1) + 6 / 24 "1일 후의 6:00"
                ,TRUNC(SYSDATE + 7) + 18 / 24 "7일 후의 18:00"
            FROM DUAL;

결과화면(클릭하시면 확대됩니다.)

2. 현재 날짜,시간과 과거 날짜, 시간

 
SELECT
                SYSDATE "현재 날짜"
                --TRUNC(SYSDATE) : 시/분/초 를 제외한 연,월,일만 나타냄
                ,TRUNC(SYSDATE) "TRUNC()_현재날짜"
                ,(SYSDATE - 1 / 1440 * 10) "10분 전"
                ,(SYSDATE - 1 / 1440 * 60) "60분 전"
                ,(SYSDATE - 7) "7일전 같은시간"                
                ,TRUNC(SYSDATE - 7) "TRUNC()_7일전"
                ,(SYSDATE - 1) - 6 / 24 "1일 6시간 전"
                ,(SYSDATE - 1) - 18 / 24 "1일 18시간 전"
                ,TRUNC(SYSDATE - 1) - 6 / 24 "1일 전의 6:00"
                ,TRUNC(SYSDATE - 7) - 18 / 24 "7일 전의 18:00"
            FROM DUAL;

결과화면(클릭하시면 확대됩니다.)

3.

 
--현재 달의 첫날을 시/분/초를 제외한 형식으로 나타냄
SELECT TRUNC(SYSDATE,'MONTH') "현재달의 첫날" FROM DUAL;

결과화면

4.

 
--현재 달의 첫날을 YYYY-MM-DD-HH24-MI-SS 형식으로 나타냄
SELECT TO_CHAR(TRUNC(SYSDATE,'MONTH'),'YYYY-MM-DD-HH24-MI-SS') "현재달의 첫날" FROM DUAL;

결과화면

5.

 
--현재 년도의 첫날을 시/분/초를 제외한 형식으로 나타냄
SELECT TRUNC(SYSDATE,'YEAR') "현재년도의 첫날" FROM DUAL;

결과화면

 
SELECT COLUMN AS NAME FROM TABLE;
SELECT COLUMN "NAME" FROM TABLE;

 
Event.observe(window,'load',initPage);

 
f.contents.value = 값;

 
f.elements["contents"].value = 값;

 
f.contents.value = document.getElementById("contents1").innerHTML+"추가";

${lectureInfo.stdcnt}

<%@ taglib uri="jstl_c_tag" prefix="c" %><%@ page isELIgnored="false" %>