<?php
  // error_reporting (E_ALL);
  // @ini_set ("display_errors", "on");
 
  echo "Point 1 <br>";
  $conn = mysql_connect ("localhost", "uzivatel", "heslo");
  if ($conn)
  {
     mysql_select_db ("test");
 
     $cmd = "create table colors
             (name varchar (80) primary key not null,
              red int,
              green int,
              blue int);
            ";
     mysql_query ($cmd);
 
     $cmd = "insert into colors values ('modra', 0, 0, 255);";
     mysql_query ($cmd);
 
     $cmd = "insert into colors values ('cervena', 255, 0, 0);";
     mysql_query ($cmd);
 
     $cmd = "select * from colors;";
     $result = mysql_query ($cmd);
 
     while ($data = mysql_fetch_array ($result))
     {
        echo $data[0], " ",
             $data['red'], " ",
             $data[2], " ",
             $data[3], "<br>";
     }
 
     echo "Point 2 <br>";
  }
  echo "<br>", mysql_error ();
?>

    import java.sql.*;
 
    private void info (String s)
    {
        jTextArea1.append (s + "\n");
    }
 
    private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {                                         
        info ("starting ....");
        try 
        {
            Class.forName ("org.apache.derby.jdbc.ClientDriver");
            info ("driver loaded ....");
        } 
        catch (ClassNotFoundException ex) 
        {
            info (""+ex);
        }
 
        try 
        {
            // import java.sql.*;
            Connection con = DriverManager.getConnection ("jdbc:derby://localhost:1527/sample", "app", "app");
            info ("connection ready ....");
 
            Statement stmt = con.createStatement();
 
            ResultSet rs = stmt.executeQuery
                          ("SELECT * FROM App.Customer");
 
            while (rs.next()) 
            {
               String s = rs.getString("Name");
               String t = rs.getString ("City");
               info (s + "," + t);
            }
 
        } 
        catch (SQLException ex) 
        {
            info (""+ex);
        }
    }