String Vs StringBuffer

kalees · #1 (**permalink**) 04-11-2009, 10:46 AM

Hi!

I am working in web application project,
I have a doubt,when should use String and String Buffer, I know the concept String in immutable and StringBuffer is muttable,So every time i am assign the value into the String its taking separate memory,....

My doubt is I have a executeQuerymanager Class,...So when i want to execute the query so i jst put the query in String and call the executeQuerymanager Class,So in my Class if i want to execute two the String So i am Using Same String variable and Calling the Class,.....

So shall i make it StringBuffer instead of String?.....

Hope u underStand my doubt,...

eg:

Java Code

String query = "";
ResultSet rs = null;

query = "select * from XXX";

rs = executeQueryManager(query);

query = "select * from YYY";

rs = = executeQueryManager(query);

Hope U understand my example....

Thanks,

kalees

Json · #2 (**permalink**) 04-11-2009, 11:34 AM

Usually you'd have a number of static queries I believe, so if I was you I'd create some static variables holding the constants for your queries.

Java Code

private static final String SELECT_ALL_USERS = "select username,password,email from userstable";

And then you just pass that into your queryManager.

// Json

kalees · #3 (**permalink**) 04-11-2009, 12:28 PM

Thanks,

But i am having different querys in my action class,each time i calling queryManager,i am jst passing the query,....

eg :

Java Code

                        query ="select userName,userPass from userTable";
                          rs = queryManager(query);
                        query = "select price from priceTable;
                         rs = queryManager(query);

Some time May have a 4 more also,So in this kind of situation what to use String or StringBuffer?.....

Json · #4 (**permalink**) 05-11-2009, 07:25 AM

I meant you should have a list of queries.

Java Code

private static final String QUERY1 = "select username,password,email from userstable";
private static final String QUERY2 = "select * from someothertable";
private static final String QUERY3 = "select * from userstable WHERE username=?";

And just add all your queries like this. How does your queryManager actually call these?

// Json

kalees · #5 (**permalink**) 06-11-2009, 04:59 AM

Yes!

I am doing web application banking project,in struts frame work,
in my action class i am getting query result from different tables,so my QueryManager will return
the query result set,So my doubt is,

Java Code

                     private static final String QUERY1 = "select username,password,email from userstable";
                     private static final String QUERY2 = "select * from someothertable";
                     private static final String QUERY3 = "select * from userstable WHERE username=?";

if i create the query with different string,
will it be create more object then it takes more memory right?
So if i use StringBuffer then it will use the same memory right?.....

What is the benefit of creating different string obj for different query?.....

Json · #6 (**permalink**) 06-11-2009, 07:27 AM

When you declare all your queries as statics they will of course take up memory like that but you will have a reference to the same strings so it will be dead quick.

When you use the StringBuffer you will create a lot of strings anyways and they all get stored into the string pool anyways so in effect they will take up memory.

Using a stringbuilder or even stringbuffer which is slower will take more time in the long end. In my opinion there's no reason to use a StringBuilder if you know that the strings will be the exactly same every time.

Otherwise you can create a properties file in your web-inf/classes folder called databaseQueries.properties and load that into memory and just get the query you need from it.

The amount of memory taken up by your queries will be nothing compared to the objects you will be putting on the session anyways I believe.

// Json

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
error cannot find symbol-constructor Person(java.lang.String,java.lang.String,Date)	ss7	What's Wrong With My Code?	2	03-11-2009 10:28 AM