[rjuyal]

Hi there,
I am having lods of tables in db.

In a file called ‘databasequery.java’ we have defined static variables to hold queries [ select/delete/insert ].



So it is like, if we want to get the query :-

Code:

Databasequery.yourtablename_select_query;

Databasequery.yourtablename_insert_statement;

Databasequery.yourtablename_update_statement;

Databasequery.yourtablename_anyother_statement;

As there are lods of tables this file is going to be very huge.



What I wanted is, there should be some mechanism to achieve this:-

Code:

DatabaseQuery.YourTableName.SELECT_QUERY;

DatabaseQuery.YourTableName.INSERT_QUERY;

also we should be able to access the "YourTableName" only via DatabaseQuery, we should not be able to write like

Code:

YourTableName.SELECT_QUERY

YourTableName.INSERT_QUERY

Please guide me..