Best language for the job?

Matt, go for Java. use Struts with any backend ;)

http://java.sun.com/products/jsp/docs.html
http://www.devx.com/upload/registered/features/javapro/2000/04apr00/ww0004/ww0004.asp
http://developer.java.sun.com/developer/technicalArticles/Programming/jsp/
http://www.visualbuilder.com/jsp/tutorial/default.asp
http://www.apl.jhu.edu/~hall/java/Servlet-Tutorial/


etc ..

Just like to add that i wanted a program to edit the db, so itll b a exe they run to edit the db

For database programming VB (or .NET) is better than C.

ok thanks, and is this good to use to execute sql queries? to edit the mysql db and then display in php?

I don't have DB Java experience, but I guess Java has relatively high level database access libraries, like VB. C and Java may be a good choice if you need to write platform-independent programs.

MFC would be best language to use with DB.  

C++ is one of the best languages but also ne of the hardest but i would recomend either MFC or C++.

My suggestion: 100% Java (since you already know some of it)

If you don't know about Spring (www.springframework.org) now is the time to look at it. It covers all things that you are looking for - easy db integration, UI, configuration, documentation, forums, ... It has steep lurning curve, but all this stuff mentioned really helps and once you master it, there's no limit to what you can do :-).

All things below are already integrated with Spring:

- db integration (db independent - only jdbc driver limitations):
  - simple sql mapping: iBatis (www.ibatis.com)
  - more advanced ORM tool: Hibernate (www.hibernate.org)

- user interface:
  - most widely spread: Struts (struts.apache.org/)
  - easy usage: WebWork (www.opensymphony.com/webwork)
  - component oriented: Tapestry (jakarta.apache.org/tapestry)
  - integrated: Spring MVC (www.springframework.org/docs/reference/mvc.html)

I work mostly in C++, but I have done a lot of work with Java, C, .NET (both VB and C#). I have spent many years working with COM, ATL and MFC. You should be careful when asking a question like this. People tend to answer by shouting out there favorite language. In truth different languages have advantages and disadvantages. When working with a DB all of the mentioned languages will do the job and so I think you should look at the other needs of your application.

These are some of the things I would consider.

-Is this a client side or server side app?
If running in a server environment it is typically preferable to use a managed language like Java or one of the .NET languages. This provides you with nice exception handling, garbage collection, etc. On a server this is invaluable.

If you are building a client side app, then you should think about download size. Languages like Java and .NET require users to download and install large runtimes. In the case of .NET I think the runtime is larger then 15MB. Also, in a client app the managed environment is not so important.


-What type of data is in the DB and what will you be doing with it?
If the data is text and numbers then any of the languages should do. On the other hand if the DB contains some kind of graphical data that requires lots of processing, then I would suggest using a language like C or C++.

-Does your app need to run on multiple platforms?
If it does, I would stay away from .NET, COM, ATL and MFC.

-Do you need to work with any other components?
.NET and C++ do a very good job of communicating with older components, while it is a real pain with Java.

How do you plan on deploying this app?
If you have no idea what is on the user system, then hands down a simple C or C++ is the simplest. Once you start introducing COM things become complicated. If you know your users have the .NET runtime, then .NET is very very very easy to deploy.


Hope this helps

hello there

can anyone help me to find a copy of CA-XCOM User Guide or Manual for MVS.

cheers
:)
Avi

where can i install this programs?thanks.

Install j2sdk1.4.2_02

JCreator LE 2.5 or higher

Rational Rose 98 Enterprise Edition

There have been some suggestions on using Java. UNless you are a fotune 500 company, I would stay away from it. The problem with Java is the cost of ownership is higher. Java requires more powerful hardware as well as a higher payroll to build upon it and maintain it. Java is an Enterprise application and that is why alot of banks and etc use it. However if you dont have a deep pocket for development costs, you will find it hard to meet your tight budgets. Java programers charge much more than PHP developers because there are far less Java programmers and they are more in demand.

PHP/mySQL is my suggestion. But if you require win32 API access, I would suggest C++ so you can work within one primary language to accomplish all of your tasks.