Inserting into jtable

Expand Post »

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:

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) {
            
        }

    }

Similar Threads

How to make JTable cell not Editable in Java
deleting rows from a JTable in Java
JTable Reloading/Refreshing/Updating/Whatever. in Java
Jtable in Java
Adding and deleting a column in JTable in Java

ashish2234

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

28 posts
since Jul 2009

Permalink

Aug 18th, 2009

Re: Inserting into jtable

A way to add rows to JTable :

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"});

Hope this will help you.

puneetkay

Reputation Points: 51

Solved Threads: 24

Junior Poster

Offline

122 posts
since Nov 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in Java Forum Timeline: any collections of how to BUILd OR MAKE JAVA applications

Next Thread in Java Forum Timeline: i need sollution

DaniWeb Message

Cancel Changes

User Name
Password