javax.swing.table

[asai]

Hi,

I am a totally noob to Java programming, but I think I'm a fast learner.
Gor introduced to this language by a friend. I have tried a few other, but starting to like this very much.

I use Netbeans and have created at form containing a table, which get data from a Mysql database.
Work very well, however I can't find how to enable adding og deleting database content from my table.

I could really need som hints in the right direction.

Thanks in advance.

[rremedios]

Use the "INSERT" or "DELETE" SQL statements to add or delete

[asai]

I have these lines of code:

        try{
            vectordata = LedgerTable.SelectAll();
        }catch(SQLException ex){}
        LedgerGrid.setModel(new javax.swing.table.DefaultTableModel(vectordata.getData(), vectordata.getColumns()
        ));

I have a file called Mysql.Tables.LedgerTable which have the statements, but I am not sure how to call them in the table..

Here is the lines with SelectAll:

public static VectorData SelectAll() throws SQLException
    {
        Connection connection = Connector.getConnection();
        PreparedStatement ps = null;
        ResultSet rs = null;     
        VectorData vectorData = null;

        String query = "SELECT * FROM LedgerTable ORDER BY Account";
        try {
            ps = connection.prepareStatement(query);
            rs = ps.executeQuery();
            ResultSetMetaData meta = rs.getMetaData();              
            int columnCount = meta.getColumnCount();
            int fechSize = rs.getFetchSize();
            Vector data = new Vector();
            Vector row;
            Vector columns = new Vector();

            for (int i = 1; i <= columnCount; i++) {
                columns.add(meta.getColumnName(i));
            }

            while (rs.next()) {
                row = new Vector(columnCount);

                    for (int i = 1; i <= columnCount; i++) {
                        Object object = rs.getObject(i);
                        if (object instanceof Integer) {
                            row.add(Integer.parseInt(object.toString()));
                        }else if (object instanceof Double) {
                            row.add(Double.parseDouble(object.toString()));
                        }else if (object instanceof String) {
                            row.add(object);
                        }else {
                            row.add(object);
                        }
                    }
                    data.add(row);
                }
                vectorData = new VectorData(data, columns);
                return vectorData;                       
            
        } catch (SQLException ex) {
            Logger.getLogger(LedgerTable.class.getName()).log(Level.SEVERE, null, ex);           
        } finally {
            connection.close();
        }
        return vectorData;
    }

Insert statement:

public static void insert(Ledger ledger)
    {
        Connection connection = Connector.getConnection();
        PreparedStatement ps = null;

        String query = "INSERT INTO LedgerTable(Account, Name, Type, Balance)"
                        +" VALUES(?,?,?,?)";
        
        try {
            
            ps = connection.prepareStatement(query);
            ps.setInt(1, ledger.getaccount());
            ps.setString(2, ledger.getaccountName());
            ps.setString(3, ledger.getaccountType());
            ps.setDouble(4, ledger.getbalance());               
            ps.executeUpdate();
            
        } catch (SQLException ex){            
            Logger.getLogger(LedgerTable.class.getName()).log(Level.SEVERE, null, ex);  
            
        } finally{
            try {
                connection.close();
            } catch (SQLException ex) {
                Logger.getLogger(LedgerTable.class.getName()).log(Level.SEVERE, null, ex);
            }
        }
    }

So, how could I call the Insert statement into my table?