Hvis du ikke har løst det endnu, er her en hurtig klippe/klistre udgave af din Frugt.class - burde fungere - du må selv fintune.
import java.awt.*;
import java.awt.event.*;
import java.applet.*;
import javax.swing.*;
import java.util.*;
import java.sql.*;
import util.*;
public class Frugt extends JApplet {
public void init() {
createGUI();
int refreshRate = 1000;
javax.swing.Timer timer = new javax.swing.Timer(refreshRate, new ActionListener(){
public void actionPerformed(ActionEvent e){
updateLager();
System.out.println("Timer started");
}
});
timer.start();
}
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;
// 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://web-oasen.dk/DATABASE","","");
Vector vi = new Vector();
// vi.addElement(user);
StringBuffer bu = new StringBuffer();
bu.append("select * from varer");
ResultSet rs = d.select(bu.toString(), vi);
int i = 1; // Placerer værdier i gridbacklayoutet
try {
while (rs.next()) {
// Navn
buildConstraints(constraints, 0, i, 1, 1, 100, 100);
constraints.fill = GridBagConstraints.NONE;
constraints.anchor = GridBagConstraints.WEST;
label[i-1] = new JLabel(rs.getString("navn"), JLabel.LEFT);
gridbag.setConstraints(l, constraints);
pane.add(label[i-1]);
// Antal på lager
buildConstraints(constraints, 1, i, 1, 1, 100, 100);
constraints.fill = GridBagConstraints.HORIZONTAL;
label[i] = new JLabel(rs.getString("antal"));
gridbag.setConstraints(l, constraints);
pane.add(label[i]);
i+=2;
}
setContentPane(pane);
} catch (SQLException s) {
System.out.println("<h3>SQL fejl: " + s.toString() + " "
+ s.getErrorCode() + " " + s.getSQLState() + "</h3>");
}
d.close();
}
private void updateLager() {
Databaseforbindelsemysqlprepared d = new Databaseforbindelsemysqlprepared("com.mysql.jdbc.Driver", "jdbc:
mysql://web-oasen.dk/DATABASE", "BRUGER", "PASSWORD");
Vector vi = new Vector();
// vi.addElement(user);
StringBuffer bu = new StringBuffer();
bu.append("select * from varer");
ResultSet rs = d.select(bu.toString(), vi);
int i = 1;
try {
while (rs.next()) {
// Antal på lager
label[i].setText(rs.getString("antal"));
i += 2;
}
} catch (SQLException s) {
System.out.println("<h3>SQL fejl: " + s.toString() + " "
+ s.getErrorCode() + " " + s.getSQLState() + "</h3>");
}
d.close();
}
private JLabel[] label = new JLabel[8];
}