fun executeQuery(miniTable: IMiniTable) { log.info("") var sql = "" if (m_DD_Order_ID == null) return sql = getOrderSQL() log.fine(sql) var row = 0 miniTable.setRowCount(row) try { val pstmt: PreparedStatement = DB.prepareStatement(sql, null) pstmt.setInt(1, m_DD_Order_ID.toString().toInt()) val rs: ResultSet = pstmt.executeQuery() while (rs.next()) { miniTable.setRowCount(row + 1) miniTable.setValueAt(IDColumn(rs.getInt(1)), row, 0) miniTable.setValueAt(rs.getBigDecimal(2), row, 1) miniTable.setValueAt(rs.getString(3), row, 2) miniTable.setValueAt(rs.getString(4), row, 4) miniTable.setValueAt(rs.getString(5), row, 3) miniTable.setValueAt(rs.getString(6), row, 5) row++ } rs.close() pstmt.close() } catch (e: SQLException) { log.log(Level.SEVERE, sql, e) } miniTable.autoSize() }
Query Info