sql queries, java string

Question

developing a web application using java. I have SQL queries with more than 40 lines ,using " , "+ at staring an end of query respectively. it is very difficult to convert string as query when i want to do any modifications in both both conversions

it is very difficult to convert string as query when i want to do any modifications This is true. And sad. 40 lines of SQL all written by hand... Feel my condolence... But what is your question? — ppeterka
– ppeterka, Commented Jan 21, 2013 at 10:35

Shoreki · Accepted Answer · 2013-01-21 10:38:26Z

3

Can't you use PreparedStatement? If possible, use an ORM tool like hibernate. That will simplify your code (Of course there are other benefits).

answered Jan 21, 2013 at 10:38

Shoreki

1,0974 gold badges15 silver badges34 bronze badges

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

1 Comment

raja Over a year ago

i am handling already developed project, so now i cant move to struct

Anugoonj · Accepted Answer · 2013-01-21 11:10:15Z

1

If your facing trouble in maintaing the sql query then you could try moving to spring JDBC templace where you can store the query in a config/props file with placeholders/bind variables. This significantly reduces the errorneous part of constructing a string query.

answered Jan 21, 2013 at 11:10

Anugoonj

5733 silver badges9 bronze badges

Comments

Himanshu Dave · Accepted Answer · 2017-02-06 10:28:04Z

0

You can simply generalise your queries by creating this kind of methods. Example:

private String DBFormatter="'";

public String FormatSQl(String value)
{
      return DBFormatter + value + DBFormatter;

}

answered Feb 6, 2017 at 10:28

Himanshu Dave

1191 silver badge9 bronze badges

Collectives™ on Stack Overflow

sql queries, java string

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related