String To = to.getText();
String Cc = cc.getText();
String Bcc = bcc.getText();
String Sub  = sub.getText();
String Msg = text.getText();
if(To.equals("") || Sub.equals("") || Msg.equals(""))
{
 JOptionPane.showMessageDialog(null, "Please Fill All Appropiate Details");
}
else
{
 try {

     Class.forName("com.mysql.jdbc.Driver");
     Connection con = DriverManager.getConnection( "jdbc:mysql://localhost:3306/email management system","root", "ok" );
     Statement stmt = con.createStatement();
     ResultSet rs = stmt.executeQuery("select first,email,mail,name from login,curlogin;");
     String from =rs.getString("mail");
         String frmname =rs.getString("name");
     String recipent = "";
     String rname = "";
     Boolean tof;
     loop1: while(rs.next())
     {
         recipent = rs.getString("email");
          rname = rs.getString("first");
        if(recipent.equals(To))
          {
              tof = true;
              break loop1;

         }
          else
          {
              tof= false;
          }
     }
    if(tof=true)
    {
        stmt.executeUpdate("Insert into inbox Values('"+frmname+"','"+Sub+"','"+Msg+"',curDate(), curTime(),'"+rname+"','"+from+"');");
                new inbox().setVisible(true);
        this.dispose();
    }
    else
    {
        JOptionPane.showMessageDialog(null,"Sorry the 'To' Email you entered does not exist.");
    }
     ResultSet rs1 = stmt.executeQuery("select first,email,mail,name from login,curlogin;");
    Boolean taf = false;
    Boolean entered = false;
   loop2: while(rs1.next())
     {
         recipent = rs1.getString("email");
          rname = rs1.getString("first");
       if(Cc.equals(""))
               {

               }
       else
       {
           entered= true;
          if(recipent.equals(Cc))
          {
              taf = true;
              break loop2;

         }
          else
          {
              taf= false;
          }
       }
     }
   if(entered=true)
   {
    if(taf=true)
    {
        stmt.executeUpdate("Insert into inbox Values('"+frmname+"','"+Sub+"','"+Msg+"',curDate(), curTime(),'"+rname+"','"+from+"');");
                new inbox().setVisible(true);
        this.dispose();
    }
    else
    {
        JOptionPane.showMessageDialog(null,"Sorry the 'CC' Email you entered does not exist.");
    }
   }
    ResultSet rs2 = stmt.executeQuery("select first,email,mail,name from login,curlogin;");
    Boolean fot=false;
    Boolean entered2 =false;
    loop3: while(rs2.next())
     {
         recipent = rs2.getString("email");
          rname = rs2.getString("first");
       if(Bcc.equals(""))
       {

       }
       else
       {


          if(recipent.equals(Bcc))
          {
              fot = true;
              break loop3;

         }
          else
          {
              fot= false;
          }
       }
     }
   if(entered2=true)
   {
    if(fot=true)
    {
        stmt.executeUpdate("Insert into inbox Values('"+frmname+"','"+Sub+"','"+Msg+"',curDate(), curTime(),'"+rname+"','"+from+"');");
        new inbox().setVisible(true);
        this.dispose();
    }
    else
    {
        JOptionPane.showMessageDialog(null,"Sorry the 'CC' Email you entered does not exist.");
    }

   }

 }