CoolDragon's Development World

npm install mysql

var mysql = require("mysql");

var mysqlConfig = {

    host : "아이피",

    port : "포트",

    user : "로그인ID",

    password : "비밀번호",

    database : "데이터베이스명"

}

var conn = mysql.createConnection(mysqlConfig);

conn.query("CALL 프로시저명(?, ?);", [인자1, 인자2], function(err, rows) {

    if (err) {

        console.log("MySQL Query Execution Failed....");

        console.log(err);

    }

    for (var i = 0; i < rows[0].length; i++) {

        console.log(rows[0][i]);

    }

    conn.destroy();

});

---------------------------------------------------------------------------------------------------------------

// OUTPUT 인자 가져오기

conn.query("CALL 프로시저명(?, ?, @id);", [인자1, 인자2], function(err, rows) {

    if (err) {

        console.log("MySQL Query Execution Failed....");

        console.log(err);

    } else {

        conn.query("SELECT @id;", function(err, rows, field) {

            console.log('id is ' + rows[0]['@id']);

            conn.destroy();

        });

    }

});

DELIMITER //

DROP PROCEDURE IF EXISTS sp_UserInfo_Select_All //

CREATE PROCEDURE sp_UserInfo_Select_All( )

BEGIN

    SELECT *

      FROM UserInfo;

END//

DELIMITER ;

DELIMITER //

DROP PROCEDURE IF EXISTS sp_UserInfo_Select //

CREATE PROCEDURE sp_UserInfo_Select

(

    pi_UserID INT

)

BEGIN

    SELECT *

      FROM UserInfo

     WHERE UserID = pi_UserID;      

END//

DELIMITER ;

DELIMITER //

DROP PROCEDURE IF EXISTS sp_UserInfo_Insert //

CREATE PROCEDURE sp_UserInfo_Insert

(

    pi_UserName VARCHAR(20)

    ,OUT po_UserID INT

)

BEGIN

    INSERT INTO UserInfo (UserName)

    VALUES (pi_UserName);

    -- Auto Increment 값 조회

    SELECT LAST_INSERT_ID()

      INTO po_UserID; -- OUT 파라메터 담기

END//

DELIMITER ;

DELIMITER //

DROP PROCEDURE IF EXISTS sp_UserInfo_Update //

CREATE PROCEDURE sp_UserInfo_Update

(

    pi_UserID INT

    , pi_UserName VARCHAR(20)

)

BEGIN

    UPDATE UserInfo

       SET UserName = pi_UserName

     WHERE UserID = pi_UserID;

END//

DELIMITER ;

DELIMITER //

DROP PROCEDURE IF EXISTS sp_UserInfo_Delete //

CREATE PROCEDURE sp_UserInfo_Delete

(

    pi_UserID INT

)

BEGIN

    DELETE FROM UserInfo

     WHERE UserID = pi_UserID;

END//

DELIMITER ;

CALL sp_UserInfo_Select_All();

CALL sp_UserInfo_Select(1);

CALL sp_UserInfo_Insert('Park', @UserID);

SELECT @UserID

CALL sp_UserInfo_Insert('Choi', @UserID);

SELECT @UserID

CALL sp_UserInfo_Insert('bahk', @UserID);

SELECT @UserID

CALL sp_UserInfo_Select(2);

CALL sp_UserInfo_Update(2, 'Choi-Update');

CALL sp_UserInfo_Select(2);

CALL sp_UserInfo_Delete(2);

CALL sp_UserInfo_Select_All();

> node -v

> node --version

> npm --version

# vi /etc/sysconfig/iptables (방화벽 설정 파일 편집)

-A RH-Firewall-1-INPUT -m state --state NEW -m tcp -p tcp --dport 22 -j ACCEPT (를 추가하면 22 포트 방화벽 사용)

# /etc/init.d/iptables restart  (포트 변경후 재시작)

> sudo ufw enable # file enable

> sudo ufw allow ssh # open ssh port

> sudo ufw allow 4444/tcp      # tcp 80 port open

> sudo ufw allow 80/tcp          # tcp 80 port open

> sudo ufw show added           # show the list of what user added on filewall

[param.js]

var env = process.argv[2] || 'dev';

console.log(env); // 파라메터 사용

console.log(process.env.NODE_ENV); // 환경변수

public static XDocument Serialize<T>(this T source)

{

var ser = new XmlSerializer(source.GetType());

var sb = new StringBuilder();

using (var writer = new StringWriter(sb))

{

ser.Serialize(writer, source);

}

return XDocument.Parse(sb.ToString());

}

      public static T Deserialize<T>(this XDocument xmlDocument)

      {

          var xmlSerializer = new XmlSerializer(typeof(T));

          using (var reader = xmlDocument.CreateReader())

              return (T)xmlSerializer.Deserialize(reader);

      }

var express = require('express'),
    app     = express(),
    port    = 8080;

app.configure(function(){
	app.use(express.bodyParser());
});

app.post('/', function(req, res){
	console.log(req.body.);
	res.send({ status: 'SUCCESS' });
})

app.listen(port);