在服务器端用nodejs插入多个数据到数据库
1、数据库中多个数据的表头
2、服务器app的搭建
const express = require('express');
const bodyParser = require('body-parser');
const product = require('./routes/product');
var app = express();
app.listen(3000);
app.use(express.static('public'));
app.use(bodyParser.urlencoded({extended:false}));
app.use('/product',product);
3、连接池pool的建立
const mysql = require('mysql');
var pool=mysql.createPool({
host:'127.0.0.1',
user:'root',
password:'',
database:'xz',
connectionLimit:10
});
module.exports = pool;
4.html 的写法
<!doctype html>
<html>
<head>
<meta charset='utf-8'>
<title>添加商品</title>
</head>
<body>
<form action='/product/add' method='post'>
<h3>添加商品</h3>
商品类型:<input type='text' name='family_id'>
主标题:<input type='text' name='title'>
副标题:<input type='text' name='subtitle'>
单价:<input type='text' name='price'>
服务承诺:<input type='text' name='promise'>
规格:<input type='text' name='spec'>商品名称:<input type='text' name='lname'>
操作系统:<input type='text' name='os'>
内存容量:<input type='text' name='memory'>
分辨率:<input type='text' name='resolution'>处理器:<input type='text' name='cpu'>
显卡型号:<input type='text' name='video_card'>
显存容量:<input type='text' name='video_memory'>
所属分类:<input type='text' name='category'>
磁盘类型:<input type='text' name='disk'>
描述:<input type='text' name='details'> 上线时间:<input type='text' name='shelf_time'>
库存:<input type='text' name='sold_count'>
是否促销:<input type='text' name='is_onsale'>
<input type='submit'>
</form>
</body>
</html>
5.路由器的创建
const express = require('express');
const pool = require('../pool.js');
var router = express.Router();
router.post('/add',(req,res)=>{
var obj = req.body;
var i=400
for(var key in obj){
i++;
if(!obj[key]){
res.send({code:i,msg:`${obj[key]} required`});
};
obj.iid = null;
var sql =`insert into xz_laptop set ?`;
pool.query(sql,[obj],(err,result)=>{
if(err) throw err;
res.send({code:200,msg:'success'});
});
};
});
6、html结果呈现
7.输入前的数据库状态
8.加入数据后浏览器显示的状态
9.加入后数据库的状态