Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- class QTableViewAuthors(parent : QWidget) extends QTableView(parent) {
- val authorsModel = new QStandardItemModel
- val blockLayout = new QVBoxLayout
- val header = Array(new QStandardItem("Author"), new QStandardItem("No of Quotes"))
- val quotesButton = new QPushButton("Quotes")
- var i = 0
- var rs = null : ResultSet
- def showQuotes() {
- quotes.show
- }
- setSelectionMode(SelectionMode.ContiguousSelection)
- setSelectionBehavior(SelectionBehavior.SelectRows)
- //quotesModel.setHorizontalHeaderLabels(Arrays.asList(header))
- //quotesModel.setHorizontalHeaderLabels(header)
- authorsModel.setHorizontalHeaderItem(0, header(0))
- authorsModel.setHorizontalHeaderItem(1, header(1))
- i = 0
- rs = stat.executeQuery("SELECT author, COUNT(*) AS no FROM quotes, authors WHERE quotes.authorID = authors.authorID GROUP BY author")
- while (rs.next) {
- val author = new QStandardItem(rs.getString("author"))
- val nr = new QStandardItem(rs.getString("no"))
- author.setEditable(false)
- nr.setEditable(false)
- authorsModel.setItem(i, 0, author)
- authorsModel.setItem(i, 1, nr)
- i += 1
- }
- setModel(authorsModel)
- setColumnWidth(0, 750)
- setColumnWidth(1, 175)
- resize(1000, 600)
- }
Advertisement
Add Comment
Please, Sign In to add comment