How to stop the Jframe execution?

[Beata Szabo-Takacs]

I have a Java program which has only one main which will launch the other JFrames with set.visible() command.
This program connects to MySQL database for inserting images. The inserting process is via GUI (JFrame) where the time of the image has to be typed in a JTextField.  I would like to avoid duplication in the database.
The data contain Time data and I would like to check if the given Time still exists on the table. If the Time still exists I would like to stop the data inserting and dispose of the JFrame. I tried the following code but it does not stop the process:

 

TIME = jTextField1.getText().trim();


Connection con =  MeteoRead.getConnection(); 
  PreparedStatement posted = con.prepareStatement(sql, Statement.RETURN_GENERATED_KEYS);
   PreparedStatement statement1= con.prepareStatement("SELECT count(*) FROM " + Table );
    ResultSet rc = statement1.executeQuery();
    // checking if the table is empty or contains data
                    while(rc.next()){
                     count = rc.getInt("count(*)");
                    }
// if the table is not empty add the TIME values to a string array list
    if(count > 0){
          PreparedStatement statement2= con.prepareStatement("SELECT TIME FROM " + Table + " ORDER BY TIME");
            ResultSet dtim = statement2.executeQuery();
                       while(dtim.next()){
                            TTest.add(dtim.getString("TIME"));
                             }
// check if the typed Time is still exist on the table
                   String test;
                        for(int j=0; j<TTest.size(); j++){
                                test = compareDates(TIME, TTest.get(j));
                                    if(!test.isEmpty()){
                                         okW = test;
                                         okWindow o = new okWindow();
                                         o.okWindow(okW);
                                         o.setVisible(true);
                                          dispose();
                                 }
                            }

                    }

public static String compareDates(String d1,String d2)
    {
        String Text ="";
        try{
            
            SimpleDateFormat sdf = new SimpleDateFormat("yyyy.MM.dd HH:mm:ss");
            Date date1 = sdf.parse(d1);
            Date date2 = sdf.parse(d2);
            

            //equals() returns true if both the dates are equal
            if(date1.equals(date2)){
                Text = "Date1 is equal Date2";
            }
            else{Text = "";} 
        }
        catch(Exception ex){
            ex.printStackTrace();
        }
        return Text;
    }  

             
This part of the Jframe is inside a jButtonActionPerformed which will insert the image to the table. Can someone suggest me a solution to stop the action and dispose the JFrame if the condition is true?
I would appreciate any help!

[Campbell Ritchie]

Beata Szabo-Takacs wrote:. . . launch the other JFrames with set.visible() command.

Why would yoiu want multiple frames? There are several better ways for multiple displays including desktop panes and dialogue windows.

This program connects to MySQL database for inserting images. The inserting process is via GUI . . .

I am afraid that doesn't sound like good design. Create an app that inserts images (or as people have discussed in the last week, references to images) without a GUI. The GUI is not your app, but simply an interface between the app and the user. Get the insertion working without a GUI fist.

. . .[code=java:firsline[28]]                                          dispose();[/code]. . .

What does that line do? What are you calling dispose() on? I can foresee threading problems because you still have to execute all that code on the event dispatch thread.

[Beata Szabo-Takacs]

Meantime, I found a solution. I applied a boolean an I used the return function. Here is the code of JButton.ActionPerformed:

String sql = " INSERT INTO" + " " + Table + " (IMAGE, TIME) VALUES(?,?)" ;
        File fr = null;
        FileInputStream fin = null;
        
        
        boolean bl = true;
             try{
              fr = new File(FILENAME);
              fin = new FileInputStream(fr);
              int len = (int) fr.length(); 
        

                Connection con =  Conn.getConnection();
             // check if the table is empty
                PreparedStatement statement1= con.prepareStatement("SELECT count(*) FROM " + Table );
                        
                ResultSet rc = statement1.executeQuery();
                    while(rc.next()){
                     count = rc.getInt("count(*)");
                    }
// check if the TIME still exists
                    if(count > 0){
                        PreparedStatement statement2= con.prepareStatement("SELECT TIME_ID FROM " + Table + " ORDER BY TIME");
                        ResultSet dtim = statement2.executeQuery();
                             while(dtim.next()){
                            TTest.add(dtim.getString("TIME"));
                             }
                         String test ="";
                             for(int j=0; j<TTest.size(); j++){
                                test += compareDates(TIME, TTest.get(j));}
                                 
                                    if(!test.isEmpty()){
                                         okW = test;
                                         okWindow o = new okWindow();
                                         o.okWindow(okW);
                                         o.setVisible(true);
                                         bl = false;
                                         return;   
                                 }
                                    else{
                                    PreparedStatement posted = con.prepareStatement(sql, Statement.RETURN_GENERATED_KEYS);
                                        posted.setBinaryStream(1, fin, len);
                                        posted.setString(2, TIME);
                                        posted.execute();
                                    ResultSet rs2 = posted.getGeneratedKeys();
                                    
                                    }    
                            

                    }
     //if the table is empty               
else{
                        PreparedStatement posted = con.prepareStatement(sql, Statement.RETURN_GENERATED_KEYS);
                         posted.setBinaryStream(1, fin, len);
                         posted.setString(2, TIME);
                          posted.execute();
                ResultSet rs2 = posted.getGeneratedKeys();
                    }
              } catch (Exception ex) {
                  bl = false;
                  
            Logger.getLogger(NewJFrame_Meteo.class.getName()).log(Level.SEVERE, null, ex);
            String m = ex.getMessage();
             
              okW = m;
                 okWindow o = new okWindow();
                 o.okWindow(okW);
                 o.setVisible(true);
           
        }
     
      
        finally{
            try{
               
                if(fin != null)
                    fin.close();
                if(bl == true){
                    okW = "DATA INSERTED SUCCESSFULLY";
                 okWindow o = new okWindow();
                 o.okWindow(okW);
                 o.setVisible(true);  
                 this.dispose();
                }
                }catch(IOException ex){
                  
                ex.printStackTrace();

            } 
          }
    }