JDBC connection to connect access database by button click

[Shreyas_cool]

Hello Everyone! I need some help with JAVA swing. I am making an application using the jdbc. My access database is connected to my JAVA program but if i want the database to be displayed in my jTable on a button click then the button action simply doesn't work. There aren't any compilation errors. Please help!

[doWhile]

on a button click then the button action simply doesn't work. There aren't any compilation errors. Please help!

With the amount of information you've provided, saying it doesn't work is as useful as us saying 'then fix it'. Did you register an ActionListener for the Button? Post an SSCCE...

[Shreyas_cool]

Here is the source code:

private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
Connection con;
Statement st;
ResultSet rs;



DefaultTableModel model = (DefaultTableModel)jTable1.getModel();
String url = "jdbc:odbc:Hospital";

try

{
String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
Class.forName(driver);

String hosp = "jdbc:odbc:Hospital";
con = DriverManager.getConnection(hosp);
st = con.createStatement();
String sql = "select * from HOSPITAL";
rs = st.executeQuery(sql);

while (rs.next())

{


String patientid = rs.getString("PATIENTID");
String patientname = rs.getString("PATIENT NAME");
String gender = rs.getString("GENDER");
String doctorid = rs.getString("DOCTORID");
String dctorname = rs.getString("DOCTOR NAME");
String roomno = rs.getString("ROOM_NO");
String disease = rs.getString("DISEASE");




}
st.close();
con.close();






}

catch (Exception ex) {

}

}

[doWhile]

a) That is not an SSCCE....
b)
...

catch (Exception ex) {

}

...NEVER let exceptions fall through like that. Do something with the exception so you know it was thrown. For instance, e.printStackTrace()

[DarrylBurke]

And use code tags, not color tags for posting code.

db

edit

private void jButton1ActionPerformed(java.awt.event.ActionEvent evt)

Dump the visual designer/code generator. It's not a beginner's tool.

[Shreyas_cool]

after writing e.printStackTrace() in the catch block i got a whole lot of errors.
Here's the list:

java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Cannot open database '(unknown)'. It may not be a database that your application recognizes, or the file may be corrupt.
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc .java:6956)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java :7113)
at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(JdbcOdbc.j ava:3072)
at sun.jdbc.odbc.JdbcOdbcConnection.initialize(JdbcOd bcConnection.java:323)
at sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDrive r.java:174)
at java.sql.DriverManager.getConnection(DriverManager .java:579)
at java.sql.DriverManager.getConnection(DriverManager .java:243)
at my.hospital.hospitalUI.connect(hospitalUI.java:344 )
at my.hospital.hospitalUI.jButton7ActionPerformed(hos pitalUI.java:472)
at my.hospital.hospitalUI.access$500(hospitalUI.java: 24)
at my.hospital.hospitalUI$6.actionPerformed(hospitalU I.java:232)
at javax.swing.AbstractButton.fireActionPerformed(Abs tractButton.java:2018)
at javax.swing.AbstractButton$Handler.actionPerformed (AbstractButton.java:2341)
at javax.swing.DefaultButtonModel.fireActionPerformed (DefaultButtonModel.java:402)
at javax.swing.DefaultButtonModel.setPressed(DefaultB uttonModel.java:259)
at javax.swing.plaf.basic.BasicButtonListener.mouseRe leased(BasicButtonListener.java:252)
at java.awt.Component.processMouseEvent(Component.jav a:6504)
at javax.swing.JComponent.processMouseEvent(JComponen t.java:3321)
at java.awt.Component.processEvent(Component.java:626 9)
at java.awt.Container.processEvent(Container.java:222 9)
at java.awt.Component.dispatchEventImpl(Component.jav a:4860)
at java.awt.Container.dispatchEventImpl(Container.jav a:2287)
at java.awt.Component.dispatchEvent(Component.java:46 86)
at java.awt.LightweightDispatcher.retargetMouseEvent( Container.java:4832)
at java.awt.LightweightDispatcher.processMouseEvent(C ontainer.java:4492)
at java.awt.LightweightDispatcher.dispatchEvent(Conta iner.java:4422)
at java.awt.Container.dispatchEventImpl(Container.jav a:2273)
at java.awt.Window.dispatchEventImpl(Window.java:2713 )
at java.awt.Component.dispatchEvent(Component.java:46 86)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.j ava:707)
at java.awt.EventQueue.access$000(EventQueue.java:101 )
at java.awt.EventQueue$3.run(EventQueue.java:666)
at java.awt.EventQueue$3.run(EventQueue.java:664)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPri vilege(ProtectionDomain.java:76)
at java.security.ProtectionDomain$1.doIntersectionPri vilege(ProtectionDomain.java:87)
at java.awt.EventQueue$4.run(EventQueue.java:680)
at java.awt.EventQueue$4.run(EventQueue.java:678)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPri vilege(ProtectionDomain.java:76)
at java.awt.EventQueue.dispatchEvent(EventQueue.java: 677)
at java.awt.EventDispatchThread.pumpOneEventForFilter s(EventDispatchThread.java:211)
at java.awt.EventDispatchThread.pumpEventsForFilter(E ventDispatchThread.java:128)
at java.awt.EventDispatchThread.pumpEventsForHierarch y(EventDispatchThread.java:117)
at java.awt.EventDispatchThread.pumpEvents(EventDispa tchThread.java:113)
at java.awt.EventDispatchThread.pumpEvents(EventDispa tchThread.java:105)
at java.awt.EventDispatchThread.run(EventDispatchThre ad.java:90)

[Tolls]

Do you have a valid Access database whose DSN is 'Hospital'?

[Shreyas_cool]

Yes..

[Tolls]

Well, ODBC doesn't seem to like it.
I'd have a look at Microsofts site and see if there's anything regarding your version of Access against ODBC against your version of Windows.