JTABLE IS NOT RETIVING DATE FROM MS ACCESS

Ads
 

JTABLE IS NOT RETIVING DATE FROM MS ACCESS

PLEZ help me to retrive date from access to jtable.......

import java.awt.BorderLayout;
import java.sql.*;
import javax.swing.*;
import java.awt.event.*;
import java.util.*;

public class StudentIssueView extends  JFrame {
    private Connection connection;
    private JTable  table;
    private Object currentRow;

    public StudentIssueView  ()
    {

       try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            connection=DriverManager.getConnection("jdbc:odbc:college" );
        }
        catch(ClassNotFoundException cnfex) {
            System.err.println("Failed to load Jdbc/Odbc driver.");
            cnfex.printStackTrace();
            System.exit(1);
          }
        catch(SQLException sqlex) {
            System.err.println("Unable to connect");
            sqlex.printStackTrace();
        }
        getTable();
        setSize(1000,150);
        setVisible(true);
        setResizable(false);
    }
    private void getTable()
    {
        Statement statement;
        ResultSet resultSet;

        try
 {
            String  query="Select * from Student";
            statement=connection.createStatement();
            resultSet=statement.executeQuery(query);
            displayResultSet(resultSet);
            statement.close();
            }
        catch(SQLException sqlex) {
            sqlex.printStackTrace();
        }
    }
    private void displayResultSet(ResultSet rs)throws SQLException
    {
        boolean moreRecords=rs.next();

        if(!moreRecords) {
            JOptionPane.showMessageDialog(this, "ResultSet contained no records");
            setTitle("No records to display");
            return;
        }
        setTitle("Student Book Issue Details");
        Vector columnHeads=new Vector();
        Vector rows=new Vector();

        try {
            ResultSetMetaData rsmd=rs.getMetaData();

            for(int i=1; i<=rsmd.getColumnCount(); i++)
                columnHeads.addElement(rsmd.getColumnName(i));

            do {
                rows.addElement(getNextRow(rs, rsmd));

            } while(rs.next());
            table =new JTable(rows, columnHeads);
            JScrollPane scroller=new JScrollPane(table);
            getContentPane().add(scroller, BorderLayout.CENTER);
            validate();
        }
        catch(SQLException sqlex) {
            sqlex.printStackTrace();
        }
    }
    private Vector getNextRow(ResultSet rs, ResultSetMetaData rsmd)throws SQLException
    {
        Vector currentRow=new Vector();

        for(int i=1; i <= rsmd.getColumnCount(); ++i)
            switch(rsmd.getColumnType(i)) {
                case Types.VARCHAR:

HAR:
                    currentRow.addElement(rs.getString(i));
                   break;
                case Types.INTEGER:
                    currentRow.addElement( new Long(rs.getLong(i)));
                    break;
                case Types.DATE:
                    currentRow.addElement( new Long(rs.getLong(i)));
                    break;
                case Types.TIME:
                    currentRow.addElement( new Long(rs.getLong(i)));
                    break;  
                 default:
                   System.out.println("Type was:" + rsmd.getColumnTypeName(i));
                     }
               return currentRow;
    }
    public void shutDown()
    {
        try {
            connection.close();
        }
        catch(SQLException sqlex)
        {
            System.err.println("Unable to disconnect");
            sqlex.printStackTrace();
        }
    }
    public static void main(String args[])
    {
        final StudentIssueView app=new StudentIssueView();
        app.addWindowListener(
                new WindowAdapter() {
            @Override
            public void windowClosing(WindowEvent e)

            {
                app.shutDown();
                System.exit(0);

            }
        });
    }

}
View Answers

February 28, 2012 at 11:00 AM

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

public class JTableDatabase {
public static void main(String[] args) {
Vector columnNames = new Vector();
Vector data = new Vector();
JPanel p=new JPanel();
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:access");
String sql = "Select * from data";
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery( sql );
ResultSetMetaData md = rs.getMetaData();
int columns = md.getColumnCount();
for (int i = 1; i <= columns; i++) {
columnNames.addElement( md.getColumnName(i) );
}
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();
}
catch(Exception e){
System.out.println(e);
}
JTable table = new JTable(data, columnNames);
TableColumn col;
for (int i = 0; i < table.getColumnCount(); i++) {
col = table.getColumnModel().getColumn(i);
col.setMaxWidth(250);
}
JScrollPane scrollPane = new JScrollPane( table );
p.add( scrollPane );
JFrame f=new JFrame();
f.add(p);
f.setSize(600,400);
f.setVisible(true);
}
}

Ads









