count

cursor

userId

userQuery

Viewer_viewer

user

User_user

User_discussionList

User_groupList

viewer

name

username

profilePicture

profilePictureName

discussionCount

followerCount

followingCount

isViewer

viewerFollows

followsViewer

discussions

groupsIn

query userQuery(
  $count: Int!
  $cursor: String
  $userId: ID!
) {
  ...Viewer_viewer
  user(id: $userId) {
    ...User_user
    ...User_discussionList
    ...User_groupList
    id
  }
}

fragment CommentListItem_comment on Comment {
  id
  _id
  body
  createdAt
  discussionId
  excerpt
  discussion {
    id
    _id
  }
  user {
    id
    _id
    name
    username
    profilePicture
    profilePictureName
  }
}

fragment DiscussionLike_discussion on Discussion {
  id
  _id
  viewerDoesLike
  likeCount
}

fragment FollowButton_user on User {
  _id
  name
  viewerFollows
  followsViewer
}

fragment GroupListItem_group on Group {
  id
  _id
  name
  permalink
  publicUrl
  headerImage {
    name
    id
  }
}

fragment Poll_discussion on Discussion {
  votingHasEnded
  viewerHasVoted
  hideVotes
  hasPoll
  viewerOwns
  voteCount
  pollClosesAt
  poll(first: 20) {
    edges {
      node {
        id
        _id
        title
        voteCount
        viewerSelected
        __typename
      }
      cursor
    }
    pageInfo {
      endCursor
      hasNextPage
    }
  }
}

fragment PostListItem_discussion on Discussion {
  id
  _id
  name
  reads
  publicUrl
  parsedExcerpt(size: 30)
  wordCount
  commentCount
  permalink
  comments(last: 3) {
    pageInfo {
      hasNextPage
      endCursor
      hasPreviousPage
      startCursor
    }
    edges {
      node {
        id
        excerpt
        ...CommentListItem_comment
        __typename
      }
      cursor
    }
  }
  createdAt
  user {
    id
    _id
    name
    username
    profilePicture
    profilePictureName
  }
  group {
    id
    _id
    name
    permalink
    publicUrl
  }
  featurePhoto {
    id
    _id
    height
    width
    name
  }
  hasPoll
  ...DiscussionLike_discussion
  ...Poll_discussion
}

fragment User_discussionList on User {
  discussions(first: $count, after: $cursor, byLatest: true) {
    pageInfo {
      hasNextPage
      endCursor
    }
    edges {
      node {
        id
        ...PostListItem_discussion
        __typename
      }
      cursor
    }
  }
}

fragment User_groupList on User {
  groupsIn(first: $count, after: $cursor) {
    pageInfo {
      hasNextPage
      endCursor
    }
    edges {
      node {
        id
        ...GroupListItem_group
        __typename
      }
      cursor
    }
  }
}

fragment User_user on User {
  id
  _id
  name
  bio
  username
  profilePicture(size: 250)
  profilePictureName
  discussionCount
  followerCount
  followingCount
  isViewer
  ...FollowButton_user
}

fragment Viewer_viewer on Query {
  viewer {
    name
    username
    profilePicture(size: 50)
    profilePictureName
    _id
    id
  }
}


Hello, Joyce, try doing it non-graphically.

I've had no luck using the NetBeans GUI Builder to bind data from an SqLite DB to a JTable, but I've done it manually using Vectors. Try this:



package gpacalc;
import java.awt.BorderLayout;
import java.sql.*;
import java.util.Vector;
import javax.swing.*;
/**
 *
 * @author etin
 */
public class tableview {
    public tableview(){
        Connection conn;
        Statement stmt;
        ResultSet rs;
        ResultSetMetaData rsmd;
        int columnCount;
        
        try{
            Class.forName("org.sqlite.JDBC");
            conn = DriverManager.getConnection("jdbc:sqlite:courses.db");
            String sql = "select * from coursedetails";
            stmt = conn.createStatement();
            rs = stmt.executeQuery(sql);
            rsmd = rs.getMetaData();
            columnCount = rsmd.getColumnCount();
            Vector column = new Vector(columnCount);
            for(int i=1; i<= columnCount; i++){
                column.add(rsmd.getColumnName(i));
            }
            Vector data = new Vector();
            Vector row = new Vector();
            while(rs.next())
            {
                row = new Vector(columnCount);
                for(int i =1; i <= columnCount; i++){
                    row.add(rs.getString(i));
                }
                data.add(row);
            }
            JFrame frame = new JFrame();
            frame.setSize(1000 , 700);
            frame.setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
            JPanel panel = new JPanel();
            final JTable table = new JTable(data,column);
            JScrollPane jsp = new JScrollPane(table);
            panel.setLayout(new BorderLayout());
            panel.add(jsp,BorderLayout.CENTER);
            frame.setContentPane(panel);
            frame.setVisible(true);
            
        } 
        catch(ClassNotFoundException | SQLException ex){
            System.out.println("Error: " + ex.getMessage());
        }
        }
    
}



Although, You'll of course have to modify it to suit your uses, the basic concept should be the same.