mysql & JDBC - results returned to the command line

This app will return data from a mysql server running on the Z or any mysql server on your network and return the results to the command line on your Z.

What you will need -

    mysql server - download and install onto a system on your computer

Downloads -

    SQLQuery.java - source

    SQLQuery.class - class files

    mm.mysql-2.0.4-bin.jar - jdbc driver (required)          

How to run the app -

Download mysql server onto your Z and run the installer.

Open Terminal and type mysqlstart

This will start the mysql server.  We are going to use a default database on this server for our example.

On the Z , create a folder called java in the /home/QtPalmtop folder.

/home/QtPalmtop/java

        On your pc Download mm.mysql-2.0.4-bin.jar..

        Unzip this file onto your pc.

        This will create a folder called org.   This folder contains several folder and files.

           

        Copy the org folder, its subfolders and files over to the Z into the java directory.

        You will now have a folder structure like this. (The mysql folder on the end contains two more folders and all the files for the jdbc driver)


            /home/QtPalmtop/java/org

You will now have a folder structure on your Z like the screen print below. (The mysql folder on the end contains two more folders and all the files for the jdbc driver)

/home/QtPalmtop/java/org/gjt/mm/mysql

Next, download the SQLQuery.class file to your pc.

Now copy this file into the java folder on your Z.

On the Z open a Terminal window and change into the /home/QtPalmtop/java and run the following line from the Terminal window.

evm SQLQuery


Below is the output. (it's is a listing of the User values in the user table of the mysql database)

    Output -