Untitled

import java.sql.SQLException;
import java.sql.*;

public class Stagiere {
     int idStg;
     String NomStg;
     String prenomStg;
     String promotionStg;
     String adresseStg;
     String fillStg;
     String TelStg;

    public Stagiere(){}
    public Stagiere(int idStg, String NomStg, String prenomStg, String promotionStg, String adresseStg, String fillStg,String TelStg){
        this.idStg = idStg;
        this.NomStg = NomStg;
        this.prenomStg = prenomStg;
        this.promotionStg = promotionStg;
        this.adresseStg = adresseStg;
        this.fillStg = fillStg;
        this.TelStg = TelStg;
    }
    // getters
    public int getIdStg(){
        return idStg;
    }
    public String getName(){
        return NomStg;
    }
    public String getPrenomStg(){
        return prenomStg;
    }
    public String getPromotionStg(){
        return promotionStg;
    }
    public String getAdresseStg(){
        return adresseStg;
    }
    public String getFillStg(){
        return fillStg;
    }
    public String getTelStg(){
        return TelStg;
    }
    // setters
    public void setIdStg(int idStg){
        this.idStg = idStg;
    };
    public void setNomStg(String NomStg){
        this.NomStg = NomStg;
    }
    public void setPrenomStg(String prenomStg){
        this.prenomStg = prenomStg;
    }
    public void setPromotionStg(String promotionStg){
        this.promotionStg = promotionStg;
    }
    public void setAdresseStg(String adresseStg) {
        this.adresseStg = adresseStg;
    }
    public void setFillStg(String fillStg){
        this.fillStg = fillStg;
    }
    public void setTelStg(String TelStg) {
        this.TelStg = TelStg;
    }

public void ajouterStg(Stagiere s1){
        Connecter co = new Connecter();
    Statement St;
    try {
        St = co.obtenirConnection().createStatement();
        St.executeUpdate("INSERT INTO stagiare(idStg,NomStg,prenomStg,promotionStg,adresseStg,filliereStg,TelStg)values('"+s1.idStg+"','"+s1.NomStg+"','"+s1.prenomStg+"','"+s1.promotionStg+"','"+ s1.adresseStg+"','"+s1.fillStg+"','"+s1.TelStg+ "')");

    } catch (SQLException e) {
        throw new RuntimeException(e);
    }
}
    public void supprimerStg(String s1){
        Connecter co = new Connecter();
        Statement St;
        try {
            St = co.obtenirConnection().createStatement();
            St.executeUpdate("DELETE  from stagiare where NomStg='"+s1+"';");

        } catch (SQLException e) {
            throw new RuntimeException(e);
        }
    }

    public String toString(){
        return "Stagiare("+"id du stagiare="+idStg+", Nom du Stagiare= "+NomStg+", Prenom du Stagiare = "+prenomStg+", Promotion = "+promotionStg+", adresse du stagiare= "+adresseStg+", fillière= "+fillStg+", telephone du stagiare= "+TelStg+")";
    }

}