Ja pesquisei sobre isso nesse forum e ja utilizei de todas as dicas que colocaram mas nenhuma me ajudou.
try {
Class.forName(Driver);
Connection conn = DriverManager.getConnection(Local,Usuario,Senha);
String query = "SELECT Sum(Saldo) as maior FROM advo where ID_Clientes ='"+txt_Codigo1.getText()+"' and Retirado= 'Sim'";
ResultSet rs;
PreparedStatement pst = conn.prepareStatement(query);
rs = pst.executeQuery();
if(rs.next()==true)
{
so = Double.valueOf(rs.getString("maior"));
}
else
so=merda;
pst.close();
conn.close();
} catch (SQLException ex) {
JOptionPane.showMessageDialog(null, "ERRO DE SQL: "+ex);
} catch (ClassNotFoundException e) {
JOptionPane.showMessageDialog(null, "ERRO DE DRIVER: "+e);
}
}
run:
Exception in thread “AWT-EventQueue-0” java.lang.NullPointerException at sun.misc.FloatingDecimal.readJavaFormatString(FloatingDecimal.java:1838) at sun.misc.FloatingDecimal.parseDouble(FloatingDecimal.java:110) at java.lang.Double.parseDouble(Double.java:538) at java.lang.Double.valueOf(Double.java:502) at Formularios.Clientes.segundo(Clientes.java:353) at Formularios.Clientes.jTable1MouseClicked(Clientes.java:400) at Formularios.Clientes.access$300(Clientes.java:24) at Formularios.Clientes$5.mouse