dupa

package pl.maciejwasiak.managementsystem;

import java.sql.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import javax.swing.*;
import java.awt.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;

public class Login_S extends JFrame implements ActionListener{
    /**
     *  JFrame components for login screen
     */
    JButton bLogin, bExit;
    JLabel lBadPasswd, lCorrectPassword, lPasswd, lLogin, lImage;
    JTextField tfLogin;
    JPasswordField pfPasswd;


    public Login_S(){
        setSize(800,600);
        setTitle("Management System for School - Zespół Szkół nr 10 w Warszawie");
        setLayout(null);

        bLogin = new JButton("Zaloguj");
        bLogin.setBounds(150,460,100,40);
        add(bLogin);
        bLogin.addActionListener(this);

        bExit = new JButton("Zakończ");
        bExit.setBounds(540,460,100,40);
        add(bExit);
        bExit.addActionListener(this);

        lBadPasswd = new JLabel("Złe hasło!");
        lBadPasswd.setBounds(370,460,100,40);
        lBadPasswd.setForeground(Color.red);
        add(lBadPasswd);

        lCorrectPassword = new JLabel("Zalogowano!");
        lCorrectPassword.setBounds(370,460,100,40);
        lCorrectPassword.setForeground(Color.GREEN);
        add(lCorrectPassword);

        lLogin = new JLabel("Podaj login: ");
        lLogin.setBounds(200,300,100,40);
        add(lLogin);

        lPasswd = new JLabel("Podaj hasło: ");
        lPasswd.setBounds(200,350,100,40);
        add(lPasswd);

        tfLogin = new JTextField(100);
        tfLogin.setBounds(300,300,200,40);
        add(tfLogin);

        pfPasswd = new JPasswordField(100);
        pfPasswd.setBounds(300,350,200,40);
        add(pfPasswd);

        lImage = new JLabel();
        lImage.setBounds(300,50,200,204);
        lImage.setIcon(new ImageIcon(getClass().getResource("logo.png")));

        this.add(lImage);



    }

    public static void main(String[] args){
        Login_S loginFrame = new Login_S();
        loginFrame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
        loginFrame.setVisible(true);

    }

    @Override
    public void actionPerformed(ActionEvent arg0) {
        Object stream = arg0.getSource();
        if(stream == bLogin){


            Connection conn = null;

            try {

                String dbuser = "root";
                String dbpassw = "";
                String databaseName = "msfs_pro";
                String url = "jdbc:mysql://localhost/"+databaseName;
                String login = tfLogin.getText();
                char[] passwd = pfPasswd.getPassword();
                Class.forName("com.mysql.jdbc.Driver");
                conn = DriverManager.getConnection(url, dbuser, dbpassw);
                Statement st = conn.createStatement();
                ResultSet res = st.executeQuery("SELECT login, password FROM users WHERE login='"+login+"' AND password='"+passwd+"'");
                if(res.next()) {
                    JOptionPane.showMessageDialog(null, "You have Logged in!");
                } else {
                    JOptionPane.showMessageDialog(null, "Wrong user/password!");
                    System.out.println(tfLogin.getText());
                    System.out.println(pfPasswd.getPassword());
                }

                conn.close();
            }
            //Wyrzuć wyjątki jężeli nastąpią błędy z podłączeniem do bazy danych lub blędy zapytania o dane
            catch(ClassNotFoundException wyjatek) {
                System.out.println("Problem ze sterownikiem");
            }

            catch(SQLException wyjatek) {
                //e.printStackTrace();
                //System.out.println("Problem z logowaniem\nProsze sprawdzic:\n nazwę użytkownika, hasło, nazwę bazy danych lub adres IP serwera");
                System.out.println("SQLException: " + wyjatek.getMessage());
                System.out.println("SQLState: " + wyjatek.getSQLState());
                System.out.println("VendorError: " + wyjatek.getErrorCode());
            }
        }else if(stream == bExit){
            dispose();
        }
    }
}