How i convert integer value into string value in java

Question

String doc = String.valueOf(po.get_Value("DocumentNo"));

I used above code but still it's taking the integer value in the query. Below I mentioned the query where I want the String value.

String sql = "update C_partial SET IsExported = 'Y' where documentno ="+doc;

ehm ... what exactly do you mean? no matter what type doc is at that point (it is a String, btw), through the concatenation, it would become part of a String. So what do you get as result that is not correct? — Stultuske
– Stultuske, Commented Nov 10, 2015 at 12:38
What do you mean with Integer value and String value? do you actually want the query to just end with "...documentno = ' +doc + "'";? — SomeJavaGuy
– SomeJavaGuy, Commented Nov 10, 2015 at 12:38
Please see JDBC PreparedStatement with particular reference to parameter placeholders, and also see SQL Injection. — NickJ
– NickJ, Commented Nov 10, 2015 at 12:41
the data type of document no column is integer, same i executed in sql developer then i have put document no in ' '(Single quote) — Lina
– Lina, Commented Nov 10, 2015 at 12:42

Sleiman Jneidi · Accepted Answer · 2015-11-10 12:39:32Z

4

Use PreparedStatement

String sql = "update C_partial SET IsExported = 'Y' where documentno =?";

PreparedStatement stmt = connection.prepareStatement(sql);
stmt.setString(1, doc);

It is just safer and cleaner

answered Nov 10, 2015 at 12:39

Sleiman Jneidi

23.4k14 gold badges60 silver badges80 bronze badges

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

Comments

Ugur Basak · Accepted Answer · 2015-11-10 12:39:15Z

0

You need to wrap with apostrophe characters

String sql = "update C_partial SET IsExported = 'Y' where documentno = '"+doc+"'";

answered Nov 10, 2015 at 12:39

Ugur Basak

3174 silver badges9 bronze badges

Comments

glethien · Accepted Answer · 2015-11-10 12:39:18Z

0

You can use

String.valueof();

like this and add ' to your query

String sql = "update C_partial SET IsExported = 'Y' where documentno = '"+String.valueOf(doc) +"'";

edited Nov 10, 2015 at 12:39

answered Nov 10, 2015 at 12:37

glethien

2,4712 gold badges30 silver badges39 bronze badges

1 Comment

Stultuske Over a year ago

wouldn't change anything. doc already is a String, he already applied String.valueOf(...), and even if not, the concatenation itself would render it as a part of the String

Collectives™ on Stack Overflow

How i convert integer value into string value in java

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related