Retrieve Data From mySQL

[Johnny Shiro]

I wonder how to retrieve data from a MySQL database, which then is displayed in Flash .

[BarryAllen]

Johhny,

Flash cannot talk to a DB directly you need some sort of middleware (ASP, XML, PHP, etc.)

Flash will post the query to php, which is where all the data is processed,then inturn it will get the data from your db and return it to field/s in flash.

Have a look at the post AS / PHP / SQL

Kindest

[Johnny Shiro]

Yeah i know that. And i need to use JSP (Java Server Pages)

for communication to the database.

Can you explain me how a .jsp would look to retrieve certain data from a mysql database ?

[Tommy]

Ok you need the Java MySQL ODBC drivers, then you need to use the classes and interfaces in package java.sql to set up a connection and execute a statement.

There is a lot more coding overhead involved in JSP pages over PHP and Perl.

[Johnny Shiro]

Ok.... i have no clue whatsoever on how to even start and figuring out that Tommy . Any tutorials ?

[Tommy]

www.jguru.com and java.sun.com are good places to start. You should find tutes on Java, JSP and JDBC there.