EGJ-Soldier
Mitglied
hallo zusammen, habe ein Problem, meine Datenbank richtig zu schreiben
Mein code:
Das Problem liegt in diesen Zeilen:
Das Programm stürtzt schon bei der ersten if-Anweisung ab. In der Datenbank steht an dieser stelle nicht.
Hoffe mir kann jmd. weiterhelfen
Gruß
EGJ-Soldier
Mein code:
Code:
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.Calendar;
public class GUIMAsk extends JFrame{
JLabel l_stunde, l_montag, l_dienstag, l_mittwoch, l_donnerstag, l_freitag, l_info;
JTextArea t_stunde, t_montag, t_dienstag, t_mittwoch, t_donnerstag, t_freitag;
JButton b_SP, b_SPA;
class MeinWindowLauscher extends WindowAdapter{
public void windowClosing(WindowEvent e){
System.exit(0);
}
}
class Lauscher implements ActionListener{
public void actionPerformed(ActionEvent e){
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:Stundenplan");
String strSql = "SELECT * FROM Tabelle1";
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery (strSql);
t_stunde.setText("");
t_montag.setText("");
t_dienstag.setText("");
t_mittwoch.setText("");
t_donnerstag.setText("");
t_freitag.setText("");
while(rs.next()){
Calendar cal = Calendar.getInstance();
int tag = cal.get(Calendar.DAY_OF_WEEK);
String montag = rs.getString("Montag");
String dienstag = rs.getString("Dienstag");
String mittwoch = rs.getString("Mittwoch");
String donnerstag = rs.getString("Donnerstag");
String freitag = rs.getString("Freitag");
t_stunde.append(rs.getString("Zeit") + "\n");
/**/
if(montag.equals("null")){
t_montag.append("" + "\n");
}
else{
if(tag == 2){
t_montag.append(montag + "\n");
l_montag.setBackground(Color.RED);
}
else
t_montag.append(montag + "\n");
}
/**/
if(dienstag.compareTo("") != 0){
if(tag == 3){
t_dienstag.append(dienstag + "\n");
l_dienstag.setBackground(Color.RED);
}
else
t_dienstag.append(dienstag + "\n");
}
else
t_dienstag.append("");
/**/
if(mittwoch.compareTo("") != 0){
if(tag == 4){
t_mittwoch.append(mittwoch + "\n");
l_mittwoch.setBackground(Color.RED);
}
else
t_mittwoch.append(mittwoch + "\n");
}
else
t_mittwoch.append("");
/**/
if(donnerstag.compareTo("") != 0){
if(tag == 5){
t_donnerstag.append(donnerstag + "\n");
l_donnerstag.setBackground(Color.RED);
}
else
t_donnerstag.append(donnerstag + "\n");
}
else
t_donnerstag.append("");
/**/
if(freitag.compareTo("") != 0){
if(tag == 6){
t_freitag.append(freitag + "\n");
l_freitag.setBackground(Color.RED);
}
else
t_freitag.append(freitag + "\n");
}
else
t_freitag.append("");
if(tag == 7){
l_info.setText("Heute ist Samstag");
l_info.setBackground(Color.RED);
}
if(tag == 1){
l_info.setText("Heute ist Sontag");
l_info.setBackground(Color.RED);
}
}
}
catch(Exception ex){
System.out.println(ex.getMessage());
}
}
}
class Lauscher1 implements ActionListener{
public void actionPerformed(ActionEvent ae){
password p = new password("Passwort");
p.setVisible(true);
p.setSize(200, 200);
}
}
GUIMAsk(String titel){
super(titel);
l_stunde = new JLabel("Stunde");
l_stunde.setSize(40, 50);
l_stunde.setLocation(50, 5);
t_stunde = new JTextArea();
t_stunde.setSize(130,200);
t_stunde.setLocation(5, 50);
l_montag = new JLabel("Montag");
l_montag.setSize(60, 50);
l_montag.setLocation(192, 5);
t_montag = new JTextArea();
t_montag.setSize(130, 200);
t_montag.setLocation(140, 50);
l_dienstag = new JLabel("Dienstag");
l_dienstag.setSize(60, 50);
l_dienstag.setLocation(319, 5);
t_dienstag = new JTextArea();
t_dienstag.setSize(130, 200);
t_dienstag.setLocation(275, 50);
l_mittwoch = new JLabel("Mittwoch");
l_mittwoch.setSize(60, 50);
l_mittwoch.setLocation(453, 5);
t_mittwoch = new JTextArea();
t_mittwoch.setSize(130, 200);
t_mittwoch.setLocation(410, 50);
l_donnerstag = new JLabel("Donnerstag");
l_donnerstag.setSize(90, 50);
l_donnerstag.setLocation(582, 5);
t_donnerstag = new JTextArea();
t_donnerstag.setSize(130, 200);
t_donnerstag.setLocation(545, 50);
l_freitag = new JLabel("Freitag");
l_freitag.setSize(60, 50);
l_freitag.setLocation(725, 5);
t_freitag = new JTextArea();
t_freitag.setSize(130,200);
t_freitag.setLocation(680, 50);
l_info = new JLabel();
l_info.setSize(120, 25);
l_info.setLocation(830, 210);
b_SP = new JButton("Lade Stundenplan!");
b_SP.setSize(120, 25);
b_SP.setLocation(820, 133);
b_SPA = new JButton("Stindenplan Ändern");;
b_SPA.setSize(120, 25);
b_SPA.setLocation(820, 180);
setLayout(null);
add(l_stunde);
add(l_montag);
add(l_dienstag);
add(l_mittwoch);
add(l_donnerstag);
add(l_freitag);
add(t_stunde);
add(t_montag);
add(t_dienstag);
add(t_mittwoch);
add(t_donnerstag);
add(t_freitag);
add(l_info);
add(b_SP);
add(b_SPA);
b_SP.addActionListener(new Lauscher());
b_SPA.addActionListener(new Lauscher1());
addWindowListener(new MeinWindowLauscher());
}
public static void main(String[] args){
GUIMAsk fenster = new GUIMAsk("Stundenplan");
fenster.pack();
fenster.setSize(1030, 350);
fenster.show();
}
}
Das Problem liegt in diesen Zeilen:
Code:
t_stunde.setText("");
t_montag.setText("");
t_dienstag.setText("");
t_mittwoch.setText("");
t_donnerstag.setText("");
t_freitag.setText("");
while(rs.next()){
Calendar cal = Calendar.getInstance();
int tag = cal.get(Calendar.DAY_OF_WEEK);
String montag = rs.getString("Montag");
String dienstag = rs.getString("Dienstag");
String mittwoch = rs.getString("Mittwoch");
String donnerstag = rs.getString("Donnerstag");
String freitag = rs.getString("Freitag");
t_stunde.append(rs.getString("Zeit") + "\n");
/**/
if(montag.equals("null")){
t_montag.append("" + "\n");
}
else{
if(tag == 2){
t_montag.append(montag + "\n");
l_montag.setBackground(Color.RED);
}
else
t_montag.append(montag + "\n");
}
/**/
if(dienstag.compareTo("") != 0){
if(tag == 3){
t_dienstag.append(dienstag + "\n");
l_dienstag.setBackground(Color.RED);
}
else
t_dienstag.append(dienstag + "\n");
}
else
t_dienstag.append("");
/**/
if(mittwoch.compareTo("") != 0){
if(tag == 4){
t_mittwoch.append(mittwoch + "\n");
l_mittwoch.setBackground(Color.RED);
}
else
t_mittwoch.append(mittwoch + "\n");
}
else
t_mittwoch.append("");
/**/
if(donnerstag.compareTo("") != 0){
if(tag == 5){
t_donnerstag.append(donnerstag + "\n");
l_donnerstag.setBackground(Color.RED);
}
else
t_donnerstag.append(donnerstag + "\n");
}
else
t_donnerstag.append("");
/**/
if(freitag.compareTo("") != 0){
if(tag == 6){
t_freitag.append(freitag + "\n");
l_freitag.setBackground(Color.RED);
}
else
t_freitag.append(freitag + "\n");
}
else
t_freitag.append("");
if(tag == 7){
l_info.setText("Heute ist Samstag");
l_info.setBackground(Color.RED);
}
if(tag == 1){
l_info.setText("Heute ist Sontag");
l_info.setBackground(Color.RED);
}
}
}
Das Programm stürtzt schon bei der ersten if-Anweisung ab. In der Datenbank steht an dieser stelle nicht.
Hoffe mir kann jmd. weiterhelfen
Gruß
EGJ-Soldier