- Code: Alles auswählen
import java.sql.*;
import java.awt.*;
import java.awt.event.*;
public class VorZurueck extends Frame {
Panel knoepfe = new Panel(new GridLayout(1,4));
Button erst = new Button("Erste Zeile"),
prev = new Button("Voherige Zeile"),
next = new Button("Nächste Zeile"),
last = new Button("Letzte Zeile");
TextField aus = new TextField();
Connection c; Statement s; ResultSet r;
public VorZurueck() {
setLayout(new BorderLayout());
add(knoepfe, "North");
knoepfe.add(erst); knoepfe.add(prev); knoepfe.add(next); knoepfe.add(last);
add(aus,"Center");
setSize(400, 250);
setVisible(true);
erst.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
erster();
}});
prev.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
vorheriger();
}});
next.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
naechster();
}});
last.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
letzter();
}});
addWindowListener(new WindowAdapter() {
public void windowClosing(WindowEvent e) {
System.exit(0);
}
});
try {
Class.forName("org.postgresql.Driver");
// c = DriverManager.getConnection("jdbc :p ostgresql://localhost","postgres", "werner80");
c = DriverManager.getConnection( "jdbc :p ostgresql://localhost/jahb", "postgres", "werner80" );
s = c.createStatement();
r=s.executeQuery("SELECT * FROM jahb.\"alle berufe\"");
erster();
}
catch (Exception ex) { ex.printStackTrace();}
}
void erster() {
try {
r.first(); zeige();
}
catch (Exception ex) {}
}
void vorheriger() {
try {
r.previous(); zeige();
}
catch (Exception ex) {}
}
void naechster() {
try {
r.next(); zeige();
}
catch (Exception ex) {}
}
void letzter() {
try {
r.last(); zeige();
}
catch (Exception ex) {}
}
void zeige() throws Exception {
aus.setText(r.getString("Berufsbez"));
}
public static void main(String[] argv) {
new VorZurueck();
}
}
gruß niesel
