Authentification en Java/mysql

 
public class Authentification extends JFrame {
	
	JLabel login,mdp;
	JTextField login1;
	JPasswordField mdp1;
	JButton valider,annuler;
	
		
	public Authentification(){
		
		super();
		this.setTitle(" GESCOM ");
		this.setSize(new Dimension(400,200));
		this.setLocationRelativeTo(null);
		this.setResizable(false);
		
		
		login = new JLabel("Login");
		login1 = new JTextField();
		
		mdp = new JLabel("Mot de Passe");
		mdp1 = new JPasswordField();
		
		valider = new JButton("Valider ");
		annuler = new JButton(" Annuler");
		
		
		Container contenu = this.getContentPane();
		contenu.setLayout(null);
		
		contenu.add(login);
		login.setBounds(20, 20, 100, 20);
		
		contenu.add(login1);
		login1.setBounds(150, 20, 150, 20);
		
		contenu.add(mdp);
		mdp.setBounds(22, 55, 100, 20);
		
		contenu.add(mdp1);
		mdp1.setBounds(150, 55, 150, 20);
		
		contenu.add(valider);
		valider.setBounds(125,100 ,77 ,20 );
		
		contenu.add(annuler);
		annuler.setBounds(225, 100, 82, 20);
		
		valider.addActionListener(new ValiderListener());	
		
		this.setVisible(true);
	
	}
		
}

		class ValiderListener extends JFrame implements ActionListener{
		
			@Override
			public void actionPerformed(ActionEvent e) {
					ActionEvent a;
					try {
						
					} catch (Exception e2) {
						
					}
			}
			
		}

public class Base {
	
	public Connection conn;
	
	public void connexionBD(){
		
		
		/*  Chargement de la Base de données  */
			try{
				
				Class.forName("com.mysql.jdbc.Driver.");
				
			} catch (Exception e) {
				
				System.out.println(" Erreur de chargement de la Base de données");
				e.getMessage();
				System.exit(0);
				
			}
		
		
			/*    Connexion de la Base de données  */
			try {
				
				String url = "jdbc:mysql://localhost/gescom";
				String user = "root";
				String passwd ="";
				conn = DriverManager.getConnection(url, user, passwd);
				
			} catch (Exception e) {
				System.out.println(" Erreur de Connexion à la Base de données ");
			}	
			
		}
	
			/*   */	
			public Connection getConnect(){
				
				return conn;
			}
	
			
			/*   Deconnexion  */
			public void Deconnexion(){
			
				try {
					conn.close();
					
				} catch (Exception e) {
					System.out.println(" Déconnexion Impossible ");
				}
			}
		
			
			
			
}

public class TraitementAuthentification implements ActionListener {

	public Base b = new Base();
	public Connection conn;
	
	static JTextField login1,passwd ;
	
	PreparedStatement statement = null;
	
	ResultSet resultat;
	
	public TraitementAuthentification(){
		
	}


	@Override
	public void actionPerformed(ActionEvent e) {
		String login = login1.getText();
		String password = passwd.getText();
		
		b.connexionBD();
		conn = b.getConnect();
			try{
				statement = (PreparedStatement) conn.createStatement();	
				String sql = "SELECT password FROM authentification WHERE login ='"+login+"'";
				resultat = statement.executeQuery(sql);
				
				if(resultat.next()){
					
					String motDePasse = resultat.getString(1);
		
				if(motDePasse.equals(password)){
			
					JOptionPane.showMessageDialog(null,"Connexion réussie ! ","Success",JOptionPane.PLAIN_MESSAGE);
				}else {
					
					JOptionPane.showMessageDialog(null,"Mot de passe incorrect ! ","Error",1);
				}
				}else {
					
					JOptionPane.showMessageDialog(null,"Login incorrect ! ","Error",1);
				}

					conn.close();
		
			}catch (SQLException e4) {
			
				System.out.println(e4.getMessage());
			}
		}
	
}