Database Update statement

Question

TIM_M_91 -3 Junior Poster in Training

12 Years Ago

Hi guys well I have successfully got my update query to work correctly. Now I have two tables in my database. What I want to do is when I click my play button not only does it update my column's in my first table but all updates my colunms in my second table if the values from my first table exist in my second table. So my question is what would I need to change or add to the following code:

if (e.getSource() == PLAY) {
          
      
             String p = PLAYLIST.getText();
             
               Connection con = null;
    try {
      con = DriverManager.getConnection(
        "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=VIDEODB1.mdb;");
      Statement sta = con.createStatement(); 
      int c = sta.executeUpdate("UPDATE " + p + " SET PLAYCOUNT = PLAYCOUNT + 1");
int d = sta.executeUpdate("UPDATE TABLE2 SET PLAYCOUNT = PLAYCOUNT + 1");
      sta.close();
      con.close();        
    } catch (Exception I) {
      System.err.println("Exception: "+I.getMessage());
    }

java microsoft-access sql

2 Contributors
3 Replies
186 Views
3 Days Discussion Span
Latest Post 12 Years Ago Latest Post by TIM_M_91

dantinkakkar 19 Junior Poster

12 Years Ago

I recommend that you check out your SQL statement once, and get sure of it's correctness. Also, how are you checking whether/not the fields have been updated? That'll help me in solving your problem better! :)

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

TIM_M_91 -3 Junior Poster in Training · Answer 1 · 2012-02-29T03:38:15+00:00

Can someone tell me why this code produces no errors but does not update my fields:

try {
      con = DriverManager.getConnection(
        "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=VIDEODB1.mdb;");
      Statement sta = con.createStatement(); 
      int c = sta.executeUpdate("UPDATE VIDEOS INNER JOIN PLAYLIST ON VIDEOS.PLAYCOUNT = PLAYLIST.PLAYCOUNT SET VIDEOS.PLAYCOUNT = PLAYLIST.PLAYCOUNT");
      
  
      
      
      

      sta.close();
      con.close();        
    } catch (Exception I) {
      System.err.println("Exception: "+I.getMessage());
    }

What I want this code to do is get information from the colunm PLAYCOUNT in PLAYLIST and produce it in VIDEOS to the correct video through its VIDEOID. At the moment no video is being affected.

Any help?

TIM_M_91 -3 Junior Poster in Training · Answer 2 · 2012-03-02T03:33:37+00:00

I recommend that you check out your SQL statement once, and get sure of it's correctness. Also, how are you checking whether/not the fields have been updated? That'll help me in solving your problem better! :)

I have two table called VIDEOS and PLAYLIST in VIDEOS the colunms are ID,NAME,DIRECTOR, and PLAYCOUNT. In PLAYLIST colunms are ID,VIDEONAME, and PLAYCOUNT. When I execute the query above nothing occurs in either tables