public  void targetweight() {

         Connection conn;
        try {
            conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/pharma?zeroDateTimeBehavior=convertToNull", "root", "");
            String q = " SELECT(SELECT `current weight` FROM `user1` WHERE serial = ((SELECT MAX(`serial`)-1 FROM user1)))+\n" +
"((SELECT `trgt` FROM `the whole cases` WHERE `Id`=1)*\n" +
".1428* \n" +
"((SELECT `check date`FROM user1 WHERE `serial`=(SELECT MAX(`serial`) FROM user1))-((SELECT `check date`FROM user1 WHERE `serial`=(SELECT MAX(`serial`)-1 FROM user1))))) AS target";
            Statement St = conn.createStatement();
            ResultSet Rs;
            Rs = St.executeQuery(q);
            while (Rs.next())
      {
             int checktrgt= (int) Rs.getInt(q);
             String checktarget= Double.toString(checktrgt);
             jTextField1.setText(checktarget);
          }
        } catch (SQLException ex) {
            Logger.getLogger(prof1.class.getName()).log(Level.SEVERE, null, ex);
        }




    }