Express: Koneksi ke MYSQL & Baca Data

/**
 * Created by StevenNathaniel on 29-Jun-16.
 */

var express = require('express');

var app = express();

var mysql = require('mysql');

var path = require('path');

var pug = require('pug');

var bodyParser = require('body-parser');


app.set('view engine','pug');

app.set('views',__dirname + '/views');

app.use('/static',express.static('public'));


var koneksi = mysql.createConnection({
    host:'localhost',
    user:'root',
    password:''
});

app.get('/',function(req,res) {
    koneksi.query('USE latihan');
    koneksi.query('SELECT * FROM pegawai', function(err,rows,fields) {
        if (err) throw err;
        console.log(JSON.stringify(rows));
        res.send(JSON.stringify(rows));
    });
});

app.listen(8080);