Java

Inserting into jtable

Please support our Java advertiser: Programming Forums - DaniWeb Sister Site

•

Join Date: Jul 2009

Posts: 28

Reputation: ashish2234 is an unknown quantity at this point

Solved Threads: 0

ashish2234 ashish2234 is offline

Offline

Light Poster

Inserting into jtable

Aug 17th, 2009

Actually , i must admit , i did not knew about connecting with database but i am trying to learn , i want to insert data into jtable from Ms acess database , i have made a table called song_library there and also created the dsn as testy1...Also in the in init function where the jTable is called i have written the code for connecting to the databse!! And i also know there is some problem i my code, i am posting that part of the code here:

 Help with Code Tags 
 JAVA Syntax (Toggle Plain Text) 
public void init() {
        try {
 
 
            java.awt.EventQueue.invokeAndWait(new Runnable() {
 
                public void run() {
                    initComponents();
                    loadDB();
                }
            });
 
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }
    public void loadDB()
    {
           try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            Connection c = DriverManager.getConnection("jdbc:odbc:testy1");
            Statement s = c.createStatement();
            ResultSet rs = s.executeQuery("select * from song_library");
            while (rs.next()) {
                jTable2.add(rs.getString(2),new Label()) ;
 
            }
 
        } catch (Exception e) {
 
        }
 
    }
public void init() {
        try {


            java.awt.EventQueue.invokeAndWait(new Runnable() {

                public void run() {
                    initComponents();
                    loadDB();
                }
            });

        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }
    public void loadDB()
    {
           try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            Connection c = DriverManager.getConnection("jdbc:odbc:testy1");
            Statement s = c.createStatement();
            ResultSet rs = s.executeQuery("select * from song_library");
            while (rs.next()) {
                jTable2.add(rs.getString(2),new Label()) ;
               
            }

        } catch (Exception e) {
            
        }

    }

•

Join Date: Nov 2007

Posts: 121

Reputation: puneetkay is on a distinguished road

Solved Threads: 23

puneetkay

Offline

Junior Poster

Re: Inserting into jtable

Aug 18th, 2009

A way to add rows to JTable :

 Help with Code Tags 
 java Syntax (Toggle Plain Text) 
// Header
			Object[] col = new Object[]{"Col1","Col2"};
			// Data
			Object[][] data = {}; // Blank
 
			DefaultTableModel model = new DefaultTableModel(data,col);
 
			JTable table = new JTable(model);
			// OR
			table.setModel(model);
 
 
			// Adding Rows
			model.addRow(new Object[]{"Data1","Data2"});
// Header
			Object[] col = new Object[]{"Col1","Col2"};
			// Data
			Object[][] data = {}; // Blank
			
			DefaultTableModel model = new DefaultTableModel(data,col);
			
			JTable table = new JTable(model);
			// OR
			table.setModel(model);
			
			
			// Adding Rows
			model.addRow(new Object[]{"Data1","Data2"});