오늘도 삽질하는 두 남자

CASE - 이전 글에서 다뤘던 DECODE와 같은 용도로 사용한다.- Oracle 8.1.7 버전부터 지원한다. - java의 switch-case문과 비슷한 형태를 가지고 있다.- DECODE 보다 가독성이 좋다고 생각한다. SQL > SELECT name, deptno, sal, CASE WHEN deptno = 101 THEN sal * 0.1 WHEN deptno = 102 THEN sal * 0.2 WHEN deptno = 201 THEN sal * 0.3 ELSE 0 END bonusFROM professor; RESULT >

DECODE - Oracle에서 DECODE는 조건에 맞는 다른 값이나 컬럼값으로 추출할 때 사용한다.- DECODE(value, if1, then1, if2, then2, ........ ,else)의 형태이다.- value의 값이 if1이면 then1의 값을 리턴하고, 모든 조건에 맞이 않으면 else를 리턴한다. SQL> SELECT name, deptno, DECODE(deptno, 101, '컴퓨터공학과', 102, '멀티미디어학과', 201, '전자공학과', '기계공학과') DNAMEFROM professor; RESULT >

doctype htmlhtml head meta(charset='utf-8') title script(type='text/javascript' src="https://code.jquery.com/jquery-3.2.1.min.js") link(rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css" integrity="sha384-BVYiiSIFeK1dGmJRAkycuHAHRg32OmUcww7on3RYdg4Va+PmSTsz/K68vbdEjh4u" crossorigin="anonymous") body div(class = "container") div(class = 'row') div(class ..

doctype htmlhtml head meta(charset='utf-8') title script(type='text/javascript' src="https://code.jquery.com/jquery-3.2.1.min.js") link(rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css" integrity="sha384-BVYiiSIFeK1dGmJRAkycuHAHRg32OmUcww7on3RYdg4Va+PmSTsz/K68vbdEjh4u" crossorigin="anonymous") body div(class = "container") div(class = 'row') div(class ..

doctype htmlhtml head title meta(charset='utf-8') script(type='text/javascript' src="https://code.jquery.com/jquery-3.2.1.min.js") link(rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css" integrity="sha384-BVYiiSIFeK1dGmJRAkycuHAHRg32OmUcww7on3RYdg4Va+PmSTsz/K68vbdEjh4u" crossorigin="anonymous") body div(class='container') div(class = 'row') div(class = ..

doctype htmlhtml head meta(charset='utf-8') title Workloud script(type='text/javascript' src="https://code.jquery.com/jquery-3.2.1.min.js") link(rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css" integrity="sha384-BVYiiSIFeK1dGmJRAkycuHAHRg32OmUcww7on3RYdg4Va+PmSTsz/K68vbdEjh4u" crossorigin="anonymous") script. $(document).on('click', '#isCompleted', fu..

doctype htmlhtml head meta(charset='utf-8') title script(type='text/javascript' src="https://code.jquery.com/jquery-3.2.1.min.js") link(rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css" integrity="sha384-BVYiiSIFeK1dGmJRAkycuHAHRg32OmUcww7on3RYdg4Va+PmSTsz/K68vbdEjh4u" crossorigin="anonymous") script. function idcheck_1(){ var id = $('.id').val(); docu..

doctype htmlhtml head meta(charset='utf-8') title script(type='text/javascript' src="https://code.jquery.com/jquery-3.2.1.min.js") link(rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css" integrity="sha384-BVYiiSIFeK1dGmJRAkycuHAHRg32OmUcww7on3RYdg4Va+PmSTsz/K68vbdEjh4u" crossorigin="anonymous") script(type='text/javascript' src="http://code.jquery.com/j..

doctype htmlhtml head meta(charset='utf-8') script(type='text/javascript' src="https://code.jquery.com/jquery-3.2.1.min.js") link(rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.2/css/bootstrap.min.css") meta(name="viewport" content="width=device-width, initial-scale=1") title WORKLOUD body div(class = "container") div(class = "row") h2 WORKLOUD legend div(class = "col-md-3"..

var express = require('express');var bodyParser = require('body-parser');var session = require('express-session');var mysql = require('mysql');var MySqlStore = require('express-mysql-session')(session);var multer = require('multer');var fs = require('fs')var html = require('html');var storage = multer.diskStorage({ destination: function (req, file, cb) { cb(null, 'uploads/'); }, filename: functi..