Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- var express = require('express');
- var path = require('path');
- var favicon = require('serve-favicon');
- var logger = require('morgan');
- var cookieParser = require('cookie-parser');
- var bodyParser = require('body-parser');
- var index = require('./routes/index');
- var users = require('./routes/users');
- var app = express();
- // view engine setup
- app.set('views', path.join(__dirname, 'views'));
- app.set('view engine', 'jade');
- // uncomment after placing your favicon in /public
- //app.use(favicon(path.join(__dirname, 'public', 'favicon.ico')));
- app.use(logger('dev'));
- app.use(bodyParser.json());
- app.use(bodyParser.urlencoded({ extended: false }));
- app.use(cookieParser());
- app.use(express.static(path.join(__dirname, 'public')));
- app.use('/', index);
- app.use('/users', users);
- // catch 404 and forward to error handler
- app.use(function(req, res, next) {
- var err = new Error('Not Found');
- err.status = 404;
- next(err);
- });
- // error handler
- app.use(function(err, req, res, next) {
- // set locals, only providing error in development
- res.locals.message = err.message;
- res.locals.error = req.app.get('env') === 'development' ? err : {};
- // render the error page
- res.status(err.status || 500);
- res.render('error');
- });
- module.exports = app;
- var express = require('express');
- var router = express.Router();
- /* GET home page. */
- router.get('/', function(req, res, next) {
- GetData(function(recordset)
- {
- res.render('index', {projects: recordset })
- });
- });
- function GetData(callback )
- {
- var sql = require ('mssql');
- const config = {
- user: 'sa',
- password: 'password',
- server: 'localhost\SQLEXPRESS',
- database: 'xxxxx',
- options: {
- encrypt: false // Use this if you're on Windows Azure
- }
- };
- var connection = new sql.Connection(config, function(err)
- {
- var request = new sql.Request(connection);
- request.query('select * from Project_Type' , function(err, recordset)
- {
- callback(recordset);
- });
- });
- }
- module.exports = router;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement