1,105,395 Community Members

java + database

Member Avatar
TIM_M_91
Junior Poster in Training
92 posts since Feb 2012
Reputation Points: -3 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

Hi there guys can someone explain to me how I can increment a value within a field in my database each time I execute my query?. As I cannot seem to find a way to do this. Below is my structure for reading + writting to my database if you need it to help me with my problem.

Also the code below updates my selected column but each time sets my playcount back to '1'. I wish to each time add 1 to the existing value. For instance if the value was already 1 when the query is executed the value becomes 2.


Any help would be appreciated

Code below:

String v = videoNo.getText();
            
             String writeString =
                     "UPDATE VIDEOS SET PLAYCOUNT = '1' WHERE VIDEOID = '"+ v + "'";
            try {
                myStatement.executeUpdate(writeString);
            } catch (SQLException sqle) {
               
            }
Member Avatar
hfx642
Posting Pro
515 posts since Nov 2009
Reputation Points: 164 [?]
Q&As Helped to Solve: 105 [?]
Skill Endorsements: 1 [?]
 
0
 

Well... If it is an Oracle database,
You could have a BEFORE UPDATE trigger in the database.

Member Avatar
JamesCherrill
... trying to help
10,367 posts since Apr 2008
Reputation Points: 2,081 [?]
Q&As Helped to Solve: 1,750 [?]
Skill Endorsements: 47 [?]
Moderator
Featured
 
0
 

Have you tried the obvious
SET PLAYCOUNT = PLAYCOUNT + 1
... seems to work in ordinary SQL

Member Avatar
TIM_M_91
Junior Poster in Training
92 posts since Feb 2012
Reputation Points: -3 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

Have you tried the obvious
SET PLAYCOUNT = PLAYCOUNT + 1
... seems to work in ordinary SQL

Solved it but thanks for reply code I used was:

int c = sta.executeUpdate("UPDATE VIDEOS SET PLAYCOUNT = PLAYCOUNT + 1 WHERE VIDEOID = '"+ v + "'");
Question Answered as of 2 Years Ago by JamesCherrill and hfx642
You
This question has already been solved: Start a new discussion instead
Post:
Start New Discussion
View similar articles that have also been tagged: