Saturday, November 17, 2012

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) {
                   }
      } 

        
        
    }        

No comments:

Post a Comment