Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- const http = require("http");
- const express = require("express");
- const bodyParser = require("body-parser");
- const mysql = require("mysql");
- const cnx = mysql.createConnection({
- host: "192.169.200.243",
- user: "unam2",
- database: "unam",
- password: "IIMAS@2019"
- });
- cnx.connect(function (err) {
- if (err) {
- console.log("No se pudo conectar a la BD...");
- return;
- }
- console.log("Conectado a la BD...");
- const app = express();
- app.use(bodyParser.json());
- app.use(bodyParser.urlencoded({ extended: true }));
- app.get("/api/productos", function (req, res) {
- cnx.query("select * from productos", function (err, registros) {
- if (err) {
- res.status(500).send(err);
- return;
- }
- res.send(registros);
- });
- });
- app.post("/api/producto/alta", function (req, res) {
- cnx.query("insert into productos set ?", req.body, function (err, result) {
- if (err) {
- res.status(500).send(err);
- return;
- }
- res.send("Se registró el producto");
- })
- });
- http.createServer(app).listen(3000, function () {
- console.log("Servicio iniciado en localhost Pto: 3000");
- console.log("Presiona Ctrl + c para salir...");
- });
- });
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement