Loading

Please need some help about jtable thanks



good day guys...

i need some help here on how to populate a jtable with the data coming from ms access db. i'm using netbeans6.9. i made a code here but i cannot get it right.

please guys if anyone could help me on my problem, i would greatly appreciate it. thanks

here is my sample code:

  1.     public void PopulatejTable(){
  2.         String dbuser = "";
  3.         String dbpasswd = "";
  4.         String DriverPrefix = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=C:\\myWork2\\PersonalInfo\\db1.mdb";
  5.  
  6.         String SQLString = ("select * from Table1");
  7.  
  8.         try{
  9.             Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  10.         }catch(Exception e){
  11.             JOptionPane.showMessageDialog(null,""+e.getMessage(),"JDBC DRIVER Error",JOptionPane.WARNING_MESSAGE);
  12.             return;
  13.         }
  14.         Statement stmt = null;
  15.         Connection con = null;
  16.         ResultSet rset = null;
  17.  
  18.         try{
  19.             con = DriverManager.getConnection(DriverPrefix,dbuser,dbpasswd);
  20.             stmt = con.createStatement();
  21.         }catch(Exception e){
  22.             JOptionPane.showMessageDialog(null,""+e.getMessage(),"Connection Error",JOptionPane.WARNING_MESSAGE);
  23.         }
  24.  
  25.         try{
  26.             rset = stmt.executeQuery(SQLString);
  27.             while(rset.next()){
  28.                 jTable1.add(rset.getString(1),this);
  29.                 jTable1.add(rset.getString(2),this);
  30.                 jTable1.add(rset.getString(3),this);
  31.                 jTable1.add(rset.getString(4),this);
  32.             }
  33.                 con.close();
  34.         }catch(SQLException e){
  35.                JOptionPane.showMessageDialog(null,e.getMessage(),"Communication Error",JOptionPane.WARNING_MESSAGE);
  36.         }
  37.     }
  1.     public final void DesignjTable(){
  2.         Connection con = null;
  3.         String SQLString = ("select * from Table1");
  4.         try{
  5.             Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  6.             con = DriverManager.getConnection("jdbc:odbc:Driver={Microsoft Access Driver (*.mdb));DBQ=C:\\myWork2\\PersonalInfo\\db1.mdb");
  7.             Statement stmt = con.createStatement();
  8.             ResultSet rset = stmt.executeQuery(SQLString);
  9.  
  10.             jTable1.getColumnModel().getColumn(0).setPreferredWidth(20);
  11.             jTable1.getColumnModel().getColumn(1).setPreferredWidth(100);
  12.             jTable1.getColumnModel().getColumn(2).setPreferredWidth(20);
  13.             jTable1.getColumnModel().getColumn(3).setPreferredWidth(20);
  14.  
  15.             DefaultTableModel dtm = (DefaultTableModel)jTable1.getModel();
  16.             dtm.setNumRows(0);
  17.  
  18.             int li_row = 0;
  19.             while(rset.next()){
  20.                 dtm.addRow(new Object[] {rset.getString("ID"),rset.getString("Username"),rset.getString("Password"),rset.getString("Website")});
  21.                 jTable1.setValueAt(rset.getString(1), li_row, 0);
  22.                 jTable1.setValueAt(rset.getString(2), li_row, 1);
  23.                 jTable1.setValueAt(rset.getString(3), li_row, 2);
  24.                 jTable1.setValueAt(rset.getString(4), li_row, 3);
  25.                 li_row++;
  26.             }
  27.  
  28.         }catch(Exception e){
  29.         }
  30.     }

i'm using a 2 different kinds methods but still didn't lucky...

advance many thanks guys for help...



Naveen Kumar's picture

Submitted by Naveen Kumar on Fri, 05/06/2011 - 20:15

Hi this is naveen can u send me the complete code to my mail id with db let me check i can solve u r problam

mail me :- naveen001122@gmail.com

Add new comment