[ask] Data Tidak Tampil di Table, seperti ini codingannya, kira-kira salahnya di mana master? Terimakasih ya mohon sekali pencerahannya. INI BAGIAN PACKAGE DAN SETERUSNYA import java.sql.*; import javax.swing.*; import javax.swing.table.*; import java.sql.*; import javax.swing.*; import javax.swing.table.*; public class products extends javax.swing.JFrame { private Connection conn; private Statement st; private static PreparedStatement pst=null; public products() { initComponents(); tampilkandata(); } LALU INI CODINGAN METHOD-METHODNYA private void konek() { try { Class.forName(com.mysql.jdbc.Driver);//Koneksi dengan driver MySQL System.out.println(Driver berhasil ditemukan.......); conn=(DriverManager.getConnection(jdbc:mysql://localhost/inventory, root, ));//Koneksi dengan database MySQL st = conn.createStatement(); System.out.println(Koneksi Berhasil); } catch (ClassNotFoundException ex) { System.err.println(Koneksi Database MySQL GAGAL); } catch (SQLException ex) { System.err.println(database tidak ada); } } private void tampilkandata() { DefaultTableModel isitabel = new DefaultTableModel(); isitabel.addColumn(Product Code); isitabel.addColumn(Product Name); isitabel.addColumn(Price); isitabel.addColumn(Stock); try { konek(); ResultSet rs = st.executeQuery( SELECT * FROM inventory order by product_code asc); while (rs.next()) { isitabel.addRow(new Object[]{ rs.getString(product_code), rs.getString(product_name), rs.getString(price), rs.getString(stock)}); } jTable1.setModel(isitabel); } catch (Exception e) { }
Posted on: Sun, 25 Jan 2015 05:34:58 +0000
Trending Topics
Recently Viewed Topics
© 2015