Skip to content

Instantly share code, notes, and snippets.

View JeromeBATAILLE's full-sized avatar

Jérôme JeromeBATAILLE

  • LYON, RANCE
View GitHub Profile
@JeromeBATAILLE
JeromeBATAILLE / delete.sql
Last active November 27, 2018 16:37
SQL 4 - Supprimer des informations
DELETE FROM `movie` WHERE id='5';
DELETE FROM `movie` WHERE id > '10';
@JeromeBATAILLE
JeromeBATAILLE / update.sql
Created November 27, 2018 15:59
SQL 3 - Modifier des informations
UPDATE `movie` SET `name`='Men in Black' WHERE id='5';
UPDATE `movie` SET `name`='DeadPool' ,`poster`="https://upload.wikimedia.org/wikipedia/en/thumb/2/23/Deadpool_%282016_poster%29.png/220px-Deadpool_%282016_poster%29.png" WHERE id='8';
UPDATE `movie` SET `comment`='' WHERE id='10';
@JeromeBATAILLE
JeromeBATAILLE / insertion.sql
Created November 27, 2018 15:01
SQL 2 - Insérer des informations
INSERT INTO `movie` VALUES (null,'Interstellar','https://www.gravatar.ghdjecjecvd.com','Best space opera ever!');
INSERT INTO `movie`(`name`, `poster`, `comment`) VALUES ('Matrix','https://WWW.gravatar.gkuegde.com','Welcome to the real world');
INSERT INTO `movie`(`name`, `poster`, `comment`) VALUES ('Matrix','https://WWW.gravatar.gkuegde.com','Welcome to the real world'), ('Matrix Reloaded','https://WWW.gravatar.gkuegde.com','The game has changed'), ('Matrix Revolution','https://WWW.gravatar.gkuegde.com','Liberty');
INSERT INTO `movie`(`name`) VALUES ('Inception');
@JeromeBATAILLE
JeromeBATAILLE / requêtes_movies_sql.sql
Created November 20, 2018 12:06
SQL 1 - Récupérer des informations
SELECT * from employee;
SELECT name from movie;
SELECT id, poster from movie;
SELECT poster, comment as avis_spectateur from movie;
@JeromeBATAILLE
JeromeBATAILLE / SecretSentence.java
Created November 13, 2018 12:26
Java Methods Indiana Jones
package indyJavaMethods;
public class SecretSentence {
public static String writeSecretSentence(String PARAMETRE_1, String PARAMETRE_2) {
return (PARAMETRE_1 + " s'incline face à " + PARAMETRE_2);
}
public static void main(String[] args) {
@JeromeBATAILLE
JeromeBATAILLE / lesVariablesEnJava.java
Last active October 31, 2018 12:29
Les varieables en java
public class lesVariablesEnJava {
public static void main(String[] args) {
String movyName = "Indiana Jones and the Last Crusade";
boolean seenMovy = true;
int yearRelease = 1989;
float rate = 8.3f;
System.out.println(movyName);
System.out.println(seenMovy);
System.out.println(yearRelease);
@JeromeBATAILLE
JeromeBATAILLE / pseudo-code
Last active October 29, 2018 15:03
Le pseudo-code Challenge
DEBUT algorithme PSEUDO_CODE
Afficher "Taper un nombre SVP: "
Demande un entier
nombre <- Lire entier
Répéter nombre fois
| Afficher "Bienvenue à la wild"
Fin Pour
@JeromeBATAILLE
JeromeBATAILLE / noe.ts
Created September 26, 2018 20:34
Typescript POO et Classes!
interface Photographiable {
photographier();
}
interface Caressable {
caresser();
}
interface Nourrissable {
nourrir();
@JeromeBATAILLE
JeromeBATAILLE / index.thml
Last active September 24, 2018 17:12
Requete HTTP
<!DOCTYPE html>
<html lang="fr" dir="ltr">
<head>
<meta charset="utf-8">
<title>Il fait chaud!</title>
</head>
<body>
<form class="" action="index.html" method="post">
<p>
<label for="Lieu">Lieu:</label>
@JeromeBATAILLE
JeromeBATAILLE / typeScript.ts
Created September 24, 2018 11:21
Découverte de TypeScript
function hello(name : string) {
console.log("Hello " + name);
}
var firstName = "bob";
hello(firstName);
hello(firstName + " marley");
function concat(a : string, b : string) {