Problememit Datenbank

EGJ-Soldier

Mitglied
hallo zusammen, habe ein Problem, meine Datenbank richtig zu schreiben

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
 
Warum stürzt es ab? NullPointer?

Dann solltest du noch auf null abfragen:

Code:
if(montag != null && montag.equals("null"))
 
Zurück