Java Reference
In-Depth Information
static boolean loadDB()
{
String url = "jdbc:derby:planets;create=false";
try (Connection con = DriverManager.getConnection(url))
{
try (Statement stmt = con.createStatement())
{
ResultSet rs = stmt.executeQuery("select count(*)
from planets");
rs.next();
int size = rs.getInt(1);
names = new String[size];
diameters = new double[size];
masses = new double[size];
distances = new double[size];
iiPhotos = new ImageIcon[size];
rs = stmt.executeQuery("select * from planets");
for (int i = 0; i < size; i++)
{
rs.next();
names[i] = rs.getString(1);
diameters[i] = rs.getDouble(2);
masses[i] = rs.getDouble(3);
distances[i] = rs.getDouble(4);
Blob blob = rs.getBlob(5);
try (ObjectInputStream ois =
new
ObjectIn-
putStream(blob.getBinaryStream()))
{
iiPhotos[i] = (ImageIcon) ois.readObject();
}
catch (ClassNotFoundException|IOException cn-
fioe)
{
System.err.println("unable
to
read
"+names[i]+".jpg");
