public DBUser GetUser()

in src/main/java/com/microsoft/aad/oidcpoc/db.java [114:141]

• 25 lines of code
• 4 McCabe index (conditional complexity)

	public DBUser GetUser(String uniqueId) {
		DBUser res = null;
        try {
            String selectSql = "SELECT * FROM [User] WHERE UniqueId = ?";
            PreparedStatement pstmt = connection.prepareStatement(selectSql);
            pstmt.setString(1, uniqueId);

        	ResultSet resultSet = pstmt.executeQuery();
            if (resultSet.next()) {
            	//we have a match
        		res = new DBUser();
        		res.UserId = resultSet.getInt("UserId");
        		res.Email = resultSet.getNString("Email");
        		res.FName = resultSet.getNString("FName");
        		res.LName = resultSet.getNString("LName");
        		res.UniqueId = resultSet.getNString("UniqueId");
            }
    		if (resultSet.next()) {
    			//sanity check - we had more than one match
    			res = null;
    		}
      		connection.close();
	    }
	    catch (Exception e) {
	            e.printStackTrace();
	    }
		return res;
	}