getUserFromCredentials

public static User getUserFromCredentials(String loginname, String password){

        User result = null;
        Connection con = null;

        try{

            con = JDBCConnectionFactory.getNewConnection();

        String sql = "SELECT * FROM User WHERE User.userName = ? AND User.password = ?";
        PreparedStatement prep = con.prepareStatement(sql);
        prep.setString(1, loginname);
        prep.setString(2, password);
        ResultSet res = prep.executeQuery();
         while (res.next()) {
             result = createUserFromResultSet(res);
         }



        } catch(SQLException e) {

            e.printStackTrace();

        } finally {
            JDBCConnectionFactory.closeConnection(con);

    }
        return result;
    }