/*
* showinfo.java
*
* Created on 30. April 2006, 22:34
*/
/**
*
* @author dödelup
*/
package datenbank;
import javax.swing.*;
import java.sql.*;
public class showinfo extends javax.swing.JFrame
{
//Datenbank
Connection verbindung=null;
Statement befehl=null;
ResultSet ergebnis=null;
/** Creates new form showinfo */
public showinfo()
{
initComponents();
JLabel ausgabe = new JLabel("Anzahl der Objekte\tAnzahl der Bezeichnungen\n");
ausgabe.setVisible(true);
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
verbindung = DriverManager.getConnection("jdbc:odbc:db2", "", "");
befehl = verbindung.createStatement();
String str="SELECT COUNT(*) FROM Daten WHERE Kategorie='Planeten'";
ergebnis = befehl.executeQuery(str);
while (ergebnis.next())
{
ausgabe.setText(ausgabe.getText() + "Planeten\t" + ergebnis.getString(1).toString() + "\n");
System.out.println(ergebnis.getString(1).toString());
}
}
catch (Exception e)
{
System.out.println("Fehler showinfo 1: " + e.toString());
}
try
{
befehl.close();
verbindung.close();
}
catch (Exception e)
{
System.out.println("Fehler showinfo 2: " + e.toString());
}
}
/** This method is called from within the constructor to
* initialize the form.
* WARNING: Do NOT modify this code. The content of this method is
* always regenerated by the Form Editor.
*/
// <editor-fold defaultstate="collapsed" desc=" Generated Code ">
private void initComponents() {
setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
setTitle("Datenbank Information");
setResizable(false);
java.awt.Dimension screenSize = java.awt.Toolkit.getDefaultToolkit().getScreenSize();
setBounds((screenSize.width-400)/2, (screenSize.height-300)/2, 400, 300);
}
// </editor-fold>
/**
* @param args the command line arguments
*/
public static void main(String args[])
{
java.awt.EventQueue.invokeLater(new Runnable()
{
public void run()
{
new showinfo().setVisible(true);
}
});
}
// Variables declaration - do not modify
// End of variables declaration
}
