tblUser

var mysql = require('mysql');
var connection = mysql.createConnection({
    host: 'localhost',
    user: 'root',
    password: '',
    database: "projectuas_android"
});
module.exports = function(app){
    app.post("/tblUser",function(req,res){
        var postBody = req.body;
        var id = postBody.id;
        var nama = postBody.nama;
        var passwords = postBody.pass;
        var sql = "INSERT INTO tbluser(kdUser,nmUser, password) VALUES ('"+ id +"','" + nama + "','"+ passwords +"')";
        var sql2 = "SELECT kdUser, nmUser, password FROM tbluser WHERE kdUser = '"+id+"'";
        connection.query(sql,function(err,rows){
            if(rows.affectedRows)
            {
                connection.query(sql2,function(err,rows){
                    if(!err && rows.length > 0)
                    {
                        res.json(rows[0]);
                    }
                    else{
                        res.json([]);
                    }
                });
            }
        });
    });
    app.get("/tblUser",function(req,res){
        var sql = "SELECT kdUser, nmUser, password FROM tbluser";
        connection.query(sql,function(err,rows){
            if(!err && rows.length > 0)
            {
                res.json(rows);
            }
            else{
                res.json([]);
            }
        });
    });
}