Related Tutorials/Questions & Answers:
How to use JTable with MS-Access
.   Here is an example that retrieves the data from MS Access database...How to use JTable with MS-Access   I have Three Column in Database (MS-Access). 1. Name 2. City 3. Contact I want to Display
How to use JTable with MS-Access
.   Here is an example that retrieves the data from MS Access database...How to use JTable with MS-Access   I have Three Column in Database (MS-Access). 1. Name 2. City 3. Contact I want to Display
Advertisements
How To Display both image and data into Swing JTable which is retrieved from ms access database
How To Display both image and data into Swing JTable which is retrieved from ms access database  So far this is my code how can i display both image and data from database.. while (rs.next()) { Vector row = new Vector(columns
Migrating from mysql to MS Access
Migrating from mysql to MS Access  Hi I am hoping for some help I need to write a conversion program (SQL statements) to import existing data in a MYSQL database to a MS Access database. any suggestions would be appreciated
how to insert values from jsp into ms access
how to insert values from jsp into ms access   how to insert values using jsp into ms access database
ms access
ms access  how to delete the autonumber from ms access using java delete code
to get picture from ms access database by jsp-servlet....
to get picture from ms access database by jsp-servlet....  I have inserted a picture in ms access data base,,,how we can retrieve that picture by using jsp
Ms Access
Ms Access   How to get query for Primary key from MsAccess?   SELECT column_name FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE WHERE table_name = 'data';   SELECT column_name FROM INFORMATION_SCHEMA.KEY_COLUMN
ms access
and password" from my ms access............and detail in register(table in my ms... "username and password" from my ms access............and detail in register(table in my... has to login . i already created ms access page and inserted values throught
ms access
and password" from my ms access............and detail in register(table in my ms... "username and password" from my ms access............and detail in register(table in my... has to login . i already created ms access page and inserted values throught
ms access
and password" from my ms access............and detail in register(table in my ms... "username and password" from my ms access............and detail in register(table in my... has to login . i already created ms access page and inserted values throught
ms access
and password" from my ms access............and detail in register(table in my ms... "username and password" from my ms access............and detail in register(table in my... has to login . i already created ms access page and inserted values throught
Select Employee and display data from access database in a jtable
Select Employee and display data from access database in a jtable  I... a employee's name from a comboBox and the jtable will be filled with all... name of the customer is stored in a access database. Below is how it should
MS access
MS access  how do i access my Ms-Access file placed in the same jar file where my application code/class file r present??? Want to access it via Code. Can anyone help me ? Please give reply urgent...   give me reply
Jdbc MS-Access question
Jdbc MS-Access question  How to delete records from the three table in MS-Access? They are in relationship with each other regarding to data field
Jdbc MS-Access question
Jdbc MS-Access question  How to delete records from the three table in MS-Access? They are in relationship with each other regarding to data field
MS-Access
MS-Access  I am trying to upload a image to ms-acess using jsp,and my problem is that it shows some error int the browser that "java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver]COUNT field incorrect ".I think i set
how to delete specified coloumn from database(MS Access) by using windows application
how to delete specified coloumn from database(MS Access) by using windows application  how to delete specified coloumn from database(MS Access) by using c# windows application
MS ACCESS
MS ACCESS  i have done : Insert form data into MS database...-> data sources. 2)Click Add button and select the driver Microsoft Access... = DriverManager.getConnection("jdbc:odbc:Driver={Microsoft Access Driver (*.mdb
MS ACCESS
MS ACCESS  i have done : Insert form data into MS database...-> data sources. 2)Click Add button and select the driver Microsoft Access... = DriverManager.getConnection("jdbc:odbc:Driver={Microsoft Access Driver (*.mdb
MS ACCESS
MS ACCESS  i have done : Insert form data into MS database Follow...-> data sources. 2)Click Add button and select the driver Microsoft Access... = DriverManager.getConnection("jdbc:odbc:Driver={Microsoft Access Driver (*.mdb, *.accdb
How to Access MS Access in jar.
How to Access MS Access in jar.  how do i access my Ms-Access file... to access it via Code or is their any alter-native?? Do i need any Driver to do this ... i m able to access a Ms-access via JDBC but cant find the file wen
excel to ms access
excel to ms access  hello sir i am developing a application which requires extracting data from excel sheet and place in the ms access database using java programming for example: in excel sheet i have 2 columns and more than
inserting picture in ms access
inserting picture in ms access  hi i am sanatan, how to insert picture in ms access by jsp.   <%@page import="java.sql.*,java.io.*"%> <% try{ InputStream sImage; Class.forName("sun.jdbc.odbc.JdbcOdbcDriver
How to Validate JRadioButton and How to Save data from JRadioButton to MS Access Database - Java Beginners
How to Validate JRadioButton and How to Save data from JRadioButton to MS Access Database  Hello Sir I want Store Corse Type that contains Two JRadioButton I want Store Information from JRadioButton to MS Access Database, and I
how to retreive values from MS Access Database based on the values entered in textbox values in jsp file
how to retreive values from MS Access Database based on the values entered... in MS Access Database. the table structure is Sno JobName ProgramName Problem... Solution field from database and display in the textbox of the jsp.   1
jtable query compare with date
jtable query compare with date  how to transfer daytable data to monthtable when complete a month
how to access the MS ACCESS database with java
how to access the MS ACCESS database with java   how to access the MS ACCESS database with java how can we insert,delete,update,search records of ms access with java   Java MS Access database connectivity Follow
Upload file to MS Access
Upload file to MS Access  Iam beginner and need to upload file to msaccess using jsp . Iam using netbeans platform. Kindly explain do I need to mention Attachment format in the table
jtable query compare with date
jtable query compare with date  how to transfer daytable data... in which i have to display database records in jtable .now I want to transfer particular data which month is over to another jtable. plz sir give me the code
jtable query compare with date
jtable query compare with date  how to transfer daytable data... in which i have to display database records in jtable .now I want to transfer particular data which month is over to another jtable. plz sir give me the code

Ads