Skip to main content

Generating JTable from database table

package process;
import javax.swing.*;
import javax.swing.table.*;
import java.sql.*;
/**
 * This class create JTable from Database table.
 * User program needs to specify database connection and corresponding atable name.
 * @author Hemraj
 */
public class TableToJTable{
    //private String table;
    private Connection con;
    public TableToJTable(Connection con){
        this.con=con;
    }
    /**
     * This method return JTable object created from Database table having same data asn structure
     * as in original table into database.
     * @param table Name of the database table to be coverted to JTable
     * @return JTable object that consist of data and structure of Database table
     * @throws java.lang.Exception Original object is deferent, e.i either SQLException or NullPointerException
     */
    public JTable getTable(String table)throws Exception{
        JTable t1=new JTable();
        DefaultTableModel dm=new DefaultTableModel();
        Statement st=con.createStatement();   
        ResultSet rs=st.executeQuery("select * from "+table);
        ResultSetMetaData rsmd=rs.getMetaData();
        //Coding to get columns-
        int cols=rsmd.getColumnCount();
        String c[]=new String[cols];
        for(int i=0;i<cols;i++){
            c[i]=rsmd.getColumnName(i+1);
            dm.addColumn(c[i]);
        }
        //get data from rows
        Object row[]=new Object[cols];
        while(rs.next()){
             for(int i=0;i<cols;i++){
                    row[i]=rs.getString(i+1);
                }
            dm.addRow(row);
        }
        t1.setModel(dm);
        con.close();
        return t1;
    }
    /**
     * This method return JTable object created from Database table having selected data and structure
     * as in original table into database.
     * @param table Name of the database table to be coverted to JTable
     * @param query Select query to specify selected columns and data to extracted from database table
     * @return JTable object that consist of selected data and structure of Database table
     * @throws java.lang.Exception Original object is deferent, e.i either SQLException or NullPointerException
     */
    public JTable getTable(String table,String query)throws Exception{
        JTable t1=new JTable();
        DefaultTableModel dm=new DefaultTableModel();
        Statement st=con.createStatement();
        ResultSet rs=st.executeQuery(query);
        ResultSetMetaData rsmd=rs.getMetaData();
        //Coding to get columns-
        int cols=rsmd.getColumnCount();
        String c[]=new String[cols];
        for(int i=0;i<cols;i++){
            c[i]=rsmd.getColumnName(i+1);
            dm.addColumn(c[i]);
        }


        //get data from rows
        Object row[]=new Object[cols];
        while(rs.next()){
             for(int i=0;i<cols;i++){
                    row[i]=rs.getString(i+1);
                }
            dm.addRow(row);
        }
        t1.setModel(dm);
        con.close();
        return t1;
    }


    public static void main(String ar[])throws Exception{
        JFrame f=new JFrame("Title");
        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        Connection con=DriverManager.getConnection("jdbc:odbc:mydsn");
        process.TableToJTable obj = new process.TableToJTable(con);
        JScrollPane sp=new JScrollPane(obj.getTable("user"));
        f.add(sp);
        f.setBounds(200,200,400,300);
        f.setVisible(true);       
    }
}





Comments

testing said…
love u..will try this now :)
Anonymous said…
JUST wonderful....


many thanks
Anonymous said…
i can compile sucessfully but there is a error on run time

plz tell me is there is another packge of process
Hemraj said…
Have you created database to be added in datasource with DSN name "mydsn". I think database connection is not proper. Please copy and paste error message here.
Narendra Tiwary said…
Hi Hemraj,
I have tried this code, it compiles correctly but when trying to run it asks for "Package" which you have mentioned in very first line of this program. Kindly see the exact error.
"Error: Could not find or load main class process.TableToJTable
Press any key to continue . . ."
Narendra Tiwary said…
Hello Hemraj,
I have tried your code it gives no error at compiling level but at run time it throws an error and keep asking for Package Process which you have mentioned in your program at very first line. Request you to kindly see the error message.

Error: Could not find or load main class process.TableToJTable
Press any key to continue . . .
I tried this but I get this
"The method isWritable(int) in the type ResultSetMetaData is not applicable for the arguments (String)"
I have some problems when i implement this code. This uís the error I get
"The method isWritable(int) in the type ResultSetMetaData is not applicable for the arguments (String)"
Read More Here said…
One of the best post I saw here. Keep it going! Thank you.

Popular posts from this blog

Using HyperSQL (HSQLDB)

HSQLDB is a portable RDBMS implemented in pure java. It can be embedded with your application as well as can be used separately. It is very a small database that supports almost all features of the standard database system. It comes with small jar file that can be found in lib folder. The HSQLDB jar package is located in the /lib directory of the ZIP package and contains several components and programs. Core components of jar file are : HyperSQL RDBMS Engine (HSQLDB), HyperSQL JDBC Driver, Database Manager, and Sql Tool. Installing and Using Download: download latest release of HyperSQL database from http://hsqldb.org website and extract it. You will see following contents. Here "bin" directory contains some batch files those can be used to run a swing based GUI tool. You can use runManagerSwing.bat to connect to database, but database must be on before running it. Directory lib contains File hsqldb.jar . It is the database to be used by you. Running database First ...

In Process Mode of HSQLDB in web application.

If you want to use the database into your web application, you can use the HSQLDB in In_Process mode. In this mode, you can embed the HSQLDB into your web application and it runs as a part of your web application programm in the same JVM. In this mode, the database does not open any port to connect to the application on the hosing machine and you don't need to configure anything to access it. Database is not expposed to other application and can not be accessed from any dabase tools like dbVisualizer etc. In this mode ,database will be unknown from any other person except you. But in the 1.8.0 version, you can use Server intance for external as well as in process access.  To close the databse, you can issue SHUTDOWN command as an SQL query.   In the in-process mode, database starts from JDBC with the associated databse file provided through  connection URL. for example   DriverManager.getConnection("jdbc:hsqldb:mydatabase","SA","");   Here myd...

How to handle values from dynamically generated elements in web page using struts2

Some time you will see the form containing the button " Add More " . This facility is provided for the user to get the values for unknown number of repeating for some information. for example when you are asking to get the projects details from user, you need to put the option to add the more project for the user since you don't known how many projects user have. In the HTML form, you repeat the particular section to get the multiple values for those elements. In Html page , you can put the option to add new row of elements or text fields by writing the java script or using JQuery API. Now, the question is that how to capture the values of dynamically generated text fields on the server. Using the servlet programming you can get the values by using getParameters() method that resultants the array of the parameter having the same name. But this limit you to naming the text fields in the HTML form. To ally this approach, you have to take the same name for t...