yesaya handoyo

Yes,by a swing jtable..Can you help me?Thanks..

Hi guys..I want to ask..Is it possible to print the datas from a jtable by using ireport???Can someone teach me how to do it??I'm intending to create a pos application..Thanks a lot..

I use it in the TableModelListener and it works for me..Thanks...

My question is how to add a row when i press enter on the last column of a row..The code i got works fine with me..Please help me if you guys have a better idea...Thanks a lot..

This is the code that i get from netbeans forum and it works for me
DefaultTableModel dtm=(DefaultTableModel) tablename.getModel(); dtm.addRow(Object []); tablename.setModel(dtm);

I'm sorry guys...My question is how to add a row,and thank God i'ved got the answers for my problem...Thanks a lot...

Hi guys..i need help about adding row to jtable..These are the codes that i've make using netbeans..

/* * JualHarianFrame.java * * Created on October 24, 2008, 12:58 PM */ package han.pos.gui; import han.pos.dao.mysql.ProdukDAOImpl; import han.pos.db.mysql.DBConnection; import han.pos.model.Produk; import java.awt.event.KeyEvent; import java.sql.SQLException; import java.util.ArrayList; import java.util.List; import java.util.logging.Level; import java.util.logging.Logger; import javax.swing.event.TableModelEvent; import javax.swing.event.TableModelListener; import javax.swing.table.DefaultTableModel; import javax.swing.table.TableModel; /** * * @author yesaya */ public class JualHarianFrame extends javax.swing.JInternalFrame implements TableModelListener { private List<Produk> Produk = new ArrayList<Produk>(); /** Creates new form JualHarianFrame */ public JualHarianFrame() { initComponents(); tblJual.getModel().addTableModelListener(this); lblTotal.setText("0"); } //code by netbeans.. tblJual.setAutoCreateRowSorter(true); tblJual.setModel(new javax.swing.table.DefaultTableModel( new Object [][] { {null, null, null, null, null} }, new String [] { "PLU", "NAMA", "HARGA", "QTY", "TOTAL" } ) { Class[] types = new Class [] { java.lang.String.class, java.lang.String.class, java.lang.Double.class, java.lang.Integer.class, java.lang.Double.class }; public Class getColumnClass(int columnIndex) { return types [columnIndex]; } } ); tblJual.setColumnSelectionAllowed(true); tblJual.setSelectionMode(javax.swing.ListSelectionModel.MULTIPLE_INTERVAL_SELECTION); tblJual.addKeyListener(new java.awt.event.KeyAdapter() { public void keyPressed(java.awt.event.KeyEvent evt) { tblJualKeyPressed(evt); } }); jScrollPane1.setViewportView(tblJual); public void tableChanged(TableModelEvent e) { Double hrg,total=null; int qty; if (e.getType() == TableModelEvent.UPDATE) { int row = e.getFirstRow(); int column = e.getColumn(); TableModel model = (TableModel)e.getSource(); if (column==0) { try { DBConnection conn = DBConnection.getInstance(); ProdukDAOImpl dao = new ProdukDAOImpl(conn.getCon()); String plu = model.getValueAt(row, 0).toString(); Produk = dao.getPlu(plu); for (Produk produk :-P roduk) { String nama=produk.getNama().toString(); Double harga=produk.getHarga_jual(); model.setValueAt(nama, row, 1); model.setValueAt(harga, row, 2); tblJual.setColumnSelectionInterval(3, 3); } } catch (SQLException ex) { Logger.getLogger(JualHarianFrame.class.getName()).log(Level.SEVERE, null, ex); } } else if (column==3){ qty=Integer.parseInt(model.getValueAt(row, 3).toString()); hrg=(Double) model.getValueAt(row, 2); total=qty*hrg; model.setValueAt(total, row, 4); lblTotal.setText(String.valueOf(total)); } } }

Hi all,i want to ask.I'm using JTable with Netbeans..Is it possible to get the edited column and search it into database,and put the other data to the other column?For example,i got a table with which columns are code,name,price,qty,total.When i edited the code column,and on keypressed,it will search into database..How i should deal with it??Please help me...Thanks a lot...

Hi Jeanne,sorry..I found out the problem.I don't need to use the ChangeMenu()..Thanks a lot..And sorry..

This is the code that i use :

ListModel list=JList.getModel(); for (int i=0;i<list.getSize();i++){ Menuuser menuuser= new Menuuser(); String menu=(String) list.getElementAt(i);

Hi all,i need help..I use a JList to display data from mysql data..When i delete the data from the JList,it doesn't display the way i hope..Here are the codes i've made and the sql for the tables..I got data about usrname,menu and description.When the admin add user,the menu will be saved instead of description.And when the admin want to edit the authorization,the JList will display the description instead of the menu.Thanks a lot...

The sql file :
create table `data_user` ( `id` int(11) auto_increment, `nama` varchar(13), `usrname` varchar(6), `pwd` varchar(50), `jabatan` varchar(10), `last_login` datetime, primary key (`id`) )TYPE=MYISAM; INSERT INTO `data_user` (`id`,`nama`,`usrname`,`pwd`,`jabatan`,`last_login`) VALUES ('1','ADMIN','ADM','21232f297a57a5a743894a0e4a801fc3','ADM','2008-09-05 22:00:00'); create table `jabatan` ( `kode` varchar(3), `jabatan` varchar(10) ) TYPE=MYISAM; INSERT INTO `jabatan` (`kode`,`jabatan`) VALUES ('ADM','ADMINISTRATOR'); INSERT INTO `jabatan` (`kode`,`jabatan`) VALUES ('BOS','OWNER'); create table `hak_user` ( `usrname` varchar(6), `menu` varchar(20) )TYPE=MYISAM; INSERT INTO `hak_user` (`usrname`,`menu`) VALUES ('ADM','mnuSupplier'); INSERT INTO `hak_user` (`usrname`,`menu`) VALUES ('ADM','mnuMasterBarang'); INSERT INTO `hak_user` (`usrname`,`menu`) VALUES ('ADM','mnuUser'); INSERT INTO `hak_user` (`usrname`,`menu`) VALUES ('ADM','mnuPO'); INSERT INTO `hak_user` (`usrname`,`menu`) VALUES ('ADM','mnuJualHarian'); create table `menu_user` ( `menu` varchar(20), `deskripsi`varchar(70) )TYPE=MYISAM; INSERT INTO `menu_user` (`menu`,`deskripsi`) VALUES ('mnuSupplier','MASTER-MENU SUPPLIER'); INSERT INTO `menu_user` (`menu`,`deskripsi`) VALUES ('mnuMasterBarang','MASTER-MENU MASTER BARANG'); INSERT INTO `menu_user` (`menu`,`deskripsi`) VALUES ('mnuUser','MASTER-MENU USER'); INSERT INTO `menu_user` (`menu`,`deskripsi`) VALUES ('mnuPO','PEMBELIAN-MENU PO'); INSERT INTO `menu_user` (`menu`,`deskripsi`) VALUES ('mnuJualHarian','PENJUALAN-HARIAN');

the codes :
public void loadMenuUser(){ listModel=new DefaultListModel(); try{ DBConnection conn = DBConnection.getInstance(); HakUserDAOImpl dao = new HakUserDAOImpl(conn.getCon()); Hakuser = dao.getAll(txtUser.getText()); for (Hakuser hakuser : Hakuser) { listModel.addElement(hakuser.getMenu()); } listMenu2.setModel(listModel); } catch (SQLException ex) { Logger.getLogger(DataUserFrame.class.getName()).log(Level.SEVERE, null, ex); } } public void ChangeMenu(){ ListModel list=listMenu2.getModel(); for (int i=0;i<list.getSize();i++){ Menuuser menuuser= new Menuuser(); String menu=(String) list.getElementAt(i); try{ Class.forName("com.mysql.jdbc.Driver"); String lokasi = "jdbc:mysql://localhost/inventory?" + "user=admin&password=admin"; String SQL="Select deskripsi from menu_user where menu=?"; Connection koneksi = DriverManager.getConnection(lokasi); PreparedStatement ptmt=koneksi.prepareStatement(SQL); ptmt.setString(1, menu); ptmt.executeQuery(); ResultSet rs=ptmt.executeQuery(); while (rs.next()){ menuuser.setDeskripsi(rs.getString(1)); for (Menuuser user : Menuuser) { // menuuser.setDeskripsi(rs.getString(1)); listModel.removeElementAt(i); //listModel.setElementAt(user.getDeskripsi(), i); listModel.addElement(user.getDeskripsi()); } listMenu2.setModel(listModel); } } catch(Exception x){ JOptionPane.showMessageDialog(this,x); } } } public DataUserFrame() { initComponents(); loadMenuUser(); ChangeMenu(); //listModel = new DefaultListModel(); } private void btRemoveActionPerformed(java.awt.event.ActionEvent evt) { try { DBConnection conn = DBConnection.getInstance(); HakUserDAOImpl dao2 = new HakUserDAOImpl(conn.getCon()); Object selected[] = listMenu2.getSelectedValues(); Hakuser hakuser= new Hakuser(); for (int i = selected.length - 1; i >= 0; --i) { // dao2.delete((String) selected[i]); try{ Class.forName("com.mysql.jdbc.Driver"); String lokasi = "jdbc:mysql://localhost/inventory?" + "user=admin&password=admin"; String SQL="Select menu from menu_user where deskripsi=?"; Connection koneksi = DriverManager.getConnection(lokasi); PreparedStatement ptmt=koneksi.prepareStatement(SQL); ptmt.setString(1,(String) selected[i]); ResultSet rs=ptmt.executeQuery(); while (rs.next()){ String menu=rs.getString(1) hakuser.setMenu(menu); //gantiMenu(); dao2.delete(hakuser.getMenu()) //loadMenuUser(); //ChangeMenu(); listModel.removeElement(selected[i]); // JOptionPane.showMessageDialog(this, "Datasselected[i]+" berhasil dihapus"); JOptionPane.showMessageDialog(this, "Data "+menu+" berhasil dihapus"); } } catch(Exception x) { JOptionPane.showMessageDialog(this,x); } listMenu2.getSelectionModel().clearSelection(); } } catch (SQLException ex) {Logger.getLogger(DataUserFrame.class.getName()).log(Level.SEVERE, null, ex); } }

Ok,thanks Rob.May God bless you for your help..

Never mind Jeanne..I'ved worked it out.I read the api about JList..And i have got it work..Thanks a lot Jeanne.May God bless you for your help...

Hi Jeanne,i need help about saving Strings from JList into database.I got 2 table,one is user_rights contain username and menu,the other one is user_menu contain menu and description.I put the JMenu name into the menu field for authorizing the user.And what i display in the JList is the desc which contains the description for the menu.For examples..The menu is mnuUser,then the desc is Menu-Master-User..The data that i would like to save is the menu,not the desc..Thanks a lot...

Ok,i'll try it out.Suppose using netbeans is no a big difference,isn't it?Thanks..