app.js

/**
 * Module dependencies.
 */

var express = require('express')
  , http = require('http')
  , path = require('path');

var app = express();

var employees = require('./routes/employees');

app.configure(function(){
  app.set('port', process.env.PORT || 3000);
  app.set('views', __dirname + '/views');
  app.set('view engine', 'jade');
  app.use(express.favicon());
  app.use(express.logger('dev'));
  app.use(express.bodyParser());
  app.use(express.methodOverride());
  app.use(app.router);
  app.use(express.static(path.join(__dirname, 'public')));
});

app.configure('development', function(){
  app.use(express.errorHandler());
});

app.get('/', employees.home);
app.get('/users/:id', employees.view);

http.createServer(app).listen(app.get('port'), function(){
  console.log("Express server listening on port " + app.get('port'));
});

employees.js

var mysql = require('mysql');

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

connection.connect();

exports.home = function(req,res) {
  //res.render('home', {title: 'My Title'})
	connection.query('SELECT * FROM users;', function(err, users){
		res.render('home', {users:users})	;
	});
};

exports.view = function(req,res) {
	//res.render('home', {title: 'My Title'})
	connection.query('select * from users where id = ?', req.params.id, function(err, details, fields) {
		/*res.render('view', {
            userid : req.params.id,
            fname : users[req.params.id].fname
        });
		*/
		res.render('view', {users : details, fname : details.fname})
	});	
};

view.jade

extends layout

block content

	h2 #{users.fname}
	hr

	a(href="users/new") Add New User
	br
	a(href="/") Home