Invoking ODBC database source administrator component of windows

[Fawad Ali]

Hi All,
I am very much new to Swing. I have mainly worked in J2EE. But the first task which I am assigned in Swing is that I need to invoke an ODBC database source administrator component of windows from a swing button. So can anyone help me in this regard. Or if you may suggest me with a tutorial or something, that will be great. I have attached a screenshot which shows the windows component.

Thanks in advance.

[Rob Camick]

You need to go to the "System DSN" tab to create your data source.

The following then shows the two ways to access the database using the Access driver. You can access the database directly or through the ODBC name:

 
import java.awt.*;
import java.sql.*;
import java.util.*;
import javax.swing.*;
import javax.swing.table.*;

public class TableFromDatabase extends JFrame
{
    public TableFromDatabase()
    {
        Vector columnNames = new Vector();
        Vector data = new Vector();

        try
        {
            //  Connect to the Database

            String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
            String url = "jdbc:odbc:Teenergy";  // if using ODBC Data Source name
            String userid = "";
            String password = "";

            Class.forName( driver );
            Connection connection = DriverManager.getConnection( url, userid, password );

            //  Read data from a table

            String sql = "Select * from Activity";
            Statement stmt = connection.createStatement();
            ResultSet rs = stmt.executeQuery( sql );
            ResultSetMetaData md = rs.getMetaData();
            int columns = md.getColumnCount();

            //  Get column names

            for (int i = 1; i <= columns; i++)
            {
                columnNames.addElement( md.getColumnName(i) );
            }

            //  Get row data

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

                for (int i = 1; i <= columns; i++)
                {
                    row.addElement( rs.getObject(i) );
                }

                data.addElement( row );
            }

            rs.close();
            stmt.close();
            connection.close();
        }
        catch(Exception e)
        {
            System.out.println( e );
        }

        //  Create table with database data

        JTable table = new JTable(data, columnNames)
        {
            public Class getColumnClass(int column)
            {
                for (int row = 0; row < getRowCount(); row++)
                {
                    Object o = getValueAt(row, column);

                    if (o != null)
                    {
                        return o.getClass();
                    }
                }

                return Object.class;
            }
        };

        JScrollPane scrollPane = new JScrollPane( table );
        getContentPane().add( scrollPane );

        JPanel buttonPanel = new JPanel();
        getContentPane().add( buttonPanel, BorderLayout.SOUTH );
    }

    public static void main(String[] args)
    {
        TableFromDatabase frame = new TableFromDatabase();
        frame.setDefaultCloseOperation( EXIT_ON_CLOSE );
        frame.pack();
        frame.setVisible(true);
    }
}

The code formatting doesn't like the following code, but here is how you can map the database directly without using ODBC:

// String url =
// "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=c:/teenergy/data/teenergy.mdb";

I don't know how to turn of the Emoticons. See below for actual code.

[Darryl Burke]

I don't know how to turn of the Emoticons

There's a checkbox for "Disable smilies in this message"
|
|
|
|
|
V

[Rob Camick]

There's a checkbox for "Disable smilies in this message"

Thanks.

For some reason this doesn't work when I edit my original posting. Maybe this property can't be edited?

Anyway here is the code I intended to post.

// String url =
//     "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=c:/teenergy/data/teenergy.mdb";

[Rob Spoor]

I'll move this to our JDBC forum as I see no GUI programming in there.

The given JDBC driver works but I've heard it has some flaws. There are other ODBC JDBC drivers available, both commercial and non-commercial. So if you run into problems with this one you can easily switch to another - all you need to do is load another driver, possibly change the connection string, and the rest can stay the same.