";
$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], "
";
}
echo "Point 2
";
}
echo "
", 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);
}
}