Displaying a SQL table with qtjambi

    public QTableViewExample(QWidget parent) throws Exception
    {
        super(parent);

        Connection         conn;
        String[]           header = { "Quote", "Author"};
        int                i;
        QStandardItemModel model  = new QStandardItemModel();
        ResultSet          rs;
        Statement          stat;

        Class.forName("org.h2.Driver");
        conn = DriverManager.getConnection("jdbc:h2:tcp://localhost/~/citaten/quotes", "sa", "");
        stat = conn.createStatement();

        setSelectionMode(SelectionMode.ContiguousSelection);
        setSelectionBehavior(SelectionBehavior.SelectRows);

        model.setHorizontalHeaderLabels(Arrays.asList(header));

        i = 0;
        rs = stat.executeQuery("SELECT quote, author FROM quotes, authors WHERE quotes.authorID = authors.authorID");
        while (rs.next()) {
            QStandardItem quote  = new QStandardItem(rs.getString("quote"));
            QStandardItem author = new QStandardItem(rs.getString("author"));

            quote.setEditable(false);
            author.setEditable(false);
            model.setItem(i, 0, quote);
            model.setItem(i, 1, author);
            ++i;
        }
        setModel(model);
        setColumnWidth(0, 750);
        setColumnWidth(1, 175);
        resize(1000, 600);
    }