public static void main(String[] args) {
         double gndr = 0,gndr1 = 0;
         Date gndr2=null,gndr3= null;
         long period;

       try {
            Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/pharma?zeroDateTimeBehavior=convertToNull", "root", "");
            String query = "SELECT `current weight` FROM `user1` WHERE serial = ((SELECT MAX(`serial`)-1 FROM user1)) ";
            Statement st = conn.createStatement();
            ResultSet rs;
            rs = st.executeQuery(query);
            while (rs.next())
            {
                 gndr = rs.getDouble("current weight");
               // System.out.println(gndr);
            }
            String query1 = "SELECT `trgt` FROM `the whole cases` WHERE `Id`=1 ";
            Statement st1 = conn.createStatement();
            ResultSet rs1;
            rs1 = st1.executeQuery(query1);
            while (rs1.next())
            {
                 gndr1 = rs1.getDouble("trgt");
                //System.out.println(gndr1);
            }

            String query2 = "SELECT `check date`FROM user1 WHERE `serial`=(SELECT MAX(`serial`) FROM user1) ";
            Statement st2 = conn.createStatement();
            ResultSet rs2;
            rs2 = st2.executeQuery(query2);
            while (rs2.next())
            {
                 gndr2 = rs2.getDate("check date");
                //System.out.println(gndr2);
            }

            String query3 = "SELECT `check date`FROM user1 WHERE `serial`=(SELECT MAX(`serial`)-1 FROM user1) ";
            Statement st3 = conn.createStatement();
            ResultSet rs3;
            rs3 = st3.executeQuery(query3);
            while (rs3.next())
            {
                 gndr3 = rs3.getDate("check date");
                //System.out.println(gndr3);
            }
             period=((gndr2.getTime()-gndr3.getTime())/(24*60*60*1000));
             //System.out.println(period);

            double trgtweight= gndr+(period*gndr1/7);
            System.out.println(trgtweight);


       }catch(SQLException ex){
        Logger.getLogger(prof1.class.getName()).log(Level.SEVERE, null, ex);



       }





    }