DecebalICT

Author table

Feb 14th, 2013
95
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Scala 1.45 KB | None | 0 0
  1.     class QTableViewAuthors(parent : QWidget) extends QTableView(parent) {
  2.         val authorsModel = new QStandardItemModel
  3.         val blockLayout  = new QVBoxLayout
  4.         val header       = Array(new QStandardItem("Author"), new QStandardItem("No of Quotes"))
  5.         val quotesButton  = new QPushButton("Quotes")
  6.  
  7.         var i      = 0
  8.         var rs     = null : ResultSet
  9.  
  10.  
  11.         def showQuotes() {
  12.             quotes.show
  13.         }
  14.  
  15.  
  16.         setSelectionMode(SelectionMode.ContiguousSelection)
  17.         setSelectionBehavior(SelectionBehavior.SelectRows)
  18.  
  19.         //quotesModel.setHorizontalHeaderLabels(Arrays.asList(header))
  20.         //quotesModel.setHorizontalHeaderLabels(header)
  21.         authorsModel.setHorizontalHeaderItem(0, header(0))
  22.         authorsModel.setHorizontalHeaderItem(1, header(1))
  23.  
  24.         i = 0
  25.         rs = stat.executeQuery("SELECT author, COUNT(*) AS no FROM quotes, authors WHERE quotes.authorID = authors.authorID GROUP BY author")
  26.         while (rs.next) {
  27.             val author = new QStandardItem(rs.getString("author"))
  28.             val nr     = new QStandardItem(rs.getString("no"))
  29.  
  30.             author.setEditable(false)
  31.             nr.setEditable(false)
  32.             authorsModel.setItem(i, 0, author)
  33.             authorsModel.setItem(i, 1, nr)
  34.             i += 1
  35.         }
  36.         setModel(authorsModel)
  37.         setColumnWidth(0, 750)
  38.         setColumnWidth(1, 175)
  39.         resize(1000, 600)
  40.     }
Advertisement
Add Comment
Please, Sign In to add comment