Advertisement
Guest User

Untitled

a guest
Jul 5th, 2016
103
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.04 KB | None | 0 0
  1. // import modules
  2. var express = require('express');
  3. var mysql = require('mysql');
  4. var app = express();
  5.  
  6. // implement connectionPool
  7. var connection = mysql.createPool({
  8. // properties ...
  9. connectionLimit: 90, // only 90 queries at a time
  10. host:'localhost',
  11. user:'root',
  12. password:'KTMEi',
  13. database:'mantis_live_dev'
  14. });
  15.  
  16. app.get('/', function(req, res){
  17. // about mysql
  18. // connection.query("SELECT * FROM mantis_live_dev WHERE", function(error, rows, fields));
  19. connection.getConnection(function(error, tempCont){
  20. if(!!error){
  21. tempCont.release();
  22. console.log('Error');
  23. } else {
  24. console.log('Successfully connected.');
  25. var query1 = "SELECT * FROM mysampletable WHERE id>10";
  26. tempCont.query(query1, function(error, rows, fields){
  27. tempCont.release();
  28. // callback
  29. if(!!error){
  30. console.log('Error in the query');
  31. } else {
  32. console.log('Success!\n');
  33. console.log(rows);
  34. // res.send('Hello, ' + rows[0].Name);
  35. res.json(rows);
  36. // parse with your rows/ fields
  37. }
  38. });
  39. }
  40. })
  41. });
  42.  
  43. app.listen(1337);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement