Results 1 to 9 of 9
  1. #1
    Shreyas_cool is offline Member
    Join Date
    Mar 2012
    Posts
    4
    Rep Power
    0

    Default JDBC connection to connect access database by button click

    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!

  2. #2
    doWhile is offline Moderator
    Join Date
    Jul 2010
    Location
    California
    Posts
    1,641
    Rep Power
    7

    Default Re: JDBC connection to connect access database by button click

    Quote Originally Posted by Shreyas_cool View Post
    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...

  3. #3
    Shreyas_cool is offline Member
    Join Date
    Mar 2012
    Posts
    4
    Rep Power
    0

    Default Re: JDBC connection to connect access database by button click

    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) {

    }


    }

  4. #4
    doWhile is offline Moderator
    Join Date
    Jul 2010
    Location
    California
    Posts
    1,641
    Rep Power
    7

    Default Re: JDBC connection to connect access database by button click

    a) That is not an SSCCE....
    b)
    ...
    Java Code:
    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()

  5. #5
    DarrylBurke's Avatar
    DarrylBurke is offline Forum Police
    Join Date
    Sep 2008
    Location
    Madgaon, Goa, India
    Posts
    11,458
    Rep Power
    20

    Default Re: JDBC connection to connect access database by button click

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

    db

    edit
    Java Code:
    private void jButton1ActionPerformed(java.awt.event.ActionEvent evt)
    Dump the visual designer/code generator. It's not a beginner's tool.
    If you're forever cleaning cobwebs, it's time to get rid of the spiders.

  6. #6
    Shreyas_cool is offline Member
    Join Date
    Mar 2012
    Posts
    4
    Rep Power
    0

    Default Re: JDBC connection to connect access database by button click

    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)

  7. #7
    Tolls is offline Moderator
    Join Date
    Apr 2009
    Posts
    12,224
    Rep Power
    20

    Default Re: JDBC connection to connect access database by button click

    Do you have a valid Access database whose DSN is 'Hospital'?
    Please do not ask for code as refusal often offends.

    ** This space for rent **

  8. #8
    Shreyas_cool is offline Member
    Join Date
    Mar 2012
    Posts
    4
    Rep Power
    0

    Default Re: JDBC connection to connect access database by button click

    Yes..

  9. #9
    Tolls is offline Moderator
    Join Date
    Apr 2009
    Posts
    12,224
    Rep Power
    20

    Default Re: JDBC connection to connect access database by button click

    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.
    Please do not ask for code as refusal often offends.

    ** This space for rent **

Similar Threads

  1. How to connect to any database without any JDBC driver?
    By sandeep43 in forum Advanced Java
    Replies: 10
    Last Post: 05-20-2011, 12:06 PM
  2. Replies: 0
    Last Post: 02-16-2011, 02:30 PM
  3. how to connect to database using jdbc in servelets
    By sureshmca08 in forum Java Servlet
    Replies: 2
    Last Post: 05-28-2010, 10:06 AM
  4. connect JDBC to offline database
    By nancyhung in forum JDBC
    Replies: 1
    Last Post: 04-12-2008, 12:04 AM
  5. Using JDBC to connect to ORACLE database
    By Java Tip in forum Java Tip
    Replies: 0
    Last Post: 02-10-2008, 12:27 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •