try { String t= (String)client.getSelectedItem(); //client = JCombobox String query1="select total(Amount) from enquiry where `client`= ?"; PreparedStatement p=conn.prepareStatement(query1); p.setString(1,tfsum.getText()); //tfsum = textfield whr sum will displays ResultSet r=p.executeQuery(); if(r.next()) { String s=r.getString("total(Amount)"); tfsum.setText(s); } r.close(); p.close(); } catch(Exception d) { d.printStackTrace(); } }
String query1="select total(Amount) As TotalAmt from enquiry where `client`= ?";
String s=r.getString("TotalAmt)");
sum(Amount)
total(Amount)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)