Oki. Kan du fortælle mig hvorfor det her ikke virker
import java.awt.*;
import java.applet.*;
import javax.swing.*;
import java.util.*;
import java.sql.*;
import util.*;
public class Frugt1 extends JApplet {
public void init() {
//Execute a job on the event-dispatching thread:
//creating this applet's GUI.
try {
javax.swing.SwingUtilities.invokeAndWait(new Runnable() {
public void run() {
createGUI();
}
});
} catch (Exception e) {
System.err.println("createGUI didn't successfully complete");
}
}
void buildConstraints(GridBagConstraints gbc, int gx, int gy,
int gw, int gh, int wx, int wy) {
gbc.gridx = gx;
gbc.gridy = gy;
gbc.gridwidth = gw;
gbc.gridheight = gh;
gbc.weightx = wx;
gbc.weighty = wy;
}
private void createGUI() {
// Set generelle værdier for panelet
GridBagLayout gridbag = new GridBagLayout();
GridBagConstraints constraints = new GridBagConstraints();
JPanel pane = new JPanel();
pane.setLayout(gridbag);
pane.setBackground(Color.green);
JLabel l;
int i = 1; // Placerer værdier i gridbacklayoutet
System.out.println(i);
// Overskrift
buildConstraints(constraints, 0, 0, 1, 1, 100, 100);
constraints.fill = GridBagConstraints.NONE;
constraints.anchor = GridBagConstraints.WEST;
l = new JLabel(" Navn", JLabel.LEFT);
gridbag.setConstraints(l, constraints);
pane.add(l);
// Overskrift
buildConstraints(constraints, 1, 0, 1, 1, 100, 100);
constraints.fill = GridBagConstraints.HORIZONTAL;
l = new JLabel("Antal");
gridbag.setConstraints(l, constraints);
pane.add(l);
Databaseforbindelsemysqlprepared d = new Databaseforbindelsemysqlprepared("com.mysql.jdbc.Driver", "jdbc:
mysql://192.168.1.15/DATABASE", "USER", "PASSWORD");
Vector vi = new Vector();
// vi.addElement(user);
StringBuffer bu = new StringBuffer();
bu.append("select * from varer");
ResultSet rs = d.select(bu.toString(), vi);
try {
while (rs.next()) {
// Navn
buildConstraints(constraints, 0, i, 1, 1, 100, 100);
constraints.fill = GridBagConstraints.NONE;
constraints.anchor = GridBagConstraints.WEST;
l = new JLabel( rs.getString("navn"), JLabel.LEFT);
gridbag.setConstraints(l, constraints);
pane.add(l);
// Antal på lager
buildConstraints(constraints, 1, i, 1, 1, 100, 100);
constraints.fill = GridBagConstraints.HORIZONTAL;
l = new JLabel(rs.getString("antal"));
gridbag.setConstraints(l, constraints);
pane.add(l);
i++;
}
setContentPane(pane);
} catch (SQLException s) {
// buffer.append("<h3>SQL fejl: " + s.toString() + " "
// + s.getErrorCode() + " " + s.getSQLState() + "</h3>");
}
d.close();
}
}