Insert string inside another string from one index to another index in between the string

Question

I have a SQL select query already written in java. Now i want to select few more columns. In that case i need to write column names before the index of from keyword. Like this Initial query-

StringBuffer query;
query = " Select name,age,dob from employee"

New query should be like this-

query = "select name , age , dob,city from employee"

For this i tried query= query.insert(indexof(dob),"city");

But i think this will overwrite from. My question comes down to whether insert creates enough space to insert the string or it overwrites the earlier string? Please help.

What are you trying to do here? Do you want to insert query results into stringbuffer or query strings? Are you referring to storing some prepared statements? — bonCodigo
– bonCodigo, Commented Dec 2, 2012 at 10:58
@Abhishekkumar that is a bad idea. You should really use prepared statements and a library to build them for you. Read all about SQL injection to understand why it is hard to write good code with non-prepared, non-sanitized queries. — tucuxi
– tucuxi, Commented Dec 2, 2012 at 11:11
Also note that StringBuilder is preferred to StringBuffer (it is more efficient in the common case of not having multiple threads access it) — tucuxi
– tucuxi, Commented Dec 2, 2012 at 11:13

Ravindra Bagale · Accepted Answer · 2012-12-02 12:39:20Z

2

instead of getting index value of dob, get index value of from

query= query.insert(original.indexOf("from"),"city ");

edited Dec 2, 2012 at 12:39

answered Dec 2, 2012 at 10:58

Ravindra Bagale

17.7k9 gold badges46 silver badges70 bronze badges

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

2 Comments

Abhishek kumar Over a year ago

Wont this insert city after from?

tucuxi Over a year ago

No - indexOf returns the index of the start of the string it searches for

tucuxi · Accepted Answer · 2012-12-02 11:13:05Z

1

Try this:-

 StringBuffer query = new StringBuffer("Select name,age,dob from employee");
 query.insert(query.indexOf("from"), "city ");

edited Dec 2, 2012 at 11:13

tucuxi

18k2 gold badges48 silver badges80 bronze badges

answered Dec 2, 2012 at 10:57

Rahul Tripathi

173k33 gold badges292 silver badges341 bronze badges

Collectives™ on Stack Overflow

Insert string inside another string from one index to another index in between the string

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related