· 9 years ago · Sep 05, 2017, 05:58 PM
1var express=require('express');
2var app=express();
3var mysql=require('mysql');
4var server=app.listen(process.env.PORT||8000, function(){
5 console.log('Connected to port 8000');
6});
7
8app.get('/', function(req, res){
9 res.sendFile(__dirname + '/index.html');
10});
11
12app.get('/secondpage.html', function(req, res){
13 res.sendFile(__dirname + '/secondpage.html');
14});
15
16app.get('/nota.html', function(req, res){
17 res.sendFile(__dirname + '/nota.html');
18});
19
20var conn= mysql.createConnection({
21 host: 'localhost',
22 user: 'root',
23 password: 'rootpass',
24 database: 'mydb'
25});
26
27conn.connect(function(err){
28 if(err) throw err;
29 console.log ('Connected to mysql');
30});
31
32conn.query ('CREATE TABLE IF NOT EXISTS elevcnrv\
33 ( id INT,\
34 nume VARCHAR(20),\
35 prenume VARCHAR(20),\
36 clasa INT,\
37 nota_info INT\
38 )',
39 function(err, res){
40 if (err) throw err;
41 console.log(res);
42 });
43
44/*
45conn.query ('INSERT INTO elevcnrv (id, nume, prenume, clasa, nota_info)\
46 VALUES(1, "Popescu", "Mihai", 11, 8)');
47*/
48
49app.get('/selectall', function(req, res){
50 conn.query('SELECT * FROM elevcnrv', function (err, result){
51 if (err) throw err;
52 res.send(result);
53 });
54});
55
56app.get('/delete/:nota_info', function(req,res){
57 conn.query('DELETE FROM elevcnrv WHERE nota_info < ?', req.params.nota_info,
58 function(err, result){
59 if(err) throw err;
60 res.send(result);
61 });
62});
63
64app.get('/update/:nota_info', function(req,res){
65 conn.query('UPDATE elevcnrv\
66 SET nota_info = nota_info + 1\
67 WHERE nota_info = ?',
68 req.params.nota_info,
69 function(err, result){
70 if(err) throw err;
71 res.send(result);
72 });
73});
74
75/*
76conn.query('INSERT INTO elevcnrv(id, nume, prenume, clasa, nota_info)\
77 VALUES(2, "Ionescu", "Iob", 10, 7)');
78
79conn.query('INSERT INTO elevcnrv(id, nume, prenume, clasa, nota_info)\
80 VALUES(3, "Popa", "Matei", 12, 6)');
81
82conn.query('INSERT INTO elevcnrv(id, nume, prenume, clasa, nota_info)\
83 VALUES(4, "Enescu", "Cosmin", 9, 8)');
84
85conn.query('INSERT INTO elevcnrv(id, nume, prenume, clasa, nota_info)\
86 VALUES(5, "Snow", "Jon", 10, 9)');
87*/