Get max value sql in Java

Question

*I don't get value of max in function other. Value return is "0". I trying but not success :( Image

public int PriceMax(int manhom){
        Connection conn = this.connect();
        int max = 0;
        if(conn != null){
            try {
                java.sql.Statement statement = conn.createStatement();
                String sql = "SELECT AVG(GiaSP) from tbsanpham where manhom = '"+manhom+"'";
                ResultSet rs = statement.executeQuery(sql);
                max = rs.getInt(sql);
            } catch (SQLException ex) {
                Logger.getLogger(CSDL.class.getName()).log(Level.SEVERE, null, ex);
            }
        }
        return max;
    }

Help!!!

int manhom = cbbNhomSanPham.getSelectedIndex();
        CSDL csdl = new CSDL();
        int max = csdl.PriceMax(manhom);
        JOptionPane.showMessageDialog(null, "Nhóm sản phẩm: '"+cbbNhomSanPham.getName()+"' \nPrice max: '"+max+"' ");

max = rs.getInt(sql);? Does this code even compile?

Mureinik
– Mureinik

2016-05-28 15:21:05 +00:00
Commented May 28, 2016 at 15:21 — Mureinik
– Mureinik, Commented May 28, 2016 at 15:21
Ok, I try change object

Chung Back
– Chung Back

2016-05-28 15:22:01 +00:00
Commented May 28, 2016 at 15:22 — Chung Back
– Chung Back, Commented May 28, 2016 at 15:22

Yassin Hajaj · Accepted Answer · 2020-11-29 12:03:05Z

6

You're not using it as it should be.

First of all, you use AVG but want MAX so change it to MAX(GiaSP). Second, you must use rs.next() to have your cursor go to the first row and then get information from it.

java.sql.Statement statement = conn.createStatement();
String sql = "SELECT MAX(GiaSP) from tbsanpham where manhom = '"+manhom+"'";
ResultSet rs = statement.executeQuery(sql);
if (rs.next()) {
    max = rs.getInt(1);
}

edited Nov 29, 2020 at 12:03

answered May 28, 2016 at 15:31

Yassin Hajaj

22.1k10 gold badges60 silver badges93 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Chung Back Over a year ago

I have a mistake "avg" with "max" @@

muru · Accepted Answer · 2016-05-28 15:43:39Z

1

ResultSet rs = stmt.executeQuery("select MAX(GiaSP) as maxGiaSP from tbsanpham where manhom = '"+manhom+"'");
if (rs.next())
{
    int w = rs.getInt("maxGiaSP ");

    // just return this int
}

answered May 28, 2016 at 15:43

muru

617 bronze badges

Collectives™ on Stack Overflow

Get max value sql in Java

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related