GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

GeekInterview.com  >  Career Advice  >  Projects  >  Java Projects
Go To First  |  Previous Question  |  Next Question 
 Java Projects  |  Question 12 of 17    Print  
hi,

I'm doing a project using jsp, java script, HTML as front end and sql server as backend.

i want to create my database inn runtime. while doing so ,

1. how do i check for an already existing class
2. if there is an already existing class then i need to update the table .

how do i do this. can any one guide through this.

vidhya

  
Total Answers and Comments: 4 Last Update: October 13, 2006     Asked by: vidhya165 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
May 09, 2006 22:26:21   #1  
Gopal        

RE: hi,I'm doing a project using jsp, java...

Hai vidhya,

can you be more specific about the problem. I am not sure which existing class you are looking for? you can create table in the database at run time and also check for the existing table in the database.

regards

Gopal


 
Is this answer useful? Yes | No
May 21, 2006 07:16:47   #2  
Janardhan        

RE: hi,I'm doing a project using jsp, java...
u can easily find the existing tables, and create runtime tables
 
Is this answer useful? Yes | No
May 21, 2006 09:18:15   #3  
vidhya        

RE: hi,I'm doing a project using jsp, java...
s i know it can be done........but how to check it during runtime........i need the exact syntax...can u explain with an example.vidhya
 
Is this answer useful? Yes | No
October 13, 2006 04:17:07   #4  
Raghav        

RE: hi,I'm doing a project using jsp, java...

You can try by giving this condition "Select table_name from all_tables where table_name='YOUR TABLE NAME'    ". If the output of this is null then, it is not existing. If it returns some value, then it exists.

Remember, you can access all_tables table only if you hv permission else you can use user_objects instead of all_tables. You have to specify the tablename that you want to search in CAPS only


 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 




About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape