Skip to content

Instantly share code, notes, and snippets.

View jeffersonchaves's full-sized avatar
😎
Focusing

Jefferson Chaves jeffersonchaves

😎
Focusing
383 followers · 130 following
  • Instituto Federal do Paraná - IFPR
  • Foz do Iguaçu - PR
View GitHub Profile
@jeffersonchaves
jeffersonchaves / cidades_turisticas.sql
Last active July 29, 2024 20:00
CREATE TABLE cidades (
id INT PRIMARY KEY,
nome VARCHAR(100),
estado VARCHAR(50)
);
CREATE TABLE atrativos (
id INT PRIMARY KEY,
nome VARCHAR(200),
tipo VARCHAR(50),
@jeffersonchaves
jeffersonchaves / default.css
Last active July 26, 2024 17:54
@import url('https://fonts.googleapis.com/css2?family=Catamaran:[email protected]&display=swap');
/* Reset CSS */
*{
margin: 0;
padding: 0;
}
@jeffersonchaves
jeffersonchaves / conexao_banco.php
Created July 11, 2024 15:12
<?php
$usuario = "root";
$senha = "bancodedados";
$url_conexao = "mysql:host=localhost;dbname=db_contatos";
$conexao = new PDO($url_conexao, $usuario, $senha);
$conexao->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
try {
@jeffersonchaves
jeffersonchaves / gist:5b168ef26d26dcb5416534a11dc17da2
Created July 5, 2024 15:03
unidade-medida.css
/* Unidades Absolutas */
div {
width: 300px;
height: 2cm;
}
/* Unidades Relativas */
p {
font-size: 1.5em;
margin: 10%;
@jeffersonchaves
jeffersonchaves / pokeapi.json
Created December 1, 2023 18:24
pokeapi.json
{"count":1292,"next":null,"previous":null,"results":[{"name":"bulbasaur","url":"https://pokeapi.co/api/v2/pokemon/1/"},{"name":"ivysaur","url":"https://pokeapi.co/api/v2/pokemon/2/"},{"name":"venusaur","url":"https://pokeapi.co/api/v2/pokemon/3/"},{"name":"charmander","url":"https://pokeapi.co/api/v2/pokemon/4/"},{"name":"charmeleon","url":"https://pokeapi.co/api/v2/pokemon/5/"},{"name":"charizard","url":"https://pokeapi.co/api/v2/pokemon/6/"},{"name":"squirtle","url":"https://pokeapi.co/api/v2/pokemon/7/"},{"name":"wartortle","url":"https://pokeapi.co/api/v2/pokemon/8/"},{"name":"blastoise","url":"https://pokeapi.co/api/v2/pokemon/9/"},{"name":"caterpie","url":"https://pokeapi.co/api/v2/pokemon/10/"},{"name":"metapod","url":"https://pokeapi.co/api/v2/pokemon/11/"},{"name":"butterfree","url":"https://pokeapi.co/api/v2/pokemon/12/"},{"name":"weedle","url":"https://pokeapi.co/api/v2/pokemon/13/"},{"name":"kakuna","url":"https://pokeapi.co/api/v2/pokemon/14/"},{"name":"beedrill","url":"https://pokeapi.co/api/v2/
@jeffersonchaves
jeffersonchaves / marvel_api.php
Created December 1, 2023 16:08
API_MARVEL.php
<?php
$ts = time();
$publicKey = 'ebb5d43c10d70a147fb24321ce1c2ae9';
$privateKey = 'a9ae9afbfb9e68792144677e2e6f5a75fef8a495';
$hash = md5($ts . $privateKey . $publicKey);
$offset = rand(0, 100) * 20;
@jeffersonchaves
jeffersonchaves / esp32_web.ino
Created October 27, 2023 19:07
// ----- Bibliotecas -----
#include <ESP8266WiFi.h>
#include <WebServer.h>
// ----- Constantes -----
const int SENSOR_UMIDADE = 0;
const int RELE = 4;
const char* ssid = "Nuestra Casa"; /* Add your router's SSID */
@jeffersonchaves
jeffersonchaves / buscando_valor_emL_lista_sorteada.por
Created August 11, 2023 17:19
programa
{
inclua biblioteca Util
funcao inicio()
{
inteiro lista[30]
inteiro num_elementos = Util.numero_elementos(lista)
@jeffersonchaves
jeffersonchaves / dados-iniciais.sql
Created May 22, 2023 14:00
insert into Veiculo (codigo, fabricante, modelo, anoFabricacao, anoModelo, valor)
values (1, 'Fiat', 'Toro', 2020, 2020, 107000);
insert into Veiculo (codigo, fabricante, modelo, anoFabricacao, anoModelo, valor)
values (2, 'Ford', 'Fiesta', 2019, 2019, 42000);
insert into Veiculo (codigo, fabricante, modelo, anoFabricacao, anoModelo, valor)
values (3, 'Renault', 'Clio', 2013, 2013, 20000);
@jeffersonchaves
jeffersonchaves / SellerRepository (delete).java
Created May 8, 2023 14:07
package br.edu.ifpr.persistproject.repository;
import br.edu.ifpr.persistproject.connection.ConnectionFactory;
import br.edu.ifpr.persistproject.exception.DatabaseIntegrityException;
import br.edu.ifpr.persistproject.model.Seller;
import java.sql.*;
import java.text.SimpleDateFormat;
public class SellerRepository {