Feyna Reendrina

I want to write a Excel file in java desktop and make a chart in it. Please guide me how can I achieve that.

bye
Thanks in advance.

i need to make it fast...
is select using SQL faster than sorted rowset??
how about if database that used is in server??

any one know where i can get WebLogic's jar???

thx..

guys, i need your help....

i want to display my database with filter and sorter....
to filter i have been using filteredrowset
but to sort it, i don't know what class that i can use....

i try to find at internet.. and i found sortedrowset (weblogic.jdbc.rowset.SortedRowSet)....

but i can't get import of it...
i try using :
import weblogic.jdbc.rowset.SortedRowSet;

but it is ended by error...

is i must install the package??
but i can't get any packages download...

Can you help me??

Thx..

I want to have a combobox in table....
where is the value (items) is different depends on the value of other cell in the table in same row....

i didn't know where i can put the code..
i have been placed the code in event comboPopupMenuWillBecomeVisible

this is the code:

combo.removeAllItems(); combo.addItem("PCS"); combo.addPopupMenuListener(new javax.swing.event.PopupMenuListener() { public void popupMenuCanceled(javax.swing.event.PopupMenuEvent evt) { } public void popupMenuWillBecomeInvisible(javax.swing.event.PopupMenuEvent evt) { } public void popupMenuWillBecomeVisible(javax.swing.event.PopupMenuEvent evt) { comboPopupMenuWillBecomeVisible(evt); } }); combo.addMouseListener(new java.awt.event.MouseAdapter() { public void mousePressed(java.awt.event.MouseEvent evt) { comboMousePressed(evt); } }); TableCellEditor editor = new DefaultCellEditor(combo); TableColumnModel columnModel=Table.getColumnModel(); TableColumn satuanColumn = columnModel.getColumn(2); satuanColumn.setCellEditor(editor);

public void comboPopupMenuWillBecomeVisible(javax.swing.event.PopupMenuEvent evt) { int[] selected = Table.getSelectedRows(); if (selected.length>=1) { String cmd="select satuan1, satuan2, satuan3 from mbarang where idbarang="+model.getValueAt(selected[0], -1); ResultSetAdapter rsa=new ResultSetAdapter(con); if (rsa.executeQuery(cmd)) { FilteredRowSet frs=rsa.getRowSet(); if (frs.size()>0) { try { frs.first(); combo.removeAllItems(); String s=frs.getString(1); combo.addItem(s); s=frs.getString(2); if (!frs.equals("")) combo.addItem(s); s=frs.getString(3); if (!frs.equals("")) combo.addItem(s); }catch (SQLException e) { } } } } }

i want to make the table model using FilteredRowSet, but i have some problem to get row count...

method size of FilteredRowSet, can not be used!! beacuse it will be return count of record in FilteredRowSet that inserted and deleted....

what i want is to get count of active record (no deleted record)...

i using this script to claculate...
but it will be always SQLException when reach the last record, if i delete the last record!!

public int getRowCount() { int counter=0; if (crs.size()>0) { try{ crs.beforeFirst(); while (!crs.isLast()) { if (crs.next()) counter++; else break; } }catch(SQLException e) { System.out.println("SQLException"); System.out.println(".. method getRowCount, class adapter.transaksiTableModel"); } } return counter; }

i want to print just only one single string...

how can i do it??

must i write it in the file first??

thx

i need it for my database project, where is can be have large record or database...

so i think, is it take time if i use max's method???
is you means that i must list all record in database (INSERT) and the table (TABLE)??? is it will take time for large database???

i have been tried the example (MySqlHotCopy.java) at
http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html

but it doesn't work....
when i try to get the packages
import org.apache.commons.io.FileUtils; at
http://www.kickjava.com/src/org/apache/commons/io/FileUtils.java.htm
but i can find what are IOUtils and CopyUtils ?? (i have been download all import packages)

beside that, directory source is input by user....
can we get it automatically??? (in mySQL)
example using registry like in Delphi??

Can you help me??


thanks you very much,...

ok..thx

it is very helpfull...
it works now...

thx

i can zip a file... but
i have some problem to zip a directories....

Can you help me??

thx

i want to make a application that have some facilities like back up and restore database....

i make the application using java and netbeans as GUI
and i use mysql as my database....

can you help me, hor to back up and restore mysql database in java language..


thx

i have some similar problem....

i try to get large record....in 3 tables, and for 100 records each table..
so i want get 1000.000 records... but there is exception:

Exception in thread "AWT-EventQueue-0" java.lang.OutOfMemoryError: Java heap space

and i use netbeans for GUI....

i don't know where i must put the command...can u tell me??

thx