SQL/index.html at main · arielabade/SQL · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
<!DOCTYPE html>
<html lang="pt">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Gerenciamento de Dados</title>
    <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css">
    <script>
        let selectedTable = "coelho";

        const tableFields = {
            coelho: ["id_coelho", "nome", "idade", "genero", "raca", "filiacao"],
            ninhada: ["id_ninhada", "data_nascimento", "quantidade", "id_mae", "id_pai"],
            funcionario: ["id_funcionario", "nome", "cargo", "id_galpao"]
        };

        function setTable(table) {
            selectedTable = table;
            document.getElementById("selectedTable").innerText = "Tabela Selecionada: " + table;
            generateFormFields();
        }

        function generateFormFields() {
            const formDiv = document.getElementById("formFields");
            formDiv.innerHTML = "";
            tableFields[selectedTable].forEach(field => {
                let label = document.createElement("label");
                label.textContent = field.replace("_", " ").toUpperCase();
                let input = document.createElement("input");
                input.type = "text";
                input.className = "form-control";
                input.name = field;
                formDiv.appendChild(label);
                formDiv.appendChild(input);
            });
        }

        async function fetchData() {
            let res = await fetch(`http://localhost:5000/${selectedTable}`);
            let data = await res.json();
            displayTable(data);
        }

        async function insertData() {
            let formData = getFormData();
            await fetch(`http://localhost:5000/${selectedTable}`, {
                method: "POST",
                headers: { "Content-Type": "application/json" },
                body: JSON.stringify(formData)
            });
            alert("Registro inserido!");
            fetchData();
        }

        async function updateData() {
            let formData = getFormData();
            await fetch(`http://localhost:5000/${selectedTable}`, {
                method: "PUT",
                headers: { "Content-Type": "application/json" },
                body: JSON.stringify(formData)
            });
            alert("Registro atualizado!");
            fetchData();
        }

        async function deleteData() {
            let idField = tableFields[selectedTable][0];
            let idValue = document.querySelector(`input[name=${idField}]`).value;
            await fetch(`http://localhost:5000/${selectedTable}`, {
                method: "DELETE",
                headers: { "Content-Type": "application/json" },
                body: JSON.stringify({ [idField]: idValue })
            });
            alert("Registro deletado!");
            fetchData();
        }

        function getFormData() {
            let formData = {};
            document.querySelectorAll("#formFields input").forEach(input => {
                formData[input.name] = input.value;
            });
            return formData;
        }

        function displayTable(data) {
            const tableDiv = document.getElementById("output");
            tableDiv.innerHTML = "";

            if (data.length === 0) {
                tableDiv.innerHTML = "<p>Nenhum dado encontrado.</p>";
                return;
            }

            let table = document.createElement("table");
            table.className = "table table-bordered";
            let thead = document.createElement("thead");
            let tbody = document.createElement("tbody");

            let headerRow = document.createElement("tr");
            tableFields[selectedTable].forEach(key => {
                let th = document.createElement("th");
                th.textContent = key.replace("_", " ").toUpperCase();
                headerRow.appendChild(th);
            });
            thead.appendChild(headerRow);

            data.forEach(row => {
                let tr = document.createElement("tr");
                tableFields[selectedTable].forEach(key => {
                    let td = document.createElement("td");
                    td.textContent = row[key] || "-";
                    tr.appendChild(td);
                });
                tbody.appendChild(tr);
            });

            table.appendChild(thead);
            table.appendChild(tbody);
            tableDiv.appendChild(table);
        }

        window.onload = generateFormFields;
    </script>
</head>
<body class="container mt-4">
    <h1 class="text-center">Gerenciamento de Banco de Dados</h1>

    <div class="text-center">
        <button class="btn btn-primary" onclick="setTable('coelho')">Coelho</button>
        <button class="btn btn-primary" onclick="setTable('ninhada')">Ninhada</button>
        <button class="btn btn-primary" onclick="setTable('funcionario')">Funcionário</button>
    </div>

    <h2 class="mt-4" id="selectedTable">Tabela Selecionada: Coelho</h2>

    <div class="card p-3">
        <h3>Formulário</h3>
        <div id="formFields"></div>
        <div class="mt-3">
            <button class="btn btn-success" onclick="insertData()">Criar</button>
            <button class="btn btn-warning" onclick="updateData()">Atualizar</button>
            <button class="btn btn-danger" onclick="deleteData()">Deletar</button>
        </div>
    </div>

    <h2 class="mt-4">Registros:</h2>
    <div id="output"></div>

    <button class="btn btn-info mt-3" onclick="fetchData()">Listar Registros</button>

    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>