JDBC connectivity with MS Access DB

[iamharish15]

I am working on a project in which I need to store the information about the users into a Database and based on the querry I need to take the results from the databse and display the results retreived from database in a frame. But I could not put the retrieved information from the database into the frame and display it.
I am using J2SE JDK 1.6 and Netbeans 6.9.1 and MS Access(MS Office 2010 EE).
So please suggest the code or any other solution to it.

[asingh]

I used to do it using AODB. But it supports JDBC too.

Use Microsoft Access with Java - JavaWorld
MS Access JDBC Driver -- Connecting MS Access with Java

[iamharish15]

this is not the problem i had. I had successfully connected with the access db using jdbc-odbc bridge but i am having trouble retrieving results from that database and display it on the frame or any output device.
for example the project i am working on requires me to take some specific tuples from the DB based on input criteria by the user(viz. firstname) and put it on a frame and displaying it.
Below is a code snippet i am having trouble with:

private void PhoneDisplayActionPerformed(java.awt.event.ActionE vent evt) {
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbcdbccm"); //pcm is the dsn
PreparedStatement st = con.prepareStatement("select firstname,lastname,email1,city,state,country,mobil e1,home from ContactsInfo"
+ "where firstname=?%");
st.setString(1,jComboBox7.getSelectedItem().toStri ng());
JOptionPane.showMessageDialog(PhoneDisplay,"Retrie ving Results....");
ResultSet rs = st.executeQuery();
int c = rs.getMetaData().getColumnCount();
rs.last();
int r = rs.getRow();
Object[][] data = new Object[r][c];


rs.first();
for(int i=0;i<r;i++)
{
data[i][0] = rs.getInt(1);
data[i][1] = rs.getString(2);
data[i][2] = rs.getString(3);
data[i][3] = rs.getString(4);
data[i][4] = rs.getString(5);
data[i][5] = rs.getString(6);
data[i][6] = rs.getString(7);
data[i][7] = rs.getString(8);
rs.next();
}

Object[] col = {"First Name","Last Name","Email1","City","State","Country","Mobile"," Home No."};
JTable t = new JTable(data,col);
QuerryFrame qf = new QuerryFrame();
qf.add(t);
qf.setSize(500, 600);
qf.setVisible(true);
con.setAutoCommit(true);
con.close();

}
catch (ClassNotFoundException ex) {
//Logger.getLogger(SearchPhone.class.getName()).log( Level.SEVERE, null, ex);
}
catch(SQLException se)
{
//JOptionPane.showMessageDialog(PhoneDisplay,"SQL Exception");
}

[iamharish15]

When I compiled the above code, it showed no errors but shows a run time exception.

Exception in thread "AWT-EventQueue-0" java.lang.NullPointerException
at sun.jdbc.odbc.JdbcOdbcPreparedStatement.clearParam eter(JdbcOdbcPreparedStatement.java:1023)
at sun.jdbc.odbc.JdbcOdbcPreparedStatement.setChar(Jd bcOdbcPreparedStatement.java:3057)
at sun.jdbc.odbc.JdbcOdbcPreparedStatement.setString( JdbcOdbcPreparedStatement.java:766)
at personalcontactmanagement.SearchPhone.PhoneDisplay ActionPerformed(SearchPhone.java:187)
at personalcontactmanagement.SearchPhone.access$100(S earchPhone.java:22)
at personalcontactmanagement.SearchPhone$2.actionPerf ormed(SearchPhone.java:71)
at javax.swing.AbstractButton.fireActionPerformed(Abs tractButton.java:1995)
at javax.swing.AbstractButton$Handler.actionPerformed (AbstractButton.java:2318)
at javax.swing.DefaultButtonModel.fireActionPerformed (DefaultButtonModel.java:387)
at javax.swing.DefaultButtonModel.setPressed(DefaultB uttonModel.java:242)
at javax.swing.plaf.basic.BasicButtonListener.mouseRe leased(BasicButtonListener.java:236)
at java.awt.AWTEventMulticaster.mouseReleased(AWTEven tMulticaster.java:272)
at java.awt.Component.processMouseEvent(Component.jav a:6041)
at javax.swing.JComponent.processMouseEvent(JComponen t.java:3265)
at java.awt.Component.processEvent(Component.java:580 6)
at java.awt.Container.processEvent(Container.java:205 8)
at java.awt.Component.dispatchEventImpl(Component.jav a:4413)
at java.awt.Container.dispatchEventImpl(Container.jav a:2116)
at java.awt.Component.dispatchEvent(Component.java:42 43)
at java.awt.LightweightDispatcher.retargetMouseEvent( Container.java:4322)
at java.awt.LightweightDispatcher.processMouseEvent(C ontainer.java:3986)
at java.awt.LightweightDispatcher.dispatchEvent(Conta iner.java:3916)
at java.awt.Container.dispatchEventImpl(Container.jav a:2102)
at java.awt.Window.dispatchEventImpl(Window.java:2440 )
at java.awt.Component.dispatchEvent(Component.java:42 43)
at java.awt.EventQueue.dispatchEvent(EventQueue.java: 599)
at java.awt.EventDispatchThread.pumpOneEventForFilter s(EventDispatchThread.java:273)
at java.awt.EventDispatchThread.pumpEventsForFilter(E ventDispatchThread.java:183)
at java.awt.EventDispatchThread.pumpEventsForHierarch y(EventDispatchThread.java:173)
at java.awt.EventDispatchThread.pumpEvents(EventDispa tchThread.java:168)
at java.awt.EventDispatchThread.pumpEvents(EventDispa tchThread.java:160)
at java.awt.EventDispatchThread.run(EventDispatchThre ad.java:121)

When I run the static SQL select command through Statement object, it runs perfectly but when I try to take the parameter at runtime through PreparedStatement object, it shows the above exception.
Please suggest some solution for the above exception.

[furious_gamer]

Did you checked the value "jComboBox7.getSelectedItem().toStri ng()" by printing it?

[iamharish15]

yes I have tried that it is working correctly.
static SQL commands are running good but the dynamic SQL commands with PreparedStatement object is having the trouble...