nodejs操作mysql创建库和表_NodeJs操作mysql数据库(js版)

末蓝、 2023-01-11 01:25 116阅读 0赞

/\*\*

\* Created by wangyc on 2015-3-18.

\* timetrack.js

\*/

var qs = require('querystring');

exports.sendHtml = function (res, html) \{

res.setHeader('Content-Type', 'text/html');

res.setHeader('Content-Length', Buffer.byteLength(html));

res.end(html);

\};

exports.parseReceivedData = function (req, cb) \{

var body = '';

req.setEncoding('utf8');

req.on('data', function (chunk) \{

body += chunk;

\});

req.on('end', function () \{

var data = qs.parse(body);

cb(data);

\});

\};

exports.actionForm = function (id, path, label) \{

var html = '

' +

'' +

return html;

\};

exports.add = function (db, req, res) \{

exports.parseReceivedData(req, function (work) \{

db.query(

"insert into work(hours,date,description) " +

"values(?,?,?)",

\[work.hours, work.date, work.description\],

function (err) \{

console.log(err);

console.log(res);

if (err) throw err,

exports.show(db, res);

);

\});

\};

exports.delete = function (db, req, res) \{

exports.parseReceivedData(req, function (work) \{

db.query(

"delete from work where id=?",

\[work.id\],

function (err) \{

if (err) throw err;

exports.show(db, res);

);

\});

\};

exports.archive = function (db, req, res) \{

exports.parseReceivedData(req, function (work) \{

db.query(

"update work set archived=1 where id=?",

\[work.id\],

function (err) \{

if (err) throw err;

exports.show(db, res);

);

\});

\};

exports.show = function (db, res, showArchived) \{

var query = "select \* from work where archived=? order by date desc ";

var archiveValue = showArchived ? 1 : 0;

db.query(

query,

\[archiveValue\],

function (err, rows) \{

if (err) throw err;

html = showArchived ? ''

: 'Archived work  
';

html += exports.workHitlistHtml(rows);//将结果格式化为表格

html += exports.workFormHtml();

exports.sendHtml(res, html);//给用户发送HTML响应

);

\};

exports.showArchived = function (db, res) \{

exports.show(db, res, true);

\};

exports.workHitlistHtml = function (rows) \{

var html = '

console.log(rows)

for (var i in rows) \{

html += '

' + rows\[i\].date + '';

html += '

' + rows\[i\].hours + '';

html += '

' + rows\[i\].description + '';

if (!rows\[i\].archived) \{

html += '

' + exports.workArchiveForm(rows\[i\].id) + '';

html += '

' + exports.workDeleteForm(rows\[i\].id) + '';

html += '

return html;

\};

exports.workFormHtml = function () \{

var html = '

Date(YYYY-MM-DD):

' +

Hours worked:

' +

Description:  
' +

' +

'' +

return html;

\};

exports.workArchiveForm = function (id) \{

return exports.actionForm(id, '/archive', 'Archive');

\};

exports.workDeleteForm = function (id) \{

return exports.actionForm(id, '/delete', 'Delete');

\};

nodejs操作mysql创建库和表_NodeJs操作mysql数据库(js版)

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关【MySQL】库操作和表操作

相关 nodejs操作mysql创建库和表_NodeJs操作mysql数据库(js版)

相关 nodejs环境快速操作mysql数据库

相关 php和nodejs连接mysql数据库_Nodejs如何连接mysql数据库？

相关 Nodejs 操作mysql数据库

相关 Nodejs 操作redis数据库

相关 nodejs操作MySQL

相关 nodejs（十七）操作mysql数据库

相关 MySQL库操作及表操作

相关 nodejs 操作mysql数据库（最新版本）