i have a DAO and i am retrieving values in select query how to print it in database in mysql

Question

I have a select query where i am retrieving column values like

select city,state,country from abc

and then fetching it using result set

city=rs.getString(1),state=rs.getString(2)

and so on

Now have to print like I live in city in state in country in java

can i give this way like

String a="I live in %city% in %state% in %country%"

will it work using %% symbol

niiraj874u · Answer 1 · 2014-04-22T07:01:01.520

0

No, % wont work in java.. You have to concat strings..and our +(plus) operator do that job in java

String a="I live in "+city+" in "+state+" in "+country;

edited Apr 22 '14 at 07:01

answered Apr 22 '14 at 06:13

niiraj874u

score 0 · Accepted Answer · answered Apr 22 '14 at 06:14

0

you will have to use string concatenating operator + as below:

String a="I live in" +city+ "in" +state+ "in" +country;

answered Apr 22 '14 at 06:14

Rahul

user3145373 ツ · Answer 3 · 2014-04-22T06:24:47.513

0

String a = "I live in " + city + " which is in " + state + " and in " + country + " Country";

Look at this tutorial for further details.

edited Apr 22 '14 at 06:24

answered Apr 22 '14 at 06:16

user3145373 ツ

@user13763 because %% syntax is used in like operator in MYSQL not in JAVA – TruePS Apr 22 '14 at 06:19
In string literals if you want to add some data in between then you ll have to use `+` to concate the string. and as per @TruePS %% is used to match any part /place of word in MySql or Postgresql with `like` or `ilike`. If you want to use it then you will have to use `String.format`. – user3145373 ツ Apr 22 '14 at 06:20
@user13763 : see this link http://stackoverflow.com/questions/3695230/how-to-use-java-string-format – user3145373 ツ Apr 22 '14 at 06:22

3 Answers3