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
| package Modele;
import java.sql.*;
public class ConnexionDB {
private Connection conn = null;;
private Statement stat = null;
private PreparedStatement prep = null;
private ResultSet rs = null;
public Connection creationConnection() {
try {
Class.forName("org.sqlite.JDBC");
conn = DriverManager.getConnection("jdbc:sqlite:restaurant.db");
System.out.println("Connexion à la DB");
} catch (Exception e) {
System.out.println(e.getMessage());
}
return conn;
}
public void creationTable() {
String tableClient = "CREATE TABLE Client(email,motpasse)";
String tableRestaurant = "CREATE TABLE Restaurant(nom)";
String dropTableClient = "DROP TABLE IF EXISTS Client";
String dropTableRestaurant = "DROP TABLE IF EXISTS Restaurant";
String tableMenuRestaurant = "CREATE TABLE Menu()";
try {
stat = conn.createStatement();
// stat.executeUpdate(dropTableClient);
// stat.executeUpdate(dropTableRestaurant);
// stat.executeUpdate(tableClient);
// stat.executeUpdate(tableRestaurant);
} catch (SQLException e) {
System.out.println(e.getMessage());
}
}
public void insererClient() {
String insererClient = "INSERT INTO Client VALUES(?,?)";
try {
prep = conn.prepareStatement(insererClient);
prep.setString(1, "ericg099@gmail.com");
prep.setString(2, "test");
prep.addBatch();
prep.executeBatch();
prep.setString(1, "joel@gmail.com");
prep.setString(2, "test");
prep.addBatch();
prep.executeBatch();
prep.setString(1, "seila@gmail.com");
prep.setString(2, "test");
prep.addBatch();
prep.executeBatch();
} catch (SQLException e) {
System.out.println(e.getMessage());
}
}
public void insererRestaurant() {
String insererRestaurant = "INSERT INTO Restaurant VALUES(?)";
try {
prep = conn.prepareStatement(insererRestaurant);
prep.setString(1, "Au Coq");
prep.addBatch();
prep.executeBatch();
prep.setString(1, "St-Hubert");
prep.addBatch();
prep.executeBatch();
} catch (SQLException e) {
System.out.println(e.getMessage());
}
}
public void fermetureConnection() {
try {
stat.close();
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
} |
Partager