import java.io.Serializable;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import javax.faces.bean.ManagedBean;
import javax.faces.bean.SessionScoped;


@ManagedBean
@SessionScoped
public class UserBean {

    private static final long serialVersionUID = 6081417964063918994L;


    public List<User> getCars() throws ClassNotFoundException, SQLException {

        Connection connect = null;

        String url = "jdbc:mysql://localhost/pytania";

        String username = "root";
        String password = "";

        try {

            Class.forName("com.mysql.jdbc.Driver");

            connect = DriverManager.getConnection(url, username, password);
            // System.out.println("Connection established"+connect);

        } catch (SQLException ex) {
            System.out.println("in exec");
            System.out.println(ex.getMessage());
        }

        List<User> users = new ArrayList<User>();
        PreparedStatement pstmt = connect
                .prepareStatement("SELECT ID_user, login, password, rola, zablokowany, zmianahasla, wiadomosc, usuniety FROM users");
        ResultSet rs = pstmt.executeQuery();

        while (rs.next()) {

            User user = new User();
            user.setID_user(rs.getInt("ID_user"));
            user.setLogin(rs.getString("login"));
            user.setPassword(rs.getString("password"));
                        user.setRola(rs.getString("rola"));
            user.setUsuniety(rs.getInt("usuniety"));
                        user.setZablokowany(rs.getInt("zablokowany"));
            user.setZmianahasla(rs.getInt("zmianahasla"));
                        user.setWiadomosc(rs.getInt("wiadomosc"));

            users.add(user);

        }

        // close resources
        rs.close();
        pstmt.close();
        connect.close();

        return users;

    }

}