Why wont Mysql field update? - Java

Question

I am trying to write a function in Java that updates the description and title fields of a Mysql table however when I pass the int variable 'urlid' nothing is added. If I change the urlid variable (at the very end of the query) to another int variable (for example int i = 2) then it works fine. What is it about this urlid that makes things go wrong?

public void updateDescription( String desc, String title, int urlid ) throws SQLException, IOException {
        String cutDesc = desc.substring(0, 99);
            Statement stat = connection.createStatement();
            String query = "UPDATE urls SET description = '"+cutDesc+"', title = '"+title+"' WHERE urlid =" + urlid;
            stat.executeUpdate( query );
            stat.close();
    }

What does transaction mean? Sorry I am fairly new to Mysql and I have never heard that term before? — user3519169
– user3519169, Commented Apr 10, 2014 at 11:16
For the benefit of anyone who might post an answer without knowing all the background - stackoverflow.com/questions/22982527/… — Dawood ibn Kareem
– Dawood ibn Kareem, Commented Apr 10, 2014 at 11:16

Community · Accepted Answer · 2017-05-23 12:27:13Z

0

i guess you miss the quotes ,

"UPDATE urls SET description = '"+cutDesc+"', title = '"+title+"' WHERE urlid ='"+ urlid+"'";

Hope this helps !!

Note: use prepared statements to avoid sql injection . see here

edited May 23, 2017 at 12:27

CommunityBot

11 silver badge

answered Apr 10, 2014 at 11:17

Santhosh

8,2355 gold badges32 silver badges56 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Ceiling Gecko Over a year ago

Your current quotes do exactly nothing to the java String object, I think you forgot to add the single quotes ' around urlid

jmail · Accepted Answer · 2014-04-10 11:43:44Z

0

I guess you can try with WHERE urlid ='"+ urlid+"'"; at the end.

for your reference http://dev.mysql.com/doc/refman/5.7/en/type-conversion.html

edited Apr 10, 2014 at 11:43

jmail

6,1503 gold badges23 silver badges35 bronze badges

answered Apr 10, 2014 at 11:34

Krish0912

11 bronze badge

3 Comments

user3519169 Over a year ago

Still nothing is being inserted into the title or description columns

Krish0912 Over a year ago

what values are you passing into the method updateDescription( String desc, String title, int urlid ) ?? if you are passing correct values in correct format it should definitely work. kindly check the values you are providing to the method. you can always use a System.out.println(); to check the values.

Krish0912 Over a year ago

you can also call this method this way updateDescription("abc", "def", 1)

Collectives™ on Stack Overflow

Why wont Mysql field update? - Java

2 Answers 2

1 Comment

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related