Code used in video "Java prog#36.How to find maximum,minimum,average values from a table in mysql/sqlite in netbeans"

Here I am providing the downloadable code link of  the Java code I have used in the video

 "Java prog#36.How to find maximum,minimum,average values from a table in mysql/sqlite in netbeans"  of my YouTube channel ProgrammingKnowledge

Click Link to watch the video LINK

This code below is for the OKActionPerformed  method action perform

private void OKActionPerformed(java.awt.event.ActionEvent evt) {                                         

        

        try{

            String sql="select min(pressure),max(pressure),avg(pressure) from Userinfo";

            pst=conn.prepareStatement(sql);

            rs =pst.executeQuery();

            String add1=rs.getString("min(pressure)");

            min_pr.setText(add1);

            String add2=rs.getString("max(pressure)");

            max_pr.setText(add2);

            String add3=rs.getString("avg(pressure)");

            avg_pr.setText(add3);

            

    }catch(Exception e)

    {

           JOptionPane.showMessageDialog(null, e);

    }finally {

try{

  rs.close();

      pst.close();

    // conn.close();

  }

  catch(Exception e) {

                   }

      } 

        

        

    }        

Browse More Articles

Tweet

Written by Unknown

We are one of the initiators of the development of information technology in understanding the need for a solution that is familiar and close to us.