performing queries on web application

HI!

I am working on a web applicaiton project by using struts and I need find out for solutions to perform all types of queries even though all users are not familiar with sql statements at all. (They used to retrieve all types of data  by using excel file and MS SQL Server somehow and it doesn’t work anymore for some reasons.) Since I am using different tools, I need to find a way of integrating this functionality to new project. The problem is that the all users do not know sql statement and still want to perform many different types of queries (relatively complex) and export data to excel files.

I appreciate any comments or information.

Thanks,
dkim18Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

TimYatesCommented:
why not have a way of storing queries...  so that you can enter the most used queries, and people can select them from a list?

Have you been round everyone and got a list of the queries they like to do?  You will probably find a core of about 10 or so that everyone does...and you can store these for people to do...
0
dkim18Author Commented:
TimYates,

thanks for your comment.
the thing is all users will perform all different types of queries(it can be more than a few hundreds..), so it won't work that way.
0
CodingExpertsCommented:
What i would then suggest is to have a form based web page and take the input from the user and build the query yourself once the form is submitted.
-CE
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

dkim18Author Commented:
CodingExperts,

thanks for your comment.
Since there will be so many different types of queries(relatively complex ones as well), do you think it is good idea? Or maybe i am not fully understanding?? I was thinking that similiar solution and i was wondering web form will be easy for users who do not know anything about sql statement....
0
CodingExpertsCommented:
Yeah, of course u have ti design the form in such a manner that this works. May be if you can post ur problem we can suggest a good design for your form. This approach hides the complexity from the user, making it all the more user friendly. Moreover you an apply Interpreter Design Pattern if the Queries are all that complex.
0
dkim18Author Commented:
So far, I found out there will be only “select” sql statement, but one query may involve with more than one tables. Since I am using Struts, should I go with javascripts to implement this feature? Or can I use an Applet and java?(I am more familiar with Applet and Swing.) which tools do you think will be better?
(this will be a my last question…)
0
CodingExpertsCommented:
I would recommend using javascript.

-CE
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
JSP

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.