Sum of one column values from sql database using java?

Asked Jul 01 '17 at 18:54

Active Jul 01 '17 at 18:54

Viewed 27 times

The code seems to show no errors yet when I run it, my ide shows a lang.nullpointerexception. I have no idea what is wrong or how to fix this problem. Thank you so much for taking the time to help me. Much appreciated.

String sql="Select cast(Sum(Copper) as varchar(255)) as sumcu from RawMaterials";
st=conn.prepareStatement(sql);
rs=st.executeQuery();
if(rs.next()){
String sum = rs.getString("sumcu");
sum_text.setText(sum);

asked Jul 01 '17 at 18:54

Siddharth Gupta

Why do you want the sum as a string? That seems . . . unusual. – Gordon Linoff Jul 01 '17 at 18:54
to display it in a text field – Siddharth Gupta Jul 01 '17 at 18:55
1

Unrelated, but: why do you retrieve a number as a String. That doesn't make sense – Jul 01 '17 at 21:53
@a_horse_with_no_name... bevause how else do I display it in a text field? – Siddharth Gupta Jul 02 '17 at 05:06

Sum of one column values from sql database using java?

0 Answers0