i'm making a web service, program is working fine except one query.the red code piece is working after "else" statement worked but it is not working after "if" or "else if" is worked. how can i fix this problemConnection conn = DriverManager.getConnection(url, username, password); Statement stat = conn.createStatement(); Statement stat2 = conn.createStatement(); Statement stat3 = conn.createStatement(); ResultSet rs = stat.executeQuery("SELECT borcmiktari FROM fatura_bilgileri WHERE faturaid=" + faturaidd); while (rs.next()) { borc = rs.getDouble("borcmiktari"); } if (borc == odenenmiktarr) { stat2.executeQuery("UPDATE fatura_bilgileri SET odenenmiktar=" + odenenmiktarr + ", durum ='Odenmis' WHERE faturaid=" + faturaidd); } else if (borc > odenenmiktarr) { stat2.executeQuery("UPDATE fatura_bilgileri SET odenenmiktar=" + odenenmiktarr + ", durum ='Borclu' WHERE faturaid=" + faturaidd); } else { str = "Hata Olustu"; } ResultSet rs2 = stat3.executeQuery("SELECT durum FROM fatura_bilgileri WHERE faturaid=" + faturaidd); while (rs2.next()) { strDrm = rs2.getString("durum"); }http://ahmetemremermer.com
SQL Query Is Not Working
Posted - 2011-07-01 : 08:23:25
