Posts by rafB • 79 points

10 posts

0
votes

2
answers

100
views

A: Select with reference in several tables

Below follows the proposed solution: SELECT e.*, (SELECT SUM(p.qtdpedido) FROM pedido p WHERE p.codigo = e.codigo) as qtdpedido, (SELECT tipo FROM produtos m WHERE m.codigo = e.codigo) as tipo FROM…

mysql sql select
answered 5 years, 7 months ago rafB 79
0
votes

2
answers

100
views

Q: Select with reference in several tables

I have three tables: PRODUTOS, PEDIDO and ESTOQUE, and I want to list all the stock by order and by products, as shown below: products codigo tipo medida 3020 | unico | 3 3021 | unico | 5 3022 |…

mysql sql select
asked 5 years, 7 months ago rafB 79
0
votes

1
answer

296
views

Q: Open pdf by URL and Inputstream Pdfview

I would like the user to enter the product code (at activity_main.xml) and click the button. The screen changes (view_pdf.xml), would make a PDF download (AnsyTask) and would open on PDFView for…

java android pdf inputstream
asked 6 years, 3 months ago rafB 79
0
votes

1
answer

52
views

Q: SELECT similar to "INNER JOIN" cell by cell of the record?

I have little knowledge about SQL and would like to know if it is possible to make a SELECT in the same record (row), and for each cell value bring the corresponding record of a second table.…

mysql
asked 6 years, 4 months ago rafB 79
0
votes

1
answer

216
views

Q: Copy Jtable Column to Clipboard?

I have here a table template with four columns and several rows filled in which I take the database. I would like to create an Action button that copies columns 2 and 3 at once to the clipboard, and…

java swing jtable clipboard
asked 6 years, 5 months ago rafB 79
0
votes

3
answers

422
views

A: Allow only integers in a Jtable column

Good morning. As commented Articuno, I had to change to not allow text or return zero, although it is very useful your suggestion. Thanks for the suggestions. Just to finish I’ll put the final chunk…

java swing jtable
answered 6 years, 10 months ago rafB 79
0
votes

3
answers

422
views

Q: Allow only integers in a Jtable column

Below I have a model of Jtable. There is only one editable column for number (seconds). How to validate to accept only integers, and in case the user enters anything else except integer, return…

java swing jtable
asked 6 years, 10 months ago rafB 79
5
votes

2
answers

2991
views

Q: SQL for last month and last two months

Hi. I’d like a hand here. I need to get the records: Mysql bank 1) last month 2) last quarter 3) Current year SELECT id, data, lote, modelo, qtd FROM controle_diario WHERE modelo like ? The table is…

mysql sql database select date
asked 7 years, 1 month ago rafB 79
0
votes

1
answer

61
views

Q: Search set of records by date

I am currently creating a Java/Mysql Desktop program. When inserting into the bank, the table is very simple: id - dataInserido - códigoProduto - qtd I would like, through an SQL, to group in…

java mysql
asked 7 years, 1 month ago rafB 79
1
votes

1
answer

765
views

Q: How to resize the application with the monitor?

I have an app that opens a JFrame, having at the top a JMenuBar. Until I call an item from Menubar one JTabbedPane, is hidden and as soon as a menu item is chosen, a Tabbed with jPanel inside opens.…

java swing
asked 7 years, 3 months ago rafB 79