Scribd
Upload
9 views4 pages

Java Database Handler for Students

The DatabaseHandler class provides methods to manage student records in a MySQL database, including adding, retrieving, updating, and deleting student information. It establishes a connection to the database using JDBC and executes SQL statements through prepared statements. The class handles SQL exceptions and returns boolean values to indicate success or failure of operations.

Uploaded by

corbeille.omega
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
9 views4 pages

Java Database Handler for Students

The DatabaseHandler class provides methods to manage student records in a MySQL database, including adding, retrieving, updating, and deleting student information. It establishes a connection to the database using JDBC and executes SQL statements through prepared statements. The class handles SQL exceptions and returns boolean values to indicate success or failure of operations.

Uploaded by

corbeille.omega
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

package server.

utils;

import [Link];

import [Link];

import [Link];

import [Link];

import [Link];

import [Link];

import [Link];

import [Link];

public class DatabaseHandler {

private static final String URL = “jdbc:mysql://localhost:3306/projet2”;

private static final String USER = “root”;

private static final String PASSWORD = “”;

static {

try {

[Link](”[Link]”);

} catch (ClassNotFoundException e) {

[Link]();

private Connection getConnection() throws SQLException {

return [Link](URL, USER, PASSWORD);

}
public boolean ajouterEtudiant(Etudiant etudiant) {

String sql = “INSERT INTO etudiant (numero_et, nom, adresse, bourse) VALUES (?, ?, ?, ?)”;

try (Connection conn = getConnection();

PreparedStatement stmt = [Link](sql)) {

[Link](1, [Link]());

[Link](2, [Link]());

[Link](3, [Link]());

[Link](4, [Link]());

return [Link]() > 0;

} catch (SQLException e) {

[Link]();

return false;

public List<Etudiant> getTousEtudiants() {

List<Etudiant> etudiants = new ArrayList<>();

String sql = “SELECT * FROM etudiant”;

try (Connection conn = getConnection();

PreparedStatement stmt = [Link](sql);

ResultSet rs = [Link]()) {
while ([Link]()) {

Etudiant etudiant = new Etudiant();

[Link]([Link](”numero_et”));

[Link]([Link](”nom”));

[Link]([Link](”adresse”));

[Link]([Link](”bourse”));

[Link](etudiant);

} catch (SQLException e) {

[Link]();

return etudiants;

public boolean modifierEtudiant(Etudiant etudiant) {

String sql = “UPDATE etudiant SET nom = ?, adresse = ?, bourse = ? WHERE numero_et = ?”;

try (Connection conn = getConnection();

PreparedStatement stmt = [Link](sql)) {

[Link](1, [Link]());

[Link](2, [Link]());

[Link](3, [Link]());

[Link](4, [Link]());
return [Link]() > 0;

} catch (SQLException e) {

[Link]();

return false;

public boolean supprimerEtudiant(int numeroEt) {

String sql = “DELETE FROM etudiant WHERE numero_et = ?”;

try (Connection conn = getConnection();

PreparedStatement stmt = [Link](sql)) {

[Link](1, numeroEt);

return [Link]() > 0;

} catch (SQLException e) {

[Link]();

return false;

You might also like