client: desktop Java app, server: Apache with php/mysql
I am new to Java, and I want to develop a desktop app that downloads data from a remote Mysql database. Direct connection to the DB is forbidden by the server administrators, and php is in the middle of Java and Mysql.
I have experience in Ajax, with xmlhttp and so on, and I wonder if the same technology is used here?
The Java application teaches a language, say English, and it must download new words from the server with "their pronunciation" in the form of wave files (*.wav).
I don't imagine how I can call a php function from Java desktop application :(
Could you please explain it, or direct me to a tutorial about it, or suggest a different technology which does this job better/easier? Could you tell me the main components you consider for such a set up?