(Move if this is the wrong forum please)
I must get a small Java client aplication to interact with MySQL through Apache http server by next Thursday. Lets say a "select * from table" and a "delete from table where id = x". I have been using google until confusion and now I am posting here to make sure I am getting it right or not.
From what I have been reading I have to use PHP with the php-soap library (of course I am still not sure what SOAP is but as long as it works...). Learn how to make my Java gui speak http and use soap as well (Is it included with the JDK or will I have to find and download it from somewhere else?)
Something like (ok?/wrong?):
Java client:
sendQuery_btnClick() {
Object = getSoapObject("http://domain/soap_object.php");
Hastable = Object.getDataFromTable("books");
//show data
}
ObjectClass.php
<?php
define class and methods
?>
soap_object.php
<?php
start and return ObjectClass
?>
Are there other ways of getting a Java gui to use Mysql through Apache? (ie. not using php, or soap, etc)
Thank you in advance.