@Override
	public User getUser(String login) {
		
		User user = null;
		PreparedStatement pStmt = null;
		ResultSet rs = null;
		
		try {
			
			pStmt = conn.prepareStatement("SELECT * FROM USER WHERE login = ?;");
			pStmt.setString(1, login);
			rs = pStmt.executeQuery();
			
			while (rs.next()) {
				
				user = new User();
				user.setLogin(login);
				user.setName(rs.getString("name"));
				user.setSurname(rs.getString("surname"));
				user.setPassword(rs.getString("password"));
				
			}
			
		} catch (SQLException e) {

			e.printStackTrace();
			
		} finally {
			
			closeResource(pStmt);
			closeResource(rs);
			
		}
		
		return user;
		
	}