Guest User

Untitled

a guest
Sep 1st, 2018
99
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.10 KB | None | 0 0
  1. server site:
  2. app.post('/myaction', async function(req, res) {
  3. async function next_func(req, res){
  4. var myJson = await show();
  5. return myJson;
  6. }
  7. dataJ = await next_func(req, res);
  8. console.log("dataJ="+dataJ);
  9. console.log(typeof dataJ)
  10. res.status(200);
  11. res.contentType('application/json');
  12. res.send(dataJ);
  13. });
  14. app.listen(8081, function() {
  15. console.log('Server running at http://127.0.0.1:8081/');
  16. });
  17. async function show(){
  18. var con = mysql.createConnection({
  19. host: "127.0.0.1",
  20. user: "root",
  21. password: "aaaaaaaa",
  22. database: "doto"
  23. });
  24. var sql ="select * from task_list";
  25. resultsArray = [];
  26. await new Promise((resolve, reject) => {
  27. con.connect((err, connection) => {
  28. if (err) return reject(err)
  29. con.query(sql, (err, rows, fields) => {
  30. if (err) return reject(err)
  31. resolve(
  32. rows.forEach( (row) => {
  33. resultsArray.push(
  34. {detail:row.details, status:row.status, subject:row.subject}
  35. );
  36. })
  37. )
  38. })
  39. })
  40. })
  41. console.log("resultsArray"+resultsArray);
  42. return resultsArray;
  43. }
  44. client site:
  45. $.fn.ajaxShow = function(st) {
  46. xhrct = $.ajax({
  47. type: 'POST',,
  48. data : {
  49. status : st
  50. },
  51. url: 'http://127.0.0.1:8081/myaction',
  52. success: function (data) {
  53. alert("function");
  54. $('#tb').empty();
  55. if(data!=null) {
  56. var fotoData = $.parseJSON(data);
  57. $(fotoData).each(function (i, obx) {
  58. alert("fotoData");
  59. $('#tb').append('<tr>')
  60.  
  61. .append('<td>'+obx.detail+'</td>')
  62.  
  63. .append('<td>'+obx.status+'</td>')
  64.  
  65. .append('<td>'+obx.subject+'</td>')
  66. .append('</tr>');
  67. });
  68. }
  69. },
  70. error: function(XMLHttpRequest, textStatus, errorThrown) {
  71. alert("XMLHttpRequest: "+XMLHttpRequest.responseText);
  72. alert("textStatus: "+textStatus);
  73. alert("errorThrown: "+errorThrown);
  74. }
  75. });
  76. }
Add Comment
Please, Sign In to add comment